SUMMARY

• Having Around 12 Years of experience in Information Technology with progressive development, Design, implementation and support of Data Warehousing projects.
• Extensive experience on Banking and Insurance Domains.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Ab Initio and IBM - InfoSphere DataStage.
• Knowledge in Hadoop echo systems HDFS, Map Reduce, Pig, Sqoop, Flume, Spark and Hive.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Extensive experience in Agile methodology Scrum.
• Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Experience in creating Project Documents High Level Design and Detailed Design in the Design phase.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in implementation of Continuous graphs for real time data processing.
• Hands on experience with Metadata Hub administration tools, utilities for creating Metadata Hub data stores.
• Niche experience in processing of XML messages using AbInitio XML processing components.
• Experienced in generating Ab Initio DML’s from COBOL copybooks and handled Vision plus/Mainframe data.
• Designed the AbInitio graphs using the Join, Sort, Reformat, Partition components and re-usable components to implement the business requirements and Business design specifications.
• Extensive usage of Multifile system where data is partitioned into four partitions for Parallel processing and Wide usage of Lookup Files while getting data from multiple sources and size of the data is limited.
• Experienced in Ab Initio tools Conduct>IT, Plan>IT and Metadata-hub.
• Designed the DataStage jobs, Job sequences, Containers and re-usable components to implement the business requirements and Business design specifications.
• Developed Varies DataStage Jobs, define job parameters, reference lookups, filter criteria, Used Database stages, SORT, JOIN, MERGE, FILTER, FUNNEL, LOOKUP, TRANSFORM, XML stages...
• Experience in integration of various data sources like Oracle, DB2, Teradata, Netezza and MS access and non-relational sources like flat files into staging area.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Extensively worked on developing, debugging and Migrating Components Flow.
• Developed functional specifications for data acquisition, transformation and load processes for implementation.
• Performs unit test, integration test, and performance test per the approved test plan, documents test results, and escalates issues to the manager.
• Supports users during functional, UAT, regression, and performance testing.

TECHNICAL SKILLS

ETL tools: Ab Initio, IBM - InfoSphere DataStage, Informatica Powercenter and Iway Data Migrator

Database: Oracle, MS-SQL, DB2, Teradata and IBM PDA (Netezza)

Hadoop/Bigdata: HDFS, Map Reduce, Pig, Sqoop, Flume, Spark and Hive

Scheduling tool: Autosys, Control-m

Programming Languages: C, Java, SQL and Shell

PROFESSIONAL EXPERIENCE

Confidential

Abinitio Tech Lead

Environment: Abinitio, Unix Shell Programming, Teradata, DB2Hadoop-Hive and control-m

Responsibilities:

• Understand the architecture of existing process and worked on developing designing strategies, database Design/analysis and data migration techniques.
• Writing new ETL workflows to implement the business requirements as per design specifications for the client requirements.
• Create ETL graphs/job for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Ab Initio.
• Identifying and maintaining common utility functions used across the application.
• Interacting with business users to analyze the business process and requirements and transforming requirements into Application and reports, designing database, documenting and rolling out the deliverable.
• Participate in project planning sessions with IT and business teams to analyze the existing business process and gather the business process requirements and outline the proposed solution.
• Creating functional documents and Requirements Traceability Matrix for transforming the requirements to the executable application.
• Designing the relational Database tables and views to aid the reporting functionalities based on requirements.
• Troubleshooting and altering the existing code to accommodate business requirements changes or to fix the defects in the existing code implementation
• Unit testing for the implemented requirements by writing the possible test cases for all modules
• Analysis and implement the code to integrate the functional workflow of all the modules.
• Documenting the technical and functional guide for the application to be delivered to the stake holder
• Work thoroughly on performance tuning for batch optimization and get the statistics approved by business and management.
• Creating interactive dashboards with drill-down capabilities using Business Intelligence designer.
• Monitors project progress by tracking activity; resolving problems; publishing progress reports and recommending actions
• Tracking the project implementation progress status for each module
• Resolve the technical implementation issues in technologies or deployment issues in production.
• Provides references for users by writing and maintaining user documentation;
• Writing the user manuals document for the application and maintaining the user manuals.
• Prepares technical reports by collecting, analyzing, and summarizing information and trends.
• Collecting and documenting the feedback from end users who are using the proposed system.
• Prepare the summary technical report document to improve the system by compiling the end-users feedback.
• Creating QA/UAT execution, Implementation checklist and documents.

Confidential

Abinitio Tech Lead

