SUMMARY

• 11+years of experience in IT as an Oracle developer and Database designer like defining entities, attributes and entity relationship diagrams.
• Extensive experience in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, testing, implementation and maintenance.
• Proficient in writing PL/SQL stored procedures, packages, functions and triggers.
• Experience in writing Unit test plans and Unit testing.
• Experience in Oracle and Other Utilities/tool: TOAD, PL/SQL Developer, and Export/Import.
• Possess excellent communication and interpersonal skills with ability to work independently and as part of a team.
• Strong experience in writing SQL Queries, Views, Materialized Views, Cursors, Collections, Ref Cursor, Cursor variables, Dynamic SQL, Exceptions.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Experienced in using Exception Handling methods along with Pragma Exception init in order to associate our own created exception names.
• Knowledge of data modeling techniques includes virtually every flavor of Entity - Relationship (ER) modeling, Physical and Logical data modeling.
• MS EXCEL: Experience in validating and analyzing data in worksheets using sorting, filtering, creating PIVOT tables, charts.
• Expertise in data analysis, database design, data management, logical and physical data modeling using Erwin and Visio and in depth knowledge in building Relational Database Systems.
• Experience inBusiness Analysis, gathering of business requirements, functional and technicalspecification writing.
• Skilled in gathering user requirements by performing gap analysis and translating them into functional specifications.
• Very good knowledge of Data Extraction, Data Mapping, Data Conversion and Data Loading process using Informatica.
• Expertise in creating reports using Oracle Report Builder.
• Strong knowledge of Data Extraction, Data Mapping, Data Conversion and Data Loading process using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
• A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

PROFESSIONAL EXPERIENCE

Confidential, Lansing, MI

Sr.PL/SQL Developer

Responsibilites:

• Created PL/SQL stored procedures, functions and packages for moving the date from staging area to master tables.
• Created scripts for new tables with partitions and indexes, complex views and materialized views.
• Performed SQL, PL/SQL tuning and application tuning using various tools like explain plan.
• Used BULK collections for better performance and easy retrieval of data by reducing context switches between SQL and PL/SQL engines.
• Used set based data load concepts to load bulk data.
• Used Partition Exchange and Switch partitions techniques.
• Used Pragma Autonomous Transaction to avoid mutating table error.
• Created records, tables and collections for improving the performance by reducing the context switching.
• Created PL/SQL scripts to extract the data from the operational database into sample flat files using UTL FILE package.
• Worked on analyzing plans for various Sql’s and analyzed AWR reports to improve the performance of the database applications.
• Handled errors using exception handling extensively for the ease of debugging and displaying the error messages in the application.
• Responsible towards Technical Design of Enhancements /Requirements.
• Actively involved in meetings with client in resolving queries/issues.
• To give KT in terms of Product & Technical to new members of the team.

Environment: Oracle 12c, Oracle 11g, SQL* Loader, Toad, SQL Developer, UNIX.

Confidential, Detroit, MI

Sr.PL/SQL Developer

Responsibilites:

• Work on very high level concepts to a detailed understanding of business problems, component design and implementation.
• Conceptualize business and technical solutions and articulate ideas clearly and concisely.
• Define and create a variety of standard IT project deliverables throughout all project lifecycle phases. Also interface with and drive work with team members at different levels.
• Design and development of custom functionality for Wellness Care applications. Also maintenance of existing WCM applications and data components.
• Developing process to integrate the WCM applications with third party systems.
• Migrated the programs from CPODS to IMT/WCMDR, all database objects, Cron Jobs and other jobs for PPQ Project.
• Creating PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Identifying query performance and resolved them in given service level agreement level
• Identified and modified the existing SQL stored procedures, Packages, and Functions etc, to suite underwriting requirement
• Created entity relationship diagrams for the new/modified tables/views/materialized views using Erwin
• Maintained and enhanced custom code using PL/SQL, Oracle SQL.
• Worked on IM Report and letter using the MS Access and Excel software for IMO team.
• UNIX shell scripting for creating new Programs and utilities, updating existing capability as per business request. Also doing migration and deployment of code through a version controlling tool.
• Created scripts for new tables with partitions and indexes, complex views and materialized views.
• Worked on SQL*Loader scripts to load the data from the flat files to the staging tables.
• Performed SQL, PL/SQL tuning and application tuning using various tools like explain plan.
• Used BULK collections for better performance and easy retrieval of data by reducing context switches between SQL and PL/SQL engines.
• Used Pragma Autonomous Transaction to avoid mutating table error.
• Created records, tables and collections for improving the performance by reducing the context switching.
• Worked on testing several 11g features in Oracle and upgraded several instances from 10g to 11g.
• Handled errors using exception handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in Analyzing the Business needs of various customers of BCBSM.
• Responsible towards Technical Design of Enhancements /Requirements.
• Actively involved in meetings with client in resolving queries/issues.
• To give KT in terms of Product & Technical to new members of the team.

