SUMMARY:

• 11+ years of IT experience in Informatica Data Analysis, Design and Development for various software applications in client - server environment in providing Business Intelligence Solutions in Data Warehousing for extensive experience in Informatica Power center 10.1.0,9.x, 8.x, 7.x
• Strong Data Warehousing fundamentals with expertise in Design and Development of ETL.
• Used Informatica Cloud connector to get data from Confidential web service to salesforce using data synchronization task and REST API service.
• Used Informatica IDQ to create column profiles and implement scorecards for a trend analysis and data quality reporting.
• Implemented B2B Data Transformation mapping to load xml data into data warehouse.
• Experience in Creating the Data Mart using the3 Flat file sources.
• Expertise in implementing complex business rules by creating re-usable transformations and Mappings/Mapplets.
• Worked with different relational sources like Oracle, DB2, Tera Data and SQL Server.
• Created and modified the databases, tables and database objects writing SQL queries, stored procedures, functions and triggers using PL/SQL.
• Performed SQL tuning, created Indexes for performance improvement.
• Analyzed slow-running queries and fixed it using query plans.
• Involved in the High level design for the ETL solution and reviewing of the detailed level design.
• Implemented Informatica MDM solution for customer and policy data.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files, XML files, COBOL Mainframe files.
• Expert in database design and programming using SQL, PL/SQL with SQL Server 2000/2005/2008 .
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.
• Obtained knowledge on various phases of data warehouse development lifecycle, from gathering requirements to design, development, testing & UAT.
• Extensively worked with Informatica Tools - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Repository Manager.
• Involved in Performance tuning of Informatica Mappings and Sessions.
• Extracted data from DB2, SAP and mainframe COBOL files in Power Exchange.
• Experience in ETL design, Scheduling, Frequencies, Failure Reporting, Audit Trails, Data Cleansing Strategies, and Performance Testing Benchmarks.
• Experience in implementing the complex business rules by creating transformation, re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy, SQL), and developing complex Mappings.

TECHNICAL SKILLS:

Data Warehousing ETL: Informatica Power Center 10.1.0/9.5/9.0/8.6/7.x/6.x and Informatica Server, Power Exchange, Power Mart 4.7.2/5.1 and Power Connect. IDQ(Informatica developer/analyst) 10.1.0, Informatica MDM, Informatica Cloud .

Data Modeling: ERWIN 7/4.0/3.0, MS VISIO.

Databases: Teradata V2R12/V2R6/V2R5, Oracle 12c/11g/10g/9i, MS SQL server 2000/2005/2008, DB2 UDB 8.1, MS Access.

Programming: SQL, PL/SQL, Unix & Shell Scripting, SQL Tuning/Optimization, C, C++, ASP, VB.NET, PL\SQL, Java.

Tools: TOAD, SSIS/DTS, SQL *Plus, SQL* LOADER, Clear View, Excel, Word, Power Point, Autosys, Control-M, IBM Tivoli Workload.

Operating System: Linux, MS-DOS, Windows 7/95/98/NT/2000/2003/XP/Vista/Server.

Methodology: RUP, OOAD, Waterfall, Agile.

Applications: Database and Application Server, Internet Information Server, SSIS, SSRS, Crystal Report, Autosys Job Scheduler, Microsoft Office, MS Visio, Adobe Photoshop, Toad, HP Service Manager.

PROFESSIONAL EXPERIENCE:

Confidential, Washington,DC

Sr. Informatica Developer

