We provide IT Staff Augmentation Services!

Sql Resume

5.00/5 (Submit Your Rating)

St Louis, MO

Over 8 Years of IT experience as an Oracle PL/SQL Developer. Expertise in analysis, design, development, implementation and maintenance of application software in a client/server environment.

Summary:

  • Extensively worked in creating, debugging and testing Procedures, Functions, Triggers and Packages using PL/SQL
  • Good exposure in Monitoring/Tuning SQL Queries using Optimization Techniques/Explain Plan.
  • Solid experience in efficiently writing SQL Queries
  • Extensive experience in using Oracle Utility tools like SQL*Loader, Import and Export.
  • Exposure in using CASE tools like TOAD, SQL Navigator for writing PL/SQL programs
  • Expertise in writing and debugging Pro*C programs in both UNIX and Windows environment
  • Extensive experience in Software Development Lifecycle and adept in software Coding Standards
  • Tuning of SQL Queries to improveperformance of a system. Identify root causes and resolve problems related to system functionality.
  • Solving performance issues using Cost based and Rule based Optimizations.
  • Exposure to SAP ECC 6.0 systems and possess good knowledge of Finance and Material/Inventory Modules.
  • Good experience supporting to Java web development team
  • Proficient in designing and coding of Oracle Forms(V 5.0/4.5/3.0)
  • Good understanding of Data Modeling and Star/Snowflake Schemas.
  • Good exposure in developing SQL*Plus and Pro*C reports
  • Hands on experience in Oracle 11g, 10g, 9i and 8.x
  • Proficient in writing UNIX Shell Scripts/PERL Scripts.
  • Involved in various phases of software development such as System Study, Analysis, Code, Testing and Documentation
  • Responsibilities include extensive client interaction to understand expectation, requirements, formulating solutions, designing the architecture and developing the application besides managing teams
  • Involved in Client/User interactions to understand and formulate requirements and business process improvements.
  • Posses Excellent Communication, Drafting and Interpersonal Skills besides being a good team Player.

Technical Skills:

Operating Systems : Windows NT/2000/XP, HP-Unix, Sun Solaris
RDBMS : Oracle 11g, 10g, 9i, 8.x and MS-Access
Languages : SQL, PL/SQL, C, Pro*C, UNIX Scripts, PERL Scripts
Web Technologies : Java, JSP, HTML, DHTML, XML
GUI Tools : Forms 3.0/5.0/6i
Data Warehouse Tools : Informatica Power Center 7.1.1, Business Objects
Other Technologies : SQL Loader, TOAD, SQL Navigator, Erwin tool

Professional Experience:

Confidential, St Louis, MO
Oct 2009 – Till Date
ASI – Integration/Migration to SAP
Database Analyst/Developer

Confidential, is one of the pioneers in manufacturing agricultural based products. The goal of ASI project is to migrate/integrate legacy systems/data into Confidential, ’s SAP system. There are 13 legacy systems.
The data from the legacy systems are extracted on a monthly basis. The legacy data to be migrated includes master data like Customer, Vendor and Material and transactional data like Accounts Receivables, Accounts Payables, General Ledger and Inventory. All the master data is loaded prior to loading the transactional data. Data is validated/reconciled at all phases of development before and after migration.

Responsibilities:

  • Developed/Scheduled Scripts to extract the data from legacy databases which include SQL Server and Oracle 11g using DB Links.
  • Responsible for validating and reconciling the data to the month end reports given by the business.
  • Extensively used SQL Loader for loading flat files and excel sheets into Oracle Staging area.
  • Responsible for creating/modifying tables and views and granting privileges on the schema objects as per the business and technical requirements.
  • Developed several SQL Scripts, Packages for reconciling the transactional data.
  • Applied several Joins and Filters on various tables and views to analyze and validate data.
  • Applied Optimization techniques for fine tuning SQL queries.
  • Tuning SQL scripts for faster execution using Explain Plan.
  • Developed and Debugged PL/SQL packages, Procedures and Functions on Oracle 11g for implementing various Business rules.
  • Embedded various Data Transformation/Mapping rules using PL/SQL.
  • Performed several ETL (Data Migration) activities using SQL and PL/SQL.
  • Extensively used PERL Scripts to generate Control files and BDC error log files.
  • Used BDC Recording, LSMW and Batch input techniques for loading the transformed/cleansed legacy Data into SAP.
  • Provided Production support to update/create and configure master and transactional data in SAP production instance using TXShuttle and SAP T-codes.
  • Loaded and tested legacy data in Development and Testing systems in SAP before loading to Production system.
  • Reconciled the data in all the systems. Generated pre load and post load reconciliation reports using PL/SQL.
  • Trained other team members in using the Procedures and Loading techniques to perform concurrent loads with in the given dead line.
  • Documented ETL Procedures and core functional areas for future Re-Use.

