SUMMARY

• Oracle Certified Professional (OCP) with 9+ years of extensive experience in the complete Software Development Life Cycle (SDLC) covering Requirements Management, System Analysis, Architecture and design, development,coding, Testing and Deployment of business applications.
• Strong Data Modeling experience using ER diagram, Star Schema modeling, Snowflake modeling using tools like Sql data modular.
• Extensive experience writing Stored Procedures, Functions, Packages, PL/SQL routines, Database triggers, Shell - Scripting, unit testing integrity and also involved in complex backend data extraction, transformation and loading operations on oracle using INFORMATICA, SQL Loader and DATA PUMP utilities.
• Created multiple customized PL/SQL Procedures & Packages for various business needs, to transform data before the loading process, and to manipulate and sort data for the Reports specifications.
• Experienced in Query Optimization and Tuning using bulk collections, Hints, Explain Plan,sqltrace. Experienced in creating External tables, Uploading/Downloading data using SQL*Loader control files.
• Extensive experience in Oracle RDBMS9i/10g, design and developing Stored Procedures/Packages, Triggers, Cursors using SQL and PL/SQL.
• Performed database administrative functions like installation and configuration of database, creating database, partitioning of database, creating indexes.
• Strong experience in design and build medium to large scale client-server and n-tier applications using, Developer 2000, Forms/ Reports 6i/10g, PL/SQL and Stored procedures.
• Extensively used the oracle features like Ref cursors, bulk bind, for all, etc.
• Experienced working on logical and physical data models using ERWIN
• Involved in various activities like preparation of functional and technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts, related unit level and user acceptance testing.
• Established connectivity between front-end and back-end.
• Strong Analytical knowledge with database design and coding for performance.
• Strong experience in Oracle development using PL/SQL, Stored Procedures, Functions, Packages, schemas, DB Triggers, Merge Statements, Bulk Load, Dynamic SQL, Analytical functions, Materialized View, SQL*Loader, Data Pump, Export/Import and UTL FILE.
• Working and coordinating with various functional business partners and the Technical team to develop a technology strategy and roadmap by researching, evaluating and considering alternative technology options available in the marketplace and layout recommendations and implementation plans.
• Worked on various functional domains such as Payroll, HR and Insurance.
• Involved in all stages of SDLC (Software Development Life Cycle) from requirements gathering to production support using waterfall, Agile.
• Experience with working on high volumes of datasets with focus on details and accuracy & resolving data issues
• Experience in reporting tools such as Crystal Reports, Oracle Forms & Reports.
• A quick learner of new technologies and implements the same as per the business requirements.

TECHNICAL SKILLS

Databases: Oracle12c/11g/10g/9i/8.1.x, SQL Server 2016, MongoDB and MS Access.

Database Tools: PL*SQL, SQL*Loader, Oracle Forms, Toad.

ETL Tools: SQL Server Integration services (SSIS).

Reporting Tools: Crystal Reports, Oracle Reports.

Languages: SQL, PL/SQL, C, and UNIX Shell Programming.

Front-End Tools: Oracle Enterprise Manager, Forms Builder, Schema Builder.

MS Office Suite: Microsoft Word, Microsoft Excel, Microsoft Visio, Microsoft PowerPoint and MS Access.

PROFESSIONAL EXPERIENCE

Confidential, Glastonbury, CT

Lead Developer

Responsibilities:

• Developing PLSQL code in Oracle to create tables, views, functions, packages and stored procedures, triggers, cursors, indexes according to business needs and business expansion requirements.
• Writing complex SQL code for reporting and fine tuning queries for report.
• Working on ETL development using PLSQL tool named Oracle Developer.
• Creating complex views, materialized views on multiple tables as per customer requirement.
• Troubleshooting and resolving production tickets in a timely manner
• Attending weekly status meetings with the development, functional and project management teams to discuss status, project timelines and testing strategies.
• Writing code, adding/altering columns based on new ER diagram model developed to accommodate new requirements.
• Bug fixing and coordinating with operations, functional, business, testing, infrastructure and change management teams
• Working closely with business analysts to clarify requirements, troubleshooting issues, providing testing support and translating requirements into code
• Collecting and documenting requirements to create new forecasting models as per the new requirements.

