SUMMARY

• Confidential, a Solution Architect has about 19 years of IT experience and about 7.5 years of Demantra(Demand Management/S&OP/Settlement Management/PTP) and supply - chain planning experience of the whole software lifecycle and Upgrade projects.
• Area of strength covers Production Support, Build, QA/QC and Release Engineering. Has extensive experience in Relational Database development using Oracle, SQL Server, Sybase and Access also database administration in Oracle.

TECHNICAL SKILLS

Hardware: Pentium Server/VGA terminals, Sun SPARC Server/WIPRO terminals, ICIM DRS/6000 Server/ICIM terminals, Solaris

Languages: Java - 1 year, C - 1½ years, PL/SQL - 11 years, Transact SQL - 3 years, JHTML and HTML - 1 year

Operating Systems: SCO Open Server 5.0, UNIX (Sun, HP), Windows XP/2000/98/95/NT/7, Solaris, Linux

RDBMS &Tools: ORACLE 11g/10g/9i/8i/8.0/7.3 - 17 years, SQL*PLUS - 17 years, SQL Navigator - 7 years, Benthic - 2 year, SYBASE System 10.0 - 1½ years, Access 2000/97 - 6 months, APT Workbench - 1½ years, Data Workbench - 1½ years, DB-Library with Host C - 1½ years, SQL Server 2000 and 2005 – 2 years

CASE Tool: Designer/2000 Release 2.1 – 3½ years

GUI: Developer /2000 (Forms 6i/5.0/4.5, Reports 6i/3.0/2.5) – 10 years, Crystal Reports 8.5/10 – 2.5 years, Crystal Enterprise 10 – 1 year, Dreamweaver/Front Page - 3 yrs, Flash – 1yr, Photoshop – 2yrs

Application Server: Dynamo 4.5.1 – 1½ years

Application: Oracle Demantra 6.2.6/7.0.2/7.1.0/7.1.1/7.3.1. X – about 7.5yrs, Personality 2000 – 4 yrs

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Working on Demand Management and Real-time S&OP full implementation in Oracle Demantra 7.3.1.4 on Oracle 11g, Linux and Weblogic.
• An integrated solution with JDE is being designed and developed for wood industry.

Confidential

Responsibilities:

• Working on enhancements, trouble shooting issues in Oracle Demantra 7.3.0.2 implementation on Oracle 10g, Linux and Weblogic.

Functional and Technical Lead

Confidential

Responsibilities:

• Working on enhancements in an already implemented Demantra application.
• The enhancements cover review some areas and make changes as required.
• It’s an Oracle Demantra 7.3.0 implementation on Oracle 11g, Linux and Oracle Application Server.

Confidential

Responsibilities:

• Implemented Demand Management for a world-wide Communication organization.
• Responsibilities include requirements gathering, business process and functional design, configurations, developing integration specifications, helping the technical team in designing the interfaces, conducting Conference Room Pilot, Acceptance testing and troubleshooting.
• It’s an Oracle Demantra 7.3.1 implementation on Oracle 11g, Linux and Oracle Application Server.

Confidential

Responsibilities:

• Implemented Demand Management and Sales & Operations modules.
• Responsibilities include requirements gathering, business process and functional design, developing integration specifications, leading the technical team in designing the interfaces, data modeling, conducting Conference Room Pilot, Acceptance testing and troubleshooting.
• Lead the team Functionally and Technically to achieve successful Go live.
• This was an Oracle Demantra 7.2 Implementation on Oracle 10g using Linux, Oracle Application Server and Demantra was upgraded to 7.3 later.

Confidential

Responsibilities:

• Worked on upgrading the system to Demantra 7.2.0.2.
• Lead the upgrade project and addressed/resolved all issues during upgrade.

Confidential

Responsibilities:

• Was responsible in performance tuning.
• This was Oracle Demantra 7.2 Implementation on Oracle 10g and Unix.

Confidential

Responsibilities:

• Designed and implemented a unique solution for Category Management for a leading Film Studio.
• Responsibilities include requirements gathering, business process and technical design, developing integration specifications, data modeling, development, end user and user acceptance testing.
• Performance Tuning was the most critical area in this project and was handled successfully to meet the Client’s expectation.
• This was Oracle Demantra 7.1.1 Implementation on Oracle 10g.

Confidential

Responsibilities:

• Responsible for production support, troubleshooting, enhancement of Demantra DM/and PTP solution, analysis, design and development based on the requirements gathered from business users.
• Oracle Demantra 6.2.6 Implementation on Unix.

Technical lead

Confidential

Responsibilities:

• Responsible for application installation, database creation and maintenance, integration design, model configuration, performance tuning (application level and DB level) and workflow setup.
• Developed SQL procedures to implement custom client calculations. Configured forecast accuracy measurements within the application. Provided post production support.
• This was Demantra 7.1 Implementation on SQL Server 2005.

Confidential,

Responsibilities:

• Payroll/HR system- was responsible in database (Oracle8i/9i), report (Report6i) development and support in City of Pasadena.
• Personality2000 is the application, which covers different areas like Payroll, HR, Benefits, Budget and Transportation.
• Working as the only consultant to support all these applications to provide with high level of customer satisfaction.
• Is involved with new report development as well as enhancement using Report6i.
• Performance tuning is performed in different areas using Explain plan.
• Used SQL Navigator4.0, SQL*PLUS as a tool to write procedures, functions, triggers using PL/SQL. Also, is involved in giving to the other developers as well as solving their problems.

