SUMMARY

• Over 15+ years of IT experience in IT and implementing DWH Solutions for Fortune 500 companies. Extensive experience in the Data Warehousing implementations for Healthcare, Retail, Banking, Pharmacy and Insurance Industries
• Performing the roles of Tech Architect, Team lead, Designer and developer for different projects with his strong ETL skills and Data warehouse concepts.
• Executed various projects in executing end to end life cycles that covers Requirements gathering, Design, Development, Deployment, Support and mentoring activities.
• Data Warehousing: 15 years of Data Warehousing experience using Informatica Power Center 9.5.1, 8.X/ 7.1.1/7.1.2 , Power Mart 6.1/5.1.1/5. x/4.7, Warehouse Designer, Power Exchange, Power Analyzer, ETL, Data mart, IBM Data stage 7.5/8.0/8.1/8.5 , OLAP, OLTP, Autosys, Control M.
• Experience with reporting tools Splunk enterprise 6.5.2, Splunk DB connect 2.3.1
• Database: Strong working experience using Oracle 10g/9i/8i/8.0/7.0, DB 2 8.0/7.0/6.0 , MS SQL Server 2008/2005/2000/7.0/6.0 , Teradata 12.1.13/V2R5/V2R4/V2R3, MS Access 7.0/2000, XML, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000.
• Data modeling using ErWin tool.
• Extensive experience in Designing, Compiling, Testing, and Scheduling and Running Data Stage jobs. Expertise in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon.
• Good communication skills, technically competent and highly motivated towards working for the goals of the project/organization.
• Experience in integrating complex data file formats such as .TXT, XML and Mainframes
• Experience in Teradata utilities in Fast Load, Multi Load, Teradata Parallel Transporter (TPT) and Fast Export and query tools (BTEQ) and Explain Plan in Teradata.
• Experience in writing UNIX, Python 2.7 shell scripts, DOS.
• Performed debugging, troubleshooting, monitoring and performance tuning using Data Stage.
• Experience in implementing the complex business rules by creating re - usable transformations, developing complex Mapplets and Mappings.
• Experience in Tuning performance of an Informatica session at mapping level and session level.
• Extensively worked on Informatica workflow manager and Monitor tools to load data.
• Involved in writing Test Plans, Test Scenarios, Test Cases and Test Scripts and performed the Unit, Integration, system testing and User Acceptance Testing Coordinating with the client and the offshore team
• Interacted extensively with clients to gather requirements and perform analysis and design to meet end user requirements.
• Self-driven to accomplish goals and meet deadlines. Provided 24/7 production support.
• Highly motivated team player with ability to lead, manage and work in all environments to meet deadlines.
• Experience in working with onsite offshore model
• Mentoring developers and perform code reviews on Data Stage jobs to ensure jobs adhere to coding standards and framework

TECHNICAL SKILLS

ETL Tools: Data Stage 8.5/7.5, Informatica 9.5.1/8.6.1/7.1.5/6.1/5 x

Reporting tools: Epic RWB, Splunk Enterprise 6.5.3, Splunk DB Connect 2.3.1

Databases & Tools: IBM DB2, Oracle (10g/9i), SQL Server 2005,Teradata V2R6/V2R5

Languages: PL/SQL, C,C++

Operating Systems: Sun Solaris, Linux, IBM AIX (4.0/5.x), Windows XP/ 2000/2003/2007.

Scheduling: DAC, Control M, Autosys

Scripting: Korn Shell Script, Python 2.7

PROFESSIONAL EXPERIENCE

ETL and RWB Lead/Programmer Analyst

Confidential, OR

Responsibilities:

• Work with Business and all other functional areas.
• Designing High level design doc and Technical design docs
• Development / Coding. Implementing the code in Informatica
• Build data extracts using Splunk DB Connect for reporting
• Developed Shell scripts in UNIX.
• Doing performance Tuning.
• Scope out the work and estimate the effort required.

Environment: ETL Tools: Informatica 9.5.1, Reporting tools: Splunk Enterprise 6.5.3, Splunk DB Connect 2.3.1 Operating Systems: Windows XP/Linux Database: Oracle 10i

Confidential, OR

Responsibilities:

• Work with Business and all other functional areas.
• Designing High level design doc and Technical design docs
• Development / Coding. Implementing the code in Informatica
• Build Epic RWB reports, templets
• Developed Shell scripts in UNIX.
• Doing performance Tuning.
• Mentoring the onsite development team.
• Scope out the work and estimate the effort required.

Environment: ETL Tools: Informatica 9.5.1, Reporting tools: EPIC Reporting Work Bench 2014 Operating Systems: Windows XP/Uinx Database: Teradata version 12.00.0241 , Oracle 10i

Confidential, MN

Responsibilities:

• Work with Business and all other functional areas.
• Requirements gathering
• Data profiling and data modeling
• Designing data mapping sheets
• Designing High level design doc and Technical design docs
• Development / Coding. Implementing the code for the interfaces.
• Developed Shell scripts in UNIX.
• Doing performance Tuning.
• Mentoring the offshore team.
• Doing Impact Analysis for the issues faced.
• On site coordinator for the Off shore communication.

