Siva Kanagaraj has over 18 years of experience in information technology, including data modeling, ETL architecture, data warehousing, business intelligence, and data integration projects. He has extensive experience working with Fortune 500 companies in retail, banking, and telecommunications. Some of his key roles and responsibilities included designing conceptual, logical, and physical data models; defining ETL architectures and data mapping; managing software delivery from vendors; and developing enterprise data warehousing and master data management programs. He is proficient in various technologies such as IBM Infosphere, Oracle, SQL, Java, and mainframe applications.
David Colbourn is an experienced information architect seeking a senior role. He has over 25 years of experience in areas such as software analysis, design, data modeling, project management, and big data integration. His core competencies include information architecture, data modeling, database design, project management, and relational and non-relational systems. He has worked in various industries including banking, healthcare, telecommunications, and government.
This document contains the professional summary and experience of Madhukar Eunny. He has over 12 years of experience working as a senior consultant on data warehousing projects. His roles have included ETL architect, developer, team lead, and production support. He has strong skills in ETL tools like Informatica and databases like Teradata, Oracle, and SQL Server. He currently works as a senior BI consultant for Medibank where he is responsible for requirements gathering, data modeling, ETL development, and providing business support.
Paul Justad has over 20 years of experience as a Solutions Architect, Developer, and Technical Analyst. He has expertise in requirements gathering, architectural design, database design, and developing web and workflow applications. Throughout his career, he has worked with Fortune 500 companies to integrate legacy mainframe data with web interfaces. Most recently, he was a Production Technical Analyst and Support Lead at Bank of America, where he managed production support and implemented automation to increase efficiency.
This curriculum vitae summarizes Pretesh Gungaram's career and qualifications. He has over 15 years of experience in data analytics, business intelligence, data warehousing, and information technology. He holds a B-Tech in Information Technology from Technikon Witwatersrand and has worked in roles at Nedbank, ABSA, KPMG, and other organizations developing data warehouses, performing ETL, and conducting analytics. He has strong skills in SQL, databases, data modeling, and project management.
This document provides a summary of Rizvi Shaik's professional experience as an Informatica ETL Developer over 9+ years. It outlines his extensive skills in areas like data warehousing, ETL development, data modeling, testing and production support. Recent roles include working with Horizon Blue Cross Blue Shield of NJ on projects involving data integration, replication and synchronization between various data sources using Informatica PowerCenter and Cloud.
Sriram Jasti has over 10 years of experience in data warehousing and business intelligence. He has implemented several large-scale data warehouse projects using star and snowflake schemas. His skills include data modeling, ETL development with tools like Informatica and SSIS, OLAP cube creation in SSAS, and report building in SSRS and Cognos. He is proficient in SQL Server, Oracle, and big data technologies like Hadoop and Hive. The summary provides an overview of his relevant experience and technical skills.
This document contains the resume of Shraddha Verma, a Data Warehouse Architect with over 10 years of experience in designing and developing ETL applications for data warehouses. She has extensive experience with tools like DataStage, Informatica, and Teradata utilities. She has worked on projects in various domains for clients like United Health Group, Sapient, and Tata Consultancy Services. Her skills include ETL design, data quality, project management, and people management. She is looking for a role as a techno-functional consultant in the data warehousing/BI domain.
The document provides a summary of Pratik Ghosh's career experience and qualifications. It outlines his 7 years of experience in ETL design and development using IBM DataStage, building data warehouses, and handling full project lifecycles. It also details his current role as a Technology Analyst at Aetna Healthcare, where he works on Medicare data integration and risk adjustment reporting systems. Pratik has expertise in technologies like DataStage, DB2, Oracle, and SQL Server and has received several awards for his work.
David Colbourn is an experienced information architect seeking a senior role. He has over 25 years of experience in areas such as software analysis, design, data modeling, project management, and big data integration. His core competencies include information architecture, data modeling, database design, project management, and relational and non-relational systems. He has worked in various industries including banking, healthcare, telecommunications, and government.
This document contains the professional summary and experience of Madhukar Eunny. He has over 12 years of experience working as a senior consultant on data warehousing projects. His roles have included ETL architect, developer, team lead, and production support. He has strong skills in ETL tools like Informatica and databases like Teradata, Oracle, and SQL Server. He currently works as a senior BI consultant for Medibank where he is responsible for requirements gathering, data modeling, ETL development, and providing business support.
Paul Justad has over 20 years of experience as a Solutions Architect, Developer, and Technical Analyst. He has expertise in requirements gathering, architectural design, database design, and developing web and workflow applications. Throughout his career, he has worked with Fortune 500 companies to integrate legacy mainframe data with web interfaces. Most recently, he was a Production Technical Analyst and Support Lead at Bank of America, where he managed production support and implemented automation to increase efficiency.
This curriculum vitae summarizes Pretesh Gungaram's career and qualifications. He has over 15 years of experience in data analytics, business intelligence, data warehousing, and information technology. He holds a B-Tech in Information Technology from Technikon Witwatersrand and has worked in roles at Nedbank, ABSA, KPMG, and other organizations developing data warehouses, performing ETL, and conducting analytics. He has strong skills in SQL, databases, data modeling, and project management.
This document provides a summary of Rizvi Shaik's professional experience as an Informatica ETL Developer over 9+ years. It outlines his extensive skills in areas like data warehousing, ETL development, data modeling, testing and production support. Recent roles include working with Horizon Blue Cross Blue Shield of NJ on projects involving data integration, replication and synchronization between various data sources using Informatica PowerCenter and Cloud.
Sriram Jasti has over 10 years of experience in data warehousing and business intelligence. He has implemented several large-scale data warehouse projects using star and snowflake schemas. His skills include data modeling, ETL development with tools like Informatica and SSIS, OLAP cube creation in SSAS, and report building in SSRS and Cognos. He is proficient in SQL Server, Oracle, and big data technologies like Hadoop and Hive. The summary provides an overview of his relevant experience and technical skills.
This document contains the resume of Shraddha Verma, a Data Warehouse Architect with over 10 years of experience in designing and developing ETL applications for data warehouses. She has extensive experience with tools like DataStage, Informatica, and Teradata utilities. She has worked on projects in various domains for clients like United Health Group, Sapient, and Tata Consultancy Services. Her skills include ETL design, data quality, project management, and people management. She is looking for a role as a techno-functional consultant in the data warehousing/BI domain.
The document provides a summary of Pratik Ghosh's career experience and qualifications. It outlines his 7 years of experience in ETL design and development using IBM DataStage, building data warehouses, and handling full project lifecycles. It also details his current role as a Technology Analyst at Aetna Healthcare, where he works on Medicare data integration and risk adjustment reporting systems. Pratik has expertise in technologies like DataStage, DB2, Oracle, and SQL Server and has received several awards for his work.
Abhishek Ray has over 9 years of experience in data warehousing and ETL. He has expertise in designing and developing data warehouses, data modeling, ETL processes, and reporting solutions. Some of his skills include Oracle PL/SQL, Unix, Java, C, Oracle databases, ODI, and OFSAAI. He has worked on banking data warehouse projects for clients like Mizuho Bank and NAB. Currently he is working as a principal consultant on a Basel III CRD IV development project for Mizuho Bank.
• 11+ Years of IT Industry experience in Analysis, Design, Development, Maintenance and Support of various software applications mainly in Data Warehousing (Informatica Power Center, OWB, SSIS and Business Objects), Oracle (SQL, PL/SQL) and Teradata in industry verticals like Finance, Telecom, Retail and Healthcare.
• Work experience in client facing roles in UK and Ireland.
• Performed numerous roles in Business Intelligence projects as Data warehouse System Analyst, ETL Designer, Onshore coordinator, Technical Lead and Senior Data warehouse Developer roles with multinational IT result-driven organizations
• Extensive experience on Data integration projects accessing sources like Teradata, Oracle and SQL server.
• Created robust EDW Solution from various types of sources like Flat files, XML Files, EDCDIC Cobol copybook from Mainframe systems, DB2 Unload files.
• Extensive experience on Data discovery, cleansing using Informatica IDQ.
• Resolved Inconsistent and Duplicate Data issues during Data Analysis to Support Strategic EDW Goals.
• Extensive experience of Data Integration using Informatica Power center Tool stack.
• Strong knowledge on Data Warehousing concepts, ETL concepts, Data Modeling, Dimensional Modeling.
• Conducted training on Informatica and have achieved awards for proficient training capabilities.
• Excellent understanding of OLTP and OLAP concepts and expert in writing SQL, Stored procedure on Teradata, Oracle and SQL Server.
• Extensive experience in implementing Data Warehousing methodologies including STAR SCHEMA and SNOW-FLAKE SCHEMAS & 3NF for huge data warehouses.
• Extensive knowledge on Change Data Capture (CDC) and SCD Type 1, Type 2, Type 3 Implementations.
• Excellent understanding of Kimball and Inmon Methodologies.
• Provided leadership when addressing high level technical issues and questions with the functionality of the reporting and business intelligence applications.
• Managed the current and strategize to foresee and plan for the future engineering needs in Data Integration space.
• Performed roles as a interface and coordinator between Database Administration, ETL Development, Testing teams and reporting teams to eliminate the road blocks for smooth flow of information.
• Hands on experience in tuning ETL mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Expert in designing and developing of complicate ETL mappings using Informatica PowerCenter.
• Proficient in optimizing performance issues using Informatica PowerCenter and Teradata.
• Having experience on using Teradata utilities (TPT, BTEQ, Fast Load, MultiLoad, FastExport, Tpump).
• Exposure in writing Shell Scripting as per given requirement.
• Work extensively in Teradata GCFR tool.
• Experience in SAP ECC integration with Informatica.
• Got training in Tableau, Qlik View& SAP BW 3.5and done POC for the same.
Mani Sagar is an ETL Sr Developer and Lead with over 8 years of experience in designing, developing, and maintaining large enterprise applications. He has expert knowledge of ETL technologies like Informatica and data management processes including data migration, profiling, quality, security, and warehousing. He has led teams of up to 8 developers and delivered projects on time for clients across various industries.
Roy Elgar has over 35 years of experience in data warehousing, databases, and Hadoop. He has worked across Asia Pacific and Europe in industries such as banking, shipping, telecommunications, and government. He currently works as an Enterprise Data Architect for Standard Chartered Bank in Singapore. Roy has extensive skills in architecture, data modeling, Hadoop, and technologies such as Teradata and IBM DB2. He holds certifications from Teradata and IBM and has lived and worked in countries including the UK, India, Denmark, and Singapore.
Prasad Kommoju has 5 years of experience in ETL development using Informatica. He has worked on projects in banking and manufacturing. His skills include Informatica PowerCenter, IDQ, MDM, DIH, SQL, and UNIX. Currently he works as a Senior Software Engineer at Tech Mahindra on a project with MasterCard managing customer data.
Sunil Faroz has over 14 years of experience in IT application development, maintenance, and support. He has extensive experience with data integration technologies like Informatica and ETL methodologies. Some of his key skills include data modeling, data warehousing, SQL, Oracle, and big data technologies. He has worked on various projects for clients in banking, manufacturing, and media industries.
Sakthi Shenbagam is a senior Informatica lead developer with over 7 years of experience in data warehousing and ETL development. She has extensive experience designing and developing complex ETL mappings and workflows to load data into data warehouses from various sources like Oracle, Netezza, and flat files. Some of her responsibilities include requirement gathering, design, development, testing, performance tuning, and support of ETL processes and data warehousing projects for clients across various industries. She is proficient in Informatica PowerCenter, QlikView, Oracle, and other tools.
Dinesh B Deshpande is an Indian software engineer with over 9 years of experience in data warehousing and ETL. He has extensive expertise in Informatica PowerCenter and has worked on various projects involving data extraction from sources like flat files, Oracle, SQL Server, and Teradata, and loading the data into target databases. He currently works as a senior consultant at Capgemini Consulting India Pvt. Ltd.
This document contains a career summary and objective for Arunkumar J S, an IT professional with over 5 years of experience in data warehousing using Abinitio. The professional profile details experience designing, developing, and implementing data warehouse projects involving processing terabytes of data. Responsibilities included creating ETL designs, mappings, data models, and loading data into Teradata. The experience section describes roles on several projects involving extracting data from various sources and loading it into a data warehouse for clients like Capital One and Wells Fargo.
The document provides a professional summary for N Venkatesh Babu, who has over 14 years of experience in IT with a focus on database technologies, data warehousing, and ETL development. He has extensive experience designing, developing, and implementing data warehouse solutions using technologies such as Oracle, Informatica, Hadoop, and Tableau. He has led projects in various industries and is proficient in technologies such as SQL, Unix scripting, Python, and Java.
The document provides a summary of Narender Reddy Andra's professional experience working as an Informatica Developer/Lead on various projects in the banking, insurance and manufacturing domains. It details his 8 years of experience implementing ETL solutions using Informatica tools like PowerCenter, IDQ, and MDM to extract, transform and load data from various source systems into data warehouses. It also lists his technical skills and responsibilities which include requirements gathering, database design, mapping development, testing, production support, and acting as an offshore lead coordinating with teams.
Pallavi Gokhale Mishra has over 16 years of experience in data migration, data warehousing, project management, and software development. She currently works as a Solution Architect for IBM India on a project involving data migration from Oracle CRM to Siebel CRM for Vodafone India. Her experience includes managing teams and leading complex data migration projects involving Siebel, SAP, and other applications for clients in telecom, automotive, banking, and other industries. She has strong skills in ETL tools like IBM Datastage, databases like Oracle, and programming languages like SQL.
Lu Cheng has over 20 years of experience as a data architect, database administrator, and business intelligence consultant. He has extensive expertise in data warehousing, ETL, analytics, and database technologies like Oracle, SQL Server, and DB2. His most recent role was as a principal data architect at Advanced Computing and Communication where he provided consulting services to clients like Erie Insurance.
This document contains the resume of Sandip Baral which summarizes his work experience and skills. He has over 6 years of experience in database design, development and application support. Currently he works as an Enterprise Data Architect at Delta Air Lines where he is responsible for data architecture, modeling, integration and quality. Previously he has worked on supply chain management projects at Staples involving applications like Rockport, Network Transportation and their Warehouse Management System.
This document provides a summary of Magesh Babu Arumugam's experience as a data warehousing professional with over 10 years of experience. It highlights his strengths such as experience tuning SQL queries, loading and extracting data using ETL tools like WhereScape RED, and working with databases like Teradata and Greenplum. It also lists his technical expertise and professional experience managing projects involving data migration, ETL development, and performance tuning for clients in various industries.
Premanand Jha is an IBM Certified IT Architect with over 15 years of experience in application development, integration, and architecture using technologies like .NET, SQL Server, web services, and SOA. He has expertise in application development, integration architecture, DevOps, and mentoring teams. Currently he works as an IT Architect at IBM India where he provides solutions, designs architectures, and mentors teams on projects for clients in industries like banking, healthcare, and telecommunications.
IT professional with 6 years of experience in business intelligence, data warehousing, and data mapping. Skilled in programming languages like Informatica, SQL, and C. Worked as a senior test analyst and quality assurance analyst for companies like OCBC and DBS, where responsibilities included testing data loads, preparing test plans, and ensuring defect-free code. Educated in electronics and communication engineering and holds certifications in banking, markets, and Cognos. Received multiple awards for work on projects involving data integration, extraction, and reporting.
Ashish Maheshwari has over 8 years of experience in data modeling, integration, analytics, mining, ETL processes, BI applications, and data warehousing. He currently works as a Technical Lead at Ness Technologies, Bangalore and has experience working on projects for clients such as FGL, Marks, and Target. His skills include Oracle SQL, PL/SQL, Datastage, data warehousing concepts, R programming, and Agile development processes.
Chiranjib Bhattacharjee has over 15 years of experience as a solution architect, database administrator, and project manager for telecom companies. He currently works as a technical solution manager for Vodafone Netherlands, where he leads infrastructure architecture and maintenance of their BI system. Previously, he has managed databases for clients such as Xerox, ServiceMaster, and IBM.
Sait Mourzaev has over 14 years of experience in software quality assurance and testing. He has extensive experience designing and executing test plans, cases and scenarios across various industries. Some of his skills include automation testing, performance testing, data warehouse testing, and experience with tools like HP LoadRunner, HP QTP and HP Quality Center. He has worked on projects for companies like Canadian Tire, Shoppers Drug Mart, CIBC and Manulife Financial.
Managed various Java projects for healthcare, financial services, and other industries. Developed graphical applications, data viewers, and other tools using technologies like Java, Swing, Struts, Hibernate, and more. Led teams as a senior developer and architect, defining requirements, designing systems, and overseeing development. Performed testing, integration, and quality assurance on projects. Maintained applications and provided technical support. Skilled in Agile methodologies, UML modeling, databases, and other technologies.
This document provides a summary of Karthikeyan Murugesan's experience and qualifications. He has over 17 years of experience in software design and development using technologies like Java/J2EE, Spring, SOAP, REST. Currently he works as a Technical Architect and Senior Developer/Lead. He has expertise in designing, developing, and deploying secured applications using various technologies. He has worked with major clients such as PNC Bank, Wells Fargo, AT&T, Citigroup, and others.
Abhishek Ray has over 9 years of experience in data warehousing and ETL. He has expertise in designing and developing data warehouses, data modeling, ETL processes, and reporting solutions. Some of his skills include Oracle PL/SQL, Unix, Java, C, Oracle databases, ODI, and OFSAAI. He has worked on banking data warehouse projects for clients like Mizuho Bank and NAB. Currently he is working as a principal consultant on a Basel III CRD IV development project for Mizuho Bank.
• 11+ Years of IT Industry experience in Analysis, Design, Development, Maintenance and Support of various software applications mainly in Data Warehousing (Informatica Power Center, OWB, SSIS and Business Objects), Oracle (SQL, PL/SQL) and Teradata in industry verticals like Finance, Telecom, Retail and Healthcare.
• Work experience in client facing roles in UK and Ireland.
• Performed numerous roles in Business Intelligence projects as Data warehouse System Analyst, ETL Designer, Onshore coordinator, Technical Lead and Senior Data warehouse Developer roles with multinational IT result-driven organizations
• Extensive experience on Data integration projects accessing sources like Teradata, Oracle and SQL server.
• Created robust EDW Solution from various types of sources like Flat files, XML Files, EDCDIC Cobol copybook from Mainframe systems, DB2 Unload files.
• Extensive experience on Data discovery, cleansing using Informatica IDQ.
• Resolved Inconsistent and Duplicate Data issues during Data Analysis to Support Strategic EDW Goals.
• Extensive experience of Data Integration using Informatica Power center Tool stack.
• Strong knowledge on Data Warehousing concepts, ETL concepts, Data Modeling, Dimensional Modeling.
• Conducted training on Informatica and have achieved awards for proficient training capabilities.
• Excellent understanding of OLTP and OLAP concepts and expert in writing SQL, Stored procedure on Teradata, Oracle and SQL Server.
• Extensive experience in implementing Data Warehousing methodologies including STAR SCHEMA and SNOW-FLAKE SCHEMAS & 3NF for huge data warehouses.
• Extensive knowledge on Change Data Capture (CDC) and SCD Type 1, Type 2, Type 3 Implementations.
• Excellent understanding of Kimball and Inmon Methodologies.
• Provided leadership when addressing high level technical issues and questions with the functionality of the reporting and business intelligence applications.
• Managed the current and strategize to foresee and plan for the future engineering needs in Data Integration space.
• Performed roles as a interface and coordinator between Database Administration, ETL Development, Testing teams and reporting teams to eliminate the road blocks for smooth flow of information.
• Hands on experience in tuning ETL mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Expert in designing and developing of complicate ETL mappings using Informatica PowerCenter.
• Proficient in optimizing performance issues using Informatica PowerCenter and Teradata.
• Having experience on using Teradata utilities (TPT, BTEQ, Fast Load, MultiLoad, FastExport, Tpump).
• Exposure in writing Shell Scripting as per given requirement.
• Work extensively in Teradata GCFR tool.
• Experience in SAP ECC integration with Informatica.
• Got training in Tableau, Qlik View& SAP BW 3.5and done POC for the same.
Mani Sagar is an ETL Sr Developer and Lead with over 8 years of experience in designing, developing, and maintaining large enterprise applications. He has expert knowledge of ETL technologies like Informatica and data management processes including data migration, profiling, quality, security, and warehousing. He has led teams of up to 8 developers and delivered projects on time for clients across various industries.
Roy Elgar has over 35 years of experience in data warehousing, databases, and Hadoop. He has worked across Asia Pacific and Europe in industries such as banking, shipping, telecommunications, and government. He currently works as an Enterprise Data Architect for Standard Chartered Bank in Singapore. Roy has extensive skills in architecture, data modeling, Hadoop, and technologies such as Teradata and IBM DB2. He holds certifications from Teradata and IBM and has lived and worked in countries including the UK, India, Denmark, and Singapore.
Prasad Kommoju has 5 years of experience in ETL development using Informatica. He has worked on projects in banking and manufacturing. His skills include Informatica PowerCenter, IDQ, MDM, DIH, SQL, and UNIX. Currently he works as a Senior Software Engineer at Tech Mahindra on a project with MasterCard managing customer data.
Sunil Faroz has over 14 years of experience in IT application development, maintenance, and support. He has extensive experience with data integration technologies like Informatica and ETL methodologies. Some of his key skills include data modeling, data warehousing, SQL, Oracle, and big data technologies. He has worked on various projects for clients in banking, manufacturing, and media industries.
Sakthi Shenbagam is a senior Informatica lead developer with over 7 years of experience in data warehousing and ETL development. She has extensive experience designing and developing complex ETL mappings and workflows to load data into data warehouses from various sources like Oracle, Netezza, and flat files. Some of her responsibilities include requirement gathering, design, development, testing, performance tuning, and support of ETL processes and data warehousing projects for clients across various industries. She is proficient in Informatica PowerCenter, QlikView, Oracle, and other tools.
Dinesh B Deshpande is an Indian software engineer with over 9 years of experience in data warehousing and ETL. He has extensive expertise in Informatica PowerCenter and has worked on various projects involving data extraction from sources like flat files, Oracle, SQL Server, and Teradata, and loading the data into target databases. He currently works as a senior consultant at Capgemini Consulting India Pvt. Ltd.
This document contains a career summary and objective for Arunkumar J S, an IT professional with over 5 years of experience in data warehousing using Abinitio. The professional profile details experience designing, developing, and implementing data warehouse projects involving processing terabytes of data. Responsibilities included creating ETL designs, mappings, data models, and loading data into Teradata. The experience section describes roles on several projects involving extracting data from various sources and loading it into a data warehouse for clients like Capital One and Wells Fargo.
The document provides a professional summary for N Venkatesh Babu, who has over 14 years of experience in IT with a focus on database technologies, data warehousing, and ETL development. He has extensive experience designing, developing, and implementing data warehouse solutions using technologies such as Oracle, Informatica, Hadoop, and Tableau. He has led projects in various industries and is proficient in technologies such as SQL, Unix scripting, Python, and Java.
The document provides a summary of Narender Reddy Andra's professional experience working as an Informatica Developer/Lead on various projects in the banking, insurance and manufacturing domains. It details his 8 years of experience implementing ETL solutions using Informatica tools like PowerCenter, IDQ, and MDM to extract, transform and load data from various source systems into data warehouses. It also lists his technical skills and responsibilities which include requirements gathering, database design, mapping development, testing, production support, and acting as an offshore lead coordinating with teams.
Pallavi Gokhale Mishra has over 16 years of experience in data migration, data warehousing, project management, and software development. She currently works as a Solution Architect for IBM India on a project involving data migration from Oracle CRM to Siebel CRM for Vodafone India. Her experience includes managing teams and leading complex data migration projects involving Siebel, SAP, and other applications for clients in telecom, automotive, banking, and other industries. She has strong skills in ETL tools like IBM Datastage, databases like Oracle, and programming languages like SQL.
Lu Cheng has over 20 years of experience as a data architect, database administrator, and business intelligence consultant. He has extensive expertise in data warehousing, ETL, analytics, and database technologies like Oracle, SQL Server, and DB2. His most recent role was as a principal data architect at Advanced Computing and Communication where he provided consulting services to clients like Erie Insurance.
This document contains the resume of Sandip Baral which summarizes his work experience and skills. He has over 6 years of experience in database design, development and application support. Currently he works as an Enterprise Data Architect at Delta Air Lines where he is responsible for data architecture, modeling, integration and quality. Previously he has worked on supply chain management projects at Staples involving applications like Rockport, Network Transportation and their Warehouse Management System.
This document provides a summary of Magesh Babu Arumugam's experience as a data warehousing professional with over 10 years of experience. It highlights his strengths such as experience tuning SQL queries, loading and extracting data using ETL tools like WhereScape RED, and working with databases like Teradata and Greenplum. It also lists his technical expertise and professional experience managing projects involving data migration, ETL development, and performance tuning for clients in various industries.
Premanand Jha is an IBM Certified IT Architect with over 15 years of experience in application development, integration, and architecture using technologies like .NET, SQL Server, web services, and SOA. He has expertise in application development, integration architecture, DevOps, and mentoring teams. Currently he works as an IT Architect at IBM India where he provides solutions, designs architectures, and mentors teams on projects for clients in industries like banking, healthcare, and telecommunications.
IT professional with 6 years of experience in business intelligence, data warehousing, and data mapping. Skilled in programming languages like Informatica, SQL, and C. Worked as a senior test analyst and quality assurance analyst for companies like OCBC and DBS, where responsibilities included testing data loads, preparing test plans, and ensuring defect-free code. Educated in electronics and communication engineering and holds certifications in banking, markets, and Cognos. Received multiple awards for work on projects involving data integration, extraction, and reporting.
Ashish Maheshwari has over 8 years of experience in data modeling, integration, analytics, mining, ETL processes, BI applications, and data warehousing. He currently works as a Technical Lead at Ness Technologies, Bangalore and has experience working on projects for clients such as FGL, Marks, and Target. His skills include Oracle SQL, PL/SQL, Datastage, data warehousing concepts, R programming, and Agile development processes.
Chiranjib Bhattacharjee has over 15 years of experience as a solution architect, database administrator, and project manager for telecom companies. He currently works as a technical solution manager for Vodafone Netherlands, where he leads infrastructure architecture and maintenance of their BI system. Previously, he has managed databases for clients such as Xerox, ServiceMaster, and IBM.
Sait Mourzaev has over 14 years of experience in software quality assurance and testing. He has extensive experience designing and executing test plans, cases and scenarios across various industries. Some of his skills include automation testing, performance testing, data warehouse testing, and experience with tools like HP LoadRunner, HP QTP and HP Quality Center. He has worked on projects for companies like Canadian Tire, Shoppers Drug Mart, CIBC and Manulife Financial.
Managed various Java projects for healthcare, financial services, and other industries. Developed graphical applications, data viewers, and other tools using technologies like Java, Swing, Struts, Hibernate, and more. Led teams as a senior developer and architect, defining requirements, designing systems, and overseeing development. Performed testing, integration, and quality assurance on projects. Maintained applications and provided technical support. Skilled in Agile methodologies, UML modeling, databases, and other technologies.
This document provides a summary of Karthikeyan Murugesan's experience and qualifications. He has over 17 years of experience in software design and development using technologies like Java/J2EE, Spring, SOAP, REST. Currently he works as a Technical Architect and Senior Developer/Lead. He has expertise in designing, developing, and deploying secured applications using various technologies. He has worked with major clients such as PNC Bank, Wells Fargo, AT&T, Citigroup, and others.
Paresh S Hingolikar is an Oracle FMW architect with over 8 years of experience in integration technologies including Oracle SOA Suite, AIA, OSB and ODI. He has worked on projects in utilities and telecom domains for clients in UK, US, France, South Africa and Australia. Currently he is leading a team of 7 resources providing L3 support for Vodacom's order management system implemented using Oracle technologies. He has experience designing and developing complex integration flows between various applications.
The document provides examples of common search strings organized by keyword and job title that can be used or modified for searching. It includes over 50 search strings covering a wide range of technical roles such as .NET Developer, Android Developer, Business Analyst, Database Administrator, Java Developer, Network Administrator, Project Manager, Python Developer, and Web Developer among others. The search strings combine relevant skills, technologies, and terms for each role.
- Allen Kuo has over 20 years of experience in IT and data warehousing. He currently works as a lead data engineer and architect.
- He has expertise in big data, ETL, data modeling, SQL, and leading projects at companies such as Apple, HP, Bank of the West, and Kaiser Permanente.
- Kuo has a master's degree in computer science and is skilled in technologies like Hadoop, SAS, Informatica, Teradata, and Oracle.
Here is a summary of the document in 3 sentences or less:
SUMMARY:
Madhu Kopparapu has over 16 years of experience in software development and management, specializing in e-commerce applications. He has led teams in designing and implementing many commercial software products, most recently as a technical manager at Sprint Nextel and RJM Technologies. Kopparapu has a proven track record of delivering projects on-time and on-budget through the use of agile methodologies and a focus on customer expectations.
This document contains the resume of Stefano Fiorini, a senior software engineer with experience in mobile development for iOS and Android platforms. He has expertise in designing and developing mobile applications using technologies like Android Studio, Xamarin Studio, Objective-C and Swift. Some of his project experiences include developing mobile apps for healthcare organizations to enable telemedicine and accessing patient health records. He is proficient in languages like C#, Java, HTML5 and frameworks like AngularJS, Ionic and J2EE.
This document is a resume for R. Michael Levin summarizing his objective, clearances, technical skills, and professional experience. Levin has over 20 years of experience in fields like enterprise architecture, data architecture, data modeling, database administration, and project management. He currently works as a Solution Architect and Technical Project Manager developing data warehouses and managing teams. His previous roles include positions as a Principal Solution Data Architect, Senior Data Architect, and Senior Database Architect at various companies.
- The document contains the resume of Abdul Mohammed, an ETL developer with 8 years of experience using Informatica for data warehousing projects.
- He has expertise in requirements gathering, data extraction from various sources, transforming the data using Informatica tools, and loading the data into target databases.
- His most recent role was as an ETL/SR Informatica Lead from 2015-present where he worked on building a data warehouse for a pharmaceutical company using Informatica to extract data from Oracle and flat files.
Alphonso Triplett is currently an Enterprise Data Manager and TDM/MDM consultant at BOKF, where he provides guidance on test data management, data masking, and data privacy solutions. Previously, he held several roles as a senior data architect and database administrator, where he was responsible for data modeling, database design, test data management, and implementing data governance policies.
Samir Patel has over 16 years of experience as a senior data architect. He has expertise in leading large-scale data management and BI/DW efforts, including data governance, data management, and master data management. He currently works as a senior data architect at Neiman Marcus, where he has implemented standardization of data governance processes and led development of enterprise data models. Previously he has worked for companies such as Wipro, Best Buy, Target, Capital One, and HP in roles including data architect, data modeler, and project manager.
An experienced IT professional with over 18 years of experience in areas such as IT management, database administration, project management, security, and ETL development. Skilled in technologies like Oracle, SQL Server, .NET, and Informatica. Provides leadership and delivers results for projects involving the design, development and maintenance of database solutions and information systems. Holds an MS in Information Technology Management and ITIL certification.
Varadarajan Sourirajan is a data architect with over 16 years of experience seeking a new position. He has extensive experience in data modeling for both online transaction processing and data warehousing applications. Currently he is working on implementing a data warehouse for the treasury line of business at a large bank in the US, drawing on his experience delivering previous data warehouse projects and a proven track record of success.
The document provides a summary of Padmashree Muralidharan's professional experience and qualifications. It highlights over 9 years of experience in business analysis, system analysis, software development, databases, and project management. Recent experience includes working as a Systems Analyst at United Health Group where responsibilities involved examining business requirements, solution design, and testing coordination. Previous experience includes roles as a Business System Consultant at Express Scripts and various analyst and developer roles at other organizations. The document lists technical skills and project experience demonstrating expertise in areas such as requirements gathering, system design, and application development.
Victor Torres is a technical consultant with 19 years of experience managing projects and teams across multiple industries. He has extensive skills in databases, ETL, and data warehousing technologies. Recent projects include designing resume parsing and points calculation systems for Zero Chaos and integrating data from 5 sources into a new data warehouse for Domtar Personal Care.
The document provides a summary of Gerald Donaldson's experience and qualifications. It includes his contact information, objective of seeking an enterprise architecture role, and summaries of his past roles including Enterprise Data Architect, Data Warehouse Architect, and BI Architect. He has over 30 years of experience designing and implementing data warehouse and BI solutions primarily using Microsoft technologies. The document also lists his education background and technical skills.
The document provides a technical summary and experience profile of Nootan Sharma. It summarizes his 8 years of experience in data warehousing and business intelligence projects. It details his expertise in tools like Informatica PowerCenter, Oracle, SQL Server and data quality management. It also lists his past work experience with companies like Capgemini, Birlasoft and Infogain on various BI and data warehousing projects for clients in different sectors.
Subham Malakar has over 11 years of experience in information technology, with expertise in data modeling, data warehousing, business intelligence, and ETL. He currently works as a solutions architect at TCS, where he is involved in projects such as a BI refresh for Kaiser Permanente and leading an enterprise solutions center of excellence. Malakar has extensive technical skills and experience delivering solutions for clients in various industries.
Manjulatha Ganna has over 15 years of experience in software development, business analysis, and testing. She has expertise in all phases of the software development lifecycle and translating business requirements into technical solutions. Ganna has worked in various industries and roles including business analyst, database analyst, test lead, and Oracle developer. She is proficient in technologies such as Oracle, SQL Server, SAP, Hadoop, and programming languages like Java, C/C++, and PL/SQL.
A competent professional offering over 7+ years of experience in Business Intelligence & Data Warehousing working in roles such as Business Analyst, Data Analyst & Reporting Developer, ETL Architect, Data Architect. Extensively worked on a wide range of tools such as Tableau, Spotfire & SAP Business Objects. Skilled in Teradata database, Oracle Database, MS SQL Server, MS Access, PostgreSQL, Requirements Analysis, reporting, Extract, Transform, Load (ETL), Data Warehousing, End-to-end execution of BI Projects, System Integration, Value Delivery, Team Leadership, Onshore-Offshore working model.
Business Expertise: Power & Engineering(GE POWER), Banking and Financial Services(GE CAPITAL), Leasing domain .
Interests: Data Science.
Patchuru Ramakrishna has over 5 years of experience in IT with skills in software development, ETL, databases, and project management. He has worked on projects involving mainframes, ETL tools like Informatica, databases like Oracle and Teradata, and programming languages including COBOL, SQL, and UNIX. Some of his responsibilities have included requirements gathering, design, development, testing, production support, and leading teams. He has worked with clients in the telecommunications industry and delivered projects on time and to quality standards.
Mr. Nisfan Nawaz has over 25 years of experience in information technology program management and leadership roles at Cisco Systems. He has a proven track record of successfully delivering large, complex, global programs and projects while managing multi-million dollar budgets and teams of over 40 people. His experience spans a variety of domains including marketing, finance, e-commerce, and public safety. He holds professional certifications in Project Management (PMP) and Six Sigma (SSGB).
Khalid SRIJI has over 12 years of experience as a senior software developer. He has extensive experience with Python, C#, .NET, SQL, and financial industry technologies. Some of his areas of expertise include full software development life cycles, distributed systems, cloud computing, web services, databases, and data analytics. He has worked on projects involving trading platforms, risk management, reporting, and asset management.
This document provides a summary of Mohammed Kaleem's professional experience and qualifications. He has over 25 years of experience in business intelligence, with expertise in MicroStrategy, Informatica, and data warehousing. Some of his roles include senior consultant, solution architect, and lead developer. He has extensive experience designing, developing, and implementing BI solutions for many large companies.
This document is a resume for Robert Weissenberg summarizing his experience in business intelligence and project management. He has over 20 years of experience implementing business intelligence solutions using Microsoft SQL Server, SSIS, SSAS and SSRS. He has expertise in ETL processes, data warehousing, cube design, reporting and dashboards. He has managed projects in various industries including utilities and telecommunications.
Pratik Dey is an IT professional with over 4 years of experience in data warehousing and ETL development. He has strong skills in Informatica PowerCenter and experience loading data from various sources into Teradata. Currently he works as an ETL Data Specialist for Thomson Reuters implementing their Connect Data Warehouse. Previously he worked on projects in healthcare and banking to develop ETL processes and load data into data warehouses.
• 11+ Years of IT Industry experience in Analysis, Design, Development, Maintenance and Support of various software applications mainly in Data Warehousing (Informatica Power Center, OWB, SSIS and Business Objects), Oracle (SQL, PL/SQL) and Teradata in industry verticals like Finance, Telecom, Retail and Healthcare.
• Work experience in client facing roles in UK and Ireland.
• Performed numerous roles in Business Intelligence projects as Data warehouse System Analyst, ETL Designer, Onshore coordinator, Technical Lead and Senior Data warehouse Developer roles with multinational IT result-driven organizations
• Extensive experience on Data integration projects accessing sources like Teradata, Oracle and SQL server.
• Created robust EDW Solution from various types of sources like Flat files, XML Files, EDCDIC Cobol copybook from Mainframe systems, DB2 Unload files.
• Extensive experience on Data discovery, cleansing using Informatica IDQ.
• Resolved Inconsistent and Duplicate Data issues during Data Analysis to Support Strategic EDW Goals.
• Extensive experience of Data Integration using Informatica Power center Tool stack.
• Strong knowledge on Data Warehousing concepts, ETL concepts, Data Modeling, Dimensional Modeling.
• Conducted training on Informatica and have achieved awards for proficient training capabilities.
• Excellent understanding of OLTP and OLAP concepts and expert in writing SQL, Stored procedure on Teradata, Oracle and SQL Server.
• Extensive experience in implementing Data Warehousing methodologies including STAR SCHEMA and SNOW-FLAKE SCHEMAS & 3NF for huge data warehouses.
• Extensive knowledge on Change Data Capture (CDC) and SCD Type 1, Type 2, Type 3 Implementations.
• Excellent understanding of Kimball and Inmon Methodologies.
• Provided leadership when addressing high level technical issues and questions with the functionality of the reporting and business intelligence applications.
• Managed the current and strategize to foresee and plan for the future engineering needs in Data Integration space.
• Performed roles as a interface and coordinator between Database Administration, ETL Development, Testing teams and reporting teams to eliminate the road blocks for smooth flow of information.
• Hands on experience in tuning ETL mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Expert in designing and developing of complicate ETL mappings using Informatica PowerCenter.
• Proficient in optimizing performance issues using Informatica PowerCenter and Teradata.
• Having experience on using Teradata utilities (TPT, BTEQ, Fast Load, MultiLoad, FastExport, Tpump).
• Exposure in writing Shell Scripting as per given requirement.
• Work extensively in Teradata GCFR tool.
• Experience in SAP ECC integration with Informatica.
• Got training in Tableau, Qlik View& SAP BW 3.5and done POC for the same.
1. Siva Kanagaraj, Sr. Data Architect
E-Mail: Sivanvin74@gmail.com
Ph: 7402577704
Experience Summary:
Total of 18 years experience in Information Technology, which includes 13 years of USA experience and
5 years of Indian IT experience, in architecture and delivery of various software applications and
products. Expertise in Data Modelling of relational modelling for OLTP/OLAP applications and data
integration for data as a service using ARTS standards. Expertise in Data Modelling of dimensional
modelling for data warehousing applications and reporting platforms using KIMBAL’s conformed
dimensional modelling standards. Worked in various areas of business intelligence for reporting areas as
a senior data architect.
Very well experienced in ETL architecture and delivery using various versions of Datastage, quality
stage tools, and other IBM Infosphere tools for data warehousing and other data integration projects.
Designed and developed data archival and data integration strategy. Strongly experienced in OLTP
application development using Mainframe and Java/J2EE toolset also provided global production
support using ITIL standards. Managed projects using project management tools, provided estimates
and project schedules. Performed and managed various types of testing.
Worked in all 3 roles such as a client, software consultant and software service provider on
development, architecture, project management and production support areas. Experienced in Retail,
Banking and Telecom domains of fortune 500 companies across the globe. Pioneer in building offshore
and onshore delivery model for data warehousing and data integration areas using multi vendor
approach for $30 billion dollar global retail industry (TJX Companies).
Provided expert-level consultation for the design and development of enterprise-wide data and
information architecture. Implemented the data management strategy. Directed and designed the
configuration of data. Defined data architecture standards and principles. Participated in the global
definition of information architecture principles, policies, and the application of industry best practices.
Performs vendor evaluations and recommended implementation of data architecture tools. Facilitated
and formally documented business requirements and strategic objectives. Worked with functional
business partners to ensure appropriate terminology is applied to metadata and data lineage.
Worked with business architects to identify, define and document business processes. Provides senior
level guidance to all aspects of the solution delivery cycle. Took responsibilities for tollgate assessment
and review. Ensured continual maintenance of high quality, timely and standardized data.
Participates in the development and implementation of the data governance and master data
management plan. Ensured all the designs met all regulatory, industry, compliance and industry best
practice procedures. Consulted project, infrastructure, business, integration, testing and production
support teams while defining data architecture policies, best practice and procedures.
Have lead and developed a diverse, global team for future growth within the department and
organization. Facilitates, delivers, advocates for and supports all aspects of the EDW & MDM programs
within the global application landscape. Owned and designed future state business processes,
conceptual to physical data models, and path to execution from current state to "as-is" assessments.
Participates in and holds design review authority as a member of the Enterprise Architecture (EA) review
board during business initiative tollgate and solution project deliverables. Worked with Data Architects,
provides guidance in the design and governance review for select development initiatives, middleware
projects, and aligned tools.
Provided instruction, training, and expert guidance to staff members on all aspects of existing and new
Data Architecture techniques, best practice strategies, and technologies. Lead, facilitated, and/or
consults the review of project team deliverables for key transformational projects in the enterprises such
as enterprise data warehouse, operation data store, data marts, and MDM initiatives.
Skills,Knowledge & Experience
Experienced in systems and technical architecture design, implementation, and support of
manual and automated database systems and technical architectures.
Strong retail experience as a Sr.Data Architect. Expertise in configuration and customization of
retail products such as RPAS and RMS.
2. Has successfully designed and implemented large-scale data warehouse and business
intelligence solutions using IBM Infosphere tools. Has the ability to communicate and formally
document all aspects of the job requirements
Expert knowledge facilitating and hands-on experience in ETL, data modelling and design, data
flow diagramming, data warehousing and business intelligence, application and analytical
reporting tools and techniques, service oriented data delivery, and global master data
management programs.
Built Effective Team and have sets team goals and regularly measures progress Understands
what motivates individual team members. Experienced in playing a leadership and mentoring
role in enterprise-wide data quality, business data stewardship, and data modelling project
assignments.
Knowledge of industry standard middleware, ETL, master data hub, and service oriented
architecture, design and delivery solutions. Exhibits a high energy, strategic thinking, results
oriented, global collaborative approach with highly tuned listening and communication skills.
General understanding of common development languages and frameworks within the
Systems development toolset. Business analysis, process modelling, and a strong domain
knowledge of a global retail business a plus. Having Bachelor's Engineering Degree in 1st
class from M.G.R engineering college of Chennai University in the year of 1992 through 1996.
TOOLS:
Erwin Data Modeller, Advanced SQL, Information Analyzer, Microsfot Project Managemant
tools, IBM Infosphere tools such as Datastage, Qualitystage & Business Glossary, Buisness
Intelligence tools Cognos, Netezza, ITIL, UNIX, TOAD for Oracle. SPUFI, Platinum and QMF
for DB2, Adabase, Oracle & IMS DB Databases. UNIX, REXX and JCL scripting. CA7 and
Autosys scheduler. VS COBOLS II, JAVA, JSP, VSAM, Natural, HTML, SQL and CICS,
Easytrieve, Web-Focus and Batch Focus report writing and Endevor.
Employment:
Roles/Employers Clients
Sr. Data Architect @ The TJX Companies, USA
(Feb 2014 – June 2016).
The TJX Companies Inc, USA (Datawarehousing and
Data Integration).
Sr. Data Architect @ Fourth Technology Inc, USA
(Nov 2011 – Feb 2014).
The TJX Companies Inc, USA (Datawarehousing and
Data Integration).
ETL Architect @ INFOSYS India/USA (Dec 2007 –
October 2011)
RBS/Citizens Bank, USA and UK (Retail and
Commercial Banking).
Sr. Consultant @ TCS, Chennai, India (May 2006
to Nov 2007)
Morgan Stanley, Europe (Investment Banking – Real
Time Settlement System).
Project Lead @ EDS, Colorado, USA (Jan 2001 &
Aug 2005)
WorldCom, USA (Financial Management Systems).
Developer @ COMSYS, Colorado, USA (June 1998
and Jan 2001)
WorldCom, USA (Financial Management Systems).
1. Project: Data Warehousing and Data Integration Platforms for TJX
Client : TJX
Role : Sr. Data Architect
TJX beinga30 billiondollarcompanyneverhada centralizedplatformforreportinganddata as services.
Therefore,ithadinitiated amultimilliondollardatawarehousingprojecttoholdcentralizedreporting
platformforall the businessesrunningacrossUSA,Europe and Canadausingthe latesttechnologiesof
Netezza&IBM Infosphere toolsinordertoavoidmultiple reportingplatforms.Similarly,aspart of TJX
3. foundationproject,ithadinitiateddataintegrationplatformforcentralized environmentusingIBMSOA
service toolstoprovideddataasa service inordertoavoid applicationtoapplicationinterfaces.
Responsibilities:
As a senior data architect, responsible for identifying key subject areas for the data warehousing
platform.
Responsible for creating conceptual, logical and physical data model using conformed bus
architecture and review the same across various teams. Responsible for managing model marts
within Erwin.
Responsible for identifying the right integration approach such as real-time, near real time and
batch services.
Responsible for ETL architecture and creation of XML/XSD architecture.
Responsible for defining data mapping, data archival, data migration strategies and implement the
same.
Responsible for creation and management of enterprise architecture/patterns with help of
vendors such as IMB/Deloitte. Responsible for the management of software delivery from various
vendors such as Wipro, Cognizant and Collaborative consulting companies.
Responsible for delivery of ETL components and physical data model for Netezza/Oracle platforms
for data warehousing and SOA services respectively.
Responsible for metadata management and business glossary.
Reasonable for identifying and creation of data marts for business intelligence.
2. Project: MyMI (My Management Information)
Client : RBS Citizens Bank.
Role : ETL Tech Lead
Technology Used : ETL Architecture & Reporting (Datastage, OLTP/OLAP on Oracle, UNIX and Autosys)
There were 2 Instances of the MyMI applications were built ~ 1 for RBS UK and 1 for RBS Citizens, USA. The
RBS UK architecture of ETL and Dashboard Reports were designed and built first, and it was lifted,
redesigned and customized to meet USA standards and implemented for Citizens Bank. M yMI Phase I was
to build a single-view of branch performance via self-service, desktop option for management. With only
few-clicks, a Retail Directors, Regional Manager, and Branch manager will be able to assess performance
and unrealized opportunity at a market, region and at branch level, across a full spectrum of business
results.
The ETL application receives source data from 40 different sources and stores them in the data mart (Star
Schema) and aggregates at branch, region and executive level using the ETL tool “DataStage 8.0.1”. The
aggregated data is kept in the Management Information tables. Subsequently, the data is retrieved and
displayed on the UI reporting screens built on .NET technology. The de-normalized data kept in the star
schema will be used by Oracle Business Intelligence for data analysis by business line.
Responsibilities:
Identified source systems based on the UI and OBI report requirements by interacting with
various business lines and source systems’ SME.
Developed Infrastructure, Solution and System design documents. Designed source extract
techniques for various source systems such as SQL Server, Mainframe and Oracle Databases.
Performed ETL Mapping exercise using FASTRACK.
Metadata Management. Performed Data profiling and Data Cleansing activities.
Developed ETL micro designs using Datastage designer as an architect and lead.
Applied ETL concepts, ETL loading strategy, Data archiving, Data reconciliation, ETL Error
Handling, Error logging mechanism, standards and Best practices.
Applied warehousing techniques and ETL Frame work designing.
Performed OLTP modeling for Hierarchy schema and OLAP modeling for Data Mart with Data
Architect.
4. Development of archival strategy. Designed self recursive hierarchy model for data mart and
UI reporting from OLTP schema.
Built ETL routines to load star schema for cases such as: slowly changing dimensions, late
arriving facts, late arriving dimensions, “as is / as was” reporting, revisions to history,
surrogate keys.
Performed Data Quality, Data Profiling and Metadata Management. Have designed and
developed reusable components and transformations. Applied Performance Tuning methods,
Partitioning and Optimization in Datastage with large volumes of data load.
Designed and built complex stages to handle high-volume scenarios. Designed and Developed
Job scheduling through Autosys. Created SIT, UAT and implementation plan and strategies.
Provided SIT and UAT and Implementation support.
Performed implementation of Datastage and UNIX components. Managed cost and schedule of
the project for Infosys side.
Managed risks and dependencies, and Managed clients and other stakeholders.
Performed estimation and Preparation of RUNBOOK. Anchored Change Management.
3. Project: Real Time Settlement Systems for Morgan Stanley (ETL and Java
OLTP)
Duration: May 2006 to Nov 2007
Role – Tech Lead for European Settlement IT Support, Maintenance and enhancement activities using ITIL
framework.
Summary:
Morgan Stanley’s Real time settlement system consists of SAFE, XMS and Intellimatch (IM). SAFE
(Settlement & Financial Execution), which runs on Mainframe, receives enriched trades from trade
processing systems and extracts settlement data from other internal systems and creates settlement
instruction for various message types and sends them out to via XMS & SWIFT network for settlement. XMS
(Systems Message Service) retrieves name value pair instructions from SAFE via MQ and creates XML &
SWIFT standard format. SWIFT format is sent out thru SWIFT network for settlement. XMS receives
acknowledged, not acknowledged; kick-outs, settled instructions from various agents located across the
world and passes the same back to SAFE. XMS runs on J2EE technology on Tomcat Server 5.0.
Responsibilities:
Coordinates technical aspects of the project between business and technology groups.
Creation of Use Case and ETL Mapping Documents.
Enhanced DB2 OLTP schema. Documented design/technical artifacts an approved Functional
Specification. Developed design solutions meeting Target architecture standards. Provide technical
guidance and assist with day to day design and testing activities.
Ensured compliance to Target architecture, design and coding standards and best practices.
Developed complex ETL jobs. Developed transformation and aggregation techniques.
Ensured adherence to Software Development process standards. Performed and managed design and
code reviews. Identifying root cause of incidents and raising Problem Management requests.
Conducting weekly meeting with user group to assess the priority of new maintenance request.
Creating Weekly Status, Capacity Utilization and Monthly metrics pack and presenting the same to line
managers in Morgan Stanley
Handling outages and providing workaround during outages, and for "Hotline" set up.
Reducing Level 1 & 2 tickets by applying permanent fixes for frequent flyer.
4. Account: Telco Financial Management System for MCI (ETL and Mainframe
applications)
Duration: June 1998 thru August 2005
Employers: EDS (January 2001 thru August 2005) & Comsys (Jun 1998 thru December 2000)
5. Summary
ETL using iWay Datamigrator – The system extracts electronic files from various sources of LEC files and
magnetic tapes from Local Exchange Carriers (LEC) containing access charges in CABS (Carrier Access
Billing System) and SECABS (Small Exchange CABS) formats, and validates formats and loads the same
Telco Account Database (TAD). Passes MCI usage information from switches, summarized by the Traffic
Summarization System through Telco Usage systems (TELUS). Stores MCI circuit information received from
the network provisioning system (NETPRO) in Telco Automated Audit (TAA), which audits LEC bills by
comparing Telco data in TAD to the MCI data in TELUS. Audited data are passed to Telco Account
Management System (TAMS) for the creation of bill payment vouchers.
Roles:
Team member for first 3 years of ETL activities.
Team Lead and subject matter expert for 4 years for ETL Development, Maintenance,
Enhancement, Performance Tuning, Implementation activities of TAD and TAMS applications.
Point of Contact for Configuration Management activities, Local Exchange Carrier issues (LEC),
Change Management Requests, Problem Management Requests, and CA7 activities.
Responsible for:
Maintenance and enhancement, and smaller development of ETL & Mainframe projects within TAD
and TAMS applications. Metadata creation & Archival process.
Data cleansing and data profiling.
Developing 2 FCC mandatory major CABS releases for TAD by applying project management life
cycles methods and decommissioning 2 old releases from the system ever year.
Delegated work requests to the team members in USA and Brazil.
Interact with the client to assess priorities of enhancement and maintenance requests initiated by
them.
Execute their AD HOC requests to make changes to existing data.
Analyze the production applications and databases periodically for any process improvements.
Ever increasing LEC data volume needed these improvements.
Assist users in UAT, and assist internal and external auditors during QA.
Upgrade TAD test environment written using REXX and ISPF Panels.
Submit change requests to system admin and DBA group as needed, to make any changes to the
system software and databases.
Ensure data integrity and integrity of the application, and provide performance report and ABEND
metrics of the systems to the upper management.
Ensure old data are archived properly and Record Retention process is complete as well.