PROFESSIONAL SUMMARY:

• 10 years of IT experience.
• 7.5 years of data warehousing experience.
• Strong domain knowledge of Banking and Investment Industry.
• Worked as Senior ETL Lead and Business Analyst for over 7 years
• Onsite lead in US and mentored multiple offshore and onsite teams.
• Expertise in ETL and Data Modeling tools in data warehousing projects.
• Expertise in Informatica PowerCenter Mapping & Workflow Designer (8.6/9.1) for over 9 years.
• Extensive Hands on experience in Teradata 13.0/14.0 DBMS.
• SQL / BTEQ scripting expertise for 5+ years.
• 7 years of experience in Unix shell scripting
• Extensively worked with large Databases with terabytes of data in Production environments.
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, training, implementation and post - implementation review.
• Experienced in Data Profiling and Requirement gathering and Business /Technical Specific Documentation
• Experience in Dimensional Data Modeling & Design for building Enterprise Level Data Warehouse
• Involved in Troubleshooting database problems, Performance tuning, partitioning and SQL Tuning.
• Worked in Support/ enhancement projects with expertise in scheduling tools like Autosys/WLM.
• Worked on Teradata Unity for 1 year.
• Worked on BI reporting tools like Cognos 7.0 and Microstrategy for 8 months
• Database Hands on Experience with DB2, Oracle, Mainframe and SAP for short terms.
• Worked on complex Informatica mappings involving Normalizer transformations, Slowly Changing Dimensions (Type2) with dynamic lookups, unions, update strategy, Workflow Partitioning, etc
• Proficient in understanding business processes / requirements and translating them into technical documents.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental loads using Teradata BTEQ scripts to provide data for Data Warehouse.
• Experienced in environments requiring direct customer interaction during specifications, design, development and product implementation phases.
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts and execution of test plans for loading the data successfully into the targets.
• Expertise in developing Teradata BTEQ to implement the business logics of database in Teradata.
• Having greater ability to upgrade to new technologies. Flexible and adaptive to any work environment.
• A Team Player with good communication, analytical, verbal and writing skills.

TECHNICAL SKILLS:

Operating Systems: Windows 9X, Windows XP, Windows 2000, Windows 7, DOS, UNIX

Languages: Markup languages, C, C++, UNIX

Packages: MS-Office(2000/XP), MS-Access

DBMS: Teradata 13 / 14.0, Oracle 10/11g, DB2, SQL 2005

Business Intelligence: Informatica 8.x, Informatica 9.0, Cognos 7.0, Microstrategy

Miscellaneous: Unix Shell scripting / WLM Scheduler / Autosys / BTEQ / SQL & PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Owings Mills, MD

Senior ETL Developer

Responsibilities:

• Enhancements to IDM for creation of Individual Investor Metrics which stands as a single source to obtain metrics for Individual Investors and will include metrics for both RPS and Retail Metrics+.
• Core DBMS involved - DB2 ; Source formats include VSAM /COBOL/ Flat files
• Worked closely with Business Analysts for formulating the requirements and data mapping documents.
• ETL Developer Lead - coordinate design / build efforts for enhancement work on EDL.
• Design and Coding in Informatica 9.1, analysis using DB Visualizer 9.0, UNIX shell scripting (creating .sh & .lst files).
• Unit and Systems Integration testing including test case preparation and test runs.
• Scheduling jobs - creation of jil files in Autosys.

Environment: Informatica PowerCenter /Power Exchange 9.1.0, DB2,, UNIX, Autosys scheduler

Confidential, Richmond, VA

Senior ETL Lead

Responsibilities:

• Co-ordination with regional warehouse teams for 6 regions for monthly production load process into EDL. Working closely with business and functional users for enhancement requirements and documentation
• Onshore Team lead - managing offshore team of 4 members.
• Core DBMS involved - Teradata 14.0 ; Core Source systems involved Teradata, Oracle, DB2, COBOL/ Flat files
• Worked closely with Data architects for creation of E-R diagrams and data model updates ( CA Erwin / Toad modeling tools)
• ETL Developer Lead - coordinate design / build efforts at onsite for enhancement work on EDL.
• Design and Coding in Informatica 9.1 Mapping Designer, Teradata Utilities, Unix shell scripting (creating .sh & .lst files).
• Unit and Systems Integration testing including test case preparation.
• Use various business transformations inside the scripts and manage platform updates for active data.
• Code enhancements with respect to dead codes and various bugs.

Environment: Informatica PowerCenter /PowerExchange 9.1.0, Teradata 14.0, BTEQ / SQL, UNIX, WLM scheduler

Confidential, Richmond, VA

ETL Developer Lead

Responsibilities:

• Co-ordination with internal and external source system teams (business and functional) to gather business needs on new campaigns through digital/ non-digital network.
• Assist Data Architects in Enterprise Data warehouse design for storing optimized offers.
• Onshore Team lead - managing offshore team of 6 members.
• ETL Developer Lead - coordinate design / build efforts for first production move of code.
• Design and Coding in Teradata Utilities, Informatica, SAS codes, UNIX; Core Source systems involved Teradata, DB2, COBOL/ Flat files.
• Handling and routing user queries during real time updation of production data in two main servers.

Environment: Teradata 14, Informatica PowerCenter /PowerExchange 9.1.0, BTEQ, DB2, UNIX, Autosys

Confidential, Charlotte

ETL Developer Lead / Business Analyst

Responsibilities:

