Resume
Sign in

Sales Project

Email
Location:
Polk, Iowa, United States
Posted:
September 19, 2013
Email:
ab74df@r.postjobfree.com
Contact Info:
********@*****.***


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.