PRAVEEN KUMAR TYAGI

OBJECTIVE

Oracle Certified (OCA) and IT support professional with an outstanding

record of accomplishments for providing technology solutions that meet

demanding time restraints and exceed expectations. Expertly develop

scalable solutions that dramatically improve efficiency, productivity,

and profitability with a demonstrated ability to define and map

project scope, specifications, project time line, resources and budget

requirements from point of planning through production in both

traditional and virtual business environments.

SUMMARY

Currently working with Wells Fargo - Biz Customer Credit Solution at 800

walnut street, Des Moines IA, US.

< 10 years of IT industry experience encompassing a wide range of skill

set, roles and industry verticals.

< Extensive experience with analysis, design, development,

customizations and implementation of software applications.

< Worked as a Oracle PL/SQL Lead at Citibank and Royal Bank Scotland.

< Complete understanding of Oracle advance features.

< Full SDLC (Software Development Life Cycle) experience; Business

Analysis, data requirements gathering, Database design.

< Extensive team leadership skills, project management, strong written

and inter-personal skills, organizational skills, work ethic and drive

and continually striving for process improvements make me a valuable

addition to any project team.

< Strong record for delivering high quality, robust and easily

supportable solutions that on time and on budget.

< Extensive talent for troubleshooting and providing root cause analysis

as well as thinking outside the box for solutions.

< Experience of Data modeling (both transactional -OLTP/ and dimensional

-OLAP).

< Actively Involved in data profiling, cleansing and data analysis.

< Experience in handling multiple roles - Software Requirements Analyst,

Software Architect, Software Developer and Application DBA.

< Actively involved to interact with off-shore team like provide

prototype, knowledge transfer, testing and on-time delivery.

< Good communication skills, customer interaction skills, interpersonal

skills, self-motivated, quick learner, team player.

< Well versed in Normalization/De normalization techniques for optimum

performance in relational and dimensional database environments.

< Proficient in System Analysis, ER/Dimensional Data Modeling, Database

design and implementing RDBMS specific features.

< Well versed with Data Migration, Data Conversions, Data Extraction/

Transformation/Loading (ETL) using PL\ SQL Scripts.

< Involved in conducting Technical Interviews in the areas of Banking

and Oracle development.

< Experience with the Software Development Life Cycle (SDLC) Process -

performing detailed analysis, collecting requirements, documenting

requirements, coding and unit testing, integration and system testing.

< 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..

< Excellent analytical and problem solving skills and can work

independently.

< Strong communication and interpersonal skills, with demonstrated team

dynamics.

< Used dynamic SQL and Collections also used BULK COLLECT to load the

bulk data and used PL/SQL RECORDS.

< Worked in debugging and Tuning the PL/SQL code, Explain plan, tuning

queries, optimization for the Oracle database.

< Proficient in Oracle Forms and Reports.

< Experienced in SAP HANA.

< 24/7 production application support, debugging and solution delivery.

< Implemented table partitioning, Bulk Collect, FORALL to improve

performance and data management. Bitmap indexes were used on low

cardinality columns as they result in reduced response time for

queries and substantial reduction of storage space.

< Experience in Using SQL*Loader, Forms Data Loader Utilities and also

in Using UTL_FILE

SKILLS/TOOLS

Databases: Oracle 11g/10g/9i,SAP HANA, SQL Server, Teradata,

Unix shell Script

Tools: TOAD, SQL Developer, Oracle Forms/Reports, Oracle

Designer,D2K

Languages: SQL, PL/SQL, VB6, C,C++, Pro *C

Version Control: PVCS

Office: Access, Excel, Word, Outlook, PowerPoint.

O/S MS Windows 2000/NT/XP/NT & VISTA, MS DOS and UNIX.

Reporting Tools BOXI, Oracle Forms/Reports, MS Access

ETL Tool SQL Loader, Import/Export

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

EDUCATION

< Master in Computer Applications (MCA) from (IGNOU).

< Post Graduate diploma in Computer Applications (PGDCA) from (IGNOU).

< Graduate from National Institute of Information technologies (GNIIT).

< Oracle Certified Associate (OCA) 9i Developer.

< Bachelor of Science from NAS College, Meerut India.

PROFESSIONAL EXPERIENCE

Onsite Assignments/ Projects:-

Project : Automation of Existing Codes

May 2013 -Present

Client : Wells Forgo

Biz : Consumer Credit Solutions.

Location : Des Moines, IA USA -On-site

Role and Responsibility

. PL/SQL development (packages, procedures, Scripts, functions and

triggers).

. Understand the existing SAS code, Microsoft Access, convert it into

