SUMMARY

• Experience covering requirement analysis, design, development, enhancement, implementation, documentation, and maintenance of businessapplications, testing, training, technical abstracting, Agile and Kanban software development Methodology.
• 15 years of experience in Oracle technology, 11g, 10g, 9i/8i/8.0/7.X/6.X,9i AS, Forms 11g, Reports 11g, Weblogic Server,11g (10.3.2), Forms 10g, Reports 10g, FORMS 9i/6i/4.5/3.0, REPORTS 9i/6i/2.5/1.1, PL/SQL, SQL*PLUS, Discoverer 2000, Designer 2000, PL/SQL Cat ridges, SQL*LOADER, PRO*C, Stored Packages, Procedures, Functions, Database triggers, Tables, Views, Indexes, Sequences, Snapshots, Database links, Synonyms, Grants, SQL*DBA, BACKUP/RECOVERY, IMPORT/EXPORT, Oracle administration and Performance tuning using Indexing, clustering, explain plan etc.
• 6 years experience in UNIX, C, Shell scripting.
• 6 years experience in Data warehousing tools like Business Objects, Brio, and Discoverer etc.
• 2 years’ experience in Web technologies like ASP, Java, C++ etc.
• Experienced in the installation, configuration and application of various Oracle Technologies such as Client Server, Intranet - based environments and in the use of a plethora of Oracle Products.
• Experienced in undertaking Oracle DBA functions from the application side.
• Experienced covering shipping, manufacturing, financials, telecom, health care, HRMS, payroll system, fixed assets, hotel management, fixed deposits, IT education and business information sectors.
• Worked as software consultant for some of major companies like ORACLE CORPORATION, MOL, IBM, LUCENT, Confidential, AETNA & Confidential for around 13 years and gained fairy good knowledge on business process in manufacturing & financials modules.
• Documented system support guides and reviewed the coding done by team member and suggested changes.
• Experience of working in cross-cultural environment.
• Strong skills in Gap/Fit Analysis, Business analysis, Business Process Re-engineering, Structured Systems Analysis and Design, Relational, Dimensional Data Modeling and Database Design, evaluating H/W and S/W, Software testing and Quality Assurance, Software implementation, End user training and providing production support. Good understanding and appreciation of user requirements.
• 1 year of experience in Oracle Apps (Manufacturing, HRMS, Financials 11.5.9/11.5.4 (modules Fixed Assets, Order Management)) and complete project life cycle. Systems Integration, Interfaces and Conversions between Oracle Financials and legacy systems, Customizations of Oracle Financials modules and Development of Custom Oracle Financials modules. Production Support and Performance tuning.

TECHNICAL SKILLS

Operating Systems: 64 bit Windows server 2008, 32 bit windows server 2003, WINDOWS 95/98/NT/2000, MS-DOS, Sco Unix, Digital Unix, SMOS-8.27 (Modified Version of AT&T UNIX), HP-UX.

Languages: PASCAL, FORTRAN, ASSEMBLY LANGUAGE, 8086, C++, C, PRO*C, PL/SQL, Perl, Python, Cobol

DBMS: Ms-Access, DBASE III+, FOXPRO

RDBMS: Oracle 10g,ORACLE 6.X, Oracle 7.X, Oracle 8i & Oracle 9i, SQL SERVER 2000, Sybase Sql 5.0

NDBMS: Through Pascal

Web Technologies: HTML, DHTML, XML, XSL, XSLT, CSS, JavaScript, Java Applets

GUI: forms 10g, reports 10g, Developer/2000 kit Forms 9i/6i/4.5/3 & Reports 9i/6i/2.5/1.5, Graphics2.5, Discoverer 3i, Discover 2000, Java 1.2, Active Server Pages, XML/XSL/XPATH, VbScript, JavaScript, HTML, Visual Basic 6.0, Crystal Reports, Designer 2000, CA Erwin 8, DB Maestro, Pitts tool for Oracle migration.

WEB TOOLS: Java, PLSQL Cartridges, Oracle9i Application Server, Internet Information Server (IIS 7) and Apache Web Server.

DATA WAREHOUSING TOOLS: Business Objects (5.1), BRIO (extracting & reporting tool), PL SQL Cartridges.

OTHER UTILITIES: PL/SQL Developer, TOAD, VISIO, MS Project, Terminal Service, PC anywhere, Shell scripting, MS Office 2000, Erwin 4.5

