SUMMARY

• Currently holding an OCP (ORACLE CERTIFIED PROFESSIONAL), has over thirteen years of experience in data warehouse decision support system, On - line Transaction Processing, and Web-based multi-tier application design, and development in oracle database.
• Extensive experience writing Oracle PL/SQL code including procedures, functions, triggers, and packages to support extraction, transformation and loading of source data into target tables of Federated star schema multidimensional (DWH) model. In addition
• Experience with the full system development life cycle including requirements gathering, Analysis, process design using Erwin and Rational Rose to implement the physical ER diagram, and develop PL/SQL using Native Dynamic SQL processing such support DDL directly inside a block. He performed extensive SQL TUNING of programs utilizing explain plan, auto-trace, sub-query factoring, materialize views, and analytic functions. W ritten preproduction test scripts for Unit testing, regression tests, and user acceptance testing and also, designed development and execution of test plans using Mercury’s Win-runner, and development of end-user documents.

TECHNICAL SKILLS

• PL/SQL,ORACLE 12C 11g, 10g, 9i, 8i
• MS Access 2000
• SQL*Plus
• SQL Navigator 4.5
• SQL*LOADER
• TOAD 9.7.2
• UML Design
• Load runner 5.0
• Winrunner
• Informatica 8.6
• OEL(oracle enterprise Linux)
• Unix
• Online Analytical Processing (OLAP)

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

• Currently on a regulatory reporting project at Santander Bank in Boston re-designing the CCAR oracle modules by using PL/SQL back-end procedures in packages.
• The task includes working with the business community and creating partitioned and sub-partitioned tables and creating materialized views for data replication in distributed databases in order to build custom transactional database applications.
• Helped implement and speed-up queries by changing from complete refresh to PCT(partition change tracking) for performance.
• Changed Materialized views queries into collections for bulk-load and forall DML to further meet the coding standardization of the project and for extraction of data from multiple upstream. He is used his expertise to eliminate duplicate records using
• Analytical functions as a mechanism to ensure the sum outstanding profit and percentage outstanding amount is correct.

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

• Worked as a senior developer for small clients such as Saint Louis Bread Company and Confidential,an oracle developer on enhancing code improvement in oracle procedures and packages using Ref cursor to be invoked by Work Day application. He wrote functions that with result cache option and PGA based functions to measure the performance of the modules to fetch data from the database.
• Performed performance tuning using DBMS PROFILER, SQL ACCESS ADVISOR and wrote robust PL/SQL using bulk load. Oracle 10g and 11g full life cycle support. Extensively involved in Installation, upgrade, and performance tuning. Database design, data warehouse schema design, user management and full SDLC application, database support. Actively contributed to enterprise standardization effort.
• Worked as a freelance developer for small clients such as Saint Louis Bread Company, an oracle developer on enhancing code improvement in oracle procedures and packages using Ref cursor to be invoked by Work Day application. He wrote functions that with result cache option and PGA based functions to measure the performance of the modules in conjunction to fetch data from the database. He performed performance tuning and wrote robust PL/SQL using bulk load.
• Senior PL/SQL developer is continuing to work on 12c re- of OCP (Oracle Certified Professional) to further upgrade his skills and experience as he already possesses OCP for 11g.

Confidential, Houston, TX

Senior Oracle PL/SQL Developer

Responsibilities:

• Lead developer in the BaselDBO database, he was responsible for the new design and development of the Basel II for risk analysis. He was responsible for writing PL/SQL procedures and packages to calculate RWA (risk weight assets), LGD (loss given default) and generate reports based on legal entity id and products that are supplied by the end-user.
• Other roles included the reverse-engineering of the current schema and partitioning of tables and adding new data files to existing tablespaces to increase space.
• Also, responsible for production support of high priority code fixes for a major release and modified the SQL in procedures to enhance Front-end component.
• Using PostgreSQL developed object, including tables, triggers, stored procedures and views to in corporate business rules in the database. In Postgre database, he developed and run maintenance routines to ensure database performance.

Confidential, Arlington, VA

Senior Oracle PL/SQL Developer

Responsibilities:

• Senior Oracle developer for the PostalOneProject works in a team of 5 developers to analyze, design, and develop modules using Einduction methodology by following IDEAlliance; industry Database standard for efficient communications and mail processing services. Reverse-engineered the MAILXML data model using SQL Developer’s data modeler tool and added 30 tables.
• To date, his responsibilities also include the implementation and development of releases 32.0.0, 33.0.0 application by coding/developing oracle Programs using PL/SQL which extract data from external sources such as BID (business intelligence data) and MID system for surface visibility in database designed and implemented in RAC using parallel execution. In addition,
• Enhanced and optimized the existing programs to meet optimum query performance by analyzing the execution plan and modifying code using analytical functions and sub-query factoring. In the process, he created oracle scripts that create and partition objects and advanced SQL query capabilities. His responsibilities included writing new procedures using oracle analytical functions and tuning existing packages to meet front-end application needs. He reverse-engineered the ODS data model and made enhancements and wrote the technical requirement document to meet the business functionality.

Confidential, IL

Senior Oracle Developer/Analyst

Responsibilities:

