SUMMARY

• Over 14 years of experience in designing/developing application software primarily in Oracle with Oracle tools, utilities and database functionality in Windows Server 2008/2003/2000/NT and UNIX (Solaris, HP-UX, AIX, Linux) platforms. Over 12 years of working experience in North America.
• Experience in System Analysis and Design, Database & Application architecture, Data modeling, Programming (Development and Customization), Testing and Integration, Quality Assurance, Implementation, Production and Technical Support, and Documentation of user interface, program units and database applications using Oracle 11g/10g/9i/8.x/7.x and PL/SQL.
• Proficient in analysis of user requirements and transforming them into comprehensive design and functional specifications.
• Extensive experience in design and development of user interface using Oracle Fusion Middleware 11g / Oracle Developer Suite 10g (Oracle Forms and Reports versions 11g/10g/9i/6i/5/4.5) and reporting tools like Oracle BI Publisher, BI/Crystal Reports, SQR etc
• Competent in design and development of Oracle database objects, including Packages, Procedures, Functions, Triggers etc
• Technical/Functional understanding and working experience with Oracle E-Business Suite R12/Oracle Applications R11i with particular emphasis on core modules such as Supply Chain Management, Manufacturing and Distribution, Financial, Workflow etc. Highly experienced in developing & personalizing Oracle Forms, Reports and Libraries in Oracle Applications.
• Technical/Functional understanding and development experience with Oracle Retail Product suite and Oracle Health Sciences Application Suite (Oracle Clinical) which includes design, development and deployment at client locations.
• Proficient in Data Modeling (Logical & Physical Design of Databases) using CASE/Oracle Designer, IDE/Oracle JDeveloper, ERwin, Visio etc
• Highly proficient in Query Optimization and Performance Tuning (using tools such as Explain Plan, SQL Trace/TKProF, DBMS_Profiler, AutoTrace, Indexing, Hints etc), Troubleshooting etc.
• Well versed with Oracle’s advanced features such as Oracle Streams Advanced Queuing, Oracle Scheduler, Collection data types, Object Management, Oracle BI Publisher etc
• Experienced in data migration from/to Oracle database using tools such as SQL* Loader, Data import and export (IMP/EXP) utilities, Oracle Data Pump (expdp/impdp) etc
• Good working knowledge in all aspects of Oracle database administration such as installation, design, creation, development, enhancements and maintenance of Oracle database servers. Worked on Database Logical/Physical Design, Hot/Cold Backups, Export/Import, Tablespace Creation and Modification, Creation/Modification of various tables, indexes and other database objects, Users/Security Administration, Performance Tuning etc.
• Strong skills in Server-side scripting including Unix Shell Scripting, Perl scripting etc.
• Good working knowledge of Internet technologies including Java, Java EE technologies, JSP, ASP.NET, PHP, XML/XSL, HTML/XHTML, CSS, JavaScript etc.
• Broad knowledge of Data Warehousing and architecture design of ETL environments using Oracle Warehouse Builder 11g, Informatica PowerCenter etc
• Extensive experience in developing scalable enterprise applications for different sectors like Retail, Inventory, Energy, Academic research, Health care solutions, Telecommunication billing, ERP solutions, Multi-national banking etc, all of these implemented full fledged Oracle based data management and online transaction / batch processing systems. Also worked on Onsite-Offshore model.

SOFTWARE PROFICIENCY