Confidential

Responsibilities:

• Worked on Data modeling using ER diagram, Star Schema modeling, Snowflake modeling using tools like oracle sql modular.
• Created multiple customized PL/SQL Procedures & Packages for various business’s needs, to transform data before the loading process, and to manipulate and sort data for the Reports specifications.
• Query Optimization and Fine Tuning using bulk collections, Hints, Explain Plan, SQLTRACE. Creating External tables, Uploading/Downloading data using SQL*Loader control files.
• Design and developing Stored Procedures/Packages, Triggers, Cursors using SQL and PL/SQL on Oracle 10g, 11i and 12c.
• Performed database administrative functions like installation and configuration of database, creating database, partitioning of database, creating indexes.
• Worked on database creation, database migration and database Performance testing.
• Designed and built medium to large scale client-server and n-tier applications using, Developer 2000, Forms/ Reports 6i/10g, PL/SQL and Stored procedures.
• Extensively used the oracle new features like Ref cursors, bulk bind, for all, etc.
• Performed Data Migrations using SQL*Loader and PL/SQL scripts, UNIX SHELL SCRIPTS. Developed SQL Program to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Prepared functional and technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts, related unit level and user acceptance testing.

Confidential

Sr. Developer

Responsibilities:

• Load flat files by using SQL Loader according to the business requirements.
• Create External table to access flat files.
• Used UTL File to load data from flat files, modified data according to the business logic and saved back in to flat file OR into table.
• Created database triggers, cursors, procedures/functions and packages using PL/SQL according to business requirements.
• Written complex SQL (Sub queries and Join conditions), in PL/SQL.
• Experience in trace errors from procedures/functions, Packages and fixed.
• Used SQL Navigator to check Explain plan and Tune fun/proc and Packages to improve the performance.
• Involved in performance tuning (SQL, PL/SQL) using oracle tools Explain Plan.
• Created Sequences for automatic generation of voucher numbers and views for hiding.
• Created Indexes (Bitmap, Btree), DB Links, Materialize Views.
• Recompile oracle Forms6i and reports after reconstructing table structures.
• Working on both environments (windows, UNIX) with oracle.

Environment: Oracle 10g, SQL, PL/SQL, SQL Developer, UNIX, Shell scripting, JSP, PERL, and Windows XP.

Confidential

Oracle Developer

Responsibilities:

• Participated in analysis, design, development, testing, and implementation of various financial Systems using Oracle 8, Developer 2000 and PL/SQL.
• This system consists of the various functional modules: Loan approvals, Deposition of Cash/ Withdrawal of Cash, Change of personnel Information, Bank Details, balance Sheet, Customer Information Database.
• Define database structure, mapping and transformation logic. Creation of External Table scripts for loading the data from source for ETL (Extracting Transforming and Loading) Jobs.
• Wrote UNIX Shell Scripts to run database jobs on server side.
• Developed new and modified existing packages, Database triggers, stored procedure and other code modules using PL/SQL in support of business requirements.
• Worked with various functional experts to implement their functional knowledge into business rules in turn as working code modules like procedures and functions
• Created tables, indexes, sequences.
• Developing packages and stored procedures using PL/SQL.
• Extensively used stored procedures, functions and database triggers.
• Responsible for understanding, changes in business functionalities, add new elements in tables and accordingly enhancing PL/SQL stored procedures and triggers.
• Responsible for performing quality assurance, data analysis and unit testing.
• Remained on call for 24x7 to support scheduled jobs in production data warehouses

Environment: HP UNIX, Oracle 10g/12c, PL/SQL, Toad, UNIX Shell script, oracle forms and reports, Crystal Reports.