• Developer worked in team of three in the analysis, design, and coding of a 10 TB database of the MIC (management information calendar) modules in PL/SQL and maintaining it in production environment. In addition, Created tables using the compress option to free-up data blocks, utilized the DBMS STATS.GATHER TABLE STATS procedure to gather statistics, created indexes, and analyzed those objects which then used BPEL to manipulate data mart Applications into one process. Also created BIGFILE Tablespace and assisted the DBA in the development databases in gathering performance reports using AWR .
• Other major responsibilities also included the migration of Code between all three environments. He Created Unix Korn shell wrapper scripts to schedule jobs such as using the nohup command.Re-designed the P&L (Profit and Loss) branch of the MIC project using Snowflake dimensional modeling and developed procedures and packages using collections (nested tables and associative arrays)
• .Involved in user security granting and revoking privileges and roles using data dictionary views. Worked in OLTP supply-chain management batch processing system, created hash-partitioning to reduce contention, and implemented on-line index rebuilding to make table & index accessible for active and current transactions. Also he performed unit, system, volume, regression, and UAT of the applications. As customers can order an Item via IVR, web, or PTOC (prime time order capture) 24/7, as a developer for ShopNBC for 3 types of transactions: bank payments, bank credits, and journal vouchers, Developed Oracle procedures and triggers that validate the transaction's general ledger.

Confidential, VA

Senior Oracle Developer/Analyst

Responsibilities:

• Created an electronic billing and automated invoice processing along with AP/AR, and Payroll system with custom report generation capabilities. The system supported 25,000 users and generated daily reports with a 40-terabyte database. Assisted with the roll out and support of oracle 11.5.10.2 Projects module including costing and billing not limited to functional configuration changes associated with change and enhancement requests
• Gathered and analyzed business user requirements. He designed the logical and physical data models using Erwin 7.2. He wrote PL/SQL programs and created 65 custom tables to convert Access source files into Oracle. He developed additional packages which consisted of functions and procedures to validate vendor, project, task, and expenditure name and type. He used SQL*Loader to load UPS billing files to custom staging tables. He executed Oracle advanced native dynamic SQL (NDS) while using collections such as associative arrays, varrays, and nested tables. He used BULK COLLECT to optimize SQL statements for large tables.
• Executed the DBMS AQ package to monitor user and exception queues. Additionally he made use of the DBMS PIPE package to monitor inter-send/pipeline messages between reports and end users. He wrote UNIX KORN shell scripts to automate monitoring, data loading, tuning, and user auditing activities. He implemented a document; testing strategy scripts and test execution scripts for Unit, system, and UTA.
• Performed design and code reviews to ensure all requirements were met with timely delivery of high quality products. He performed SQL tuning using the “explain plan” function and implemented hints, indexes, and re-sized buffers to resolve bottlenecks. He completed unit testing on all objects he created to ensure they met user requirements.

Confidential, Dallas, TX

Oracle Developer

Responsibilities:

• Developed the Branch Managers’ Supervisory System (BMSS) that allows the TELEVISTA branch Management staff to effectively respond and manage to risk related call center activities. The system provides various reports for daily call volume, specific accounts review, follow-up action review, and policy compliance.
• Responsibilities included the study, analysis, design, development, and maintenance of front-end and back-end programs. He used Erwin to implement the physical data model including a set of base tables to meet reporting needs. He created Oracle triggers and packages that included structured record types, table types, and ref cursors.
• Performed SQL tuning and implemented hints, table partitions, and indexes to increase performance. He also utilized BULK COLLECT to fetch large volumes of data with increased efficiency. He developed UNIX shell scripts to automate job control.
• Implemented a centralized data warehouse featuring key performance indicators from PeopleSoft HR, Finance, and Supply-Chain Management modules. Developed queries in ODS (operational data store) for online integration of data where he created a one-to-one Local index partitioning to achieve optimal index-only maintenance. He used Oracle designer to reverse engineer the schema from an early prototype, designed an enhanced multidimensional model to support the Warehouse, and documented the mappings from the PeopleSoft source elements to the warehouse schema. He developed PL/SQL code to transform and load data into the warehouse and developed UNIX shell scripts to automate the load processing. He conducted performance tuning using the ALL ROWS optimizer and improved the physical data model with partitioned tables and local indexes. To meet Sarbanes Oxley compliance requirements, Developed a web-based reporting application used by executives to access data from the warehouse.

Confidential

Oracle Developer/Analyst

Responsibilities:

• Supported development of General Motors VECTORSCM application which provides end-to-end tracking through the delivery network from supplier to factory, dealer and customer. The system provides detailed information at every stop in the supply chain giving General Motors visibility into operations resulting in greater speed and flexibility in delivery.
• Used Visible Analyst to perform a study of the existing system and developed requirements and design documents for improvements to the system. He used ER-win to develop a new data model for the payout stream. He developed PL/SQL programs to compute earned commissions, measure sales growth against goals, and check for missing information. He enacted code changes for procedures that handle adjustments and retroactive fee schedule changes.
• Also implemented the extraction of data from remote databases and developed the accompanying front-end application to produce billing, labor, and margin analysis reports. He developed test specifications and test cases, executed test plans and documented test results.