• Capture daily data from sources like SQL server, DB2, Mule soft etc. for trend analysis using tableau dashboards for the upper management and mechanical engineering division.
• Oversaw the migration of Informatica from Confidential managed servers to Amazon Web Service. Involved multiple challenges on the way from replicating the UNIX server/ roles/security to managing the transfer without any impact to other dependent systems
• Used the Informatica Data Quality (IDQ10.1.0) tool Informatica analyst to create profiles and Scorecards for dimension and fact tables. Created common data quality rules on the columns to apply to those profiles for data quality analysis.
• Used B2B Data Transformation to get xml files and insert data into EDW tables.
• Used Informatica Data Quality (IDQ10.1.0) tool Informatica Developer to create mapplets to scrub/validate all the staged data before it gets loaded to the facts and dimensions. Implemented the business rules and exported them as mapplets to add to Informatica power center.
• Implemented tasks to retrieve passenger data from Confidential web service to salesforce.com using Informatica Cloud connector.
• Implemented business rules for data as varied as financial data, customer data, IOT data, and supply management data like food and beverages. Worked to set up rules for Data quality enforcement and design of the Informatica mappings using low level documents from the same.
• Worked with flat files coming from Mule Soft application that itself sources the data from Salesforce.com. Implemented data quality control/communication for complex source being handled by various teams like Mulesoft, Hybris, and salesforce.com
• Worked on creating Data failure/Reject and timeliness metrics for complete informatica workflows and processes as part of Data Governance.
• Used various transformations of Informatica, such as Source Qualifier Transformation, Expression Transformation, Look-up transformation, Update Strategy transformation, Filter transformation, Router transformation, Joiner transformation, SQL Transformation etc. for developing Informatica mappings.
• Configured Power Exchange 9.5.0 to extract data from DB2 and SAP sources.
• Developed Informatica mappings for TYPE 1, 2 Slowly Changing Dimensions employee dimension.
• Creating sessions and work-flows for the Informatica mappings.
• Configuring sessions for different situations including incremental aggregation, pipe-line partitioning etc.
• Creating mappings with different look-ups both connected look-up, unconnected look-up
• Creating various mapplets as part of mapping design.
• Involved in development and maintenance of the data warehouse for reporting
• Created Sessions, Reusable Worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
• Hands on experience in handling large volumes of data in production environments.
• Involved in Performance tuning by determining bottlenecks in sources, mappings and sessions.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Troubleshooting the loading failure cases, including database problems
• Worked with XML files to share the XML elements and extract the necessary data from the XML
• Prepared Documents like Technical Design Doc, Production Support Doc, Deployment Doc
• Documented Mappings, Transformations and Informatica sessions.

Environment: Informatica Power Center 10.1.0/9.5.1 (Source Analyzer, Data Warehousing Designer, Debugger, Mapping Designer, Mapplet, Transformations), Informatica Developer(IDQ)10.01,Oracle 12c/11g, Toad, MS SQL Server 2005, HPQC, SCCD, MS Visio

Confidential, Stevens Point,WI

Sr. Informatica Developer

• Involved in all phases of development from requirement gathering to production deployment.
• Worked closely with system architect for data modelling and implementing warehouse design as per his specification.
• Used Informatica cloud to copy real time data that was being entered on the website.
• Developed Informatica mappings for dimensions and facts including junk dimensions, fact less facts.
• Built master data for customer data for insurance policies with Informatica MDM.
• Used SQL server database logs to implement CDC for real time data capture and provide up-to-date information.
• Implemented a historical load of over 30 years’ worth of data to the warehouse for analysis.
• Created data maps to extract data from mainframe COBOL files in Power Exchange 9.
• Tuned the performance of the Informatica workflow to increase the performance.
• Involved in supporting the QA testing of the data and performed and produced Unit test artifacts.
• Worked with XML files to share the XML elements and extract the necessary data from the XML
• Prepared Documents like Technical Design Doc, Production Support Doc, Deployment Doc
• Documented Mappings, Transformations and Informatica sessions.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Ran SQL queries and validated the data in warehouse and mart using PL/SQL
• Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.
• Extensively involved in testing by writing QA procedures for testing the target data against source data.

Environment: Informatica Power Center 9.0.1 (Source Analyzer, Data Warehousing Designer, Debugger, Mapping Designer, Mapplet, Transformations), Informatica Developer(IDQ),Oracle 11g, Toad, MS SQL Server 2005

Confidential, Milwaukee,WI

Informatica Developer

