SUMMARY:

• 13 years of extensive experience in maintaining, delivering and managing complex IT solutions using Oracle SQL, PL/SQL(8i/9i/10g/11g/12c), Unix, Oracle Forms and Reports.
• Experience in all phases of the SDLC (Software Development Life Cycle) of waterfall and agile methodologies from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience in data modeling includes Conceptual,Physical, Logical and Dimension data modeling using Erwin, Visio, Toad.
• Worked closely with domain experts, business analysts to ensure Conceptual, logical physical, Dimension database models are in compliance with enterprise standards and documented.
• Worked on Forward and Reverse Engineering to analyze Object dependencies and prepared, executed DDL scripts for all schemas.
• Reviewed existing Logical, Physical database design and suggested modifications to improve efficiency and performance.
• Expertise in creating new DB Objects and maintaining existing DB objects like Tables,Views,Indexes,Types,
• Sequences,Synonyms,Constraints, DB Links,PL/SQL procedures,functions,Packages,Triggers.
• Extensively used constraints and database triggers(Before/After/Compound triggers) to enforce data integrity.
• Expertise in identifying performance bottlenecks and improving the application performance dramatically by using various performance technics including views,Explain plan,TKPROF,Indexing,Hints,table Partitioning.
• Developed and Modified complex PL/SQL packages, functions,Procedures as per client requirements to make new enhancements or to resolve problems.
• Experience in loading high volume of data using PL/SQL packages.
• Identified several SQL and PL/SQL bottlenecks using DBMS PROFILER, explain plan, auto trace.
• Proficient in advance features of Oracle for PL/SQL programming like using Cursor variables, Ref. cursors, Varrays, Nested tables and Dynamic SQL.
• Experience in writing UNIX shell scripting for sftp,batch processing and automation of various Oracle Database jobs.
• Extensively worked on Data migration, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses.
• Experience in working as Individual contributor.
• Experience in Working on multiple concurrent projects, prioritization the tasks and met the tough project deadlines.
• Experience in leading team and mentoring them.
• Participated in meeting with Business users to gather the requirements
• Involved in code reviews and suggested changes to ensure code meets client business standards.
• Maintained Object scripts versions using version controls CVS,PVCS,Clearcase,VSS and created label to them for production deployment.
• Involved 24/7 Production Support
• Involved in code deployment activities and sanity check in UAT and Production environment
• Domain experience in Financial, Supply Chain Management, Logistics, Insurance.

TECHNICAL SKILLS:

Programming Languages: Oracle(9i/10g/11g/12c) SQL, PL/SQL

DB IDE Tools: SQL Plus, Toad, PL/SQL Developer, SQL Navigator

UI: Oracle Forms6i

Reporting Tools: Oracle Reports6i

Scripting Languages: UNIX Shell Scripting

Data Modeling Tools: Erwin, Toad,Visio

Version Controls: CVS,PVCS,Clearcase,VSS

PROFESSIONAL EXPERIENCE:

Confidential, TX

Technology/Tools: Oracle (12c) SQL, PL/SQL,Toad,PL/SQL Developer,SQL Developer,Erwin

Senior Application Developer

Responsibilities:

• Involved in Logical, Physical, Dimension data modeling design of Online Customer Service Center(OLCSC) for BOS (Back office systems).
• Prepared DDL, DML scripts and executed them
• Prepared functional design documents, requirement document and technical design documents .
• Implemented ETL process using Oracle PL/SQL packages, procedures and functions to capture large millions of legacy data and loaded it into the new BOS system.
• Extensively used analytical functions and Materialized Views for reporting purposes.
• Implemented multi - threaded framework to schedule migration jobs with optimum threads.
• SQL Query Optimization issues fixed using Explain Plans, Hints,Parallel process and PL/SQL performance issues fixed using Bulk collect, forall.
• Created SQL queries to validate and reconcile data in tables.
• Involved in DB environment set up for QA testing.
• Created test plans and executed during development phase to ensure the code meet business requirements.
• Interacted with testers to resolve any issues or defects during testing and verification.
• Worked on Integration testing and User Acceptance Testing (UAT).
• Involved in root cause analysis of defects and fixing those defects.
• Checked-in DB Objects latest versions in ClearCase.
• Involved in code deployment activities and sanity check in UAT and Production environment.
• Involved in 24/7 production support

Confidential, NY

Technology/Tools: Oracle(11g) SQL, PL/SQL, Unix,SQL Navigator,Erwin

Team Lead(PL/SQL)

Responsibilities:

