Praveen Kumar Tyagi

Roles Performed:

Data Analyst, Python Developer, Informatic Cloud Developer-IICS, Informatica Power Center Developer, Oracle PL-SQL Developer, Product Owner, Oracle Forms/Reports Developer, Root Cause Analyst, Lead Onshore/Offshore.

Location:

NJ, USA

Certification:

Python and Oracle SQL

adlxtp@r.postjobfree.com, +1-551-***-****

Professional Summary

15 years of combined experience in and as Data Analyst, System Architect, Root Cause Analyst, Oracle PL-SQL Development, Informatica Cloud Development, SQL Server Development, Data Engineering, ETL Development, MIS reporting, Oracle Forms/Reports Development, Data Ware House Design and Development, Testing, Business Analyst in Banking Domain, In-House ERP Development.

Proficient in wide range of Databases, Tools and Languages- Oracle 10g/11g/12c, Green Plum, SQL-Server, PL-SQL, SQL, Core Java, C,C++, Informatica PowerCenter, Toad, SQL Loader, SQL Developer, BOXI, Sap Hana, Tableau, Excel Reporting,, WinSCP, Unix, Oracle Forms/Report.

MCA-Master’s in Computer Applications

Solid verbal and writing communication skills.

Working as a Product Owner, Informatica Cloud Developer, Lead On-site at Chubb NJ.

1 Year Worked as Data Analyst, Oracle, ETL, GP Developer with Genworth Insurance VA.

3 Years worked as Data Analyst, Root Cause Analyst, Oracle Developer with Swiss Re KS.

3 Years worked as Oracle Developer, Data Analyst, BOXI developer with Citibank Singapore.

4 Years worked as Oracle Developer, Oracle DBA with ABN Amro(RBS) Bank in India.

2 years worked as EDP-Executive for In-House ERP Development with ANGIP in India.

1 Year worked as a Developer and DBA with Mastek India Ltd Mumbai

Extensively worked in Data modeling (both transactional -OLTP/ and Analytical -OLAP).

Actively involved in data profiling, cleansing and data analysis.

Involved in conducting Technical Interviews.

Extensive experience in Performance Tuning using various techniques like Explain Plan, analyzing objects, query rewriting, memory management, object dead lock handling, generating statistics. Indexes, Hints, Partitioning, Data Analysis, Optimization, Tuning queries, collections, Cursors, SQL Loader and Normalization techniques to overcome the performance issues in production environment.

Skill Profile andTools:

Databases:

Oracle 11g/10g/9i, SAP HANA, SQL Server 2012, Teradata, SQL Server, GreenPlum

Tools:

IICS, TOAD, SQL Developer, Power Center, MDM, Greenplum, Putty, APPWORX, WINSCP

Languages:

SQL, PL SQL, VB6, C, C++, Unix shell Script, Unix shell Script, SAS, Core Java

Version Control:

PVCS, TFS

Reporting Tools

BOXI, Oracle Forms/Reports, MS Access

ETL Tool

Power Center Informatica, SQL Loader, Informatica Cloud IICS.

Web Languages

HTML, XML, ASP, Java script, Oracle Web toolkit

Professional Experience:

Organization Name: Capgemini Inc

Project : PRS Data Strategy from Aug 2019 – Current

Location : Whitehouse, NJ

Client : CHUBB

Chubb, a global provider of insurance products covering property and casualty, accident and health, reinsurance, and life insurance and one of the largest publicly traded property and casualty company in the world. There are four transaction driven Policy Admin Systems in Scope (Masterpiece, PLS, DRC, CAAS) and typical transaction includes are Newline, renewal, cancel rewrite, endorsements, and change of producer. Currently PRS data is stored on multiple sources in different format making it difficult to PRS business to find, consume and Analyze the data effectively. The financial booking/issuance of the premium bearing transaction generates an xml and feed to the PRS gateway to prepare the data for financial processing PRS Genus application. The target is Common Business Definition which will contain data in a common format that can be shared and used with PRS and across organization.

Role and Responsibilities as Product Owner, Data Analyst, IICS Developer

IICS and Database (Oracle and SQL Server) Development.

Python development

Front line technical support and supervise all the production deployment.

Lead Offshore Team and Coordinate with Client to ensure that development and deployment should be performed as per standards and requirements

Code Review, UAT Testing and Quality Assurance.

Data Profiling, Data Analyzing, Optimization, tuning queries and working on procedures to overcome the performance and technical issues in production environment

10% production Support

Involve in PL and Sprint Planning.

