SUMMARY

• 9 years of IT experience working in the Data Warehouse Business Intelligence domain and in the fields of Client/Server Application and Business Intelligence tools.
• 8 years of experience in ETL using Informatica Power Center 6.x/7.x/8.x/9.1
• Excellent Data Analysis skills and ability to translate business logic into mappings using complex transformation logics for ETL processes.
• Strong logical and physical data modeling skills, physical database design, relational models, star schema and snow - flake schema.
• Responsible for all activities related to the design, development, implementation and support of ETL process for large scale data warehouses.
• Strong experience working with different RDBMS like Oracle, SQL Server, Teradata, Netezza, SQL, PL/SQL, SQL* PLUS, SQL* Loader, TOAD, Stored Procedures, Triggers.
• Worked with different file systems including XML files, Mainframe COBOL copybook files, CSV files to capture the data into the data warehouse.
• Experience with complex Informatica mappings using transformations like Expression, Aggregator, Router, Joiner, Rank, Sorter, Stored Procedure, Lookups, Normalizer, Sequence Generator and Update Strategy.
• Experience in creating Informatica Sessions, Workflows, and Worklets by using the Workflow Manager tools like Task Developer, Worklet.
• Strong experience in Teradata Tools and Utilities such as Mload, BTEQ, TPT, Fastload, FastExport and Tpump
• Experience in Partitioning, Performance Tuning and Optimization of ETL Jobs and mappings.
• Experience in integration of various data sources like Oracle, Sybase, SQL Server, Flat Files.
• Implemented various Audit Controls to reconcile the data between Source and Target systems.
• Experience in UNIX Shell Scripting, Perl Scripting, and Job Scheduling on Multiple platforms like Windows NT/2000/2003, SunOS, HP-UX, IBM-AIX.
• Involved in full Software Development Life Cycle (SDLC) of application software on multiple platforms including system study, analysis, design, development, unit integration, acceptance testing and implementation.
• Experience creating different documentations like RTM, BRD, HLD, TDD, Unit Test Cases, Deployment Plans and Production Turnover documents.
• Highly motivated, possesses quick grasping power and very good analytical and technical skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.x/7.x/6.x, Informatica Power Exchange 8.x/7.x, Informatica Data Explorer (IDE) 5.x, Informatica Data Quality (IDQ) 8.x, DataStage 8.x, Pentaho Kettle PDI 4.1/4.2, Ab-Initio, SSIS 2008/2005.

Reporting Tools: Business Objects XI, Cognos (Framework Manager, Report Studio) 8.x, SSRS.

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, MS SQL Server 2008/2005/2000 , Teradata R2V4/V6, IBM-DB2, Microsoft Access.

Languages: Java, C, C++, .NET, ASP.NET, SQL, HTML, XML, UNIX Shell Scripting.

Tools: Tivoli (TWS), Autosys, PVCS, Hummingbird, Toad, SQL Developer, ERWin, Visio.

Operating Systems: Windows NT/95/98/XP, MS-DOS, UNIX, Mainframes.

PROFESSIONAL EXPERIENCE

Confidential, Ogden UT

Senior Informatica Consultant

Responsibilities:

• Communicated with Business Leads to identify their issues and converted complex requirements to technical specification to convert the existing Mainframe ETL structure to Informatica Mappings.
• Attended requirement specification meetings to add/change requirement as per the changing ETL Scenarios.
• Used complex Informatica mappings to extract data from the source system to the Staging DB.
• Converted complex Transformation requirements to Informatica Transformation to transform the Source data to match the target data.
• Created complex reusable Rule Exception Mapplets to test the quality of data begin loaded in the target DB and Raise Exceptions if the data is not within a predefined set of thresholds.
• Create test plans and scenarios for development unit testing and data validation.
• Set up batches and workflow sessions to run these mappings.
• Helped in the creation of the Run Book for migration of the code from Development to Test To Acceptance then to Production.
• Performance tuned the mapping using Velocity Best Practices.

Environment: Informatica Power Center 9.0. Oracle 11g,, Toad 10.5, BusinessObjects, Autosys, UNIX. Rational ClearCase. Rational ClearQuest, HP Quality Center.

Confidential

Responsibilities:

• Communicated with Business Leads to identify their issues and converted them into technical requirements.
• Create ETL mappings to extract data from multiple data sources.
• Converted complex business rules to reusable Mapplets to be used in different mappings.
• These Mapplets were used to validate the data against source files, and if the data does not match raise an exception.
• Worked with data modeling in preparing logical and physical data models and adding/deleting necessary fields.
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Create test plans and scenarios for development unit testing and data validation.
• Set up batches and workflow sessions to run these mappings.
• Provided fixes to bugs and testing with new Builds.
• Performance tuned the mapping using various strategies like Partitioning, and other best practices.

Environment: Informatica Power Center 9.0. Oracle 11g,, Toad 10.5, MicroStrategy, Autosys, UNIX. Rational ClearCase. Rational ClearQuest, HP Quality Center.

Confidential, Pasadena, CA

Senior Informatica ETL Engineer

Responsibilities:

• Designed and Developed Informatica mappings to convert the present ETL Framework, the framework is based on C# classes and XML Rule Engine.
• Converted SSIS packages to Informatica mappings and sessions.
• Converted Historical Research Data jobs to Informatica mappings and sessions.
• Assist in the design of the Informatica framework as needed.
• Created User Defined Function for mappings, to implement reusability of complex functional logic.
• Created and maintained stored procedures, triggers, views and constraints to support systems and databases.
• Develop queries and stored procedures involving complex database structures.
• Created the Data Maps for respective Copybooks to source it from Mainframe COBOL files to Target database.
• Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Documented the completed Mappings.
• Created Reusable Mapplets, Worklets and Lookup Transformations to implement generic logic.
• Developed indirect method to read multiple source files and load the target for individual processes.
• Review the requirements to assess and estimate the work effort.
• Work with peers to carry out design and code reviews of new development.
• Document new design, development procedures or test plans as needed.
• Extensively used Pushdown Optimization to push the transformation logic to Netezza database servers.
• Experienced in creating Real Time Mappings using MSMQ sources and Netezza targets to price the vehicles for kbb.com. Used XML Midstream Parser Transformation to parse the Message and load to the target Netezza table.
• Worked with different Source Systems to perform transformations and load to different Target Tables.
• Install update, maintain, monitor and support Data Integration Technologies (including Informatica, Netezza).
• Worked with large volume of Web Analytics data and was involved in performance enhancement of the Informatica code

Environment: Informatica PowerCenter 9.1, Pentaho Kettle Data Integration 4.1/4.2, IBM Netezza Database 6.0.3, Aginity Workbench, Microsoft SQL Server 2008, Oracle 11g, Toad 10.5, MicroStrategy, WinSCP, FTP, SFTP, C#, XML Rule Engine, Visual Studio, Version One, Agile Development, Kanban.

Confidential, Calabasas CA

Informatica Developer

Responsibilities:

• Communicated with Business Leads to identify their issues and converted them into technical requirements.
• Complete SDLC including architecture, analysis, design, development, testing, implementation & maintenance of application software in the Enterprise Data Warehouse with production support.
• Participation in project meetings/design groups as a team member with other Data Analysts in preparing Analysis reports and project development reports according to industry regulations.
• Profiled the data using Informatica Data Explorer (IDE) 5.x.
• Created datamaps for getting the COBOL copybooks and data files as a source using the interface Informatica Power Exchange (PWX).
• Created complex level mappings involving Slowly Changing Dimensions (SCD) Type 1, 2 & 3.
• Code, implement and unit test the application based on the technical requirements.
• Provide support for the system once it is deployed and running in production environment.
• Create ETL mappings to extract data from multiple legacy systems.
• Transform and load the data into the Enterprise Data Warehouse using Informatica Power Center.
• Worked with different files like XML files, COBOL files and Flat files.
• Assist in designing Informatica mappings and data model structural changes.
• Worked with User Defined Functions (UDF) to reuse the complex business logic across different mappings.
• Design and develop new database objects like tables, procedures, functions, indexes, and views using Oracle and SQL Server.
• Understand business challenges and translate them into process/technical solutions.

Environment: Informatica Power Center 9.0.1/8.6.1/8. x, Ab-Initio, Informatica Power Exchange 8.x, Informatica Data Explorer 5.x, Oracle 11g/10g, SQL Server 2008/2005, Toad 10.5, SQL Server Management Studio, Cognos 8.x (Framework Manager, Reprot Studio), Tivoli Work Scheduler (TWS) 8.3, PVCS, UNIX.

Confidential, Los Angeles CA

ETL Data Warehouse Developer

