Page * of *

Jayan Bhargavan Phone: 203-***-**** (M), 203-***-**** (H)

Fairfield, CT 06825 E-mail: acsrbc@r.postjobfree.com Professional Summary

Over 18 years of experience in IT industry with over 13 years in ETL design and development.

Extensive experience in all the stages of an ETL program in both Data warehouse and ODS/OLTP environments.

Excellent analytical and conceptual skills in database design and development.

Meet with users and subject matter experts to analyze business processes and systems.

Define and communicate specifications to technical staff.

Excellent data modeling skills. Created various logical and physical data models using Erwin.

Expertise in ETL process with Informatica PowerCenter.

Have performed Informatica administration tasks such as re-starting server, upgrade software, apply patches, user control maintenance.

In depth knowledge in RDBMS Concepts. Extensive experience in database programming.

Experience in coordinating with offshore teams.

Excellent programming knowledge. Expertise in SQL and PL/SQL. Have knowledge in Java Script, Java, VB Script and Visual Basic programming from work done in the earlier years.

Worked with Informatica Data Quality (IDQ) toolkit.

Basic knowledge on Big Data, NoSQL DBs such as Cassandra, data analytics language such as R.

Skilled at SQL tuning and ETL performance tuning.

Have used techniques such as partitioning and push down optimization for ETL performance tuning.

Skilled at capturing user needs and translating them into functional and technical requirements documentation.

Knowledge on Six sigma methodologies.

Worked in cross-functional areas. Worked extensively in Travel industry, Insurance, Telecom and Retail.

Fluent and Effective communicator, in both spoken and written forms.

Worked with large organizations at diversified locations - Priceline.com, Swiss Re (Kansas), GE (Kansas), Philip Morris (Tokyo, Japan), Qatar Telecommunications (Doha, Qatar), Schneider Logistics Inc. (India), Trane (India). Technical Skills

Database: Netezza 7.2, Oracle 7.x/8.x/9i/10g/11g, Sybase, SQL Server 2000 Data Modeling: Erwin 7.3

ETL: Informatica PowerCenter 5.x/6.x/7.x/8.x/9.x

Methodologies: Star Schema, Snowflake Schema

Programming Languages: SQL, PL/SQL, Java Script, VB Script, VB 5.0, HTML, Java ERP: Oracle Financials

Scheduling Tools: Cron, Autosys, Tidal

Other Tools: Aginity, TOAD, SQL Navigator, VSS, PVCS, Visual Interdev, Forms 4.5, Visio Education

Post Graduate Diploma in Computer Application (PGDCA) - 1996 Gemini Electronics and Computer Technologies – Andhra Pradesh, India Bachelors in Computer Science (BSc) - 1995

Osmania University – Andhra Pradesh, India

Page 2 of 3

Work Experience

ETL Consultant, Coach Inc., New York, NY, Jun 2015 – Present Tech stack used: Informatica, Netezza, Aginity, Linux, Tidal, Jira Projects:

DM conversion: DM is a data migration process written in Visual Basic to extract data from files sourced from SAP to the EDW (Enterprise data warehouse) in Netezza. This project is to convert the ELT process developed in Visual Basic to an ETL process in Informatica. Goal was to identify and reduce / eliminate redundant and inefficient extract and load process and to achieve the load time thresholds. Other than lack of in-house ex- pertise with Visual Basic, the process was hard to track back on any data issues identified. Push down optimi- zation was utilized as much as possible to enhance the load performance. Principal Engineer, Priceline.com Norwalk, CT, Nov 2006 – May 2015 Tech stack used for the below projects: Informatica, Oracle DB, Erwin, Oracle Financials, PL/SQL, OBIEE, Visio, Toad, Linux Projects:

AP (Accounts Payable) Data mart: This data mart was primarily built to identify and resolve incorrect hotel charges. Millions of dollars were being lost to over charges from hotels. Data mart provided ease of reporting and identifying areas to focus on. Segregation of types of overcharges helped targeting / follow up with hotels and get money back. The datamart also helped identifying issues with the front end (website selling reserva- tions) such as incorrect room rate being used, or a missing fee, etc. Processes such as discrepancy faxes, chargeback process were built around the data mart helping recover money from the vendors.