• Co-ordination with the real time Offers management team to gather business needs on new campaigns and documentation of Business Specific templates.
• Prepare Technical and Functional/ Nonfunctional design specification for Clients
• Onsite Team lead - managing offshore team of 4 members.
• ETL Developer Lead - coordinate design / build efforts at onsite and offshore
• Design and Coding in MLOAD, TPump, FAST EXPORT scripts
• Implementation of Teradata Unity for bank.
• Review & Unit / Systems Integration testing including test case preparation.
• Use various business transformations inside the scripts and manage real time trigger process for active data.
• Code enhancements with respect to dead codes and various bugs.
• Performing data profiling to provide high quality of data to business users and customers.
• Performance tuning in Teradata.
• Handling and routing user queries during real time updation of production data in two main servers.

Environment: Teradata 13.0/14.0, Informatica PowerCenter /PowerExchange 9.1.0, BTEQ / SQL, Unix, Autosys

Confidential, Richmond

Business Analyst / ETL Developer Lead

Responsibilities:

• Worked as onsite team lead for Off-shore/ On-shore Co-ordination setting, delegating and mentoring 2 members at onsite.
• Business Analyst role for Pharmacy claims extraction
• Prepare Technical and Functional design specification for Clients.
• Worked closely with Data architects for creation of E-R diagrams and data model updates ( CA Erwin / Toad modeling tools)
• RDBMs involved - Teradata (12/13.0) / Oracle 11g
• Design and Coding in Teradata BTEQ scripts, Informatica and Unix
• Leading a team of 3 offshore ETL developers and 1 offshore technology analyst - task allocation to team members, preparing status reports, maintaining issue tracker, effort estimation and helping the team to solve technical issues
• Adhoc system feasibility analysis and platform setup for automation for business team to aid their analysis
• Review and Testing the code against the requirements
• Code enhancements with respect to dead codes and various bugs
• Performing data profiling to provide high quality of data to business users and customers
• Performance tuning in Teradata
• Actively involved in Production Support and Maintenance phase
• Did analysis on data provided by Client and prepared Business requirement mapping and documents accordingly

Environment: Teradata 13 / Oracle 11g, Informatica PowerCenter /PowerExchange 9.1.0, BTEQ / SQL / PL/SQL, WLM, UNIX

Confidential, Richmond

Onsite Lead / ETL Developer Lead

Responsibilities:

• Co-ordination with Confidential team to gather all the business related Information for Project.
• Worked as onsite coordinator by setting, delegating and managing a group of 11 members at Offshore.
• Enterprise Data Warehouse - single source of truth for Confidential designed & modeled for Claims, Membership, Claims and Revenue data. Involved in the dimensional modeling of warehouse using ER diagrams.
• Worked closely with Data architects for warehouse architecture design/ data model creation ( CA Erwin / Toad)
• RDBMs involved - Teradata (12/13.0) / Oracle 11g
• Prepare Technical and Functional design specification for Clients.
• Detail mapping attribute documentation and extraction logic design.
• Design and Coding in Informatica 8.6 and Bteq scripts.
• Leading a team of 9 developers and 2 business analysts, task allocation to team members, preparing status reports, maintaining issue tracker, effort estimation and helping the team to solve technical issues.
• Worked on the first time mass history migration in Confidential for 6 years’ worth Capitation/ Revenue data into EDW.
• Source to target attribute mapping document preparation for all regions.
• Testing the code against the requirements.
• Review on developer’s code.
• Used various transformations inside the scripts
• Performance tuning in Teradata.
• Actively involved in Production Support and Maintenance phase.

Environment: Teradata 13 / Oracle 11g, Informatica PowerCenter /PowerExchange 9.1.0, BTEQ / SQL / PL/SQL, WLM, Unix

Confidential, Fortworth, Texas

ETL Developer Lead

Responsibilities:

• Requirement analysis and client interactions.
• Prepare Technical and Functional design specification for Clients
• Design and Coding in Informatica 8.6 and Teradata.
• Worked in Off-shore / On-shore Co-ordination setting, delegating and managing a group in Offshore
• Leading a team of 4 developers, task allocation to team members, preparing status reports, maintaining issue tracker, project effort estimation
• Worked extensively on creation of mappings and sessions
• Unit testing at onsite and offshore code review.
• Used various transformations inside the scripts
• Performing data profiling to provide high quality of data to business users and customers.
• 3 months of production environment support through job scheduling tool, Redwood. Had to provide first level issue analysis and bug identifications

Environment: SAP, Informatica PowerCenter 8.6, Redwood.

Confidential

Offshore ETL Developer

Responsibilities:

• Organized multiple requirement discussion meetings with Business Users and Onsite Leads and involved in functional and technical spec designs for ETL part.
• Involved in the Real time implementation from Requirement Analysis phase.
• Performing data profiling to provide high quality of data to business users and customers.
• Detail mapping attribute documentation and extraction logic design.
• Detailed design documentation and build
• Creating Unit Test Plans and performing Unit Test and environment setup for higher environments.
• Development of Mappings / sessions / reusable mapplets in Informatica 8.6
• Weekly Status report updates for onsite review

Environment: SAP / DB2, Informatica 8.6, UNIX

Confidential

Offshore ETL Developer

Responsibilities:

• Requirement analysis and technical design documentation
• Development of reports in Microstrategy reporting tool
• Unit testing and integration testing
• Report modification based on user requirements and enhancements
• Issue analysis and resolution
• Onsite - offshore peer review and submission to users

Environment: Microstrategy 8.0

Confidential

Offshore Developer

Responsibilities:

• Requirement analysis.
• Development of reports in Cognos 7.0 reporting tool.
• Unit testing and integration testing.
• Onsite - offshore peer review and submission to users.

Environment: Cognos 7.0