EXPERIENCE summary

• Over 10 years of vast IT experience in Analysis, Development, Production Support and Implementation of applications using Oracle, UNIX, PL/SQL, Oracle Forms/Reports.
• Worked on Production/Application support, development, enhancements and data analysis Projects.
• Good experience in troubleshooting, bug fixing, change request and maintenance of the projects and very strong in data analysis and Data Warehousing concepts.
• Good programming knowledge in Oracle 11g/10g/9i/8i/8.x, PL/SQL, SQL Plus, TOAD, SQL Loader.
• Proficient in developing Packages, Procedures, Functions, Triggers and developing programs using SQL, PL/SQL
• Expertise in the application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL PLUS, TOAD and SQL LOADER.
• Good in resolving production application tickets and familiar with Remedy system.
• Experience in Customizing Oracle and custom ERP applications.
• Good working knowledge in UNIX and UNIX shell scripting.
• Extensive working knowledge in tools like TOAD, Oracle SQL Loader, SQL Plus.
• Used XML Types in Oracle to store and extract the data from the front end application.
• Strong experience in Data warehouse concepts, ETL.
• Good in Client Interaction, Communication, Requirements Gathering and Analysis.
• Highly experienced in onsite off-shore model.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Good on Proper and Well-written Documentation of the programs and New Applications developed and / or Customized / Modified.
• Created Shell Scripts for invoking SQL scripts and scheduled them.
• Good team player with excellent Interpersonal Skills and Self-starter, capable of Working Independently.
• Worked on migration projects like migrating from Oracle to SQL Server.
• Good in setting project goals and achieving it, Highly Result-Oriented.
• Experience in the preparation of Technical Design documents and System Test scripts for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces, Reports.

Technical skills

• Languages : PL/SQL, T-SQL, UNIX Shell Scripting, Perl Scripts
• Databases : Oracle 9i/10g R2/11g, MS SQL Server 2000/2005/2008.
• Tools : SQL Plus, Toad, SQL Loader, SQL Developer, Oracle Developer, MS Visio, Text Pad, Excel, Erwin, SSIS, Control-M, EAI Integration, PUTTY
• Version Control : PVCS, Open Source CVS, TFS, VSS
• Web Technologies : HTML, JavaScript
• Web Servers : Tomcat, IIS, SharePoint, Apache
• Operating Systems : UNIX, Solaris, Windows 95/2000/NT/XP

PROJECTS PROFILE

Confidential

Role : Technical Lead

Skills : Oracle Database 10g, Manufacturing

Environment : Windows and UNIX

Description :

The Global Primo West program focuses on system consolidation between Sony Electronics US and SONY Europe SAP and related systems The objective of Global Primo West GPW program is to enable accurate, reliable, timely, and cost effective financial and accounting services through the transformation of Finance and Accounting Business Processes.

Vision:

• Common Process Methodology
• Simplified, System Environment with standardized tools
• Aligned financial reporting

Responsibilities:

• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Participated in Designing databases schemas to ensure that the relationship between data is guided by tightly bound Key constraints.
• Designed Physical and Logical Data model and Data flow diagrams.
• Worked on various tables to create Indexes to improve query performance Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
• Worked with offshore team in coordinating for production support.
• Involved in writing several complex Queries and Procedures using joins, sub queries and correlated sub queries.
• Optimized the performance of queries by Data Manipulation which includes modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins wherever necessary.
• Used bitmap Indexes, materialized views and partition tables to optimize the queries.
• Developed Data Mappings using various Transformations and PL/SQL Packages to extract, transform and load the data.
• Loaded the data into database tables using SQL loader from text and excel files.
• Worked in Application tuning for slow running queries using Explain plan Auto trace .
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Used advanced Bulk techniques FOR ALL, BULK COLLECT to improve performance.
• Developed Data entry, Query and Reports, request screens and tuned the SQL queries.
• Used Joins and Indexes effectively in WHERE clauses for Query optimization.
• Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

Environment: Toad, SQL Developer, SQL Plus, SQL Loader, Oracle 10g, 11g, Erwin, Windows XP, UNIX

Confidential

Role : Technical Lead

Skills : Oracle Database 10g, Manufacturing

Environment : Windows and UNIX

Description :

Budget 2 was a budgeting tool that required having all the existing functionalities of Budget One tool along with new features and functionalities It will deal with Sell In budget, Sell in Indirect and Sell out Budgets This application was developed using WPF and Spreadsheet Gear in the front end and back end was Oracle database.

