PROFESSIONAL SUMMARY:

• Seven years of experience in the Analysis, Design and Development of Data warehousing solutions and in developing strategies for Extraction, Transformation and Loading (ETL), mainly using AbInitio
• Expertise in AbInitio (ETL) architecture, data modeling, design and integration with hands on expertise in designing, developing and delivering ETL solutions
• Expertise in UNIX, shell scripting and data integration/migration
• Extensively worked with AbInitio GDE, Co - operating System, Data Manipulation Language (DML), PDL and Conductlt Plans
• Designed, developed, and implemented ETL for large decision support systems (DSS) and Data Warehousing projects
• Experience in developing complex graphs from the variety of components in Ab Initio and to develop generic code enabling re-usage
• Extensive experience with Ab Initio Metadata hub and data lineage and DQE
• Relational, Dimensional and Multidimensional data modelling.
• Excellent technical, analytical, and management skills focused on delivering optimum solutions and providing quick return on investment
• Good experience in written and vocal communication towards business stake holders. Committed team player with good analytical skills
• Exposure to several Design, GUI, Analytical and Reporting tools - SAS EG, MS-SQL and Cognos
• Experience in Designing Modular, Reusable data structures and processes for data integration, migration and conversion
• Database experience using Oracle 10g/9i, SQL Server, DB2 and knowledge in managing Conceptual, Logical and Physical Data Models for DB2 EEE
• Extensively worked on DB2,MS-SQL and stored procedures, having high proficiency in database Querying, writing complex SQLs and Data Analytics
• Work on Go Live activities as per the prepared Implementation plan and manage any issues related to functionalities, user interface, performance, etc. that may arise
• Experience in Banking Domain especially in marketing area
• Trained on Mongo-DB and Good Understanding of Hadoop (HDFS + MapReduce) and its ecosystem frameworks like SQOOP, Flume, HIVE, Pig and Oozie
• Project Management experience in handling multiple applications across multiple environments and managing challenging complex and time critical projects and mentoring development teams
• Exposure to QueryIt, ExpressIt and Control Centre

TECHNICAL SKILLS:

ETL Tools: Ab Initio GDE 1.15/2.15, 3.1.5.3, 3.2.2

Analytical Tools: SAS EG, SSIS, Cognos

Languages: SQL, Shell Scripting, SAS

Operating System: UNIX, Linux, Windows

Databases: Oracle 9i/10g, DB2 v8/10, DB2 EEE, MS-SQL

Business Modelling: MS Visio

Scheduling Tools: CA7

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Onsite DW ETL Lead and Data Analyst

Responsibilities:

• Review existing SAS solution, read SAS programs and perform data analysis using SAS-EG and participate in requirements elicitation.
• Analysis of business requirements, recognize the application level design change. Take inputs from the business team to understand the overall architecture and the output deliverable expected.
• Analyze metadata using DQE environment and Express It. Set data lineage.
• Work with data modelling team to come up with suitable data mart design.
• Work with Business analyst to come up with detailed mapping that adheres to business needs.
• Create a high level design for the better understanding of the solution by the business.
• Work on the detailed level design, review it and get the necessary approvals for the implementation.
• Perform code review and peer review to identify any issues/bugs within the system.
• Review the solution with business and in corporate continuous improvements to the design based on feedback.
• Work on the issues/defects, identify the cause and resolve them at early stage of the cycle there by saving the effort and time of the project.
• Co-ordinate migration and Implementation of the Code between environments to maintain code versions and promotion of the correct code.
• Participate in and prepare content for KT sessions, document the understanding, take on Shadow Support.
• Provide warranty support to the Production Support team which involves co-ordination between various teams -the business, server administrators, testing teams.

Technology Used: Ab Initio 3.2.5.2, UNIX/linux, DB2, MS-SQL server, Oracle, PDOA, SAS and SAS-EG

Confidential

Onsite DW ETL Lead and AbInitio Lead

Responsibilities:

• Analysis of data present in different systems to bring out the various relationships/hierarchy required.
• Analyze business requirements to identify business rules and develop technical solutions.
• Work on the high-level and detailed design and the loading of data into the mart.
• Estimating the effort for the project including and excluding Ab Initio.
• Data quality checks, standardization and recommendations.
• Onsite, offshore Coordination, design, reviews of the reports and enhancements.
• Re-design and deliver next phase of data based on business inputs.
• Third Party Relationship Oversight (bridge between team, Client and third party vendors) and External Network Connectivity (for data transfer)
• Interaction with multiple project and team members involving the cross-platform development and testing (Salesforce, abinitio, unix, Replication Junction, sql server, oracle)
• Conducted code reviews, performance testing and tuning of the ETL code for optimization.
• Developed reusable ETL code - graphs, plans, and transformations.
• Mentor and scale all junior members in the team and review their work in a periodic manner.

Technology Used: Ab Initio 3.2.5.2, UNIX/linux, DB2, CA7, Oracle, PDOA

Confidential

Technology Analyst and Offshore Team Lead

Responsibilities:

• Analyze requirements to identify business rules and develop technical solutions.
• Perform effort estimation for the work done. Track the progress of project and report the project status on weekly basis to client PM.
• Work on the design and code Abinitio graphs, conductlt plans for implementing all the transformation logic.
• Mentor the development team for effective deliverables
• Responsible for all pre-ETL tasks upon which the Data Warehouse depends, including managing and collection of various existing data sources
• Involved in developing UNIX Korn Shell wrappers to run various Ab Initio Scripts.
• Involvement in Unit/Integration/End to End/UAT testing and make sure complete product goes to Production with no bugs.
• Analyze, design and propose effective design approaches for DW design
• Automation of various processes though shell script to maintain the stability of the system
• Playing a major role in communicating the progress on a timely manner to the stakeholders. Status reports preparation, arranging status meetings as required.
• Raising early red flags to the stake holders and management in case of issues or during any forecasted problems to minimize the risk, work on the resolution plan and act immediately.
• Coordination between numerous teams- development teams, testing team, admin teams, business stake holders, scheduling team, for various applications.
• Code walk-through on all proposed changes, conference with users concerning all modifications and impact analysis.
• Knowledge Transfer to new players and bring them up to speed for numerous applications.
• Documentation for the applications, maintain repository and keep track of the versions.
• Creation of CA7 jobs and design their dependencies.

Technology Used: Ab Initio 3.2.5.2, UNIX/linux, DB2, CA7, MS-SQL, Oracle, PDOA

Confidential

AbInitio ETL Developer

Responsibilities:

• Developing ETL code and Unix scripts/ Conduct LT plans
• Used components like run program and run sql components to run UNIX and SQL commands in AB Initio. Also used the components like filter by expression, partition by expression, replicate, partition by key and sort Components.
• Create Summary tables using Rollup, Scan & Aggregate.
• Created UNIX shell scripts to automate and schedule the jobs.
• Created the migration scripts, test scripts for testing the applications, creating and supporting the Cognos reports.
• Detecting the nature of the defects/bugs in question, isolating the cause of the failure through root cause analysis. Resolving of the issues in timely manner without affecting the delivery schedules.
• Interacting with Onsite coordinator/ Client for understanding and analyzing requirements
• Designing and preparing design documents viz., High level design, Low level design and unit test cases
• Work on CA7 Scheduler and design the entire flow of job runs
• KT to Production support
• Participate with PSO team in warranty support

Technology Used: Unix/Linux, DB2, sql servers, Ab Initio GDE 3.1.5.3.