PROFESSIONAL SUMMARY:

• Over 7+ of IT experience in Business Requirements Analysis, Designing, coding and testing of Data Warehousing implementations across Financial, Insurance and Pharmaceutical Industries.
• Experience in building and managing various data warehousing/data marts using Informatica products such as Power Center 9.x/8.6.1/8.5.1/8.1.1/8.0/7.1, Power mart 6.1/5.1/4.7, Power Exchange for data models.
• Strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center and Informatica Power Mart (Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor).
• Involve all aspects of the project and technologies (Informatica, Unix Scripts, and Business Objects Reports) and work with a team of Onsite and offshore Build and Test resources.
• Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Knowledge in OLTP/OLAP System Study and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Enhanced performance for Informatica sessions by using physical pipeline partitions, DTM Session performance and Parameter Files.
• Extensive experience in using tools like SQL Plus, TOAD, SQL Developer and SQL Loader.
• Experience in data modeling using designed tool Erwin 4.1/4.0 and worked with Oracle Enterprise Manager and Toad.
• Knowledge in extracting data from various sources like Oracle, DB2, Flat file, SQL SERVER, XML files, Teradata and loaded into Teradata, Oracle database.
• Strong understanding of Performance tuning in Informatica and Databases with Oracle Stored Procedures, Triggers, Index and experienced in loading data into Data Warehouse/Data Marts using Informatica.
• Hands on experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures.
• Experienced in developing applications in Oracle and writing Stored Procedures, Triggers, functions, Views and creating Partitions for better performance.
• Extensive experience in oracle SQL. PL/SQL Programming. Experienced in writing and designing the SQL queries. SQL*Loader, Developed PL/SQL, SQL*Plus, Tuning using explain plan etc.
• Setting up ODBC connections, Batches and sessions to schedule the loads at required frequency using Power Center.
• Experience in UNIX Shell Scripting. Autosys, Control-M for scheduling the Workflows.
• Familiar with Agile development and waterfall methodologies.
• Ability to work in teams as well as individually, quick learner and able to meet deadlines Development experience across functional business areas such as Pharmaceuticals, Finance, Supply Chain and Manufacturing.

TECHNICAL SKILL:

ETL Tool: Informatica 9.x/8.x/7.x/6.x/5.x (Power Center/Power Mart/Power Exchange)

Data Modeling: ERwin r7.3/4.0/3.5(Star schema/Snow flake)

Languages: C, SQL, PL/SQL, SQL*Plus.

Databases: Oracle 7.x/8i/9i/10g/11g, MS SQL Server 7.0, 2000, 2008, DB2.

OLAP Tools: BusinessObjectsXIR2, OBIEE

SQL Tools: SQL Developer, TOAD, SQL*PLUS, SQL*Loader.

Office Tools: MSOffice, MS Project, Auto CAD.

Operating Systems: Windows 95/ 98/NT/2000, XP, UNIX, Sun Solaris.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. ETL/Informatica Developer

Responsibilities

• Develop technical design documents and mappings specifications to build Informatica Mappings to load data into target tables adhering to the business rules.
• Analyzed business and systems specifications and developed logic flowcharts.
• Coordinated and worked with the offshore team for development and involved all phases from requirement gathering, design, development, testing and Production deployment.
• Extensively used ETL to load data from wide range of source such as flat files, oracle and XML to ORACLE.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, and Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Implemented bulk load method with SQL Loader for loading history data to staging area.
• Worked withVariables and Parametersin the mappings to pass the values between sessions.
• Executed Multi load scripts for daily batch jobs.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Defined UNIX Batch scripts for automation of execution of Informatica workflows and used UNIX Shell Scripts and pmcmd command line utility to interact with Informatica Server from command mode.
• Worked with Backend testing, writing complex SQL queries to verify the transactions and business logic.
• Using Dynamic SQL and SQL*Loader in distributed environment.
• Worked with Performance tuning of the Mappings, Sessions and SQL Queries Optimization.
• Create complex analytic queries on large data sets
• Extensively use SQL Queries on different data sets.
• Extensively worked in the performance tuning for the mappings and ETL Procedures both at designer and session level.
• Involved Working on Functional testing, Integration/ System testing, Regression testing and User Acceptance Testing.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Expertise in working with Oracle Stored Programs, Packages, Cursors, Triggers, Database Link, Snapshot, Tables, Constraints, Views, Indexes, Sequences.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts and test cases for manual testing.

Environment: Informatica Power Center 9.1/8.6, Oracle 10g/11g, UNIX, Shell Scripts, TOAD 10.6, Control-M 6.4, ERwin 7.3. HP Quality Center 10.0.

Confidential, Seattle, WA

Sr. ETL/Informatica Support and Developer

Responsibilities

• Work closely with Plan team to analyze the requirements, perform gap analysis, and convert the business requirements to technical specification in from Informatica point of view
• Extracted data from wide variety of data Sources like Legacy Systems, Flat files, Relational Databases.
• Interacted actively with Business Users and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Developed various Mappings which perform Extraction, Transformation and Loading of Source data into the OLAP Schema, and used different Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, Joiner etc
• Extensively used Re-usable Objects like Mapplets and Transformations in the Mappings.
• Worked with pmcmd to interact with Informatica Server from command mode.
• Created parameter files, mapping variables to enhance the ETL performance.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Develop and migrate code, track and support the projects in all project life cycle.
• Worked on ETL support issues extensively to fix the production issues.
• Tuned sources, targets, mappings and sessions to improve the performance of data load into SQL server database.
• Tested all Mappings, Sessions and Workflows for Data accuracy.
• Created deployment groups and deployed workflow from one environment to other.
• Worked with Backend testing, writing complex SQL queries to verify the transactions and business logic.
• Worked with some administration tasks like creating a user, assigning the privileges and creating integration services using admin console.
• Involved in implementing the Hot Fix 14 for the server and client and tested the application.
• Involved in testing the Informatica mappings using the test data and upgraded the QA Test Plans.
• Testing and validating the data on target data system and fixed the error codes on target data.
• Performed database health checks and tuned the databases using Teradata Manager.