Responsibilities:

• Wrote PL/SQL Stored Procedures, Functions, Triggers and Packages with extensive use of cursors, complex joins, date functions and string handling functions to implement business rules into the application and do the validations as per requirements.
• Developed Shell Scripts and Cron Jobs to maintain scripts for monitoring, troubleshooting.
• Developed SQL Loader scripts, conversion scripts for the conversion of the data to the custom new schema.
• Optimized Query by Data Manipulations, removed unnecessary columns, normalized tables, eliminated redundant and inconsistent data, established Joins and created clustered/non-clustered indexes wherever necessary.
• Troubleshooting production problems and worked effectively with other team members to identify and address problems.
• Involved in SQL tuning and optimization of SQL performance by generating trace files DBMS trace , using TKProf and Explain Plan utilities.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Used FTP, SCP and WinSCP to transfer the files between different servers.
• Created DDL for various modules of data model for testing and implementation.
• Performed File transfers using FTP.

Environment: Oracle 10g, UNIX, Windows, SQL Plus, Version Control, TOAD, SQL Developer

Confidential

Role : Senior Software Engineer

Skills : Oracle Database 10g, Manufacturing

Environment : Windows and UNIX

Description :

eCLIPS was the planning tool for Marketing Business users which consolidated the demand data from all the Sony regional sales offices This system was a communication tool between factory inventory management group and marketing for demand, supply, and allocation.

Responsibilities

• Worked with team to design, develop, test and implement system.
• Created database objects like Tables, Views and Triggers Created Procedures, Packages using Oracle tools like SQL Loader, SQL Plus and PL/SQL.
• Created PL/SQL Triggers to monitor the database activities and to implement some database constraints.
• Involved in Data Loading and Data Migration Used SQL Loader to load data from flat/Excel file into the temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions/enhancements on oracle Application.
• Involved in problem analysis, resolution, troubleshooting and Performance Tuning.
• Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when application runs For best results, used these tools with Explain PLAN.
• Used Joins, Indexes, effective Where clauses for Query optimization.
• Used Export and Import to transport data from production to testing and to other databases.
• Participated in development, testing and migration of oracle objects from development to testing and production environments.

Environment: Oracle 9i/8i, PL/SQL, SQL Loader, UNIX, TKPROF, SQL TRACE, EXPLAIN PLAN.

Confidential

Role : Senior Software Engineer

Skills : Oracle Database 10g, Manufacturing

Environment : Windows and UNIX

Description :

Sony Electronics Limited, USA is involved in Sales and Marketing of consumer electronic products across the United States It has many divisions/business groups, one of the groups VOAPA handles operational and sales planning of all Sony desktop and notebooks across Latin America, North America and Brazil As the existing application is not calibrated to plan the demand and sales in detail for VOAPA group, new architecture was proposed to fulfill their requirements for better demand and sales planning at various levels.

Contribution

• Gathered the requirements from the onsite coordinators
• Involved in designing relationship between the tables
• Developed stored procedures, functions and triggers
• Developed interfaces to load the data from the flat files that were sent from the external systems ETL process
• Wrote shell scripts which were used to invoke the Oracle packages to load the data
• Scheduled the shell scripts as jobs in UNIX environment
• Provided daily updates to onsite team on self-owned tasks
• Wrote unit test cases and executed them

Other Information

The objective here was to build a new architecture with the following high level components in order to provide the single solution for Demand planning Application component to provide the necessary input data to the main window forms Interpreter Sync framework between client and main database The development of middle tier component to process published data Process the data feed from external systems SOLA, SOCAN and SEVEN as per requirements specified in RS Enhance STORMS to accommodate model set up changes for warehouse and series.

Confidential

Role : Senior Software Engineer

Skills : MSSQL Server 2005, Manufacturing

Environment : Windows

Description :

Confidential is involved in Sales and Marketing of consumer electronic products across the Confidential They engineer, manufacture, sell and market consumer and professional audio and video equipment, computer and peripheral Products, recording media and energy Products, semiconductors, and other electronic components Increased Productivity, Quick turnaround time, Reduction in the overall cycle time from Request submission for creation of material to creation of material in SAP by 80 when compared to the current system.

Contribution:

• Developed stored procedures, functions and triggers.
• Migrated the database from Oracle 10g to SQL Server 2005.
• Used the SSMA tool to migrate the database from Oracle to SQL Server.
• Worked on SSIS packages and created new packages for the ETL processes.
• Scheduled the jobs in the SQL Server Agent so that the jobs will run at regular intervals of time Timely deliveries of the tasks assigned to me.
• Writing unit test cases and executing the test cases.

