SUMMARY:

• Over 9 Years of software development life cycle experience in Software Design, Development and Implementationin SYNTEL LTD.
• Over 6 Yearsof experience in Oracle, SQL, PL/SQL applications.
• Over 4 Years of Onsite experience at Client location Pittsburgh USA .
• Over 1 Year of Glasgow Scotland experience at Client Location SLC .
• Expertise in EDI Transactons 270/271, 276/277, 278, 835, 837 I and 837 P .
• Expertise in Implementation Guides of major EDI Transactions.
• Extensive experience in maintaining the processes for all the database activities within the project to meet the security and audit guidelines.
• Extensive experience in writing SQL, Stored procedures, Functions, Packages, Databasetriggers, Exception Handling and SQL Loader scripts.
• Extensive experience in DataModelling both Logical and Physical Data Models using ERWIN.
• Good understanding of oracle Data Dictionary and Normalization Techniques.
• Knowledge in query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
• Extensive experience in data migrationtechniques using Oracle External Tables, SQL Loader, Import/Export, bulk and batchprocessing.
• Expertise in performing Data export, Import and various operations using TOAD.
• Extensively worked in Client-Server application development using Oracle 10g/9i/8i,
• SQL, PL/SQL.
• Experience of using Global Temporary Tables.
• Experience in application development using various advanced features of Oracle like Collections, BulkCollections, TableFunctions, AutonomousTransactions, DynamicSQL, Objecttypes and Records.
• Experienced in data analysis, data modeling, development, testing and documentation of projects.
• Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Improve the performance of the slow SQL queries by implementing proper Index, using FORALL and BULKCOLLECT.
• Experience in Installing Software's and Configuring Databases.
• Strong Trouble-shooting, Problem solving, Analytical Design Skills.
• Experience in programming languages like C, C , HTML and XML Technologies.
• Possess good communication skills and quick learning ability.

.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Role: Senior Oracle Developer

Confidential Services is the investment servicing division of State Street, also known as the State Street Bank Trust Co. It provides asset owners and managers withcustodian safekeeping, corporate actions , fund accounting pricing and valuation , and administration financial reporting, tax, compliance, and legal services. Global Services handles assets from many classes, including equities, derivatives, exchange-traded funds, fixed income assets, private equity, and real estate. State Street now administers 40 percent of the of the assets under administration in the US mutual fund market.Global Services also provides outsourcing for operations activities and handles 10.2 trillion USD of middle-office assets.

Responsibilities:

• Developed stored procedures to extract the data from sources and load it into intermediate staging tables data.
• Worked on Data Stage for the mapping of source columns to the staging columns.
• Worked on the enhancements of the data stage jobs to fit into the new requirements.
• Analyzing the data and Mapping the data requirements developing Stored Procedures, Functions and Triggers.
• Extensively used Cursors, User-defined Object types, Collections,Records, and Tables in PL/SQL Programming.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in Daily status calls both with Client and Offshore.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Refactored the current system of Investors and Investments to a Row based structure for all the financial columns.
• Partitioned tables and indexes for better performance of application
• Analyzed SQL statements reorganize database objects and design indexes to improve response of queries.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed reports using complex queries as per client request as a part of production support.
• Provided on call support, solved the user issues and made necessary changes.
• Resolved Production severity Issues in time and meeting the SLA.
• Writing high quality and well documented code according to standards.

Environment: Toad, SQL Plus, SQL Loader, Oracle 10g, MS SQL Server, Data Stage,Windows XP, UNIX.

Confidential

Role: Project Lead

The Confidential is a not for profit company in the United Kingdom that provides student loans. It is owned by the UK Government's Department for Business, Innovation and Skills 85 , the Scottish Government 5 , the Welsh Government 5 and the Northern Ireland Executive 5 .The SLC is funded entirely by the UK government and the devolved administrations. It is responsible for both providing loans to students, as well as collecting loan repayments alongside HM Revenue and Customs HMRC The SLC was established in 1989 to provide loans and grants to students studying in the UK. From 1990 to 1998 these were mortgage-style loans, which were aimed at helping students with the cost of living and repaid directly to the SLC. From 1998 with the introduction of tuition fees in the UK, the SLC instead began providing loans under an income-contingent repayment ICR scheme, to cover the cost of the fees as well as living costs. Repayments for these loans were collected by HMRC via thePAYE tax system.

Responsibilities:

• Creating Module Specifications and Unit Test Specifications as per SLC guidelines and standards.
• Strictly follow the SLC's QA process using DRS Document Review System
• Created PL/SQL Stored Procedures, Functions and Packages for implementing business logic.
• Creating setup scripts for various correspondence letters.
• Extensively used Cursors, User-defined Object types in PL/SQL Programming.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Used Exception handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in tuning the complex queries of Live Environment to improve the performance.
• Creating the implementation plans and the release labels with the changes that need to be promoted to each environment.
• UNIX Shell scripting for the nightly jobs that needs to be run for creating the correspondence letters to the Students.
• Coordinating with the release team to implement the changes in different environments like Next Test, Support Test and Live.
• As a senior ICT developer closely working with Clients and the BSA for the requirement gaps and implemented the gaps in given timelines.
• Prepared Technical Documentations and walk through to the clients for the successful project handover.
• Involved in code review process for all the internal teams before delivering to make sure we follow all the SLC guidelines and the standards.
• Active team member of the QA process for the peer reviews of all the oracle developments carried over by other oracle resources.
• Actively participated in the Oracle RFP and the value ads and the suggestions to the clients in the areas of improvement in terms of process and the development areas.