Environment: Informatica Power Center 8.6.1/9.x, Oracle 10g, SQL server 2005 &2008, PL/SQL, SQL*Plus, Windows NT, Unix Shell Scripting, Erwin 4.

Confidential, Baltimore, MD

Sr. Informatica Developer and Web Services

Responsibilities

• Worked withInformaticaPower Center to move data from multiple sources into a common target area such as Data Marts and Data Warehouse.
• Coordinated with Business system analyst (BSA) to understand and gather the requirements.
• Accordingly, Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Responsibilities included designing and developing complexInformaticamappings including Type-II slowly changing dimensions.
• Involved in writing the Technical Requirements Document, Mapping Documents, and Low Level Design Documents.
• Designed and developed mappings using Source Qualifier, Aggregator, Joiner, Lookup, and Sequence Generator, Stored Procedure, Expression, Filter and Rank transformations.
• The Mapping Designer module used for ETL tasks to upload the data from various centers with data in different source systems to build Data Marts.
• Created Informatica parameter files with workflows and sessions.
• Extensively used SQL overrides at Source Qualifier and Lookup Transformations while extracting data from multiple tables.
• Tuned mappings to perform better using different logics to provide maximum efficiency and performance.
• Categorized different alerts and exception types to be built from User’s Data Validation list and built mappings to generate exceptions and alerts accordingly.
• Tested the target data against source system tables.
• Used Command task to move the parameter files to the desired position at the start of the session.
• Worked with pre-session and post-session sql and stored procedures
• Worked with Performance tuning of the Mappings, Sessions and SQL Queries Optimization.
• Coordination with OBIEE Team regarding the reporting data for Answers and BI Publisher reports and also for the Dashboard Designs.
• Involved in requesting input forms and creating log-in Windows for users to input the feeds.
• Performed Validations and Worked on Merqury Quality center tool for defect resolution.
• Performed Informatica Code Migration across environments.
• Documentation of ETL extracts developed using the Informatica extract tool.
• Created UNIX scripts for file transfers, to remove unwanted characters from source files, update the Time dimension table which was maintained for reporting purposes.
• Maintained and developed components on web platform.
• Responsible for the full stack (front end development, application logic, services, data persistence).
• Worked in a team of twenty.
• Agile / Scrum environment.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL server 2005, Teradata, Informatica power exchange, PL/SQL, SQL*Plus, TOAD, ERwin 4.0, Windows NT, Shell Scripting, HP UNIX 10.2 JavaScript, jQuery, C#, ASP.NET MVC, LINQ, LINQ to SQL, Windows Communication Foundation (WCF), Web Services, REST, JSON, AJAX, MSBuild, XML, XSL, XPath, SOAP, CSS, HTML, Microsoft SQL Server 2005, SQL / T SQL, Microsoft Team Foundation Server (TFS), and the .NET Framework 4.0

Confidential, Madison, WI

Mid-Level ETL/DW Consultant

Responsibilities

• Worked with users to understand their reporting requirements and translate those requirements to extract data, and load data in the form of a report.
• Tested Informatica 8.6 with all functionalities for migration of Informatica 6.2/7.1.2 to 8.6.
• Analyzed business and systems specifications and developed logic flowcharts
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, and Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Implemented Informatica Power Center for building Oracle Data Warehouse from different OLTP systems
• Implemented bulk load method with SQL Loader for loading history data to staging area.
• Defined UNIX Batch scripts for automation of execution of Informatica workflows.
• Executed Multi load scripts for daily batch jobs.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Implemented business rules by using database triggers.
• Generated Drill Up, Drill Down and Drill Through reports using Business objects based on user requirements.
• Improved Application performance by fine-tuning application using TKPROF and EXPLAIN PLAN
• Expertise in setting up UNIX cron jobs using cron tab in UNIX.
• Experience in SQL tuning using Hints, Materialized Views.
• Extensively worked in the performance tuning for the mappings and ETL Procedures both at designer and session level.
• Using Dynamic SQL and SQL*Loader in distributed environment.
• Expertise in working with Oracle Stored Programs, Packages, Cursors, Triggers, Database Link, Snapshot, Tables, Constraints, Views, Indexes, Sequences.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Extensively worked with Business Users on regression testing the Monthly/Quarterly Reports and convey the errors/issues to Developers and get them fixed on tight deadlines
• Designed and developed full client reports in all different formats and modified, tuned thelegacy reports. Used Business Objects for Adhoc reporting.
• Developed an n tier service oriented e commerce application.
• Responsible for developing the full stack (from the Markup, JavaScript, Application Services, Database, and Build Scripts).
• Responsible for gathering requirements, performing gap analysis, development, and final support tasks.
• Conducted on site client training, and reoccurring knowledge transfer sessions.

Environment: Informatica Power Center 8.1/7.1, Oracle 9i, Business Objects 6.5, UNIX, Shell Scripts, TOAD 8.0, Autosys, Sun Solaris JavaScript, C#, Windows Communication Foundation (WCF), Web Services, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Commerce Server 2007, MSBuild, XML, XSL, XPath, SOAP, CSS, HTML, ASP.NET, Microsoft SQL Server 2005, SQL / T SQL, Microsoft Team Foundation Server (TFS), Microsoft Visual Source Safe (VSS), and the .NET Framework 3.5