SUMMARY:

• 10+ Years of experience in complete life cycle implementation (gathering Business Requirements, Analysis, Design, Data Modeling, Development, Implementations and Testing) of various functionalities of Business Intelligence, Data Warehouses/Data Marts and business applications using Ralph Kimball and Bill Inmon Methodology.
• Currently working an Informatica SME and Architect in Data Governance consulting project using Informatica archival, application retirement project which involves data masking, data sub setting, data profiling along with Informatica Power center.
• Worked closely with project directors to define strategy across application retirement.
• Extensive experience in creating the Workflows, Mappings, Mapplet, Reusable transformations and scheduling the Workflows and Sessions using  Informatica Power Center
• Worked as a consultant to help client to Install and configure all the components of application retirement project which includes Informatica ILM, test data management (Data Masking, Subset), DVO and ETL.
• Well versed in installing, configuring and admin activity of Informatica Power Center, Test Data management, Dynamic Data Masking and Data Archival which are all part of Informatica ILM product suite.
• Worked as in ILM architect to design and implement Informatica ILM products with proper strategy which includes Data Masking, Data Archival.
• Expertise in using Dimensional Data modeling, Star Schema, Snow flake schema, Fact and Dimension tables, Physical and logical data modeling.
• Experience in developing Slowly Changing Dimensions mapping (Type I, Type II& Type III).
• Worked as BI lead in internal project to develop OBIEE RPD and Dashboards including Answers.
• Have worked for Deloitte Consulting for 4+ years and have worked in the domain of Health Care, Insurance and Energy & Utilities and manufacturing.
• Experienced in Installation, Configuration, and Administration of OBIEE and Informatica Power Center/Power Mart on Client/Server environment.
• Has worked on an initiative work to extract data using Informatica and Kapow from social website (Facebook, Twitter) and perform the sentiment analysis.

TECHNICAL SKILLS:

Operating Systems: Windows, Unix

Languages: C, SQL, Pl/SQL, Windows Scripting

ETL Tools:  Informatica Power Center ETL & Admin, SAP BODS

Reporting: OBIEE, BO, Tableau, Qlikview, Kalido DIW

Data Governance: Informatica ILM(Information Lifecycle Management), Data Archival, Application Retirement, Data Masking, Data Subset, Test data generation, Data profiling, Test Data Management, Dynamic Data Masking, IBM Optim, Informatica DVO(Data Validation),Informatica Data Explorer)

RDBMS: Oracle, Sql Server, DB2

Directory Services: Active Directory, LDAP

Application Servers: Oracle Weblogic

Other Tools: KAPOW( Social Media Adapter), Concepts Data Warehousing, Business Intelligence

PROFESSIONAL EXPERIENCE:

Confidential 

Informatica ILM Architect and SME

• I am acting as an Informatica ILM architect or archival SME to implement and retire client’s applications. Working for client for their data governance using Informatica ILM tool set.
• I architected Infrastructure for data archival. Then strategy for data archival was done. I have also designed/architected an application archival which involves mainframe cobol files.
• I am also acting as a data custodian to be able to retrieve information for legal/compliance in case of any litigation or legal queries.

Environment: Informatica Power Center, ILM, Dynamic Data Masking, DVO, Sybase, Oracle, Sql Server, Unix

Confidential

BI & ILM, Masking Architect

• I was acting as a ILM Lead or archival SME to implement and retire client’s applications. Working for client for their data governance using Informatica ILM tool set.
• Data governance on how and where to use TDM for their application test data organization wide. Provide client options about Informatica data explorer. .Architect and build strategy in ILM products including TDM. Retire application based on multiple entities. Identify retention policy. Configure ILM and setup 2 environment for ILM. Perform Data Masking for Informatica Data Vault.
• LDAP Active directory configuration for the required users. Roles configuration in LDAP. Create data discovery entities for end user access with managing retention entities. Define relationship with in EDM. Perform DVO including table pair creation on archived application.
• ETL Administration, Power Center training to client for developing ETL mappings.

Environment: Informatica Power Center, ILM, Test Data Management(Subset and mask), Dynamic Data Masking, DVO, Business Objects, Oracle, Sql Server

Confidential, Trinamix, Colorado

ILM & Masking Architect

• I was acting as a consultant from Informatica (IPS) to help client configure and train client about data archival and strategy for ILM product suite.
• End to end archival and masking implementation.
• Apply masking rules for few of mock database for client training purpose. To work with client to make them hands on in above stated skills. Work on a pilot application to work on on - go strategy for data archival. Provide basic knowledge of TDM to client.

