HIGHLIGHTS

• Around 7+ years of experience in Software development using Oracle Technologies that includes Complete System Development Life Cycle from Analysis and Design to Implementation in Telecom,Banking&Finanace and HealthCare domain.
• Acquired good Telecom Domain Knowledge while working with Verizon Business, BRITISH TELECOM and Banking & Finance Domain Knowledge while working with CITIGROUP and HealthCare Domain Knowledge working with Total Health Care/Blue Cross Blue Shield.
• Developed PL/SQL Programs as Database Triggers, Stored Procedures and Functions and Packages.
• Experience in Dynamic SQL, Records, Collections and Exception Handling.
• Experience of working with Oracle XML Db .
• Experience in Application Performance and Tuning using TKPROF and Explain Plans and using Oracle Hints and Oracle Advanced Queuing.
• Experience in Table, Index Creation, Roles and Database Links for Remote Database access.
• Worked extensively on Oracle8i/9i and Oracle 10G and Knowledge on 11G.
• Experience with Edit Plus, Eclipse 2.1.1/3.0 and Weblogic workshop IDEs
• Experience in developing applications API’s using Java, JDBC, and Java Beans.
• Knowledge of J2EE, JSP, Servlets, XML, HTML, XHTML, JavaScript, Ajax, Struts.
• Strong experience in Back-end Programming with Oracle PL/SQL and SQL and Front end programming with technologies such as Pro*C,Forms 6i .
• Extensively worked on Building Front end Reports and Interfaces using C, Pro*c 3.0 and Forms 6i which included coding, preparing test plans and production transfers.
• Experience with UNIX Operating system, Shell scripting and coding and running Pro*C and Forms 6i programs in UNIX Platform.
• Extensive QA Experience in Unit Testing, Performance Testing and Integration Testing in all Phase of the Development Life Cycle.
• Knowledge of Data warehousing concepts (ETL Process, Fact tables, Star Schema) .
• Oracle Certified Associate in Oracle Developer Track (Oracle 9i).
• Excellent Programming and trouble shooting skills, and an ability to deliver under pressure.
• Interacted with business technical groups and analyzed business needs.
• Have Strong interpersonal, analytical and communication skills, self-motivated and multi-task oriented, with strong work ethic and ability to work effectively in a Team.

SKILLS SUMMARY

Languages

C,C++, Java, J2ee, XML, HTML, JavaScript, SQL,PL/SQL,Pro*C, Shell Scripting

Application Servers

BEA Web logic 8.1/ 10.3

IDEs

Eclipse 3.x

J2EE Technologies

JSP, Servlets, JavaBeans, JDBC,JSP Custom Tag Libraries

FrameWork

Struts

Databases

Oracle 8i/9i/10G

Operating Systems

HP-UNIX, MS–DOS, Windows 9x/2000/NT/XP, Sun Solaris

Tools

Toad, SQL * Plus, PL/SQL Developer, SQL Navigator

GUIs

Forms 6i

Education and Achievements:

Bachelor of Engineering, Electronics & Communication

Oracle Certified Associate in Oracle Developer Track.

Awarded with the Exceptional Performer Award from Nucsoft Ltd for Flexcube Migration Project for Citibank.

OVERVIEW OF EXPERIENCE

Confidential, (Southborough MA) Jul 09 – Current
Role: Software Engineer

These Projects Involve Building High end scalable applications for CLAIMS Processing system In Healthcare Domain.
The system has its data and processing criteria stored in tables which would involve
Claims data, provider information, member information, etc.
Provider will be used to generally refer to any professional (physician, specialty clinic, etc.) or institutional (hospital, long-term care, etc.) entity. Insured is used to refer to a health plan participant. The submission process begins with the treatment of a medical condition. A health plan will process and accept health claims submitted in electronic form by a provider. The claim is subsequently processed.

Responsibilities:

• Responsible in product development in Architecture Design, Development, Testing and Implementation phases.
• Responsible in Data Migrations/Data Conversion/Data cleansing with the use of Utilities like SQL * Loader, Collections and created custom Stored Procedures, Functions and Packages to load/extract the data from Oracle Applications and Legacy systems.
• Responsible for writing test cases and test scripts SQL Queries (Oracle) to validate the data in data warehouse that are being loaded.
• Responsible in code promotion/deployment from one environment to another i.e., Development, UAT and Production upon approvals from supervisor and Business users through tools like VSS and Control-M.
• Tuning Queries Using Hints and Performance Optimization Techniques to achieve better Performance.
• Development using Oracle Xml Db while working in EDI for various processes like 834,837,835,270/271.

Environment: Oracle 10g, Oracle XML db, Toad, Sql Loader, Pl/Sql Developer, C#, ASP.NET3.5

Confidential, (Boston MA) May 07 – Jun 09

Confidential,
Role: Software Developer

Enterprise data integration (among MCI and VZB portal), (VZB and VZW portal) which integrate more than 500 backend systems in all business areas.

The main area of work for all these Projects is CDI (Customer Data Integration) and MDM (Master Data Management) for ECP (Enterprise Customer Profile). It is the process of consolidating and managing customer information from all available sources, including contact details, customer valuation data, and information gathered through interactions such as marketing. The scope of all these projects migration starts right from analysis of the existing data from a different system, creating detailed design level documents and finally migrating existing data from one system to other using Pl/SQL stored Procedures, Triggers, Functions and packages.
These projects also involved Middleware development of Java Api’s using JDBC and Front end development using Jsp, Struts, Ajax, JavaScript and Html.
In addition to that sending daily reports using shell scripts which are scheduled using cron jobs.

