Project Support

Mail id: ***********.****@*****.*** Mb. No.: +1-631-***-****

Ritu Shrivastava

9.4 years of experience in field of software development life cycle in requirement gathering, analysis, design, coding, review, testing and implementation. Strong analytical skills with track record of success in designing, developing, and debugging code modules to ensure customer needs are met and satisfaction remains high with every project.

Highly experienced in designing SQL queries to research, analyze, and troubleshoot data and to create business reports; and worked with team to investigate and correct any defects or deficiencies.

Experience Summary

Worked extensively on IBM/AS400 using RPG/400, CL/400, COBOL/400, DB2/400, RPG ILE, ADT Tools and ILE environment languages.

Proficiency in embedded SQL/400.

Expertise in DB2/400 with concepts like Database Integrity, Indexes, Commitment Control and Journaling.

Experience in providing technical assistance to Business Analysts in capturing detailed business

requirements for creation of the Business Requirement Documents.

Proven capabilities in identifying and suggesting various improvements in system. Identified data issues and provided resolution to ensure optimal performance.

Well conversant with Project and work request estimations.

Excellent Skill is SQL Query designing, QMQRY, Query optimization, using query plan.

Wrote complex SQL queries using complex joins, grouping, aggregation, nested subqueries, and cursors.

Worked on system performance enhancements. Implemented performance tuning by implementing suitable optimizations and appropriate indexes and keys.

Conversant on FTP files transfers, connection strings, AS400 Integrated file system (IFS).

Excellent Knowledge of CL/400 using Open Query File concepts.

Excellent coding skills in RPGILE using Subroutines, Procedures, Data Queues, Data Area and Sub-files.

Excellent knowledge of RPG ILE using concepts like Module, Service Program, Binding Directory, Procedures, and Activation Groups etc.

Working knowledge of Synon.

Been Onsite (Paris) for requirement gathering, ST, UAT and Implementation support for various projects.

Education:

Master of Science (Information Technology) July - 2002

M.C.R.P. University (Bhopal, M.P.)

Bachelor in Computers Application. Dec - 2000

M.C.R.P. University (Bhopal, M.P.)

Experience:

Organization

Designation

Duration

CapGemini IndiaPvt.Ltd

Senior Consultant

Oct 2013-Oct 2014

Mphasis an HP Company

Module Leader

Sep 2008-Oct 2013

HSBC Software Development India Pvt. Ltd.

Senior Software Engineer

Jun 2005 – Sep-2008

Rajiv Gandhi Computer college Shahdol(MP)

Lecturer

Apr 2003 – Dec 2004

Technical Skills

Operating Systems

OS400 Win-9x/2k/NT

Languages

SQL,ILE-RPG, RPG/400, Cobol/400,CL/400, SQL/400, QUERY/400, DB2/400, Synon

Databases

DB2/400,Oracle7.4, MS-Access, SQL Server

Domain Knowledge

Financial, Banking, Manufacturing.

Training

SI#

Title

Location

Organized by

Duration

1

AS/400

PUNE

Seacom Pune

3 Months

2

Core Java

PUNE

HSBC Software development

5 Days

Work Profile Summary

Date: 09/13 – 10/14

Organization: Capgemini India Pvt Ltd.

Project: HSBC Holdings

Module: HBME CDD, EWRA

Software: OS/400, CLLE, SQL, RPG (Free format), QMQRY

Responsibilities

Analyze data and implement procedures to support development teams and front end users working with various applications.

Create business reports in designed Excel spreadsheet with pivot tables.

Identify data issues and provide recommendations for resolution to ensure desired report.

Developed sql queries to validate accuracy of data to ensure database integrity.

Unit testing, UAT/SIT support, implementation, post implementation support.

Data analysis for reporting on demand reports/adhoc reports to stakeholders.

Identifying areas for improvement and introducing resuble componets.

Source Code Promotion using Implementer.

Weekly reporting of Project Status, Adhoc Status.

SQL Training and Mentoring team members.

Key Achievements:

Provided risk assessment dashboard on 7 years data, as per the questionnaire given by the business having more than 70 questions. In-order to achieve this developed extensive SQL Queries in very limited time frame. Developed reusable component for the same.

Trained and guided team to implement the same for all 11 sites.

Got solid recognition for providing the business report in given format with pivot table without any discrepancy.

Date: 06/09 – 09/13

Organization: Mphasis an HP Company

Project: Western Union Business Information System

Module: EIM/Financial Control (Wells Fargo)

Software: OS/400, COBOL/400, SQL, SYNON, RPG (Free format), Embedded SQL

Responsibilities

System monitoring and Run Time Improvements for the Jobs/Queries consuming high CPU and I/O.

Created and optimized diverse SQL queries.

Extensive Query Designing for Report generation on Datawarehousing Adhoc requests.

Implemented performance tuning by implementing suitable optimizations and appropriate indexes and keys.

User requirement analysis, estimation, suggestions to user, providing best solutions, development, unit testing, UAT/SIT support, implementation, post implementation support.

Production Support and Oncall Support.

Support during disaster recovery outages and OS Upgrades.

RCA for SLA Breach.

Source Code Promotion using Implementer.

Weekly reporting of Project Status, Adhoc Status and Production support Incidents.

Key Achievements:

Without any prior experience in Synon, self learnt and managed to deliver projects with in given timelines.

Designed and developed Purge process for EIM (Data warehousing) and got recognition for same.

Developed utility to monitor and alert on SLA breaching jobs.

Date: 10/08 – 06/09

Project: SKF India/Central

Module: COH/DOH

Software: OS/400, COBOL/400, RPG (Free format)

Responsibilities

User requirement analysis, estimation, suggestions to user, providing best solutions, development, unit testing, UAT/SIT support, implementation, post implementation support.

Ammendment in Cobol/400 Source Code.

Peer reviews.

Identified functional test cases to prepare Unit test Reoprt.

Independent Unit testing.

Source code promotion Using Implemnter.

Retrofitting on Local Sources for US 6.5 Release.

Key Achievements:

Without any prior experience on Cobol/400, delivered project where application was designed in Cobol/400. Proactively learnt Cobol/400 within the timelines of project deliveries.

Date: 06/05 – 09/08

Organization: HSBC Global Technology Center

Project: HSBC France (CCF) Engagement

Software: OS/400, CLLE, RPG (Free format), RPGLE, Embedded SQL

Responsibilities

Handling of messages received from Internet banking Front-End Cerise.

Involved in gathering client requirement and technichal specifications.

Identified functional processes and prepared Statement of understanding as per the received user requirement.

Preparing External/Internal design Report for project.

Communicated and maintained issue log for the different issues encountered during project span.

Allocating tasks to the team members and maintained task allocation sheet.

Organised Panel and Peer reviews for all deliverables.

Technichal support provided to team as and when required.

Maintained all the delivered documents in Domdoc with versions.

Prepared system Test Plan.

Logged all defects identified at various stage of project into mercury quality center.

References available on request.

Contact this candidate