SUMMARY:

• More than Twelve(12) years of extensive experience in Analysis, Design, Development and Maintenance of Management Information System by using Oracle Database 12C/11G/10G/9i, Oracle Developer Suite 11G/10G/9i on Windows 7, Windows XP Professional, Windows 2000/NT environments and UNIX /LINUX/WIN2008 Server.
• Extensive experience of Full System Life Cycle including requirements, feasibility analysis, planning, designing, development, testing, implementation, documentation and maintenance of business critical applications and large databases using Oracle databases and development tools.
• Experienced in designing logical and physical data models using Erwin, database migration and ETL using Informatica Power center 9.6., IBM Data Stage, SQL * Loader and Import/Export, External Tables, XMLGEN package, UTLFILE utility, Bulk Collect, Text IO, Forms Packages, Pl/sql packages and procedures, database triggers.
• Strong hands on experience in Data Migration of Oracle Databases and Data Extraction, Transformation and Loads into Oracle 12C/11G/10G Database. Conversion of Oracle Forms and Oracle Reports from Oracle Forms/Reports 10G/11G.
• Business case study, gathering business requirements and putting them together in logical model.
• Experienced in RDBMS and Dimensional Modeling, OLTP and OLAP, structured and Object Oriented application development including Template Based Programming, Object Groups, User Defined Property Class and Object Libraries using Object Oriented techniques.
• Preparation of use case, test case scenarios for ongoing projects and future projects.
• Experienced in complex reports development using Oracle Report Builder 11G/10G/9i.
• Creating Advance PL/SQL, packages, procedures, functions and triggers to implement business logic. Creating and updating Unix Shell Scripting to automatically run the processes and the periodical jobs and reports.
• Excellent Knowledge and hands on experience in TOAD and Oracle PLSQL/SQL Developer.
• Excellent communication skills, interpersonal skills, motivated, energetic, team player with demonstrated proficiency for learning new tools and business environment with excellent Analytical skills.
• Able to manage changing responsibilities and deliver time critical projects on schedule.
• Proven ability to accept challenges and produce results in a multi - tasked environment.

TECHNICAL SKILLS:

Languages: PL/SQL, SQL

Commercial Packages: Oracle Developer Suite (Forms 11g and Reports 11g), Oracle Developer Suite (Forms 10g and Reports 10g), Oracle Developer Suite (Forms 9i and Reports 9i), Oracle 6i (forms and reports) and Oracle Developer 2000 Rel2.1 (Forms 5.0/4.5,Reports 3.0/2.5),

ETL Utilities and Tools: Talend, Informatica Power Center 9.6, SQL*Loader and Import/Export.

Dashboard Tools: Tableau

Reporting Tool: Oracle Reports Builder 11G,10g, 9i, 6i and 3.0.

Operating System: Windows 98/2000/NT/XP/Unix/AIX/Linux

Modeling Tools: ERWIN (RDBMS, Dimensional)

Internet Tools: ODBC, Apache

Methodologies: Object Oriented, Structured, OLTP, OLAP

Other Tools: PL/SQL Developer, TOAD, Oracle SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst/ Warehouse Developer/ ETL/ Oracle Developer

• Data Modeling using ERWIN, reviewed Batch Management, Dealer Management System for ALLY FINCANCIALS retail clients, Applied DDL changes through scripting to production systems, Applied Normalization.
• ETL Load of Internal and external data from OLTP and external sources to ODS and Warehouse/Mart Using ETL techniques and tools which includes mapping/validations, jobs schedule and controls, Unix Shell Scripting for automated jobs, monitoring log files, SQL Performance Tuning.
• ETL loads into the Oracle database from various sources including Excel and Flat Files such as CSV, TXT, output files including historical RDBMS data and daily data loads extensively used PL/SQL, SQL Loader, External Tables and Data Stage.
• Analyzed Dealer CRM system and provided source to target mapping from ODS and warehouse to consuming systems for reporting needs.
• Database Development using Oracle PL/SQL Packages and Stored Procedures and Functions.
• Automated several internal processes using Oracle PLSQL packages, functions, database Triggers and UNIX scripts.
• Built UNIX Shell Scripts to run periodic reports, periodic external data upload calling PLSQL Packages and download data for external use.
• Applied AGILE/SCRUM (with Sprints) for Data warehouse development and Integrated operational data store (ODS) development and maintenance.
• Source to Target Mapping for Data Warehouse and ODS for Batch Management and Dealer Management System.
• Data Dictionary, Business Glossary Maintenance and Version control for Code and Batch Jobs.
• Documentation of the Business Process and Gap Analysis, Building Test Cases for testers and QAs.