Environment: Oracle 10g/11g, TOAD, SQL Developer, WinCVS, SQL Loader, MS Access, PERL, SAP ECC 6, Windows XP

Confidential,
July 2008 – Sep 2009
SCP – Development/Migration
Oracle/PL/SQL Developer
Maxim Integrated Products is one of the leading manufacturers of Semi Conductors. The Supply Chain Planning system assists in planning the production line based on the demand/orders generated. The initial phase of development was done on integrating the data from the legacy systems into the planning system. The later phase was projected to enhance/modify and interface the planning system with data feeds from newly implemented SAP systems.

Responsibilities:

  • Developed functions, procedures and packages using PL/SQL on Oracle 11g as per the business requirements.
  • Modified/Debugged the existing PL/SQL code as per the change requests.
  • Fine tuned SQL queries using Explain Plan Techniques.
  • Involved in Code Review and performed Unit Testing.
  • Developed ETL procedures for the planning system.
  • Performed extensive Data Analysis and Generated simple to complex business Reports using Oracle Discoverer 9 as per the requirement.
  • Involved in performing tasks such as Scheduling Scripts to run on daily and weekly basis to extract the data from source systems and load in planning system.
  • Applied several Data Transformation Rules on the source data as per the business requirements.
  • Extensively used Analytical functions.
  • Effectively used Query Rewrite clause.
  • Developed Triggers to log the changes in sales order tables.
  • Created/Modified Indexes where ever necessary to increase the performance.
  • Developed Batch interfaces for batch jobs.
  • Provided Production Support and applied Hot Fixes to production issues.
  • Extensively used Bulk Collection techniques to load heavy volumes of data.
  • Developed Test Cases and documented test results for business review.
  • Involved in documenting the ETL procedures for future review.

Environment: Oracle 10g/11g, TOAD, SQL Developer, WinCVS, Windows XP

Confidential, St Louis, MO
Aug 2007 – June 2008
Project Mercury – Migration to SAP
Database Analyst/Developer
Confidential, is one of the pioneers in manufacturing agricultural based products. The goal of Project Mercury is to migrate legacy systems/data (from Seminis Inc.) into Confidential, ’s SAP system. These legacy systems include 11 SAP systems and 16 Non - SAP systems located in different regions across the globe.
The data from the legacy systems are extracted on a monthly basis. The legacy data to be migrated includes master data like Customer, Vendor and Material and transactional data like Accounts Receivables, Accounts Payables, General Ledger and Inventory. All the master data is loaded prior to loading the transactional data. Data is validated/reconciled at all phases of development before and after migration.

Responsibilities:

  • Developed/Scheduled Scripts to extract the data from legacy databases which include SQL Server and Oracle 9i using DB Links.
  • Responsible for validating and reconciling the data to the month end reports given by the business.
  • Extensively used SQL Loader for loading flat files and excel sheets into Oracle Staging area.
  • Responsible for creating/modifying tables and views and granting privileges on these schema objects as per the business and technical requirement.
  • Developed several SQL Scripts while reconciling the transactional data.
  • Applied several Joins and Filters on various tables and views to reconcile the transactional data.
  • Fine tuned the SQL scripts for faster execution using Explain Plan.
  • Proficiently used TOAD and SQL Developer for interacting with the Oracle database.
  • Developed and Debugged PL/SQL packages, procedures, triggers and functions.
  • Extensively used these packages and procedures for implementing various business rules.
  • Embedded various Data Transformation/Mapping rules using PL/SQL.
  • Performed several ETL (Data Migration) activities using SQL and PL/SQL.
  • Extensively used Pivot tables for generating Reconciliation reports at different Aggregation levels.
  • Extensively used PERL Scripts to generate Control files and BDC error log files.
  • Used BDC Recording, LSMW and Batch input techniques for loading the transformed/cleansed legacy Data into SAP.
  • Loaded and tested legacy data to development and testing systems in SAP before loading to production system.
  • Reconciled the data in all the systems. Generated pre load and post load reconciliation reports using PL/SQL.
  • Trained other team members in using the Procedures and Loading techniques to perform concurrent loads with in the given dead line.
  • Documented ETL Procedures for future Re-Use.

Environment: Oracle 10g, TOAD, SQL Developer, SQL Loader, MS Access, PERL,
SAP ECC 4.6C, Windows XP

Confidential, Overland Park, KS
Mar 2006 – July 2007
Logistics Solutions
Oracle Developer
Confidential, is a leading logistics provider. The main Forte of Yellow roadway is their density and volume of shippers and receivers and the many to many relationships amongst them to deliver goods and provide logistics in the most efficient way. This system mainly deals with bookings, deliveries and transshipment of parcels. Booking can be made in three different ways namely Paid, To-pay, Deferred parties. In a booking station Daily Remittance Statement (DRS) is prepared by EOD, which includes all transactions for the day. This application provides facility to maintain and view day-to-day reports based station wise, agent wise and so on. This application is also integrated with the financial system to provide Day Books, GL’s, TB’s and P&L account statements.