• Languages:
• PL/SQL, SQL, Java, C/C++, Pro*C/C++, Perl, Unix Shell scripts (sh, csh), AWK, XML/XSL, HTML, Transact-SQL, Delphi, Pascal, Ada etc
• Databases:
• Oracle 11g/10g/9i/8.x/7.x, Microsoft SQL Server 2005, IBM Informix, MySQL etc
• Development Tools:
• Oracle Fusion Middleware 11g (Oracle Forms 11g/Oracle Reports 11g/ Oracle JDeveloper 11g/Oracle BI Discoverer 11g), Oracle Developer Suite 10g (Oracle Forms 10g/Oracle Reports 10g/Oracle Designer 10g/Oracle JDeveloper 10g/Oracle BI Discoverer 10g), Oracle9i Developer Suite (Oracle9i Forms Developer/Oracle9i Reports Developer/Oracle9i Designer/Oracle9i JDeveloper/Oracle9i Discoverer Administrator), BI/Business Objects 11.x, Crystal Reports 12/11, Power Builder 7.0, Visual Basic 6.0 etc
• Oracle Tools/Utilities/Applications:
• Oracle E-Business Suite R12/Oracle Applications R11i, Oracle Enterprise Manager, Oracle Warehouse Builder, Oracle BI Publisher, Oracle APEX, Oracle Streams AQ, Data import and export (IMP/EXP) utilities, Oracle Data Pump (expdp and impdp), SQL*Loader, Oracle XML Developer Kit (XDK), Oracle Developer Tools for Visual Studio (ODT), Oracle TopLink, Tuxedo, Oracle Essbase, Oracle Data Integrator (ODI), Oracle Data Miner, Oracle SOA Suite, Oracle\'s Primavera Project Portfolio Management (PPM), PeopleSoft PPM, PeopleSoft HRMS/CRM etc
• Operating Systems:
• Windows Server 2008/Windows Server 2003/Windows 2000/Windows NT 4.0, UNIX (IBM AIX V6, HP-UX 11i, SUN Solaris 10), Oracle Enterprise Linux 5, Red Hat Enterprise Linux AS/ES/WS/Desktop, Novell NetWare 6.5, MS-DOS 7.x
• Hardware:
• IBM BladeCenter/IBM Power Systems, IBM System p/IBM System I, IBM RS/6000, HP Integrity Servers, HP 9000 Series, Sun SPARC Enterprise/Sun Blade/Sun x86-based Servers, Sun Fire/Sun Enterprise etc
• Database Tools & IDE’s:
• Quest Software’s TOAD & SQL Navigator, PL/SQL Developer, Oracle SQL Developer, Eclipse, NetBeans IDE, POSIX (UNIX), Microsoft Visual Studio, IntelliJ IDEA, IBM VisualAge, IBM Rational Rose XDE etc
• Internet Technologies:
• Java EE technologies (JDBC, RMI, JMS, Web service, XML, EJB, JCA, JSP, Servlets, Portlets, JSF, Spring, Hibernate, Apache Struts, Swing etc), JavaScript, Oracle WebLogic Server/IBM WebSphere, Apache, PHP, ASP.NET, .NET Framework, CORBA, Ajax etc
• Applications:
• Distributed Concurrent Versions System (DCVS)/CVS, Perforce, Bazaar, Apache Subversion (SVN), Microsoft Visual SourceSafe (VSS), Borland StarTeam, SVK, Rational Synergy, PVCS, Remedy Action Request System (ARS), Request Tracker (RT), Rational ClearCase/ClearQuest, Peregrine, Primavera, Microsoft Office Visio, Bugzilla, Microsoft Project, IBM Lotus Notes, Microsoft Outlook, Microsoft Office etc
• Others:
• ETL Tools (Oracle Warehouse Builder 10g, Informatica PowerCenter), IBM Tivoli Workload Scheduler (maestro scheduler), Cron job scheduler, CMMI, SOA, HP Quality Center (QC) etc

• Confidential, Since MAY 2008

as Systems Analyst

Projects undertaken:

(*) Project Titles : Oracle Retail Merchandising System, Rel. 13.x Customization

Scope and Features:

• Oracle Retail Merchandising System (RMS) is the market leading integrated merchandising solution for retailers of all sizes. This solution enables retailers to better manage, control and perform crucial day-to-day merchandising activities with ease.
• From supply chain, operations, merchandising, store systems, optimization and information technology solutions, Oracle Retail is the single source for innovative and comprehensive industry solutions - enabling organizations to serve their customers better by applying insight into daily business decisions for more profitable results.
• Abercrombie & Fitch is implementing and customizing RMS to support its corporate expansion plans both domestic and International.

Responsibilities:

• Involved in collection and rationalization of user requirements, functional gap analysis, preparing solutions designs, specs to build teams, leading development activities, conducting end-user training, leading integrated testing and deployment and post-deployment support
• Involved in the product extensions/custom development comprising design, extensive development and testing of the extensions to the Oracle Retail Merchandising product based on customer requirements
• Primarily focused on application design, custom development and maintenance of Oracle Retail application.
• Also involved in technical/functional design, development, techno-functional troubleshooting and Unit testing of conversion and data migration from legacy systems to Oracle Retail.
• Involved in interfacing of Oracle Retail modules with other third party logistics systems
• Provided technical support to data management and worked as a technical resource for the administration of oracle databases and related applications.
• Designed and developed database objects including PL/SQL Packages, Procedures, Functions, Triggers, Forms and Reports to extend Oracle Retail functionality based on user requirements
• Performed application tuning, tuned SQL Scripts using Optimizer Hints, Explain Plan, SQL Trace & TKPROF and Packages / Stored Procedures using DBMS_Profiler.
• Developed and implemented RMS batch processing