Environment: Informatica Power Center, ILM, Test Data Management(Subset and masking), Dynamic Data Masking, DVO, Business Objects, Oracle, Sql Server

Confidential

BI Manager

• Get high level of understanding of BI requirement and develop & design the ETL and dashboard accordingly. Overall, end to end implementation of ETL and OBIEE dashboards.
• Create database objects as per requirement. ETL Design plus Source to target mapping sheet. Develop, test the ETL mapping. Validate the data in staging, and DH. Informatica Administration.
• Develop OBIEE rpd after understanding the need. Create dashboard in OBIEE with drill down reports. Modify RPD and dashboard as per product development requirement. Integrate and merge the PDQ rpd with other rpd and migrate the code to customer’s environment.

Environment: Informatica Power Center, Oracle, OBIEE, Data Modelling

Confidential

BI Solution Architect

• Primary role was to architect the BI solution for the client and provide Road map for the BI tools going forward. Get high level of understanding of BI requirement and meet different BI vendors to perform a demo and small POC. Evaluate different BI tools in market.
• Understand the AS-IS state and TO-BE architecture. BI Tools and high level architecture recommendation. Help my client with BI and other BI roadmap landscape.

Environment: Informatica Power Center, Oracle BI, Tableau, Qlikview, Sql Server

Confidential

Architect

• Understanding the business process flow and work with business user after which, I am supposed to coordinate and understand the requirement and business analysis.
• Have to work towards building a robust model or design considering the present data ware house. My role includes from business analysis till testing. Understanding the business flow and coordinating with business users to get answers required for design.
• Work on requirement gathering document along with ETL mapping sheet. Building reports to meet business requirements.
• Development of ETL’s which includes file inbound process, CDC, error handling. SCD2 development. Database objects creation and data mart population. Data analysis for the existing ware house. Data validation for the mart.

Environment: SAP BODS, OBIEE, Sql Server 2008

Confidential

Deloitte, Pennsylvania

Tech Lead

• Understanding the business process flow and work with business user of each application to be decommission for business requirement gathering. After which, I am supposed to coordinate archiving and validation of the retired application.
• Have to work with business and technical users on deciding the technical complexities for each application like retrieval requirement after the application is decommissioned etc.
• Leading effort for new product installation on our production and test server across different regions. Gathering and placing request for space available and required in server.
• Creation of Informatica mappings for verification where Informatica DVO doesn’t fit. Schedule meeting with business and technical owner of applications.
• Coordinating with different vendors involved for archiving. Understanding the business requirement for archival and coordinating retrieval queries for an application.
• Taking archival end to end and this also includes retrieval query execution. Creation of Informatica-DVO scripts for JDE markets. Contributing for process improvements.
• POC on performance/Live archiving. Performed a POC and then implementation of data subset in client’s warehouse.
• Performed a data archiving and masking POC for client using IBM Optim.
• Lead ETL Development where the code page was an issue. Informatica Administration.

Environment: Informatica Power Center, Informatica ILM, Informatica DVO, Data Archival and Application Retirement, Data Subset, Oracle, DB2, Sql Server, JDE

Confidential

Deloitte, California

Tech Lead

• Understanding the business requirement from the technical and business standpoint. Create source to target mapping for all ETL’s. Lead 2 modules from ETL standpoint.
• Assign tasks to peers to meet the stringent deadlines. Development of some of the ETL’s in coordination with peers. Coordinate between offshore and onshore to understand the design.
• Test and lead the testing activity for all the assigned modules.

Environment: Informatica Power Center, Sql Server, Unix

Confidential

Senior Consultant

• Analyzing the business requirement. Developing different kind of mapping referring to the business requirement document. Making suitability adjustments in the functional flow. Understanding the complex calculations involved as per the requirement and hence proposing the corresponding logic for it.
• Making technical specs and unit test cases while adhering to the quality. Moving the codes between different environments after testing is completed. Coordinating between Client, onsite and offshore team (Mumbai).

Environment: Informatica Power Center, Sql Server, Unix

Confidential

Business Analyst

• In this project Informatica 8.6 is deployed along with Oracle 10G as their database. It provides business intelligence to them and the analysis by which they can enhance their insurance business and hence get best out of minimum effort.
• Analyzing the business requirement as there was two fixed reports to be produced instead of usual ad-hoc reporting. Defining the Logical primary keys. Defining the table to be deployed along with their data types.
• Developing different kind of mapping referring to the business requirement document. Performance tuning. Understanding the complex calculations involved as per the requirement and hence proposing the corresponding logic for it.
• Making technical specs and unit test cases while adhering to the quality. Accepting new changes and making design documents. Reviewing the code.

Environment: Informatica, Oracle, Unix