SUMMARY

• As an Oracle SQL developer and ETL with over 5 years of IT experience. My main area of experience has been in database programming, testing, creation of custom reports and ETL. My technological forte is Oracle (SQL, PL/SQL, Oracle forms, Reports), Oracle Data Integrator (ODI), SSIS, and SQL Server 2005, MS Access and Microsoft Office products.
• Over 5 years of experience as database developer, data analyst and ETL developer in development, conversion and production support projects.
• Strong skills and work experience in Oracle Database (11g/10g/9i). SQL, PL/SQL, Stored Procedures, Functions and Triggers.
• Extensively worked on the performance tuning of long running queries by using indexes, hints and joins.
• Extensively worked with developing screens and reports using Oracle Forms/Report 10g.
• Experienced working Oracle Data Integrator (ODI) and good knowledge in INFORMATICA.
• Expertise in in cognos10 BI Suite (framework Manager,cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio, Transformer)
• Good knowledge in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Extensively worked with flat file loading process using SQL*LOADER, UTIL FILE and TEXI IO package of oracle forms.
• Skilled in developing ad - hoc and complex reports using Oracle Reports, Discoverer and Cognos8.
• Worked on Windows 95/98/2000/XP, Windows NT and UNIX.
• Involved in the entire QA Process and the Documentation of Test Plans, Test Cases, Test Procedures and Test Scripts.
• Proficiency in usingtesting, test management and defect tracking tools such as JIRA, TFS and HPALM.
• Experienced in Designing Test plans, Test Scenarios, Test Cases and Test Scripts.
• Excellent team player, self-motivated with thirst for knowledge.
• Good experience in interacting with business users, Gathering requirements and writing Requirement Specification documents.
• Creative Problem Solver and Excellent interpersonal and communication skills with the ability to adapt quickly to new and challenging environments

TECHNICAL SKILLS

Tools: QTP, Forms10g/11g, Reports10g/11g, TOAD, Oracle data integrator (ODI), Discoverer 10g, Cognos8 and Cognos10 (Query Studio, Report Studio, Analysis Studio, Framework Manager) and MS Office.

Defect Tracking Tools: TFS, JIRA and Quality Center 9.0

Operating System: Windows and Unix

Scripting Languages: Perl and Unix shell scripting

Languages: SQL, SQL*Plus, PL/SQL, Cobol, HTML,PHP and JAVA

Version control: Visual source safe, Tortoise SVN, visual studio 2012

Databases: MS Access, Oracle 10g/11g and SQL Server 2008

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Database consultant

Responsibilities:

• Involving production support along with enhancement of the RPS application.
• Participating in grooming sessions with business users during analysis phase.
• Worked on Procedures, Functions, and Packages to meet the business requirements.
• Involved in designing & creating various models, and publishing packages in framework manager
• Developed advanced reports using Report Studio.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups and Created Scorecards and Metrics using Metric studio.
• Created dashboards for immediate visibility into key performance indicators KPIs for corrective action and rapid decision-making.
• Involved in executing the batch jobs using COBOL and PERL scripts for posting the returns.
• Involved in troubleshooting performance issues and bugs within PLSQL code using dbms output and explain plan.
• Responsible for new and existing forms and report fixes of the RPS.
• Involved daily SCRUM meetings and update the status for each sprint.
• Involved in code reviews along with unit, system, UAT and integration testing with other developers.
• Responsible for pushing data from RPS to RPSDW system using ODI.
• Responsible for development of ODI interfaces/mappings, packages using oracle data integrator (ODI).
• Involved in writing test plan, test cases using test manager.

Environment: Windows NT, Oracle 11g, Forms11g, Reports11g, COBOL, TOAD, TFS, SVN, PUTTY, BITVISE, ODI11g/12c, SQL* LOADER and Cognos10.2.2

Confidential, Carson City, NV

Conversion Developer

Responsibilities:

• Responsible for development of Oracle Data Integrator (ODI) interfaces, Packages
• Responsible for data analysis and database testing.
• Responsible for data mappings from legacy database to new database.
• Responsible for development of SQL Query, PL/SQL package, procedure, function onOracle database
• Responsible for performance improvements and trouble shooting for Oracle development database.
• Responsible for developing windows batch reports using SQL/SQR and management reports using discoverer 11g.
• Responsible for mock conversion executions and analyze record counts from source to target.
• Responsible for conversion defect fixes using HPQC.

Environment: Windows NT, Oracle 11g, Toad, Oracle data integrator 11g(ODI), TOAD, Quality Center 9.0.

Confidential, Carson City, NV

IT Professional III

Responsibilities:

• Designed and developed various Complex Forms, Menus, Reports and database objects.
• Development and Testing of advanced SQL and PL/SQL based code in support of Reports
• Developed numerous Ad-hoc and complex reports using Oracle Discoverer.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries),
• Develop Test, Implement, Customize PL /SQL Scripts, Packages, Database objects whenever required.
• Load flat files using SQL*LOADER and TEXI IO package of oracle forms.
• Worked in the direct interaction with the End Users and implemented reviews Of the application
• Support state development team to understand and resolve the issues.
• Resolve system test, UAT and production support issues.
• Support ongoing production processes.

Environment: Windows NT, Oracle 10g, Toad, .Net, COBOL, PERL, Oracle forms10g, Reports 10g, Discoverer10g, SQL*Loader, and Flat Files (ASCII)

Confidential

Oracle Developer

Responsibilities:

• Worked in creation of Views for hiding of actual Tables and Queries.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions),
• PL/SQL Programming. Designed and Developed various Complex Forms, Menus And Reports
• Graphics and PL/SQL Libraries. Also wrote stored procedures, Functions, Packages etc.
• Development and Testing of advanced SQL and PL/SQL based code in support Of Reports
• Written database triggers for automatic updating the tables.
• Worked in the direct interaction with the End Users and implemented Reviews of the application
• Study, analyze, and recommend solutions for complex Client/Server application.
• Resolve production support issues. Support ongoing production processes.

Environment: Windows NT, Oracle 9i, PL/SQL, SQL* PLUS, TOAD, PL /SQL developer, Forms6i, Reports6i.