SUMMARY

• Having 15 Years of Oracle Development, design and testing of business applications in Client/Server and multi - tiered applications.
• Design and implementation of Physical and logical Data warehouses and Data marts.
• Wrote PL/SQL packages, procedures and functions.
• Experience in optimization of SQL statements using SQL Trace, TKPROF and Explain Plan.
• Experience in performance Tuning using various types of Hints, Partitioning and Indexes.
• Wrote KORN shell Scripting, Perl & Batch Processing.
• Exposure to Samson Ensemble Billing system, wire-line, wireless and telecommunications.
• Experience in writing ETL scripts.
• Expertise in E-R Modeling. Fluent in E-R Modeling - Notation, Multi-Dimensional Data Modeling techniques like Star Schema Modeling, Cube-processing, Snow-flake & Dimension modeling.
• Excellent experience in creating Test Cases, Test Plans, Technical Design Documents and Functional Design Documents.
• Good knowledge of the RDBMS concepts advanced Oracle queuing and Oracle Workflow.
• DBA duties include but not limited to: SQL Loader, Export/Import, Performance Tuning, optimization, subject-matter-expert, point of contact for all data items, version control, managing cold and hot backups, deploying the code from development to QA to Production.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Proficient in Oracle tools and utilities such as TOAD, SQL Navigator, PL/SQL Developer, SQL Developer.
• Actively participated in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Knowledge/Exposure in creating DTS packages.
• Good Exposure to C/C++ and Java 1.5.
• Deep understanding of Software Development Cycle (SDLC) and implemented various models as per business requirements.
• Versatile team player with proven problem solving skills. Worked individually as well as in team environments.
• Demonstrated strong communication and interpersonal skills, resourceful decision-making and leadership capabilities.

TECHNICAL SKILLS

Operating systems: HP UNIX, UNIX, Sun Solaris, Windows 10

RDBMS: Oracle12C/11g/10g/9i/8i,Microsoft SQL Server 2008, IBM DB2, MySQL, MS ACCESS

Oracle Tools: Oracle RAC, Oracle Forms 9i/6i, Oracle Reports 9i/6i, SQL*PLUS, SQL*Loader Developer 2000, Informatica Power Center/Power Mart 8.6.

Languages: C, C++, HTML, JavaScript, SQL,PL/SQL, Microsoft Visual Studio.NET

Scripting Languages: UNIX/Korn Shell Scripts, Java Script

Web Technologies: HTML, XML, ASP.NET, ADO.NET

Web Server: IIS 6.0/5.0, Apache 1.3.

Others: Agile and Waterfall Methods, Informatica Power Center, TOAD, SQL Developer, PL/SQL Developer, SQL Navigator, Microsoft Office, Hyperion, MS-Project. Visio and Winputty, E-Terminal, OBIEE.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Lead Senior Developer

Responsibilities:

• Administer and support Manhattan Inventory Optimization application.
• Enable Multistore functionality for QCMP (Quaker City Motor Parts) stores using pl/sql and Unix.
• Worked on project to transfer overstock inventory from a Napa store back to the Napa DC using pl/sql .
• Wrote and automated the NAPA Store SKU feeds for the Informatica Qlik Application using oracle Bulk Collections.
• Tuned and optimized long running SQL statements using Oracle tools.
• Added Pre Processor for MEI (Multi Echelon Item) using pl/sql and xml.
• Worked on LDAP (Light Weight Access Protocol) project to convert user credentials to employee Id’s using xml.
• Worked on subversion source control.
• Technical lead for all projects involving GPC subsidiaries being brought into the IO application.
• Build automated processes to reduce work load on Supply Chain Support team using pl/sql and UNIX scripting.
• Lead team development by building new training/onboarding plans, and presenting training to new employees.
• Adapting to new technologies based on project requirements.
• Gathering business requirements and making recommendations for improvements to team productivity.

Environment: Oracle 18C/12C, SQL, SQL*PLUS, PL/SQL, Informatica, Manhattan Associates IO, SQL Modeler, XML, PL/SQL Developer/Toad, Sun Solaris 5.8, Service Now, MKS, Windows 10 Professional.

Confidential, Atlanta, GA

Lead PL/SQL Developer

Responsibilities:

• Confidential System Study & Business Requirements Analysis & Documentation for Out dialer, Intelliconnection and Virtual Hold.
• Interacted with the client (Tag Mobile & Cincom) in gathering the business requirements and documenting the requirements.
• Trouble-shoot Production issues with the AEON database.
• Reversed Engineered and created new tables in AEON database using SQL Data Modeler and converted the above ER Models into PDF Formats.
• Responsible for analysis, design, development, and testing of Auto dialer, Virtual Hold and Intelliconnection applications.
• Implemented code changes and deployed into production through the MKS system.
• Wrote documentation for the code changes as per business requirement.
• Wrote PL/SQL Procedures, Functions, and Packages for Intelliconnection, Out dialer and Virtual Hold using PL/SQL Developer and Oracle 10g.
• Created Views and Materialized Views in AEON databases.
• Loaded data in AEON/AEON-India database using SQL loader utility.
• Wrote shell scripts and scheduled jobs for Intelliconnection.

