Data Developer

Chinnish Borra

Ph: 972-***-****

******.***@*****.***

SUMMARY

Around 5 Years of Experience in IT primarily in Telecom, Education and Retail Sectors as Oracle Developer primarily in Windows & UNIX Environments.

Have complete understanding of the SDLC (Software Development Life cycle) and various Software Engineering Methodologies like OOAD and UML.

Worked Extensively on Oracle 9i/8i/10g/11g and 12c, SQL Server, PL/SQL, Informatica, HP-UX, Sun Solaris OS, Linux AS.

Experience in E-R Modeling to create Data Models both Logical and Physical design using ER Win.

Experienced in working with Huge Datasets comprising of at least greater than 10 Mill records.

Competent in Tuning the SQL and PL/SQL Procedures by enforcing HINTS and OPTIMISER and by using SQL Trace, Explain Plan and TKPROF Tools.

Writing Triggers.

Exposure to data support on Multiple Environments like UAT, SIT, DIT, Training, and Production Environments on an Enterprise Level. Responsible for data consistency and integrity across the board.

Well versed with SDLC.

Enthusiastic to learn new skills with a shorter learning curve.

Excellent Communication, Good Work Ethics and a Team Player.

TECHNICAL SKILLS

Languages

C, C++,SQL,PL/SQL,Pro*C,Java, .NET,C#,VB.NET.

Databases

Oracle 12c/11g/10g / 9.0/8i/7.X, SQL Server

GUI Development

Oracle Forms, VB

Operating Systems

UNIX, Windows 9X /2000/NT/XP.

Version Management

WinCVS, Clear Case,

Bug Tracking

Mantis, Bugzilla, Merant Tracker

Data Modeling Tools

ER Win 3.5.2 /4.0, Oracle Designer

Others

MS Office ‘97 thru 2010, MS Visio, MS Project, Toad, Sql Navigator.

Reporting Tools

Oracle Reports

Scripting

Ksh / C Shell / Bourne

ETL

Informatica 5.1/6.2/7.0

ACADEMICS

M.Sc in Electronics.

PROFESSIONAL EXPERIENCE

Qualcomm – San Diego, CA. 11/2016 to Current

Oracle Applications Sr. Programmer Analyst

Environment: Oracle 10g/11g/12c (PL/SQL, Export / Import, External Tables, SQL*Loader, SQL Trace, Explain Plan, TKPROF, CRON TAB), Oracle EBS R12, Oracle Forms 10g, Oracle Reports 10g, Pro*C, HP-UX B.11.23, TOAD, MS SQL Server 2000,MS Windows XP/2008, MS Office 2010, MS Office 2007, MS Visio.

DISD implemented Oracle ERP system for their ongoing business requirements. DISD maintains their Vendor information, Payment, Purchasing, HR and Payroll in Oracle ERP system. All expenses and vendor payments will be done through Oracle AP.

Responsibilities:

Gathering User requirements and implement them in the best possible way and document the process.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day.

Created PL/SQL stored procedures, functions and packages to automate Employee vendor Bank Account in synch with Payroll Bank Account for Electronic payment using stored Procedure.

Developed INBOUND and OUTBOUND Interfaces based technical specifications.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Created PL/SQL scripts to extract the data from the operational database into flat text files using UTL_FILE package

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Hands on Experience with UNIX scripting (FTP, SFTP and Keys exchange, Shell Scripting)

Developed oracle reports in Financial Modules based on user requirements.

Developed shell scripts.

Provide 24X7 supports, resulting in timely resolutions of issues in the application.

Zale Corporation - Dallas Texas 1/2015 to 10/2016

Sales Audit / Marketing / Polling Applications Sr. Programmer Analyst

Environment: Oracle 9i/10g/11g (PL/SQL, Export / Import, External Tables, SQL*Loader, SQL Trace, Explain Plan, TKPROF, CRON TAB), Oracle Forms 6i, Oracle Reports 6i, Pro*C, HP-UX B.11.23, TOAD, MS SQL Server 2000,MS Windows XP/2003, MS Office 2003, MS Office 2007, MS Visio.

Perform Computer system analysis, programming and supporting and maintain multiple systems like Xstore, Sales Audit, and Polling and Database Marketing applications.

Responsibilities:

Development / Planning / Testing / Installing and Documenting Software Applications and computer programs for UNIX Client/Server based applications.

Debugging / Developing Complex programming logic for new and existing applications.

·Serving as the lead on internal design activities of large, Complex Systems and coordinating it with other members.

Translate business requirements into technical specifications; gathering, analysing and reviewing technical information to increase operating efficiency.

Supporting and Maintaining Sales Audit system, making changes to these programs based on the business requirement where we load daily sales data.

Wrote database triggers to audit the user activity.

Supporting Marketing Epiphany campaign management application that loads daily customer data, cleanse the data and uploading the data to front-end.

Supporting Polling application that sends daily downloads to the stores like prices changes, purchase orders etc.

Sales audit archive and Telecom Phone setup Oracle Forms/Reports Applications.

Writing PL/SQL programs and Shell scripts based on the Functional requirements.

Loading data from different vendors and writing ftp scripts.

Tuning existing PL/SQL programs.

Minor database Administration Activities.

Oversee and maintain customer satisfaction in all activities of the development lifecycle.

Provide 24X7 supports, resulting in timely resolutions of issues in the application.