Environment: ETL Tools: IBM Information server 8.1, Operating Systems: Windows XP/Uinx Database: Teradata, Oracle 10i, DB2, SQL Server

Confidential, AR

Responsibilities:

• Work with Business and all other functional areas.
• Informatica & DAC Servers installation and Setup on windows servers
• Designing High level design doc and Technical design docs
• Development / Coding. Implementing the code for the interfaces
• SDL and SIL mapping customization
• Developed Shell scripts in UNIX.
• Build Teradata load scripts for SIL mappings.
• Doing performance Tuning.
• Mentoring the offshore team.
• Scope out the work and estimate the effort required.
• On site coordinator for the Offshore communication.

Environment: ETL Tools: Informatica 8.6.1 HF6 with DAC 10.1.3.4.1 , OBIA with Universal Adaptors Version 7.9.6.1Operating Systems: Windows XP/Uinx Database: Teradata version 12.00.0241 , Oracle 10i

Confidential, AR

Responsibilities:

• Work with Business and all other functional areas.
• Design: Designing High level design doc and Technical design docs
• Development / Coding. Implementing the code for the interfaces.
• Fixing of bugs in the Relase 1.5 Interfaces.
• Developed Shell scripts in UNIX.
• Doing performance Tuning.
• Mentoring the offshore team.
• Doing Impact Analysis for the issues faced.
• Scope out the work and estimate the effort required.
• On site coordinator for the Offshore communication.

Environment: ETL Tools: IBM Information server 8.1, Informatica, DACOperating Systems: Windows XP/Uinx Database: Teradata, Oracle 10i DB2

Confidential, AR

Responsibilities:

• Work with Business and Requirement gathering.
• Design: Designing High level design doc and Technical design docs
• Development / Coding review..
• Fixing of bugs in the existing code.
• Developed Shell scripts in UNIX.
• Doing performance improvement.
• Mentoring the offshore team.
• On-site coordinator for the offshore communication.

Environment: ETL Tools: IBM Information server 8.1, Operating Systems: Windows XP/Uinx Database: Teradata, Oracle 10i DB2

Confidential, IL

Responsibilities:

• Requirement Gathering for enhancements
• Development / Coding. Implementing interfaces.
• Fixing of bugs in the existing code.
• Developed Shell scripts in UNIX.
• Doing performance improvement.
• Mentoring BI team about the GTP data flow.
• Doing Impact Analysis for the issues faced.
• Coordinating with the Country users, end users to solve the issues faced by them.
• On-site coordinator for the offshore communication.

Environment: ETL Tools: Ascential DataStage 7.5.1, Operating Systems: Uinx Database: Oracle 9i

Confidential

Responsibilities:

• Development / Coding. Implementing the Purge interfaces for different countries.
• Fixing of bugs in the existing code.
• Developed Shell scripts in UNIX.
• Doing performance improvement.
• Mentoring Operations team to resolve issues related to Daily operations.
• Doing Impact Analysis for the issues faced.
• Co-ordinating with the Country users to solve the issues faced by them.

Environment: ETL Tools: Ascential DataStage 7.5.1, Informatica 7.1.4, DACOperating Systems: Uinx Database: Oracle 9i

Confidential, CA

Responsibilities:

• Requirement analysis
• High Level Design
• Technical Design
• Development / Coding
• Code review
• Support for Testing and performance tuning.

Environment: ETL Tools: Ascential Data Stage 7.5.1Operating Systems: Uinx Database: Oracle 9i, Teradata

Senior software Engineer

Confidential

Responsibilities:

• Requirement analysis
• High Level Design
• Technical Design
• Development / Coding
• Code review
• Customer interaction
• Support for Testing and performance tuning.
• Assigning tasks to Team members
• Effort Estimation
• Scheduling worflows

Environment: Informatica Power Center 6.2.2, 7.1.1, 7.1.4, Linux, Oracle 8i/9i

Software Engineer

Confidential, Florida

Responsibilities:

• Understanding Requirements
• Development / Coding
• Mappings implementation. implemented Mandatory Checks, Date Filed Checks and Number Filed Checks
• Used different transformations.
• Performance tuning.

Environment: Informatica Power Center 6.0, Windows 2000 Server, Oracle 8i

Confidential

Responsibilities:

• Understanding Requirements
• Development / Coding
• Mappings implementation. implemented Mandatory Checks, Date Filed Checks and Number Filed Checks
• Used different transformations.
• Performance tuning.

Environment: ETL Tools: Informatica 5.0, Windows 2000 Server, SQL server

Confidential

Responsibilities:

• Understanding Requirements
• Development / Coding
• Mappings implementation. implemented Mandatory Checks, Date Filed Checks and Number Filed Checks
• Used different transformations.
• Performance tuning.

Environment: Informatica 5.0, Windows 2000 Server, SQL server