OBJECTIVE:

Seeking for a Professional position as ETL/Informatica Developer or as a Data Analyst.

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 OBIEE11.7,Microsoft Excel and Tableau8.3
• More than 2 yrs of experience in Master Data Management.
• More than 2 yrs of experience in Salesforce CRM and Oracle Ebs.
• More than 3yrs of experience in InformaticaPowercenter 8.x, 9.x,InformaticaPowerExchange8.x.,Teradata12
• 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, Big data, Hadoop/Hive.
• 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 and 9.x,Informatica PowerEXchange8.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, OBIEE11.7

Programming languages: Html, CSS, UNIX Scripting, Python

Database: Ms-Access, MS Sql server 2005/2008, Oracle9i, Oracle10g, Oracle11g

ETL tools: Informatica 8.x,Informatica PowerEXchange8.x, Teradata 12

Project Management software: Microsoft Project 2010

CRM: Salesforce and Oracle Ebs

PROFESSIONAL EXPERIENCE:

Confidential

Data Business Analyst

Responsibilities:

• Key member of the Data services team and responsible for maintaining correct data of customer accounts in salesforce.
• Deduplication of accounts in sfdc and Asset transfers of the customer accounts in Oracle Ebs.
• Maintaining the customer account hierarchies in customer data hub.
• Supporting the end users for the customer accounts and opportunities related queries.
• Keep a check on the synchronization between the sfdc and other upstream and downstream systems.
• Territory Management using Informatica .
• Enrich the customer data in sfdc using avention and hoovers data.
• Maintaining dashboards for customer accounts in sfdc.
• A Key member in generating monthly and adhoc reports in OBIEE for the management and maintaining dashboards.

Environment: Salesforce,Oracle EBS,OBIEE11.7,SQL

Confidential

Informatica Developer

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.
• Worked on the GoToMarket data and data cleansing of customer accounts before loading it in Anaplan.
• 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 scd type2 tables to load the data from sources to the targets.
• 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 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.

Environment: Informatica Power Center 9.1,Oracle11g,PL/SQL,Salesforce,Flat files,Unix

Confidential

Informatica developer, California

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:
• Business Process Reengineering, Gap analysis
• 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 training
• 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 training

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