Professional Summary:

• A technology driven professional with over 12 years of IT industry with analyst to lead across various domains Manufacturing, Hospitality and Banking .
• Over 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System RDBMS .
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL PLUS, TOAD and SQL LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Strong experience in Data warehouse concepts, ETL.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index B Tree, Bitmap and Function Based .
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization CBO .
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience in ETL techniques and Analysis and Reporting including hands on experience with the ETL tools such as Informatica.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Technical Skills:-

• Database:- Oracle 8i, 9i, 10g, 11g, SQL Server 2000/2005, Adaptive Server Anywhere, Sybase 12.5
• ETL Tools:- Informatica 8.x/9.x, Oracle SQL Loader.
• Reporting Tools:- Cognos 8.0, Infomaker
• Operating Systems:- Unix Sun Solaris, HP Unix, Red Hat Linux , Windows NT/98/2000/7
• Data Modeling: Erwin 3.5.2, Power Designer
• Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Java, XML, Powerbuilder 6.5-12.5
• Other Tools: AutoSys, CA Unicenter

Confidential

Tools: Informatica 9.x, Oracle, SQL Server, TOAD, UNIX Scripting and Autosys r11.3

Descriptions:

Confidential provides a tool for Confidential users and suppliers to forecast the quantity of manufacturing components produced by GM approved global suppliers used in GM plants globally. Global architectures and global sourcing are resulting in situations where a single supplier location will supply the same component to GM plants in multiple regions.

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed functions and stored procedures using oracle analytical functions to aid complex SQL's.
• Created Packages, Stored Procedures, Functions and Materialized view used for moving the data from staging area into data mart for COGNOS reporting.
• Automation done to call PL/SQL scripts using DBMS Scheduler / Job used to call PL/SQL.
• Bulk collect method used to boost data load performance.
• Created scripts to create new tables, views, queries for new enhancement in the application using Erwin 3.5.2.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Partitioned the fact tables and materialized views to enhance the performance.
• Created records, tables, collections nested tables and arrays for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and logged the error messages in the Error Handling Table.
• Written UNIX shell scripts used corn tab to schedule the workflows.

Confidential

Tools: Oracle SOA 11g, Jdev 11.1.1.6, Oracle 11g, PLSQL, Webservers and SUN Solaris

Description:

Confidential is an Vehicle Order Status tracking system, which interfaced beginning with Plant Management system POMS to Global Warranty Management GWM system via online/offline updates to Provide the exact current status of an vehicle. Single system which works for different Confidential.

Responsibility:

Support Delivery Module Lead

• Handling incidents raised by user and providing work-around/resolution.
• Developed lot of functions to leverage the application Time zone and Language independent.
• Single database for all the region.
• Developed Packages and Procedures to extract the daily feeds to downstream system and Processing feeds from other interfaces.
• Daily team meeting on open issues and hand-over of issues among team.
• High priority interface error recovery to keep SOM sync with inbound/outbound systems.
• Maintaining knowledge base repository for recurring incidents.
• Confidential system and comprises three main functions Vehicle Image Maintenance, Order Entry Validation, Vehicle Build Specification.

Responsibilities:

• Entire Business Logics were encapsulated in Packages and Procedures.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created Packages and Procedures for online validation of the vehicle images ordered through client and Web Applications.
• Created scripts to import the data send by other interfaces like VIM, Forecast, POMs, VDS etc. using SQL Loader and process through Stored Procedures.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created Triggers to record Changes performed for Dimension tables for auditing.
• Batch processing is controlled by CA UniCenter which schedules and runs the PL/SQL programs.
• Created Oracle Sequence for Identifier Key Columns.
• Created Public Synonyms and provided DML rights based on user group.
• Created Procedure to compile to all the modified database objects after implementation in production.
• Created Procedure to export the data for particular transactions and it's depended records from all the respective tables and it generates an Oracle Merge Statement for each records in a file using UTL FILE packages.
• Interfacing, other than with the client application, is either batch file transfer using XCOM, or transactional using SeeBeyond.
• Confidential view and report on actual data and create simulated forecasts for a variety of criteria such as vehicle image, vehicle options, sales period, colors, trim, etc.

Responsibilities:

• 60 of Business Logics were encapsulated in Packages and Procedures.
• Created Triggers to record Changes performed for Dimension tables for auditing.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created Packages and Procedures for online validation of the vehicle images ordered through client and Web Applications.
• Created scripts to import the data send by other interfaces like VIM, Forecast, POMs, VDS etc. using SQL Loader and process through Stored Procedures.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Batch processing is controlled by CA UniCenter which schedules and runs the PL/SQL programs.
• Created Oracle Sequence for Identifier Key Columns.
• Created Public Synonyms and provided DML rights based on user group.
• Created Procedure to compile to all the modified database objects after implementation in production.
• Created Procedure to export the data for particular transactions and it's depended records from all the respective tables and it generates an Oracle Merge Statement for each records in a file using UTL FILE packages.
• Interfacing, other than with the client application, is either batch file transfer using XCOM, or transactional using SeeBeyond.

Tech Lead

Description:

Confidential is a property management system for all types of hotels from large 1,000 rooms to 30 room properties providing a state-of-art property management system utilizing Windows NT, Windows XP, Windows 98 and 2000 clients touch screen technology and sophisticated graphics.

Responsibilities:

• The project involved preparing a vision scope docs for allotted tasks, making technical specifications Test plans.
• Coding as per Tech specifications Peer Reviewing of Technical specification and Test plans and Code.
• Encapsulated the business rules in Procedures.
• Created triggers to logs history of Dimension tables.
• Synchronizing the data with central hub.

Confidential

Software Engineer

Description:

Confidential which is a product for Treasury Branches. The package mainly deals with Inter Bank Forex Deals like Outright, Swap Deals, Merchant Forward Deals, Lending and Borrowings. System architecture is like that the Deals, which are punched by the CTOs, or by dealers in front office are pulled out in Back office and authorized by the managers/officers. NRI deposits and withdrawals and loans are carried in the FCNR module. Reconciling the Nostro Statements sent by the foreign banks with the mirror generated for the corresponding manifolds sent by the Branches.

Responsibilities:

• Developed Swap Deals and NRI deposits module.
• It involves constructing programs based on Program Specifications, as per applicable language Standards designing, implementing test fixing for bug reports changing for Change Requests to programs.
• Confidential Market is a market for short-term funds, generally up to one year. Securities, Approved Securities, Central Government Security, State Government Security, Trustee Securities, Treasury Bills, PSU Bonds are the instruments maintained in money market. Purchasing or selling the instruments issued by Financial Organisation is the main process of the Money Market. Revaluation of the Instruments is processed on each half-year end.

Responsibilities:

• Production support in client place Central Bank of India and Union Bank of India.
• It also involved constructing programs based on Program Specifications, as per applicable language Standards. Designing, implementing test fixing for bug reports changing for Change Requests to programs. Documenting all program changes handling relevant technical communication with client.

Confidential

Software Engineer

• fied Associate PL/SQL Developer.