SUMMARY:

• Over 8+ years of IT experience with extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
• Extensive Data Warehouse experience using Informatica Power Center / Power Mart (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation Designer) as ETL tool.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger).
• Expertise in Dimensional data modeling, Star schema modeling, Snowflake modeling, Data Normalization.
• Worked with Full Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes.
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions. Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
• Proficient in creating UNIX Shell Scripts.
• Strong experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Strong Expertise in using Tools like Tableau Server, Tableau Desktop and Qlikview.
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Worked with Business Analysts, Development, and end users to correlate Business Logic and Specifications for ETL Development.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Used Informatica Power Exchange for loading/retrieving data from mainframe system.
• Change Data Capture has done using the Power Exchange .
• Self - motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.
• Strong decision-making and interpersonal skills with result oriented dedication towards goals.
• Provided support to fix the bugs identified in the production.
• Involved in data analysis and handling the ad-hoc requests by interacting with business analysts, clients and customers and resolve the issues as part of production support.
• Used InformaticaPowerExchange for loading/retrieving data from mainframesystem.
• Change Data Capture has done using the Power Exchange.

TECHNICAL SKILLS:

ETL Tools: Informatica Power center 9.x/8.x/7.x/6.x, Informatica Power Exchange 8.x/9.x, Data Stage 7.5

Reporting Tools: Tableau Desktop 7.0/8.0/8.1, Cognos

Operating Systems: UNIX, Windows 98/ NT/2000/XP, Solaris

Database: TERADATA 14.x, Oracle 10g/9i, SQL Server,DB2

Database GUI Tools: TOAD, SQL Assistant

Web Development: HTML,XML

Programming Languages: Oracle SQL, PL/SQL, UNIX, Shell Script, C, C++.

Scheduling Tool: Autosys, ZENA, IBM WLM, Control M.

Data Modelling: Erwin

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Informatica Developer

Responsibilities:

• Identified data source systems integration issues and proposing feasible integration solutions.
• Partnered with Business Users and DW Designers to understand the processes of Development Methodology, and then implement the ideas in Development accordingly.
• Worked with Data modeler in developing STAR Schemas and Snowflake schemas.
• Created Oracle PL/SQL queries and Stored Procedures, Packages, Triggers, Cursors and backup-recovery for the various tables.
• Identifying and tracking the slowly changing dimensions (SCD)
• Extracting data from Oracle and Flat file, Excel files sources and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to extract and load data into the target systems.
• Created reusable Mailing alerts, events, Tasks, Sessions, reusable worklets and workflows in Workflow manager.
• Scheduled the workflows at specified frequency according to the business requirements and monitored the workflows using Workflow Monitor.
• Embedded Tableau views in to application.
• Generated tableau dashboards with combination charts for clear understanding.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Embedded Tableau views in to application.
• Generated tableau dashboards with combination charts for clear understanding.
• Involved in meetings with Global Team executives to explain about the reports and to make sure reports met their requirements.
• Involved in data analysis and handling the ad-hoc requests by interacting with business analysts, clients and customers and resolve the issues as part of production support.
• Extensive experience in designing & implementing Cross Product Solutions and Coordinating Activities between multiple stakeholders.
• Fixing invalid Mappings, Debugging the mappings in designer, Unit and Integration Testing of Informatica Sessions, Worklets and Workflows.
• Extensively used TOAD for source and target database activities.
• Involved in the development and testing of individual data marts, Informatica mappings and update processes.
• Created repository, users, groups and their privileges using Informatica Repository Manager
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.
• Generated simple reports from the data marts using Business Objects.
• Designed Batch Processing system for applications using AutoSys. Developed standardized scripts for job implementation.

Environment: Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Power Exchange,Talend, Teradata, UNIX, Oracle 10g, Mainframes (DB2, VSAM Files, Sequential Files), Autosys.

Confidential, TX

Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• 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.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Creating Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in Tableau.
• Performing data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Involving in troubleshooting, performance tuning of reports and resolving issues within Tableau Server and Reports.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDMfrom various source systems.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationshiptypes, profiles, put and display packages and used the entity types as subject areas in IDD.
• Assisted with implementation/upgrade of AutoSys and JAWS, troubleshoot errors, and documentation/procedures.
• Provided support to fix the bugs identified in the production.
• Involved in data analysis and handling the ad-hoc requests by interacting with business analysts, clients and customers and resolve the issues as part of production support.
• Extensive experience in designing & implementing Cross Product Solutions and Coordinating Activities between multiple stakeholders.
• Responsible for problem identification and resolution of failed processes or jobs and assisted customers in troubleshooting issues with their applications in AutoSys.
• Automated the process of starting and stopping dtlcacon/pwxccl process by creating a shell script.
• Applied different types of monitoring for Power exchange processes like dtlcacon monitoring, dtllst monitoring, oracle scn monitoring, lag monitoring scripts, Heartbeat table to monitor the lag.

