SAUMYA SINGH

Email: abmkp5@r.postjobfree.com

abmkp5@r.postjobfree.com

Phone: 248-***-****

PROFESSIONAL SUMMARY

. Software System Analyst with 7 years of IT experience. Experienced with

monitoring and reporting development and maintenance projects.

. Lead and mentored staff for 3 years for development and maintenance of

Oracle based applications.

. Certified, Senior Oracle Developer with exhaustive experience in design,

development, testing and maintenance of custom applications using Oracle

databases and tools in Unix and Window environments.

. Experienced report designer and developer using BO-Crystal reports and

Oracle Developer Forms and Reports.

. Trained in Data-warehousing techniques using SAP-BW.

. Extensive experience performing design, development, testing and

maintenance of client server and multi-tier applications using SQL,

PL/SQL, UNIX shell scripting and Windows OS.

. Proficient in MS Access and interfacing it with Oracle databases.

. Hands-on experience with Business Objects XI, Crystal Reports, Delphi

RAD, D2K 6i Graphics, Forms and Report Developer, including publishing

reports on web using HTML.

. Elementary hands-on experience with C programming.

. Exposure to Supply Chain Management, Telecommunications Rating and

Billing and US Federal business domains.

. Detailed knowledge and hands-on experience on Geneva/IRB Rating and

Billing engine.

. Exposure to Adexa Supply Chain Planner and Sherpa DMS Product Data

Management System.

. Experience with a wide variety of software configuration and change

management tools including VSS, RCS, CM-Synergy, SVN, JIRA

. Expert in handling client communication and requirements gathering for

projects.

. Experience in leading small teams as a Team lead within project team with

successful on-time quality deliveries

. CMM Level 5, CMMi Level 5 and BS7799 (Information Security) process

aware.

. Adjudged Quality champion while working for Skyworks.

. Received Power of One recognition at Convergys for initiative and

integrity in bringing development in new technologies to the team.

PROFESSIONAL CERTIFICATION

. Oracle Corporation Certified Associate (Oracle 9i) with an aggregate of

92%

TRAINING COURSES

. Professional Web Designer course from IPEM, India.

. SAP BW - Introduction Course from SAP Training Partners -

yoursaptrainer.com

TECHNICAL SKILLS

Operating System - Windows 95/2000/XP, Windows 2003 Server 64 Bit, UNIX

Tru64, HP-UX 11i, Sun Solaris

Environment - Client Server, Distributed

Database - Oracle 7.x, 8x, 9i, 10g, SQL-Server 7.0, MS-Access

ERP and Reporting Tools - Business Object XI R2, Crystal reports 8, XI R2,

Oracle Developer 2k 6/6i

Development Tools - Toad, Bunyan, PL/SQL Developer, SQL Developer, Delphi 7

Other - Unix Shell scripting, Tool Language for Adexa Planning Engine

Source Control/ Version Management - VSS, RCS, CM-Synergy, JIRA, SVN

DOMAIN EXPERTISE

. Exposure to Supply Chain Management domain

. Exposure to Telecommunications Rating and Billing Solutions domain

. Exposure to US Federal domain - Real Estate and Property management.

EDUCATION

. B-Tech (Bachelor of Technology) in Electronics from Kamla Nehru

Institute of Technology (INDIA) with an aggregate of 83%

PROJECTS HANDLED

Sep 2008 - Current

Employer - DSR Management Inc., Evanston, IL

Client - Subsystem Technologies Inc. for Federal Aviation Administration,

Washington, DC

Project: Real Estate Management System (REMS)

Role: Senior System Analyst

URL: www.subsystem.com, www.faa.gov

This project is aimed at developing, supporting and maintaining Real Estate

Management system for the Federal Aviation Administration. This intranet

system is the primary Real Property management system for the DoT in the

USA. The front-end is developed in ASP/.Net and the backend database is

Oracle 10g.

Roles & Responsibilities -

. Prepare reports for FRPC and OMB submission.

. As the only Database analyst and developer in the team, I was

responsible for database design for all enhancements and new features.

. Developing, Testing and Deploying database code for REMS in

production.

. Production support including data analysis and integration.

. Crystal report development and maintenance. Including deployment of

Crystal Reports on Production.

. Work independently to study the system and offer strategies of

improving the functionality and performance of the system.

. Impact analysis of database changes, including but not limited to

adding/removing database objects for better system design.

. Involved in gap analysis of advancing REMS to include leasing

information and address the requirements of the users from FAA's

obsolete Lease information management system.

. Extensively involved in laying out an establishing software processes

for REMS, including configuration and change request management using

SVN and JIRA.

. Worked as support DBA for the project. Responsibilities involved

ensuring successful backups, occasional client and small database

installations and troubleshooting.

Environment: Oracle 10x, MS Access 2000 - 2007, Windows XP Professional,

