SUMMARY

• Over eight years of IT experience in database development using Oracle PL/SQL and SQL,ETL using SSIS, SQL server, MS ACCESS 2003, VB and Unix shell scripting.
• Expert in Oracle PL/SQL Packages, Stored Procedures, Functions and Triggers, Collections, Bulk Collect, Cursor and Dynamic SQL, Hints etc.
• Experience in ETL between homogeneous and heterogeneous systems using MS SQL tools DTS, SSIS and Oracle SQL loader etc.
• Experience of Oracle query performance tuning and query optimization techniques.
• Beginner level knowledge of NOSQL databases such as Mongo DB, Cassandra and Amazon Redshift and PostgreSQL.
• Experience working in Waterfall and agile software development environments.
• Passionate Toastmaster. Certified as a competent leader by Toastmaster International.
• Hands on experience of JDA Intactix suite of applications including and IKB, space planning in the SCM domain.
• Hands on knowledge of IBM Maximo enterprise asset management EAM , Maximo integration framework and object structure for data migration related tasks.

SKILLS

Databases ORACLE 11g, MS-SQL SERVER, MS ACCESS, Amazon Redshift

Development Technologies PL/SQL, SQL, T-SQL, UNIX Shell Script, VB

Tools Toad, Oracle SQL developer, SQL server management studio SSMS ,

SSIS, SVN, Eclipse

Operating System Windows XP/NT, Linux

EXPERIENCE

Confidential

SQL Developer

• As an oracle PL/SQL developer, I was involved in migrating the existing Oracle packages and Stored Procedures to the Amazon Redshift database.
• Developed the UNIX shell scripts jobs responsible for loading the data to the data warehouse tables.
• Fine-tuned a couple of old packages to improve performance and added better error handling capabilities to the existing packages. Did performance tuning for 5 existing packages.
• Created required documentation for the changes done to the various packages and shell scripts.
• Did unit testing and integration testing to ensure quality of final production code.

Environment: Oracle 11g, Toad 11.5, Aginity Workbench, Win SCP, Putty, Unix Shell Scripting.

Confidential

Oracle PL/SQL Developer/Team Lead

• As an oracle team lead and PL/SQL expert, I was involved in migrating the existing data from MYSQL to Oracle in a format which is required by IBM Maximo framework.
• Lead a team of three junior developers and one tester. I assigned the tasks, tracked the progress and mentored the new joiners at offshore.
• Created new Oracle packages to automate the incremental load and updated the live business data from the legacy system to the Oracle tables. Did performance reviews of existing queries.
• Created BOK and trained manuals for the junior team mates.
• Created unix shell script to load data to tables.
• Completed the peer reviews of the PL/SQL codes for other EAM teams.

Environment: Oracle 11g, UNIX Shell Scripting, IBM Maximo, Eclipse Juno, Toad, Clear Case.

Confidential

Oracle PL/SQL Developer

• As a lead oracle developer and administrator, I lead a team of PL/SQL developers in analysis, design and coding in the store reset cost management database, in PL/SQL and maintained it in production environment.
• Created at least ten new packages to handle various functionalities related to the store cost calculations as per the business rules.
• Developed and documented the required test scripts for testing the accuracy of final cost as calculated by the tools.
• Created required shell scripts jobs in UNIX and did end to end testing for new packages and verified the output against test cases.

Environment: Oracle 11g, Toad 11.5, SVN, UNIX shell scripting, Putty.

Confidential

Oracle PL/SQL Developer

• Developed Stored Procedures and Functions, Ref cursors that interacted with the VB modules to display required information from the database.
• Created automated jobs in SSIS to do the data load. Earlier data was loaded using SQL queries.
• Developed two new SSIS packages for ETL of data to CRP system.
• Handled code versioning and code reviews using SVN.
• Did performance tuning of the existing queries to improve their throughput and response time.

Environment: Oracle 11g,SQL Server 2005, SSIS, SQL Server Management Studio, Visual studio.

Confidential

SQL Developer

• I was responsible for designing the front end of application using VB 6.0 based on the requirement of the various teams.
• Designed the back end database tables using MS ACCESS and wrote set of SQL queries to load data from the Oracle database to MS ACCESS.
• Wrote the complete application logic in VBA. Completed the Unit testing and then the deployment of the application.

Environment: SQL, MS ACCESS 2003, VBA, Oracle 9i.

Confidential

MS ACCESS Developer

• I was involved in the data entry of old internet usage records to excel sheets so that same can be imported to the database.
• Created tables in MS ACCESS and imported data into these tables from various excel sheets.
• Create user forms and report design to be able to fetch the usage records.

Environment: MS ACCESS 2003, MS Excel 2003.

Confidential

MS ACCESS Developer

• I was involved in data cleaning of these records. First the records need to be manually entered in Excel and then updated and made in format as required by database.
• Created excel based functions/macro to clean up the records.
• Designed the forms In MS ACCESS and added various report template to access the records.
• Integrate MS ACCESS with MS Excel so as to allow the users to enter new records and view them in MS ACCESS where can update/delete the records.

Environment: MS ACCESS 2003, MS Excel 2003.