Project : RTS Project – SMART & SFDC from Aug 2018 – Aug 2019

Location : Richmond, VA

Client : Genworth Financials

Genworth Financial has three segments: Retirement & Protection, US Mortgage Insurance, and International. Products and services include life and long-term care insurance, mortgage insurance, and annuities. The objective of this project is to provide Application Monitoring Support on (24 * 5) mode & Enhancement Support on (16 * 5) mode for EDW Applications. It required lot of troubleshooting, process improvement and quality assurance using BIG Data and Hadoop technologies for Genworth’s Data Integration and EDW projects and building Methods, Frameworks, Solutions using various technologies/tools for Genworth’s MDM.This includes extracting data from many heterogenous sources like Salesforce, MDM and transforming the data based on the business rules and loading into one central EDW system providing the organization a consolidated view of the information and help in taking informed decisions using data accurate reports.

Role and Responsibilities as Oracle PL/SQL, Data Analyst, Informatica Developer

Analyzed and Developed end to end solution to extract JSON raw response from Salesforce and populate into Oracle Database tables, so user can make informed decision.

Informatica Power Center, Oracle, Green Plum, Unix Development.

Responsible for Analyzing, debugging and resolving errors on-time and support in monitoring daily, weekly and monthly job processing

Debugging and resolving errors of Enterprise Data Warehouse application process flows and jobs through AppWorx Scheduling, GP Loader log monitoring tool, Informatica PowerCenter for maintaining 100% SLA (Service Level Agreement) adherence of Genworth production environment.

Responsible for Accepting and implementing Incident Requests (IRs) for direct fixes in production and Service Requests (SRs) for Application related changes, submitted by Business Analysts in Service Catalog/Service Now and tracking tickets on Genworth Helpdesk portal.

Performed the performance tuning at source and Target DB using Indexes, Hints and Partitioning in ORACLE and Informatica.

Investigating and fixing the bugs occurred in the production environment.

Involved in collecting statistics, rebuilding indexes, user management and develop queries to improve the performance of the databases.

Project : Corso Claims Information Run from Jan 2015 – Aug 2018

Location : Swiss Re, Overland Park, KS

Client : Swiss Re

Swiss Re has partnered with Capgemini Inc. to transform its data warehousing space. The primary goal of this project is build a data warehouse where data from multiple sources can be brought together and used for operational and analytical reporting. Swiss Re in the management of data warehousing and reporting work stream, including alignment and execution with respect to critical path dependencies within and across other work streams.

Role and Responsibilities as Oracle PL/SQL, Data Analyst, Informatica Developer

Design solution architecture to integrate data from multiple sources like PinJ, AC/Risk Master and build a centralized data warehouse called CMP which may be used as an enterprise reporting environment for Java and BOXI Dashboard.

Involved in Root Cause Analysis.

Operate database management systems to analyze data and perform lot of data mining, data cleaning and data masking.

Tuning SQLs as a part of resolving the performance bottlenecks.

Involved in Informatica Development and ETL mapping document.

Develop Database Objects- Packages, Views, Triggers, Functions and Procedures.

Involved in collecting statistics, rebuilding indexes, user management and develop queries to improve the performance of the databases.

Project : Commission and Registration System from Jun 2014 – Jan 2015

Location : LPL Financial, Charlotte, NC

It is an Oracle Based system called ComReg used by LPL financial advisors, Commission Group and Registration Team. ComReg contains the commission, registration and some compliance related apps. It is the transaction processing system and repository for all commissions and Registration data associated with LPL advisers. It also produces all sorts of financial management, sales, and compliance reports.

Role and Responsibility as Oracle SQL, Oracle Forms Developer:

Oracle PL/SQL development for Oracle Objects like partition tables/index, indexes, packages, procedures, Scripts, functions, triggers, External tables, pipeline, collections etc.

Oracle 11g forms and SQL Reports.

SQL Tuning, Database backup, script to deploy in production after UAT sign-off.

Co-ordination with different teams, senior management and different Lines of Business.

SQL Performance tuning and implementing Oracle 11g features.

Production support.

Identification and analysis of data issues, performing root cause analysis and providing recommendations for the remediation of any underlying data quality issues

Client – Citibank Singapore from May 2010 to Dec 2013

Project : Asia Consumer Enterprise Solution (ACES)

Biz : Citi Bank Retail banking and Credit Cards.

