SUMMARY

• Over 7 years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle, SQL, PL/SQL.
• Strong knowledge in creating Oracle Stored Packages, Procedures, and Functions.
• Writing code for enhancing existing programs or developing new programs
• Experience programming PL/SQL batch environment utilizing large tables and high transaction throughout requirements.
• Knowledge on DBA activities like creating users, granting and revoking objects privileges on database objects
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning.
• Proficient in debugging PL/SQL packages to troubleshoot issues.
• Expertise in data analysis, data warehousing, ETL techniques and Data conversion from flat files to oracle using SQL * LOADER
• Experience in ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center.
• Experience in application development like bulk collections, Dynamic SQL, Autonomous Transactions
• Experience in Back ends Testing of the applications by executing complex SQL commands.
• Ability to work with offshore team.
• Experienced in data retrieval from multiple tables using joins, writing stored procedures, cursors.
• Worked extensively on PARTITIONS to enhance performance and archiving of a DW.
• Knowledge on TKPROF and EXPLAIN PLAN.
• Experienced in working with many complex SQL queries with joins, date functions, inline functions, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub - queries and analytical queries to generate reports.
• Expertise in all the phases of System development life Cycle (SDLC)
• Work Experience in UNIX environment.
• Can Collaborate with the Product Management to understand and deliver the right solutions for business needs
• Comfortable in working with a fast-paced, professional development team environment.
• Excellent verbal and written communication skills and the ability to interact professionally with a diverse group, including executives, managers, and subject matter experts.

TECHNICAL SKILLS

Databases: Oracle 10g, MS-SQL Server, MS Access, MySQL

Scripting: SQL, PL/SQL, Unix DB2, T-SQL, PERL

Languages: C, C++, HTML, XML, PHP

Reporting Tool: Business Objects, Crystal Reports

ETL Tool: Informatica

Query Tools: TOAD, SQL Navigator, SQL* PLUS, OBIEE

Operating Systems: Windows 2000/XP,LINUX 9.2/9.3

GUI: Oracle Forms 9i and Reports 9i

Other Tools: SQL*Loader

PROFESSIONAL EXPERIENCE

Confidential, Fredrick MD

Sr Pl/SQL Developer

Responsibilities:

• Understanding the source/target systems and developed CDC( change data Capture) to sync source and target
• Used advanced PL/SQL concepts like Collections(Index-by tables, Nested tables, Variable arrays)
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
• Run Batch files for loading database tables from flat files using SQL*loader.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic
• Data Conversion for data quality issues and reporting them to client team to fix the data usingOracleData Cleansing techniques
• Lead role in design development and deploymentof ETL process to Sync source and Target.
• Used concepts like Static & Dynamic (REF) Cursors, Dynamic SQL
• Developed PL/SQL Functions, Cursors for various calculations in the application.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Explain Plan, Analyze, Hints to tune queries for better performance and extensively used Indexes
• Tuned CDC performance to complete a cycle in 22 minutes from 36 minutes to process 75K records.
• Created PL SQL Packages to develop job scheduling mechanism as an alternative to AUTOSYS job scheduling.
• Used Bulk Binds and Records processing to improve the performance of processing.
• Used constructs such as BULK COLLECT, FOR ALL to reduce context switching while using collections.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Error handling using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Partitioned the fact tables and materialized views to enhance the performance.
• Using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.

Environment: Oracle 11g, Oracle Forms 10g, SQL, PL/SQL, SQL Developer 3.0.03, UNIX, TOAD, Perl. SubVersion (SVN).

Confidential, Seattle WA

PL/SQL data warehouse engineer

Responsibilities:

• Analyzing and reviewing Business and Functional Requirement documentation. Converting User Requirements into formal Technical specification and Interfacing with clients.
• Design and development of Oracle packages, procedures, programming and data structures.
• Designing, implementing, and operating solutions to flow data from production systems into the data warehouse and to extract data from the warehouse to be used by end-user facing applications.
• Creating and maintaining SQL*Loader routines for loading data
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Working on different transformations like source Qualifier, lookup, Expression, Aggregation, Update Strategy, Sequence generator and Router transformations
• Reverse engineering existing Informatica workflows, sessions and mappings, document process logic for future reference
• Using SSIS built high performance data integration solutions, including extraction, transformation and loading (ETL) packages for data warehousing.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS
• Responsibilities include design, development, testing & Implementation of EDW daily receive pre-processing (UNIX Shell Scripts), de-normalization for reporting purpose, data security issues, development of ETL Process, development of ETL extract process, testing of data for the developed modules.
• Experience in Installation of high availabilityRACenvironment (2, 3 and 4 node clusters).
• Supported Production Database Oracle RAC4 Node with High Level Evaluation, performance tuning, instance recovery, load balance
• Full lifecycle experience in multi-tiered and multi-server application architecture usingPL/SQLon UNIX platforms Strong analysis skills
• Work with team to achieve timely resolution of all production issues meeting or exceeding Service Level Agreements
• Responsible for leading the Support activities and managing the offshore team

Environment: Oracle 11g, SQL Developer, Sql *Plus, UNIX, Perl, Toad, SSIS,MS office, HTML, Informatica 8.6.1