Project environment : AIX 6.1, Solaris 10, and HP-UX 11i v3, Oracle E-Business Suite R12/Oracle Applications R11i, Oracle 11g with Oracle Fusion Middleware 11g (Oracle Forms 11g/Oracle Reports 11g /Oracle JDeveloper 11g/Oracle BI Discoverer 11g, SOA etc), Java/WebLogic, Oracle APEX 4.0, Crystal Reports 12, 10gR2 Designer, Oracle Enterprise Manager 11g, PL/SQL 11, SQL* Plus 10.1, TOAD/ SQL Developer, UNIX Shell/PERL Scripting, SQL*Loader, Oracle Warehouse Builder 11g etc

Client: Confidential,OH
Project Period : Since May 2008

• Confidential,Auburn Hills, MI SEPT 2007 - FEB 2008

as Systems/Programmer Analyst

Projects undertaken:

(*) Project Titles : Oracle Applications 12i/11i, Supply Chain Management Applications (Inventory (INV), Order Management (OM), Purchasing (PO)), Manufacturing Applications (Bill of Materials (BOM), Work in Progress (WIP), Cost Management (CST)), Financial Applications (General Ledger (GL), Payables (AP)/Receivables (AR), Projects (PA)), Workflow, Multi-Org etc

Scope and Features:

• RGIS provides accurate, reliable and efficient inventory, merchandising and staffing solutions worldwide and is the largest and most respected inventory and retail Services Company in the world.
• RGIS systems accurately capture the quantity of every item number in the store, reducing out-of-stocks and increasing sales. RGIS helps avoiding inventory errors that create a hidden liability issues.
• RGIS Inventory services helps avoid order reductions, reduce bundling or removal of hard to count merchandise and eliminate closing off sections of the store or moving goods in preparation for inventory. This improvement in product availability can lead to increases sales.

Responsibilities:

• Involved in the product extensions/custom development comprising design, development and testing of the extensions to the Oracle Applications product based on customer requirements
• Very familiar with Oracle’s application database structure for the core modules such as Distribution and Manufacturing (Inventory, Order Management, Shipping, Purchasing etc) and the open interface tables and inbound interfaces (APIs) relating to these modules.
• Developed PL/SQL Packages, Request sets, Forms, Menus and Reports to extend Oracle applications functionality based on user requirements and registered them as concurrent programs
• Experience with Oracle’s proprietary Application Object Library (AOL/FND) and Custom Libraries in conjunction with Oracle version 11i applications. Understand and know how to apply workflow.
• Performed setup steps, for defining key flex fields and descriptive flex fields. Created various lookups and value sets. Sound knowledge of flex fields, value sets, concurrent processing, workflow, set-up and profile options.
• Used cross-validation and value set features while implementing descriptive flexfields extensively to capture additional information in standard as well as customized forms.
• Performed requirements gathering, functional gap analysis, Oracle application configuration and modules setup, writing documentation, training end users, and production support.
• Prepared technical design documents for customizations and conversions using Oracle AIM documentation methodology.
• Also involved in technical/functional design, development, techno-functional troubleshooting and Unit testing of conversion and data migration from legacy systems to Oracle 11i.
• Provided technical support to data management and worked as a technical resource for the administration of oracle databases and related applications.
• Performed unit testing, code review, and system integration testing;

Project environment : Sun SPARC Enterprise M8000/T5220, Sun 4800/3960, Solaris 2.9/10, Oracle 11.5.9/Oracle 12i, Oracle Developer Suite 10g (Oracle Forms 10g/Oracle Reports 10g /Oracle JDeveloper 10g/Oracle BI Discoverer 10g), Java/WebLogic, Crystal Reports 9, 10g/9i Designer, Enterprise Manager 10g/9i, PL/SQL 9.2, SQL* Plus 9.2, TOAD, UNIX Shell Scripting, PERL Scripting, SQL*Loader, Oracle Warehouse Builder etc
Project Period : Sept 2007 – Feb 2008

• Confidential, MAY 2006 - SEPT 2007

as Principal Analyst

Projects undertaken:

(*) Project Titles : Willow (Fleet Management Software)

Scope and Features :

