SUMMARY:

• Over 12 years in delivering BI - data warehousing - analytics solutions to various clients. Like government agencies, large retail clients and other industry (Telco, Confidential ).
• Currently working as a Technical Lead in Deloitte consulting.
• Worked on multiple projects - Digital licensing and Confidential - for the Confidential government to setup BI reporting solutions.
• Worked as a data architect and ETL team lead.
• Using the latest technologies - Hive, Confidential, Informatica and Obiee - to provide solutions in data warehousing.
• Extensively worked on Oralce and SQL server databases.
• Aspiring to be a data scientist and one of the eminent data architect.
• Worked for biggest consulting firms like Deloitte and Capgemini. Have a very good consulting experience and worked in client locations.
• Won a gold for the outstanding demonstration of excellence.
• Proficiency in Creating Unix shell Scripts.
• Worked in SSIS and SSRS.
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of source system.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.

TECHNICAL SKILLS:

Software / Products: C, JCL, COBOL

Development Tools / Languages: Informatica 9i, Obiee 11g, Microsoft SSIS

Middleware / Databases: Oracle Database Project, Microsoft SQL Server Database

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Responsibilities:

• Worked as a technical lead.
• Did the data modelling for this project.
• Facilitated the Implementation process.
• Responsible for overall design of the solution including the data movement/Modelling and reporting from DAO.
• Reviewed and validated the technical documentation

Confidential

BI Architect

Responsibilities:

• Demonstrated the BI features to clients and participated in the requirement gathering and analysis.
• Created the data model for this BI solution.
• Planned and developed all the ETL routines by using Informatica and created reports and dashboards in OBIEE.
• Using Confidential loaded all the data into Hive tables.

Confidential

BI analyst/DBA

Responsibilities:

• Created the dashboard for the minister by using the tool DOMO.
• Designed and developed the database tasks for Trends feature in the app.
• Developed all the SQL procedures.
• Using Confidential loaded all the price historical changes into Hive tables for the future analytics.

Confidential

BI analyst/DBA

Responsibilities:

• In this role I have to give solutions in OBIEE/BI/DWH (end to end). Taking care of Informatica, DAC and OBIEE.
• As a DBA I have to maintain BI by resolving the BI issues, monitor the daily BI loads and implement the CR on Quarterly basis.
• Created ETL/BI Specifications and developed the ETL’s for CR raised by the users.
• Daily basis create and schedule the reports as per user request.
• Solve the issues on daily basis.

Confidential

Senior ETL Developer

Responsibilities:

• Working as a BI Specialist.
• Created a High level design and low level design in EA.
• Ported all the Oracle target code to SQL Server.
• Created ETL Specifications and developed the ETL’s to load data from Source to DM.
• Created cubes by using SSAS.

Confidential

Informatica Contractor

Responsibilities:

• Working as a BI Specialist.
• Creating the TDD and Build Document’s.
• Doing the Data Modeling and designing the DW.
• Did the development of Informatica Mappings and DAC Execution plans.
• Schedule the workflows by using DAC.
• Did the performance testing.

Confidential

ETL Lead

Responsibilities:

• Worked as an ETL module lead.
• Did the ETL Design for this project.
• Creating the TDD and Build Document’s.
• Did the development of Informatica Mappings and DAC Execution plans.
• Schedule the workflows by using DAC.
• Did the performance testing.

Confidential

Data Migration Lead

Responsibilities:

• Primary responsibility is to Load the data from legacy systems to Siebel Customer Service Application By using Informatica.
• Map the different legacy systems to Siebel Customer Service Application.
• Did the development of ORACLE Procedures, Informatica Mappings and Unix Shell Scripts.
• Schedule the workflows by using Redwood to perform an End to End Load for Batch runs.

Confidential

Data Migration Developer

Responsibilities:

• Taking care of one module (ERP-HR Systems) in this conversion.
• Map the two different systems (people soft, oracle apps).To do this Need to have an understanding of two different systems.
• Having calls with client to see the target requirements.
• Understanding source system and Creating a mapping specifications for development in Oracle and Informatica.
• Creating and reviewing Oracle Procedures and Informatica Mappings and checking unit testing documents.

Confidential

Developer

Responsibilities:

• Involved in the development, enhancements and implementation of the Enterprise Data Warehousing (EDW) process and Data Mart.
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Created Oracle Procedures or Informatica mappings to move from Various Systems to Transaction History database.
• Created, updated and maintained ETL technical documentation.
• Involved in UAT and resolved issues.
• Got a good knowledge in BO and created report specifications.

Confidential

Developer

Responsibilities:

• Used Oracle and Informatica PowerCenter 6.2 for migrating data from various OLTP servers/databases to the ODS.
• The data migration included identifying various databases where the information/data lay scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
• Translated the business processes into Oracle PLSQL Procedures or Informatica mappings for building the ODS.
• Created complex Oracle Procedures to load the data into ods and monitored them.
• Created Informatica mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.