SUMMARY

• 11 years of IT experience in Data Warehousing and Business Intelligence platforms.
• Solid understanding of ETL design principles and good practical knowledge of performing ETL design processes using ETL Tools like Informatica PowerCenter and SSIS.
• Expertise in ETL design, development and Testing.
• Experience in Data Analysis and providing solutions.
• Experience in ETL tool Informatica Data Transformation, Informatica Developer (BDM/IDQ) and Informatica Power Exchange, MSBI Tools (SSIS, SSRS and SSAS), UNIX shell scripting and Informatica Cloud.
• Experience in working with databases such as Oracle, Greenplum, DB2, MS SQL Server and Mainframe JCL’s
• Develop and maintain physical and Logical data models using ERWIN.
• Experience in database programming language like PLSQL, T - SQL and writing complex SQL statements
• Experience in leading projects from requirements to warranty support
• Experience in Managing offshore team and Analyze and share the work with developers at offshore.
• Thorough understanding and involvement in Software Development Life Cycle (SDLC) which includes requirement gathering, designing, implementing, warranty support and testing.
• Experience in preparing Blueprints, High Level Designs and Low-Level Designs.
• Performed Proof of Concepts for IDT (Informatica Data Transformation) and Powercenter webservices and provided recommendations.
• Solid working experience in Insurance, Finance, Banking and Retail domains.
• Supported Sales teams by providing power point presentations on Informatica DT, Informatica Webservices and data masking transformation.
• Resourceful, creative problem-solver with proven aptitude to analyze and translate complex customer requirements and business problems and design/implement innovative custom solutions.
• Experience in creating unit test plans, system test plans and integrated test plans and conduct testing in different environments for various business intelligence-based applications
• Excellent team management, leadership, communication and interpersonal skills. Managed small to medium size teams and have delivered many complex projects successfully.
• Good knowledge on Scheduling tools like Autosys, control M and TWS
• Worked on projects utilizing AWS glue and S3
• Have experience using Jenkins for Continuous integration and Continuous deployment
• Excellent communication skill.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.1/8.6/8.5/10.2, Informatica Data transformation 9.1, MSBI Tools(SSIS,SSRS,SSAS), Informatica Cloud and Informatica Developer (IDQ), Informatica Power Exchange

Operating Environment: Windows 7/95/98/NT/2000/XP/Server 2008/2010

Tools & Utilities: Oracle Clients (TOAD, etc.), Putty, Clear Case, IBM Clear Case, WinSQL, SQL Developer, Harvest, Erwin, SSMS, Jenkins

Databases: Oracle, DB2, MS SQL Server, Mainframes, Green Plum

Languages: PL/SQL, Unix shell scripting, Mainframe JCLs

Scheduler: Autosys, Control M, TWS

Graphics: MS-Visio, MS PowerPoint.

PROFESSIONAL EXPERIENCE

Confidential

DW Developer

Responsibilities:

• Provide Estimation to baseline the size and schedule of the development work
• Gather data to analyze, design, develop, troubleshoot and implement business intelligence Applications
• Build conceptual, logical, and physical data models using Erwin which adopts Kimball frameworks using 3NF and de-normalized dimensional design philosophies
• Create tables, views, stored procedures, and functions in the oracle database as well as maintaining the DDL scripts.
• Build Informatica ETL mappings based on the technical requirements and design using Informatica Powercenter and Oracle DB
• Create unit test plans conduct testing in different environments for data warehousing projects.
• Perform data profiling and data quality checks; a build data relationships.
• Implement best practices and standards for data management/conversion project.
• Convert some of the existing code into oracle data warehouse which follows traditional star schema design philosophy, using SQL to translate programs.
• Conduct performance tuning of PowerCenter mapping if there are any bottlenecks or performance issues in the ETL processes.
• Research and troubleshoot, using tracing techniques in both SQL & Informatica.
• Create and maintain tables, views, stored procedures, triggers and functions in oracle database in order to meet specific technical design.
• Contribute to the creation / maintenance of a high performing data warehouse which is the core system for various reporting and analytical needs, applying advanced skills of dimensional data model design.
• Recommend ways to improve data reliability, efficiency, and quality.
• Ensure systems meet industry best practices and business, security, privacy, and retention requirements.
• Proactively identify the risks involved in the project if any and communicate those to the management along with other major project updates on a timely manner during the entire life cycle of a project.
• Reporting of the status of assigned tasks to project manager

