SUMMARY

• Over 8 years of experience in System Analysis, design and development of database applications in Client/Server applications using Oracle 11g/10g/9i/8i/8.x/7.3, Oracle Forms9i, Reports9i/6i, SQL, PL/SQL, SQL*Loader, BI Publisher.
• Involved in complete project Life Cycle including requirements gathering and Analysis, Database design, Database development and Application development, Testing, Implementation and Support of the application software.
• Good understanding of ETL Processes and Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De - normalization of Tables.
• Experience in SQL, PL/SQL, Tables, Table Partitions, Database links, Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes.
• Experience using Autonomous Transactions, Materialized Views, Bulk Collects and Collections.
• Experience in writing PL/SQL ETL routines in data warehousing applications.
• Expertise in Documenting user requirements, technical designs, implementations and user guides using AIM (Application Implementation Methodology).
• Analyzing & gathering table statistics for Query Optimization.
• Experience in Performance Tuning using SQLTRACE, EXPLAIN PLAN & TKPROF with the help of Hints, Partitioning, Bulk Binding techniques and Indexes.
• Worked with scripting languages like JAVASCRIPT, HTML and XML.
• Excellent in writing UNIX, LINUX, AND PERL Scripts.
• Hands on implementation experience in industries like Banking, Trading, Energy distribution, Telecommunications and Health insurance.
• Worked with applications like Manufacturing Process, Banking Information Systems, Health Care Management Information Systems, and Financial Accounting.
• Experienced in the Retail and Supply chain management activities.
• Experience in Oracle Import/Export Utilities & SQL*Loader.
• Experience in Migrating Data to Oracle database.
• Good understanding of Oracle Architecture.
• Experience using TOAD, SQL Navigator under UNIX and Windows NT/2000/XP/Vista, Sun Solaris operating systems.
• Experience using BI Publisher to create reports for different analysis.
• Excellent Database administration skills including user authorizations, Database creation, Tables, indexes and clusters creation.
• Experience in preparing technical documentation & user manuals.
• Ability to cope up with team with good analytical, communication, organizational and interpersonal skills.

TECHNICAL SKILLS

OPERATING SYSTEMS: WINDOWS NT/2000/XP/Vista/Windows 7, Solaris 8/9/10, AIX 7.1, Red Hat LINUX AS3.0 & 4.0.

DATABASE: ORACLE 11g/10g/9i/8i/8.x/7.3, MS Access, MS Excel (VBA), SQL Server 2005/2008, DB2.

GUI's: Oracle Developer suite11g/10g/9i.

TOOLS: ERWIN 7.x, TOAD 10.6, SQL Developer, SQL*PLUS, SQL*LOADER, PVCS, MS Visio, Talend 5.0, SQL Navigator, Reports Builder, BI Publisher 11.1.1

SCRIPTING: UNIX Shell Scripting, Perl.

Languages: C, C++, Java, VB, C#.

Communication Tools: MS-Outlook.

Web Technologies: JSP, Servlets, XML, HTML, CSS, AJAX, JavaScript.

PROFESSIONAL EXPERIENCE

Confidential - Farmington Hills, MI

Oracle PL/SQL Developer

Responsibilities:

• Involved in Development of multiple projects.
• Worked closely with the Business Analysts to review requirements and implement solutions that add value to the business.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, Synonyms, triggers, packages, stored procedures, roles and granting privileges.
• Involved in the Table design and re-structuring of the key Tables.
• Developed procedures to handle errors and exceptions at database level using PL/SQL.
• Used Ref-cursors, Collections and Bulk Collects for memory intensive processes and to improve code performance.
• Used Utl File package to read and write directly from flat files to the server.
• Involved in Performance tuning in Oracle using Explain plan, SQL Trace.
• Created Indexes to improve the overall system performance.
• Involved in tuning the SQL queries for performance improvement.
• Worked on troubleshooting the application and resolving bugs.
• Used Qlikview software to create new reports and enhance existing ones.
• Debugging the packages, functions, procedures and triggers.
• Addressing the issues raised by the users and providing relevant information to them as needed.
• Involved in Production support.
• Experience in Writing Test Plans, Developing Test Scenarios along with Test Cases, Documenting Testing Procedure, with reference to Business.
• Ability to work in teams and independently with minimal supervision to meet deadlines.
• Responsible for documentation.

Environment: Oracle 10g, SQL Developer 4.0., Db Forge Studio 3.6.3., SQL*Plus, MS-Office 2013, QlikView 11.

Confidential - Southfield, MI

Sr. Oracle PL/SQL Developer

Responsibilities:

• Analyze business requirements/processes and system integration points to determine appropriate technology solutions.
• Interact with business users and IT to define current and future application requirements.
• Automate the process to create monthly file with new customers added and also the old customers monthly change in New registrations, expirations and zip codes along with report.
• Create sales match reports by using Pmc and NCOA process based on the input file and requirements specified.
• Create Packages, Procedures and other Pl/sql objects.
• Create analyzed reports on overall purchase activity from a campaign, units sold and buy rates, number of leads bought from competitiors by purchase type, weekly sales activity and top new and used registrations by make and model using BI Publisher.
• Involved in performance tuning and troubleshooting issues.
• Used FTP to transfer the files to different servers as per needed by the business users.
• Responsible for documentation.

