Cumming-GA *****
******.****@*****.***
917-***-****(cell)
SURESH KODI
IT Experience:
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 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 including 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, promotion from dev to QA to Production.
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 95/98/2K/2003/NT/XP
RDBMS
Oracle11g/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, Java Script
Web Server
IIS 6.0/5.0, Apache 1.3.
Others
Informatica Power Center, TOAD, SQL Developer, PL/SQL Developer, SQL Navigator, Microsoft Office, Hyperion, MS-Project. Visio and Winputty, E-Terminal, OBIEE.
Genuine Parts Company, Atlanta GA
Lead Senior Developer June 2013 – Present
Genuine Parts Company is a distributor of automotive replacement parts and accessories in the U.S., Canada, Mexico and Australasia. The Company also distributes industrial replacement parts in the U.S., Canada and Mexico through its Motion Industries subsidiary. S. P. Richards Company, the Office Products Group, distributes business products in the U.S. and in Canada. The Electrical/Electronic Group, EIS, Inc., distributes electrical and electronic components throughout the U.S., Canada and Mexico.
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.
Added Pre Processor for MEI (Multi Echelon Item) using pl/sql and xml.
SPR Conversion IO upgrade v2007 to v2014 for spreadsheet conversion using pl/sql and unix.
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.
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 12C/11G, SQL, SQL*PLUS, PL/SQL, Manhattan Associates IO, SQL Modeler, XML, PL/SQL Developer/Toad, Sun Solaris 5.8, MKS, Windows 10 Professional.
Intelliverse, Atlanta GA Jan’12 to May’2013
Lead PL/SQL Developer
Intelliverse 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, SQL Server 2008, SQL, SQL*PLUS, PL/SQL, SQL Modeler -Erwin 4.0, PL/SQL Developer/Toad, Sun Solaris 5.8, Perl, MKS, Windows XP Professional.
Incomm, Atlanta GA Feb’10 to Dec’2011
Senior PL/SQL Developer
Incomm 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 (Invision Back Office) application.
Resolved/Fixed FastPin 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 Incomm 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, SQL Server 2008, SQL, SQL*PLUS, PL/SQL, Erwin 4.0, SQL Navigator/Toad, Sun Solaris 5.8, Perl, Remedy, Smart CVS, Windows XP Professional.
Department of Children Services, Nashville TN Sept’09 to Feb’10
Senior Analyst/Developer
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.
T-MOBILE, Atlanta GA Sept’08 to Sep’2009
Senior Developer (Centivia Team)
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, SQL, SQL*PLUS, PL/SQL, Crystal Reports XI, Perl, SQL Navigator/Toad, Sun Solaris 5.8, Remedy, SQL Server 2005, Windows XP Professional
AT&T, Atlanta GA Feb’08 to Aug’08
Analyst/ Developer
Tuned sql statements, Suggested and Implemented indexes for faster retrieval of data as per business requirements.
Wrote, Modified and trouble-shooted the existing stored procedures/packages based on user requirements.
Scheduled Cron jobs as per business requirements.
Loaded data into billing staging tables using SQL Loader and Stored Procedures.
Developed commission's data integrity reports using Oracle Discoverer.
Loaded data using cron jobs and scheduling procedures/packages as per business requirements.
Drawn flow diagrams as per business requirements.
Wrote & involved (BRD’s, SRD’s & FRD’s) in various projects as per business requirements.
Wrote & Involved in various UAT/System test cases.
Involved in SWOT testing procedures and produced weekly report to Horizon team.
Use to check daily Commissions Data Integrity report for Horizon team and will report to the RWOT team for any corrections.
Tuned the Crystal Report queries to their optimal run.
Loaded data using Perl Scripting.
Environment: Oracle 10G, SQL, SQL*PLUS, PL/SQL, Crystal Reports XI, PERL, Discoverer, Teradata SQL assistant 7.0, ERWIN 4.1, SQL Navigator/Toad, Sun Solaris 5.8, CTS, Windows 2000 Professional.
Mail Express, Atlanta GA Aug’07 to Jan’08
PL/SQL developer
Worked extensively to resolve Help Desk Tickets.
Involved in new requirements like ICE screen, Bradford Group & national reports as per business requirements.
Tuned sql statements, Suggested and Implemented indexes for faster retrieval of data in various procedures/packages as per business requirements.
Developed Bradford and national reports using Discoverer.
Troubleshoot Issues with help desk based on user requirements.
Scheduled Cron jobs as per business requirements.
Wrote, Modified and troubleshooting the existing stored procedures/packages based on user requirement.
Loaded data using cron jobs and scheduling procedures/packages as per business requirements.
Drawn flow diagrams as per business requirements.
Environment: Oracle 10G, SQL, SQL*PLUS, PL/SQL, PL/SQL Developer, Discoverer, Sun Solaris 5.8, Vision 10.x, SOLAR, CTS, Windows 2000 Professional.
CINGULAR WIRELESS, Atlanta GA Oct’06 to Aug’2007
Tier III Production developer
Worked extensively under Tier 3 to resolve CTS Tickets in NDR/Vision databases.
Involved in new requirements (FRS) as per business requirements.
Tuned sql statements, Suggested and Implemented indexes for faster retrieval of data in NDR and Vision as per business requirements.
Troubleshoot Issues in NDR/Vision based on user and business requirements.
Scheduled Cron jobs as per business requirements.
Wrote, Modified and troubleshooting the existing stored procedures/packages based on user requirement.
Loaded data from NDR to Vision using cron jobs and scheduling procedures/packages as per business requirements.
Drawn flow diagrams in NDR and Vision based on business requirements.
Environment: Oracle 10G, SQL, SQL*PLUS, PL/SQL, PL/SQL Developer, Remedy Ticketing System, Sun Solaris 5.8, Vision 10.x, SOLAR, CTS, Windows 2000 Professional.
HIGHMARK, Pittsburgh, PA Feb’06 to Sept'06
Oracle Developer
Wrote stored Procedures/Functions/Packages in Consumer Health Management Enroll schemas as per business requirements.
Loaded data into the database tables using sql loader for E - Platform.
Tuned sql statements, Suggested and Implemented indexes for faster retrieval of data for member and employer services.
Extracted data from CHM database into flat files for IPAT Systems.
Used UTL_SMTP package to send email and attachment for user profile services.
Environment: Oracle 10G, SQL, SQL*PLUS, PL/SQL, SQL LOADER, SQL Navigator, Sun Solaris 5.8, Windows 2000 Professional.
Time Warner Cable, Stamford, CT Jan’04 to Dec’05
PL/SQL Developer
Wrote stored Procedures/Functions/Packages in various schemas as per business requirements.
Wrote procedures for division, system and CLA (used oracle types & Ref Cursors) for Residential/Non Residential and Commercial Subscribes and tested these procedures in Report Net Frame work Manager.
Before loading data into Oracle Server, Mapping checks were made from Legacy system (AS/400) Standards to oracle standards and then data was loaded using Informatica as ETL tool.
Good Exposure to Informatica with Transformations and Mappings.
Wrote scripts for creating tables, Indexes, Grants and Synonyms in different schemas and made modifications for the existing tables as per business logic.
Suggested and Implemented indexes for faster retrieval of data in Weekly and Monthly Metrics reports.
Wrote complex views in CDMP & CDMPLT.
Created & Scheduled jobs to run daily and weekly.
Loaded data from different Sources into the Data warehouse environment using SQL Loader.
Extracted data from ODS into CDMP oracle staging tables.
Involved in Cost based and Rule Based Optimization, modified the Explain Plan statements to optimize the SQL statements.
Involved in Unit testing, QA and Implemented in production (CDMP) the above Packages and jobs.
Wrote Documentation for implementing Packages & jobs to run daily and weekly in CDMP and CDMPLT databases.
Wrote DTS Packages and scheduled jobs as per client requirement using SQL Server terminal services.
Wrote Stored Procedures, Views and tables where created as per business logic using SQL server.
Wrote DTS package for weekly fallouts and scheduled the job to run on weekly basis.
Environment: Oracle 9i, Informatica 7.0, SQL Server Enterprise Manager 8.0, Report Net (Report Studio, Query Studio & Framework Manager), SQL, SQL*PLUS, PL/SQL, SQL LOADER, SQLAB 4.7.1, TOAD 7.6, Sun Solaris 5.8, CVS, Windows 2000 Professional and HP-UNIX 11i.
Century Tel Inc., Monroe, LA Jan’03 to Dec’03
PL/SQL Developer
Tuned Procedures for the maximum efficiency in various schemas across databases.
Involved in Cost based and Rule Based Optimization, modified the Explain Plan statements to optimize the SQL statements.
Scheduled Korn Jobs for ATB History Tables.
Wrote scripts for creating tables, Indexes, Grants and Synonyms in Stage, Ref and Dim schemas and made modifications for the existing tables as per business logic.
Wrote scripts to create temporary tables in various schemas.
Loaded data from different Sources into the Data warehouse environment using SQL Loader.
Wrote Documentation for new data model changes in deltas for procedures, triggers, Extracts & rated-feature, customer and atb history tables as per company specifications.
Wrote database triggers to generate sequence numbers before inserting data into the table.
Wrote stored procedures in various schemas (Stage, Ref, Prgmr and Dim) as per business requirements.
Wrote shell scripts, perl scripts and comm. Scripts for customer extract, atb history (atbhistory_load.ksh) and orders (dw_order_extract.ksh) in Data warehouse to load data into stage and dim schemas.
Wrote shell scripts for sorting out the missing Ban’s in the Extracts.
Involved in Unit testing, QA and Implemented in production (Ensemble) the above customer, atb and order extracts.
Wrote shell scripts, Perl scripts and stored procedures for Reconciliation process for Charge and bill in Data warehouse.
Used CVS to check-in and check-out the programs.
Wrote documentation for charge and bill reconciliation process.
Wrote Documentation for Tech Safari Utility Tools for Century Tel Ongoing support.
Projected Scalability for long running jobs, Batch Summary and drawn graph against average records, worst case records and time taken for (end of day, end of month, immediate end of month monthly).
Projected & Tracked run times (timing information) for production & new development (CTDEV environment) for reporting database jobs
Wrote documentation for creating environment in Lamarfp2 for reporting database.
Wrote scripts for creating tables, Indexes, Grants and Synonyms in Reporting Database (repbcvc and qa environments).
Wrote & extracted data into flat files using perl scripts for usage and directory access for Reporting databases.
Wrote sql loader scripts using korn shell scripts for usage & directory access.
Environment: Oracle 8i/9i, Oracle 9IAS, SQL, SQL*PLUS, PL/SQL, SQL LOADER, Oracle Reports 6i,SQLAB 4.7.1, TOAD, Sun Solaris 5.8, Perl 5.6.1, CVS, Windows 2000 Professional and HP-UNIX 11i.
Georgia-Pacific Corporation, Atlanta, GA Sept '01 to Dec’02
Oracle Developer
Created Win Diagrams in Erwin for the corresponding tables.
Involved in Data Analysis, Modeling and Design troubleshooting.
Involved in Star and Snow flakes Models.
Worked extensively as PL/Sql programmer in Data Warehouse Environment in development box and also in production box.
Wrote and Scheduled Korn Jobs for Key Measures Products.
Developed user friendly Portal Pages to allow users for data entry & manipulate the data.
Involved in KMSLR_CODE (Key measures & Service Level Reporting) Schema for DTL and ODS Tables in Level one as well as in Level Two procedures.
Involved in Expanded Data warehouse project since new business rules where added to the KMSLR_CODE schema to load data into the table monthly as well as weekly.
For Consumer users populated data with aggregate tables in KMSLR_CODE schema.
Responsible for writing Database Triggers, Stored Procedures and Back end PL/SQL functions.
Wrote Korn shell Scripts to purge temporary tables
Involved in unit testing and functional integration testing of PL/SQL programs.
Wrote Procedures, Triggers in various schemas as and when required as per business requirements.
Tuned Procedures for the maximum efficiency in various schemas across databases.
Developed Reports for Weekly as well as for Daily for Commercial, Consumer and Retail Products using Reports 6i.
Developed front-end forms depending upon the logic such as master-detail form and complex forms for user friendly for commercial, consumer and retail products using Forms 6i.
Created test plans for the above procedures in key measures according to business logic.
Environment: Oracle 8i/9i, Oracle 9IAS, Oracle Web Portal, SQL, SQL*PLUS, PL/SQL, Oracle Reports 6i, Oracle Forms 6i, SQL LOADER, Windows 2000 Professional and HP-UNIX 11i.
Amli Residential Properties Trust, Chicago, IL April ‘01 to Aug '01
Financial PL/SQL/Reports Developer
Worked extensively as PL/Sql programmer and Financial Reports Developer in Data Warehouse as well as in Oracle Applications across databases in development box and also in production box.
Wrote PL/SQL Scripts & Tuned SQL scripts for AR, GL, AP, INV, Supply Chain Management & Project Accounting Modules. Data modeling for the prototypes using Designer 6.0/6i.
Wrote Scripts for Data-Migration from Flat Files and other Databases into Designer 6i
Created Entity relationship diagrams, Function relationship diagrams and data flow diagrams and enforcing all referential integrity constraints using Designer 6.0/6i.
Maintenance and Administration of PL/SQL objects.
Responsible for writing Database Triggers, Stored Procedures and Back end PL/SQL functions.
Extensively used Procedure Builder to edit compiles, test and debug client and server side PL/SQL program units.
Involved in Korn shell Scripts to purge into database tables & to run cron jobs.
Developed Reports in Data Warehouse for Amli Lien Waivers and Affidavit’s.
Environment: Oracle 8i, Designer6.0/6i, Oracle Discoverer 4i, Oracle Financials 11i, SQL, SQL*PLUS, PL/SQL, SQL LOADER, Oracle Forms 6i & Reports 6i, Windows 2000/NT and HP-UX.
Georgia-Pacific Corporation, Norwalk, CT Oct '00 to March ' 01
PL/SQL Developer
Worked extensively as PL/Sql programmer in Data Warehouse Company in development box and also in production box.
Involved in EIS Schema for PTD's and WTD's in Monthly as well as Weekly procedures.
Involved in Expanded Data warehouse project since new business rules were added to the SGP schema to load data into the table monthly as well as weekly.
For Consumer users populated data with aggregate tables in SGP schema.
Responsible for writing Database Triggers, Stored Procedures and Back end PL/SQL functions.
Wrote Korn & Perl shell Scripts to purge temporary tables
Involved in unit testing and functional integration testing of PL/SQL programs.
Wrote Procedures, Triggers in various schemas as and when required as per business requirements.
Tuned Procedures for the maximum efficiency in various schemas across databases.
Developed Reports for Weekly as well as for Daily for Commercial, Consumer and Retail Products.
Environment: Oracle 8i, SQL, SQL*PLUS, PL/SQL, Oracle Reports, Perl, Windows NT and UNIX.
Spellman High Voltage Electronics Corporation, New York. Aug ‘98 to Sep’00
Oracle Developer
Participated in a team involving generation of item discrepancy report and this report prints data for any part weather the data present in that table or not as required for Spellman using reports 3.0.
Exported and Imported the Glovia files in Oracle Enterprise Manager and as well as in the UNIX environment. The list of files will be standard lookup tables like Vendor, Customer and possibly additional data.
Wrote shell scripts for Glovia files under UNIX environment.
Wrote PL/SQL scripts to load data into the Glovia files.
Migrated the Glovia files and the Oracle data into the present system using SQL Loader.
Monitored the System Table space and adding additional data files to the Table spaces in Oracle Storage Manager.
Identified and mapped the various entities, referential integrity constraints and relationships.
Developed forms and reports for giving input and for generation of reports in Glovia files using forms 5.0 and reports 3.0.
Environment: Oracle 8.X, SQL, SQL*PLUS, PL/SQL, Forms 5.0, Reports 3.0, Windows NT and UNIX.
EDUCATION:
Master's Degree in Transportation Engineering. 1992-1994
Bachelor Degree in Civil Engineering. 1984-1988