Environment: Oracle 11G/10G, NO/SQL, Mongo, SQL Server 2008, SQL, SQL*PLUS, PL/SQL, SQL Modeler -Erwin 4.0, PL/SQL Developer/Toad, Service Now, Sun Solaris 5.8, Perl, MKS, Windows XP Professional.

Confidential, Atlanta, GA

Senior PL/SQL Developer

Responsibilities:

• Confidential System Study & Business Requirements Analysis & Documentation for Closed Loop and IBO Teams.
• Interacted with the client in gathering the business requirements and documenting the requirements.
• Trouble-shooted issues with the tables and Stored Procedures in Merchant Manager Database and loaded data into the tables.
• Wrote SQL Scripts for Closed Loop project.
• Reversed Engineered and created Closed Loop, Closed Loop QA, Closed Loop UAT and Green card ER Diagrams using ERWIN and converted the above ER Models into PDF Formats.
• Responsible for analysis, design, development, and testing of Closed Loop and IBO (In vision Back Office) application.
• Resolved/Fixed Fast Pin Issues in IBO Diff reports.
• Implemented code changes and deployed in production through the change board.
• Wrote documentation for the code changes as per business requirement.
• Activations, Redemptions, Reversals etc have been tested using Confidential Web test tool.
• Wrote PL/SQL Procedures, Functions, and Packages for Closed Loop and IBO databases using TOAD and Oracle 10g.
• Created Views and Materialized Views in merchant manager and closed loop databases.
• Loaded data in merchant manager database using sql loader utility.

Environment: Oracle 11G/10G, NO/SQL,Mongo, Server 2008, SQL, SQL*PLUS, PL/SQL, Erwin 4.0, SQL Navigator/Toad, Sun Solaris 5.8, Perl, Remedy, Smart CVS, Windows XP Professional.

Confidential, Nashville, TN

Senior Analyst/Developer

Responsibilities:

• Dept. of Children Services System Study & Business Requirements Analysis & Documentation.
• Interacted with the client in gathering business requirements and documenting the requirements.
• Involved in Database Schema Design and Logical and Physical Data Models using ERWIN.
• Reversed Engineered & Forward Engineered for CFTM and Health Services Datamarts.
• Responsible for analysis, design, development, and testing of the application.
• Developed PL/SQL Procedures, Functions, and Packages using TOAD and Oracle 10g.
• Developed Views and Materialized Views with fast and incremental Refresh Rates using Oracle TOAD.
• Used SQL*Loader utility to load Large Volumes of Data in the format of CSV files, Excel Sheets into the tables.
• Extensively worked on PL/SQL Error/Exception handling, Control structures in PL/SQL.
• Documented various Datamarts (like CFTM, Health Services, Child Placement etc) in Dept of Children Services and wrote ETL & Technical Specifications Document.

Environment: Oracle 10G, SQL, SQL*PLUS, PL/SQL, Erwin 4.0, SQL Navigator/Toad, Sun Solaris 5.8, Remedy, Smart CVS, Windows XP Professional.

Confidential, Atlanta, GA

Senior Developer

Responsibilities:

• Involved in the full life cycle (SDLC) of design and development of Spyderbots for Monaco project (reward minutes) for Centivia Tool.
• Wrote back-end PL/SQL packages and UNIX shell scripts for data migration & batch processing.
• Developed demonized Spyderbots for collection monitoring, disk space management and for system monitors.
• Loaded data using oracle SQL Loader in Centivia tool.
• Loaded data into the billing staging tables, using stored procedures.
• Tuned the SQL statements for optimal performance.
• Optimized the queries using EXPLAIN PLANS and SQL analyzer.
• Developed new stored procedures for Centivia tool in Direct Debit Payment.
• Involved in Centivia production issues, Auditing process and monitoring the jobs.
• Developed new stored procedures for International call reporting and for Revenue Assurance Team.
• Developed stored procedure for hung Spyderbots in sql server 2005.
• PL/SQL Stored Procedures extensively used for the input of data into Crystal Reports.
• Involved in creating Reports with Combined Queries, Drill Down, Master Detail, Sub-Reports, Drill down Sub Reports on Stored Procedures and Queries by using Crystal Reports.
• Tuned the Crystal Report queries to their optimal run.
• Loaded data using Perl Scripting.

Environment: Centivia 3.0, Oracle 10G, Samson Ensemble Billing system, SQL, SQL*PLUS, PL/SQL, Crystal Reports XI, Perl, SQL Navigator/Toad, Sun Solaris 5.8, Remedy, SQL Server 2005, Windows XP Professional