Sql Data

Sateesh Ganguru

Cell: 469-***-**** Mail: ****************@*****.***

Professional Summary:

* + years of IT experience in Business Requirements Analysis, Application Design, Database design, Data Modeling, Development, Database Marketing, Testing, Implementation, SQL Performance Tuning, Data warehousing ETL process and Client/Server applications for Retail, and Healthcare Industries.

Extensive experience in developing stored procedures, functions, triggers and packages using tools SQL*PLUS, TOAD, PL/SQL Developer and IBM Data studio.

Expertise in Unix shell scripting and automated task scheduling using crontab.

Experience in analyzing business rules and coordinating in application design and database design.

Used DML triggers to update the tables when any DML event occurs and developed Database Triggers to enforce security.

Experience in Oracle Forms 11g/10g/6i, Reports 10g/6i and PL/SQL.

Experience in all phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing, documentation, implementation support and maintenance.

Worked on Layout design, Data models which used Placeholder, Summary, Formula Columns and prepared user manuals for objects developed using Reports and Forms builder.

Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.

Extreme use of Exception Handling methods along with PRAGMA_EXCEPTION_INIT in order to associate user defined exception names.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DBMS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.

Expert knowledge in using Data Modeling tools like ER diagrams with Normalization Techniques for designing database with Relational technology.

Extensively involved in Query Level Performance tuning using Optimizer Hints, partitioning tables and Indexes.

Experience in performance tuning and Optimization of SQL queries using Explain Plan.

Strong Programming and debugging skills in PL/SQL, MySQL, Dynamic SQL, C, Pro*C and Unix Shell Scripting.

Extensive experience in Enterprise Data warehousing. Design of Extraction, Transformation & Load (ETL) environment.

Good experience on OLTP and OLAP systems.

Extensively worked on Code migration from Development, Systest and Production.

Demonstrate the analytical ability to understand the business requirement/process, convert the business specification to technical document, data management, develop and integrate solutions to meet the requirement.

Strong in Designing, Development (coding), Testing, Implementation and Documentation as per Industry standards.

Possesses the ability to work autonomously as well as Team management experience.

Excellent communication, inter personal, presentation, strong analytical and trouble shooting skills.

Technical Skills:

Tools

TOAD, SQL *Plus, SQL *Loader, SQL Developer, Informatica, Pentaho, liquibase, System,iNavigator,IBMDataStudio,GitHub,Tableau, Reports Builder 6i/10g,Forms Builder 6i/9i/10g, Data Pump (expdp/impdp), Erwin, ER/Studio

RDBMS

Oracle 12c/11g/10g/9i, DB2 on AS400, DB2 on LUW, Maria DB, SQL Server

Languages

PL/SQL, RPG, Unix Shell Scripting, Java, XML, HTML, Perl Scripting and PRO*C.

OS

UNIX (Sun Solaris, AIX), Linux and Windows NT/2000/XP.

Professional Experience:

Client : Copart Inc, Dallas,TX Aug 2015 – Sep 2017

Project : Seller / Member Applications

Role : Database Developer

Responsibilities:

Worked on projects using AGILE/SCRUM methodology.

Involved in entire project life cycle including database Design, Development, Testing, Optimizing, deploying on development and production servers.

Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures, Clusters, Triggers and maintaining referential integrity.

Involve in conversion of 10g forms into 11g as well as 32-bit to 64-bit Pro C modules and make sure they function as supposed to.

Resolve issues with Oracle 11g Forms/Reports application, such as workstation using side printers for slip printing and other reported problems.

Performed ETL operations using Pentaho Kettle to design jobs and transformations resulting in data migration.

Analyze technical requirements and design new data objects to support our internal SOLR search engine.

Actively participated in Database design and functionality implementation of Proquote Module as part of Seller Application.

Developed Forms, Reports, Menus, Object Libraries, and the PL/SQL Library using Oracle Forms 12c.

Convert stored procedures and functions from DB2 AS400 format [written in RPG ] to pure SQL on Oracle DB.

Actively participated in the data migration during the G1 Applications integration.

Extensively worked on pealing out the member, seller and auction modules from DB2 on AS400 to Oracle DB.

Extensively worked on Virtual sale project to push to prod, which resulted in the Huge growth of the company sales.

Deploying the database objects like tables, views and stored procedures using Liquibase.

Maintaining the database objects procedures, service programs, table functions and indexes on tables in DB2 environment, which has been developed using RPG language and converting them to SQL if needed.

Providing the field logic to search team to implement the logic in SOLR which improves the performance of application calls to get results faster.

Created views, temp tables, pre-migration and post migration scripts as part of G1 2.0 Data Migration across DB2 on LUW and Oracle DB.

Actively participated in the data modelling of seller, member and Yard databases as part of G1 2.0 and 2.1 versions development.

Good knowledge on using tableau to generate some ad-hoc reports and dashboards.

Helping the reporting team to develop their reports and providing the business logic to retrieve the data.

Performance tuning and optimization of SQL queries, stored procedures, functions and batch reports.

Gathering the metadata from business and load it to databases to support different application teams.

Helping the application team during the production bugs and handling major projects deployment to production.

Running the Sumo logic queries on production to capture the C2 error logs and Handling the business exceptions.

Handling tickets raised for SQL bugs in stored procedures and function by business user and QA team.

Environment: DB2 on AS400, Oracle 12c, SQL, PL/SQL, Forms 12c, TOAD, SQL*Loader, SQL Navigator, Windows, IBM i series Navigator, Tableau, Pentaho, IBM Data Studio, Liquibase, Unix.

