Sanat Pandey

INFORMATICA, DENODO - CONSULTANT

adoz3o@r.postjobfree.com

602-***-****

Experience Summary

15+ years of IT experiences with expertise in Data Warehousing & Business Intelligence practice and various Databases using Informatica and Denodo

10+ years of Informatica Development and Design experience Implementation of Data Warehouse & Data Marts using ETL Tools Informatica PowerCenter 10.1/9.x/8.x/7.x for Utility, Oil & Gas, Banking, Insurance, Pharmaceuticals, Aviation industries

Experienced in Informatica Administration for installation, and configuring the Application services Repository, Web Hub, SAP BW etc. of Domain /Gateway services (Authentication, Configuration, Service Management, Log Services etc.)

8+ Years of experience as Team Lead, Module Lead, onshore coordinator, application SME, Informatica Center-of-Excellence and worked with other teams of various domains, platforms, and technologies

4+ years of experience as Denodo Developer and Administrator

Working with SBM Group INC. Edison, NJ – 08837 since March 2014

Excellent written and verbal communication, interpersonal and client facing skills

Worked with Tata Consultancy Services (TCS) from June 2007 to Feb 2014

Well versed in working with end-users, trained on, and practiced using SEI CMM Level 5 development processes

Education

Bachelor of Engineering-Computer Science and Engineering, 2000-2004, RGPV Bhopal, India

DOMAIN EXPERIENCE:

•Health Insurance (Blue Shield of California)

•Investment management (INVESCO)

•Insurance (USAA)

•Utility: Energy-Electricity (APS-Arizona Public Service, ComEd, GE Nuclear Energy)

•Pharmaceutical (Johnson & Johnson)

•Oil & Gas (British Petroleum)

•Banking (GE Money)

•Aviation (GE Aviation)

Technology:

Technologies

Tools

Data warehousing/ETL

Informatica Power Center 10.4.1/9.x/8.x/7.x, IDQ, MDM, Sagent Data Flow Solution 6.4/6.5

Data Virtualization

Denodo Platform 7.0, 6.0

Cloud Computing

Informatica Cloud (IICS), AWS, Snowflake, Redshift

Data Modelling

Star Schema, Snowflake

ERWIN 8.2/7.2, Visio, OLAP, OLTP

Programming

Unix Shell Scripting, PL/SQL, C, C++, ASP, VBScript, JavaScript

Databases

Oracle 12C/11g/10g/9i/8i, IBM Netezza 7.2.x, Teradata 14.0, IBM DB2 8.0/7.0, MongoDB 5.0, MS SQL Server 2005/2000, MS ACCESS

Environment

Red Hat LINUX 5.6/5.4/4.8/4.6, UNIX (Sun Solaris 2.7/2.6, HP-UX 10.20/9.0, IBM AIX 4.3/4.2)

Schedulers

Control-M, JSS, Tidle, Informatica Schedulers

Professional Experience:

Blue Shield of California - Oakland, California July 2020 – till date

Implementation Partner- Atos Syntel

Informatica & Denodo Consultant

Blue Shield of California is a non-profit mutual benefit corporation and health plan company based in Oakland, California, and serves 4.5 million health plan members and more than 65,000 physicians across the state

Responsibilities:

•Work with a team of Six offshore developer

•Review, design, build and test ETL Load processes using Informatica PowerCenter

•Load Data warehouse from Relational Sources DB2, Oracle, SQL Server, flat files, xml, CSV

•Data Validations scripts in Unix

•Denodo Development related activities and Access Control

•Production support for number of DataMart

Data Virtualization - Denodo Platform 6.0 and 7.0

Installation of Denodo Server and Clients, connectivity with other applications like Oracle, SQL, UNICA, STI Server etc. Roles and User management

Developer and Administrator for Denodo platform

Create objects like Virtual Data base, Source, Base, Derived Views, selection, all type of joins

Environments: -

•Informatica Power Center 10.4.1, Denodo Platform 7.0, Oracle 12C, IBM Netezza 7.2.x, MongoDB 5.0 UNIX shell scripting, Control-M, Agile methodology, Jira management tool

Invesco - Denver Feb 2020 – June 2020

Implementation Partner- Cognizant

Informatica and Denodo Consultant

Invesco is an American independent investment management company.

Responsibilities:

•Informatica and Denodo Developer

•Informatica and Denodo Admin related activities such as environment setup for new projects

Code Migration, connection creation

•Production support for number of DataMart

Environments: -

•Informatica Power Center 10.2, Denodo Platform 7.0, UNIX, Control-M, Agile methodology, Jira management tool

USAA (United Services Automobile Association) - Phoenix, AZ Aug 2019 – Jan 2020

ETL Consultant

USAA offers a range of personal property and casualty (P&C) insurance, including automobile, homeowner, renters, and umbrella insurance to past and present members of the Armed Forces, officers, and their families

Project- P&C CWH

