SUMMARY

• 9 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS).
• Extensive experience in Data Transformations, Data Loading, Database Modeling and Performance Tuning.
• Experience in different phases of Oracle Application implementation life cycle including Technical Design, Data Conversion, Oracle Forms development, Oracle report development, Unit Testing, Integration Testing, End User Training and Production Support.
• Strong Knowledge on oracle architecture and database design.
• Developed mapping to load data from source to target using Owb.
• Have a strong knowledge on data ware housing concepts and implementation using oracle ware housing.
• Strong knowledge on Star schema, snowflake schema.
• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Excellent conceptual knowledge of Oracle … PL/SQL.
• Extensive experience in database programming using SQL and PL/SQL.
• Extensive experience in developing SQL and PL/SQL (Coding Procedures, Functions, Database Packages and Triggers).
• Scheduled complex cron jobs on UNIX platform using crontab format.
• Experience in Dynamic SQL, PL/SQL Collections and Exception handling.
• Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, Tkprof, SQL*Trace and Table partitioning.
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating external tables to manage data which is stored at the OS level.
• Experience in retrieving data from Personal Data Files, and Stored Procedures.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, TKPROF andSQL*Navigator v.4.5.
• Participated in collecting the requirements, analyzing the System Requirements.
• Experience with Star Schema Modeling and knowledge of Snowflake Dimensional modeling.
• Experience with Data Modeling using ERWIN … SQL Server, MS Access, SQL, PL/SQL, SQLPlus, Toad, and MS SQL Server, Query Analyzer.
• Proficient in Microsoft Office Suite (to include PowerPoint, Visio, Project, SharePoint and Access).
• Extensively worked on Design, Development, Deployment & Maintenance of ETL process to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML SQL/ Oracle) to different targets (DB/Files).
• Experience in Understanding complex performance issues and worked with DBA's to suggest valuable ways to fix the problem.
• Excellent planning, analytical, written Communication, ability to work under pressure and Interpersonal skills.
• Extensive experience on admin and user editions of discoverer 10g and used AIM (application implementation methodology) in documenting the development tasks.

TECHNICAL SKILLS

O/S: Microsoft Windows 2000, NT, XP, Linux, Aix.

Database: Oracle 8i /9i/ 10g/11g, IBM DB2 Universal Database, SQL Server, MS Access

Data Warehousing: Informatica Power Center Designer 9.1

Languages: SQL, PLSQL, C++, C.

Oracle Utilities: SQL * PLUS, TOAD, SQL Developer, PLSQL Developer

Data Modeling Tool: ERWIN, VISIO

Functional Testing Tools: QTP, IBM RFT

Defect Tracking Tools: QC, Bugzilla

GUI & Reporting Tools: Oracle Forms v8i/ 9i/10g, XML Reports, Oracle Reports v8i/9i/10g, Oracle BI EE 10, Oracle Essbase Reports.

Version Control Tools: Sub - Version

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Senior Oracle PL/SQL Developer / Application Specialist

Responsibilities:

• A liaison between Business and Technology for functional design, specification and deployment of Finance Systems Initiatives at the Finance Project Office (FPO).
• Undertake data assessment, data gap analysis, system sourcing, remediation and transformation efforts for FR Y-9C, FR Y-14A/Q.
• Liaise with cross-functional teams (business groups, IT organizations) in Several Global Locations
• Supported the end-to-end process, Enterprise and Basel DW integration, including feasibility proofGap analysis, data mapping.
• Investigated and performed elements mapping for Specific Market Risk, Counterparty Credit Risk.
• Defined, designed, reviewed and documented maps, attributes, data types, cardinality, and data quality standards for both Banking and trading books. Worked with different exposures / assets pools: Trade Products, Loans, Securities, and Derivatives.
• Assist project management team with evaluation of different process and technology solutions.
• Single Point of Contact for OFSAA and Risk functionality.
• Validating OFSAA Data Model for FRY-14Q requirements.
• Creating business analysis document for integration between OFSAA -Risk Staging - Confidential 's RAY based on Risk FRD's.
• Re-Designed T2T process to populate FX Exchange Rate table and Historical table.
• As member of IHC Transversal Functional team worked on Integrating OFSAA and Confidential 's Risk Authority (RAY) for RWA calculations.
• Performing Impact analysis of OFSAA changes on Risk calculation in Confidential 's Risk Authority.
• Validating SQL's used for extracting dataset from T CDR, T MR tables of Confidential 's Ray for CCAR.
• Designing Data Quality (DQ) checks in OFSAA Framework.
• Developed 2000+ SQL's to validate Line Items of FRY-14Q PPNR reports based on Business requirement in Excel sheet.
• Performed Data analysis for LAP and Oracle GL Accounts, Counterparty, Instrument data.
• Developed R17 Reconciliation process between OFSAA and Confidential 's Risk Data.
• SPOC for Set-Up of UAT environment with GL data and Referential Dataset required for the
• Risk Functionality Testing.
• Worked data acquisition, classification, and enrichment processes and data flows inbound / outbound feeds to and from source systems / product processors.

