CAREER SUMMARY:

• 10 years of experience in analyzing, designing, developing, testing, implementing and maintaining ETL systems
• Experience in developing ETL applications using Informatica Power Center to integrate data into data warehouses, transactional databases, data marts, and operational data stores.
• Experience in working on data conversion/migration, data warehousing and operational data store projects.
• Experience in working in several business domains such as Health care, Manufacturing, insurance.
• Experience in Relational data modeling, Data Flow Diagrams, Process Models, ER diagrams with modeling tools like ERWIN & VISIO.
• Creating the custom Execution Plans at DAC for the custom mappings.
• Worked on Implementation, Production Support and up gradation projects.
• Proficient in SQL, PL/SQL and UNIX shell programming.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.
• Extensively Worked on BI Apps (Informatica, DAC and OBIEE).
• A self - starting, experienced and motivational hands-on leader and team player with a demonstrated track record for quality and timely results, dedication and skills to meet business challenges and a proven ability to manage, direct, motivate and mentor staff as well as peers.
• Good understanding of database, data modeling, & data warehousing concepts.
• Experience in working, coordinating, and monitoring in an Onshore-Offshore model.
• Excellent analytical, problem solving, communication, and interpersonal skills.
• Experience of working in multi-vendor engagements and expertise in coordinating and building relationships with different technical, functional and application support teams for smooth and successful business runs.
• Outstanding ability to build relationships and effectively interact with all levels of the organization. Significant experience and proficiency in preparing and delivering written and verbal presentations to customers and senior management.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center v9.5/8.x/7.x

Languages: SQL, PL/SQL, UNIX Shell

Databases: Oracle 11g/10g/9i, Teradata v2R5/v2R6, MS SQL Server 2008 R2, SAP, MS-Access

Database Tools: TOAD, AQT v8.x, SQL Navigator v4.x, PL/SQL Developer v7.1, SQL Server Management Studio 10.5, Teradata SQL Assistant, Golden, Win SQL 7.5

Database Utilities: SQL*Loader, Teradata-BTEQ, M Load, Fast Load, TPump, FastExport, BCP

Other Tools: MS Visio, MS Office, Putty, CORE FTP, Text Pad, Ultra Edit, Mercury Quality Center 9.0, WinSCP 5.7.3, Perforce Visual Client, DAC

PROFESSIONAL EXPERIENCE:

Confidential, Dublin, OH

Sr. ETL Consultant/Programmer Analyst

Responsibilities:

• Develop tasks in ETL/Informatica, DAC & PL/SQL
• Documentation, Requirement gathering, Impact analysis and Effort estimation
• Ensure all code products are thoroughly tested
• Document design changes, test results, & release information
• Deliver tasks as per the Agile development framework
• Update change request tickets accordingly on Serena Business Manager
• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Defined Target Load Order Plan for loading data into Target Tables.
• Worked on Mainframe system as source. (Cobol Files)
• Conducted design and code reviews and extensive documentation of standards, best practices, and ETL procedures
• Proficient in applying performance tuning concepts to Informatica mappings, session properties, and database.
• Monitoring the daily DAC loads and Fixed the failed jobs in Data Warehouse Administration Console
• Well exposed and worked closely with testing teams in performance unit testing, user acceptance testing, and system integration testing.
• Responsible for coordinating with the Business Analysts to understand business requirement, functional requirements, and conversion of business rules into technical specifications

Environment: Informatica Power Center 9.6.1, DAC 11.1, Oracle, Toad for Oracle Base 11.0, WinSCP 4.2.9, Serena Business Manager, Trello

Confidential, MI

Sr. Informatica Developer

Responsibilities:

• Worked on new development and enhancement requests as per business requirements
• Migrated code between development, QA, & UAT environments
• Performed unit & system testing
• Executed & monitored on demand, daily, & monthly loads
• Documented new development, enhancements, and load schedule information
• Fine-tuned performance and fixed production issues
• Delegated, monitored & reviewed code assigned to junior team member
• Developed Informatica objects like mappings, using active and passive transformation are, mapping parameters, session parameters, reusable and non-reusable objects, short cuts.
• Maintain the version control for all ETL objects using Subversion.
• Extensively worked on XML sources.
• Experience in creating reusable objects and used Expression, Lookup, XML Source qualifier and Union Transformations.
• Carry out the Unit test for the mappings developed
• Co-coordinating between onsite and offshore associates for tasks assignments and day to day deliverables

Environment: Informatica Power Center 9.5.1, SQL Server 2008 R2, SQL Server Management Studio 10.5, WinSCP 5.7.3

Confidential, PA

Technology Consultant

Responsibilities:

• Worked on enhancement requests as per business requirements
• Worked on Integrating data to Salesforce using Informatica Cloud
• Defect fixing if any issue persists in coding after the code deployment to production as part of business readiness testing and analyzing the impact of the solution.
• Migrated code between development, QA, & UAT environments
• Performed unit & system testing
• Responsible for coordinating with the Business Analysts to understand business requirement, functional requirements, and conversion of business rules into technical specifications.
• Involved in development of Stage, Dimension & fact tables mappings using Connected/Unconnected LKP's, EXP, UPD, FILTER, AGG, JOINER
• Involved in Fine tune mappings as a Performance activity.
• Using ETL Process to Extract, Transform and Load the data into stage area and data warehouse and Creating Mapplets and using in mapping.
• Using Transformations to clean the data from staging area as per the data warehouse requirements
• Used Shortcuts to reuse objects across folders without creating multiple objects in the repository.
• To monitor the scheduled workflows like Daily, Weekly and Monthly jobs and execute the Manual Weekly and Monthly jobs.
• Identified and tracked the slowly changing dimension tables, heterogeneous Sources and determined the hierarchies in dimensions
• Executed Pre-and Post-session commands on Source and Target database using Shell scripting.

Environment: Informatica Power Center 9.5, Oracle 11g, Salesforce, Toad for Oracle Base 11.5, Putty 0.64, WinSCP 5.7.3

Confidential

Asst. System Engineer

Responsibilities:

• Developed mappings & workflows to ETL data using Informatica Power Center
• Prepared deployment document for code migration
• Migrated code between development, QA, & UAT environments
• Performed unit & system testing
• Coordinated with onsite development team

Environment: Informatica Power Center 8.6, Oracle 11g, Toad for Oracle Base 11.5, PuTTY 0.64, WinSCP 5.7.3, Windows 7 Enterprise

Confidential, Chicago, IL

Sr. Data Analyst

Responsibilities:

• Developed mappings & workflows to ETL data using Informatica Power Center
• Coordinated work with offshore development team
• Fine-tuned the performance of workflows
• Used Shortcuts to reuse objects across folders without creating multiple objects in the repository
• Performed unit and integration testing

Environment: Informatica Power Center 7.1, Oracle 10g, MS SQL Server 2008, SAP, Windows XP Professional