Environment: Oracle MSSQL Server 2005, T-SQL, SSIS, Oracle 10g, UNIX, MSSQL Server Agent, WINDOWS

Confidential

Role : Senior Software Engineer

Skills : Oracle Database 10g, Manufacturing

Environment : Windows and UNIX

Description :

Sony Electronics Limited, USA is involved in Sales and Marketing of consumer electronic products across the United States It has many divisions/business groups who are involved in this process and cater to different product categories Each of these divisions needs to Forecast and Plan the requirement of these products to meet their Customers allowed at both Stream Weekly and Stream Monthly levels Requirement was provide Excel Based Tool MPI 2.0 Procurement Planning system Data in the tool as made available from SAP/BW/CDW and user would be able to publish the saved data in procurement tool to SAP

Contribution:

• Gathered the requirements from the onsite coordinators
• Involved in designing relationship between the tables
• Developed stored procedures, functions and triggers
• Developed interfaces to load the data from the flat files that were sent from the external systems ETL process
• Wrote shell scripts which were used to invoke the Oracle packages to load the data
• Scheduled the shell scripts as jobs in UNIX environment

Confidential

Role : Project Engineer

Skills : Oracle Database 10g, Manufacturing

Environment : Windows and UNIX

Description :

Sony Electronics Limited, USA is involved in Sales and Marketing of consumer electronic products across the United States It has many divisions/business groups who are involved in this process and cater to different product categories In order to do so, they had a system tool that would provide visibility to different planning metrics Orders, Sales, Inventory, PSI, OSI, Commitment, Forecasts, etc and enable them to simulate their plans before submitting their final requirement to their providers factories on regular basis Requirement was to provide data consistency form the source system SAP..

Contribution:

• Gathered the requirements from the onsite coordinators
• Involved in designing relationship between the tables
• Developed stored procedures, functions and triggers
• Developed interfaces to load the data from the flat files that were sent from the external systems ETL process
• Wrote shell scripts which were used to invoke the Oracle packages to load the data
• Scheduled the shell scripts as jobs in UNIX environment

Confidential

Role : Technical Associate

Skills : Oracle 8i, TELECOM

Environment : Windows and UNIX

Description :

FlowStream is a mid-tier system that is used for provisioning of telecom products e.g Broadband, PSTN, VoIP, LLU etc for BT It takes inputs orders from a front end and co-ordinates and communicates with various back ends, each of which does its own bit of activity in the provisioning cycle The application allows the automation of all the process starting from them Order Placement to the completion of the order.

Contribution:

• Worked on Java Script to develop the front end web pages using Oracle Application server by using HTP tags
• Developed stored procedures, functions and triggers
• Worked to store the TLV Tag, Length, Value Messages that we get the Messaging Queues from different systems in the Oracle Database.
• Written packages to store, extract and update these fixed format messages into the database tables in Oracle by using PL/SQL
• Scheduled the shell scripts as jobs in UNIX environment

Confidential

Role : Programmer

Skills : Oracle 8i, Manufacturing

Environment : Windows-XP

Description :

Kedia Vanaspati is one of the largest oil manufacturing industries in Andhra Pradesh The entire procedures are divided into Sales, Purchases, Finance, Inventory and Payroll module The main activities involved are selling of oil through a middle agent called the broker and purchasing of raw material and other than raw material After the items are purchased details are sent to the H.O located at Hyderabad and these details are record in the Goods Receipt Note GRN All the items are debited to the stock account and goods value is credited to supplier account The reverse happens when a sale is done Various reports are generated for Pre Post Sales, Purchases and Accounts.

Contribution:

• Preparing and Maintaining Forms
• Creating tables and writing SQL queries.
• Developing Reports.

Confidential

Role : Programmer

Skills : Oracle 8i, Retail

Technical Associate : Windows-XP

Description :

Dig Shoppe is world's leading e-catalog company in various business fields, such as pharmaceutical products, Restaurant, Food Catering Services, Home Shopping many more The project explores purchasing all the Materials, Equipments, and consumables for Business Exporting and Training internationally all the products of group produce Developing New Products Business related to the business field of group and Information Activities such as Market Survey, Introducing new business trends or solutions etc.

Contribution:

Preparing and Maintaining Forms, Creating tables and writing SQL queries, and developing reports