Environment: Ab Initio, Unix Shell Programming and Oracle

Responsibilities:

• Implement the ETL solution using Abinitio (3.17) tools and involved in whole development life cycle of project like design, coding, testing, migration and production support.
• Provided end to end Architecture solution in enhancing the process performance.
• Understand the architecture of existing process and worked on developing designing strategies, database Design/analysis and data migration techniques.
• Worked with Users and BAs to gather and understand the requirements
• Designed the ETL Solution and created High Level and Detailed design document based on technical requirements document.
• Involved in data analysis, verifying data models
• Manage the Deliverables like Source to Target Mapping, Requirement Traceability Matrix
• Worked with the team to develop the Ab Initio Graphs and Unix Wrappers as per the Client Standards to provide Solution for Source to Database Data.
• Preparing and using Test data/cases to verify accuracy and completeness of ETL process.
• Involved in Unit Testing and Preparing and using Test data/cases to verify accuracy and completeness of ETL process.
• Support System Testing and User Acceptance Testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Set up jobs on the $universe scheduler and run the Project Deployment in Production Environment
• Worked on Onsite-Offshore development model and handled 6+ resources at offshore.
• Provided schedules, status reports, and issue resolutions to the Project team, Business Users, and Project Managers. Kept peers and upper management well informed with weekly status reports on project status / risks and test issues.
• Worked on project estimates, efforts, Forecast and Monthly Actuals.

Confidential

Tech Lead

Environment: IBM - InfoSphere DataStage, DB2, Unix Shell Programming, Algo tool, Mercury Quality Center and FRS

Responsibilities:

• Requirement gathering working with customer.
• Involved in preparing the EDD and Technical Design Document.
• Prepared the Design Flow Chat diagrams.
• Prepared mapping document for ETL processing with required business rules.
• Designed and developed various Data stage Jobs using various Stages.
• Developed shell scripts for Audit, batch processing.
• Prepared the Unit test cases and tested each Job.
• Check-in the code into CVS for version control.
• Supported with SIT & QAT Teams while fixing the defects.
• Coordinated with offshore development & testing teams.
• Validated test cases prepared by the testing team.
• Regularly attended meetings related to project status, designs and other project items.

Confidential

ETL Developer

Environment: IBM - InfoSphere DataStage, MS SQL Server 2008, DB2Unix Shell Programming, CVS, Bugzilla, Mercury Quality Center and Autosys

Responsibilities:

• Requirement gathering working with customer.
• Involved in preparing the EDD and Technical Design Document.
• Prepared the Design Flow Chat diagrams.
• Prepared mapping document for ETL processing with required business rules.
• Designed and developed various Data stage Jobs using various Stages.
• Developed shell scripts for Audit processing.
• Prepared the Unit test cases and tested each Job.
• Check-in the code into CVS for version control.
• Deployed the code in various environments by using Build forge.
• Supported with SIT & QAT Teams while fixing the defects.
• Supported Production implementation.
• Coordinated with offshore development & testing teams.
• Validated test cases prepared by the testing team.
• Learnt and used various business processes being used at the client for code management, deployment, implementation and testing.
• Regularly attended team meetings related to project status, designs and other project items.

Confidential

Abinitio Developer

Environment: Ab Initio, oracle, Unix & Tivoli

Responsibilities:

• Involving in developing the codes as per requirements.
• Creating the AbInitio graphs using the Join, Sort, Reformat, Partition components.
• Crating the watcher’s scripts to initialize the App Events in the Control database.
• Creating wrapper scripts for executing the process.
• Working in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like check-in and checkout are using for this purpose.
• Performing Transformations of source data with Transform Components.
• Scheduled the jobs in Development Environment using Tivoli Scheduler.
• Done appropriate unit-level testing of work products and the management of the review process for the Ab Initio deliverables.
• Prepared the Unit test cases.

Confidential

Abinitio Developer

Environment: Ab Initio, oracle and Unix

Responsibilities:

• Involving in developing the codes as per requirements.
• Creating the Ab Initio graphs, utilizing Rollup, Join, Sort, Replicate, Partition components to speed up the ETL process.
• Working in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like checkin and checkout are using for this purpose.
• Performing Transformations of source data with Transform Components.
• Tuning of Ab Initio Graphs for better performance.
• Running the jobs in Development Environment.
• Supported with QC team and UAT team to resolving the issues.
• Involved in migrating the code from Development Environment to UAT Environment.
• Done appropriate unit-level testing of work products and the management of the review process for the Ab Initio deliverables.