Resume

Sign in

Sr. Data Warehouse PL-SQL / ETL Developer

Location:
Bridgewater Township, New Jersey, United States
Posted:
December 21, 2018

Contact this candidate

Resume:

SHANMUGAM NEELAKANTIAH

(SHAN)

Email : ac702m@r.postjobfree.com

Mobile # : 919-***-****

SUMMARY:

Overall 20+ years of IT experience as Technical Lead / Team Lead / Senior Developer in Software Development, Maintenance and Enhancement Projects in Investment Banking, Telecom, Healthcare, Human Resources and Manufacturing domains.

Hands on experience in designing and creations of Tables, Views, Database Triggers, Stored Procedures, Functions and Packages, Exception Handling, Implicit and Explicit Cursors, Ref Cursors, Database Links, Sequences etc.

Strong experience in writing Co-Related Sub Queries, In-Line Views, Inner / Outer Joins, Autonomous Transactions, Optimizer Hints, Mutating Tables, Materialized Views, Dynamic SQL using DBMS_SQL and EXECUTE_IMMEDIATE, UTL_SMTP etc.

Strong Backend and ETL Development skills and extensive experience with Informatica, Oracle PL/SQL, Oracle DBMS packages like UTL_FILE, UTL_CALL_STACK, PL/SQL Advanced features like Records, Bulk Collections, FORALL Insert, FORALL Update and External Tables, Pipelined Functions, SQL Advanced features like Merge Statements, Multi Table Inserts, Hierarchal Queries, Analytical Functions etc in Data Warehouse Environment.

Experienced in using Informatica for ETL processes, to export and import data between SQL Server databases and Oracle databases and to load data from flat files.

Developed many Informatica Mappings and Workflows to generate flat files from database tables and FTP them into secured FTP servers for the consumption of the downstream systems.

Using Informatica, extracted data from multiple operational sources to load into Staging Area, Data Warehouse and Data Marts using CDC/SCD (Type1/Type2/Type3) loads.

Used various Informatica Transformations such as Filter, Expression, Router, Lookup (Connected and Un-Connected) and Stored Procedure in many Informatica Mappings.

Used ETL process to process 90+ Million rows of data.

Develop, monitor, debug and provide production support for Autosys, Informatica Workflows and Crontab jobs.

Expertise in SQL and PL/SQL Performance Tuning and greatly enhanced the performance of many SQL queries and PL/SQL programs.

Extensively used TOAD, PL/SQL Developer, and Oracle SQL Developer tools to improve the productivity.

Strong with Partitioned Tables, Partition Strategies and Statistics, Global and Local Indexes and use of Global Temporary Tables (GTT). Worked extensively with Export / Import, SQL*Loader, External Tables.

Migrated MS Access applications into Oracle 8i. Studied the existing business logic and rewrote the applications in Oracle Forms 6i / Reports 6i.

Worked with FACETS Data Model in Healthcare Domain to develop applications using Oracle Forms, Oracle Reports and PL/SQL Backend Packages.

Experienced in Physical and Logical Data Modeling. Used Designer/2000, ERWin and PowerDesigner for Data Modeling. Worked with Star Schema and Snowflake Schemas.

Strong experience in Developing, Tuning and Debugging of UNIX/Linux Shell scripts. Debugged PERL scripts. Supported numerous applications in Data Warehouse / OLTP environment.

Good communication and interpersonal skills and ability to work in a team and at all levels.

TECHNICAL SKILLS:

Operating Systems : Windows / UNIX / LINUX

Programming Languages : PL/SQL, Pro*C, Java, Shell Scripts

RDBMS : Oracle 11g / 12c, SQL Server 2008 R2 / 2014

Tools : Informatica 9.6/10.2, PowerDesigner 16.6, ERWin, Designer/2000,

Developer/2000 (Forms 6i, Reports 6i & Graphs: 6i), TOAD 12.2,

Oracle SQL Developer, PL/SQL Developer, Tortoise SVN, Git Bitbucket,

Remedy ITSM, Control M, Autosys, FACETS 4.5.1