Client : Epsilon Inc, Bengaluru, IND Aug 2013 – June 2014

Project : JCPenney CRM

Role : PL/SQL Developer

Responsibilities:

Actively involved in interacting with front end users and gathered user requirement and online system specification.

Created PL/SQL Stored Procedures, Packages, and Triggers for implementing business logic.

Responsible for performing code reviews.

Involved in preparing ETL design and Source to Target Mapping documents.

Extensively used Expression, Filter, Sorter, Router, Joiner, Aggregator, Sequence generator, Lookup and Update strategy transformations.

Developed number of complex Informatica Mappings, Mapplets and Reusable Transformations for several Informatica load jobs.

Responsible for creating the unit test plan, test cases and documenting the unit test results.

Using Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.

Performance tuning and PL/ SQL tuning.

Creation of database objects like tables, views, Indexes on tables, synonyms, materialized views, stored procedures, packages using oracle tools like TOAD.

Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.

Developed PL/SQL blocks using Collections like Nested Tables and Varrays, Bulk collections and Exception handling.

Developed executive level Forms and Reports for invoice details by customer, by item, by product type using Oracle Forms and Reports 10g.

Developed and customized daily, weekly, monthly Orders Reports for Business and scheduled these jobs using Auto sys.

Worked with Application Team and Testing Teams to ensure interfaces and data loads are accurate as per the design specifications.

Developed Test Cases and Test Scripts for System and UAT Testing.

Performed Positive and Negative Testing for this application.

Extensively used SQL queries to check storage and accuracy of data in database table.

Performed basic testing of security features using manual testing.

Kept track of execution, Unit test cases and defects for smooth functioning.

Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

Generated the order matrix reports, open PO’s report, and order transmission reports.

Used SQL* Loader, Data Pump (expdp/impdp) and UTL_FILE for loading data into the interface tables.

Created Shell Scripts for automating the execution process of the orders.

Involved in Bug fixing within Packages and Stored Procedures.

Used PuTTY for secure remote shell access to a UNIX/Linux system.

Created unit test cases, test case review and testing.

Optimized the queries to improve the performance of the application.

Environment: Oracle 11g, Toad, PL/SQL, SQL, Teradata, Tableau 7, SQL*LOADER, UNIX, Informatica 8.6, UNIX Shell Scripting, Reports 10g/11g, Forms 11g, Oracle Data Integrator ODI 11g/12c

Company : ISOFT Technologies, Hyderabad, India June 2012 – Aug 2013

Project : Roche Diagnostics and IDS (Insulin Delivery System)[ Fulcrum Analytics Inc]

Role : Oracle PL/SQL Developer

Responsibilities:

Involved in preparing Database Design, High level and low-level documents.

Developed back end interfaces using PL/SQL stored procedures, functions, packages, triggers, collections, object types and K-shell scripts.

Involved in ETL design to convert different file formats into pre-defined XML format and automated this process for different file formats.

Improved performance of reporting mart and some ODS processes.

Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, partitions, triggers, db links and privileges.

Worked with Power Center Designer tools in developing mappings and mapplets to extract and load the data from flat files and SQL server (source) to Oracle (target).

Created different transformations for loading the data into targets using various transformations and also involved in creating Data Marts.

Created reusable transformations and mapplets to use the transformation logic in multiple mappings.

Scheduled Sessions on the Informatica Server using Informatica Workflow Manager.

Improved the performance of existing phone and email merge purge process.

Automated unica flowchart files QC.

Migrated data from Flat Files to Oracle database using SQL*Loader and External tables. Wrote Oracle PL/SQL programs for backend processing.

Implemented Oracle Table functions and With Clause queries in PL/SQL scripts which have written for ETL process.

Implemented Oracle Regular Expression functions REGEXP_SUBSTR, REGEXP_REPLACE, REGEXP_INSTR and REGEXP_LIKE to parse and extract the strings in PL/SQL procedures.

Responsible for SQL tuning and optimization using Analyze, Explain plan

Implemented external tables for loading data into database.

Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables. Used Cursor Variables to pass query results sets between PL/SQL programs.

Wrote Unix Shell Scripts to send (ftp) files to other systems.

Wrote perl scripts to convert the data in oracle table into XML format.

Responsible for performing code reviews.

Testing of all the deliverables done with User support.

System Support – Assisted Client for User Acceptance Test for new releases

Environment: Oracle 11g/10g, SQL*PLUS, SQL, PL/SQL, SQL*Loader, UNIX (AIX 5.3), PL/SQL Developer, Informatica, XML, HTML, First Logic, Windows NT, Unix korn Shell, Perl

Company : US Tech Solutions, Hyderabad, India August 2011 – June 2012

Role : Oracle Developer

Responsibilities:

Actively participated in gathering Business Requirements and System Specification from system users.

Designed database tables using various Normalization techniques and database rules.

Developed stored procedures to apply business logic on raw data.

Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.

Involved in preparing the User Test plans.

Developed web based front-end screens using Forms 6i.

Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.

Developed reports as per the requirements collected from the users using Oracle Reports 10g.

Tuned complex stored procedures for faster execution and developed database structures according to the requirements.

Involved in importing the production data to work environment through TOAD.

Involved in handling the changes in compiling scripts according to the database changes.

Created Shell Scripts for automating the execution process.

Involve in migrating applications to the new release versions.

Environment: Oracle 10g, Oracle Forms 6i, Oracle Reports 9i, Perl Scripting, PL/SQL TOAD, UNIX.

Contact this candidate