Environment: Informatica Power Center(Repository Manager, Designer, Workflow Manager, Workflow Monitor),Informatica Power Exchange, SQL Server, IBM DB2, Oracle 10g, Toad, UNIX Shell Scripting, Flat Files, SQL Developer, and, Autosys.

Confidential, FL

ETL Developer

Responsibilities:

• Involved in detailed analysis of requirements and creation of requirement specifications and functional specifications.
• Analyzed business requirements and worked closely with various application teams and business
• To develop ETL procedures that is consistent across all application and systems.
• Involved in Creating Fact and Dimension tables using Star schema
• Built Repositories using Informatica Power Center Repository Manager to store Source, Target, Transformations, Mapplets and Mappings Meta Data Information.
• Created many visualizations like filled maps, geo maps based on dimensions and measures which gives the End user more visibility to make decisions based on the region.
• Created many Dashboards and KPI reports using relevant Marks or Highlight functionalities.
• Implemented data blending to blend related data from different data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Tableau.
• Involved in creating many complex Ado and Dynamic reports with calculated fields, filters, parameters, hierarchies, sets and groups.
• Managed Agile Software Practice using Rally by creating Product Backlog, Iterations and Sprints in collaboration with the Product Team.
• Worked on Informatica tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed various Mappings, Mapplets and Transformations for migration of data from various existing systems to the new system using Informatica Power Center Designer.
• Extracting and loading of data from flat file, Oracle sources to oracle database (target warehouse) using transformations in the mappings.
• Created Informatica mappings with SQL, PL/SQL procedures and Functions to build business rules to load data.
• Wrote shell scripts and control files to load data into staging tables and then into Oracle base tables using SQL*Loader.
• Performed tuning of sessions in Target, Source, Mappings and Session areas.
• The result of sessions has been track through log files using session manager.

Environment: Informatica Power Center, Tableau Desktop 8.2, Teradata, DB2, PL/SQL, SQL*Loader, Windows NT and UNIX, SQL Assistant, SQL Server 2008.

Confidential, VA

Informatica Developer

Responsibilities:

• Involved in Designing and developing multi-dimensional model (Star Schema) using Erwin
• Scheduling meetings with the business users to gather the business analysis reporting requirements.
• Designing and developed ETL process.
• Developed Mappings and reusable Transformations and Mapplets.
• Extensively worked with Informatica Transformations and also Override SQL using Oracle Functions.
• Informatica Server Manager usedto create database connections, sessions, and batches to run the mappings.
• Various Performance and Tuning techniques used to improve the load.
• Involved in writing of Triggers, Functions, and Packages.
• Converting from SQL/Procedures and SQL Loader scripts to Informatica mappings
• Scheduling the batches and sessions for daily loads.
• Automation of FTP process to and from source systems.
• Involved in writing UNIX shell scripts and PL/SQL procedures, Pre-session and Post- Session Scripts.

Environment: Oracle9i, Sun Solaris, Windows NT/2000, Informatica PC 6.x SQL loader, Toad Modeler.

Confidential

ETL Programmer

Responsibilities:

• Installed Informatica Power Center Server manager & Power Center client.
• Performed design of ETL components in this project. Creation of Design documents, Development and testing were my primary responsibilities.
• Created the warehouse tables using Informatica Power Mart Warehouse designer.
• Designed the source to target mappings that contain the business rules for the server during the extract, transform and load process using Informatica ETL Tool.
• Created Mappings in Informatica Designer to extract data from Heterogeneous data sources like Oracle, COBOL files, MS SQL Server, MS Access & Excel Sheets to load into the data warehouse with various types of transformations like Aggregator, Expression, Filter, Joiner, Lookup, External Procedure, Router & Update Strategy.
• Created and maintained documents including data quality plan design, mapping inventory, mapping specifications, change request form, unit test plan, test case list, target-source matrix etc.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Tasks, Workflows and the Target Data.
• Making Enhancement and fixes in the Procedures, Packages, Triggers.
• Creation of Bitmap indexes & Partitioned indexes for partitioned tables to maximize performance.

Environment: Informatica Power Center, Oracle, MS SQL Server2003, PL/SQL, Windows NT.