EDUCATION / CERTIFICATIONS:

ME in Engineering (Electrical Engineering) From Anna University, India – 1993

BE in Engineering (Electrical Engineering) From Bharathiar University, India – 1990

Oracle Certified Associate (OCA) – 2007

Advanced Diploma in Software Export Technologies - C, C++, VC++ 5.0, Visual Basic 4.0, Oracle 7.3, Developer/2000, Power Builder 5.0

PROFESSIONAL EXPERIENCE:

Insight Global LLC, USA Aug 2017 – To Date

Sr. Data Warehouse PL-SQL / ETL Developer

Client Duration Project : Bank of America Jul 2018 – To Date Compliance Risk Assessment (CRA)

Responsibilities:

Develop Procedures, Functions, PL/SQL Packages, Load Views and Triggers to retrieve data from source system and load them into multi-dimensional 10 Terabytes Oracle Data Warehouse in Agile development environment.

Interact with the Business Analyst and Data Modeling team to understand the requirements, design the ETL process, create tables, views and interface programs.

Developed complex Informatica mappings that involved in implementation of Business Logic to load data into staging area using Informatica PowerCenter tools and finally load them into the target database tables in the Oracle Data Warehouse environment using CDC/SCD (Type1/Type2) loads.

Extensively involved in Unit testing and Integration testing as part of development and deployment process.

Used Autosys and Linux Shell scripts to schedule and automate data load.

Involved in Process Optimization and Performance Tuning of SQL queries and PL/SQL programs using parallel query options, SQL Hints and Global Temporary Tables. Tuned offensive Ref Cursor Queries execution from 10-20 minutes to less than a minute.

Closely working with DBA team to address all production and developments issues.

Used Bulk Collections, Record Types, PL/SQL Table Types, Ref Cursors, MERGE Statements, Oracle Dynamic SQLs (EXECUTIVE IMMEDIATE) and UTL_SMTP in the PL/SQL Packages to improve the overall performance of the program execution.

Work with Partitioned Tables and Materialized Views.

Responsible to work with and lead off-shore and on-site teams in a shared resources Agile Process environment.

Environment: Oracle 11g on Exadata, TOAD, Oracle SQL Developer, Informatica 9.6/10.2, Autosys,

LINUX Version 2.6, Shell Scripts, PowerDesigner 16.6, Tortoise SVN, Git BitBucket.

Client Duration Project : Bank of America Aug 2017 – Jul 2018 Wholesale Credit Authorized

Data Store (WCADS)

Responsibilities:

Working in Application DBA group to design metadata driven ETL load strategy to load data into the Unified Credit Model (UCM) database for operational and data warehouse needs.

Develop Procedures, Functions and PL/SQL Packages to extract data from Stage database and load them into Data Warehouse in Agile Process

Involved in Table Partition Strategies and implemented partition exchange mechanism using PL/SQL package code to exchange partitions in data warehouse tables.

Implemented generalized Exception Handling process using UTL_CALL_STACK utilities.

Contributed to database access security model using multiple levels of roles and grants for user access.

Promoting codes to various lanes and sub-lanes to meet different Agile Sprint Cycles development teams.

Utilized Oracle ERR$ table feature to capture offending records during DML inserts by ETL layer into stage tables.

Work with and lead off-shore and on-site teams in a shared resources environment in Agile Process

Environment: Oracle 12c on Exadata, TOAD, Oracle SQL Developer, LINUX Version 2.6, Shell Scripts,

Git BitBucket.

Tata Consultancy Services, USA Jul 2017 – Aug 2017

Sr. Data Warehouse PL-SQL / ETL Developer

Client Duration Project : SEI Investments Jul 2017 - Aug 2017 Team 0 App Admin

Responsibilities:

Develop Procedures, Functions, PL/SQL Packages, and Triggers to retrieve data from different databases and load them into Oracle Data Warehouse.

Create DDL structures for tables, views, sequences.

Environment: Oracle 11g, Informatica 9.6, Oracle SQL Developer

Data Inc., USA Dec 2015 – May 2017