ACES is a single platform provide management insights covering daily sales, balance, profitability, net flow; sales force productive and cross sell performance across Asia Pacific region. It has regional sales dashboard/ data mart, leveraging on existing Enterprise Warehouse (EDW), Sales station and Financial Data Warehouse (FDW). It is a single Platform for standardizing KPI definitions for consistent analysis & decision making across region. Provide daily business matrix across 15 AP countries, product, customer segments and sales hierarchy on daily bases through a set of KPIs – useful for analyzing business trend & variations from Plan numbers.

Target User Groups in Regional and 15 Countries

Regional Sales

Product segments SMEs (Subject Matter Experts)

Regional Heads

FINCON

DM- country Business & function Heads

Role and Responsibility as Oracle Lead and Business Analyst

Built OLAP star Schema as a single platform for various data source.

ETL- Data stage mapping to populate facts.

PL SQL Lead development (packages, procedures, Scripts, functions and triggers).

Data Analyst, Data mapping, Data Quality, Data Governance

Perform business gathering requirements from business users, stakeholders, and Subject Matter Experts (SME’s)

Responsible for requirements and design phases.

Developed a layer to close the gap between DRI and Rainbow.

Gather requirements and write specification and functional design documents for software development.

Coordinate and communicate tasks with developers and off-Shore Team.

Involved in the development BOXI Dashboard.

Ensure that development performed as per requirements.

Responsible for managing scope, planning, tracking, change control, aspects of the project.

Project : Sales Station

Biz : Retail banking, Credit Cards and Citi Phones (CPH).

Client : Citibank, Singapore

Sales Station would serve as a robust Enterprise Compensation & Performance Management tool that will enable consistent approach to managing the sales process across Asia Pacific. It would support multiple business Segment sales organization and serve as a platform for reliable & timely sales information by aiding in Goal setting, measurement & incentive calculation across the sales hierarchy. This will help in development of healthy sales culture for rewards & recognition. KPI definition module brings the ability of configuring new and existing KPIs to the users directly, by reducing time and effort significantly spent on introducing changes to KPIs.

It has below features

“Goal Allocation” aides in setting a goal for a KPI for a user or a set of users in a single shot while addressing the grace on the goals for special cases. The interactive interface makes the goal allocation simple and effective

Scheme Wizard uses one of the best Rule Engines to simplify changes and introduction of new schemes. It uses “Rete algorithm” to compute the schemes in a bulk there by saving time and CPU during computation. The user friendly interface makes the scheme maintenance easy for any user to maintain the scheme

“Simulation of schemes”, which can be used for the biz planning exercise, provides business the flexibility to simulate new schemes before introduction into main stream with existing or new set of data

Micro marketing a powerful analytical tool enables analysis on the customer data by cutting them through different dimensions available in SS and gauging them with the KPIs. This is one of the tools to generate leads and send to COPS. Leads generated for various biz segments and channels will complement the COPS generated data.

Post batch adjustments at transaction, Account and incentive amount reduces increases the accuracy of the results there by allowing the system to capture arbitration results that happened outside any system

Role and Responsibility as Oracle Lead and Business Analyst

PL SQL development and Involved in requirements and design phases.

Data Analyst and Oracle PL/SQL Lead Developer.

Gather requirements and write specification and functional design documents for software development.

Coordinate and communicate tasks with developers and offshore Team.

Deliver new and complex high quality solutions to clients in response to varying business requirements.

Data mapping, Data Quality, Data Governance.

Responsible for managing scope, planning, tracking, change control, aspects of the project.

Utilize in-depth knowledge of functional and Technical experience in Oracle PL SQL, Unix Shell Scripting and Data Stage (ETL), Oracle SQL Loader and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.

Establish Quality Procedures and continuously monitor and audit to ensure the deliverable meets quality goals.

Assist Oracle developers in troubleshooting existing production code.

Perform code modification to Oracle stored procedures, functions when necessary to assist team.

Production Support.

Project : Customer Excellence Reporting (CER)

Biz : Retail Banks and Cards.

Location : Citibank, Singapore

This Customer Excellence Reporting model involves using of a scorecard to depict customer experience across all channels. It involves

Definition of consistent Service Channels to be used to summarize Customer Experience

Identification of Customer Goals (Business Transactions) that our customers use via the Service Channels

Development of repeatable Scoring Methodology for calculating Customer Experience

Implement regular Data Capture in interval necessary for accurate reporting

Build and Share Customer Experience Reporting

MIS having how many times Citibank Customers touches the Citibank Channels.

Channels in Scope

Branch

ATM

POS

Internet and Mobile

CPH

IVR

Role and Responsibility as Oracle Developer and Business Analyst

