SUMMARY

• Sr Data Integration Consultant Architect Over 17 plus years of IT experience with over 12 years of experience in Data Integration, ETL Architecture Design, Business Intelligence, Data warehousing, Data Mining, and Data Modeling, Salesforce/Cloud Data Integration
• Over 9 years of experience in (ETL) INFORMATICA (Power Center, Power Exchange 10.x/9.x/8.x).
• Specialization in Development of Databases, Data Warehousing & BI Systems.
• Extensive experience in Application Integration and Cloud Integration with CRM to ERP.
• Extensive experience in architecture, design, and development of Business Analytics applications
• Extensive experience in Data Analysis, Data mapping, Data Conversion, and Data Cleansing,
• Extensive 9 plus years of hands on experience in Data Migration and Integrations using Informatica with SFDC and Oracle ERP technologies.
• Certified Salesforce.com Administrator
• Extensively worked on SFDC Data Model, Saleforce Data management and Integrations
• Well versed with SOQL
• Conceptualize, analyze, Design, develop, and deploy strategiesfor data acquisition, transformation, and loading on an enterpriselevel.
• Extensive experience with Informatica Cloud with handling Data Replication/Data Synchronization tasks.
• Extensive experience in Informatica Cloud Integration with Application Integrational.
• Extensive work experience on Data Integrations of SFDC Cloud to On - premise Oracle ERP.
• Experience of designing strategies for ETL audit, load balance, exception handling and high data volumes.
• Hands on Knowledge on building SFDC Data Integration architecture and defining SFDC Data Model.
• Good Knowledge of Big Data and Hadoop related technologies.
• Extensive database experience on SQL Server, Oracle 12c/11g with Proficiency in writing T-SQL, SQL.
• Experienced in designing CRM databases and designing SFDC data models and configurations.
• Experienced in writing SOQL queries and SFDC configurations.
• Well versed with the Integrations of Tibco, SOA, Web Service, Rest API, Informatica Cloud
• Expertise in Designing Dashboards and Scorecards.
• Experience in OLAP migrations from technologies like Oracle Express (ROLAP), Seibel Analytics to SSAS (MOLAP).
• Good Knowledge On demand integrating data quality (IDQ), IDE in to ETL.
• Good Knowledge aboutDefining technical data quality rules, monitor data quality results and coordinate and perform data remediation across
• Good Knowledge on Master data Management (MDM ) specific activities such as define the Cleanse rules, Match Rules, etc.,
• Expertise on Dimensional Modeling, Star Schema, Snowflake Schema and 3NF.
• Develop and maintain Conceptual, logical & Physical data models using Erwin and MS Visio, and designing ETL Systems with SSIS and Informatica.
• Developed SQL Server Integration Services (SSIS) packages to transform data from various data sources to MS SQL 2005
• Experienced in managing offshore teams like leading, coordinating, prioritization and allocation of tasks
• Driven quality improvement initiatives like designing organization standards for Business Intelligence development.
• Have been exposed to full SDLC process - Ability to design, organize, and implement module, perform system testing.
• Ability to research and trouble-shoot application related problems.
• Experienced in meeting regularly with key business personnel to determine business needs and document requirements.
• Extensively Worked with technical team to develop solutions(Proof of Concepts) and then present to the business to obtain agreement and consensus.
• Experienced in Documenting detailed functional and technical specifications based on agreed solutions.
• Estimation for ongoing/upcoming enhancements/projects
• Co-ordinate and work with CoE’s as required for estimation and POC and research.
• Experienced in interacting with Account management, project management, and clients locally and globally.
• Excellent analytical, written and verbal communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center, Informatica Cloud

OLAP & BI Reporting: SSAS ProClarity, Business Objects (Infoview, Webi), Oracle Express, OBIEE

Scorecards & Dashboards: Performance Point, BSM 2005

Ad Hoc Data Reporting: SSRS, Crystal Reports

RDBMS: SQL Server, Oracle, MS Access, Teradata (Teradata SQL Assistant)

Data Modeling: Dimensional modeling, Star Schema, Erwin, Visio.

Big Data: Training knowledge on Big Data technologies (Hadoop, Hive, Pig, Spark)

PROFESSIONAL EXPERIENCE