ERP Modules: Oracle Manufacturing, Financials, Release 11i (11.5.9 & 11.5.4) Purchasing(PO), General ledger (GL), Accounts payables (AP), Accounts receivables (AR), Purchasing(PO), Fixed assets (FA), Cash management (CE), Order management (ONT), Inventory (INV), Application Object Library (AOL), Alert (ALR), System administration (SYSADMIN).

PROFESSIONAL EXPERIENCE

Confidential, New York City

Sr. Oracle Developer

Responsibilities

• Involved in the Designing specs for new requirements based on existing database structure.
• Involved in the Unit testing, Integration & User Testing.
• Involved in various phases of software development life cycle, Requirement gathering from managers, Analyzing, design new database structure, development and testing.
• Involved in Application Deployment to production.
• Involved in Agile Software Development Group.
• Involved in Kanban Software development Team.

Environment Oracle 11g, SQL, PL/SQL, DB Maestro, TOAD 9.7, PL/SQL Developer, Microsoft Visual Studio 2008, Erwin 8

Confidential, NEW JERSEY

Programmer / Analyst

Responsibilities

• Involved in generating reports, form based pages using PL/SQL packages in oracle 11g and classic ASP.
• Involved in the Designing specs for new requirements based on existing database structure.
• Involved in the Unit testing, Integration & User Testing.
• Involved in various phases of software development life cycle, Requirement gathering from managers, Analyzing, design new database structure, development and testing.

Environment Oracle 11g, SQL, PL/SQL, ASP, Microsoft Visual Studio 2008, TOADDec’ 2011 to Jan’2012.

Confidential, NEW JERSEY

Programmer / Analyst

Responsibilities

• Involved in upgrading oracle forms 10g to 11g, reports 10g to 11g.
• Involved in migrating applications from 32 bit windows server 2003 to 64 bit windows server 2008.
• Involved in developing web pages in ASP.
• Involved in configuration of IIS 7 server.
• Involved in configuration of weblogic server 10.3.2
• Involved in installation of oracle 11g database, forms 11g, reports 11g, forms and reports server, IIS 7 and weblogic server.

Environment Oracle 11g, Oracle 10g, forms 11g, reports 11g, forms 10g, reports 10g, SQL, PL/SQL, Weblogic Server 10.3.2, ASP, java 1.6.0.24, Visual Basic, 64 bit Windows 2008 Server, 32bit Windows 2003 server, Microsoft Visual Studio 2008 & 2005, TOAD, PL/SQL Developer, PVCS Version manager 6.5.

Confidential

Programmer / Analyst

Responsibilities

• Involved in Application development and maintenance services at the client's site depending upon the type of assignment.
• Involved in the design, development, and implementation in Oracle 10g Forms/Reports applications.
• Involved in migration of application Forms6i / Reports6i to Oracle forms 10g / Reports 10g using PITSS conversion tool.
• Involved in oracle 10g to oracle 11g migration.
• Designed and coded multi-block forms usingOracle Forms 10g/6i.
• Fine-tuned SQL to optimize performance.
• Created PLL libraries, object groups, form triggers, template forms and reports.
• Ensured High availability of application by suggesting alternate solutions.
• Prevented program changes for new requirements by suggesting alternate setups.
• Documented system support guides.
• Reviewed the coding done by team member and suggested changes.
• Performed various testing of the new programs to ensure meeting business requirement.
• Prepared Test plans covering a range of Test cases, and performed unit & integration testing.

Environment Oracle 11g migration, Oracle 10g, forms 10g, reports 10g, Oracle 9i/8i, SQL, PL/SQL, Pro*C, PLSQL Cartridges, SQL Loader, Forms 9i/6i, Reports 9i/6i, Oracle Forms Server, Oracle Reports Server, Oracle9ias Server.

Confidential, CHICAGO

Systems Engineer Consultant

Responsibilities

• Involved in Software Development and Application Support services at the client's site depending upon the type of assignment.
• Involved in the design, development, and implementation in Oracle Forms/Reports applications.
• Modified Pro*C programs for new enhancements.
• Designed and coded multi-block forms usingOracle Forms 9i/6i.
• Fine-tuned SQL to optimize performance.
• Created PLL libraries, object groups, form triggers, template forms and reports.
• Ensured High availability of application by suggesting alternate solutions.
• Prevented program changes for new requirements by suggesting alternate setups.
• Documented system support guides.
• Reviewed the coding done by team member and suggested changes.
• Performed various testing of the new programs to ensure meeting business requirement.
• Prepared Test plans covering a range of Test cases, and performed unit & integration testing.

