SUMMARY:

• More than 6 yrs. of IT - industry experience in Data warehousing and all phases of Software development life cycle (SDLC).
• More than 5 yrs of experience in Data analysis using Microsoft Excel(pivot table) and Tableau8.3
• Experience in Informatica Power center 8.x, 9.x, Informatica Power Exchange 8.x., Teradata 12.
• Good experience in Data Warehousing, Conceptual, Logical and Physical Data Modelling.
• Experience in Tableau Dashboards in Design and Presentation.
• Develop enterprise dashboards and reports using OBIEE Plus tools.
• Identify critical issues and processing faults to optimize BI dashboards and reports.
• Familiar with Python programing
• Perform testing sessions for reports and dashboards and resolve process issues.
• Excellent experience of creating data models for relational schemas (OLTP) and dimensional schemas (OLAP) with proper normalization and denormalization techniques and developed Database Schemas like Star Schema and Snowflake Schema.
• Designed and developed complex mappings using transformations like Lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Sequence Generator and Update Strategy.
• Experience in creating reusable transformations, mapplets and PL/SQL stored procedures.
• Worked on requirement gatherings of the reports for several projects, designed the data warehouse and developed mappings to load the data in the dimension and fact tables.
• Implemented slowly changing dimensions of Type 1, Type 2 and Type 3 and Performance tuning of sources, mappings, targets and sessions in Informatica and SQL queries.
• Implemented Centralized ‘Banking Application Software ‘Omni’ extensively. Experience in Testing, Implementation and Support in banking software.
• Worked extensively on writing SQL queries and Oracle constructs.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills. Ability to work in high-stress environments.

TECHNICAL SKILLS:

ETL Technology: Informatica 8.x,Informatica Power EXchange8.x

Datawarehouse: Star schema and snowflake schema

Data Modelling: MS Visio, Erwin

Application software: Banking software OMNI, MS Office and Toad and Microsoft Excel and Tableau8.3 for Data Analysis

Programming languages: Html, CSS, UNIX Scripting,Python

Database: Ms-Access, MS Sql server 2005/2008, Oracle 9i, Oracle 10g, Oracle 11g

Project Management software: Microsoft Project 2010

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer/Master

Responsibilities:

• A key member of Master Data Management, responsibilities include Data governance consisting Data Stewardship, Metadata management, Data Quality, Data Profiling, Data Integration & Consolidation.
• Responsible for Data analysis of customer data in salesforce versus D&B data.
• Responsible in maintaining the correct data in salesforce and eliminating the duplicates
• Involved in tool evaluation of various MDM tools like Informatica MDM, Talend, and IBM.Trillium.
• Well versed with Talend Integration cloud and Talend MDM.
• Participated in business meetings with BA and various departments for requirement gatherings of MDM tool and their pain points and responsible in preparing the BRD for same.
• Prepared the functional and non-functional document for MDM tool.
• Responsible for designing MDM application architecture (tool/no tool)
• Responsible for designing the Customer Hierarchy architecture in Oracle
• Key person in designing, developing and documenting the ETL process to load the salesforce data into Oracle using Informatica power center 9.1 for designing the Customer Hierarchy in Oracle.
• Designed the complex mappings and workflows and sessions using Informatica power center 9.1.
• Implemented the scd type 1 and scdtype2 tables to load the data from source to target.
• Extensively involved in performance tunning of ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions. This led to better performance.
• Used pmcmd to run workflows and handled incremental loading.
• Used Aggregator, sql overrides, source filter and source qualifier and data flow management into multiple targets using router transformations.
• Wrote complex Sql queries and Pl/Sql procedures to perform data base operations according to business requirements.
• Documented the process for further maintenance and support. Worked on test cases.

Environment: Informatica Power Center 9.1, Oracle 11g, PL/SQL, Salesforce, Flat files, UNIX

Confidential

Informatica developer

Responsibilities:

• Gathered report requirements with Business Users and converted them into project documentation.
• Created the mappings and workflows for loading data to the staging tables and then to the dimension and fact tables using Informatica Power center 8.6.
• Used transformations like Source qualifier, Lookup, Router, Joiner, Update strategy, Sequence generator, Expression and Filter Transformations in the project.
• Used Debugger to track the path of the source data and to check the errors in mapping.
• Involved in Data Modeling using Star/Snowflake Schema Design using Erwin.
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures.
• Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance.
• Used pmcmd to run workflows.
• Handled slowly changing dimensions of Type 1 and Type 2 to populate current and historical data to dimensions and fact tables.
• Responsible to write complex sql queries and scripts to perform database operations according to business requirements.
• Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance.
• Involved in end-to-end system testing, performance and regression testing and data validations.
• Worked on Data Extraction, Transformations, Loading, Data Conversions and Data Analysis.

Environment: Informatica Power Center 8.6, Teradata 12, Oracle 11g, Erwin 8, Putty

Confidential

Senior Engineer

Responsibilities:

• Worked as a Team Lead and Data analyst.
• Created database objects including tables, views, and indexes.
• Performance tuning of SQL queries by using Hints.
• Minimized the problems in ATM transactions by monitoring it and taking the necessary actions
• Generated statistical data by constructing and executing complex queries in oracle
• Provided support and adhoc reports to the Retail banking department regarding ATM

Environment: Oracle 10G, SQL*Plus, SQL, SQL*Loader, crystal Reports XI, UNIX, Toad

Confidential

Engineer

Responsibilities:

• Worked as a Team lead for more than a year.
• While working in IT Department, acquired domain knowledge in retail operations enabling active support for all queries/problems of end users using banking application software
• Wrote PL/SQL Stored Procedures, Functions, Packages and SQL queries using join conditions as per business requirements.
• Implemented Extraction, Transformation and Loading using SQL Loader and PL/SQL.
• Worked on the various phases of implementation of Banking software such as:
• User Acceptance Testing: Key Member of the team, included work pertaining to creation of test scripts, test data, carrying out actual tests, interaction with implementation team of application software provider and User
• Worked on the cut-over activities
• Production support to end users
• Service Desk
• I was the key person implementing Change management and Release Management
• Provided support to the business users for various process, configuration and data related issues by performing extensive troubleshooting
• Managed the service desk
• Created and maintained documentation
• Trained end users various times, created material and carried out in-house

Environment: Oracle 10G, SQL*Plus, SQL, SQL*Loader, Crystal Reports XI, UNIX, Toad