SUMMARY:

• Over 10+ years of outstanding experience in Software Analysis, Design, Development and Maintenance, Database Recovery and Backup.
• Highly skilled in identifying Performance issues, Debugging, Performance tuning, Query tuning using Hints, EXPLAIN PLAN, TKPROF, SQL Trace, Indexing, Partitioning.
• Substantial Experience in writing Complex SQLs, PL/SQL Functions and Procedures, Packages, Cursors, Normalization, Database Design, creating Indexes, Triggers.
• Proficient in advanced concepts like Data Collections, Bulk Collect and Forall Loop, Dynamic SQL, Exception Handling, Global Temp Table, Nested Tables, External Tables, Advanced Queuing, Analytical Functions and REF Cursors.
• Experience in creating mappings/workflows to extract data from source database into various Business Entities using ODI (9i and 10g) as well as SSIS (BIDS).
• Excellent knowledge of Agile fundamentals, extensive experience of working in and managing Agile project groups, Task Planning, Workflow Scheduling, Team Mentoring, Customer - in-loop Development.

TECHNICAL SKILLS:

RDBMS: Oracle 10g/11g/12c, MS SQL Server 2008/2012, MySQL 5.7

Languages: SQL, PL/SQL, C, C++, C#, Perl, Shell scripting (Korn, Bash, C Shell)

Database Tools: Toad, PL/SQL Developer, SQL Developer, RMAN, SQL* Loader, Oracle E-Business Suite, Data Pump, Erwin, Toad Data Modeler, SSIS, ODI (ODI 9i and 10g), APEX 5.0

Operating Systems: Windows, UNIX (HP/UX, Solaris, AIX, Linux)

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr. Oracle Developer

Responsibilities:

• Development and support to all system interfaces and coordination with all project managers/teams/stakeholders to provide specifications for all core modules.
• Coordinate with various developers, project teams and analysts to prepare designs for new applications/existing application enhancements and document all processes to ensure effective evaluation of all applications.
• Analysis of all technical design documents and development of various PL/SQL packages to provide support to all application developers.
• Monitoring complex PL/ SQL packages and designing various relational database objects according to business needs.
• Conduct performance tuning using query Optimizer, AUTOTRACE, Execution Plans
• Analysis of Oracle sessions, tablespace usage and indexes.

Confidential, Scottsdale, Arizona

Sr. Database Developer

Responsibilities:

• Developed and maintained Maximsoft - the billing system for property and casualty insurance industry,
• Created complex PL/SQL packages and procedures, indexes, triggers to improve the Commissions Process which automated settlement of commissions between the agents, sub-agents and the company.
• Conducted performance tuning of complex queries using Explain Plan and TKPROF, thus reducing the execution time of daily processes including the Invoice and Printing Cycle.
• Provided production support to iReli and Accounting Design, perform code refactoring, data cleaning (scrubbing).
• Worked with Business Analysts and QA team to implement Agile development practices including project scoping, analysis, design, development, testing, and implementation of applications.
• Built Unit and Regression test cases using tools like PL/SQL Developer, Code Tester and managed packaging of applications to QA, UAT and Production Environments.
• Led the team of 4, for successful development of the Automated Recurring Payment Project.
• It involved development of several time-sensitive and complex processes dealing with critical information related to automated payments via Electronics Funds Transfer and insured bank account information.
• Improved the insurance agent-insured-company interaction and streamlined the overall payments process.

Confidential, Scottsdale, Arizona

Sr. Oracle Consultant

Responsibilities:

• Served as a technical lead for a team of 5 for design and development of the Operational Data Storage (ODS) using database objects and complex PL/SQL packages.
• Reverse migrated data from Confidential, processing it in ODS, migrating it to the downstream system AS/400
• Troubleshot, fixed and implemented bug fixes within tight deadlines for ODS.
• Researched emerging technologies, development tools and techniques to improve current applications, architectures and processes.
• Designed Data Warehouse tables and used Oracle Data Integrator(ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses
• Configured ODI modules and ELT tools and supported accessible applications
• Developed and edited ETL jobs in DW tables, Data Mart tables and Oracle Data Integrator.
• Conducted ETL development tuning, examined uncertain glitches, supported Integration testing conditions.
• Managed a team of 4 by performing Requirement Analysis, Modeling and database architectural solutions.
• Performed Data Requirement Analysis, Data Modeling and Data Architecture
• Developed multiple Stored Procedures using T-SQL & PL/SQL.
• Coordinated with the onshore and offshore teams, provided assistance and technical guidance to less experienced team members.
• Led multiple geographically dispersed teams, for successful implementations of various projects.
• Managed the successful completion of over 5 software development projects, involving multiple teams of Business Analysts, Development, QA and UAT
• Thrived working in a fast-paced challenging environment, learned and implemented new technologies and gained extensive experience in onsite-offshore business model, Coordinated with multiple off-shore teams

Confidential, Blacksburg, Virginia

Oracle Developer / Analyst

Responsibilities:

• Designed and implemented databases for every quarterly release of Confidential
• Implemented of ERDs using Toad Data Modeler.
• Worked in data compiling and analysis using PL/SQL and shell scripts
• Maintained Data (Loading, Transfer, Reorganization, Statistics analysis) using SQL* Loader, Data Pump Export and Import Utilities
• Created and maintained, worked on backup and maintenance of development databases using RMAN
• Upgraded Oracle 10g databases to Oracle 11g
• Provided training and production support to Customer Support Analysts after every release.
• Successfully developed an automated software framework for migration of the complete product database to a newer version which involved complex shell scripts and PL/SQL packages parsing an XML file and executing the DDL, DML, external executables and scripts in it. It also integrated Hudson to restore a test database using RMAN every hour, running the migration script in above process and checking it against a database state file.
• This automation helped Confidential save roughly over 500 annual man-hours previously needed by the development team to manually migrate and test a product database.

Confidential Norfolk, Virginia

Oracle Consultant

Responsibilities:

• Developed and maintained - Confidential, (an Electronic Health Records database product aimed at Maternal Child and Family Support Network) with extensive use of PL/SQL Web Toolkit, PL/SQL stored procedures and JavaScript