Technology/Platform: Oracle 12C/11G Database OLTP, ODS, Data warehouse, Oracle PL/SQL Developer, UNIX/Linux, Putty, WinScp, Windows 7, HP Quality Center, IBM Infosphere Server 11, IBM Data Stage, IBM Cognos Reporting, ERWIN, Golden Gate, Oracle 12C Exadata

Confidential

Senior Oracle Developer

• Data Modeling using ERWIN, reviewed Ad Sales Finance system, Program Scheduling (content/episode airing) module data model, Applied DDL changes through scripting to production systems, Applied Normalization.
• Developed new Packages, procedures and Functions for Business use cases (AR, Accounting, Invoice Maintenance, Customer file) using Oracle PLSLQL.
• ETL loads and Full Process into the Oracle database from various sources including Excel and Flat Files such as CSV, TXT, XML, JSON output files including historical RDBMS data and daily data loads extensively used SQL Loader, External Tables, UTLFILE.
• Maintenance of production systems including removing major and minor bugs from the existing oracle forms and reports and stored packages, procedures, functions and database Triggers for NCS.
• Created Screens using Oracle Forms 11G and backend Oracle database package based process to load external data into NCS system.
• Created packages to download the data for internal and external applications.
• Built Procedure to call SOA API data into Oracle using UTLHTTP.
• Automated several internal processes using Oracle PLSQL packages, functions, database Triggers and UNIX scripts.
• Migrated data of third party systems for ESPN/ABC TV business units into Center of Excellence NCS ERP integrated application.
• Built UNIX Shell Scripts to run periodic reports, periodic external data upload calling PLSQL Packages and download data for external use.
• Provided functional details for QA process for newly developed programs and reports also provided user test cases.
• ETL Load of Internal and external data from OLTP and external sources to ODS and Warehouse/Mart Using ETL techniques and tools which includes mapping/validations, jobs schedule and controls, Unix Shell Scripting for automated jobs, monitoring log files, SQL Performance Tuning.
• Applied SDLC for re modeled Ad Sales Customer file Rebuilt and Enhancements.
• Enhancement of Ad Sales Customer files backend using Oracle PLSQL and Front end using Oracle Fusion Middleware Forms and reports services.
• Enhancement of various modules of NCS ERP of existing Oracle forms and reports adding new features based on user requirements.

Technology/Platform: Oracle 11G Database OLTP, ODS, Data warehouse, Oracle Fusion Middleware, Oracle Developer Suit 11G, Oracle PL/SQL Developer, Java2EE, UNIX/Linux, exceed, Putty, WinScp, Windows 7, Citrix Client, HP Quality Center, Informatica Power Center Client 9.6, Tableau, ERWIN, Oracle 11G Exadata

Confidential

Senior Oracle Developer

• Developed new forms and reports based on user requirements for in house built custom solution (Construction system, Including union based payroll system - Called P2000) in Oracle Forms 10G and Reports 10G.
• Conversion of forms and reports from oracle forms/reports 10G to 11G
• Creating/Recreating and Dropping objects while maintaining the integrity,
• Performance tuning of queries and cursors using Golden Plsql Tool.
• Reviewing Data Models and Applying DDL changes for Accounting system module of in-house ERP P2000.
• Building/Generating DDL Scripts of database enhancement for JOB Costing module of ERP P2000.
• Enhancement and development current and new screens and reports for day to day use. Removing major and minor bugs from the existing oracle forms and reports and stored packages, procedures and functions.
• Maintaining the documentation of new development, enhancement of features through the change management and problem management in in-house built application.
• Application testing, user training and product evaluation.

Technology/Platform: Oracle 10G Database Release 2, Oracle 11G, Oracle Developer Suit 11G, Oracle Developer Suit 10G, Toad, Golden PLSQL Tool, VB, Crystal Reports, Linux, Windows 7, MS Project, MS Visio, ERWIN.

Confidential

Senior Oracle Developer