Oracle.

. Gather requirements and write specification and functional design

documents for software development.

Project : Asia Consumer Enterprise Solution (ACES) May

2010-Mar2013

Client : Citibank US

Biz : Retail banking and Credit Cards.

Location : Citibank -On-site

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

. PL/SQL development (packages, procedures, Scripts, functions and

triggers).

. Oracle Forms/Reports Development.

. 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

.

. Deliver new and complex high quality solutions to clients in

response to varying business requirements.

. Ensure that development is performed as per requirements.

. Responsible for managing scope, planning, tracking, change control,

aspects of the project.

. Responsible for effective communication with the customer and to

provide project status to the customer.

. Utilize in-depth knowledge of functional and Technical experience

in Oracle PL/SQL, Unix Shell Scripting, 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.

Project : Sales Station May 2010-Mar

2013

Client : Citibank Singapore/US.

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

Location : Citibank On-site

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

. Involved in requirements and design phases.

. Oracle Forms/Reports Development.

. Gather requirements and write specification and functional design

documents for software development.

. Coordinate and communicate tasks with developers and off-shore

Team.

. Deliver new and complex high quality solutions to clients in

response to varying business requirements.

. Ensure that development is performed as per requirements.

. Responsible for managing scope, planning, tracking, change control,

aspects of the project.

. Responsible for effective communication with the customer and to

provide project status to the customer.

. 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 team member code reviews to ensure standards and Best

Practices are being adhered to.

. Perform code modification to Oracle stored procedures, functions

when necessary to assist team.

. Production Support.

Project : Customer Excellence Reporting (CER) May

2010-Mar 2013

Client : Citibank US.

Biz : Retail Banks and Cards.

Location : Citibank On-site

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

. 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.

. Coordinator with off-shore team and Ensure that development is

performed as per requirements.

. Responsible for managing scope, planning, tracking, change control,

aspects of the project.

. Responsible for effective communication with the customer and to

provide project status to the customer.

. 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 Analytical (RA). Aug 2012-Mar

2013

Client : Citibank US.

Biz : Retail banking (Mutual Funds).

Location : Citibank -On-site

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

. Collect and gather all 15 countries data from EDW like Oracle, Sql-

Server, TeraData.

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

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

. Set of Queries are 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.

. Responsible for effective communication with the customer and to

provide project status to the customer.

. 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

Biz : Cards.

Project : MIS Reporting / DRP (Debit Relief Program)

Location : RBS On-site

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

. Developed and Deployed and supported DRP.

. 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 is performed as per requirements.

. Responsible for managing scope, planning, tracking, change control,

aspects of the project.

. Responsible for effective communication with the customer and to

provide project status to the customer.

. 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.

Cirrus Pvt. Ltd. -Developer Jan

2006 -Apr 2006

Client : Ambuja Cements, Gujarat.

Biz : Human Resource Management System (HRMS)

Location : Cirrus Mumbai, India

It is a complete package, built in Oracle Forms and Reports 9i having all

the HRMS required features required to manage Ambuja Cements.

. Responsible for developing the Oracle Packages.

. Requirement Gathering.

. Oracle PL-SQL developer.

. Oracle Forms and Reports

eHorizon Pvt. Ltd India- Developer Apr 2005

-Jan 2006

Client : eHorizon Pvt. Ltd

Biz : Human Resource Management System (HRMS)

Client : Software Technologies Ltd.

Location : eHorizon Mumbai, India

It is a complete package, built in Oracle Forms and Reports having all

the HRMS required features.

. Developed Oracle Forms and Reports in 10g.

. Responsible for developing the Oracle Packages and Reports.

. Involved in DBA Activities as well.

. Establish Quality Procedures and continuously monitor and audit to

ensure the deliverable meets quality goals.

An-GIP -EDP Executive Apr 2003

-Oct2004

Project : ERP In house Product in Oracle Forms/Reports

Client : Anil Nanda German Indo Product (An-GIP).

Biz : ERP

Location : On-Site

An-GIP is a Multinational Leather Garment Production House company. It

supplies garments to German shopping centers and across the globe . There

is inbuilt package in Oracle forms/Reports called ERP.

It has all the below

< Complete flow from inventory to dispatch.

< Having all employees data

< Having all management Reports.

< Generation Invoices.

< Calculate and generate the commissions.

Role and Responsibility

. Production Support.

. Develop new Oracle Objects.

. Developed Oracle Forms & Reports in 6i.

. Understand the Business Requirement.

. Manage Oracle Database- taking backup, Tune SQL Queries, Database

Performance.

Contact this candidate