SUMMARY

• Over 7+ years of IT experience with strong experience in analysis, design, development, testing and implementation of Business Intelligence solutions.
• Solid experience in Informatica Power Center (versions 9.5/8.6 RDBMS, Data warehousing/ETL, OLAP 7.1/5.1) including Designer, Workflow Manager and Informatica Power Exchange (version 9).
• Good experience in Workflow Monitor, Repository Manager, Repository Server Admin console and Teradata.
• Good experience using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong in various types of transformations like Aggregator, Rank, Router, Normalizer, Sorter, Lookup, Update Strategy, Stored Procedures, Joiner, Filter, External Procedure, Sequence Generator and Source qualifier.
• Worked extensively with slowly changing dimensions i.e. SCD1, SCD2 and SCD3.
• Proficient in the Integration and Expertise in working with various data sources with multiple relational databases like Oracle11g/ Oracle10g/9i, MS SQL SQL Server 2008/2005, DB2(8.0/7.0), Teradata ( 12.0/13.0/14.0 ), Exadata, UDB, Unix Shell Scripts.
• Experienced in Flat Files into the Staging area, ODS, Data Warehouse and Data Mart.
• Good Experience in Integration services like Pervasive Data Integrator, SQL Integration Service and Scheduling Tools (i.e. CA7, Control M, Autosys)
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers.
• Experienced in Complex SQL queries and SQL Stored Procedures using SQL Server, TSQL and Oracle PL/SQL.
• Experienced in SLA tracing, Incident Resolution, Informatica DAV, Informatica MDM and IDQ.
• Good experience in Migrating the data to different environments.
• Managing and mentoring the team for any technical issues.
• Excellent interpersonal and communication skills.
• Good experience working with managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9.5/9.1/9.0/8.6 /7.1.2/6. x/5.x

Scheduling Tool: Control M, CA7, Autosys

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata 12.0/13.0/14.0

OLAP Tools: Cognos 8.0/8.1/8.2/8.4/7.0/ , Business Objects XI r2/6.x/5.x, OBIEE 10.1.3.4/ 10.1.3.3

Languages: C, C++, SQL, PL/SQL, UNIX, Shell Scripts.

Operating systems: Windows 2000/07/NT/XP/8/8.1, UNIX (Sun - Solaris, HP/UX), Linux.

Scripting languages: Windows scripting, Unix Scripting.

Integration Services: Pervasive Data Integrator, SQL Integration Service.

Data Modelling Tool: Erwin 4.0

Packages: SQL* PLUS, Toad 7.x, SQL Developer

Web technologies: HTML, DHTML

Applications: MS Word, Excel, Outlook, PowerPoint, Visio, Visual Studio.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Informatica Developer

Responsibilities:

• Working with different source systems like SAP (R3), AS 400, flat files, Oracle.
• Contacting the Business Analysts/Users to develop, document and to evolve process and data models based upon their input and feedback.
• Experience in Agile methodology.
• Experience translating business requirements into Conceptual and Logical Process and Data Models.
• Experience in preparing Logical data models as well as Physical data models and document the same.
• Created reusable transformations for converting varchar into upper case and string to date.
• Created Mapplet for history management dates, ETL Process status.
• Participated in Data modeling meetings, helped to identify the relationship between tables according to the requirements.
• Prepared ETL design document which consists of the database structure, change data capture, Error handling, restart and refresh strategies.
• Worked in Informatica Power Center for the Extraction, Transformation and Loading from various sources to the enterprise data warehouse.
• Developed and tested extraction, transformation, and load (ETL) processes.
• Worked Extensively on DAV and MDM.
• Involved in change data capture (CDC) ETL process.
• Created sessions and workflows for the source to staging data flow and staging to Target loading.
• Implemented Type II changes for different Dimensions.

Environment: Informatica Power Center 9.1, 8.6, Informatica DAV, Informatica MDM, Oracle 9i, Teradata, SQL developer, TOAD, HP Quality center 10.0, Control-M, PL/SQL (Stored Procedures, Triggers, Packages), Erwin, MS Visio, UNIX shell Scripting, AIX, Windows NT/XP.

Confidential, Cupertino, CA

Sr. Informatica Developer

Responsibilities:

• Involved in the team during the entire ETL process and development of data marts using Informatica Power Center.
• Worked with enterprise architects to develop the new logical and physical ER data models in line with corporate standards and guidelines.
• Created the necessary documentations like High Level Design document (HDD), Detail Design Document (DD) with the ETL Mapping Matrix for the new data marts.
• Created Informatica Mappings to load data and used transformations like Stored procedure, Transformation, Connected and Unconnected lookups, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filters, Sequence, Router and Update Strategy transformations.
• Architected and developed Fast Load and MLoad scripts, developed BTEQ scripts to process the data in staging server.
• Worked on Variables, Parameters, Parameter files and File list on Informatica.
• Implemented slowly changing dimensions (Type I and Type II) for customer Dimension table loading.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL for creating Connected and Unconnected Stored Procedure Transformations.
• 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.
• Involved in writing Automation Testing scripts using Shell.
• Worked on Maestro to schedule these scripts in DEV and QA environments.
• Extensively used Toad during development and testing to ensure data quality and investigate data issues.
• Performed Unit and System Testing as per the test plan and documented the test results as per the corporate standards. Monitored the data loads during UAT tracked and resolved the defects raised by the business users.
• Involved in development of programs for Extraction and Transformation, Fast Load and MLoad scripts, developed BTEQ scripts to process the data in staging server.

Environment: Informatica Power Center 9.1, Power Exchange, Oracle10g, DB2, SQL Server 2008, MY SQL, XML, HP Quality Center 9.0, Toad, SQL Developer, Control-M, PL/SQL (Stored Procedures, Triggers, Packages), Erwin, MS Visio, UNIX shell Scripting, AIX, Hexdata, Windows XP.

Confidential, Bloomfield, CT

Informatica Developer

Responsibilities:

• Analyzing business processes, functions, existing transactional database schemas.
• Designing star schema models to support the users reporting needs and requirements
• Communicating with business users to resolve their issues, follow-up with users and team to resolve the issues.
• Designed multi-dimensional Star schema, Generated the database scripts, E-R diagrams using ERWIN.
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with back-end database using PL/SQL.
• Used Power Exchange to access VSAM, IMS data stored on the mainframe systems,
• Collaborate with the Data Warehouse team to design and develop required ETL processes.
• Created technical design specifications for the ETL programs.
• Performance tuning, Maintenance and enhancements of ETL programs and scripts.
• Developing the maplets, worklets, reusable transformations and shortcut objects.
• Created mapping for error handling sessions.
• Created mapping for creating a parameter file.
• Worked with DBA's to design and build the Staging/Target databases.
• Assisted business users for data cleansing and user acceptance testing.
• Developed functions and stored procedures to aid complex mappings.

Environment: Informatica- Power Center 8.6, Oracle 11g, DB2, IMS Data, UNIX Shell Scripts, Autosys, Power Exchange, Business Objects XI, Erwin, Windows XP, Unix (AIX).

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Developed the detailed database design document which included data dictionary, data estimates, entity relationship (ER) diagrams, dimensional model (Snowflake schema) using Erwin, MS Office and MS Visio
• Migrated data mappings to production and monitoring, troubleshooting and restarting batches.
• Developing UNIX korn shell scripts for data manipulation and process automation.
• Developed separate mappings for the Data Cleaning and Scrubbing and implementing the Data warehousing Standards.
• Starting Sessions and Batches and make Event based scheduling using Informatica Power Center Server Manager.
• Generated server side PL/SQL scripts for data manipulation, validation and provided DDL scripts for creation of database objects such as tables, indexes, views, sequences, object types, collection types and Materialized Views.
• Implementing the complex business rules by creating transformations, filter, Expression, Lookup, Joiner, Sequence generator transformation.
• Performed Informatica server administration tasks such as stopping/starting Informatica Repository and Server processes, performing code migration from Dev to Test, backup and restoring of Informatica Repository, upgrades and security administration.
• Created Migration Documentation and Process Flow for mappings and sessions.
• Designed Business Objects reports to have drill down, drill up and drill across functionality.
• Worked on gathering, analyzing and documenting business reqs.
• Ensured that the documentations comply with the corporate stand.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.

Environment: Informatica- Power Center 7.1/8.1, Oracle 10g, DB2, SQL Server, UNIX Shell Scripts, Autosys, Business Objects, Erwin, Windows XP, Unix (AIX).

Confidential

Informatica Developer

Responsibilities:

• Extracted Data from Different Sources by using Informatica Power Center.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplet Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyzed, designed, constructed and implemented the ETL jobs using Informatica.
• Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Created Users, user groups, database connections and managed user privileges using supervisor.

Environment: Informatica Power Center 7.1.1, Oracle 8i, MS SQL Server 2000, SQL, PL/SQL, SQL*Loader, Unix Shell Script, CA7 Scheduling tool.