Confidential

Data Integration Consultant Architect

Environment: (Informatica Power Exchange, Oracle 12c, Informatica Cloud, SFDC )

Responsibilities:

• Interacting with Business Analysists and Business owners for gathering CRM Integration requirements and solutioning.
• Assessments, POCs and estimation of ETL Integration Development.
• Model and Design of Data Integration Architecture.
• Design, create and optimize key data pipelines.
• Preparation of Functional Design and Technical design documents including Data mapping documents.
• Reviewing the Technical designs and working with other stake holders for approval.
• Developing the Integration Interfaces to connect between CRM systems and various other systems using the technologies like Informatica On-premise/Informatica Cloud/Oracle/SFDC.
• Leading/Guiding the Offshore team on Integration development.
• Building the Testing strategy for Informatica/Oracle Product upgradations and leading the testing process with offshore testers.
• Code review, Testing and deployment support from onsite.
• Production Support and handling business owner’s queries and tickets.
• Onsite coordination and leading the offshore team on CRM Application support.
• Providing the root cause analysis to production support tickets and suggesting alternate efficient solutions on CRM integrations.
• Ensuring the Team Adherence to the development methodologies like Agile, Waterfall and Quality standards.
• Keep tracking of Project progress and timely reporting the status to project management and higher management.

Confidential, Atlanta,GA

BI & DW Consultant

Environment: ( Confidential Sql Server, SSAS, SSRS, SSIS,BO Voyager)

Responsibilities:

• Gathering Requirements, Developing the Conceptual and logical Data Models.
• Developing the BI Migration strategy.
• Reverse engineering the existing Oracle Express BI Systems.
• Designing the new BI system on Confidential BI Platform.
• Communicating with business users and other stake holders and creating the documents.
• Onsite coordination and leading the offshore team.
• Performance Tuning: Tuning SQL queries and SSAS Cubes, Authoring the standards and Best Practices for SSAS cube development and MDX.
• Worked with third-party vendors on data acquisitionWorked with outside consultants and experts to accomplish multiple project related tasks.
• Supporting on UAT testing cycles.
• Participated in Code Reviews and Code Turnovers as an author.
• Worked on Migration of ETL and SQL programs by preparing appropriate docs for code movement to QA, UAT and production.
• Co-ordinated with support groups (Development, Environment, DBA’s) in minimizing outage due to execution failures.

Confidential, Denver, CO

DW & BI Consultant

Responsibilities:

• Implementing Data Modeling techniques, Reviewing ETL architecture Dimensional Modeling, Designing and implementing Conformed dimensions, Designing of ETL Mappings..Reengineered and created models from Legacy data Sources,, Loading data from various sources like, flat files, to SQL Server database Using SSIS Package .
• Designed and created Partition strategies for Performance.
• Participated in requirement gathering meetings. Involved in making mappings and transformations using Data Flow Task and Execute SQL Task.
• Leading the ETL team and Coordinating with project manager and Business owners.
• Designing Multi dimensional Objects (Cubes, Dimensions) using MS Analysis.
• BI Implementation with MS SQL Server Reporting Services and ProClarity.
• Designing BI dashboard and ScorecardLeading the team and ensuring development adherence to Quality Standards .

Confidential

Project Lead

Responsibilities:

• Implementation of Dimensional Modeling and Designing ETL Mappings.
• Developed Multi dimensional Objects (Cubes,Dimensions) using MS Analysis
• Loading data from various sources like, flat files, MS Access, Sql Server to SQL Server database Using SSIS Package .
• Involved in making mappings and transformations using Data Flow Task, Execute SQL Task .
• Leading the ETL team and Coordinating with project manager and others.
• Data preparation for Data Mining, Development of Reports and charts using MS Sql Server Data Mining Tool.
• Developed reports and Score cards using MS SQL Server Reporting Services and BSM.
• Leading team, code reviewing, Testing and checking on adherence to Quality Standards

Confidential

Data Warehouse Developer

Responsibilities:

• Requirement gathering and preparation of logical design and functional Documents
• Model and Design of Relational Database .Development and review of TSQL procedures and other database Objects. Design and Development of Reports
• Code reviewing, Testing and checking for adherence to Quality Standards.