Environment: Oracle 11g, SQL Developer 3.2, SecureFX 7.0, Secure CRT 7.0, Salesforce, MS-Office, Talend 5.0, BI Publisher 11.1.1.

Confidential - Auburn Hills, MI

Sr. Oracle Developer

Responsibilities:

• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Worked with SQL*Loader and External Tables to load weekly flat files into staging tables.
• Developed procedures to move data from staging tables to production tables.
• Created PL/SQL packages, procedures, functions applying the business logic to calculate Communication Volumes (by touchpoint & communication channel), Response Rates (Customer Pay & Warranty Pay breakouts), Dealer ROI Metrics, Key Program Headquarters Statistics, Revenue Generated Statistics (cumulative and per CP RO), Services Purchased (e.g. Brakes, Batteries, Tires, etc.), etc.
• Analyzed the performance of SQL queries using Explain plan and SQL TRACE, and increased the query performance by creating proper indexes on tables.
• Created data for Crystal Reports using procedures and complex Queries.
• Exclusively worked on UNIX environment and rewrote complex UNIX shell scripts as per the requirement.
• Ran Cron jobs for loading database tables from Flat Files using SQL*Loader and also used DBMS SCHEDULER to schedule PL/SQL stored procedures.
• Documented design specifications and architecture using Microsoft Visio.

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, PL/SQL Developer 9.0.3, AIX 7.1, MS-Office.

Confidential - Green Bay, WI

Oracle PL/SQL Developer

Responsibilities:

• Involved in design, development, testing and implementation of the application.
• Involved in writing Queries, Stored Procedures, functions and triggers to implement the business requirements.
• Created new models and modified existing models based on the business requirements.
• Identified obsolete tables and columns in R12 and corresponding substitute\alternate tables and columns after upgrading from R11.
• Identified all the impacted scripts and reports and modified accordingly.
• Performed unit testing on modified scripts.
• Involved in performance tuning of Queries, Stored Procedures.
• Extensively used UC4 for job scheduling.
• Involved in Performance tuningofSQL queriesas data warehouse consists of many tables with millions of rows of data.
• Made use of AUTOTRACE and EXPLAIN PLAN for monitoring the individual query performance.
• Used Visual Builder to create new diver models.
• Responsible for the production support and bug fixing.

Environment: Oracle 11g, SQL, PL/SQL, AIX 7.1, Secure CRT, Harvest, Winscp, Visual Builder, MS-Outlook.

Confidential - Topeka, KS

Oracle Developer

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Creation of database objects like tables, views, procedures, packages using Oracle utilities like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions
• Prepared program specifications for PL/SQL Procedures and Functions to do the conversion.
• Implemented RDBMS (normalization) concepts in Data modeling.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Participated in Performance Tuning using Explain Plan and TkProf.
• Developed number of Reports using Crystal Reports.
• Created Unix Shell Scripts for automating the execution process.
• Created business area, new custom folders, complex folders, summary folder, hierarchies, item classes and list of values using Discoverer 10g.
• Worked on Perl scripts to transfer files using FTP to all the UNIX servers.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: SQL, PL/SQL, Oracle 10g, Toad 8.5, SQL*Plus, SQL*LOADER, UNIX shell scripting, MS SQL Server 2000, Discoverer 10g.

Confidential - Toledo, OH

Oracle Developer

Responsibilities:

• Understanding the business requirements, writing functional specs, test specs and plans.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures.
• Developed stored procedures, packages and functions for workflow validation and verification.
• Document the whole process flow: PL/SQL packages, log files, locations, descriptions, log tables, possible error messages and process codes.
• Prepared procedures to update the internal structures to reflect the newly loaded data.
• Created SQL*Loader control files for moving the data from Flat Files to staging area tables.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and maintained logs for the results.
• Created error log table to capture the error messages, session load time.
• Extensively involved in tuning the queries for faster and better performance of the SQL queries Optimized critical queries to eliminate Full Table scans, reduce Disk I/O and Sorts.
• Worked with Partition tables and indexes to improve the performance of data loading and query processing.
• Worked with Reporting group to facilitate reports.
• Responsible for production support and bug fixing.

Environment: Oracle 9i/10g, SQL*PLUS, PL/SQL, SQL*Loader, UNIX, Windows XP, SQL Developer 1.2, Toad 8.6.1.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Active Participation in the System Study.
• Involved in gathering and creating requirement documents.
• Physical designing and development of Database.
• Assisted in designing the system flow.
• Created tables, indexes and views.
• Creating & modifying stored programs in the form of PL/SQL Packages, Procedures and Functions.
• Creating SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
• Managing tables, indexes, constraints, views, sequences, synonyms and stored program units.
• Extensively used complex SQL queries (Sub-queries and correlated sub queries).
• Involved in writing crisp and precise technical documentation.

Environment: UNIX, Oracle, SQL *PLUS, Solaris 2.6, Microsoft word, PL/SQL.