SUMMARY:

• Over 8+ years of experience in IT ETL Design, Data warehousing, Data warehouse Testing and business intelligence using ETL tool Informatica and Business Objects.
• Expertise in Informatica PowerCenter7.x/8.x/9.1Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Maple Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Expertise in Creating, designing and executing test plans, test harnesses and test cases.
• Expertise in Conducting deep technical analysis/testing of release in plan to conduct validation and verification of entire application.
• Expertise in executing all phases of the testing process in a multi - server environment and to define and maintain testing environments and/or configuration.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator transformation, Active and Passive transformations, Joiner and Update Strategy transformations.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Experience in working with Mainframe files, XML, and Flat Files.
• Experience in using Shell scripts to move the file in server to local folders.
• Experience in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources systems into data warehouse using Informatica Power Center.
• Experienced in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Produced Dimensional (Star Schema) data models for Data Warehouse/OLAP applications using data modeling -best practices- modeling skills and the Ralph Kimball methodology
• "Meta-Meta" Data Modeling: Modeled Repository Objects For Extensibility Proficient working with Unix/Linux environments and writing UNIX shell scripts
• Experienced in working with tools like TOAD, SQL Server Management studio and SQL plus for development and customization.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work effectively as a team member as well as independently.
• Good exposer to Informatica Data Quality
• Good exposure in informatica MDM where data Cleaning, De-duping and Address correction were performed
• Worked on the Business Objects XI, XIR2,3.0/3.1
• Worked in design, development and implementing Web intelligence reports using Business Objects XIR2.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.x/9.x, BODI/ BODS

Scheduling Tools: CA7, AUTOSYS

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join SchemaModeling, Snow-Flake Modeling Fact and Dimensions Tables, PhysicalAnd Logical Data Modeling, Erwin 4.0/3.5.2/3. x.

Databases: Oracle11g/ 10g/9i/8i/8.0/7.0, DB2 8.0/7.0, Teradata, MS SQL Server

GUI: TOAD, SQL Developer

Programming: SQL, PL/SQL, SQL, HTML, DHTML, C, C++, XML, XSD, UNIX Shell Scripting.

Design Tools: Erwin 4.0/3.5, Oracle Designer / 2000.

Environment: UNIX AIX 5.2/5.3, Windows95/98/2000/XP/VISTA, WinNT 4.0, MSDOS.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Informatica Consultant

Responsibilities:

• Analyzing the source data coming from different sources and working with business users and developers to design the Data Model.
• Translated requirements into business rules & made recommendations for innovative IT solution.
• Implemented Machine Business Rules in Informatica and used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Update Strategy, Router and Sequence generator.
• Using Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Developed number of complex Informatica Mappings, Mapplets and Reusable Transformations for different types of studies for Daily and monthly Loading of Data.
• Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL tool.
• Involved in Dimensional modeling to Design and develop STAR Schemas using POWER DESIGNER to design Fact and Dimension Tables.
• Removed bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Implemented efficient and effective performance tuning procedures.
• Tuned Source System and Target System based on performance details - used pushdown optimization and partitioning techniques.
• Interfacing with and supporting testing teams to validate functionality.

Environment: Informatica Power Center 9.6/9.1, Power Center Designer, workflow manager, workflow monitor, Oracle, TOAD, Flat Files, UNIX, ESP, DB2.

Informatica Consultant

Responsibilities:

• Conduct studies, gather and analyze data from various databases and sources
• Extensive interaction with clients and business teams to get the report code and generation
• Designed and developed various ETL processes to support different projects in the EDW Framework.
• Worked on Informatica Grid for sharing resources and load and High availability which cluster the systems.
• Worked with business analysts, and end users to define business rules and interpret data.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the Process of loading, pulling and pushing data from & to different servers.
• Involved in Designing and developing ETL mappings from varied transformation logics like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Integrated various data sources of Oracle, SQL server and sequential files into staging area.
• Error handling in ETL processes using SQL queries or transformations like Router and Lookup.
• Developed reusable transformations, Mapplets and Worklets to reduce development time.
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and Worklets.
• Worked closely with reporting team supporting large database clusters running state-of-the-Art Vertical column store database.