The consumable warehouse (CWH) is intended to be a multipurpose data environment that is intuitive, easy to learn, easy to develop and easy to use.

Responsibilities:

•Data virtualization design

•Setup CDQLOAD process, Data Validations scripts in Unix

•Production support for number of DataMart

•Data Mapping, XML/JSON, and web service in Denodo 7.0

Environments: -

•Informatica Power Center 10.2, Denodo 7.0, Snowflake, Netezza, UNIX, Control-M, Denodo Platform 7.0, Agile methodology, Jira management tool

Arizona Public Service (APS) - Phoenix, AZ Feb 2015 – July 2019

IT Sys Analyst/Integrator Sr (Informatica and Denodo Consultant)

Arizona Public Service (APS) is a grand provider of energy in the Grand Canyon state. APS, a subsidiary of Pinnacle West Capital, distributes power to about 1.2 million customers in 11 of 15 Arizona counties, making it the largest electric utility in the state.

Responsibilities:

•Design, build and test of ETL Load processes using Informatica PowerCenter

•Setup real time webservices to get temperature based on latitude and longitude.

•Load Data warehouse from Relational Sources DB2, Oracle, SQL Server, flat files, XM, CSV

•Provide enhancement and support to existing .asp pages.

•Informatica admin activities such as upgrade, setup user privileges, Connection object setup.

Environments: -

•Informatica Power Center 10.1.1/9.6.1/9.1, IDQ, Denodo Platform 6.0/7.0, Informatica Cloud (IICS), Oracle 11g/10g, DB2, MS-SQL Server 2000, PL/SQL, Toad 9.5, Control-M

ComEd (An Exelon Company) - Oakbrook Terrace, IL Sep 2014 – Feb 2015

Implementation Partner- Accenture

Data Warehouse Analyst/Informatica Developer

ComEd is an energy delivery subsidiary of Exelon Corporation and one of the largest utilities in the United States, Headquartered in Chicago.

Responsibilities:

•Informatica Developer and Admin

•Design, build and test ETL components for key reports and dashboards using PowerCenter and IICS

•Code reviews and Document reviews

Environments: -

Informatica Power Center 9.5, Informatica Cloud (IICS), Oracle 11g, UNIX, JSS, TFS, ALM

Johnson & Johnson - Raritan, NJ April 2014 – Sept 2014

Implementation Partner- TCS

Data Warehouse Analyst/Informatica Developer

Johnson & Johnson is an American multinational medical device, pharmaceutical and consumer packaged goods manufacturer

Responsibilities:

•Informatica tech lead, Informatica Admin

•BI Solution Architect for optimal access to enterprise data warehouse

•Implement slowly changing dimension Type 2, Type 3 and Type 6 for change data capture

•Implementation of Push Down Optimization on Teradata

•Client interaction and Onsite-Offshore co-ordination

Environments: -

Informatica Power Center 9.5, Teradata 14.0, Teradata SQL Assistant, SAP R3, UNIX, Tidle

Arizona Public Service (APS) - Phoenix, AZ March 2011 – Nov 2013

Data Warehouse Developer/Integrator II -TCS Onsite

Project: Migration of ETL applications MTDW, PTDW, SCDW, EDW from Sagent to Informatica

Responsibilities:

•Analysis of existing Sagent system and business rules

•Develop Informatica objects to migrate ETL applications from Sagent to

•Review mappings, workflows, sessions, tasks developed by peer team members

Environments: -

Informatica Power Center 9.1/8.6.1, Oracle 11g/10g, JAVA/JEE, DB2, Control–M

BP (British Petroleum) - Naperville, IL Sept 2010 – Feb 2011

Data warehouse Developer / Analyst - TCS Onsite

BP is one of the world's leading international oil and gas companies. It operates over 80 countries

Responsibilities:

•Informatica Developer and supportive administrator

• Develop various reports using the Cognos 7.0, write Procedures, Functions, Triggers etc.

Environments: -

Informatica Power Center 8.6.1/8.1.1, Oracle 10g, JAVA/JEE, MS-SQL Server 2000, PL/SQL, UNIX, Cognos 7.0, Informatica DQ, UNIX, Shell Programming

Tata Consultancy Services (TCS) Mumbai, India Jun 2007 - Aug 2010

IT Analyst- Data warehouse Developer (Informatica Developer- TCS Offshore)

GE Money, GE Nuclear Energy, GE Aviation

Responsibilities:

•Requirement Gathering, Analysis, Development, Design & Testing

•Informatica administrator, Performance Tuning

Environment: Informatica PowerCenter 8.5.1, Oracle 10g/9i, JAVA/JEE, UNIX Shell Scripting

D2k Technologies India Pvt. Ltd. -Mumbai Jan 2005 – May 2007

Client: RELIANCE LIFE INSURANCE COMPANY LIMITED

ASP, PL SQL Developer

Responsibilities:

•Development of database tables, views, procedures, triggers, functions

•Design and develop web applications using ASP, VB Script, Java Script, Java /JEE

Contact this candidate