SUMMARY

• 8+ years of strong experience in designing and implementing Data Mart / Data Warehouse applications using ETL tools INFORMATICA Power Center 9.1 8.6, 8.5, 8.1.2, 8.1.1 (Designer / Workflow Manager), Informatica Power Exchange/IDS/IDQ/MDM.
• Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, also created Mappings and Workflows
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
• Proficient in using Informatica Workflow manager, Workflow monitor, pmcmd (Informatica command line utility) to create schedule and control Workflows, tasks and sessions.
• Extensively worked on database applications using DB2, Oracle, SQL*Plus, PL/SQL, SQL*Loader, Composite.
• Experience in modeling Transactional Databases and Data Warehouses using tools like Erwin.
• Experience in Production support and SLA’s.
• Experience in incident management, problem management and change management
• Experience in developing Logical and Physical models and implementing them in Oracle.
• Experience designing the entities and ERD of the data warehouse.
• Experience in Integrating data from various sources Oracle, DB2, Sybase using Composite 3.7/5.1
• Experience in creating entity relational & dimensional relational data models with Kimball Methodology (Star schema and Snow flake schema architectures, Fact/dimension tables)
• Documented design procedures, operating instructions test procedures and troubleshooting procedures.
• Knowledge about Pushdown Optimization utility in Informatica.
• Used partitioning in Informatica to improve session performance for very large loads.
• Knowledge in design and development of Business Intelligence reports using BI tools - Business Objects XI R2/R3, Cognos and experience developing Crystal reports.
• Experience in Production Support.
• Worked as On-Site co-coordinator for an off-shore development team in India.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• Solid time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews according to the varied needs of the people involved

TECHNICAL SKILLS

DATA WAREHOUSING TOOLS: Informatica 9.6.1/9.1.0/8. x/7.x, Business Objects XI R2/R3, Cognos 8, Crystal reports 10/2008, DataStage, SSIS, SSRS

DATABASES: Oracle 11g/10g/9i/8i, SQL Server, Sybase, DB2, Composite 3.7/4.1

DATA MODELING TOOLS: Erwin, TOAD

LANGUAGES: C, JAVA, VB, PL/SQL, TSQL

WEB PROGRAMMING: HTML 5, CSS 3

WINDOWS APPLICATIONS: MS Excel, Word, Power Point, Outlook, Visio, Access

ENVIRONMENT: S: Client/Server, Data warehouse

OPERATING SYSTEMS: Windows XP/Vista/7, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential - Newport Beach, CA

Sr. Informatica / Data warehouse Developer

Responsibilities:

• Created and maintained mappings, sessions and workflows.
• Worked with QA team to facilitate testing incremental loads and with users for UAT.
• Created reusable transformations and Mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer and Mapplet Designer, respectively.
• Implemented SCD Type1, Type2.
• Implemented push down optimization and partitioning techniques to facilitate parallel processing.
• Been a part of Informatica/Oracle migrations and associated testing.
• Worked with the Enterprise Architect to optimize the table structures/Indices/schema as a part of design discussions.
• Extensively worked on optimization of mappings.
• Created/Modified jobs as Unix scripts and Control-M tables for automation.
• Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse. Help develop the optimum solutions for data warehouse deliverables.
• Involved in production planning and analysis with Business and Project Management.
• Create scripts/Jobs for watch-file functionality, run calendar utilities.

Environment: Informatica Power Center 9.6.1/IDS/MDM, Oracle 11g/12c, Toad, PL/SQL, Linux, Control-M

Confidential - Irvine, CA

Sr. Informatica / Data warehouse Developer

Responsibilities:

• Developed PL/SQL procedures for Oracle 11g source.
• Created and maintained mappings, sessions and workflows.
• Been a part of architecture team to design the entities and develop ERD and respective dimensions and facts.
• Worked with QA team to facilitate testing incremental loads and with users for UAT.
• Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer and Mapplet Designer, respectively.
• Implemented SCD Type1, Type2.
• Extensively worked on optimization of mappings.
• Worked with run team for configuration and scheduling of the scripts and workflows using Control-M.
• Raised change requests, incident Management, analyzed and coordinated resolution of program flaws for the Development environment and hot fixed them in the QA, Pre-Prod and prod environments, during the runs using QA Complete ticketing system.
• Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse. Help develop the optimum solutions for data warehouse deliverables.
• Maintained all team owned databases used in development and SIT environments.
• Involved in production planning and analysis with Business and Project Management.

Environment: Informatica Power Center 9.5.1, Oracle 11g, Toad 8.6, PL/SQL, Solaris, Control-M

Confidential - Los Angeles, CA

Sr. Informatica / Data warehouse Developer

Responsibilities:

• Involved in project from Requirement gathering, BRD analysis, Design and development of warehouse till reporting.
• Been a part of architecture team to design the entities and develop ERD and respective dimensions and facts.
• Developed Linux scripts to FTP the flat files between vendor and native lockboxes and to pre-process and clean the flat files before staging.
• Worked with business to establish the scope and scalability of the application.
• Implemented Agile in the beginning and scrum methodology towards the end phase of the project.
• Worked with QA team to facilitate testing incremental loads and with users for UAT.
• Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings. Created reusable transformations and Mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer and Mapplet Designer, respectively.
• Implemented SCD Type1, Type2, Type1 with soft deletes and Many-to-Many bridge entity.
• Extensively worked on optimization of mappings for heterogeneous data sources.
• Worked with BI team in the universe design using business objects and creation of templates for canned reporting and development of measures and filters for Ad-hoc reporting.
• Worked with run team for configuration and scheduling of the scripts and workflows using Active Batch 7.
• Raised change requests, incident Management, analyzed and coordinated resolution of program flaws for the Development environment and hot fixed them in the QA, Pre-Prod and prod environments, during the runs using QA Complete ticketing system.
• Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse. Help develop the optimum solutions for data warehouse deliverables.
• Maintained all team owned databases used in development, test and UAT environments.
• Involved in production planning and analysis with Business and Project Management.

Environment: Informatica Power Center 9.0.1, Business Objects XI R3, Oracle 11g, Toad 8.6, win SQL, MS Excel/VB, PL/SQL, MS SQL server R2, Linux, Active Batch

Confidential - New York, NY

Sr. Informatica Developer

Responsibilities:

• Responsible for investigation, characterization, and communication of build and release problems, implementing corrective and preventive actions. Resolved all the issues with JIRA tickets on priority basis.
• Analyzed Change request (CR) as per requests from JIRA. Creating SR to Informatica Inc. -related to any Power center product issues.
• As per Change requests (CR) migration of objects in all phases (DEV, QA and PROD) of project and trained developers to maintain system in UAT and production environments.
• Worked on VB Macros in Excel for reporting purposes.
• Ensures proper configuration of the Power Center Domain components. Experience in nodes, Repository services, Integration services, and Reporting Services.
• Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings. Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer and Mapplet Designer, respectively.
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions type two and type one.
• Raised change requests, incident Management, analyzed and coordinated resolution of program flaws for the Development environment and hot fixed them in the QA, Pre-Prod and prod environments, during the runs using JIRA ticketing system.
• Ensures proper application of the licensing files. Creating Folders and manages user and user group access to objects based on LDAP settings.
• Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse. Help develop the optimum solutions for data warehouse deliverables.
• Maintained all team owned databases used in development, test and UAT environments. These databases are also used for training purposes.
• Worked with DBAs on issues related to Production Databases.
• Involved in production planning and analysis with Business.
• Used Autosys to schedule Informatica workflows and UNIX scripts to automate jobs.

Environment: Informatica Power Center 9.0.1, 8.6.0, Business Objects XI R3, Crystal Reports 10, Sybase, DB2, Composite 3.7/4.1/5.1, Oracle 10g, Toad 8.6, win SQL, MS Excel/VB, PL/SQL

Confidential - Atlanta, GA

Informatica Developer

Responsibilities:

• Involved in business requirements, created data mapping documents.
• Build ETL mappings to pull data from Oracle, flat files to target sql server database
• Designed and developed mappings with optimal performance using Aggregator, Java, Joiner, Normalizer, Rank, Sequence Generator, SQL, Transaction Control, Un-Cached & various kinds of Cached Lookup, Connected-Unconnected-Source Target pre and post load Stored Procedure Transformations, Update Strategy, Union, XML Transformations, etc.
• Created sessions and workflows to help schedule nightly loads and process data from all source terminal Data Collection points.
• Extensively used pre-session and post-session variable assignment for simulating multithreading scenarios for Load balancing and performance improvement.
• Used pre-session and post-session variable assignment to transport variable (flags and counters) values across sessions and work-lets.
• Used Constraint Based loading & target load ordering to efficiently load tables with PK-FK relation in the same mapping.
• Edited different kinds of Partition points and Created partitions to improve performance by activating multiple Transformation Threads for optimal use of system resources.
• Executed stored procedures from source qualifiers and SQL transformations and used the return data set in the mapping.
• Used Normalizer Transformation to normalize data from COBOL sources and used Aggregators to De-normalize records to create one record.
• Implemented SCD methodology including Type 1, Type 2 changes to keep track of historical data.
• Wrote shell scripts and Stored Procedures for regular Maintenance and Production Support to load the warehouse in regular intervals and to perform Pre/Post Session Actions.
• Used reusable look-up transformations, across the folders.
• Used Incremental Aggregation technique to load data into Aggregation tables for improved performance.
• Wrote the PL/SQL procedures for data extraction, transformation and loading.
• Extensively used Parameter file to override mapping parameter, mapping Variables, Workflow Variables, Session Parameters, Ftp Session Parameters and Source-Target Application Connection parameters.
• Involved in scheduling the workflows through Autosys and Job scheduler using UNIX scripts.
• Monitored the jobs daily and involved in production support.