Confidential, Chapin, SC

Sr.PL\SQL Developer

Responsibilities:

• Monitoring existing SQL code and performance tuning if necessary.
• Created indexes for retrieving data quickly.
• For better performance used EXPLAIN PLAN, HINTS to tune queries.
• Created Temporary Tables in procedure to achieve performance issues.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Involved in report generation using Crystal reports.
• Developing Pro*C programs to call from Unix scheduling process
• Wrote Pro*C programs to handshake data with other projects
• Worked with workflow team to support existing PL/SQL code and provided solutions to assigned tasks for various enhancements and defects.
• Wrote complex database modification scripts for hot fix solutions.
• Wrote packages for unit testing using PL/SQL and debugged using DBMS debug packages and other PL/SQL developer tools.
• Created views to apply security policies and also created materialized views to achieve performance gain.
• Worked with DBA for performance tuning and space management.
• Documented technical specifications and did knowledge transfer with other departments and team members.
• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Dealt with heavy weight tables which are appended with millions of records daily.
• Moved / manipulated data from one environment to another for development, testing and debugging of application.
• Involved in Data Loading and Data Migration (ETL).
• Used SQL*Loader to load data from flat files and Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.

Environment: Oracle 10g, PL/SQL Developer, PRO*C, SQL*Plus, SQL Loader, Toad, Forms 6i, reports 6i.

Confidential, Richmond, VA

PL\SQL Developer

Responsibilities:

• Extensively worked on Performance tuning by using Explain plans and various hints.
• Worked on table partitioning (Range and List) and deploying local indexing on table partitions.
• Involved in Extraction, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 10g database.
• Increased efficiency of code, by usingbulkcollection techniques to handle large amounts of data
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Created Stored Procedures, functions and Packages in Oracle 10g using SQL and PL/SQL for the Audit Trail using Oracle 10g as backend.
• Development and testing of various Reports (10g) and associated Forms (10g) using Oracle Developer Suite 10g.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Worked on Partitioning and indexing concepts (Local and Global) indexes on partition tables.
• Worked on Data warehouse design, created star schema, dimension and fact tables.
• Interacted with end users and functional architects for mapping the legacy data to the Oracle tables.
• Involved in testing all forms, PL/SQL code for logic correction.
• Designed and developed ETL mappings and data extraction and loading jobs using SQL*loader, Pl/SQL.
• Studied the existing OLTP system(s) and interacted with Data Architect regarding facts, dimensions and star schema representation for the data mart.
• Customized the properties for the users in the embedded options based on the privileges using Interactive reporting.

Environment: Oracle 10g, Forms 10g & Reports10g, ASP, SQL PLUS, PL/ SQLSQL*Loader, UNIX Shell Scripts, Data Stage, Business Objects, SQL Navigator, TOAD.

Confidential, Denver, CO

Oracle Developer

Responsibilities:

• Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
• Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
• Created PL/SQL Packages for easier application design and improved Performance.
• Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables.
• Developed Unix Shell Script as required.
• Migrated data from Flat Files to Oracle database using SQL*Loader.
• Involved in dimension modeling of the data warehouse and data marts.
• Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views
• Created Jobs in SSIS and was responsible for ETL job scheduled to run daily, weekly and monthly.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Performed complex data manipulation using foreign functions written in C and PL/SQL language.
• Performed tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.
• Created reports using Interactive Reporting for the users so that they can interact among each other without any IT support.
• Fixed customized dashboards in the charts and associated with the slider control using Interactive reporting.
• Involved in trouble-shooting production database problems and report problems.
• Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.

Environment: PL/SQL, C, T-SQL, SSIS, SQL*Plus, SQL*Loader, Oracle 9i, UNIX, Windows.

Confidential

Software Programmer

Responsibilities:

• Responsible for the design, development and import of invoice information into Oracle Receivables.
• Maintaining concurrent manager and assigning priorities.
• Creating users & modifying the privileges for users.
• Creating appropriate roles and assigning it to users.
• Migrated the data from excel sheets, text files into the respective Oracle Database tables using SQL *Loader scripts.
• Loaded data into oracle tables using SQL*Loader and dbms utility package.
• Responsible for customization of reports according to client requirement in key indicator report and Distribution detail report like Account Status Report, Transaction Detail Report, etc.
• Created the data flow diagrams using Microsoft Vision.
• Registration of new forms, Creation of concurrent executable and concurrent programs for reports, Opening up Descriptive Flex fields.
• Written scripts to customize customer needs.
• Extensively worked in the scheduling and monitoring of mappings in Information Warehouse.
• Extensively worked in the analysis and tuning of the Application code (SQL).
• Monitor all the Production, System Test and developments boxes for any errors in the logs and fix them as needed.
• Was responsible for tuning the SQL statements using Explain Plan, SQL Trace, TKPROF, Clusters and Optimizer Hints.
• Used UNIX shell scripts to run the batch PL/SQL procedures.

Environment: Oracle8i, Forms & Reports6i, SQL Loaders, SQL, PL/SQL, SQL* Plus, Toad, HTML, UNIX.