Environment: Oracle 11g/10g, SQL* Loader, Toad, SQL Developer, UNIX.

Confidential, Burbank, CA

Sr.PL/SQL Developer

Responsibilities:

• Generated SQL and PL/SQL scripts to install building database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms with oracle 10gdatabase.
• Created complex functions, stored procedures and packages by using PL/SQL.
• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Responsible working with user groups, analyzing reported problems, performing root cause analysis and presenting alternatives to correct the problem.
• Developed back end interfaces using PL/SQL packages, stored procedures, functions, Object Types, Pipelined functions, Oracle queues and used Collections, Bulk Collects to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from the database.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
• Involved in Dimensional modeling and developed the star and snowflake schemas.
• Designed and developed complex reports to meet end user requirements and deployed.
• Developed complex triggers in reports before/after for validation of user input.
• Performed unit testing and supported integration testing and end user testing.
• Extensively worked on production issues with effective defect management.
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
• Developed SQL’s for loading data from feed file to staging tables.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using tools like EXPLAIN PLAN etc.

Environment: Oracle 10g, Informatica 8.6, SQL * Loader, PL/SQL Developer, SQL Developer, SQL*PLUS, UNIX, Oracle Report Builder.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in Data modeling activities for EIS3 Capital Enhancement project.
• Interacting with Business users, gathering and analyzing requirements.
• Created system design document with high-level design and requirement document. Conducted walk through for requirement and system design.
• Created and modified SQL, PLSQL and SQL*Loader scripts for data conversions to load data from flat files into oracle interface tables.
• Developed SQL Queries to fetch complex data from different tables from different databases using database links and inserted the results into the newly developed tables.
• Created views, materialized views and synonyms for developers to hide the complexity and secure the direct access of DB Tables.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL asper the Design Documents.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, hints, indexing and Partitioning of tables.
• Worked on Data Modeling tool which includes both Logical and Physical Models.
• Generated UNIX Shell scripts to automate Batch Jobs and Loading Process.
• Developed complex reports like matrix reports, tabular reports for the systems using running totals, sub totals, grand totals and daily balance by using lexical parameters.

Environment: Oracle 10g, SQL developer, SQL Loader, TOAD, UNIX, Oracle Report Builder.

Confidential

PL/SQL Developer

Responsibilities:

• Reviewed requirements document to prepare project plan, design documents and implementation plan
• Created and managed primary data base objects such as Tables, Views, Sequences and Synonyms.
• Heavily involved with the Logical and Physical Design of the Database.
• Experience with usage and creation of indexes on the table for better performance of complex query.
• Involved in Creation of tables, partitioning tables, Join conditions, and correlated sub queries, for the business application development.
• Loading data from flat files into Oracle 9i database using SQL*loader and Unix script.
• Wrote Oracle database triggers, stored procedures, stored functions, and stored packages to perform various automated tasks to performed for better performance Used different joins, sub-query, nested query in SQL query, for reporting purpose.
• Involved in writing PL/SQL Store Procedures, Functions, Cursors, Ref Cursors Triggers and Packages.

Environment: Oracle 10g, PL/SQL developer, SQL developer, UNIX