Environment: Informatica Power Center 8.6/8.1, Power exchange, DB2, Sybase, Oracle, UNIX, DB Artisan, PUTTY.

Confidential - Boston, MA

Informatica Developer

Responsibilities:

• Gathering requirements, conducting a design overview, detailing ETL specifications, data analysis/troubleshooting, implementation tasks, and general mentoring.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Providing in-depth technical consultation to ensure development of efficient application systems by utilizing standard methodologies and best practices.
• Writing program specifications and developing mappings.
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers.
• Provide technical leadership to other support team members and resolution of technical issues.
• Creating Informatica Mappings to implement complex business rules by using mapplets, reusable transformations and mapping parameters.
• Designing and Developing Mapping specifications, Physical Flow diagrams and build documents.
• Developing reusable mappings to process real time files/admin systems extracts, error handling and notification processes.
• Experience with high volume datasets from various sources like Oracle, DB2, SQL Server, Text Files, XML files and Netezza Relational Tables.
• Developing mappings, workflows and schedules that reflect ETL methodology standards
• With Power Exchange (CDC option), captured the database inserts, updates, and deletes in the available data. Transformed and cleansed the data continuously without staging tables.
• Created test data using Power Center Data Masking Options (Key Masking, Random masking, Expression masking, Substitution) in mappings.
• Involved in the technical analysis of data profiling, mappings, formats, data types, and development of data movement programs using Power Exchange and Informatica.
• Designing and implementing schemas for reference data, Change Data Capture, process control and audit balancing.
• Developing mappings/mapplets, and utilizing dynamic parameter files.
• Using transformations like Normalizer, Lookup, Aggregator, Expression, Sequence Generator, Router, Filter, Joiner and Union Transformations.
• Creating partitions to improve the Session Performance.
• Migrating projects between multiple environments (Development, QA, UAT and Production).

Environment: Informatica Power Center 8.6.1, Power exchange, Oracle 10g, Netezza, PostgreSQL, SQL Server 2005, Control-M, SAP R/3, Erwin, Windows, UNIX, Metadata manager.

Confidential - Boston, MA

Informatica developer

Responsibilities:

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Parsing high-level design specs to simple ETL coding and mapping standards. Designed mapping document, which is a guideline to ETL Coding.
• Created Mappings to move from Various Systems into the Data Warehouse.
• Worked on Informatica tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
• Transformed bulk amount of data from various sources to Teradata database using BTEQ scripts.
• Transferred data using Teradata utilities like SQL Assistant, Fast Export and Fast Load.
• Created different Transformations for loading the data into target like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Performed Reverse Engineering of the legacy application using DDL scripts in Erwin, and developed Logical and Physical data models for Central Model consolidation.
• Worked with the Production Support team, to meet client requirements.
• Worked with DBA to create a best-fit Physical Data Model from the Logical Data Model using Erwin.
• Written Scripts using PERL.
• Writing Stored Programs (Procedures & Functions) to do data transformations and integrate them with Informatica programs and the existing application.
• Used mapping parameters and variables.
• Worked on Parameterize of all variables, connections at all levels in Window NT.
• Helped maintain the Quality of the Data by performing Data Analysis and Data Enhancement processes.

Environment: Informatica Power Center 8.1.3, Workflow Manager, Workflow Monitor, IDQ Erwin 4.0/3.5.2, TOAD 8.6.1.0, PL/SQL, Flat files, XML, Oracle 10g/9i/. Teradata.

Confidential

Business Intelligence Associate/Developer

Responsibilities:

• Created Transformations, Mappings, Sessions, and Workflows using Informatica.
• Performed performance optimization on Informatica mappings and workflows.
• Created reusable transformation and mappings.
• Created reports using Business Objects XI R2/R3, Crystal Reports X/2008 across various databases.
• Does unit testing across the test server and the EOD production data (regression, manual)
• Collaborated with the business and clients for UAT and production planning.
• Implemented production turnovers on weekly basis besides pre-production and post-production testing
• Worked with the business to optimize the generation of reports and load balancing depending on the count, parameters and format etc.,
• Created CSV and fixed width reports using formulas, filters and with and without parameters etc., which are compatible with client data load process for their native databases.
• Designed Report Template according to the Company standard requirements.
• Created stored procedures in various databases like Oracle, Sybase, DB2 and Composite
• Create, modify and support excel macro based reports for business areas with legacy systems.
• Implemented data integration from various databases using Composite
• Create, modify and maintain the workflows using Informatica 8.6
• Maintain perforce based version control of templates and stored procedures
• Create documentation and maintain the knowledge base KM2.0 using Twiki.
• Does Knowledge transfer to the new hires and cross project teams as and when needed
• Collaborate with offshore team on bi-weekly basis, onsite and clients on weekly basis for assignment summary

Environment: Informatica Power Center 7.1/8.1/8.6, Business Objects XI R2, Cognos 6, Oracle 10g, Sybase, DB2, Windows XP, SQL, PL/SQL, TSQL