Verizon Advanced Data Svcs, TX 9/2014 – 1/2015

Product Catalog (PCAT) Oracle Developer

Environment: Oracle 9i / 10g (PL/SQL, Export / Import, External Tables, SQL*Loader, SQL Trace, Explain Plan, TKPROF, CRON TAB), HP-UX B.11.00, ER Win 3.5.2, TOAD, Developer 2000, DB Artisan, Win CVS, J2EE Architecture, MS Windows XP/2003, MS Office 2003, MS Project 2000, MS Visio.

Product Catalog hosts products related to data communication such as DSL, SHDSL, Dial, DIA, Web hosting, VPN, Fios data, Fios Video, DNE, and DNR. Product Line Manger (PLM) enters the product related data in National Console. PCAT pulls these product changes and makes them available for ordering after validating the data. Working in both VOL (retail) and VADI (wholesale) product catalogs.

Responsibilities:

Developed GUI for PLMs to define/enter product data using Developer 2000.

Developed procedure to extract data from National Console and populate the data in different tables.

Involving actively in deriving the requirements with the Business Folks.

Document these product changes and present them to development teams.

Developed Stored Procedures that are available to the ordering system to pull products based on the needs.

Using ER Win for Making changes to the physical data model based on the Business requirements.

Refresh the monthly data of NPA/NXX/Switch clli from Telcordia in different environments.

Developed product validation scripts based on the Business requirements.

Generate scripts for new product change requests and load them in DIT/SIT for testing.

Have scheduled jobs using CRON TAB to load the above in the Production after test certification.

Looking in Bug tracking Tool Merant Tracker for IRs raised against PCAT.

Document and Co-ordinate the new products changes with application development team and testing team.

Verizon Advanced Data Svcs, TX 5/2013 - 8/2014

SSP Data Migration Oracle Developer

Environment: Oracle 9i, (PL/SQL,CRON TAB, Export / Import, External Tables, SQL*Loader, SQL Trace, Explain Plan, TKPROF), Sun Solaris 5.8, RH Linux AS 2.1, Win CVS, Merant Tracker.

SSP (Strategic System Profile) is a Order System for Verizon Broadband. The Merger between GTE and Bell Atlantic required a consolidation of source systems and resources. SSP is the new ordering system. The data from both the GTE and Bell Atlantic Ordering Systems required a migration into SSP. Customer Profile from four source systems (IPAC/ OASIS/ NX / BX) should be migrated to SSP. The Validation source to check against is ARBOR, the Billing System.

Responsibilities:

Actively participated in the Business and SSP Architectural Meetings.

Document the Business requirements and design.

Based on the Test Feeds, took the ownership of mapping the corresponding data elements in SSP.

Developing the necessary loading scripts for loading the source data using SQL*Loader and External Tables and resolving any Data Type related Issues.

Installing and Maintaining the Version Control System – WinCVS.

Installing and Maintaining the Bug Tracking Tool, Merant Tracker.

Developing the Packages, Stored Procedures and Triggers to incorporate the Business Logic.

Developed a Parallelization process at the UNIX Level, which fastens up the process thereby reducing the Application Downtime.

Developed a module for Address Conversion from USPS to G1C1 Format using a third party tool called G1 SW.

Extensively used the DBMS_OBFUSCATION package for handling sensitive customer Data.

Taking the Database Dump using Export / Import Utility to provide data to other environments like UAT, SSP Training and PLE on adhoc basis after the mock runs.

Post Conversion -- Generating the required External Feeds to various systems like ARBOR, Remedy, VIS etc

Actively involved in planning the System Downtime and Co-Ordination during the actual Conversion Process.

Documented the Archival of the old Source System effort.

Verizon Advanced Data Svcs, TX 4/2014 - 4/2013

Data Reconciliation Tool Oracle Developer

Environment: Oracle 9i / 10g (PL/SQL, Export / Import, External Tables, SQL*Loader, SQL Trace, Explain Plan, TKPROF, CRON TAB),Developer 2000, HP-UX B.11.00, ER Win 3.5.2, TOAD, DB Artisan, Win CVS, .NET Architecture, MS Windows XP/2003, MS Office 2003, MS Project 2000, MS Visio.

DRT is a reconciliation tool for the DSL Customers between the Billing (ARBOR) and Provisioning Systems (NCON/ BAAIS). Data from various systems is received twice a week.

This data set is bashed against twice a week to generate the Out of Sync’s between the Billing and Provisioning systems. The interface engine is based on .NET providing Workflow and Drill down reports.

Responsibilities:

Involved actively in deriving the requirements with the Business Folks.

The entire Front end is done in Developer 2000.

Using ER Win, designed the Data Model for the Tool.

Loading the flat files into Source tables in the schema using Oracle External Tables and SQL* Loader.

Developed the necessary Packages and Stored Procedures to incorporate the Business Logic.

Tuning the SQL’s by enforcing HINTS, choosing optimizers and Tuning utilities like SQL Trace, Explain Plan and TKPROF.

Developed the necessary Shell Scripts to facilitate the automation of the process from loading and until the Refresh is complete with necessary notification processes.

Developed a Parallelization process at the UNIX Level, there by reducing the refresh time from 24hrs to 8hrs.

Have scheduled recurring jobs using CRON TAB.

Refreshing the data from and to various environments like UAT and PLE by using Export / Import Utilities of Oracle.

Contact this candidate