Server 2003, SQL, PL SQL, Crystal Reports 8 and XI

Tools: SQL Developer, TOAD, SVN, JIRA

Dec 2005 - Oct 2007

Employer - Convergys IMG, Hyderabad, India

Project: Infinys Rating & Billing (Geneva Engine) - Core Interfaces

Role: System Analyst

URL:http://www.convergys.com/solutions/customer-solutions/convergent-

billing/convergent-charging.php

This project is aimed at developing, supporting and maintaining Infinys

Rating & Billing flag ship product of Convergys. This is also known as

Geneva. Geneva is a widely used to provide convergent Billing and Rating

solutions in Telecommunications vertical for many small and middle-sized

telecommunications companies worldwide. Its core catalog is a set of rules

set in Oracle PL/SQL for rating events and billing them at the end of the

cycle. A graphic interface developed in Delphi is supplied to modify these

rules.

Roles & Responsibilities -

. Understand the product overview and functional knowledge of the tool

and the domain

. Product Analysis and Feasibility Study of the requirements

. Review analysis, design documents and test plan, test cases for the

module enhancements, customizations as part of IRB releases in 2006 &

07.

. Lead the maintenance team through allocation of maintenance requests

at all releases and tracking them to completion.

. Maintain and report maintenance progress and metrics to management,

including review of fixed client reported bugs at all level of

severity.

. Participated in design of Catalog import and export system which

entailed pulling up catalog data in form of XML and importing it to a

different database.

. Collaborated with interfacing modules to design IRB Catalog for

implementation of Oracle RAC to improve scalability of the

application.

. Assited system test team with data integrity issues at all level of

product release, including maintenance releases.

. Led a team of new joinees in the project pioneering Delphi development

as User Interfacing development.

. Reviewed and documented business rules, functional and technical

designs, test cases, user guides and release notes.

. Impart new recruit and inter-project training for Core Interfaces.

. Plan and arrange Technical and Domain training for team members for

skill development.

. Conduct technical interviews for lateral and in-house candidates.

Environment: Oracle 8x, 9x, 10x, Delphi 7, Geneva product and framework,

Unix (HP UX, SUN Solaris), Linux Redhat, Windows, SQL, PL SQL, XML, Oracle

Advanced Queuing, Oracle RAC

Tools: CM Synergy, Rational Clear Case and Clear Quest, PL/SQL Developer,

Bunyan, TOAD

Jun 2004 - Nov 2005

Employer - HCL Technologies (India) Pvt. Ltd., Gurgaon, India

Client - Skyworks Solutions Inc

Irvine, CA USA

Project: ADEXA-SAP Interface (Supply Chain Planning Interface)

Role: Senior Developer/System Analyst

URL: http://www.skyworksinc.com/, http://adexa.com

This project is aimed at development, customization (including user

requested enhancements), maintenance and production support of ADEXA -

Supply Chain based planning system for Skyworks. The primary goal of this

project is to integrate the isolated Supply Chain Planning system into SAP

based ERP environment. Project involved modification of all interfaces of

the Adexa based supply chain planning system to accept input from SAP and

provide output to SAP. It also involved minor changes to the system core in

order to process the inputs correctly.

Roles & Responsibilities

. Transit to from developer to System Analyst role.

. Maintain the current system and provided production support as and

when issues arise.

. Communicate directly with end users of the system to define, analyse

and solve production and data integrity issues.

. Check and restablish data integrity as and when required by the end

users.

. Analysis and assistance for SAP-BW application input interfacing for

ADEXA.

. Work at client's side for analysis of the proposed architecture and

current architecture

. Impact analysis and feasibility study of migration, customizations and

enhancements.

. Core member and provided subject matter expertise on ADEXA and

functional business processing rules for Skyworks

. Provided senior-level support to SAP/ABAP programmers and Cognos

report writers regarding all aspects of Oracle, Unix, SQL and PL/SQL.

. Resolved data integrity issues with SAP interface during the test run

and after release till application stabilization.

. Generated database views, public PL/SQL functions, packages, triggers,

procedures and anonymous blocks.

. Tuned inefficient report and view queries using combinations of index

creation, alternate indexing strategies, join strategies,

localization/periodic refreshment of remote data objects, and session

and query level optimization hints.

. Solely responsible for all internally developed SQL, PL/SQL and UNIX

Korn shell scripts executed through cron

. Involved in code enhancements and customizations for ADEXA 5.1 upgrade

from ADEXA 4

. Documented business rules, functional and technical designs, test

cases, and user guides.

. Created documentation for all aspects of the project including

training the end users.

. Participated in Internal and External project reviews inline to the

SEI-CMM standards

. Establish, maintain and report project progress and metrics. Establish

risk management plan for the application.

Environment - Oracle 8i, 9i,HP-UX Posix-Shell Scripting, Windows, ADEXA

