pein new

8/7/2019 pein new

1/5

N-158,Sct 8,R.K.Puram,N.Delhi

Email:[email protected]

Phone: -9899697137

Priyanka Tiwari

ProfileMCA and OCP with 8 years of total IT experience in the areas ofProject Management, SoftwareDevelopment, Quality Control and testing. Responsible for successfully leading and managing

multifaceted Software Development projects in the capacity of Manager, Project leader both at onsiteand offshore. I have worked with Tech Mahindra , Nucleus Software and currently associated withGenpact as Sr. Consultant(Manager) and handling the responsibilities of Database Management

Project Management, Project Planning and Onsite-Offshore coordination, Client Liaison for UnitedHealth Group.

Career Summary

Working with Genpact India, Gurgaon as Senior Consultant with Analytics department.

Project Management, Project Planning, Monitoring and Management like Requirements gathering,

Effort estimation, Resource Planning, Onsite-Offshore coordination, Client Liaison, Identifying andmitigating risk, status meetings, sending out weekly metrics, escalation paths, best practices,

expectations in near future.

Extremely well versed in Database Management, Performance Tuning creating data mart , data

migration, data analysis using Oracle 10G,SQL Queries , Advance PL/SQL, Unix, HTML, DHTML,

XSQL,XSL.

Strong experience in writing complex queries to retrieve data, creating procedure , function, triggers,

dynamic SQL, SQL Loader ,Performance Tuning.

Comprehensive knowledge and understanding in Software Development Life Cycle (SDLC), and

Quality Control.

Excellent communication and presentation skills with demonstrated abilities in mentoring motivatedteams towards achieving organizational goals.

Possess strong leadership abilities. Have been appreciated by my management for building a databaseteam from Ground Zero.

Proven analytical and problem solving abilities.

Excellent analytical abilities with domain experience in US Health Insurance. Built analyticaltechniques and tools to convert data into information and insights.

Work Experience :Total experience in software development is around 8 years.

Currently working with Genpact, Gurgaon as Sr. Consultant since July.2007.

o Have been effectively leading production and Development projects and deliveries

simultaneously.

o Had exposure to work with QA team to resolve the bugs in production.

o Handling the transition of the projects from Ingenix, USA to the Offshore Service Center.

o Coding in SQL, Pl/Sql, Unix, APEX, XSQL,XSL creating test cases and doing UAT.

Worked with Tech Mahindra ltd, Noida as a Technical Associate from Oct.2006 to July 2007.

o Have effectively led Onsite and Offshore PMC/IT team for AT&T on Telecom Domain.

o Handled the responsibilities of working TL by coordinating between Remedy and Oracle

team.

o Coding in SQL, Pl/Sql, Unix, creating test cases and doing UAT.o Worked as an Offshore for PMC/IT team of AT&T.

Worked with Nucleus Software, Noida as a Software Engineer from Nov 2005 to Oct 2006

1

8/7/2019 pein new

2/5

o Worked as a Software Engineer in Cash@will team for Payment module on banking

domain.

o Involved in coding in SQL, Pl/Sql, Forms 9i,Reports 9i, creating test cases and doing

UAT.

o Had exposure to work with QA team to resolve the bugs in production.

o Worked in the UAT team.

Worked with VSVL as Software Engineer from Sep. 2002 to Oct 2005.

o

Worked as a Software Engineer in for ERP(MRMCS) for HR and Finance module.o Involved in coding in SQL, Pl/Sql, Forms 9i,Reports 9i, creating test cases and doing

UAT.o Resolving the bugs in production.

o Worked in the UAT team.

Proficiency Fort (Software Development, Automation, Quality Control, Project Management, Team Management)

Technical

Oracle:- Table, Views, SQL, Dynamic SQL,SQL Loader, Performance Tuning .

PL/SQL Programming:- Create Trigger, Procedure, Package, Function .

SQL Queries:- Simple and Complex Queries using multiple joins, Sub-query, Dynamic SQL .

SQL Server :-Run DTS ,transfer data from one database to another .

XSQL/XSL:- Coding for development work to show the result on Web .

APEX :- Used for creating screens for input with validation and present report .

Developer 9i (Forms 9i and Reports 9i) .

Functional

Managerial

Directing, leading and motivating the teams; imparting continuous on-job training for accomplishing

