SUMMARY

• Over 8+ years of programming experience as an Oracle Technical Lead/ETL/PL/SQL developer and Forms/ Reports Developer.
• Excellent knowledge in Analysis, Design and implementation of Business Applications using Oracle Relational Database Management System (Oracle RDBMS).
• Have good experience in writing PL/SQL scripts for the database objects like tables, views, procedures, functions, packages, database triggers, indexes and sequences, Flashbacks.
• Good knowledge of ERWIN for Data modeling to design the logical model, physical model, Entity relationship.
• Good experience in generating forms using PL/SQL for data validation, processing Oracle Forms 9i/10g and also generating reports in Oracle Reports 9i/10g.
• Dynamic SQL, Query Optimizer, Nested Loops, External Tables, Nested Tables, LOBS.
• Used Hints for better performance of the queries and any procedures.
• Experience in application fine - tuning and database fine-tuning using Explain Plan and TKProf.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
• Have a good knowledge on NoSQL,MongoDatabase.
• Expertise in all phases of the Software Development Life Cycle (SDLC) including analysis, Physical and Logical design, Resource Planning, code development, testing, implementing and maintenance
• Expert in creating special Grouped reports, Cross Tab / Matrix Reports, Sub reports in main reports, Drill Down reports, mailing reports using Crystal reports.
• Good knowledge in design, coding and testing.
• Good knowledge of Informatica PowerCenter (9.1) in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse
• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.

TECHNICAL SKILLS

• Oracle 10G
• Unix Administration
• SQL plsql
• Databases
• Data Analysis
• Database Management
• Performance Improvement crys

PROFESSIONAL EXPERIENCE

Senior Oracle developer/Technical Architect

Confidential

Responsibilities:

• Working on a Project called NICS (National Instant Criminal background check system.)
• Responsible for writing high level document about NICS process.
• Did analysis on the data flow of NICS to understand the application.
• Involved in assisting other developers to optimize the sql queries using EXPLAIN PLAN.
• Written a framework to give delta among three systems (NICS, HERDS, and MHARS).
• Created a high-level architecture documents for NICS process.
• Created packages, procedures, functions to meet the Business requirements.
• Developed Oracle Framework for a project called ICOA, to automate the data flow from GUI to database with some transformations.
• Suggested some changes to the existing packages to include some more logging and proper exception blocks.
• Used Rollup, CUBE functions to achieve the results as per the business requirements to generate reports.
• Used Crystal reports to create reports for Business user's team.
• Used Analytic function Over partition by order by clauses for calculations along with RANK.
• Worked with AVG, ROWNUM, TRIM, LPAD, RPAD and some other Aggregate functions for performance and data matching
• Involved in mapping the data from one table to another.
• Good knowledge of ODI tool.
• Tested and debugged Oracle PL/SQL packages.
• Used GECS and ESB for scheduling the jobs to run at a certain timeframe.
• Created Views and Synonyms for the database objects.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Worked on Unix platform to sftp the created files and used grep, vi and awk commands to find the file content and properties.
• Used Microsoft TFS for Check out/check in the scripts.
• Worked with GECS/ESB team to schedule the jobs.

Environment: Oracle 10g/11g, SQL, PLSQL, TOAD, Unix, ESB, GECS, CVS, Unix, Data stage(7,8.1,8.7,9.1), HP Quality Center, TFS.

Tech Lead/Oracle/ETL developer

Confidential

Responsibilities:

• Worked as a Tech Lead for couple of projects.
• Involved in approving SDLC aritifacts.(SIT plan, DESIGN, Requirements, SOL REVIEW)
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement and used appropriate joins.
• Used Sql*Loader(ETL) Extensively for loading files(ASCII) into Database tables.
• Developed complex packages and procedures and functions using Record types.
• Worked on SQL Tuning using Explain Plan. Tuned SQL Queries and plsql objects.
• Used Analytic function Over partition by order by clauses for calculations along with RANK.
• Worked with AVG, ROWNUM, TRIM, LPAD, RPAD and some other Aggregate functions for performance and data matching
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Involved in mapping the data from one layer to another.(staging, source, target mappings) as per Line of business at Enterprise level(EDW).
• Created Views and Synonyms for the database objects.
• Assisted the QA team in performing Load Testing and Performance Testing.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Involved in Data modelling to come up with physical and logical models to create table and establish the entity relationship using ERWIN.
• Got Exposure to Sybase database, was supporting Sybase team.
• Analyzed integrity constraints during development of physical model using ERWIN.
• Developed complex packages and procedures and functions using Record types.
• Worked on Datastage tool and used Plsql Frameworks to implement ETL concepts (File loading to tables).
• Worked on priority levels tasks using Unicenter Service Desk software.
• Good knowledge of control-M jobs.
• Extensively used Execute Immediate for building the Dynamic Sql based on the parameters passed.