• Involved in Design of ER Diagrams for new and existing change requests.
• Prepared Technical Design documents based on functional documents provided by business team.
• Created PL/SQL Procedures, Functions, Packages,Views, Materialized View,Triggers.
• Improved the application performance significantly by tuning SQL Queries and PL/SQL program units .
• Analyzed the application enhancement requests came from client and provided suggestions to the team
• Involved in code reviews to ensure applications meet coding standards.
• Created scripts in Unix environment for daily and monthly audit reports of the daily transactions and monetary adjustments.
• Created Unix scripts for file transfers using sftp.
• Worked with off-shore team for development and Testing activities.
• Checked-in DB Objects latest versions in VSS.
• Involved in code deployment activities and sanity check in UAT and Production environment.
• Followed ITIL-V3 process for production support activities.
• Single Point of Contact for all production support activities.

Confidential

Technology/Tools: Oracle(11g) SQL, PL/SQL,PL/SQL Developer,Erwin

Senior Application Developer

Responsibilities:

• Collected requirements from business users and prepared functional and technical documents.
• Designing and development of complex PL/SQL packages, procedures, functions and SQL scripts as per business requirements.
• Debugging the issues and implemented bug fixes and enhancements within tight deadlines.
• Involved in Unit Testing and Integrated Testing with multiple Components.
• Used advance features of Oracle for PL/SQL programming like cursor variables, ref. cursors, varrays, nested tables and Dynamic SQL.
• Checked-in DB Objects latest versions in CVS.
• Participated in change control reviews for the code changes that go into production.
• Involved in code deployment activities and sanity check in UAT and Production environment.
• Provided production support and 24/7 support for resolving the critical production issues.

Confidential

Technology/Tools: Oracle(10g) SQL, PL/SQL, Toad,Viso

Senior Software Engineer

Responsibilities:

• Involved in requirement analysis,Datamodel, preparing high level, low level technical documents.
• Created conceptual models using Erwin and conducted several walkthrough meetings with Architects,BAs for approvals and also conducted team meetings for creating logical and physical models from the conceptual model.
• Reverse Engineered the existing database structure to understand the existing data models so that any changes in corporate would synchronize with current model.
• Created new DB Objects (tables,views,sequences,synonyms,dblinks etc) and PL/SQL procedures, functions, packages,triggers as per business requirements.
• Daily status update in scrum meeting.
• Created indexes on table columns to improve SQL query performances.
• Identified high resource consumed long running SQL queries and re-wrote them to use less resource consumption with quick query response.
• Created shell scripts for batch process and automated these scripts using Cron.
• Defined indexes on various tables to improve the performance of the queries for reporting purpose.
• Wrote complex packages for batch processes.
• Checked-in DB Objects latest versions in CVS and labeled scripts for production deployment.
• Involved in code deployment activities and sanity check in UAT and Production environments.

Confidential, CA

Technology/Tools: Oracle(9i) SQL, PL/SQL, Toad

Senior Software Engineer

Responsibilities:

• Analyzed the business requirements and converted these into workflow and logical processes.
• Created Design, Technical, Installation and Requirement specification verification documents for both new and existing projects.
• Created PL/SQL packages,Procedures,Functions,Triggers, collections, ref-cursors to pass the data between Java application and the Oracle database.
• Loaded data from flat files into Tables using SQL*Loader utility.
• Performed Unit testing, integration and System testing to ensure the application meets business requirement.
• Deployed DB objects into all environments in all phases (DEV, QA and PROD) of project
• Checked-in DB Objects latest versions in PVCS and labeled scripts for production deployment using Quintana.

Confidential, CA

Technology/Tools: Oracle(10g) SQL, PL/SQL, Toad

Software Engineer

Responsibilities:

• Involved in requirement analysis, preparing high level, low level technical documents.
• Created Oracle PL/SQL Procedures, functions, packages.
• Application tuning by analyzing table, index statistics.
• Wrote complex packages for business logic using bulk binding and partitioning.
• Performed Unit testing, integration and System testing to ensure the application meets business requirement.
• Interacted with subject matter experts and business analysts to resolve any issues related to the requirement.

Confidential

Technology/Tools: Oracle(9i) SQL, PL/SQL,Forms,Reports,Toad

Software Engineer

Responsibilities:

• Worked closely with functional team to understand business needs and documented the requirement.
• Developed new oracle forms as per the business requirement.
• Involved in implementation of new Oracle PL/SQL Procedures,functions,packages.
• Developed new oracle reports and modified existing reports as per business requirement.
• Generated reports for management to analyze the business and make decisions.
• Wrote many adhoc SQL queries for data analysis and debugging, fixing issues.
• Identifying and debugging issues, fixed, and implemented bug fixes and enhancements within tight deadlines
• Checked-in DB Objects latest versions in VSS.
• Involved in production support activities.