greater operational effectiveness and efficiency.

Interacting with clients and all stakeholders

Working on succession planning of the workforce, rendering technical guidance to the team members,

appraising the members performance & providing feedback.

Client Management for Fortune 500 clients.

Guiding and mentoring database management team technically as well as product knowledge wise.

Software Development

Requirement gathering, application analysis and ensuring application enhancement.

Interacting with the Users for application study, requirements gathering, analysis and scoping.

Defining QA Process, Templates and Designing Manual

Executing test scripts and maintaining reports of the same.

Preparing test plan, Designing test cases and Tracing requirements through traceability matrix.

Developing automation test scripts to reduce test execution time.

Perform Regression testing through automated test tools to efficiently utilize the time.

Conducting test case / test readiness review meetings.

Performing rigorous black box testing.

Identifying, analyzing defects and in-consistencies in software program functions, outputs, online

screens, and content.

Preparing various matrixes required for analyzing progress of testing and quality of the product.

Quality

SIX SIGMA GREEN BELT certified.

Created GB project through CDFSS approach which resulted into 83% time saving and 300% increase

in data handling capacity.

2

8/7/2019 pein new

3/5

Achievements

Have created SIX SIGMA GREEN BELT Project through CDFSS approach which resulted into 83% time

saving and 300% increase in data handling capacity.

Got multiple awards from both Client and Genpact including Most Valuable Player , Bronze Award,

SPOT Award.

Project Profile

Project#1Worked for Genpact

DATA ACCEPTANCE Project ( Green Belt Project)For Ingenix(a group of UHG),USA.

Role: Sr.Consultant

Team Size: 10

Duration Since Oct 2009.

Environment: Oracle10G,Triggers,Tables,Views,Packages,Procedure,Functions,,XSQL, UnixResponsibility :

This project is being developed with 2 team members offsite and 2 members onsite. I have created the technicalspecification, test cases and test plans for this project and did the coding for this. Unit testing is done by the

technical team offsite . Once the testing is done, the final testing is performed by functional people on site. If any

of the requirement did not met the specification, they use to mention it in a shared document from where I use

to assign it to the team for rectification.This project is being created as a Green Belt Six Sigma project.

Synopsis:

Data Acceptance is a process of cleaning the unformatted data as per products requirement and running the

data through various validation steps(around 115 for each product) . Previously it was done in SQL Server forsome product(facility) and in Oracle for some product(professional)

We have designed a common tool using Oracle10G,XSQL, XSL,Unix which can be used for Data Acceptanceregardless of the product, data type ,data size which will reduce the TAT for doing Data Acceptance and also

eliminate any rework. All reports will be available on Web.This is a GB project which willl result into 83% time saving and 300% increase in data handling capacity .


PA Quality InterfaceFor Ingenix(a group of UHG),USA.

Role: Sr. ConsultantTeam Size: 10

Duration Since July 2009.

Environment: Oracle10G,Triggers,Tables,Views,Packages,Procedure,Functions,Unix ,APEX

Responsibility :

I am leading this project which will be developed to centralize the whole PRODUCT ASSESSMENT process on

web. Currently, the whole process is spread at various location and technologies like a word document is sent tothe prospective client and is not maintained in any database . Now with this process , the whole process will be

available on web with menu driven navigation.Synopsis:

In this tool, we are developing a common tool which will serve as share point for all the steps involved during

the whole process. There will be no forms in word or excel. All the forms will be available on web which can be

accessed by any one at any time.


BENCHMARKING DATABASEFor Ingenix(a group of UHG),USA.

Role: Sr. ConsultantTeam Size: 12

Duration Nov 2008 to June 2009.

Environment: Oracle10G,Triggers,Tables,Views,Packages,Procedure,Functions,Unix ,APEX

Responsibility :

I have developed this tool using APEX Forms, reports as Front end and Oracle as back end. This was highlystatistical project in which various statistics on the data was performed using oracle and result was displayed as

web reports.

Synopsis:Benchmarking database functions as a repository to store detailed data on all analyses completed bythe Product Assessment team, which can be queried to create standard and ad hoc reports. The database

supports sales strategic knowledge of editing and savings trends and the variances that affect them, as well as

providing potential and current clients more insight into how they compare with similar entities in the market.