Confidential

Responsibilities:

• Production Support - Was responsible to solve the site issues, which are reported by SBC customers and users. The site issues are mostly related with Oracle 8i, Java, JHTML. Besides solving site issues, takes care of problems associated with code-release, is responsible in bug fixing with SBC’s Order Entry Tool and Build Tool( Developer 2000 Forms5.0, Reports3.0) - used by Customer Service and Order Entry department.
• Was also responsible in development of new Web-based applications. SBCDO has one of the best YellowPages in the world. It has some unique features. The system is based on Dynamo Application Server. The scope of work covers maintenance and development by back-end programming in Oracle8i database and Java 1.2.2, PL/SQL languages. Was also responsible for database maintenance and administration. Was responsible for handling the site issues, which are reported by different customers.
• Release Engineering - Was responsible to develop a Build Release application using Java and JHTML with version control using Star Team 4.0.
• Headings - Was responsible in analysis, design and development of Universal Heading Code mapping. Headings, received from different sources, consolidate into SBCI virtual headings. The Advertisers can buy a listing in any region in any Heading. So, when a type search is performed in a particular directory or city or zip code, the Advertisers (along with the free listings) will show up. The purpose of this mapping is to increase the number of Advertisers, which will result in more revenue. Used Oracle8i and PL/SQL.
• WhitePages - Was involved in WhitePages development. One of the main responsibilities was to manage more than 90 million transactional data. The work-area covered database development and maintenance. Was responsible for performance tuning, which was directly related to SBC’s site performance. A powerful feature of Dynamo - Relational View Manager was used to interact between the Java Classes and the Oracle database.
• YellowPages - Was responsible to include the Geocoding of addresses to get the exact location in the map for Driving Directions. Worked in the integration of Telco Data with different data sources like Ameritech and South Western Bell. Implemented business rules for “hour text” for different customers and Merchant Id generation. Also used shell scripts to run the batch jobs.
• Personalization - Was responsible to implement Personalization Server with the current functionalities to increase site traffic. The module included User Registration, Address Book, and Notepad Maintenance. For this project Dynamo Personalization Server 4.5.1 along with Oracle 8i were used.
• QA/QC – Was responsible to test and finalize different projects.

Confidential

Responsibilities:

• Working as a Database administrator and system developer on a Catalyst Testing application.
• The client is in need to uniform and standardize the data input procedures, which can keep track of the same readings in a uniform way.
• Is responsible to study, design the database and user interface along with graphs using Access 97.
• Simultaneously involved in developing a Timesheet Management system, using Java Servlet programs with Oracle database. Used Crystal reports for reporting.

Confidential

Responsibilities:

• Worked as a Database Administrator on a project named Recruiters Exchange (REX). Contract Programmers’ Exchange deals with the requirements raised by the buyers. REX maintains a Dynamic Database created by generic process.
• Using Designer/2000 release 2.1 the Database was transformed in Oracle 8.0 from ERD and DFD. Had a leading role in creating and maintaining the full database, managing the users. Was responsible to maintain regular back-up also.

Confidential

Responsibilities:

• Worked as a System Developer on Raffles Business System.
• Was engaged in developing current functionality, related with security trading.
• Was responsible to provide some changes in already developed system in Oracle 8.0 with Developer 2000 Release 2 as front-end.

Confidential

Responsibilities:

• Worked as a system developer on Student Information Management System.
• Used Developer/2000 Forms 4.5, PL/SQL for developing the reports and Library extract files.
• The Creation of Grade Roaster had a challenging feature of “Bubble Allocation”, implemented with the help of PL/SQL.

Sigma Consultants,

Confidential

Responsibilities:

• Worked as a Business/System Analyst, DBA and developer.
• This system was responsible to take care of the key areas like sales, order, promotions and market research information across different branches and regions to corporate office.
• I was responsible to analyze users’ specification and design/integrate the system to serve the purposes efficiently.
• Was responsible for developing DFD with Designer/2000, loading data using SQL* Loader, creating Stored Procedures, Triggers, Functions using PL/SQL. And was also responsible to create user interfaces for maintenance of data using Developer/2000.
• High level of performance tuning needed to be done because of high Volume of data.

Shares Accounting System (SAS):

• Involved in implementing this SAS package so that the company would be able to generate all the various types of transactions affecting the share holders' balance, location, tax status, protection, share movements, distribution etc. and update the share holders' information.
• The system generated decision support reports needed during executive meetings.

Confidential

Responsibilities:

• Worked as System Developer on Sales and Finished Goods Consolidation System using APT Workbench and Data Workbench, SYBASE System 10.0, bcp utility, DB-library with C host C was used.

Confidential

Responsibilities:

• Worked as a system developer on project named Production Planning and Control System.
• The company was in real need of Standard Planning and Control of their Production Procedures, so that they could get the optimum control on their product quality and dispatch values as per ISO 9001.
• In the system the modules from R&D to Dispatch were incorporated.
• On the server side, various stored procedures and database triggers were written in Sybase System 10.0.