Summary:

15 years of extensive experience in IT Industry in different phases of software development life cycle such as design, development, testing, implementation and documentation of general application programming as well as specialized areas such as Data Warehousing, Enterprise Resource Planning and Database Administration. I can work independently, build a team and effectively promote teamwork. Gained valuable experience and knowledge over the span of my career as follows:

Business Areas:

Financial, Pharmaceutical, Manufacturing, Nuclear Energy Utilities, Supply Chain, Ocean Shipping Transportation, Bond Insurance/Finance, Travel Accommodation, Commercial/Real-Estate Construction and Retail Industry.

Technical Skills:

• OS AIX V4.3, Solaris, Linux, UNIX and Windows NT/2010
• Languages C, Pro C, SQL, PL/SQL, Java, SQL Loader
• Scripting Languages UNIX Shell scripting, JavaScript, ASP, JSP, Perl and PHP
• Databases Oracle 8i/9i/10g/11g R1, MS SQL Server, DB2, MySQL
• Tools Developer 2000, Oracle Forms, Reports 6i/10g,
• Discoverer, Share Point, VB, TOAD and SQL Navigator
• Autosys
• Reporting Tools Oracle Report, OBIEE, SSRS, Crystal Reports, Actuate 4.1/5/6/7, Crystal Reports, Brio Star Schema, OLAP, MOLAP, ROLAP , Discoverer2000, Cognos Impromptu V7
• ERP Oracle Financials 10.7/11i, SAP R/3, and PeopleSoft 7
• ETL Informatica Power Mart, Power Center 5.1/6 and Informatica Applications
• E-commerce Commerce One BuySite

Experience:

Confidential

Lead Oracle PL/SQL Developer

Responsibilities:

• Design and created both logical and physical database schema for most of the above projects.
• Designed, Developed and Support existing Data Models, Data warehouse, Enhancements, Data Marts, and tune ETL process
• PL/SQL, Packages, Stored Procedures, Functions, Triggers, Materialized Views
• Collections Bulk collection , Pipe, Object Type, Collection Types, Reference Cursors for the above projects.
• Created database replication procedures and scripts and created shell scripts to schedule.
• Design and developed Pro C interface for C library TIPS
• Integrating External Application for Data Feeds.
• Extensive knowledge in Oracle XML and BLOB manipulation.
• Extensive SQL tuning in both Data housing and transactional database.
• Designed and Created Batch Processing using external tables, bulk collections, bulk exception and partitioning and created shell scripts to schedule batch jobs.
• Reverse engineer existing PL/SQL modules into functional requirements for enhancements, bug fix and tuning
• Tuning ETL processes PL/SQL Code and SQL for SSRS reports
• Migrated DW Data Marts to SQL Server Data Models
• Data migration from MYSQL to Oracle
• Architect, Designed and Developed External Feeds processes using PL/SQL, external tables
• PL/SQL jobs to sync Active Directory with PeopleSoft HR
• Created notification process module using PL/SQL packages
• Supporting Existing Midas application, Midas enhancement and production issues, Implemented and enhanced Annuity business logic in existing applications
• Design and developed process to report exposure of credits and policies
• Developed process and a package to load Ratings and populate across the Organizations Hierarchy
• Enhanced MIDAS PL/SQL Libraries Designed, developed and enhanced oracle Reports Re-Engineered Crystal Reporting environment Optimize Analysis and Reporting database for SSRS reporting
• Developed ETL process to extract Principia application data
• Schedule ETL jobs via Autosys and setup notifications
• Converted Ess-base Cubes into SSRS Data Models for Ad-hoc reporting
• Created Financial Reporting Data Models for A R system

Environment: Oracle 8i/9i/10g/11g R1, Data Warehouse A R , Oracle Forms Reports 6i/10g, Discoverer Reports, Cognos Impromptu, SSRS Report, Crystal Reports, PL/SQL, XML, JavaScript, TOAD, HP UNIX 10.2, Solaris, Windows XP

Confidential