Sr. Data Warehouse PL-SQL / ETL Developer

Client Duration Project : Bank of America Dec 2015 – May 2017 Operational Risk and Compliance

Integrated Technology (ORCIT)

Responsibilities:

Develop Procedures, Functions, PL/SQL Packages, and Triggers to retrieve data from different databases and load them into multi-dimensional Oracle Data Warehouse of 6 Terabytes in size.

Interact with Business Analyst and Data Modeling team to understand the requirements, design the ETL process, create tables, views & interface programs. Also work with Partitioned Tables, Materialized Views.

Developed complex Informatica mappings to implement the Business Logic to load data into staging area using Informatica PowerCenter tools and finally load them into the target database tables in the Oracle Data Warehouse environment using CDC/SCD (Type1/Type2) loads.

Extracted data from various heterogeneous sources like Oracle, SQL Server and Flat Files using various Informatica Transformations like Joiner, Expression, Aggregate, Lookup (Connected and Un-Connected), Stored procedure, Filter, Router transformation, Update strategy transformations to load data into Oracle Enterprise Data Warehouse using Star Schema.

Used Autosys and Linux Shell scripts to schedule and automate data load.

Provide database and ETL support to other ORCIT work stream development teams.

Involved in Process Optimization and Performance Tuning of SQL queries and PL/SQL programs using parallel query options, SQL Hints and Global Temporary Tables.

Used Bulk Collections, Record Types, PL/SQL Table Types, Ref Cursors, MERGE Statements, Oracle Dynamic SQLs (DBMS_SQL and EXECUTIVE IMMEDIATE) and UTL_SMTP in the PL/SQL Packages and Procedures to improve the overall performance of the program execution.

Work with numerous teams within the Bank to provide support and co-ordinate for all the production code release/deployment activities. Also used BMC Remedy IT Service Management tool create CRQs for production deployment and to track issue tickets.

Work with and lead off-shore and on-site teams in a shared resources environment.

Environment: LINUX Version 2.6, Autosys, Oracle 11g on Exadata, SQL, PL/SQL, TOAD 11.6 for Oracle,

TOAD 6 for SQL Server, Microsoft SQL Server 2008 R2 / 2014, Informatica 9.6, Shell Scripts

Sunrise Systems Inc., USA May 2007 – Nov 2015

Sr. Data Warehouse PL-SQL / ETL Developer

Client Duration Project : Avaya Inc. Jul 2011 – Nov 2015 Enterprise Data Team

Responsibilities:

Develop Procedures, Functions, PL/SQL Packages, and Triggers to retrieve data from different databases and load them into multi-dimensional Oracle Data Warehouse of 5 Terabytes in size and implement the business logic to prepare the data for the end users and downstream systems.

Also developed SQL Server Procedures and complex validation queries to publish the data to other consumer applications

Interact with the Business Analyst team to understand the requirements, designing the database applications including tables, views and interface programs.

Worked on Partner Benchmark Scorecard Reports and provided all the SQL and PL/SQL support to Cognos Reports to address data and validation issues.

Extracted data from heterogeneous sources like Oracle, SQL Server and Flat Files using complex Informatica Mappings and Transformations like Joiner, Expression, Aggregate, Lookup (Connected and Un-Connected), Stored procedure, Filter, Router transformation, Update strategy transformations to load data into Oracle Enterprise Star Schema Data Warehouse and Data Mart using CDC/SCD (Type1/Type2) loads.

Developed Informatica Workflows to create flat files from the database tables and FTP them to a secured FTP server location. Used Linux Shell scripts to automate data loads, FTPing the processed the files. Also used Crontab and Autosys to automate the scheduled jobs.

Migrated many SQL Server database objects like tables, views, stored programs, DTS into Oracle database objects. Automated many manual scripts into Oracle programs to improve productivity

Developed Oracle programs to Extract data from heterogeneous database like SAP and Siebel, Cleanse the Extracted data, Transform and Aggregate them and finally loaded into Oracle Enterprise Data Warehouse using both PL/SQL program and Informatica mappings.

