SUMMARY:

• Professional experience in IT industries in the field of System analysis, Design, Development, Testing, Implementation and Maintenance of medium and large size projects using ORACLE 11g/10g, SQL, PL/SQL, VB Scripts, JAVA, Java Scripts, SQL * LOADER, Business Objects and Unix Shell scripting.
• Strong experience in Software Development life cycle (SDLC) methods including Development projects, Conversion projects, Migration projects, and Maintenance projects.
• Worked on Agile and Waterfall Methodologies.
• Strong Data Architect expertise in developing RDBMS Logical Database Design/ Physical Database Design using tools ERWIN, Power Designer.
• Expertise in Oracle 11g/10g, PL/SQL and Advanced PL/SQL programming.
• Advanced in developing complex SQL queries, stored packages, stored procedures, stored functions, database triggers, views, materialized views, and external tables on large - size projects. Optimization and tuning of SQL queries using explain plan, sql trace, TKPROF, optimizer hint, merge, global temporary tables, Dynamic SQL, Bulk collect/insert, Collection, and PL/SQL Table. AWR, ADDM, RAC.
• Expertise in SQL * LOADER, IMPORT/EXPORT.
• Strong expertise in production support projects using Batch Job Scheduler tools CONTROL-M, MAESTRO, AUTOSYS and TIVOLI Job Console.
• Expertise in HP Vertica Analytic Database.
• Excellent UNIX K-shell scripting, C shell scripting, and Perl programming.
• Worked on ETL tools like Informatica PowerCenter, Business Objects, BridgeWare and Teradata SQL Assistant.
• Worked on Source Control Management tools like Tortoise SVN, MS Team Foundation Server, JIRA, GIT/ Bitbucket, Perforce, MS Visual SourceSafe, Rational ClearCase, and WINCVS.
• Strong expertise in developing Client-Server applications using Oracle Forms 4.5, Developer 2006 and Visual Basic.
• Strong expertise in developing various types of reports using reporting tools: Crystal Reports, Oracle Reports, Actuate Reports, Active Reports, SQL PLUS Report Writer, Eagle STAR/PACE REPORTS, PRO *C, PRO * COBOL, OBIEE.
• Worked on multiple operating environments like HP-9000, Sun Solaris, LINUX, Windows NT, Windows 2000, Windows XP, and Windows 2008 platforms.
• Excellent communication skills. Strong project management skills. Around 15 years of IT work experience in USA and worked with clients like Confidential, Confidential, Confidential, Confidential, Confidential, Confidential, Confidential and Confidential .

TECHNICAL SKILLS:

Databases: Oracle 11g, Oracle 10g, Oracle 9i

Analytic Database: HP Vertica

Platforms: Windows7/ NT/2000/XP, Linux 1.6.16, Sun OS 5.10.

Development/Productivity Tools: AWK, Developer 2000, MS Project, ODBC, ORACLE OBJECTS FOR OLE, PL/SQL, Pro*C, Pro*COBOL, SQL * FORMS 3.0, SQL * LOADER, SQL*Plus, SQL*ReportWriter, Unix Shell Scripts, Visual Basic, VB Scripts, Java Scripts, ASP, VI Editor, TOAD, Putty, HP ALM Quality Center 12.5, MS Team Foundation Server, Total Commander 8.0, Beyond Compare 4.0, Control-M 7.0, Hadoop, Sqoop, HIVE, Impala, SharePoint, MS Lync/Skype, Agile(Jira), Bitbucket,Visio, Access, Excel, PowerPoint, Informatica, BridgeWare (ETL), Business Objects, Oracle SQL Developer 4.0.3, PL/SQL Developer 11.0.2, SQuirreL SQL Client, Autosys and Maestro scheduler.

Programming Languages: PL/SQL, SQL, UNIX Shell Scripting, Perl Scripts, HTML, PERL, XML, Visual Basic Scripting, Java Scripts, ASP

Reporting: Crystal Reports, Axiom, OBIEE 11.1.1

Software Engineering: Erwin, Power Designer, MS Visual Sourcesafe, OLAP, ETL, MS Project, MS Visio, TOAD, SVN, Perforce, GIT

Methodology: Agile and Waterfall

