Summary

• Over 6 years of experience in performing software analysis, design, development, and supporting clients such as Toyota, Prudential and AmeriHealth Caritas.
• Strong skills in Oracle server side programming which includes SQL, SQL Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming and a very good knowledge of Oracle 10/11g Developer Suite modules.
• Extensive experience in identifying performance issues and performance tuning using SQL Trace, Explain plan, Indexing, Hints and TKPROF.
• Extensive experience in data migration techniques using SQL Loader, Import/Export.
• Hands on experience in building applications using MS Access, Excel, Macros and VB.Net.
• Experience with various Source Configuration Management SCM tools like Clear Case Clear Quest and VSS.
• Working experience in reporting tools such as crystal reports.
• Managed projects as Team Lead and conducted meetings with all levels of management.
• Experience in on-call 24 7 support in production environment, even during off-hours.
• Experience in onsite-offshore business model and coordinating a team offshore.
• Excellent troubleshooting, debugging, and error trapping skills.
• Extensive experience in full life cycle or SDLC process development and post implementation support of various large-scale systems using Six Sigma methodology.
• Excellent written and verbal communication, interpersonal skills, and working as part of a team.
• Experience working with HIPAA ANSI X12 4010A 270/271, 276/277, 834, 835, 837 for institutional, professional and commercial claims.
• Domain Expertise includes multiple areas of Insurance including Annuity, Life insurance life cycle, Individual Life products and Manufacturing and logistics

EXPERIENCE

Senior Oracle Developer

Confidential

• Design and develop solutions and applications for encounters and claims support applications. Code, test and develop programs and documentation for all HIPPA files. Troubleshoot and solve design and coding problems. Liaise with Lead Programmer/Analysts and Business Systems Analysts to understand and meet customer requirements and design specifications and accuracy of complete encounter files and high acceptance rate with 11 Lines of Business including subcontractors Pharmacy, Dental, Vision, Family Planning and Behavior Health data.
• Gathering the functional requirements from users and converting them into technical requirements and get sign-off from Programmer/Analysts and Business Systems Analysts.
• Migrated DB tables from Oracle 10 to Oracle 11g and altered tables with new data types.
• Migrated PL/SQL Code from Oracle 10 to 11g and implemented Object types.
• Created database packages, procedures, functions, triggers, views, and materialized views using Oracle PL/SQL in 10g.
• Create shell scripts to call from tidal jobs to automate this process.
• Analyzed performance of database objects and suggested DBA for indexes, schema gathering, partitioning, explain Plan, TK PROF.
• Used SQL Loader and export/import mechanism for data migration for bulk upload. Implemented PL/SQL to perform application security and batch job scheduling using Tidal.
• Generated dynamic reports Data Cert using crystal reports.
• Performed thorough Unit testing, System Testing and User Acceptance Testing in development environment to obtain an error free and smooth migration process and provided quality work for functional users.
• Verified the HIPAA Transactions files 277CA, 834, 835, 837, 999 and 997.
• Liaised and Coordinated the resolution of EDI mapping issues arising from data transfer process from Encounter database to third party systems.
• Analyzed mandatory and the situational fields and compared these with the users manuals for EDI.
• Analyzed data issues in the 837P, 837I, 837D, 277CA, TA1, 999 etc. files.
• Use knowledge of Trizetto Facets Healthcare system, Sybase, tidal.

Environment: Oracle PL/SQL, VB.Net, Crystal Report, Tidal, Citrix, shell scripting

Oracle Pl/SQL Developer

Confidential

• Worked with business and technical analysts in gathering requirements for the project and with LifeCAD, which is the application used at Prudential for the administration of fixed payout products for annuities, life, group life and structured settlements. I also developed schema objects such as Tables, Constraints, Indexes and other schema objects required for the project and ensured that Prudential complied with the regulation put forth by the New York Department of Insurance:
• Developed the stating schema and tables to load daily feeds.
• Worked extensively on database functions, stored procedures, packages, roles, and granted privileges, complex joins, indexes, and packages as per the requirements of the project.
• Expertly used the tools SQL Developer, Toad, SQL Plus.
• Involved in developing technical documentation.
• Prepared DML/DDL scripts for new database to synchronize all environments Development, testing and production .
• Wrote SQL scripts to perform back end testing of the Oracle database using SQL.
• Implemented change controls and performed impact analysis and effort estimations.
• Developed and created PL-SQL stored procedures to automate repeatable processes.
• Coordinated Unit Testing, Quality Assurance and Production Deployment of applications.
• Worked with account managers, implementation managers, and employers to ensure eligibility files met the needed file requirements.
• Performed Business Testing for all file feed content and customer specific reporting.
• Performed multiple effort estimations using Function Point technique during multiple phases in the SDLC life cycle.
• Frequently interacted with internal and external users/teams.

Environment: Oracle PL/SQL, PVCS, Oracle Discoverer, Vb.Net, Citrix, shell scripting

Oracle Pl/SQL .Net Developer

Confidential

• Documented business requirements and data mapping for customer specific reports.
• Performed Business Testing for all file feed content and customer specific reporting.
• Performed impact analysis and effort estimations.
• Coordinated and implemented change controls.
• Used the Toyota Order Management System TOMS to manage the ordering and specification management system. I was also involved with Sales Analysis and Production Planning SAPP , monthly forecasting and specification management SpecMan . I gathered business requirements, performed User Needs Analysis, and coordinated External/Internal teams:
• Analyzed Service Request Tickets and suggested the root cause to work around or resolve those Tickets.
• Developed P2E, SLA Dashboard, CCAT, FRNBA, APPUPDATE, and DATAMAN tools for this project.

Environment: Oracle PL/SQL, Vb.Net, shell scripting