SUMMARY:

• 10 years of IT Experience Oracle Development experience including analysis, modeling, design, coding, testing, administration, maintenance of Oracle Database systems.
• Served as Technical lead and involved in project planning, resource allocation, calculating estimates for the defined scope of work, identifying and mitigating project risks
• Involved in the coordination with QA team, scheduling rollouts, analyzing and fixing production issues.
• Expertise in data analysis, database design, data management, logical and physical data modeling.
• Experience in system analysis, business, functional, technical requirements gathering, translating to design, system/data architect, data model, prototype, application development, quality control, software distribution, deployment, and production support.
• Solid experience in Oracle Database Programming using PL/SQL, SQL, Database Design (both Physical and Logical), Database Modeling, Query PerformanceTuning & Optimization.
• Experienced in backend database development using tools SQL*PLUS, SQL* Loader, Oracle Designer, Oracle TOAD with good understanding of RDBMS and Normalization Techniques.
• Experience in creating Procedures, Packages, Functions, Triggers views, Cursors, PL/SQL Collections and optimizing query performance and other database objects using SQL, PL/SQL.
• Proficient in using Cursors, Ref - Cursors, Table Functions, Functions, Collections, SQL Types and Sequences.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Enforcing data integrity using integrity constraints and database triggers.
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
• Experience in XML Data base functions to generate data in XML (XML Data ingestion)
• Tuning of SQL Queries to improve performance of a system. Identify root causes and resolve problems related to system functionality. Knowledge in Oracle implementations through full infrastructure and performance optimizations including I/O optimization, Testing and Implementation.
• Acquainted with Oracle E-business Suite 11i Technical modules like order processing, inventory, user management, Oracle discoverer
• Knowledge on Oracle Forms and Reports - creating and customizing the oracle forms, and generating the reports.
• Knowledge on creating the Data Feeds for the warehouses and Generating the reports.
• Knowledge on creating the Tableau Worksheets for client for the operational transparency.
• Working Experience on UNIX shell scripting.
• Experience in working in Agile environment, JIRA workflow for project management
• Easy adaptability to new technologies and new system environments.
• Troubleshoot and debug complex issues. Identify and implement solutions.

TECHNICAL SKILLS:

Programming Languages: PL/SQL, SQL, Pro*c/C++

Operating Systems: Windows, Unix

Databases: Oracle 9i/10g/11g

Tools: Used: Tableau, Oracle Form designer, Oracle Report designer, SQL Loader, SQL developer, TOAD, PL/SQL Developer, Oracle Workflow, Oracle Discoverer, ERVIN, Rational Rose Data modeler. eclipse.

Project Management tools: JIRA

Version Control Tools: CVS, GIT, SVN

PROFESSIONAL EXPERIENCE:

Confidential, Skillman, NJ

Environment: Application-End: Windows.Net 2.0, Microsoft .Net Framework 3.5Tool: Visual studio 2005Business-Layer-End: C#.Net 3.0Middle-Layer-End: JBoss Application server 4.0.5 GA, Java 5.0, Tool: Eclipse 3.4.0Database-End: Oracle10g,11g

Responsibilities:

• Served as the Technical lead in the project and involved in the project planning meetings, analysis, design, development and production support in Agile Development Framework.
• Involved in Creating the Frame Work for DB Scripts Generation for the New applications
• Involved in building the common components for the framework which is the base for any Blade applications in the Confidential workflow tools.
• Coordinated with the Business Analysts and the Data Management team to process application data.
• Involved in providing time estimation for the defined scope of the projects.
• Involved in designing of the database tables and Design Diagrams.
• Created PL/SQL Procedures, Functions, Packages and Triggers for data validation, data updating and retrieving of data using SQL XML.
• Tuned queries using EXPLAIN plan, SQL Trace, Oracle Hints, Optimizers and Indexes for better query performance.
• Developed monthly reports in SQL for upper management
• Developed Ad-Hoc reports and ULOG Reports for customers depending on the requirements.
• Worked on the unix scripts for the auto deployment process and copying the data objects from Prod to test environments.
• Involved in solving day to day production issues and coordinating with the Business Analysts and Data hub teams.
• Maintained the developed code using GIT.

Confidential, Skillman, NJ

Environment: Database-End: Oracle11g Tableau, QLIK

Responsibilities:

• As a team member in the project and involved in the project planning meetings, analysis, design, development and production support in Agile Development Framework.
• Identifying the report parameters for the each products.
• Creating the data feeds for the warehouse.
• Data extraction and Loading the data into GDI Tables.
• Creating the Vendor KPI reports
• Coordinated with the Business Analysts and the Data Management team to identify the key reports for the business decision
• Created Tableau Worksheets for the vendor assessment and Identify Process Time Analysis
• Created Tableau Worksheets for the Point in Time comparisons of the different document types and their average processing times in the peak seasons.
• Developed Weekly, monthly reports in SQL for upper management
• Developed Ad-Hoc reports and ULOG Reports for customers depending on the requirements.

Confidential

Environment: Business-Layer-End: C#.Net 3.0Middle-Layer-End: JBoss Application server 4.0.5 GA, Java 5.0, Tool: Eclipse 3.4.0Database-End: Oracle10g

Responsibilities:

• Served as the Team lead in the project and involved in the project planning meetings, analysis, design, development and production support
• Preparation of the Requirement documents.
• Preparing the Database Design documents for the given Requirements.
• Involved in designing of the database tables and Design Diagrams.
• Created PL/SQL Procedures, Functions, Packages and Triggers for data validation, data updating and retrieving of data using SQL XML.
• Writing the .ttl files.
• Generating the Weekly, Monthly reports and generating the xmls using SQL XML.
• Involved in Deployment and production support.
• Creating the deployment Scripts.
• Performance tuning using Oracle Hints, Query Rewriting, Optimizers and Indexes, Creating indexes .

Confidential, IL

Environment: Oracle Applications 11i E-Business suite

Responsibilities:

• As a Team Member Giving support to the project and the On-site people in the 24x7 environment.
• Creating and Customizing the Oracle Forms in the Order management Screens, pricing Screens using Oracle Form Builder.
• Creating the workflow using Oracle Workflow tool and creating the procedures and functions.
• Creating the Packages, Procedure, Functions, Triggers.
• Generating the reports using the oracle reports builder
• Implementing the security reviews in the Instance using the Oracle Discoverer and creating work books in the Discoverer.
• Creating and running the scripts using the QA load.
• Creating and deleting the users, clients and assigning responsibilities to them, resetting the passwords of the users and the sys admin work.

Confidential

Environment: ULTRA 10 WorkstationSun Solaris (Release 5.8).C++ on Sun Solaris.Pro*C++, PL/SQL Oracle 8i.

Responsibilities:

• As a Team Member involved in creating the Database model diagrams using IBM Rational Rose
• Involved in Requirement capturing and Analysis and preparing the requirement documents.
• Coding in Pro *C for Domain layer and DB Integration.
• Created PL/SQL Procedures, Functions, Packages and Triggers for data validation, data updating and retrieving of data.
• Involved in writing a simulator for the data feeds from the lower entities.
• Writing Unit test cases.