• Bynx is the world\'s leading supplier of innovative fleet and leasing technology supported business solutions. Willow is aimed at medium to large fleets, providing a back-office vehicle and lease management support tool.
• The system is modular and is provided as a packaged full service leasing and fleet management application or as individual modules assembled to match specific fleet/lease management needs.
• Fleets are able to control the whole life cycle of a vehicle from quote to order, through purchasing, direct and indirect in-life cost and contact management to end-of-contract used vehicle decommissioning, cost recoveries and sale.

Responsibilities:

• Responsible for requirement gathering, documenting specification, Analysis, Detailed Technical Design, Data Modeling, Development and Customization, Testing, Integration and Implementation of Bynx’s fleet management solution Willow.
• Designed, developed and customized modules using Oracle Forms and Reports, PL/SQL, database and client-side packages, procedures, functions, triggers, UNIX shell scripts etc
• Created batch-processing jobs using server side procedures, control files and shell scripts to schedule and execute nightly and weekend batch jobs using Maestro Job Scheduler

Project environment : HP 9000, HP-UX 11.23/11.20, AIX 5L 5.2/5.1, Sun Solaris 10, Oracle 10g/9i/8i with Developer 9i Suite (9i Forms Developer/9i Reports Developer /Crystal Reports 11), 9i Designer, PL/SQL 10.2, SQL* Plus 9.2, SQL*Loader, TOAD, J2EE, Java, Oracle JDeveloper, Web Services, XML, Perl Scripting, UNIX Shell scripting, SOA etc
Client: Confidential,Cincinnati, OH
Project Period : June 2007 - Sept 2007

(*) Project Titles : CSB (Customer Service and Billing Application)

Scope and Features :

• DTE is an energy and energy technology provider for residential and commercial electric and natural gas and is one of the nation\'s largest diversified energy companies.
• The CSB system provides for single billing for a variety of DTE services.
• CSB is supported by three key components: Computer Telephone Integration (CTI) – delivers the customer telephone call and customer information data to the customer representative’s desktop. CT Vision (The Collection Connection) – is an online, stand-alone collection system for overdue residential and commercial accounts. Customer Service and Billing(CSB) – is the billing engine which houses important customer and billing information.

Responsibilities:

• Designed, developed and maintained applications using Forms and reports, PL/SQL database and client-side packages, procedures, functions, triggers, UNIX shell scripts etc required for ongoing development and maintenance of customer service billing and other legacy applications/projects
• Created batch-processing jobs using server side procedures, control files and shell scripts to schedule and execute nightly and weekend batch jobs using Maestro Job Scheduler

Project environment : HP 9000, HP-UX 11.11/11.0/10.2, AIX 5.2/5.1.4.x, Sun Solaris 7/2.6, Windows 2000/NT, Oracle 10g/9i/8i with Developer 9i Suite (9i Forms Developer/9i Reports Developer), 9i Designer, PL/SQL 10.2, SQL* Plus 9.2, SQL*Loader, TOAD, J2EE, Java, Web Services, XML, UNIX Shell scripting, CMMI etc
Client: Confidential,Detroit, MI
Project Period : May 2006 – June 2007

• Confidential,Canada JUN 2005 – APR 2006

as Programmer Analyst / Systems/Database Administrator

Projects undertaken:

(*) Project Titles : Oracle Health Sciences Application Suite (Oracle Clinical (OC), Oracle Thesaurus Management System (TMS) & Oracle Clinical Remote Data Capture (RDC))

Scope and Features:

• Oracle Clinical is a database application that streamlines clinical trial management. It captures the data entered from CRF (Case Report Form) and stores the data in its database system
• Oracle Clinical is typically bundled together with other products, specifically TMS (the Thesaurous Managment System) and RDC (Remote Data Capture)
• Features include a Global Library of reusable objects, a comprehensive set of tools for capturing the components of the clinical trial protocol, a flexible method for structuring the questions that appear on Case Report Forms (CRFs), automated procedures for generating and customizing data entry windows (forms) that correspond to the CRFs, tools to define complex data validations and derivations, a discrepancy database automatically synchronized with changes to both the clinical trial data and the validation definitions, a flexible internal data structure for storing the clinical trial data that provides the ability to reorganize data for extract and tools to maintain lab reference ranges across multiple studies

Responsibilities:

• Designed, developed, validated, and maintained Oracle Clinical databases for clinical trials
• Transitioned the Clinical Research department from paper CRFs to Oracle Clinical’s Remote Data Capture (RDC) system for electronic CRFs
• Design and/or manage Oracle Clinical global library of panels, page sections, pages, rules and derivations, code lists, and other regularly used programs and routines
• Used Definition subsystem to create data collection modules (DCMs), data collection instruments (DCIs), and, optionally, DCI Books, which describe the data to be collected for a study. Created data entry windows & Validation and Derivation procedures.
• Managed Global Library definitions including questions, question groups, discrete value groups, data collection modules & instruments
• Designed, developed and maintained internal applications using Oracle forms, Crystal Reports, PL/SQL database and client-side packages, procedures, functions and triggers required for ongoing management of clinical trial data and operations.
• Provided technical support to data management and worked as a technical resource for the administration of oracle databases and related applications
• Performed SAS ETL tasks between Oracle Clinical and SAS datasets. Created, tested and activated derivation and validation procedures
• Used extensive understanding of HL7 and Code of Federal Regulations (CFR) Title 21, Part 11 that covers the management of electronic records and electronic signatures in computer system

Project environment : HP ProLiant ML570/ML370, Compaq ProLiant 5500/3000/800, Windows 2000/NT, Oracle Clinical 4.x, Oracle 9i/8i with Developer 9i Suite (9i Forms Developer/9i Reports Developer), Crystal Reports 9, 9i Designer, Enterprise Manager 9i, PL/SQL 9.2, SQL* Plus 9.2, TOAD, UNIX Shell & PERL Scripting, SQL*Loader, Performance Tuning with Explain Plan & DBMS_Profiler etc
Clients: Confidential,
Project Period : June 2005 – April 2006

• Confidential, FEB 2001 - JUN 2005

(A Haemonetics Company), Edmonton, Canada
as Systems Analyst

Projects undertaken:

(*) Project Title : DMS (Donor Management System)

Scope and Features:

• Involved in the development and maintenance of 5D’s flagship product DMS, Donor Management System which is designed to automate the operations of plasma collection centers.

Responsibilities:

• Senior team member of the development team and involved in the design and development of Forms and Reports, Oracle PL/SQL server side packages, Triggers, Pro* C/ C/ C++ programs.
• Tuned SQL Scripts using Optimizer Hints, Explain Plan and Packages / Stored Procedures using DBMS_Profiler.
• Also involved in unit/ regression/ integration/ team lead testing, implementation and support.
• Involved in full project life cycle: Analysis, design, development and implementation of applications. Analyzed user requirements, and prepared design and functional specifications based on these requirements.

Project environment : HP-UX, Windows 2000/NT, Oracle 9i/8i with Developer 9i Suite (9i Forms Developer/9i Reports Developer), SQR, 9i Designer, PL/SQL 9.2, SQL* Plus 9.2, Pro*C/C++, UNIX Shell Scripts, PERL, Performance Tuning using Explain Plan and DBMS_Profiler; SQL*Loader etc.
Clients: Worked in the product development and support group. Clients include Confidential,
Project Period : July 2002 – June 2005.

(*) Project Title : IHCare (Integrated Health Care Information System).

Scope and Features:

• IHCare is an enterprise-wide healthcare information system that includes Advanced Patient Management, Order Management, Clinical Management, Enterprise Scheduling and Community Systems Management subsystems.

Responsibilities:

• Senior team member of the development team and involved in the design and development of Oracle PL/SQL server side packages, Triggers, Forms and Reports, UNIX Shell Scripts, Perl, Pro* C/ C/ C++ programs.
• Tuned SQL Scripts using Optimizer Hints, Explain Plan and Packages / Stored Procedures using DBMS_Profiler.
• Also involved in unit/ regression/ integration/ team lead testing, implementation and support

Project environment : HP UX, Windows 2000/NT, Oracle 8i with Developer 6i/6 Suite (Form Builder 6i/6, Report Builder 6i/6), PL/SQL 8.1, SQL* Plus 8.0, Pro*C/C++, Designer 6.0, Performance Tuning using Explain Plan and DBMS_Profiler etc
Clients: Confidential,
Project Period : February 2001 – July 2002.

EDUCATIONAL QUALIFICATIONS:

Master’s Degree in Computer’s .

• Doing OCP Certification

• Introduction to Oracle - SQL and PL/SQL, Oracle
• Developer/2000 Forms I & II and Developer/2000 Reports, Oracle
• Corporate training in Oracle Applications 12i/11i
• Java Programming Fundamentals
• Several corporate trainings in Retail, Enterprise, Energy, Telecom, ERP, Banking and Health care operations etc.