SUMMARY

• 8.4 years of IT experience in database development using Oracle PL/SQL and SQL* PLUS, SQL,ETL using SSIS, MS 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 with Database Design and modeling using SQL Workbench/Toad/SQL developer etc.
• Experience of Testing database scripts - manual and automated testing using sql developer/toad.
• 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.
• Experience of Reporting tools such as Excel,IBM Cognos and Crystal report.
• Beginner level knowledge of NOSQL databases such as Mongo DB, Cassandra and Amazon Redshift and PostgreSQL.
• Experience of working in waterfall and agile software development environments for development and production support projects.
• Passionate Toastmaster. Certified competent leader by Toastmaster International.

TECHNICAL SKILLS

Databases: ORACLE 10g/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,SQL Workbench,Putty, IBM Cognos.

Operating System: Windows XP/NT, Linux

PROFESSIONAL EXPERIENCE

PL/SQL Developer

Confidential, Ann Arbor, MI

Responsibilities:

• As an oracle PL/SQL developer, I was involved in migrating the existing Oracle packages and Stored Procedures to the Amazon Redshift database.
• Worked with application team to define process for new report formats using Tableau and Cognos.
• Developed new stored procedure and oracle packages and related 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.

Oracle PL/SQL Developer/Team Lead

Confidential, Jacksonville, FL

Responsibilities:

• As an oracle team lead and PL/SQL expert, I was involved in migrating the existing data from MY SQL 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 Logical/physical design for Signals database and did documentation of the design process.
• 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, My SQL,UNIX Shell Scripting, IBM Maximo, Eclipse Juno, Toad, Clear Case.

Oracle PL/SQL Developer

Confidential

Responsibilities:

• 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.

Oracle PL/SQL Developer

Confidential

Responsibilities:

• 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.

SQL Developer

Confidential

Responsibilities:

• 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.

MS ACCESS Developer

Confidential

Responsibilities:

• 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,SQL, MS Excel 2003.

MS ACCESS Developer

Confidential

Responsibilities:

• 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, SQL,MS Excel 2003.