SUMMARY:

• Oracle and web expert having over 10 years of experience in developing medium to large - scale web applications. Actively participated in all phases of application development including the design, analysis, coding and implementation. A team player and self-starter who is capable of adapting quickly to emerging technologies.
• Extensive experience in Client/Server application development, implementation and system design in ORACLE, ORACLE DEVELOPER (ORACLE FORMS, ORACLE REPORTS), ERWIN, Cognos Impromptu, DESIGNER 2000, and DISCOVERER combined with solid programming and analytical skills.
• Experience in developing applications using Oracle and Data Warehouse tools.
• Expert in coding complex ETL procedures using PL/SQL and used SQL Plus, SQL*Loader extensively.
• Extensive experience in web technologies like PSP, JSP, JavaScript, HTML, DHTML.
• Possesses excellent analytical, programming and communication skills.
• Expert in writing Unix shell scripts.
• Extensive background creating stored procedures, triggers and user defined functions.
• Expert level knowledge in handling Microsoft Office Suite (MS-Excel, MS-Access, MS-Word).
• Possess a very strong technical foundation and the ability to work in a collaborative atmosphere with end-users and members of the development team.

TECHNICAL SKILLS:

Operating Systems: Windows NT/95/98/2000 and UNIX

Languages: SQL Plus, PL/SQL, XML, HTML, ASP, VB Script, JavaScript, UNIX SHELL Scripts, Java, Pro*C

RDBMS: ORACLE 7.x/8.x/9.x/10.x,11i, MS-SQL Server 6.5/7.0/2000 , MS-Access

Application Dev Tools: Oracle Developer (Forms 10g/9i/6i, Reports10g/9i/6i,), Visual Basic 5.0, Microsoft Visual Interdev 6.0, Crystal REPORTS 8.0

Data Modeling Tools: Oracle Case Designer 2000, ERWIN 3.5

Source Control Tools: Visual Source Safe 6.0, PVCS, Rational Clear Case

Ticket Tracking tools: Test Director, Peregrine

Other Tools: PSP (PL/SQL Server Pages), Pro*HTML, SQL LOADER, TOAD, SQL Station, SQL Navigator, Cognos Impromptu, Business Objects, BEA Tuxedo

PROFESSIONAL EXPERIENCE:

Confidential, Farmington Hills, MI

Senior Programmer/Analyst

Responsibilities:

• Involved in the UI development process - from requirement gathering to final deployment.
• Designed and developed procedures and/or packages to handle new business rules, using PL/SQL.
• Created new forms for Confidential team using Oracle Forms 6i.
• Modified existing reports, and created some new ones using Oracle Reports 6i.
• Gave the scripts for new table creation to DA/DBA group.
• Set up new monthly/quarterly programs, which has the information for sales representatives for dealers, and their performance can be tracked. Based on this, award payouts can be generated.
• Migrated Appworx chains from AppWorx7 to AM8 environment
• Modified/created new chains for Appworx.

Environment: Oracle 10.x/11g, PL/SQL, TOAD, PL/SQL Developer, SQL Plus, Oracle Forms 6i, Oracle Reports 6i, AppWorx 7, AM8

Confidential, Ann Arbor, MI

ETL/BI trainee / Sr. Developer/Analyst

Responsibilities:

• Worked on SSRS for creating reports.
• Created tables/views needed for the new reports.
• Bug fixing in the reports.
• Helped QA with the queries needed.

Environment: Oracle 10.x/11g, PL/SQL, TOAD, PL/SQL Developer, SQL Plus, ODI 10g

Confidential

Responsibilities:

• Worked on ODI for creating/modifying interfaces, to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse.
• Analyzed the business requirement, and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Worked on Slowly Changing Dimension (SCD).
• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator (ODI).
• Created SQL scripts for sourcing data, including creating tables, views, stored procedures.
• Used Toad for analysis and maintained Database using DDL’s, DML’s
• Validate the required data at the database level by using tool Toad.
• Created/modified stored procedures using PL/SQL, which were called from ODI.

Environment: Oracle 10.x/11g, PL/SQL, TOAD, PL/SQL Developer, SQL Plus, ODI 10g

Confidential, Southfield, MI

Senior Programmer/Analyst

Responsibilities:

• Participated in developing the web pages for the system using HTML, CSS, PSP and JavaScript .
• Created stored procedures, functions using PL/SQL, which are used frequently in main programs.
• Developed/modified load programs to load the different sets of data.
• Involved in loading the production data.
• Analysis, Design and Development of UI using PLSQL packages, procedures and functions.
• Extensively using TOAD & PL/SQL Developer, for verifying the data, creating anonymous PL/SQL blocks.
• Created technical construction documentation.

Environment: Oracle 10.x/11g, PL/SQL, TOAD, PL/SQL Developer, SQL Plus, JavaScript, HTML

Confidential

Senior Programmer/Analyst

Responsibilities:

• Analyzed warehouse data and created day to day transaction reports using Oracle Reports
• Wrote PL/SQL procedures using utl file package to create and read data file with customer address information.
• Developed an automated process to send the data file on to vendor database using secured FTP.
• Developed screens using Oracle Forms and implemented address validation functionality for dynamic address validation. Created database triggers to update the Audit fields and to maintain historical data.
• Wrote UNIX shell scripts to execute the batch programs.
• Analyzed and tuned the existing programs for better performance.
• Created adhoc excel reports as per users request.

