SUMMARY

• Over 15 years of designing & implementing diverse cutting edge database systems delivering excellent business intelligence (BI) systems.
• Adept at creating IT systems that support a variety of industries including Asbestos liability Claims Processing, Government Housing Development, Healthcare & Pharmaceuticals.
• Excellent team player who was instrumental in implementing claims management systems using Oracle PL/SQL
• Experience in implementing business logic using Triggers, Views and Stored procedures.
• Extensive experience in writing complex PL/SQL Program Units.
• Involved in performance tuning using Explain plans. AWR Reports, TKPROF, SQL Trace.
• Strong database design, hands - on development and administration experience.
• Hands on experience with ERwin.
• Worked with Collections, PLSQL Tables and Arrays.
• Used SAS to generate critical Quarterly and Annual Management reports for reporting Confidential 's Asbestos Claims Summaries.
• Experience in user/production support.
• Expertise in Data Conversion, Data Migration and Data Load.
• Worked on Medium to Large Databases.
• Well versed in Software Development Life Cycle and comprehensive understanding of software testing methodologies.
• Knowledge of Oracle Form and Report Developer2000.
• Superior oral and written communication skills
• Excellent team player as well as work independently and time-management skills.

TECHNICAL SKILLS

Software: ORACLE 11g/10g/9i/8i/8.x/7.x, PL/SQL, SQL*PLUS, SQL*LOADDeveloper/2000 (Forms 4.5/5.0/6.0/9 i, Microsoft Access Database and Microsoft Excel.ORACLE Reports 2.5/3.0/6.0/9 i, Graphics 3.0), (Forms 4.5, Reports 2.5), SAS

Hardware: SUNX Ultra 2, IBM 3270, HP-9000, DIGITAL ALPHA, ACER PENTIUM, ACER 486, METEOR 486, HCL BUSYBEE PC-XT, and IBM PCs

Operating System: LINUX, VAX/VMS, IBM AIX V 4.3.2, HP-UNIX 10.2, Windows 95/98, Windows 2000/XP, Windows NT 3.11, WINDOWS for WORKGROUPS, MS-WINDOWS 3.1, NOVELL NetWare 3.1

Tools: SQL Navigator 5.5, 5.0, Oracle OEM v2.0.4.0.0, Platinum Erwin v3.52

Languages: PL/SQL, SQL

QA/Testing: QTP, Selenium, VB Script, Java

PROFESSIONAL EXPERIENCE

Freelance Consultant

Confidential, Reston,Virgina

Responsibilities:

• Data Analyst performing data analysis using ORACLE SQL querying to draw conclusions and to provide recommendations.
• Worked on looking for Data inconsistencies, keeping the Data integrity, data forecast, data compliance to business requirements, consistent with business strategies and rules.
• Performance tuning using Explain plans, TKPROF/
• Oracle Bulk load and external Tables.

Confidential, New York, NY

Software Specialist

Responsibilities:

• Data Migration, Data Conversion to convert data from the Old business model to the New Business Model. Developed PL/SQL Program Units to move data from Old Business Model Database (ONTRACK) to the New Application Database (HPD Works).
• Loaded Data using direct conversion routines, as well as Staging area Database Structures.
• Developed and implemented conversion routines to translate business Mapping into apply the new business logic to translate to data to acceptable target business model.
• Applied and used LLD in Data Modeling and implementing Business requirements.
• Worked in AGILE Methodolgy, Attended to SCRUM session and 2week rapid sprints. including daily standup meetings.
• Performance tuning using Explain plans, AWR Reports, TKPROF to improve and fix performance issues and performance degradation on complex multi-table joins.
• Recommended Table partitioning and indexes to boost performance.
• Run the conversion of data for UAT.
• Created the required Procedures and Functions for the Migration of the Initial Phase of the Migration.
• Successfully migrated the Initial Phase of the Project.

Confidential, Reston,Virgina

Data and Systems Analyst (Consultant)

Responsibilities:

• Gathered User requirements and translated them into Business Model. Analyzed Business requirements and implemented the Business/application model.
• Expert in Data Analysis and giving recommendations on Data inconsistencies.
• Reporting Data inconsistencies, and maintaining Data Integrity.
• Loaded Data using direct conversion routines, packages as well as Staging area Database Structures.
• Managed Database Application objects(Tables, Procedure, Packages).
• Designed test cases for UAT. And tracked the progress of the application Testing.
• Used PL/SQL to code the Modules.
• Extensively handled User requests for Data Reporting. Exported data to Excel Formats.
• Imported Data from external source (Excel Files and Access Database to load into the Application Database.
• Adhoc Reporting using SQL and Excel Report Output.
• GO-TO Point person for all data requests from external entities.
• Implemented Application level Security

Confidential, New York, NY

Senior Programmer/Analyst

Responsibilities:

• Designed, developed & tested Settlement, Payables, Accounting, and Billing Modules for insurance ‘Claims Processing’ software modules. Created Monthly, Quarterly Management Summary Reports for Confidential Legal Finance. Extracted and processed legal reports based on requests for data analysis requirements of supervisors, counsels and law firms; from Multisource Plaintiff Law firm Databases. Developed PL/SQL stored procedures and functions, views, to implement functionalities across the system using external tables and used Access Database to load data into oracle tables from flat files.
• Key Design and implementation team member, in analyzing, designing and implementing Bundled-to-Unbundled conversion Business Plan. Implemented Data Conversion to adhere to the new Business Model for Asbestos Claims Processing.
• Conducted performance tuning using Cost Based Optimizer usage and DML plans using Explain Plan, Quest SQLNavigator tool for Development, Table & Index analysis using DBMS STATS to gather statistics, DDL & DML, Tune production queries. Excelled in the role of Application DBA creating and modifying data objects including Tables, Sequences, procedures, functions, triggers, Explain Plan for Query Performance.
• Performance tuning using Explain plans, AWR Reports, TKPROF and SQL Trace on complex queries using high volume Tables. Also, created indexes and used hints in queries to boost performance.
• Analyzed Business requirements and provided solution and designed business modules and processes.
• Designed the Cost effective Database objects (Tables/Data structures) required for the Business processes.
• Worked with certain automated data load processes to look for Claims data from external source, to load, validate and push data into the Database, using automated CRON jobs.
• Worked on Medium to Large Databases.
• Create necessary database objects (packages/procedures/functions, triggers, and tables).
• Extensively created ADHOC reports using SQL Queries for the ADHOC requests from management and Law firms. Output primarily in the Excel File Format.
• Use advanced techniques like Dynamic SQLs to create/populate permanent/temp tables for interim rule processing as well as create indexes on temp tables and collect stats on them.
• Use anonymous blocks to log the intermediate results/queries.
• Tune the dynamic queries to achieve the expected level of performance efficiency.
• Extensively use exception handling and to track, log and ensure the proper operation of the DB objects.
• Performed the role of Application DBA creating application objects and maintaining object Security.
• Loaded Data from Law firms into the application and processed them according to the Claims processing Business rules.
• Perform the UNIT test.
• Did QA of the Application module using Manual Testing using Test Cases.

Confidential, Boston MA & NY

Senior Programmer/Analyst

Responsibilities:

• Conducted performance tuning using Cost Based Optimizer usage and DML plans using Explain Plan, SQLNavigator tools, Table & Index analysis using DBMS STATS to gather statistics, DDL & DML, Tune production queries. Excelled in the role of Application DBA creating and modifying data objects including Tables, Sequences, procedures, functions, triggers, Explain Plan for Query Performance.
• Create necessary database objects (packages/procs/functions, triggers, and tables).
• Use advanced techniques like Dynamic SQLs to create/populate permanent/temp tables for interim rule processing as well as create indexes on temp tables and collect stats on them.
• Use anonymous blocks to log the intermediate results/queries.
• Designing, coding, testing, and implementing the Interface module, to upload Vehicle Insurance Data from an external agency (FASTRAC) into MaxiLease on a weekly/Monthly basis. Developed Surround System Interface module between Leasepak / Dealer Access, a front-end lease booking system on VMS / Web Application and MaxiLease, with Error Reporting by e-mail to the User.
• Implemented user maintenance, Remote server Information, Insurance tracking screens using Forms 4.5. Developed Lease Booking Report, Client Overdue report using Report 2.5