SUMMARY

• 12+ years of IT experience in Analysis, Design, Development, Testing and Production Support in Oracle, SQL, PL/SQL and Client Server applications.
• Experienced in developing Oracle 11g/10g/9i/8i SQL,PL/SQL’s
• Experienced in developing SAS BI Reports using SAS EG Tool.
• Expertise in developing Stored Procedures, Functions, Packages, Triggers, Indexes and Views.
• Expertise in tuning SQL queries using Hints, application tuning using Explain Plan, creating indexes, Collections etc.
• Expertise in Oracle utilities including export/import, SQL Loader, SQL*PLUS.
• Expertise in Migration from one technology to another technology ( COBOL, SYBASE and SQL Server to Oracle
• Expertise implementing securities using Roles, Privileges and Grants.
• Strong in data base management concepts and UNIX skills.
• Excellent interpersonal skills, analytical, communication skills and leadership responsibilities.

TECHNICAL SKILLS

Programming Languages: C, C++, UML, Java, Pro *C, VB

Oracle Database: Oracle 9i/10g/11g/12C, SQL, PL/SQL

Servers: ApacheTomcat4.2, Weblogic8.1, Oracle 10gAS,Oracle 11gR2

Design & Other Tools: Rational Rose, Rational Xde, Visio, Data stage7.5

Scripts: Perl, Shell, VBScript, JavaScript

Operating Systems: Linux, Windows 98/2000/NT/XP, UNIX, Solaris

Web and J2EE: EJB, JSP, Servlets, HTML, DHTML, JDBC, JMS

Main Frame: Data Base DB2, COBOL.

GUI and Tools: Oracle10g Developer suite, Oracle9i IDS Developer suite, Forms 5.0/10g, Reports 5.0/10g, Designer 6i/9i, Informatica / Data Stage

Version Control: GIT, SVN,CVS,PVCS

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Sr Oracle PL/SQL Developer

Responsibilities:

• Responsible for On boarding the dealers.
• Responsible for validating the data in Elastic Search vs Postgres vs 20/20 tool.
• Responsible writing SQL queries and loading the data into PostGres Database.
• Creating and Scheduling the job in Chronos.
• Responsible for resolving the JIRA tickets for the Customer and Invoice domains.
• Creating the custom and override functions for Dealers.
• Responsible for Validating the data in Kibana - Sense.

Environment: PostGreSQL, SQL, Unix, ElasticSearch, Chronos, AirFlow, XML,Mesos, Python, Kibana-Sense, AWS, Docker.

Confidential, Chicago, IL

SAS EG Developer / Sr Oracle PL/SQL Developer

Responsibilities:

• Responsible for resolving the CBOE/C2/CFE Production issues on CDB/DWS.
• Responsible for setting up C2 DR / CFE DR site for C2 Main and CFE Main.
• Responsible for creating oracle SQL Query’s and PL/SQL stored procedures and Functions.
• Responsible for developing the SAS BI Reports using SAS EG Tool.
• Responsible for developing stored process for SAS Reports.
• Responsible for preparing the technical documentation for the user requirement.
• Responsible for providing solution design document for the requirement.
• Responsible for creating shell scripts to automate deployment process.
• Responsible for creating indexes to improve the performance of the SQL queries.
• Responsible for performance tuning of procedures and functions.
• Responsible for modifying the existing Oracle Tables and Procedures as for the business requirements.
• Responsible for 24x7 on call support, troubleshooting the C1/C2/C3 Production issues.
• Monitoring and optimizing the database performance and SQL performance, provided day-to-day production support for CDB/DWS applications.
• Responsible for setting up control-m jobs, folder structure and users creation for DR Sites.

Environment: Oracle RAC, TOAD, SQL*PLUS, Unix, Shell scripting, Perl,Pro *C, Java, Angular, Control-M, SAS EG, GIT, Stash, Bamboo, Clear case.

Confidential, Chicago, IL

Sr Oracle PL/SQL Developer

Responsibilities:

• Responsible for validating the user’s data by creating data quality rules.
• Responsible for modifying the existing Oracle Tables and Procedures as for the business requirements.
• Responsible for writing Oracle Packages for all acquisition cycles and Data package and data package groups.
• Responsible for preparing the technical documentation for the requirement.
• Responsible for providing solution design document for the requirement.
• Responsible for creating Perl scripts to automate deployment process.
• Creating the indexes to improve the performance of the SQL queries.
• Responsible for performance tuning of procedures and functions.
• Involved in coding, compiling, debugging, testing and full life-cycle unit testing.
• Responsible for data model and design of the databases.

Environment: Oracle 11g, TOAD, SQL*PLUS, Perl scripting, Share Point, Power Designer, .Net.

Confidential

Responsibilities:

• Responsible for creating the Control-M jobs from SBIP to DVSZ environment.
• Responsible for changing external tables into Sql loader control files scripts
• Responsible for creating the Shell scripts to schedule the jobs.
• Clone databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
• Responsible for Security Management by allocating proper privileges.
• Creating the indexes to improve the performance of the SQL queries.
• Responsible for performance tuning of procedures and functions.
• Responsible for loading Bloomberg / Factset’s data into PBR data base.
• Responsible for loading Instruments, Holdings and Portfolio’s data into database.
• Responsible for preparing the technical documentation for the requirements.
• Responsible for preparing the Smart Sync tool to automate the migration process.
• Involved in coding, compiling, debugging, testing and full life-cycle unit testing.
• Responsible for modifying the existing Oracle Tables and Procedures as for the business requirements.

Environment: Oracle 11gR2, TOAD, SQL*PLUS, EM Tool, SQL Loader, Export & Import Data, WinSCP, Tectia, Unix, Shell scripting, SVN, Enterprise Architect

Confidential

Responsibilities:

• Responsible for extracting all hospitals data, send to central database using
• Pl/sql Stored procedures and Shell scripting.
• Created the indexes to improve the performance of the SQL queries.
• Responsible for improving performance of the Reports that are running long time.
• Responsible for extracting central database data and Sync all Hospitals using Shell scripting and PL/Sql Stored procedures
• Responsible for performance tuning of procedures and functions.
• Involved in coding, compiling, debugging, testing and full life-cycle unit testing.
• Responsible for modifying the existing Oracle Tables and Procedures as for the business requirements.

Environment: Oracle 11g, SQL, PL/SQL, Linux, Windows XP, Redmine, .Net, Putty.

Confidential

Responsibilities:

• Gathering the requirement from Users, Plan & implement into production servers
• Responsible for performance tuning of PL/SQL procedures and functions.
• Responsible for TWS setup for Phase 1.1 & Phase 1.2 interfaces.
• Responsible for creating the new Shell scripts as for the requirement.
• Responsible for assigning the tasks to team members.
• Have good exposure on working with OLTP / OLTA.
• Identification of various Data Sources like Relational databases, Application systems and Flat files to extract, transform and load data from these sources into Data warehouse.
• Responsible for reviewing / writing new wrapper Shell scripts for Phase 1.2
• Responsible for reviewing / raising CR’s to push the updated scripts into production
• Responsible for investigating the production issues / tickets.
• Responsible to assigning the production tickets to team members and work together to solve the issues.

Environment: Oracle 11g, SQL, PL/SQL, AIX 5.3, Windows XP, Clear Case, Tomcat Server, BPS server, Rendition server, AlgoSecutiry server, Documentun server, TWS / Tivoli, Manage now,Data Stage.

Confidential, Grand Rapids, MI

Responsibilities:

• Designed Database Structure, developed PL/SQL procedures, Bulk collections SQL scripts functions & Triggers.
• Monitored and optimized the database performance and SQL performance.
• Involved in Migration of Oracle data base 10g to 11g.
• Created the indexes to improve the performance of the SQL queries.
• Was responsible for answering problem tickets created by business users and resolving application issues.
• Involved in coding, compiling, debugging, testing and full life-cycle unit testing.
• Developed Core Java programs and JDBC connection.
• Was responsible for modifying the existing Oracle Tables and Procedures as for the business requirements.
• Was responsible for modifying the VB code (WinFax) to MS Fax service for sending/receiving the quotes to the customers.
• Created the Quotes List and sent faxes to customers.

Environment: Oracle 10g/11g, SQL, PL/SQL, Toad, UNIX, Windows XP, FTP, VB, MS SQL Server, C++, Crystal Reports, Java Springs, Net Beans, CVS, MS Access, IBM Web sphere 5.2

Confidential, Chicago, IL

Responsibilities:

• Identify Sybase proc's and implement them in PL/SQL procedures.
• Responsible for Coding, Debugging, Testing and Full cycle Unit testing in Sybase and PL/SQL.
• Created Ref cursors for passing data to Business objects.
• Monitored and optimized the database performance and SQL performance.
• Created Global temporary tables for temporary data load processes.
• Responsible for creating the functional specs for all Sybase proc's.
• Created new tables, indexes, views, SQL scripts, Bulk collections SQL scripts and triggers.
• Responsible for data loading from the Sybase to Oracle tables and involved in data analysis, design and implementation.
• Prepared test cases for all batch programs.
• Created the indexes to improve the performance of the SQL queries.
• Involved in unit testing and resolved the errors that occurred.
• Created the new packages, procedures, functions across the client requirements.
• Designed database structure and developed PL/SQL procedures & functions.

Environment: Oracle 10g, SQL, PL/SQL, Sybase, Rapid SQL 7.2, HP UNIX, Windows XP, JAVA, C/C++, TOAD, PVCS, Pro * C, IBM Web sphere, Business Objects, Novel.

Confidential, Pittsburgh, PA

Responsibilities:

• Responsible for creating the Functional specs for all interfaces.
• Identified all COBOL interfaces and implemented them in PL/SQL procedures.
• Assisted DBA in granting privileges, created new tables, indexes, views, triggers, procedures and functions. Restored the lost data in the tables.
• Created Algorithms for all hospital interfaces & Medical interfaces.
• Responsible for preparing the flow charts for all interfaces.
• Prepared test cases for all batch programs.
• Designed database structure and developed PL/SQL procedures & functions.
• Monitored and optimized the database performance and SQL performance.
• Involved in coding, compiling, debugging, testing and full life-cycle unit testing.
• Involved in unit testing and fixed the errors that occurred
• Created new packages, procedures, functions across the client requirements.

Environment: Oracle 10g, SQL, PL/SQL, COBOL, Toad, HP UNIX, Windows XP, ASP.Net, MS Visio.

Confidential, Detroit, MI

Responsibilities:

• Monitored and optimized the database performance and SQL performance, provided day-to-day production support to all applications.
• Developed Triggers and PL/SQL stored procedures.
• Restructured SQL to improve query response times by up to 25% and performance tuning of procedure, functions.
• Identification of various Data Sources like Relational databases, Application systems and Flat files to extract, transform and load data from these sources into Data warehouse.
• Extensively used Data Stage Designer to design & develop various Server jobs for ETL using stages like ODBC, Sequential File, Hashed file, Aggregator, Transformer, Merge, and Sort etc.
• Created/Modified the shell scripts for data load application as for upstream application.
• Created and managed database tables and control files for data loading.

Environment: Oracle 9i, SQL, PL/SQL, SQL * loader, Toad, HP UNIX, Windows XP,FTP, Erwin, Cognos, Ascential data stage 7.5.1,autosys