Environment: Oracle 10g, PL/SQL, Pro*C, UNIX, Oracle Forms6i, Oracle Reports6i

Confidential, Detroit, MI

ETL/BI trainee / Sr. Developer/Analyst

Responsibilities:

• Handled team lead activities such as coordinating version upgrades, requirements gathering, designing implementation plans, scheduling and planning of development tasks, and working with users in JAD sessions.
• Created stored procedures using PL/SQL to automate the pricing changes and the agreement renewal process.
• Developed user interface screens for data entry and data retrieval using Forms 9i and generated reports for invoicing, payments and usage details using Reports 9i
• Optimized the performance using PL/SQL by restructuring the extraction and summarization routines. Tuned the SQL statements for better performance by restructuring the indexes and statements.
• Used database triggers created to audit data modifications and insertions when an agreement got changed and by whom
• Automated the back end batch jobs using Unix shell scripts
• Implemented the exceptional handling in the procedures so that the jobs run with the error messages directed to a table until a frequency count is reached and then aborts
• Created technical construction documentation.

Environment: Oracle 8.x/9.x/10.x, PL/SQL, TOAD, Forms 9i, Reports 9i, Designer 2000, Windows XP, SecureFX, SQL Plus, SQL*Loader, Advanced Queuing, BEA Tuxedo, Pro*C

Confidential, Southfield, MI

ETL/BI trainee / Sr. Developer/Analyst

Responsibilities:

• Participated in gathering the requirements from the users, and developing the forms for the system using Discoverer and Oracle Forms .
• Modified the existing interface procedure using PL/SQL , so that it can eliminate the unused tables.
• Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL.
• Analysis, Design and Development of Interfaces using PLSQL packages, procedures and functions.
• Extensively used SQL Navigator, TOAD, SQLpal and SQL PLUS writing several SQL queries to pull/verify the data, and for determining the optimization level of the query.
• Used SQL LOADER to load the data from plain text files into database tables and use these for extraction purposes.
• Ensure all T&E import and export processes are successful, in regards to Citibank, Lotus Notes and Extensity, on daily basis.
• Heavily involved in all the quarterly ETL refreshes and interface development.
• Heavy use of SQL Navigator, TOAD, SQLpal and SQL PLUS writing several SQL queries to pull/verify the data.
• Developed several reports for different teams, as well as for managers and users, using Oracle Reports

Environment: ORACLE 8.x/9.x/10.x,11i, PL/SQL, SQL Plus, SQL*Loader, FORMS 6i, REPORTS 6i, Discoverer Plus, Discoverer Viewer, Microsoft Visual Interdev 6.0, Visual Source Safe, TOAD, UNIX, HTML, DHTML, Windows XP, Linux, SecureFX, SecureCRT, PCAnywhere

Confidential, Southfield, MI

Responsibilities:

• Participated in developing the web pages for the system using HTML, DHTML, PL/SQL Server Pages, Pro*HTML and JavaScript.
• Pro*HTML was Confidential . Confidential ’s chosen 3rd party utility used to create / modify the web pages instead of Oracle Web Tool Kit.
• Generated the XML documents from database using PL/SQL packages.
• Used Oracle CASE to look up the ER diagrams
• Participated in analysis and design phases of the project in finalizing the user requirements, functional requirements and technical requirements
• Developed several REPORTS for Toyota using PL/SQL procedures and Report 6i.
• Developed a module in PL/SQL to hold the consumer control group for performance metrics project.
• Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL and SHELL scripts.
• Wrote UNIX SHELL scripts to automate and schedule the processes in the system

Environment: ORACLE 9IAS, ORACLE 8.x/9.x/10.x, FORMS 6i, REPORTS 6i, PL/SQL, SQL Plus, SQL Loader, Discoverer 9i, XML, Microsoft Visual Interdev 6.0, Visual Source Safe, Rational Clear Case, PL/SQL Server Pages, Pro*HTML, TOAD, UNIX, HTML, DHTML, Windows XP, XML, Oracle Case Designer 2000, Linux, SecureFX, SecureCRT, UNIX SHELL Scripting, HP-UX11i

Confidential, Warren, MI

ETL/BI trainee / Sr. Developer/Analyst

Responsibilities:

• Participated in the all the phases of the project including design, development, implementation and production support.
• Studied user requirements and functional specifications.
• Developed various end-user REPORTS as per the requirements using REPORTS 5/6 and 6i.
• Involved in tuning the SQL queries for optimal performance.
• Generated the XML documents from database using PL/SQL packages
• Documented all the scripts used in the project for easier maintenance.
• Created data-model using Oracle CASE and Designer 2000.
• Grant the necessary system and object privileges to the respective users and roles.
• Developed interface screens using FORMS 6.0, wrote UNIX SHELL scripts to automate processes, and created complex stored procedures and functions using PL/SQL.

Environment: ORACLE 8i/9i, FORMS 5.0/6.0/6i, REPORTS 5.0/6.0/6i, PL/SQL, SQL PLUS, SQL LOADER, TOAD, Oracle CASE, Oracle Designer 2000, SQL-Station, Business Objects, Unix Shell Scripting, HP-UX11i, Linux.