SUMMARY:

• I am an accomplished and versatile Business Intelligence & Analytics professional with considerable experience in information architecture, software architecture and enterprise data management.
• I have more than 9 years of delivering extremely robust and efficient Information Management Solutions, on - time and on-budget. I have a proven ability to deliver highly comprehensive Data warehouse Management designs to consolidate data across a wide range of business entities.
• I have a long-running record of providing exponential increases in throughput, accuracy and profitability.
• I have been an Inspiring leader with an innate understanding of team dynamics and intrapersonal relationships, I build winning teams and take pride in their accomplishments.
• I have an outstanding ability to define business functions as generalized metadata, enabling systems to provide long-term stability and reliability. I have a vast capacity for absorbing and synthesizing a wealth of detail into a unified, coherent vision and communicating that vision to a diverse audience. 

TECHNICAL SKILLS:

• Informatica PowerCenter Tool
• Teradata Tool
• Informatica Data Quality Tool
• Informatica Master Data Management
• Teradata Database
• Oracle database
• Microsoft SQL server Database
• ER-Studio Modeling Tool
• Microsoft Visio
• Erwin Modeling Tool
• SAP Business Objects Reporting Tool
• Base SAS Programmimg
• Windows Server OS
• Unix/Linux
• Structured Query Language
• Unix Shell Scripting
• Microsoft Office Suite Advanced Level

WORK EXPERIENCE:

Information Integration Architect 

Confidential

Responsibilities:

• Working as an Integration Architect in Retail domain in the field of Development & Implementation of New product hierarchy for Oracle Retail Integration.
• Managing the conversion team of ETL developers, database developers by providing architectural solutions for databases, canonical models and orchestration objects for Interfaces on the presentation layer for data conversion efforts.
• Architected and maintained Erwin logical and physical data models of the new product hierarchy.
• Architected Conversion framework and strategy for new product hierarchy from legacy system.
• Designed the Score card, reconciled Reporting solutions for the client and communicated the data conversion scope, integrated with other applications and designed strategy for successfully converting the legacy data to the new product hierarchy for Oracle Retail.
• Initiated Design of ETL architecture solution from functional requirements which is required to be analyzed as a part of the quality assessment process.
• Providing the technical designs for conversion of legacy data to Oracle Retail system.
• Analyzing the source data to determine accuracy and completeness of the source data which would clarify the structure, relationship, content and derivation rules of data.
• Identifying the data patterns and designing the unstructured data into required structured data for Oracle Retail system using Informatica data quality tool.
• Helping the client to identify the ETL infrastructure and its limitations.
• Working as an ETL Informatica and Data Quality SME for the conversion program to implement Oracle Retail system.
• Providing the best practices of Informatica for implementing the data conversion.
• Responsible for development and implementation of ETL Informatica interface.
• Providing architectural and design leadership across several cross-functional development teams, as well as working closely with other architects and project management team.

Data Warehouse Integration Architect 

Confidential

Responsibilities

• Worked as an Information Integration Architect and consultant in Life Science Sales and Marketing domain in the field of Development & implementation of Business Intelligence and Data Warehouse to stabilize the Commercial Data Warehouse.
• Architected dimensionally secured SSAS cubes to house CAST data along targets, Professionals, Specialties, Jobs and Calendar for all call, target, and Trx and NRx metrics from IMS data. Provided Drill through functionality, to accommodate “what if” scenarios.
• Offered strong combination of business and technical expertise, ensuring steadfast project management from development of initial concept through design and implementation of ETL solutions.
• Provided architectural and design leadership across several cross-functional development teams, as well as work closely with other architects and project management.
• Responsible for all phases of Project Management for accomplishing multiple deliveries.
• Provided rationalization of CDW environment through business and technical analysis to efficiently organize, optimize, cleanse and structure data to meet internal and external business needs.
• Worked on requirement gathering/analysis with the client to bring the different Sales strategic business information of different geographical regions under the single point of Data warehouse.
• Worked with multiple teams to integrate data from multiple source systems like SAP, Siebel, DCH, MARS etc. and third party vendors like IMS into a Single Data Warehouse system.
• Designed the Architecture of Financial Reporting for the client and provided SAS datasets to the third party vendor for budget analysis.
• Analyzed the source data to determine accuracy and completeness of the source data which clarified the structure, relationship, content and derivation rules of data.
• Proposed New Customer Account Master Universe of Business Accounts using MDM solution.
• Responsible for Project Planning and coordinating the Oracle Exadata Migration activity.
• Acting as a single of point of contact for any Informatica, Oracle and ETL related issues for multiple teams.
• Implemented multiple Performance Tuning activities, which improved the ETL performance significantly.
• Implemented logical and physical data models of ETL Design solutions using ER/ Studio Tool.
• Completed several technical assessments as per the change requirements of Business.
• Creating, reviewing and providing recommendations on technical procedures, architecture documentation, and engineering decisions.
• Cross-trained other BI team members and groom them with projects and mentoring to build depth and expertise of the team.

Data Warehouse Integration Architect 

Confidential

Responsibilities:

• Designed the integration of business entity data to implement MDM hub architecture for HCM Data warehouse.
• Evaluated current data warehouse/ETL environment for implementation of Customer Master (MDM) capability and provided gap assessment.
• Worked with Enterprise Architecture Team to find the gaps and challenges in the evolving commercial model (Symphony) that met the overall enterprise architecture requirements.
• Initiated Design of ETL architecture solution from already existing ETL processes which were required to be analyzed as a part of the quality assessments.
• Responsible for Leading the ETL, Data Quality solutions.
• Implemented ETL solution for 34 different source systems which provided the feeds to a Next Generation HCM model to create effective Customer Master Information.
• Worked as the single of point of contact of client engagement in the domain of Informatica, Oracle and ETL issues for the team.
• Worked as an Expert Designer and developer in Informatica Power Center ETL, IDQ Data Quality Tool and mentored the Team with the development modules.
• Overseen activities for all tasks in Project from planning to delivery and sustaining support to ensure that projects meet established business objectives, time and budget constraints.
• Worked as a Designer/Developer/SME for ETL Implementation for Master Customer data Management.
• Reverse Engineered ETL Database into Physical Data Models using ER/ Studio Tool.
• Assessed the Source to Target Mappings for reviewing the existing code and data analysis.
• Created Data Flow Diagrams for ETL processes scheduled to run on a daily basis.
• Performed Data Quality assessment to know the hard coded values and records rejected and reference data.
• Developed Data Lineage Reports in Metadata Manager along with performing the metadata profiling on HCM data.
• Delivered multiple modules on time with high precision and received accolades and awards from the client management team.
• Worked on Performance tuning complex queries, optimizing Informatica workflows.
• Responsible for working with developers to assure design and implementation conforms to internal standards, makes use of best practices and performs well.

Lead ETL Designer 

Confidential

Responsibilities:

• Worked as an ETL Designer, ETL Developer/SME for Activity Reporting Area. Worked as the First Onsite Coordinator from Accenture who was responsible to setup the entire Production Support team for Confidential .
• Coordinated with the Client to accomplish multiple deliveries.
• Responsible for new requirement analysis and changes of Activity reporting solutions and Dashboard.
• Completed several Technical Assessments for any kind of changes required by Business.
• Worked as Team Lead for Activity Dashboard and Market Share dashboard. Apart from that, designed the ETL and data mart. Successfully delivered the modules on time with multiple iterative changes requested by the Business.
• Expert in Informatica Data Quality Tool. Used it extensively to profile the heterogeneous sources for data quality trend analysis and apply the Rules to standardize the source data for processing the Master Data.
• Worked as a Data Modeler and Designer for Coaching Reporting Area.
• Was the single of point of contact for any Informatica, Teradata and ETL related issues and queries for the team.
• Implemented multiple Performance Tuning activities, which improved the ETL performance significantly.
• Implemented multiple Deployments on Production on time.
• Worked as the Production Support Lead and was responsible for planning the work distribution among team members.
• Understood the Accenture- Confidential production support agreement.
• Structured the daily and weekly Status Report which was approved by business. Production support team sends them till date.
• Successfully rolled out Activity and Sales solution on production and business started using new BI application.
• Mentored the offshore team regarding the Confidential change control application and ISM application.
• Responsible for Siperian MDM Hub solution and its jobs.

Senior ETL Designer 

Confidential

Responsibilities:

• Worked on multiple modules like Essbase Cube, Post Audit Release, and Tax Data Retention & Reporting for the client.
• Worked with the Finance team and analyzed data through multiple data dimensions to compare both budget and actual information with data in Matrix reporting using Essbase cube.
• Provided phased releases of enhancements that enabled Post Audit to save time, save resources, and improve quality.
• Responsible for tuning complex queries and redirecting data access to data available in Teradata databases.
• Worked with multiple teams to reduce the current and future tax payments by increasing availability and accuracy of information and data to support Sales & Use Tax audits and compliance support.
• Worked on Informatica solutions which electronically retains Sales data & uses Tax sensitive data in the Enterprise Data Warehouse/Tax Data Universe for the required length of time (7 years) and provides the necessary reporting capabilities to support audit defense.
• Built a reusable component using BTEQ and ksh script, which checks the status of the particular Table Update Status and based on that, it creates .ok file to kick start the other dependent jobs in Maestro.
• Worked in this project as a Teradata Developer to build TPT scripts to extract the data and ksh Scripts to automate the process.
• Used Informatica solutions to automate the whole process.
• Built sftpksh scripts, different ksh scripts which automated the module.
• Worked as an Informatica Developer as well as a Teradata Developer to build BTEQ scripts and FLOAD Scripts.
• Implemented different data quality checks using Informatica.
• Proposed new design of the process flow to automate the whole process.
• Reduced the total time of data extraction from the oracle source table with performance tuning.
• Implemented scripts for capturing delta records from the source table using Informatica mapping successfully.
• Exposure to the business concepts and modules of Confidential during implementation of the project.

ETL Developer

Confidential

Responsibilities:

• Worked as an ETL Developer and helped to design the Warehouse using snowflake schema.
• Designed and configured Informatica 7.1.
• Worked on the network configuration for MS-SQL 2005, Informatica and Business Objects to work as a centralized system.
• Worked on the complete solution which consisted of 3 different Stages like designing or building Warehouse, ETL process to load the data into warehouse and Building Universe in BO to generate the report for Analysis.
• Understood and implemented the asset building capability on Retail Domain.