• Involved in requirements gathering and analysis for the entire application.
• Writing SQL stored procedures, Views, Functions for data manipulation and querying data for SQL SERVER 2008.
• Involved in complete SDLC of the application.
• Designed and Implemented the Extraction, Transformation, and Load (ETL) techniques built using Informatica, SQL, PL/SQL and Unix Shell Scripting.
• Developed various Stored Procedures, Functions, Packages and Materialized views for ETL needs.
• Performing SQL tuning, created Tables, Indexes for performance improvement
• Created SSIS packages using Integration Services for the import and export of the data in SqlServer2005.
• Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console.
• Incorporated various transformations, Lookups, Expressions, Routers, Sequence generators, mapplets, dynamic lookups and reusable transformations in ETL maps
• ETL performance (Data base and ETL jobs) by optimizing back end queries, by implementing techniques like index drop and re-create, table partition, parallelism etc
• Performed Database/ETL migrations from Dev environment to Test/Training/UAT/Staging and PROD environments

Environment: SQL Server 2008, Informatica, Power Center 8.6, Oracle 9i, PL/SQL Developer, SQL*Loader, Toad, ER-Studio, UNIX, Informatica 8.6

Confidential, Milwaukee,WI

Informatica Developer

• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations.
• Created different source definitions to extract data from flat files and relational tables for Informatica Power Centre.
• Used Star Schema approach for designing of database for the data warehouse
• Developed a standard ETL framework to enable the reusability of similar logic across the board.
• Created different target definitions using warehouse designer of Informatica Power Center.
• Used mapping designer to generate different mappings for different loads.
• Created different transformations such as Joiner Transformations, Look-up Transformations, Rank Transformations, Expressions, Aggregators and Sequence Generator.
• Created stored procedures, packages, triggers, tables, views, synonyms, and test data in Oracle.
• Extracted source data from Oracle, Flat files, XML files using Informatica, and loaded into target Database.
• Created medium to complex PL/SQL stored procedure for Integration with Informatica using Oracle 10g.
• Developed complex mapping also involving SCD Type-I, Type-II, Type-III mapping in Informatica to load the data from various sources
• Extensively transformed the existing PL/SQL scripts into stored procedures to be used by Informatica Mappings with the help of Stored Procedure Transformations.
• Involved in extensive Performance Tuning by determining bottlenecks in sources, mappings and sessions.
• Validate the data in warehouse and data marts after loading process balancing with source data.
• Worked closely with the business analyst’s team in order to solve the Problem Tickets, Service Requests. Helped the 24/7 Production Support team

Environment: Informatica Power Center 8.6, Oracle 9i, MS SQL Server, TWS, UNIX

Confidential, Baltimore,MD

Technical Analyst/Programmer

• Worked as onsite co-coordinator and team lead for all the enhancements related to the Bridge Project.
• Programmed modules and worked closely with offshore developers to maintain the development schedule.
• Performed VB.NET Code walkthrough and code review to ensure the coding standards are maintained.
• Created design specifications and test cases in accordance with the functional specifications.
• Reported weekly project status updates to senior management and the Executive Management Committee.
• Worked with the QA team for creation of Test Plans and Test Cases from the Business Requirement document and design document to cover overall quality assurance.
• Conducted Functionality testing, Integration testing, Regression testing, and ETE testing.
• Created Help files for each release using Adobe Robohelp (html).

Environment: XML, VB.NET, ASP.NET, ADO.NET, MS Office, Windows XP, Rational Clear quest. Oracle 9i, Adobe Robohelp, Autosys Scheduler, Toad for Oracle, Crystal Report

Confidential

Technical Analyst/Programmer

• Template Creation and modifications.
• Writing Stored Procedures, Ad-hoc reports creation.
• Involved in all the phases of Software Development Life Cycle of the project.
• Used leadership skills successfully turned around the delayed project.
• Participated in the team meetings to discuss the issues arising out of testing.
• Involved in creating Test Plans and Test Cases from the Business Requirement document and design document to cover overall quality assurance.
• Created Stored procedures to return and MS Word templates to display Application Data.
• Wrote and modified VB Code to pull in the data on the MS Word template.
• Used SQL queries to test the integrity of data by querying the database.
• Creation of Ad-hoc reports using crystal reports template.
• Involved in creating internal reporting and database solutions using software such as Crystal Report 10, Access, MS Word and PL/SQL.

Environment: Rational Suite, Crystal reports, MS Project, VB, MS Office, Oracle, Windows NT/2000.