PL SQL development and Responsible for requirements and design phases.

Data Analyst and Oracle PL/SQL Lead Developer.

Deliver new and complex high quality solutions to clients in response to varying business requirements.

Coordinator with offshore team and Ensure that development performed as per requirements.

Responsible for managing scope, planning, tracking, change control, aspects of the project.

Utilize in-depth knowledge of functional and Technical experience in Oracle PL SQL, Oracle SQL Loader and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.

Project : Regional Analytics (RA)

Biz : Retail banking (Mutual Funds).

Location : Singapore

RA is a single platform provides management insights covering Monthly Mutual Funds sales, balance, Redemption, net flows; sales force productive and cross sell performance across Asia Pacific region. Business can see the trend and analyze the gap between Actual numbers and reported/Pearl Numbers.

Target User Groups is Regional management.

Role and Responsibility as Data Analyst and Data Architect

Data Analyst doing Data Mapping, Data cleansing, Data masking and Data mining

PL SQL development, Collect all 15 countries data from EDW - Oracle, Sql-Server, Teradata.

SQL Loader/ETL used to upload data into target schema.

SQL Server-Tables, Procedures, functions created to fetch data.

Set of Queries Created for Teradata.

Responsible for requirements and design phases.

Develop the report in Excel.

Deliver new and complex high quality solutions to clients in response to varying business requirements.

Establish Quality Procedures and continuously monitor and audit to ensure the deliverable meets quality goals.

Client : ABN AMRO (now Royal Bank Scotland) Bank (Jan 2007-Jan 2010)

Project : MIS Reporting / DRP (Debit Relief Program)

Location : RBS Gurgaon, India

Involved with communicating clients and the backend programming by creating packages, procedures, Export/Import Database, optimize queries and DBA Related task in production environment.

Responsible to gather requirement and provides Schedule and Ad hoc reports.

DRP- Before write-off Identify the potential customer not paying Outstanding. Bank can collect a minimum required amount and make installments for the rest amount. It will take care of closing all old accounts and creating a new account and track the account up to complete amount received. Not less than 50 people are using this package and continuously log the required improvement activities in the Lotus notes and after getting the approval. Senior management will have regular reviews of the progress and direct oversight of the changes made to the solution, and constant reporting on current user requests, interfaces monitoring, etc.

Identify the Customer where Risk Involved. Decrease their Credit limit.

Role and Responsibility as Oracle Developer

Developed and Deployed and supported DRP and PL SQL development.

Responsible for requirements and design phases.

Gather requirements and write specification and functional design documents for software development.

Deliver new and complex high quality solutions to clients in response to varying business requirements.

Ensure that development performed as per requirements.

Responsible for managing scope, planning, tracking, change control, aspects of the project.

Delivered MIS to client.

Mastek Ltd. India —Developer Apr 2006 –Oct 2006

Client : LEX UK

Biz : Vehicle Leasing

Location : Mastek Mumbai, India

Lex is a Vehicle Leasing Organization needs a complete package to manage and track all the needs.

It is a package built in Oracle Forms and Reports having all the required features from Vehicle leasing to collection.

Daily Rental

Providing Services- Accidental Polices, Insurance etc.

Selling, Delivering and Collection of Vehicles.

Role and Responsibility

Responsible for developing the Oracle Packages and Reports.

Oracle Objects.

Involved in DBA Activities.

Education

Educational Record

Course of Study

Specialization

Name of University

Address of University

Year of Completion

Masters in Computers Applications

Computers

IGNOU

New Delhi, India

2007

Graduate from National institute of In information tech.

Computers

NIIT

New Delhi, India

2004

Bachelor in Science

Physics, Mathematics,

Statistics

CCS university Meerut, UP

Meerut UP, India

1997

Professional Organizations

Prior Work Experience Details

Organization’s Name

Designation

Dates of Employment

Location (City & State)

Explanation for Interruption / gap

(If Any)

From

(DD-MON-YYYY)

To

(DD-MON-YYYY)

Igate Inc/Capgemini America

Business System Analyst2

12-Jun-2014

Overland Park, KS

3i Infotech

Programmer Analyst

25-Sep-2013

09-jun-2014

Monroeville, PA

Saksoft Ltd

Lead tech.

01-dec-2006

25-Sep-2013

USA, Singapore, india

Mastek Ltd

Developer

12-Jun-2006

15-Oct-2006

India

Training, Certifications & Affiliations

Ceritifitate in Business Analytics

Certificate in project management

Oracle PL/Sql Associate

Contact this candidate