The database also provides the Product Assessment team with a point of reference to compare data with to more

3

8/7/2019 pein new

4/5

clearly identify peculiar editing trends and anomalies in potential client data which may pose potential problemsin the process or context and explanation of the affects to give back to the client.

Project#4Worked for Tech Mahindra Ltd

Apps Security Compliance (PMC IT)For AT&T,USA.

Role: Technical Associate

Team Size: 4

Duration Nov 2006 to june 2007.Environment: Oracle 9i DB enterprise edition, Remedy 6.3, Oracle Application Server 10G, HTTP

Server (Apache 1.3), Unix

Responsibility :

I was working as an acting TL for this project. My responsibility is to take the requirements from Client and to

provide the deliverables to them which included coding in Pl/Sql, Testing, assigning and monitoring the task to

the team(Remedy/Java) and to provide reports to the Manager.

I have worked on various procedures as to set the Status type of Customer as Active or InActive, to retrieve

the email ids of Customer etc. I have also created various UTPs and done the the testing of various modules.

Synopsis:

This project is in response to the current corporate initiative which is to ensure all applications are compliantwith all applicable AT&T Operating Practices. It includes updates to the system which will allow for the

compliance of the PMC Remedy application with standard AT&T Operating Practices

Project#5Worked for Nucleus Software.

Payment Processing (PD-VIM-ICIC-IN-CASH-0506-F) For Ambank, MalaysiaRole: Software EnngineerTeam Size: 15

Duration Since April 2006 till nowEnvironment: Oracle 9i DB enterprise edition, Oracle Forms 9i Runtime Available with 10gAS,

Oracle Application Server 10G, HTTP Server (Apache 1.3), Oracle Reports 9i

Runtime Available with 10gAS, OC4J, JDK1.4, IE 5.5.

Responsibility :

Writing PL/SQL, Procedures, Functions, Packages, and Triggers, creating various documents as PS,UTP,UTC for

Payments module in Cash@Will (Cash Management). Payments refers to processing of instruments such as

checks, post-dated checks, and ECS to ensure efficient utilization of funds for payments.

I have worked on Inventory maintenance, Invoice maintenance, ECS (Electronic Clearing Service),Reissuance. Payment Entry modules.

Synopsis:

This application is intended to facilitate the Payments Management Operations of Ambank,Malaysia.

Cash Management refers to efficient and effective management of funds. Banks offer Cash Management

Services to their corporate clients in order to provide faster transfer of funds. They take the responsibility for

collecting receivables from the clients buyers and for processing the payables to clients suppliers. Cash

Management helps corporate manage funds efficiently and streamline collections and payment processes. This

results in a huge saving for them in terms of processing time, cost, and charges.

Project#6

Worked for Icon-India Software (Textile Solutions)

E.R.P (M.R.M.C.S) (Management Resource Monitoring And Control System)

For Bhaskar Industries Ltd. (Bhopal)

Role: Team Member

Duration Since Feb 2005 till Oct 2005Environment: Oracle 9i, & Developer 6i (Forms 6i and Reports 6i), Windows 2000 Server.

Responsibility :Writing PL/SQL, Procedures, Functions, Packages, and Triggers, Creating User Manual etc. Integration with

other modules/departments.I have worked on Admin(Administration) , HRS(Human ResourceSystem), RM(Raw Material), STK(Store) module .

Synopsis:

Bhaskar Industry has plants at Mandideep and Head office is in Bhopal with many depots in different cities.

Till now we designed some modules like Admin, HRS, Maintenance, Quality, Store, Raw Material, Production,Dying Packing/Dispatch and waste and implemented them at there plant Bhopal. The project is on the stage of

acceptance testing i.e. the users are testing with live data and changes are made accordingly.Now we are

working on Finance and MIS module.

Professional Qualification

2004 MCA from MDU ,Rohtak

4

8/7/2019 pein new

5/5

2005 OCP(Oracle certified Professional) from Sql Star International.

Personal Profile

Date of Birth :19th Sep-1979

Marital Status :Married

Languages Known :English, Hindi

Visa Details

VISA Details : B1 (Valid US Visa upto 2017)

I hereby declare that the above written particulars are true to best of my knowledge and belief.

Date: __ / __/2010. (Priyanka Tiwari)

5

pein new

Documents

Transcript of pein new