Environment: Oracle 10g, Oracle 10g Developer Suite, Toad,SQL Developer.

Confidential

Role: Project Lead

Confidential is recognized as the industry leader in the Medical Banking niche, which is the convergence of traditional Treasury Management and healthcare Clearinghouse services. The competition is closing the gap with acquisitions and capital investments. PNC must maintain and capitalize on the brand recognition in the industry. An integrated comprehensive and complete healthcare revenue cycle solution from pre-registration through collection that utilizes decision support tools throughout the cycle is required. The focus is to enable cognitive learning for constant and automated improvements to the decision support tools and processes to drive economies of scale and to automate manual process for both PNC and the Client. Implementing and automating the trading partners, 270/271, 276/277, 278, 835, 837 EDI transactions, Egistics, THIN interface, Denial mgmtetc, under the project scope

Responsibilities:

• Created Logical and Physical DataModels for entire application with different subject area for each Release.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Extensively used Cursors, User-defined Object types, Collections,Records, and Tables in PL/SQL Programming.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Developed control files for SQL Loader and PL/SQL programs for loading and validating the data into the Database.
• Sucessfully implemented the Deployment Process at Onsite for better deliverables to Production.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Implemented features includingviews for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Created Packages, Stored Procedures and Functions to be called by Java modules.
• Involved in writing complex queries to generate reports as per client requests as part of productionsupport.
• Coordinated with DBA in improving Database Performance.
• As Lead at Onsite closely work with Clients for the requirement gaps and implemented the gaps in given timelines.
• Prepared Technical Documentation. Trained the business users for the better understanding of the Business Application.
• Involved in code reviews for the code received from Offshore.
• Involved in developing test plans and test cases based on high-level and detailed designs.
• Involved in Production Support and troubleshooting data quality and integrity issues.
• Involved with Offshore as a point of contact for all the database deliverables.

Environment: Oracle 10g, Oracle 10g Developer Suite, Toad,SQL Developer.

Confidential

Role: Senior Programmer Analyst

Confidential is focused on number of core technology domains to enhance expertise and offer optimized migration solution. The identified migration areas are Language Migration, Data Migration, Platform Migration, Architecture Migration, and UI Migration. Proactive identification and evaluation of best migration tools, techniques and methodologies developed by third parties targeting specific migration paths, to test their technical and financial suitability to our current and future projects.

MCoE goals are:

• Offering optimized solution to specific migration scenarios.
• Remove pain areas of migration, such as development cycle time, cost. Also speed up the time to market the migrated applications.
• Working as knowledge repository and offer thought leadership in migration practice areas.
• Proactively look for new migration opportunities as per market trend, and work on resolving the pain areas in them.
• To provide High ROI and reduced TCO to clients.

Responsibilities:

• Involved in Coding and Development of IP Portal and Migration Portal.
• Evaluated tools and methodologies for migrating Lotus Notes to J2EE.
• Involved in gathering the stratagies and limitations with the tools.
• Involved in Research and Development with the third party tools.
• Co-ordinating with the third party wendors for the tools provided and doing a POC.
• Environment:Windows 2000/XP, HTML, Core Java, Java Mail, Struts, JSP,Oracle

Confidential

Role: Programmer Analyst

Confidential Developing a product that would provide the necessary features and functionalities to Payers. The Contract Management system will be used to manage all provider contracts for a payor. A Provider Contract is an agreement between the payor and any healthcare provider example: acute care hospital or primary care physician . By setting up a contract, the provider and payor agree upon the method of reimbursement for the services provided. The Contract Management system will maintain the legal contract document legal text along with the contract data that represents the terms of the contract regarding the services contracted for along with the method and rates for reimbursement. A term is a collection of provisions, exceptions, exclusions, and limits. A provision lists services that are reimbursed by a standard method according to a Payor/Provider contract. Exclusions, exceptions, or limits are deviations from the standard Payor/Provider contract.The solution runs on McKesson's Horizon Architecture and uses effective deployment of industry standards such as J2EE, SOAP, XML/XLS and C as well as Unix database servers, Linux application/web servers and Oracle relational database management systems.

Responsibilities:

• Involved in Coding and Development of Templates Module of the CACD Project.
• Creating hbm files and corresponding Java classes for the the tables related to Templates Module.
• Good understanding amd implementation of HAF framework using SOAP to access data.
• Interacting with the client on daily basis for the status of the project and issues.
• Used Exception Handlingextensively in coding.
• Executing the scripts and inserting data into the tables.
• Adding constraints, updating and altering tables according to the changes in the design documents.
• Documentation of Tables and Views.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.

Environment:Windows 2000/XP, C Windows Application , Spring Framework,Hibernate 3.1, HAF Framework using SOAP to access data in Oracle 10g.