Functional Areas: Banking & Finance (Regulatory reporting- BASEL III, CCAR, TLAC, USRSM, FINMA, PRA, IHC), Bond Insurance & Reinsurance, Investment Management, Health Insurance, Manufacturing.

PROFESSIONAL EXPERIENCE:

Senior Oracle Database Developer

Confidential, NYC, NY

Responsibilities:

• Database development and maintenance activities for CSAR.
• Interaction with Business Analysts to understand the requirements based on Business Requirement documents.
• Creation of technical specifications document and conducted technical walkthrough with QA team.
• Creation of back end database procedures and packages based on the technical specifications.
• Analysis of massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
• Extraction, transformation, validation and loading of data from different environment using SQL Loader, HP-Vertica and Informatica.
• Creation of Error logging and handling procedures/packages for logging and analysis of errors occurred during program execution.
• Perform unit testing and track the defects in HP ALM Quality Center/ TFS/ JIRA.
• Creation of SQL-Loader scripts to load legacy data into Oracle staging tables.
• Creation of SQL queries to perform Data Validation and Data Integrity testing.
• Reporting and tracking of defects using HP Quality Center.
• Fine tuning of procedures/SQL queries for maximum efficiency in various databases using Oracle Hint for Cost based optimization.
• Creation of complex SQL queries in HP Vertica - Analytic database.
• Creation of Unix shell scripts to integrate with Autosys JIL file for Batch Processing.
• Follow workflow process to deploy the source code from Development, SIT, UAT, and PROD environments.
• Work with Autosys/APS team to setup Autosys batch schedules for CSAR.
• Provide ROTA on-call support for CSAR.

Confidential, NYC, NY

Senior Oracle Database Developer

Responsibilities:

• Database development and maintenance activities for STAR, US-REG, LVE projects.
• Interaction with Business Analysts to understand Functional Requirement Specification based on Business Requirement documents.
• Creation of technical specifications document and conducted Technical walkthrough with QA team.
• Creation of back end database procedures and packages based on the technical specifications.
• The reports vary from Leverage Exposures, MIS, Tableau, Axiom, etc.
• Analysis of massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
• Extraction, transformation, validation and loading of data from different environment using SQL Loader.
• Creation of Error logging and handling procedures/packages for logging and analysis of errors occurred during program execution.
• Performed unit testing and track the defects in HP ALM Quality Center.
• Creation of SQL-Loader scripts to load legacy data into Oracle staging tables.
• Wrote SQL queries to perform Data Validation and Data Integrity testing.
• Reporting and tracking of defects using HP Quality Center.
• Fine tuning of procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Cost based optimization.
• Followed workflow process to deploy the source code from Development, FT, UAT, and PROD environments.
• Worked with Control-m team to setup control-m batch schedules for the various projects.

Environment: Oracle 11g, PL/SQL, SQL, Shell Scripts, Linux, Solaris, SVN, Control-M 7.0, TOAD, Putty, HP ALM Quality Center 12.5, Total Commander 8.0, Beyond Compare 4.0, Hadoop, Sqoop, HIVE, Impala, MS SharePoint, MS Lync/Skype, Oracle SQL Developer 4.0.3, PL/SQL Developer 11.0.2, OBIEE 11.1.1, Axiom, Agile(JIRA) and Finance Regulatory Calculation.

Confidential, NYC, NY

Senior PL/SQL Developer

Responsibilities:

• Involved in System Study, Requirement Analysis and Identify the Business Rules for the various applications.
• Developed Logical and Physical Database Design for the business rules used for the Bond Close applications.
• Prepared the Design Document, Functional Specification for the various applications.
• Participated in review meetings to finalize the design and functional documents to support business requirements.
• Developed Stored Packages, Stored Procedures, Stored Functions using PL/SQL, Dynamic SQL, Cursors, Collections and PL/SQL table for the Monthly/Quarterly/Yearly Bond close schedules, STAT/GAAP Earnings schedules, STAT/GAAP Projection, Reinsurance, NY STATE Exhibits, and Claims - Debt Payment Obligations (DPO) applications.
• Developed the database triggers to enforce audit rules and business rules in various applications.
• Created views, materialized views and external tables for the various modules based on the business needs from Finance Team / Reinsurance Team / Surveillance Team.
• Involved in optimization and tuning of complex SQL queries using explain plan, sql trace, TKPROF, optimizer hints for the various applications.
• Worked with DBA for creating the schema objects like Tables, Synonyms, Sequences, DB Triggers, and views. Involved with DBA in creating Table partitioning for the critical bond tables.
• Worked and fixed the root cause problems in Contingency Reserve, Reinsurer DDF, STAT Projection, and Reinsurers Bordereau applications.
• Analyzing the issues and finding out the root cause of the problem to get a permanent fix for the issues in various applications.
• Identified the bugs during integration and system testing and resolved the same.
• Followed the Change Request / Work Order process flow and installation procedures to Go-Live in production.
• Resolving the month-end issues and prepared a setup document for month-end bond close.
• Tested the functionality as per the client business requirements.
• Developed Unix Shell scripts for the various bond close jobs and schedules Developed VB Scripts and JAVA Scripts for the various applications.
• Created various types of reports using Business Objects Reports.
• Worked closely with Business and Support Teams during testing and transition phase.
• Coordinated with Off-shore development team in INDIA.

Environment: HP-9000, Windows XP, Oracle 11g/10g, PL/SQL,SQL, SQL * LOADER, SQL*Plus, Oracle Import and Export Utilities, TOAD, SQL Developer, ASP, VB Scripts, Java Scripts, Visual Basic, Business Objects, AutoSys, Unix Shell Scripting, XML, MS Visio, Finance, ERWin, MS Visual Sourcesafe, Bond Insurance & Reinsurance

Confidential, Dorchester, MA

Oracle Database Developer

Responsibilities:

• Worked on Small Business Credit Solutions (SBCS) and Credit Reporting Unit (CRU) projects at Confidential, Dorchester, MA.
• Worked with Business to understand their Functional Requirements and prepared the various requirement specification documents.
• Developed Logical and Physical Database Design for the business rules identified in the Requirement specifications.
• Prepared the Design Document, Functional Specification for the various applications.
• Developed Stored Packages, Stored Procedures, and Stored Functions using PL/SQL, Dynamic SQL, Cursors, Collections and PL/SQL table for the SBCS applications.
• Developed the database triggers to enforce audit rules and business rules in various applications.
• Created views, materialized views and external tables for the various modules based on the needs from Business Team.
• Involved in optimization and tuning of complex SQL queries using explain plan, sql trace, TKPROF, optimizer hints for the various applications.
• Worked with DBA for creating the schema objects like Tables, Synonyms, Sequences, DB Triggers, and views. Involved with DBA in creating Table partitioning for the critical tables.
• Tested the functionality as per the client business requirements.
• Followed the Change Request / Work Order process flow and installation procedures to deploy the source code in production.
• Involved in 24/7 production support for SBCS and CRU projects.

Environment: Sun Solaris, Windows XP, Oracle 9i, SQL, SQL * PLUS, PL/SQL,TIVOLI scheduler, Unix Shell Scripts, SQL * Loader, Rational ClearCase, TOAD, SQL Developer, Java 1.4.2, JSP 2.0, WebLogic 8.1, Servlet 2.3, Actuate Reports 8.0, Hibernate 2.0, Teradata SQL Assistant 6.1, ILOG JRules.

Confidential, Boston, MA

Oracle Developer

Responsibilities:

• Involved in System Study, Requirement Analysis and Identify the Business Rules for the various applications.
• Developed Logical and Physical Database Design for the business rules used for the Operational Data store (ODS), Member - ID-Replacement, Electronic Enrollment (EDI), and Web Enrollment applications.
• Prepared the Design Document, Functional Specification for the various applications.
• Developed Stored Packages, Stored Procedures, Stored Functions using PL/SQL, Dynamic SQL, Cursors, Collections and PL/SQL table for the Operational Data store (ODS), Member-ID-Replacement, HMO/POS/PPO product, Medicare Preferred, Clinical Services Data Repository (CSDR), National Provider Identifier (NPI), Electronic Enrollment, and Web Enrollment applications
• Developed the database triggers to enforce audit rules and business rules in various applications.
• Created views, materialized views and external tables for the various modules based on the requirements.
• Involved in optimization and tuning of complex SQL queries using explain plan, sql trace, TKPROF, optimizer hints for the various applications.
• Worked with DBA for creating the schema objects like Tables, Synonyms, Sequences, DB Triggers, and views. Involved with DBA in creating Table partitioning for the critical bond tables.
• Worked and fixed the root cause problems in Operational Data store (ODS), Member-ID-Replacement, Electronic Enrollment applications.
• Followed the Change Request / Work Order process flow and installation procedures to deploy the source code in production.
• Resolving the weekly issues and prepared a root-cause document as specified by Change Control board from QA Team.
• Tested the functionality as per the client business requirements.
• Developed Unix Shell scripts for the various jobs and schedules Involved in production support for the various applications.