Responsibilities:

• Preparing of High level design and Technical (detail) design documents for migration projects.
• Involved actively in full life cycle of the migration projects which includes Analysis, Design, Build and Testing phase.
• Use of Java Api’s to Produce Reports using Ref Cursors and also using Dynamic SQL to produce diff reports based on different user Requirements.
• Designed and developed forms using HTML and validated them using JavaScript.
• Used Log4j for logging Errors.
• Did rigorous unit and integration testing for the modules developed i.e. Unit Testing, Performance Testing and Integration Testing of the UI pages and Database level integrity checks
• Used XML to transfer the application data between client and server and also used Oracle Advanced Queuing.
• Used the JDBC for data retrieval from the database for various API.
• Writing complex SQL queries and PL/SQL procedures and functions to extract data from various source tables.
• Creating New and modified Database procedures, functions, triggers and other database objects by using TOAD tool.
• Developing Shell Scripts in UNIX to generate reports.
• Using SqlLoader to load Diff Data files to Staging Tables.
• Participating in unit testing, system testing and fixed defects in PL/SQL packages, Procedures, Functions and Shell Scripts.
• Daily Interaction with customers and business analysts to implement enhancements in PL/SQL Packages according to business requirements.

Environment: Oracle 10g, Toad, Sql Loader, UNIX, Java, XML, Web Logic 8.1,XSLT
Eclipse 3.3.0, JDK 1.4, JSP, Java Script, Struts, Ajax,EJB2.0,Ant,Cvs,Web
Services.

Confidential, Jul 06 – Mar 07

Confidential, London Jul 06 – Mar 07
Confidential,
Role: Oracle Developer (Team Lead)

The Prime responsibility of DCMO Team is to load and amend Customer Inventory data in BFG. BFG is the name given to customer inventory database of the Central Repository. The Application /Data tools primarily Tested are: DCMO Online - Performed End to End Testing of intranet Web application, followed quality standards and Testing Techniques. DID Tool - Data Input Device, main DCMO Tool for Bulk Loading. IMS - Inventory Management System which enables users to make real time changes so that contract teams/CSM\'s can manage their customer data.

Responsibilities:

• Involved in leading a team of 5 people.
• Created and Debugged Oracle 9i PL/SQL procedures in TOAD.
• Development using Forms 6i .
• Created Anonymous blocks with cursors to call Remote procedures.
• End to End testing of various developments of the IMS and DID applications.
• Prepared the User Test plans for the User Acceptance Testing (UAT).
• Tuning Existing SQL queries
• Involved in writing programs in Pro*c which involved Bulk data Processing and PL/SQL procedures through Dynamic Sql.
• Unit Testing, Performance Testing and Integration Testing of all the Modules Developed.

Environment: Oracle 9i, Toad, Sql Navigator, Asp Dot Net, IIS Server, Visual Basic,Pro*C,Forms 6i

Confidential, (Nucleus Software) Apr 04 – Jul 06

Confidential, Jan 05 – Jul 06
Role: Oracle Developer

Confidential, is a major re-engineering exercise of Citibank India, which aims at making the core banking system called Oasis and Basis more scalable. Currently the Citibank User has to perform all the activities (e.g. Account opening, Tide booking, etc.) separately for each branch. Also the data for different branch is stored on different Oracle instances and inter branch activities (e.g. PAP check clearing) only takes place with the help of Dblinks.
E-Oasis aims at removing this restriction so that the User can perform any activity by logging onto a PAN-INDIA branch, and also consolidation of all the oracle instances into one single instance thus improving the productivity.

Responsibilities:

• Worked with developing and maintaining the business functions as database packages, stored procedures, functions, and database triggers in Oracle 9i using TOAD.
• Designed New Front end interfaces through C, Pro *c and Forms 6i which in turn called Oracle stored procedures.
• Through understanding of Business Functionality for Consumer Banking.
• Involved in writing programs in Pro*c which involved Bulk data Processing and PL/SQL procedures through Dynamic Sql.
• Unit Testing, Performance Testing and Integration Testing of all the Modules Developed.

Environment:Oracle 9i, Forms 6i, Pro*c, SQL, PL/SQL, SQL*PLUS, TOAD, Sun Solaris,
Java,JDBC

Confidential,INDIA Mar 05 – Dec 05
Role: Oracle Developer

An Online interface is needed to pass accounting entries from Supplier Finance and Channel Finance product to Flexcube and get back response from Flexcube to indicate whether the entries were successfully passed or not.
Flexcube:
This is a centralised banking system of Citibank GF Customers. It contains information about Flexcube related accounts, base no\'s and limits for TTLC Buyer\'s. Entries from Supplier-Finance will hit Flexcube Online/Offline. All Offline accounting entries will be uploaded into Flexcube through an X-Cup File.

Responsibilities:

• Involved in analysis, design, and coding, testing, implementation of the project
• Had tuned large number of SQL queries using TOAD.
• Developed new PLSQL Packages(REF CURSORS Used) , Procedures, Dynamic Sql and Databasequeries in Oracle 9i
• Designed new Front end interfaces through C, Pro *c and Forms 6i which in turn called Oracle stored procedures after numerous validation checks.
• Checked existing Pro*c and Forms 6i interfaces for the migration.
• Prepared the User Test plans for the User Acceptance Testing (UAT).
• Through understanding of the FLEXCUBE system as a whole.

Environment: Oracle 9i, Forms 6i, C, Pro*C, SQL, PL/SQL, SQL*PLUS, TOAD, HP-UNIX.,
Java, JDBC