Provide database support to the Hyperion Essbase application team to build their OLAP.

Extensively involved in Performance Tuning of SQL queries and Code and Process Optimization. Tuned offensive queries execution form 2 hours and 30 mins to 20 minutes.

Send data to DnB to get customer matching and process and load the returned data from DnB.

As an Application DBA for the Enterprise Data Warehouse and Data Mart, responsible for the development and maintain 20+ applications, create and maintain necessary grants and privileges.

Used Bulk Collections, Record Types, PL/SQL Table Types, Ref Cursors, MERGE Statements, Oracle Dynamic SQLs (DBMS_SQL and EXECUTIVE IMMEDIATE) and UTL_SMTP in the PL/SQL Packages. Also used both External Tables and SQL* Loaders to load data from the flat files into Oracle tables.

Performing complex month end and quarter end process to process and load 90+ million rows of data

Work with Partitioned Tables and used parallel query options and SQL Hints for improved performance.

Provide production support to database applications and perform routine data loadings including weekends

Environment: LINUX Version 2.6, Oracle 9i/10g/11g, SQL, PL/SQL, TOAD 9.5, Oracle SQL Developer 3.2,

Microsoft SQL Server 2000/2008 R2, Informatica 8.1 / 9.1, Cognos 8.4, Shell Scripts, Autosys

Client Duration Project : Credit Suisse Group Aug 2009 – Jul 2011 Derivatives Results Database

Responsibilities:

Develop PL/SQL Packages, Procedures, Functions and Triggers to retrieve and load data from different database tables and implement the business logic to prepare the data to the downstream systems.

Interact with the Business Analyst team of Derivatives Results Database (DRD) to understand the requirements, designing the database applications including tables, views and interface programs.

Extract the data loaded by the providers from the staging database and bridge them to DRD Data Warehouse (2.7 Terabytes in size).

Extracted Data are cleansed / transformed / aggregated and finally loaded into Data Warehouse for DRD consumers usage.

Used Bulk Collections, Record Types, PL/SQL Table Types, Ref Cursors, MERGE Statements, Oracle Pipelines Functions, Analytical Functions, Dynamic SQLs (DBMS_SQL and EXECUTIVE IMMEDIATE), Oracle Object Types and Object Views in the PL/SQL Packages and Procedures to improve the overall performance of the program execution. Also used SQL*Loader to load data into test environments.

Work with Partitioned Tables and partitioned level statistics, used parallel query options and SQL Hints.

Work with Middle Tier team to integrate the database code with .Net applications.

Provide rotational weekly production support to DRD applications and monitor DRD Control-M jobs

Co-ordinate with DBA’s and Environment set-up team to promote the code to QA, UAT and Production Environments. Developed binary comparison tool to automate and assist the Regression Testing.

Extensively involved in Code Optimization and SQL Query Tuning to reduce some of the offensive queries execution timings from 30 minutes to 3-5 minutes. Used DBMS_PROFILER, EXPLAIN_PLAN, TKPROF, AWR Reports and Optimizer Hints for Performance Improvements.

Environment: SUSE LINUX Enterprise Server 9, Oracle 10g Release 2, SQL, PL/SQL, PL/SQL Developer,

ClearCase, Subversion, SharePoint, Quality Center, Remedy ITSM, Control-M.

Client Duration Project : CareFirst Blue Cross Blue Shield Nov 2008 – Aug 2009

Model Office Service Domain

Responsibilities:

Develop PL/SQL Packages, Procedures and Functions to retrieve data from numerous FACETS 4.5.1 tables based on the business logic.

Responsible for business process analysis, designing and developing the data extraction algorithm to extract data from FACETS 4.5.1 Data Model Tables for Domains like Subscriber/Member, Claims, Providers, Groups, Plan and Billing, etc.

Provide support to the TIBCO Middleware team by developing custom SQL queries based on FACETS 4.5.1 ERwin Data Model.

Used SQL*Loader to read the data from flat files and load into Oracle Tables.