Tools, DBs and languages: Informatica Powercenter 10.1, Informatica Developer, Oracle, Erwin

Confidential

Technology Lead Madison, WI

Responsibilities:

• Gather and understand requirements from business partners and business analysts and convert them into low level design and technical specifications.
• Responsible for partnering with requirements team to understand expected functional and non-functional behavior, and to verify that proposed solution design meets those requirements
• Provide Estimation to baseline the size and schedule of the development work
• Gather data to analyze, design, develop, troubleshoot and implement business intelligence Applications
• Analyze data in Oracle, DB2 or Greenplum and provide solution.
• Create unit test plans, system test plans and integrated test plans and conduct testing in different environments for various business intelligence-based applications.
• Facilitate/lead reviews (walkthroughs) of technical specifications and program code with other members of the technical team.
• Team coordination to manage the expectations with MFT (Managed File Transfer) and EDI (Electronic Data Interchange) teams.
• Implementation of ETL solutions using ETL tool Informatica PowerCenter and databases as Oracle, Db2 and Greenplum and provide warranty support to the existing active applications in production.
• Manage offshore team - Analyze and share the work with developers at offshore. Review their deliverables and provide updates to the project team daily.
• Working closely with release management team, DBAs, Data modelers, Data Architects and testing team during design, development, testing, production implementation and support for the project.
• Performance improvement & tuning of Informatica mappings.
• Create necessary documentation and Update the project documentation based on Change Requests and JIRA
• Triage the Production issues and work on the code fixes
• Participate in 24x7 rotational on-call responsibility
• Proactively identify the risks involved in the project if any and communicate those to the management along with other major project updates on a timely manner during the entire life cycle of a project.
• Utilized Jenkins for Continuous integration and Continuous deployment
• Reporting of the status of assigned tasks to project manager

Tools, DBs and languages: Informatica Powercenter 9.6/10.2, Oracle, Greenplum, DB2, Mainframe, Autosys, Informatica Cloud, Jenkins

Confidential

Technology Lead

Responsibilities:

• Gather and understand requirements from business partners and convert them into low level design and technical specifications.
• Develop and maintain physical and Logical data models using Erwin
• Provide Estimation to baseline the size and schedule of the development work
• Create unit test plans and system test plans and conduct testing in different environments.
• Manage offshore team - Analyze and share the work with developers at offshore. Review their deliverables and provide updates to the project team on day to day basis.
• Implementation of ETL solutions using ETL tool SSIS and databases as MS SQL Server and provide warranty support to the existing active applications in production.
• Analyze data in MS SQL Server and provide solution.
• Provide support to business partners to develop reports using SSAS and SSRS
• Implementation of non-functional requirements using Unix shell scripting
• Reporting of the status of assigned tasks to project manager

Tools/DBs: MSBI Tools, MS SQL Server, Oracle, UNIX shell scripting, DB2, Erwin, Autosys, SSMS

Confidential

Lead ETL Developer

Responsibilities:

• Gather and understand requirements from business partners and convert them into low level design and technical specifications.
• Develop and maintain physical and Logical data models using Erwin.
• Provide Estimation to baseline the size and schedule of the development work
• Create unit test plans and system test plans and conduct testing in different environments.
• Design, code, test, debug and document programs and ETL processes.
• Implementation of ETL solutions using ETL tool SSIS and databases as MS SQL Server and provide warranty support to the existing active applications in production.
• Provide support to business partners to develop reports using SSAS and SSRS
• Analyze data in MS SQL Server and provide solution.
• Implementation of pre and post processing using Unix shell scripting

Tools/DBs: MSBI Tools, MS SQL Server, Oracle, Unix Shell scripting, Erwin, Control M, SSMS