• Developed new forms and reports based on user requirements for NCS and OTV modules’ in Oracle Forms 10G and Reports 10G.
• Maintenance of production systems including removing major and minor bugs from the existing oracle forms and reports and stored packages for NCS and OTV modules including hard coding.
• Created user defined stored procedure, function, packages using PL/SQL Developer.
• Performance tuning of queries and cursors using and PL/SQL Developer.
• Enhancement of existing Oracle forms and reports adding new features based on user requirements.
• Applied DDL scripts for application enhancements and new builds.
• Reviewing data models of applications module for data flow and integrity.
• Building Scripts for backend job runs.
• Provided functional details for QA process for newly developed programs and reports.
• Updated Unix shell scripts for reports and automated processes.

Technology/Platform: Oracle 10G/9i Database (9.0.6.0), Oracle Developer Suit 11G, Oracle Developer Suit 10G, Oracle forms 6i and reports 6i, Oracle PL/SQL Developer, Java2EE, UNIX/Linux, Windows 7, Citrix Client, HP Quality Center, ErWIN.

Confidential

Senior Oracle Developer

• Maintenance and support and of Integrated Business Management Solution (IBMS) production system including removing errors from oracle PL/SQL procedures and packages and functions.
• Created user defined stored procedure PL/SQL Developer for data conversion from flat files to Oracle database.
• Enhancement of existing IBMS software features for City Planning module to add new features based on user requirements.

Technology/Platform: Oracle 10G Database, Oracle PL/SQL Developer and Windows XP Pro.

Confidential

Senior Oracle Developer

• Developed new forms and reports based on user requirements for NCS and OTV modules’ in Oracle Forms 10G and Reports 10G, Oracle forms 6i and reports 6i.
• Maintenance of production systems including removing major and minor bugs from the existing oracle forms and reports and stored packages for NCS and OTV modules including hard coding.
• Created user defined stored procedure, function, packages using PL/SQL Developer.
• Performance tuning of queries and cursors using PL/SQL Developer.
• NCS Application modules data model review for data flow understanding and enhancements (Normalization).
• Enhancement of existing Oracle forms and reports adding new features based on user requirements.
• Used Global temp tables and cursors to collect the exact data for better performance of the query.
• Updated Unix shell scripts for reports and automated processes.

Technology/Platform: Oracle 10G/9i Database (9.0.6.0), Oracle Developer Suit 10G, Oracle forms 6i and reports 6i, Oracle PL/SQL Developer, .NET, UNIX/LINUX,, exceed, Putty, WinScp, Windows XP, Citrix Client, ERWIN

Confidential

Oracle Developer

• Developed plan to migrate the application of CIS from Oracle 8i version into Oracle 9i version with both database and forms/reports. Also operating system had changed from Windows 98 to Windows 2000 Professional.
• Created test cases for feasibility analysis before the project kick off.
• Preformed import into New version of the database using SQL Loader, External tables, UTL File utility of Oracle.
• Migrated into Phases wise, first transferred database into new version and secondly transferred forms and reports.
• Developed interface for reports from forms runtime and generated into PDF on browser (Internet Explorer).

Technology/Platform: Oracle 9i Database (9.0.6.0), Oracle 9i Developer Suite, Oracle 8i and Oracle Developer 2000 Rel.2.1 (Form, Report) Builder, Window98 and Windows 2000/XP, Toad and Oracle SQL Developer, Erwin

Confidential

Oracle Developer

• Analyzed and discussed the proposed Inventory System with the users and undertook requirements gathering
• Designed logical data models of the system using ERWIN and constructed database schemas
• Normalized table relationships based on requirements gathered
• Developed the stored procedures, triggers to implement business rules using Oracle PL/SQL
• Designed Screens for Inventory System and Reports using Oracle Developer 2000 (Forms, Reports)
• Created technical documentation detailing the implementation of the developed systems
• Trained end-users operating and maintaining system and software

Technology/Platform: Oracle 8i Database, Oracle Developer 2000 Rel 2.1 (Form, Report) Builder, Window98 and Windows 2000/XP, Erwin

Confidential

Oracle Developer 

• Involved in Analysis, Design and Development, Testing, Maintenance and resolved problems during implementation.
• Involved in developing Logical and Physical Data Models using ERWIN
• Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements.
• Database application development; created tables, relationships, queries, forms and reports.
• Heavy interaction with users, make them understand the use standard and management reports
• Wrote Procedures, Functions and SQL Loader scripts.

Technology/Platform: Oracle 8i Database, Oracle Developer 2000 Rel.2.1 (Form, Report) Builder, Window98 and Windows 2000/XP, Toad, Erwin.