Environment Oracle 9i/8i, SQL, PL/SQL, Pro*C, SQL Loader,Forms 9i/6i, Reports 9i/6i, Oracle Forms Server, Oracle Reports Server, Oracle9ias Server.

Confidential

Software Consultant

Responsibilities:

• Involved in the maintenance of SuperD application which includes changes in database objects like packages, stored procedures, stored functions, database triggers, and maintenance of SuperG which includes changes in forms and reports using developer 2000, Generating statistical reports using XML programming for User & business level management and developing various processes using VB Script & C programming language.
• Modified Pro*C programs for new enhancements.
• Fine-tuned programs to optimize performance.
• Ensured High availability of application by suggesting alternate solutions.
• Prevented program changes for new requirements by suggesting alternate setups.
• Reviewed the coding done by team member and suggested changes.
• Performed various testing of the new programs to ensure meeting business requirement.
• Prepared Test plans covering a range of Test cases, and performed unit & integration testing.
• Involved in the development & maintenance of Document Library application which includes developing new ASP programs, changing existing programs, generating output in various formats like HTML, Excel, XML etc, Generating statistical reports for User & business level management.
• Generating Various output information in XML file which is later used by different systems.
• Generating Excel Pivot Tables, Charts using Excel Macro programming.
• SQL Server features like DTS, Cubes were used to improve the performance and presentation and make the application more user friendly.
• Third party components like ASP Grid, ASP Tree View, ASP Upload were used to have more user friendly.

Environment: Oracle 10g, 9i/8i, SQL, PL/SQL, Pro*C, SQL Loader, Unix shell scripts, Forms 9i/6i, Reports 9i/6i, Oracle Forms Server, Oracle Reports Server, Oracle9ias Server, J-Initiator 1.1.8.16, Unix, IE 5.5, Extranet access client, XML/XSL/XPATH, VB Script, SQL Server 2000, ASP, Ms Excel Macros, OLAP Cubes.

Confidential

Senior Systems Engineer (Techno Functional Consultant)

Responsibilities

• Involved in the development of BEACONLITE phase 1 application which includes creating packages, stored procedures, stored functions, database triggers, and development of forms and reports using developer 2000, discoverer and programming in shell scripts, ‘C’ language User & business level reports using Business Objects & BRIO tool, and developing various processes using oracle database objects.
• Involved in the Designing specs for new requirements based on Existing database structure.
• Involved in the Unit, Integration & User Testing along with Implementation at various sites.
• Set up the development server for Beacon Manufacturing System (CPMO), China.
• Modified Pro*C programs for new enhancements.
• Developed various reports in Oracle to aid production unit tracking for production engineers.
• Fine-tuned programs to optimize performance.
• Provided on-site and off-site support for Beaconlite Phase 1& 2, Beacon and Dex applications globally.
• Involved actively in full life cycle of he project which includes screen design, table design, preparation of user manual, preparation of test plans.
• development of the program using Developer 2000, Designer 6i & Discoverer.
• Developed conversion programs in PL/SQL to import Legacy Systems invoice data into AR module using AR invoice import open interface.
• Controlling user access to the database
• Reviewed and modified scripts for the overnight synchronization of an external Oracle Discover database with tables from the AR, GL, PO, and HR modules, using Unix shell, PL/SQL, SQL*Loader and Toad.
• Design and development of Reports in AP, AR and modification of Standard Oracle application reports.
• Developed and customized interface programs for the Assets module.
• Design and development of Reports in AP, AR and modification of Standard Oracle application reports.
• Participated in implementation of all programs at the client’s site

Environment: Oracle FINANCIALS 11.5.9/5.4 (Modules: GL, AP, AR, PO, OM, FA, BOM, MRP, INV, ALERT, SYS ADMIN), Designer 2000, Discoverer 2000, Oracle 9i/8i/7.3.4, SQL, PL/SQL, Pro*C, SQL Loader, Unix shell scripts, Forms 9i/6i/4.5, Reports 9i/6i/2.5, Graphics2.5, Oracle Forms Server, Oracle Reports Server, Oracle8ias Server, J-Initiator 1.1.8.16, PL/SQL cartridges, Business Objects, BRIO tool, Windows 2000, TOAD, Erwin 4.5, Maestro Scheduler, Unix-HP UX B.11.00, IE 5.5, Extranet access client.