Project Management

ASHISH SRIVASTAVA

Mobile: 099********

E-Mail: **************@*****.***

Job Objective

Seeking assignments in Data warehouse (Data Stage), PL/SQL, Shell Scripting in the IT/ITeS sector.

Professional Profile

An IT professional with 5.2 Years of experience in IT / ITeS functions of mission-critical business solutions using IT as a tool.

Currently working with IBM India Pvt Ltd, Noida as an Technical Analyst.

Automation of Operation Process and Design, Deploying application in UNIX,PL/SQL and Unix Cron .

Developing and troubleshooting of Data stage Parallel Jobs.

An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business & management.

Having Experience in Pl/SQL Objects(Trigger , Cursor , Procedure , Function etc..)

Academic Credentials

MCA from HIMT, Greater Noida, Affiliated to U.P.T.U, Lucknow, in 2006.

B.Sc (Physics, Chemistry & Maths) from SHIA .P.G. College, Affiliated to Lucknow University in 2001.

XII from G.N.L.D Rastogi Intermediate College, Lucknow, (U.P.Board) in 1997.

X from M.A.V Intermediate College, Lucknow, (U.P.Board) in 1995.

IT Skills

Languages : UNIX Shell Scripting, SQL

Database : Oracle 10g, DB2

Operating System : UNIX, AIX

ETL Tool : Data Stage

Organisational Experience

Since April’10 With IBM India Pvt Ltd ), Noida as IT Executive.

Since April’08 with IBM India Pvt Ltd(Contract), Noida as IT Executive.

Since Apr’07 with IBM (Vendor :- Net Connect India Pvt. Ltd.,Delhi) as IT Executive.

Since Jan’07 with Cosmic Softech Limited, Delhi as Software Trainee.

Key Functional Areas;

IT Support / Management

– Application/Database Issue Resolving, tracking with case / system / Process Study etc.

– Focusing on Delivery Management for technical deliverables of concurrent projects according to SLA.

– Defining escalation / response / resolution time for reported problems on the basis of criticality.

– Defining best practices for project support and documentation.

– Application deployment, monitoring, development with training & counseling of processing associates.

– Preparing technical documents, performing task scheduling, change management, creating RFC

SDLC Planning & Management

– Actively involved in Solution Design Phase for the users requirements.

– Identifying business core / critical system / processes and priorities.

– Resolving support/operational issues in liaison with project managers & business group.

– Developing, implementing & providing all kinds of support for business application software for clients.

– Achieving customer satisfaction by ensuring service quality norms and building the brand image by exceeding customer expectations.

– Handling Coding, testing, debugging, implementation & support phase with requisite documentation of the project ensuring all necessary data and matrix are generated ensuring software change request, software change control documents are maintained.

Client Relationship / Account Management

– Driving efforts for outsourcing & setting up remote development environment.

– Understanding & mapping client’s requirements / enhancements to the product & provide technical solutions. Serve as Single Point of Contact / interface for supporting Client.

– Conducting Resource requirement analysis – Software, Hardware, Network and Manpower.

– Providing end-to-end demonstration for obtaining final User Acceptance before kick off.

– Maintaining MIS for all phases and reporting project progress to the client/ senior Management. Meeting deadlines without compromising quality norms.

Key Projects Handled;

1:

Project Title : IRP 360 (Data warehousing Project)

Role : Development (Analysis,Designing,Development)

Organization : IBM India Pvt. Ltd, Noida

Tool : Data Stage 7.5

Database : Oracle

Duration : Jan,2009 to Till now

Description : IRP 360 is data warehouse project to cater the need of Business user for overseeing their business Trend and take decision according to that. Data comes from different sources and

Loaded to DB2 after processing according to Business need .

MODULE: Sales & Distribution

Description:-

The module helped business to provide the tertiary channel information on prepaid, postpaid,blackberry ,paper and easy recharge and paper(SUK). Line of Busienss Mobility

Source: Delimited Files, Oracle

Target: Oracle

ETL: Datastage 7.5

Responsibilities:

• Responsible for the developing of parallel jobs in Datastage Designer.