Environment: Oracle 11g, Oracle SQL, PL/SQL, TOAD, SQL Developer, Windows NT, OFSAA, RHEL LINUX, Shell Scripts, Informatica.

Confidential, Milwaukee, WI

Oracle Pl/Sql Developer

Responsibilities:

• Collaborated with the Business analysts to create technical design documents, Source to target mappings, Process documents for ASDS Data project.
• Developed CDC Packages when new table and columns are added in ASDS and also has Good understanding of CDC process procedures.
• Worked with Business in full development life cycle for ASDS project. And involved in developing procedures, functions, packages, triggers, views, and materialize views etc.
• Involved in Performance tuning, which included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility.
• Worked with offshore in analyzing and developing the new Use Cases like Pool Settlement Report, Uncommit ARM Report, and also change the current CDC Code as per the business.
• Involved in analyzing, fixing and testing the CDC conflicts issues in production. Worked on creating test cases and data validation scripts.
• Worked on creating the change tables, change views and packages for oracle native CDC.
• Worked on various CDC objects like Procedures, Packages, views etc. to improve the performance of CDC Load process.
• Worked with DBA's in setting up and refreshing the various Test Environments like DEV, IST and UAT.
• Worked as CDC on call support in rotational manner.
• Collected all impacted modules from all developers and prepare the deployment script for production release.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid and invalid data into error tables.

Environment: Oracle 11g, Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, UNIX, Windows XP/2000.owb 10g.

Confidential, Philadelphia, PA

Oracle Pl/Sql Developer/Support/Production Engineer

Responsibilities:

• Develop Packages, Stored Procedures/Functions to develop Atlas Database mirroring the existing ATG System.
• Write Procedures to classify the incoming orders based on their regions and place them in different SAP system.
• Perform root cause analysis for and test failure and co-ordinate with different teams to resolve the issue.
• Create and Maintain Autosys jobs in both production and development Environments.
• Create Views based on multiple tables and perform data changes on tables for cancelled and modified orders.
• Create multiple jobs in Autosys Environment co-coordinating with offshore team and other technical teams to create a QA Environment to perform testing.
• Working on issues like Defective Images, discrepancy between product, price, Style-colors with most of source systems like Flex, CDB and CDM, Goal, Scean7 etc. for Nike.net.
• Create UNIX Shell scripts and SQL queries to get order report data from Atlas and process them into reports that is used by other systems like SAP and JCAPS for maintenance.
• Wrote Test scripts to execute Performance testing to check the low of order between the system and the databases and performance of Nike.net.
• Customized forms by writing block level triggers and item level triggers using Oracle Forms.
• Developed screens and reports using Oracle Forms/Reports 10g. Also developed reports using Pro*C and PL/SQL.
• Conversion Oracle Forms and Reports 10g to Oracle Forms and Reports 11g.
• Involved in creating Logical Model and Physical Models using ERWIN.
• Prepared Defect metrics for the project by Querying Atlas database using SQL and UNIX shell scripting.
• Took initiative in designing Coupon code addition to their existing system and to add unique coupons codes to their XML and send it to the Database.
• Develop Unix Shell scripts to monitor jobs and run the stored procedures/functions.
• Help the various testing teams by tracking the order details through databases, SAP and Idocs that are created.
• Created MS Access programs with login security functionality to allow user to interact with all databases.
• Structured and optimized code in stored procedures, triggers and MS Access for processing data.
• Involved in preparation of Test plan and Test scripts with the help of requirement and design document.
• Co-ordinate between different teams to highlight the defects and defect resolution.
• Provided Support coverage for the release and performed root cause analysis during the warranty phase.
• Worked with different teams to set up the development and test Autosys environments.
• Created Work Instruction Manual listing the possible failures and Recovery steps for each and every new job added as part of the project.
• Involved in the preparation of Test plan and Test scripts with the help of requirement and design document.

Environment: Oracle 10g/9i/11g, SQL, PL/SQL, SQL*Loader, UNIX Shell script, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, JAVA, Windows XP/2000.