Co-ordinate with DBA’s for code promotions to various Test Environments (like Integration, System, UAT, Training and etc) and Production Deployment. Used Process Management Tool Serena TeamTrack for code promotions work flow activities. Also Responsible for creating and maintaining the build process

To meet the Voice Response Unit (VRU) team’s expectations, extensively involved in Code Optimization and SQL Query Tuning to reduce some of the queries execution timings from 2 seconds to 300-400 Milliseconds. Used DBMS_PROFILER, EXPLAIN_PLAN, TKPROF and Optimizer Hints for Performance Improvements. Worked with Materialized Views to improve the Query and Application Performance.

Used Bulk Collections, Record Types, PL/SQL Table Types, Ref Cursors in the PL/SQL Packages and Procedures to improve the overall performance of the program execution.

Maintain Version Control and Baseline Code using Serena Dimensions Configuration Management Tool.

Environment: FACETS 4.5.1, Oracle 10g Release 2, SQL, PL/SQL, TOAD 9.6, Oracle SQL Developer,

Serena Dimensions, Serena TeamTrack.

Client Duration Project : Employment Security Commission Of North Carolina May 2008 – Nov 2008

JobConnector Job Matching System

Responsibilities:

Developed PL/SQL Packages, Procedures and Functions to retrieve data based on various Search Criteria for Job Seekers, ESC Staff and Employers. Modify the existing data model to meet the new requirements.

Used Erwin for data modeling. Created various reports using Stored Procedures and Functions

Extensively involved in SQL Query Tuning Process and reduced the Execution Time of 20+ queries from 25 – 45 minutes to 1-2 seconds. Used EXPLAIN_PLAN and Optimizer Hints (PARALLEL, INDEX, INDEX_FFS) to improve the query execution time.

Actively involved in PL/SQL Performance Improvements and Application Stress Tests. The Performance Improvements resulted the application from 200 concurrent users to run 3200 concurrent user with less than 30% of CPU Utilization during the Application Stress Test.

Used Bulk Collections, Record Types, PL/SQL Table Types, FORALL Insert, FORALL Update, Dynamic SQLs, REF CURSORS, Bind Variables, DBMS_SESSION, SYS_CONTEXT features in the PL/SQL Packages and Procedures to improve the overall performance of the program execution.

Created and Worked with Materialized Views to improve the Query and Application Performance.

Used Oracle’s Advanced Queuing features for En-queuing and De-queuing the Messages using DBMS_AQ package.

Environment: Oracle 10g Release 2, SQL, PL/SQL, TOAD 9.6, Oracle SQL Developer, .NET

Client Duration Project : Credit Suisse Group May 2007 – May 2008 Deferred Compensation- HR IT

Responsibilities:

Developed PL/SQL Packages to generate Journal Entries for various Accounting Entry Types for employee compensation.

Used PL/SQL Table Types, Record Types, Bulk Collections, FORALL Insert, FORALL Update and Hierarchical Query features in the PL/SQL Packages to improve the overall performance of the program execution.

Involved in SQL and Application performance improvements. Used EXPLAIN_PLAN and Optimizer Hints (PARALLEL, INDEX, INDEX_FFS) to improve the query execution time.

Written PL/SQL package and SQL*Loader scripts to automate the testing and validating the Business Test Cases. Used UTL_FILE package for File Handling with different field delimiters.

Implemented performance improvement in eHR Module and reduced the query execution time from 2:00 hours to 3 minutes.

Environment: Oracle 10g, SQL, PL/SQL, DBArtisan, PL/SQL Developer, SQL*Loader, Sun Solaris 5.7, .NET

Cognizant Technology Solutions, India Jan 2007 – Apr 2007

Sr. PL/SQL Developer

Client Duration Project : Cognizant Technology Solutions – Healthcare Practice

Jan 2007 – Apr 2007 Data Mart Design for Pharmacogenomics

Responsibilities:

Identifying strategies to implement the Samples Coding Processes using Oracle PL/SQL.

Code home grown ETL scripts in Shell and SQL to load data from disparate systems into the data mart. Used SQL*Loader to load data into the data warehouse. Analyzed existing SQL and Tuned offensive SQL