interface, ADEXA proprietary language, SQL, PL SQL, HP-UX 11i, SAP - BW

Tools- TOAD, Microsoft VSS, UNIX Revision Control System

Jun 2003 - May 2004

Employer - HCL Technologies (India) Pvt. Ltd., Gurgaon, India

Client - Skyworks Solutions Inc

Irvine, CA USA

Project: Xcalibur and OEE Development & Migration

Role: Senior Oracle Developer

URL: http://www.skyworksinc.com/

The XCALIBUR system is supply chain planning being used by Skyworks Systems

(leading wireless semi-conductor chip anufacturing company based in USA).

In the backend, tables and views are prepared according to actual and

forecasted demand ver a pre-stipulated planning horizon. The inputs to this

system come from three sources:

SAP

PROMIS VAX System

User entered data, through the Adexa Interface

The output is a number of reports published in MS Excel.

The OEE system is a part of the supply chain system for Skyworks and

monitored lots at the shop floor level. Taking input from PROMIS (as text

files) and users through a Developer 6i Forms user interface.The output is

a number of reports published on the intranet using HTML and Developer 6i

Reports and Graphics.

The project entailed maintaining the current systems and migrating them to

a new environment after the spin-off of Skyworks from Conexant. It also

involved enhancing and modifying the system as per Skyworks business needs.

Roles & Responsibilities

. Maintaining the current system and production support for the planning

team, the end-users of the system

. This included resolving data integrity issues while dealing with

millions of rows of data.

. Enhancing the current system as per end-user request.

. Troubleshooting and fixing existing bugs in the system.

. Analyzing and formulating the migration methodology for Xcalibur and

OEE applications

. Inter-group co-ordination for carrying out the migration activity

through various business partners

. Modification Coding and Testing of system during and after migration.

. Serve as on-site co-ordinator for the offshore teamduring system

migration

. Carried out coding activities in Oracle SQL, PL SQL for the Xcalibur

system to migrate from Tru 64 UNIX to HP-UX 11i Operating System.

. Modifying applications for a distributed structure with Databases

hosted on a separate server than the application.

. Unifying and fusing parts of the system to put all application

modules, other than the database, on a single server.

. Restructuring the application for better maintainability (Value

addition task).

. Setup of Environment for Xcalibur and OEE applications on the new HP-

UX server.

. Modification and testing PL/SQL and Shell Scripts for change in

application structure.

. Modifying and developing forms and reports in Oracle Developer 6i for

OEE application.

. Modification in the layout of the application for better

maintainability. The task included logical organization of files and

folders of the application on the new server.

. Implement and test the modified applications at client site.

Environment - Oracle 8i, HP-UX Posix-Shell Scripting, SQL Server 7.0, SQL,

PL SQL, Digital Unix (Compaq Tru 64) and HP-UX, Oracle Developer 2k Forms

and Reports

Tools - TOAD, Microsoft VSS, UNIX RCS, Humming Bird Exceed.

Nov 2001- May 2003

Employer - HCL Technologies (India) Pvt. Ltd.

Client - Conexant System Inc

Newport Beach, CA USA

Project: Oracle based projects - Xcalibur OEE DMS

Role: Trainee/Oracle Developer

The Supply Chain Management system of Conexant (Leading semi-conductor chip

manufacturer) use a number of Client-Server applications Oracle as the

backend. They follow the same underlying methodology. The inputs come in

form of text files, user entered data using Oracle developer forms and

excel sheets. Upon load the data is processed using a set business rules

are coded in PL/SQL. The output is a series of reports in HTML, Oracle

Developer Reports and Graphics and text reports used by third party

reporting tools.

The project involved maintaining and enhancing multiple systems as per user

requirements.

Roles & Responsibilities

. Analyze maintenance request and check feasibility

. Code and test modifications/enhancements as requested in the MREQ

. Upgrade database from Oracle 7.x to Oracle 8i

. Create reports and forms for new and modified modules added to the

system

. Production support. Monitor applications for regular correct behavior.

. Report and resolve severity 1 irregularities and bugs in applications

within SLA.

. Data modeling and acquisition methodology development for new modules

of the application.

. Develop code in Sherpa DMS using C and C++ for managing workflow based

Production Data management system.

Environment - Oracle 7x, 8i, HP-UX Posix-Shell Scripting, K Shell

Scripting, SQL Server 7.0, SQL, PL SQL, Digital Unix (Compaq Tru 64) and HP-

UX, SUN Solaris, Oracle Developer 2k Forms and Reports, Sherpa DMS

proprietary methods, Borland C, C++, gnu open source compilers and

debugging tools.

Tools - TOAD, Microsoft VSS, UNIX RCS, Humming Bird Exceed, Sherpa DMS,

Borland IDE

Contact this candidate