Environment: HP-3000/HP-9000, Windows NT, Oracle 9i/8i, SQL, SQL * PLUS, PL/SQL, BridgeWare (ETL), Maestro scheduler, Unix Shell Scripts, SQL * Loader, WINCVS, TOAD, SQL Developer

Confidential, Boston, MA

Database Consultant

Responsibilities:

• Provided 24/7 production support for FIDW, MURDR and PACE applications.
• Performed day - to-day production support to Investment Data Group of FIDW, MURDR and PACE applications.
• Log production issues and track them to closure.
• Execution of assigned tasks.
• Follow documented procedures.
• Reporting/Turnover log.
• Revise and maintain all process documents.
• Escalation of any pending issues to the client.
• Participated in monthly / weekly reviews

Environment: Oracle8.x, PL/SQL, SQL*LOADER, SQL*Plus, Unix Shellscripts, vi, Finance, PERL, Banking & Finance, Sun Solaris, Unix, Windows 2000

Confidential, Boston, MA

Database Consultant

Responsibilities:

• Involved in preparing Technical Specifications for PACE outbound feeds module.
• Prepared Technical Specifications for developing advanced PACE & STAR Reports.
• Interaction with On - site Coordinator through weekly calls and e-mails.
• Developed an advanced STAR REPORTS using Visual Basic 6.0/ Data Dynamics ActiveReports 1.0/MS-ACCESS 97.
• Wrote SQL, PL/SQL, Unix Shell Scripts for PACE Outbound Feed module.
• Prepared Unit Test Cases & Unit Test Plan for the project.
• Prepared Post Mortem for closing the project.

Environment: MS Access, Oracle 8.x,ODBC,PL/SQL,SQL*Plus, Unix Shell scripts, Visual Basic, vi, Finance, Banking & Finance, SunOS 5.5.1, Oracle8.1.6, SQL, PL/SQL, Eagle STAR/PACE, Unix Shell Scripts, VI editor, Visual Basic 6.0, Data Dynamics Active Reports 1.0, MS-ACCESS 97, Autosys

Confidential, NYC, NY

Oracle Developer

Responsibilities:

• Prepared Systems Requirement Specifications (SRS) for the entire applications.
• Identified financial business activities & business rules, and prepared Functional (or Business Specifications) for the entire system.
• Designed Database structure using ERWIN database tool.
• Wrote coding for several modules using PL/SQL, Visual Basic 6.0 and UNIX shell scripts.
• Created several reports using Crystal Reports.
• Wrote several Stored Procedures, Functions, Packages, and Database Triggers.

Environment: Oracle 8i, Crystal Reports, PL/SQL, SQL * LOADER, SQL*Plus, Visual Basic, UNIX Shell Scripts, Finance, ER Win, MS Visual Sourcesafe, Insurance

Confidential, Phoenix, AZ

Oracle Developer

Responsibilities:

• Identified functional business activities & business rules, prepared Functional (or Business Specifications) for the project.
• Designed database structure using ERWIN database tool. Wrote coding for several modules using PL/SQL, Visual Basic5.0.
• Wrote several Stored Procedures, Functions, Packages, and Database Triggers. Wrote several reports using Crystal Reports.
• Prepared Unit Test Plan & Cases, Integration Test Plan & Cases, and System Test Plan & Cases for the Project. Involved in Testing of the all the modules of the project.
• Prepared Installation Document and User s manual for the Project.
• Handled DBA role in the project.

Environment: Oracle 7.x, Crystal Reports, PL/SQL, SQL * LOADER, SQL*Plus, Visual Basic, Unix Shell Scripts, Erwin, MS Visual Sourcesafe.