Responsibilities:

• Analysis of the source systems, Develop functional specifications and converting them into technical specifications.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Actively involved in upgrading Informatica Power Center from version 6.2 to version 7.1.2.
• Designed and developed mappings for exception management process for the fact tables.
• Designed the process for DW Conversion and Reconciliation to convert the data from legacy DW to EDW and support automation of financial balancing, production data validation.
• Involved in design, development and testing for the forklift effort to migrate the DW from Oracle to Teradata database.
• Exclusively used FastLoader and MultiLoader in different modes to load data to Teradata. Also manually wrote control files (loader scripts), bteq scripts to load data from flat files to Teradata tables.
• In depth knowledge in using CDC 9i utility, developed CDC ETL Update mappings for the modernized data warehouse.
• Written several PL/SQL procedures, SQLs for producing ADHOC reports to the users.
• Developed Shell Scripts, table and Index creation scripts.
• Designed the new master workflow for the daily load process for the modernized data warehouse.
• Extensively used Informatica scheduler to schedule various workflows.
• Created unit test plans and test scenarios. Involved in unit, Integration, functional and performance Testing.
• Extensively used Test Director 6.0 and Quality Center to open, assign and track test defects.
• Generated reports making use of Cognos Reporting tool.

Environment: Informatica Power Center 7.1.2/6.2, Windows NT, UNIX, Oracle 10g/9i, Teradata, SQL, PL/SQL, ERWIN 4.0, Toad, PVCS, Test Director 6.0.

Confidential

Senior Oracle DBA/Developer

Responsibilities:

• Designed various front-end screens of application using Oracle Designer 6 and Forms 6i
• Developed various Reports in Oracle Designer 6i and Reports 6i.
• Customized and developed program Libraries (PLL) for the application screens in Oracle Forms 6i
• Developed and in corporate changes in various packages, libraries, procedures and functions to support and develop new application.
• Designing and developing various modules of company new application from scratch which enable company to enter in international market using and Reports 6i.
• Designed physical and logical database using Oracle Designer 6i and ERWIN data-modeling tools.
• Designed and developed schemas, creating tables, views, and constraints based on international and national market manufacturing Industry business rules.
• Performance tuning of queries and cursors using HINTS, Explain Plan and TKProf and PL/SQL Developer
• Developed backend procedures, functions, libraries and triggers for Data validation, and parsing EDI files data into database.
• Developed Advance PL/SQL packages, procedures, triggers and functions to implement business logic.
• Generated Tech Documentation, detail designs, SDDs, DFDs, and user manuals of interfaces that are developed in customer service and billing and cash to help users and tester understand application while they test or use it.
• Experience in converting and comparing large objects (LOB).
• Actively used various Oracle Utilities and standard packages UTL File, Text IO, SQL*Loader, Export/Import etc.
• Supported Oracle Apps customization and development
• Assist and support users in user testing and helping to ensure accuracy Designed and developed schemas, tables, views, constraints, and triggers to make system automatic, Performed tuning and optimized complex queries using hints.
• Developed complex packages, functions and procedures to convert and parse data from XML files to multiple database tables.
• Worked as Senior Oracle Developer and Database Designer, supports very large database by developing routines at backend packages for company’s intranet application.
• Worked closely with Production Database Administrators to implement new releases.
• Supported over 250 databases on Windows Server 2000 and NT system with sizes ranging from 500GB to 2TB.
• Developed RMAN scripts for backup and recovery of databases.
• Wrote monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
• Database design/architecture experience using both logical and physical modelling using Erwin Tools.
• Excellent communication skills and the ability to work independently or in a team environment.
• Designed, documented, implemented, and maintained all disaster recovery procedures which result in no data loss while saving the company over 500g.
• Performed daily operational duties/security for all users of the databases.
• Developed, implemented, and provided operational support of distributed application point of sale (POS) programs in a production environment.
• Administered, maintained, developed and implemented policies and procedures for ensuring the security and integrity of the company databases.
• Resolved database performance issues, database capacity issues, and other distributed data issues (OLTP).
• Ability to work in stressful environment while handling demanding internal and external clients.
• Performed tuning and optimize complex queries using hints.
• Designed and developed schemas, tables, views, constraints, and triggers to make system automatic.
• Actively Involved in Data Modelling. Developed complex packages, functions and procedures to convert and parse data from XML files to multiple database tables.