PROFESSIONAL SUMMARY:

• Tech Lead/ BI Developer with 11+yearsof experience developing large - scale Data Warehouse and Client/Server Applications, including, Data Migration, Data Modeling, Business Process, Design and Development, Integration and Testing, Database Programming, SDLC, Project Management and Production Support.
• Experience in Retail, Insurance, HealthCare, Banking andFinancialdomains.
• Experience in complete Software development life cycle (SDLC) with a strong background in Design/Modeling, database development and implementation of various business intelligence and data warehouse / Data mart’sprojects that covergathering Business Requirements, Development, Implementations and Documentation.
• Strong work experience with Business Users to analyze the business process model and made necessary changes to schema objects to cater users reporting needs.
• Extensive experience in ETL methodologies for supporting Data Migration, Data Exchange, Data Transformation using Ab Initio 3.6.x, Informatica Power Center v9.x/8.x/7.x.
• Experience in developing graphs/Plans in Ab Initio GDE and maintaining code in EME.
• Implemented Ab Initio Naming standards and Best Practices for the full life cycle of data warehouse projects, right from design to development through go-live and support
• Sound knowledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles - Star schema, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization
• Experience in integration of various data sources like Oracle, DB2, copybooks, and SQL Server, Teradata, Flat Files, and Excel.
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, and Type 3) to keep track of historical data.
• Extensively used various Performance Tuning techniques to improve the performance for data loads.
• Experience interacting with Business users and Architecting high level requirements, high level design and detailed level design documents.
• Strong Quality Assurance and debugging skills in ETL Process.
• Solid understanding of OLAP concepts and challenges with large sets of data.
• Proficient in Toad, SQL navigator, and UNIX Shell Scripting.
• Created High level Technical Specification,User level requirementdocumentation and Low level design procedural documents for the ETL process and standards.
• Expertise in Unit testing of mappings, sessions and created documents such as Test Case, Test script document, Test result document.
• Expertise in different types of loading like Normal and Bulk loading challenges. Involved in Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Experience in SSIS of MS SQL Server tools.
• Expertise in production support activities like fixing the abends, root cause analysis for recurring abends, working on User queries, Ab Initio Maintenance.
• Involved in helping the reporting team with Business Objects reports and data issues.
• Good knowledge and understanding of Scheduling tool Autosys, CA7.
• Versatile team player with excellent analytical, communication and presentation skills to interact with team members and business users.
• Provided production support in an on-call rotation in 24x7.
• Quick learner and adaptive to new and challenging technological environments
• Excellent communication, presentation, interpersonal skills and leadership qualities.
• Recently started working on Hadoop and Big data technology.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.X, 8.6.1, Ab Initio 3.6, SSIS

Data Modelling: Dimensional Data Modelling, Star Schema Modelling, FACT and Dimensions Tables

Databases: Oracle 9i/8i, DB2, SQL Server

Reporting Tools: BUSINESS OBJECTS XI R2 - Designer, Desktop Intelligence. Trained in Cognos reporting tool

Programming: SQL, Unix Scripts

Environment: Windows/2000/XP, Unix, Citrix

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Ab Initio Developer

Responsibilities:

• Work with business clients to deliver strategic and tactical solutions
• Developed Ab Initio graphs using different components for Extracting, Loading and Transforming external data into data mart using components like Reformat, Join, Normalize etc.
• Involved in end user support and bug fixes and tuning the code for better performance.
• Identify, diagnoses, and resolves problems for users and communicates solutions to end-users.
• Translates business requirements into functional specifications for the IT development teams, manages changes to such specifications, and educates the IT organization on the direction of the business.
• Documents existing process in order to evaluate and define new IT solutions and implementation process.
• Posses understanding of technical trends and uses this knowledge to bring solutions to business groups supported to enhance the enterprise’s competitive advantage.
• We are moving to Data Lake environment using Big Data. As part of this project I am working on Hadoop, Hive and big data environment.

Environment: Ab Initio 3.2.6, DB2, Oracle, CA7, shell scripting

Confidential

SSIS Developer

Responsibilities:

• Served as SSIS developer taking the ownership of deliverables for all the graphs under 2 LOBs.
• To gather, analyze requirements and mapping, prepare Functional as well as Technical design for one module.
• To advice the changes in design for performance optimization
• To build the SSIS packages for loading the Staging tables from source systems and again loading final tables form these staging tables as per the mappings provided for different source systems involving various Calculations, Default and complex transformations.
• To unit test the code and implement the changes for optimum performance when required.
• To deploy all the packages of 3 LOBs and create the jobs for these packages on SQL server 2005.
• To package and promote the code.

Environment: SSIS, SQL server 2005, Windows, CA7, shell scripting

Confidential

Informatica Developer

Responsibilities:

• Involved in deriving Technical Specifications based on Functional Specifications.
• Developed and tested ETL components using Informatica Power Center.
• Worked on Informatica Designer tools like Source Analyzer, Transformation Developer, and Mapping Designer.
• Involved in creating Tasks, Sessions, Workflows and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
• Worked extensively on Lookup, Router, Filter, Aggregator, Expression, Stored procedure, Sequence Generator and Update Strategy Transformations.
• Worked with mapping parameters and variables to load data from different sources to corresponding database table.
• Performed testing of the developed components and involved in System testing and UAT support..
• Dealt with mappings that in corporate Incremental loads, Constraint Based Loading.
• Worked on PowerCenter Versioning (Check-in, Check-out), Querying to retrieve specific objects, maintaining the history of objects.
• Involved in end user support and bug fixes and tuning the code for better performance.
• Responsible for configuration control using VSS

Environment: Informatica Power center 8.1.3, Oracle 9i, PL/SQL, Flat Files, UNIX

Confidential

Data Warehouse Developer/Analyst

Responsibilities:

• Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Prepared documentation such as Functional Specifications document, Technical or ETL Specifications document,
• Worked on Data Analysis, Mapping, Identify Data Quality issues, Data Cleaning, Data validation and Loading.
• Performances Tuning & recommending tuning strategies in Informatica Mappings, Sessions, Workflows and sending automated email on errors, failures, success of the sessions/workflows.
• Hands on experience leading all stages of system development efforts, including requirement definition, design, architecture, testing, support and administration.
• Expertise in developing and running Informatica Mappings, Sessions/tasks, Workflows, Worklets, and Batch processes on Informatica server.
• ETL Architect, Define ETL Standards, ETL process, batch processing, bulk loading, initial data capture, change data capture, implementation process.
• Create & Perform Unit & Integration Test Cases, UAT Test Case Review, Migration to Production.
• Worked on Informatica Designer tools like Source Analyzer, Transformation Developer and Mapping Designer.
• Involved in creating Tasks, Sessions, Workflows and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
• Involved in exhaustive testing of the developed components.
• Involved in end user support and bug fixes and tuning the code for better performance

Environment: Informatica Power center 8.1.3, Oracle 9i, SQL, Unix

Confidential

Teradata Developer

Responsibilities:

• Developing and testing database queries and SQL tuning.
• Extensive use of Teradata Utilities ý Multiload and BTEQ .
• Involved in data validation and requirement walk through.
• Developed BTEQ scripts to extract data from the detail tables for reporting requirements

Environment: Teradata and Unix