Oracle Financials 11i Upgrade

Responsibilities: Techno-Functional Consultant

• Defined Setup options, Accounting Flex fields, Set of books, Security rules, Recovery journals, Budget, Roll-up groups in General Ledger Module.
• Involved in the complete set up of Oracle Receivable that included defining System Options, Accounting Rules, Auto Accounting Rules, Aging Buckets, Approval Limits and Approval Hierarchy, Banks, Banks Transaction Codes, Auto Cash Rule Sets, Transaction Types, Payment Terms and Dunning Letters.
• Developed a feeder program to load external data from legacy system using SQL Loader into Interface Tables for importing customer data and Auto Invoice Master Program, worked with various Oracle Purchasing Order tables and views.
• Involved in Data Conversion to Import Customer information into AR Modified the Reports like Invoice History, Invoice Aging, Prepayment Status and Invoice on Hold Reports.

Environment: Oracle Applications 10.5/11i, Oracle 8i/9i, Oracle Forms 6i/10g Oracle Reports 6i/10g, Discoverer Reports, PL/SQL, XML, JavaScript, TOAD, HP-Unix10.2, Solaris, Windows XP

Confidential

Senior Oracle Developer

Responsibilities: As a Lead Designer/Developer

• Designed Supply Chain Management system for Spare Parts Module
• Designed Process flow for Procurement, Supply Chain, Distribution and Order Management
• Analyzed and created specifications from user requirements
• Created Integration process flow
• Designed user interface forms for web integration
• Designed both logical and physical data structures for application
• Created technical, QA and user documentation model
• Designed ER Diagrams for the application
• Designed and created table structures
• Designed and developed complex screens for transactions with required validations and writing procedures for common functionality using Oracle Forms
• Designed and created Reports in Oracle Discoverer
• Created Oracle stored packages for core process of the application
• Create PL/SQL Server Pages PSP pages for Web integration
• Write Shell Scripts for Job Automation

Environment: Oracle 8i/9i, Oracle Forms Reports 6i, Discoverer Reports, PL/SQL, PL/SQL server pages, XML, JavaScript, TOAD, HP UNIX 10.2, Solaris, Windows XP

Confidential

Senior Oracle Developer

Responsibilities: As a lead Designer/Developer

• Translated business requirements into Technical specifications
• Analyzed, Designed and developed ETL process for Reporting Data Models
• Enhanced existing SQL queries of Actuate Reporting Tuned the application using SQL-TRACE, TKPROF and EXPLAIN PLAN facilities
• Created PL/SQL stored procedures and functions
• Designed and developed Star Schema Created Shell scripts for automation of ETL process Created Data Models and views for Ad hoc Reporting for Discoverer
• Created Dimension tables for Actuate Query reporting purpose Created partitioned custom tables for financial reporting Created Oracle Packages for Actuate Reporting
• Involved in development of on-going enhancements, planning, scheduling implementing, testing and production support of the application

Environment: Oracle 8i, PL/SQL, Forms 6i, Reports 6i, Discoverer Reports, Designer 6.0, Solaris 2.6, Actuate 6/7

Confidential

Senior Oracle Developer

Responsibilities: As a lead Designer/Developer

• Translated business requirements into technical specification for reporting and Data analysis
• Designed and created and configured Reporting Database
• Created Data Models and views for Ad hoc Reporting
• Created Dimension tables for Actuate Query reporting purpose
• Created ETL process for Help Desk Support Database for Reporting
• Administered and Schedule ETL process
• Created stored procedures for input / output ports in mapplets
• Tuned sessions and Extract and Load processes
• Created Shell scripts to automate ETL process and setup runtime environment, and to run Oracle stored procedures, packages to populate the data in staging tables Created Oracle packages to convert SQR report into Oracle Reports 6i
• Fine tuned SQL for Actuate and Oracle Reports

Environment: Oracle 8i, PL/SQL, Forms 6i/ 6.0, Reports 6i/6.0, Designer 6.0, AIX UNIX