Environment: Oracle 10g/11i, SQL, PLSQL, TOAD, Unix, Data stage (7,8.1,8.7,9.1), WinCVS, HP Quality Center, WinSCP

Plsql/Netezza developer

Confidential

Responsibilities:

• Worked on Framework called QBM(Query Builder Merge) internal to IMS.
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Used NZSQL command to create database objects like Tables and to run queries.
• Used NZLOAD command to load the data into the tables using control file.
• Used some of the Built-In functions (like Upper, case, decode, NVL) in netezza to meet the requirements.
• Attended Business meetings and walkthroughs to discuss the status of the project.
• Written shell scripts to generate a report as per Business Requirements.
• Written shell scripts to send an email after the job Failure or Success.
• Worked on the Config properties file to set up the database connection and changed accordingly to reflect the same in the code.
• Assisted the QA team in performing Load Testing and Performance Testing.
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Scheduled jobs using Mainframe Code.
• Good knowledge of Mainframe jobs.
• Extensively used Execute Immediate for building the Dynamic Sql based on the parameters passed.

Environment: SVN, Netezza, Mainframe, Oracle 10g/11i, SQL, TOAD, Unix.

Oracle/ETL developer

Confidential

Responsibilities:

• Wrote complex SQL queries to retrieve information from the databases depending on user requirement and used appropriate joins.
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Developed complex packages and procedures and functions using Record types.
• Worked on SQL Tuning using Explain Plan.
• Created Views and Synonyms for the database objects.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Assisted the QA team in performing Load Testing and Performance Testing.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement and used appropriate joins.
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Involved in mapping the data from one layer to another.(staging, source, target mappings) as per Line of business at Enterprise level(EDW).
• Involved in Data modelling to come up with physical and logical models to create table and establish the entity relationship using ERWIN.
• Analyzed integrity constraints during development of physical model using ERWIN.
• Developed complex packages and procedures and functions using Record types.
• Got familiar with Datastage tool and WinCVS.
• Worked on priority levels tasks using Unicenter Service Desk software.
• Good knowledge of control-M jobs.
• Extensively used Execute Immediate for building the Dynamic Sql based on the parameters passed.

Environment: Oracle 10g/11i, SQL, PLSQL,, TOAD, Unix, Data stage, WinCVS, HP Quality Center

Oracle Developer/Reports developer

Confidential

Responsibilities:

• Involved in requirement gathering and development of the application.
• Involved in migrating all the database objects (Tables, Views, Triggers, Procedures, Functions, and Packages) from 10g to 9i.
• Involved in migrating Oracle Forms from 10g to 9i
• Involved in migrating all the UNIX shell scripts from one server to another.
• Generate SQL scripts for altering, inserting, creating the tables.
• Created Views and Synonyms for the database objects.
• Assisted in scheduling the everyday activity of data purging using CRON jobs.
• Migrated forms from one server to another using the version control tool VSS (Microsoft Visual Source Safe).
• Used the WITH clause to rewrite the Sql query for faster Performance.
• Performed debugging of the PL/SQL codes using the DBMS OUTPUT.
• Performed debugging in Oracle Forms using MESSAGE.
• Extensively used 'vi' editor in UNIX.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation of the code.
• Assisted the QA team in performing Load Testing and Performance Testing.

Environment: Oracle 9i/10g, SQL, PLSQL, TOAD, UNIX.

Oracle Programmer Analyst

Confidential

Responsibilities:

• Involved in requirement gathering and development of the application.
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement and used appropriate joins.
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Developed complex packages and procedures and functions using Record types.
• Used UTL FILE to import the data from database tables to flat files.
• Used External Tables for Data Conversions to populate the data from spreadsheets to a base table.
• Created a DBMS SCHEDULER job to write the data from a table to a flat file on a daily basis.
• Worked on SQL Tuning using Explain Plan.
• Worked with Analytical functions like OVER, LAG, LEAD, PARTITION BY and familiar with the MODEL, RANK etc.
• Familiar with RazorSQL tool(for working with Pervasive databases, a Pervasive database browser, an SQL editor, Pervasive import and export tools, a query builder, and an edit table tool).
• Extensively used Strong Ref cursors for manipulating the large amount of data and reducing the coding and error margin and wrote some scripts in UNIX.
• Used the WITH clause to rewrite the Sql query for faster Performance.
• Created indexes on some of the columns on the tables to increase the application's performance.
• Developed Landscape and portrait Reports using Oracle Reports 10g.
• Created Tabular reports, Group Above reports for the Clients as per the requirement.
• Generated Spread Sheet, XML, PDF format reports.

Environment: Oracle 9i/10g, SQL, PLSQL, Oracle Forms and Reports (6i, 9i, 10g) SQL*Loader, TOAD.