Wrote PL/SQL procedures and triggers for data cleansing / data scrubbing.

Environment: Oracle 9i, SQL, PL/SQL

Verizon Data Services, India Dec 2003 – Jan 2007

Sr. PL/SQL Developer, Technical Lead

Client Duration Project : Verizon Communications, USA Dec 2003 – Jan 2007

Network Metrics Portal

Responsibilities:

Developed SQL and PL/SQL code to implement the business logic for the generation of various Metrics Reports from a VLDB (10TB) Oracle Data Warehouse and Data Mart. Wrote complex Data Manipulation and Data Validation scripts in PL/SQL. Used parallel query options and SQL Hints for Partitioned Tables.

Responsible for Design/Development/Automate the ETL process using Informatica, SQL, PL/SQL and Shell Scripts. Wrote validation scripts for data integrity check, data consistency, data cleansing and scrubbing.

Enhanced and provided support to numerous applications in the Data Warehouse environment.

Load data from numerous flat files coming from SAP, Mainframes and other Legacy systems into Oracle Data Warehouse and Data Mart, using Informatica Power Center Server Manager.

Generate various Metric Reports using MicroStrategy from Oracle Data Mart.

Involved in the performance tuning of SQL queries. Analyzed the Application Code and provided alternate SQL & PL/SQL Performance Tuning strategies. Used Explain Plan, Tkprof and Optimizer Hints (INDEX, INDEX_FFS, HASH, USE_MERGE, ORDERED, PARALLEL etc.) to reduce query execution time from 15-20 hours to 30-45 minutes in some cases. Used Erwin for data modeling.

Wrote Shell scripts for Batch programs and Data loading. Debug UNIX and PERL scripts

Work with the Partitioned Tables and identify the need for converting the Global Indexes into Local indexes in Partitioned tables. Involved in designing the Star Schema for logical database.

Used Oracle Native Dynamic SQL, PL/SQL Tables, Ref Cursors, Object types, Export / Import, SQL*Loader and File Handling tools for loading data into tables and creating files.

Coordinated with off-shore and on-site personnel for timely delivery of Metric Reports.

Environment: Oracle 8.1.7 / 10g, PL/SQL, Informatica 7, MicroStratergy 7.3, TOAD 7.6,

Oracle SQL Developer, PERL, HP-Unix B.11.11 U

Covansys India Pvt. Ltd., India Dec 2000 – Dec 2003

Sr. Analyst, Team Lead

Client Duration Project : Hewitt Associates, USA Mar 2003 – Dec 2003 Peoplesoft -HRMS

Responsibilities:

Analysis, Design and Development of customized PeopleSoft components based on emerging requirements using People Tools and People Code

Review and Test the work products. Performance Tuning of the People Code queries

Interact with the clients for clarifications and provide project status report to management team.

Environment: PeopleSoft 8.x, PeopleSoft HRMS, People Code, People Tools 8.19, DB2 UDB 8.1,

Client Duration Project : Kaiser Permanente, USA Jul 2002 – Feb 2003

Budget Forecasting and Reporting System (BUFR)

Responsibilities:

Developed business logic in Java. Coded JSP, Servlets and JavaScript.

Wrote and tune SQL scripts. Test and Review the code.

Provide application support, fix the bugs and implement enhancement to the existing BUFR Module.

Environment: Oracle 8i, Java, JSP, Servlets, Java Script, HTML, MS Front Page 2000, Weblogic Server 6.1

Client Duration Project : Visteon Corporation, USA May 2002 – Jun 2002 Payroll Data Conversion

Responsibilities:

Understood conversion mappings and rules, and then wrote SQL scripts to manipulate data from different sources (MS Access, Flat Files) and Load data into SQL Server.

Checked accuracy of the data. Test the SQL Scripts and stored procedures for load and accuracy.

Environment: SQL Server 2000, Windows 2000

Client Duration Project : Priority Health, USA Dec 2000 – May 2002

Managed Care Systems Conversion

Responsibilities:

Responsible for leading a team of 14 members for the development of Oracle Reports / Forms and PL/SQL packages.