OIC (Oracle Incentive Compensation): OIC is a cloud based product used for paying commissions to Priceline’s affiliates for bringing traffic to the website. Informatica was used to extract data from the transactional sys- tems, transform and load them in OIC. This included migration / conversion of data from the old affiliate pay- ment system. IDQ was utilized to identify and eliminate duplicates.

Commission Data Store / Data Mart (CDS): CDS was built to be able to report on revenues made from agency transactions (commission transactions). This was also used to create receivables once the payment file is re- ceived from vendors. OBIEE reports were developed from this datamart. This project not only helped with ease of reporting but also helped identify pain areas and improve on revenue generation. This also became a major data source for the OIC project.

Data warehouse ETL Tuning: Identified bottle necks with ETL loads in the existing data warehouse. Re-wrote certain mappings and tuned existing mappings to improve performance. Identified need to drop constraints, create indexes, create partitions at the DB level to enhance performance. Load times were reduced by more than 50%.

Lawsuit data automation: This project was to build a system so that data can be readily available for any law- suit requests. PL/SQL package was created to extract the data from various sources and load into Oracle ta- bles. An interface was provided to the legal team to call the Oracle package with the required inputs. This also eliminated any possibility of a manual error in retrieving the data which could cause loss of effort and dollars.

ERP migration: Migrated / converted from old ERP system (GEAC) to Oracle Financials. Informatica was used to convert and migrate the data to the new ERP system. Challenges were to understand the new system to be able to design the conversion process. I was primarily responsible for conversion of the AP (Accounts Payable), AR (Accounts Receivables) and vendor data.

Responsibilities:

Lead projects at various stages from requirements gathering and business rules analysis to creating logical and physical database model, ETL design, development and reporting.

Understand different data sources involved and create source to target mappings, data mapping, data diction- ary to enable high quality end product.

Page 3 of 3

Responsible for Data Modelling, ETL design and development, Production support.

Lead data migration/conversion from old ERP system (GEAC) to new ERP system (Oracle Financials).

Architect and implement facts and dimensions for data marts.

Develop, modify and optimize complex queries for data retrieval and modification.

Develop mappings, sessions and workflows using Informatica Powercenter and follow the deployment pro- cess.

Responsible for performance tuning of the ETL programs.

Scheduling the workflows in Cron.

Production support

Lead Developer, GE Insurance Solutions Overland Park, KS, Dec 2000 – Oct 2006 Digitization, Archival and ETL tuning of all Inconcert Metrics for Claims, Billing/Collections and Underwriting (Customer Ful- fillment Divisions) of GE Insurance Applications

Responsibilities:

Interact with the Business, understand their needs, and prepare high level and low level design documents in- cluding data models and source to target mappings.

Create Informatica Mappings /Workflows and support existing ETL code.

Coordinate with offshore team on the deliverables.

Test and deploy deliverables from offshore.

Data mart design using Star Schema methodology. Model reviews and approval from GE IS Architects.

Interact with DBAs for creating/setting Database, tuning/analyze queries, tune datamarts for better perfor- mance, both for ETL and Reports.

Work on Source Data Analysis / Gap Analysis, report back to the Users on can do /cannot do Metrics.

Effective use of Test Director for Bug Fixing and control.

Assist Business Owners in the data collection phase of six sigma projects, a quality procedure followed by GE to improve the productivity of the process.

Environment: Oracle 9i, Unix OS, PVCS, Erwin 3.5, MS Visio, Windows NT, SQL, PL/SQL, Informatica PowerCenter 7.1.2 Technical Lead / Developer, Philip Morris Tokyo, Japan, Jun 1999 - Nov 2000 Environment: ASP, XML/XSL, MTS (Microsoft Transaction Server), IIS, Visual Interdev, Visual Basic Developer, Qatar Telecommunications (Qtel) Doha, Qatar, Apr 1998 – May 1999 Environment: VMS, Oracle 7.2, Form 3.0, SQL Report Writer Developer, Schneider Logistics Inc., Bangalore India, Oct 1997 – Mar 1998 Environment: Visual Basic 4.0, Sybase System 10, ODBC Developer, Trane Bangalore India, Feb 1997 – Sep 1997 Environment: Oracle 7.1, Developer/2000 1.3.2

Contact this candidate