Environment: Informatica Power Center 9.0, Oracle 11g, TOAD, and Cognos, DB2, PL/SQL, VSAM, UNIX, Windows XP, UNIX Shell Scripts and DB2 Connect.

Informatica Developer

Responsibilities:

• Involved in gathering and analyzing requirements, prepared Technical Design document and Source - Target Mapping docs and presented to BU team to finalize and get sign off on the TDD/STM
• Worked on project plan to define the efforts and estimations tasks.
• Created SCD Type 2 mappings using Date Flagging Method.
• Designed and Developed the Batch and Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Scheduled and lead the status meeting calls with Deliver /Test Managers to define the road map and to discuss on project status.
• Identify root cause and implement resolution for production Processing issues.
• Perform object deployments on versioned repositories from QA to Production.
• Setup and administer Power Center security.
• Setup the Databases and File transfer system.
• Experience with Automic Scheduler to schedule the Stored Procs.
• Create test cases and used Debugger to test the mappings and fixed the bugs.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 8.6 / 8.1.1, Erwin 4.5, Oracle 10g / 9i, Windows NT, VSAM, Flat files, SQL, MS-SQL Server 2008, Power Exchange 8.5, UNIX

Senior ETL and Report Developer

Responsibilities:

• Point of contact for all the ETL and Reporting related activities. Monitor/Lead other Developers in implementation of the projects
• Involved in gathering and analysing the requirements and preparing business rules.
• Worked in preparing mapping documents, code review checklist and technical design documents for ETL and Reports.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
• Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse. Created mapping documents to outline data flow from sources to targets.
• Involved in designing the database, required tables and other related objects. Responsible for getting Informatica, Database and Reporting environment ready for development and testing by getting AD groups, Process Ids and Connection Managers created.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse. Developed reusable Transformations and reusable sessions.
• Performed Unit testing, System Testing and Performance testing for the ETLS. Created detailed Unit Test Document with all possible Test cases/Scripts.
• Involved in migration of code to QA and PROD for both ET and reports.
• Generated various reports like parameterized, Cascading parameters, subreports, drill down, drill through, sub reports using SQL Server Reporting Services (SSRS).
• Created standard report subscriptions.
• Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager
• Creating Adhoc reports as per the client requirements.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Scheduled reports using a third party tool.

Environment: Informatica 8.1, Oracle 11g, SQL server 2012, SQL, T-SQL, Toad 6.6

Senior ETL and Report Developer

Responsibilities:

• Primary SME (Subject Matters Expert) for the existing application designed using tools like BODI and OWB
• Writing the custom ETL as to perform the desired task as per the client requirements for the three modules.
• Understood the existing application build in BODI, Owb and oracle and replicated the same in Microsoft.
• Analyzed data extraction 7 different source system and end to end load earlier done using BODI and implemented the same in new MSBI platform
• Responsible for maintenance of the applications. Involved in fixing bugs in daily loads and providing permanent solution
• Creating Re-usable components like templates and other database objects like stored procedures and functions which can be used repeatedly.
• Scheduling/monitoring ETL jobs and coordinating with 3rd party vendors and resolve the same
• Worked in preparing mapping documents, code review checklist and technical design documents as per MSBI Coding Standards
• Involved in preparing proof of concept to demonstrate SSIS.
• Creating Adhoc reports as per the client requirements.
• Working as onshore coordinator that includes client interaction and coordination between client, onshore and offshore team.
• Has performed various levels of Testing such as Unit testing, System testing, Functional testing, and Pre-Prod ETL testing. Has worked on the Performance tuning of SQL queries.
• Analyzed the UNIX scripts of the legacy system and implemented the same Functionality in the new system.
• Worked on GO-LIVE for the applications by automating the ETL and other processes.
• Worked in preparing mapping documents, code review checklist and technical design documents as per MSBI Coding Standards

Environment: SSIS, BODI, OWB, SQL Server, Unix, SSRS, Oracle.