• UNIX Shell scripts for data loading & to support ETL.

• Completed end to end automation of a module using UNIX shell scripts.

• Helps internal team to resolve post production issue.

MODULE: DTH-CAS & CWN

Description:-

This module includes reporting of the SMS conditional access system (CAS) reconciliation and Closely Watched Number (CWN). Information about subscriber’s usage is there in the CAS as well as in SMS. The objective this module to make both the systems in synch.

CWN includes some high level snapshot of a business basced on KPI,s(Key performance Indicators).These KPI’s includes Closing Subs base, Gross adds,net adds,churn, recharges and suspended. These KPI’s required for business to understand the current business scenarios.

Source: Delimited Files, Oracle(FX,CRM,M6)

Target: Oracle

ETL: Datastage 7.5.3

Reporting Tool: Business Objects XI

Responsibilities:

• Responsible for the developing of parallel jobs in Datastage

• UNIX Shell scripts for data loading & to support ETL.

• Completed end to end automation of a module the Datastage jobs using UNIX shell scripts.

• SQL Query Development for extraction of data.

MODULE : REC-QCB(Revenue Earning Customers)

Description-

This module helped the business to track its revenue on a Monthly basis through multidimensional analysis of Geography, KPI’s and Period. .

Source : Oracle database

Target : Oracle

ETL : Datastage 7.5.2

Reporting Tool: Business Objects XI

Responsibilities:

• Involved in the developing of parallel and server jobs in Datastage

• UNIX Shell scripts for data loading & to support ETL.

• Prepared a detailed Technical design document for the application.

• Involved in moving the modules to operations.

MODULE: Daily Churn

Description:-

The organization to track the number of customers churning away from Airtel on a Daily basis through multidimensional analysis of Geography, Account Segments and Period.

Source : Delimited Files

Target : Oracle

ETL : Datastage 7.5.2

Responsibilities:

• Responsible for the developing of parallel jobs in Datastage

• UNIX Shell scripts for data loading & to support ETL.

• Completed end to end automation of a module the Datastage jobs using UNIX shell scripts.

• Involved in moving the modules to operations and resolving post production issue.

2 :

Project Title : CPRS(Content Provider Revenue Settlement)

Role : Query Developer

Organization : IBM India Pvt. Ltd, Noida

Operating System : AIX

Database : Oracle

Duration : Jan,2008 to Dec,2008

Description : In CPRS(Content Provider Revenue Settlement) data is extracted from different Customer servers from Telemedia Database and processed according to Business need and deliver to Customer.

Responsibility:

1: - Develop a SQL processs for CPRS Application.

2: - Shell Scripting For Automation

3: - Involved in User Acceptance Testing

4: - Assist internal teams to reconciliation of extracted data with BI Data.

3:

Project Title : MIS

Role : IT Executive

Organization : IBM India Pvt. Ltd, Noida

Operating System : AIX

Database : Oracle

Duration : Apr,2007 to Dec,2007

Description : In MIS I had develop the report for Business and fulfilling the Client’s Adhoc Requirement.

Responsibility:

1: - Develop a SQL query based on user requirements for Mobility LOB.

2: - Shell Scripting For Automation

3: - Involved in User Acceptance Testing

Training Project:

Project Title : Automation of Work Updation System Role: Coding

Organisation : Cosmic Softech Team Size: 2

Environment : ASP.NET with C#, Database- SQL Server Duration: 5-months

Description : The project is a composite mixture of control, leadership, teamwork, resource management etc. An employee has to submit his/her work status everyday. Work will be assigned to the subordinates and this will be checked regularly. According to this remarks will be given to them.

Academic Projects

Project Title : Telephone Directory Role: Coding Duration: 1.5 Months

Environment : C Language using File Handling Team-size: 2

Description : This project stores all information (Contact Number, Name, and Address) as General Telephone Directory.

Personal Details

Permanent Address : Plot No:-703,Rishi Nagar, Alambagh, Lucknow-226005

Current Address : 48 B, Anukampa Appt. , Abhay Khand – 4,Indirapuram , Ghaziabad

Date of Birth : 10-01-1980

Contact this candidate