Convert abstract technical details into Technical Documentation and send to the Client for approvals.

Migrated MS Access applications into Oracle 8i to suit FACETS Data Model requirements. Studied the existing business logic and rewrote the applications in Oracle Forms 6i / Reports 6i.

Used ERwin for database design, prepare the Entity Relationship Diagrams, created Instances and Normalize tables.

Wrote complex SQL and PL/SQL stored procedures, functions, packages, triggers, used inbuilt DBMS packages, wrote Ref Cursors and Dynamic SQL to implement business logic to extract data from FACETS Data Model to Oracle Warehouse.

Performance Tuning of SQL and PL/SQL using EXPLAIN_PLAN, SQL Trace and using optimization techniques like Optimizer Hints, analyzing statistics on tables and appropriate creation and use of indexes.

Environment: Oracle 8i, PL/SQL, Developer/2000 (Forms 6i, Reports 6i & Graphs 6i), ERWin, FACETS,

TOAD, Windows 2000 / NT 4

Tata Infotech Ltd., India Jun 1998 – Dec 2000

Lead System Engineer

Client Duration Project : Oil Co-ordination Committee, India Sep 2000 – Dec 2000

Tanker Scheduling System

Responsibilities:

Prepared Entity-Relationship Diagrams and Data Flow Diagrams using Designer/2000.

Install Oracle and Design the database. Creation of Users, Roles and Privileges

Identify and create various database objects such as tables, views, indexes, database triggers and database procedures, functions and packages. Debug VC++ Code.

Performance Tuning and Optimization of the queries using TOAD and EXPLAIN PLAN.

Environment: Oracle 8.0.5, VC++ 6.0, PL/SQL, Visual Basic 6.0, Designer/2000, TOAD, Rational Rose, ILOG

Client Duration Project : Tata Special Steels Ltd, India Sep 1999 – Sep 2000 Auto Generation of

Credit Advices & Auto Conversion of Credit Advices into Sales Credit Notes

Responsibilities:

Creation of database objects such as tables, views, indices, synonyms, database triggers and procedures.

Development of data entry screens for auto generation of Credit Advices and auto conversion of Credit Advices into Sales Credit Notes and Reports for the same.

Wrote complex SQL, PL/SQL scripts using Native SQL, Dynamic and Embedded SQL. Used Cursors extensively. Also wrote the Pro*C code for data extraction, batch processing and printing.

Wrote Shell scripts for file handling and Pattern searching.

Implemented Accounting System at TSSL’s different plant location. Wrote SQL and PL/SQL scripts to create data transfer procedures for transferring data between geographically isolated locations based on the Distributed Database Concept.

Environment: Oracle 7.3, Pro*C 2.2.4, PL/SQL, SQL*Forms 3.0 & SQL*Reports 1.0,

Developer/2000 ( Forms 6.0 & Reports 6.0 ), SUN Solaris 5.6

Client Duration Project : DisBank, TURKEY Jun 1999 – Sep 1999 New Generation Banking System

Responsibilities:

Analysis of the existing system's features and its functioning

Development of front end screens and reports in Forms 5.0 and Reports 3.0 for NGBS.

Creation of Oracle SQL queries, PL/SQL database triggers, procedures, functions and DBMS packages.

Tune high cost SQL, PL/SQL using proper Indexing and Hints. USED TOAD and TKPROF

Environment: Oracle 7.3, PL/SQL, Developer/2000 (Forms 5.0 & Reports 3.0), TOAD

Client Duration Project : Tata InfoTech Ltd, India Jun 1998 – Jun 1999

Human Resources Allocation Group (HRAG) System Development

Responsibilities:

Develop GUI for all the data entry jobs and reports in Developer/2000.

Create database triggers, procedures, functions and packages in PL/SQL.

Providing application support for the system, fix bugs and troubleshoot application issues which was implemented at different Tata Infotech branches

Code and test all programs.

Environment: Oracle 7.3, PL/SQL, Developer/2000 (Forms 4.5 & Reports 2.5)



Contact this candidate