Responsibilities:

  • Creating, debugging and modifying stored procedures, functions, packages, triggers, tables and views using PL/SQL and SQL.
  • Creating database tables and coding database Triggers.
  • Customization Analysis of existing database and modification of various existing packages, procedures, functions and triggers according to the new business needs.
  • Creation of schema objects, Granting Roles and Privileges to the users.
  • Involved in code reviewing and performance tuning using optimization techniques in PL/SQL
  • Mostly used in Explain Plan Techniques for tuning SQL Queries.
  • Enabled Query Rewrite on materialized views for optimizing SQL queries.
  • Used RDBMS Packages to implement and schedule Dynamical SQL and extensive usage of Ref Cursors.
  • Extensive use of UNIX commands to execute/compile stored procedure from the UNIX environment.
  • Extensively used Normalization Techniques for fine tuning the database to reduce the Data Redundancy for better performance.
  • Extensively used TOAD for extracting scripts from the dictionary.
  • Supporting to solve data warehouse issues.
  • Supporting to Java web development team.
  • Involved in brainstorming sessions with business analysts on new functionality change requests.
  • Involved in preparing detailed technical documents.
  • Preparation of checklists, identification of test cases and preparing test plans.
  • Active participant in code reviews and test case meetings.

Environment: Oracle 9i/10g, SQL Loader, Java, J2EE, UNIX and Windows XP, SQL Navigator, TOAD, Erwin tool.

Confidential, TX
Dec 2004 – Feb 2006
Project: TRIMS (Trade Information Management System)
Senior Oracle Developer
Confidential, is a comprehensive Global Trade Finance Division (GTFD) system that process transactions from initial registration to final liquidation for all GFTD products. This application is designed to provide end-to-end trade process support on a single global system platform. Transaction registration, Letter of Credit (LC) issuance, advising, amendment processing, bills (Payments) processing, fund accounting like transfer the funds to normal accounts to fund account for budget allocation, normal accounting processing and static database (SDB) maintenance are some of the facilities that are made available in the software.

Responsibilities:

  • Key team member in interacting with the client and gathering Requirements.
  • Developed PL/SQL Packages, stored procedures, functions, database triggers and packages to access the database from front end screens.
  • Solved many performance issues using Optimization Techniques and Explain Plan.
  • Migrate the data from excel sheets, text files into the respective Oracle database tables using SQL*Loader Scripts.
  • Provided database support to testing team in writing the complex SQL queries.
  • Involved in PL/SQL Performance Tuning.
  • Written conversion scripts to load data from flat file to Database.
  • Involved in the analysis of the existing database.
  • Involved in creation of Indexes and database triggers.
  • Involved in Code Review and preparing Unit Test cases.
  • Prepared weekly/ monthly status reports.
  • Supporting to solve the problems in Data warehousing.
  • Export and import of data from QA to Development environment.
  • Creation of Schema Objects, Granting of Roles and Privileges to the users.
  • Extensively involved in knowledge transfer for the documentation team for the development activities carried out by our team.
  • Provided support in database modeling and design
  • Extensive use of UNIX commands to execute/compile the stored procedure from the UNIX environment.

Environment: Oracle 9i, SQL plus, TOAD, SQL Navigator, HP-Unix.

Confidential, Detroit, MI
Feb 2004 – Nov 2004
Integrated Spares and Service Management System
Oracle Developer
Integrated Spares and Service Management system maintains stock detail for different vehicle spare parts, register customer complaints and maintain labor details. This system also has the capability to maintain repair orders, which includes party and vehicle history and detailed billing for replacement of damaged spare parts. The application can also generate reports such as purchase order reports, sale order reports and stock balance reports to name a few.

Responsibilities:

  • Collection of user requirements by participating in interviews and studying the existing system.
  • Creation/modification of PL/SQL Packages, stored procedures, functions and triggers.
  • Involved in the analysis of the existing database.
  • Use of RDBMS Packages to implement, scheduling, Dynamic SQL and Ref Cursors.
  • Design and develop the Forms and Reports.
  • Involved in the writing of Pro C Programs.
  • Extensive Use of normalization techniques in fine tuning the database to reduce the data redundancy for better performance.
  • Used SQL *Loader to load data in to Oracle database tables.
  • Involved to solve the performance issues using optimization techniques.
  • Involved in creation of Indexes, Database Triggers and Views.
  • Written SQL Scripts to format data and generate customized reports.
  • Provide end user training and documentation.
  • Extensive use of UNIX commands to execute/compile the stored procedures/forms from the UNIX environment.

Environment: Oracle 9i, Forms 5.0, TOAD, SQL Navigator, Pro*C, UNIX, Windows NT.

Education:

  • M.S Software Engineering (Specialization in Management)

We'd love your feedback!