SUMMARY:

• Extensive experience in the Information Technology field with the experience of managing and executing IT work on multiple technologies such as Oracle SQL, PL/SQL, Oracle Apex, UNIX, LINUX, Oracle Tuning, Informatica, Java, Java Script, J2EE, PHP, .Net, SQL Server, SSRS, Oracle Forms Builder, Oracle Reports Builder, Oracle Applications, Pro*C, Developer2000, SQL Server, VB6, AS/400, IBM Mainframes, Lotus Notes, Business Objects
• Highly experienced in analysis, design, development, testing, production support and maintenance of applications developed using Oracle SQL, PL/SQL, UNIX, Oracle Apex, Oracle Forms Builder, Oracle Reports Builder
• Extensive experience in back - end programming, relational databases, data warehousing and development & maintenance of complex and critical systems
• Experienced in providing solutions and fix to various Production Problems, completion of different Service Requests and working in Agile software development environment.
• Good technical and functional knowledge of Oracle Applications in implementation, enhancements, customizations, migration, interfaces, data extractions and data conversions
• Knowledge in the technical aspects of Oracle Applications INV, BOM, OM, WIP, WSH, PO, GL, AP, AR, Applications Object Library (AOL) and System Administration
• Good experience in developing Interfaces and Conversion Programs to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader and UTL File
• As a Designer/Analyst/Developer experienced in all phases of the Software development life cycle - Analysis, Design, Development, Testing, Maintenance and Documentation
• Seasoned in Quality activities pertaining to SEI CMM standards
• Excellent communication and personal skills, good team player, strong analytical skills and can work with individuals at all levels

TECHNICAL SKILLS:

Languages & Tools: Oracle SQL, PL/SQL, Oracle APEX 4.2, SQL*Loader, UNIX Shell scripting, TOAD, SQL Developer, Explain Plan, TKProf, DBMS Profiler, Autosys, VSS, PVCS, AccuRev, WinCvs, FileZilla, WinSCP, PAC2000, Putty, Oracle Forms Builder 6i, Oracle Reports Builder 6i, SSRS, Developer 2000, Business Objects 6.5, Oracle Applications 11.5.8, Oracle Designer, Pro*C, C, SQL*Plus, SQL*Forms 3.0, SQL*Report Writer 1.1, SQL*Menu 5.0, VB6, RPG/400, COBOL, JCL, VSAM, CICS, Lotus Notes 4.5

Databases: ORACLE RDBMS 11g/10g/9i/8i/7.x, SQL Server 2012, DB2, FoxPro, MSAccess

Operating Systems: Risc UNIX (SMOS 8.27), Linux - SuSE FUSE Version 4.1, AIX, Windows 95, 98,NT, 2000, XP, 7, 8, MS-DOS

Other Software: FoxPro, MSOffice, COGNOS, Informatica, COM/DCOM, Xmotif, Windows

Other Languages: C++, Java, Java Script, HTML, XML, JSON, Perl, SQL/400, CL/400

Hardware: R4000 (Dual CPU), Pentiums, Mainframes, AS/400

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte NC

Sr. Oracle Developer

Responsibilities:

• Worked on updating complex views to solve production issues and enhancements.
• Worked on query optimization by parsing Json format Clob content in the table.
• Worked on Autosys batch jobs to solve production issues.
• Worked on development of procedures, views and table designs.
• Worked on PL/SQL Extract Transform and Load (ETL) development and handling of large data volume.
• Worked on Linux shell scripting using Putty and WinSCP.
• Analyzed the requirements, generated test results and created the necessary tables, views, stored procedures and sequences for the project.
• Worked on Linux servers and used vi editor to update files.

Confidential, Charlotte NC

Sr. Oracle Developer

Responsibilities:

• Worked on setting up iTOA Carolina application links on the multiple windows servers.
• Worked on setting up single sign-on and secured application links.
• Worked on helping team members to complete data conversion scripts.
• Worked on completing data conversion and interface design documents.
• Communicated with other teams to gather required information to setup app links.
• Reviewed packages, procedures, functions and table designs.
• Worked on PL/SQL Extract Transform and Load (ETL) development and handling of large data volume.

Confidential, Charlotte NC

Sr. Oracle Developer

Responsibilities:

• Worked on helping team members to solve database related issues.
• Worked on performance tuning of complex sql queries.
• Worked on nightly Autosys batch job process enhancements.
• Reviewed packages, procedures, functions and table designs.
• Worked on data warehouse environmenthaving data coming from upstream systems, loading and processing incoming data using Autosys jobs. Making data ready for various reports and to be used by downstream systems.
• Worked on PL/SQL Extract Transform and Load (ETL) development and handling of large data volume.
• Worked on Unix/Linux shell scripting using Putty and WinSCP.
• Analyzed the requirements, generated test results and created the necessary tables, views, stored procedures, functions and sequences for the project.
• Monitored production jobs to make sure the files are properly being processed and fixed production issues.
• Worked on Unix and Linux servers and used vi editor to update files.
• Used WinSCP to transfer files between Windows and Unix & Linux server.
• Completed various online mandatory company s.

Confidential, Charlotte NC

Sr. Oracle Developer

Responsibilities:

• Worked on new field additions of daily feed using Informatica.
• Worked on new field additions of weekly feed using SQL loader.
• Worked on nightly Autosys batch jobs.
• Worked on development of packages, procedures, functions and table designs.
• Worked on PL/SQL Extract Transform and Load (ETL) development and handling of large data volume.
• Worked on Linux shell scripting using Putty and WinSCP.
• Analyzed the requirements, generated test results and created the necessary tables, views, stored procedures, functions and sequences for the project.
• Worked on Linux servers and used vi editor to update files.

Confidential, Charlotte NC

Sr. Oracle Developer

Responsibilities:

• Worked on finding root cause of failed jobs and providing solutions for successful job run.
• Worked on server migration from Unix to Linux.
• Worked on helping team members to solve database related issues.
• Worked on performance tuning of complex sql queries.
• Worked on nightly Autosys batch job process enhancements.
• Reviewed packages, procedures, functions and table designs.
• Worked on data warehouse environmenthaving data coming from upstream systems, loading and processing incoming data using Autosys jobs. Making data ready for various reports and to be used by downstream systems.
• Worked on PL/SQL Extract Transform and Load (ETL) development and handling of large data volume.
• Worked on Unix/Linux shell scripting using Putty and WinSCP.
• Analyzed the requirements, generated test results and created the necessary tables, views, stored procedures, functions and sequences for the project.
• Monitored production jobs to make sure the files are properly being processed and fixed production issues.
• Worked on Unix and Linux servers and used vi editor to update files.
• Used FileZilla and WinSCP to transfer files between Windows and Unix & Linux server.

Confidential, Orlando FL

Sr. PL/SQL Developer

Responsibilities:

• Worked on developing new Oracle application named Amazon Web Store Re-platform of Tupperware.com which is used to process order and payment XML files received from Amazon and to send acknowledgement, shipment and adjustments XML files to Amazon.
• Worked on Online Recruiting enhancements to add Self Recruitment functionality.
• Analyzed the requirements, generated test results and created the necessary tables, views, stored procedures, functions and sequences for the project.
• Wrote necessary PL/SQL package Scripts for successful running of the programs.
• Worked on production support work including error analysis and trouble shooting.
• Monitored production jobs to make sure the files are properly being processed and fixed production issues.
• Worked on Linux server and used vi editor to update XML files.
• Interacted with the team members to ensure bug free delivery of the work.
• Created required technical documents such as Technical specifications
• Complete responsibility of deliverables as well as the production support.
• Ensured that the programs, scripts, procedures fully tested to ensure bug free performance.

Confidential, Orlando FL

Sr. Oracle Apex Developer

Responsibilities:

• Worked on developing new Oracle Application Express applications such as WindQInspec - Checklist Administration and Activity Manager.
• Worked on various enhancements such as JSON File generation, Mobile Incident Reporting enhancements, Focus Re-architecture, Planner’s view development, CRDB Config Records Migration.
• Analyzed the requirements, generated test results and created the necessary tables, views, stored procedures, functions and sequences for the project.
• Wrote necessary PL/SQL package Scripts for successful running of the programs.
• Created new Oracle Apex web pages as required for the applications.
• Implement UI enhancements as asked for by the business to the existing applications.
• Modify the underlying data model behind the applications as necessary to support the remediation.
• Interacted with the team members to ensure bug free delivery of the work.
• Created required technical documents such as Technical specifications, Test results.
• Followed company guidelines and processes to complete the tasks.
• Complete responsibility of deliverables as well as the production support.
• Ensured that the programs, scripts, procedures fully tested to ensure bug free performance.

ProjectCCW Quoting (Cisco Commerce Workspace Quoting)

Project TypeProduction maintenance, Enhancements

PlatformOracle 11g, SQL, PL/SQL, Java, Toad, SQL DeveloperWinCvs, PVCS, Windows 7 Enterprise

Duration

ClientCisco, San Jose CA USA

EmployerMastech Inc, USA

Cisco is a worldwide leader in networking - transforming how people connect, communicate and collaborate. Cisco designs, manufactures and sales networking equipment including routers, IP phones, switches, servers video, wireless, storage networking, security products etc.

Responsibilities as IT Engineer:

• Worked on various enhancements such as Rebate calculation, Royalty cost automation, Service cost calculation, Revenue Transfer Calculator, My Deal Manager enhancements, Service ordering, Packages, Functions and Procedures improvements.
• Performed SQL tuning on complex queries using tools such as Explain Plan, TKProf and DBMS Profiler.
• Analyzed the requirements, generated test results and created the necessary tables, views, stored procedures, functions and sequences for the project.
• Wrote necessary PL/SQL Scripts for successful running of the programs.
• Created required technical documents such as Technical specifications, Test results.
• Interacted with onsite QA team to ensure the tasks are completed bug free and on time.
• Followed company guidelines and processes to complete the tasks.

Confidential, Columbus OH

Software Developer Sr

Responsibilities:

• Worked on various enhancements such as Advanced Search screen, Skill Mapping new application, JRAS HR SSP report, Seat Selection based on LOB, Table update queries, Performance Tuning and APEX web pages changes.
• Analyzed the requirements, designed process flows, generated test results and created the necessary tables, stored procedures for the project.
• Updated existing and created new Oracle Apex web pages as required for the applications.
• Wrote necessary PL/SQL Scripts for successful running of the programs.
• Created the necessary tables, stored procedures, triggers and sequences for the project.
• Created required technical documents such as Impact Analysis, Test cases, Test results.
• Followed company guidelines and processes to complete the tasks.
• Completed online company courses such as Fair Lending, Responsible Lending, American with Disabilities Act, Resiliency Risk Awareness, Privacy Awareness Assessment, IT Risk Awareness, Anti-Money Laundering, Information Barriers and Communications for Mortgage Banking, Technology Usage and Information Practices, Treating Customers Fairly for Mortgage Banking, TCPA Cell Phone Regulations.
• Involved in performance tuning of programs.
• Ensured that the programs, scripts, procedures fully tested to ensure bug free performance.

Confidential, Dearborn MI

Senior Systems Analyst

Responsibilities:

• Worked on various eTrackers such as Linking documents, Journal Template change, R to T linking, Applied to source, SAAVE auto archival, Transfer price, Spawning changes, FVA Purge, Oracle upgrade, PARS, VINCENT Reporting, Calendarization, Data Extracts and Loads.
• Executed regular jobs such as SAAVE archival rule DBCR for archiving right amount of data to ensure to complete within allotted time frame, monitoring production activities to ensure smooth running of jobs, rule copy from production to QA.
• Analyzed the requirements, designed process flows, designed program specifications, generated test results and created the necessary tables, stored procedures for the project.
• Worked on production support work including error analysis and trouble shooting.
• Wrote necessary PL/SQL Scripts for successful running of the programs.
• Worked on data warehouse environmenthaving data coming from upstream systems, loading and processing incoming data using Autosys jobs. Making data ready for various reports and to be used by downstream systems.
• Worked on database migration from Oracle 9i to Oracle 11g.
• Worked on PL/SQL Extract Transform and Load (ETL) development and handling of large data volume.
• Worked on new UNIX shell scripts developments and updated existing UNIX shell scripts.
• Worked on using FTP for text file transfer and for using text files for data load.
• Worked on using SQL Server Management Studio, SQL, T-SQL, and SSRS.
• Worked in Agile software development environment.
• Managed and interacted with offshore and onsite team to ensure the tasks are completed on time.
• Followed company guidelines and various processes to complete the tasks to minimize any audit findings.
• Completed company courses such as Records and Information Management, Standards of Corporate Conduct, Data safeguarding course, Careful Communication, Unauthorized commitments course, Hazardous Materials Transportation, Health and Safety, Global Mutual Respect course.
• Involved in performance tuning of many custom programs.
• Complete responsibility of deliverables as well as the production support.

Confidential, Ann Arbor MI

Senior Developer

Responsibilities:

• Analysis of the requirements and client interaction.
• Designing program specifications and test cases.
• Developed custom reports like Deferred Revenue Report, Revenue Lines Matching, Revenue Lines Non-Matching, Revenue Fact EEBO1Like, With Free Revenue Details, Without Free Revenue Details, Revenue Fact PAL By Quarter, Revenue Fact PAL By Year, Usage Report.
• Writing Pl/SQL programs for processing data to get the required report.
• Created the necessary tables, stored procedures and sequences for the project.
• Wrote necessary PL/SQL Scripts for successful running of the programs.
• Solving production problems and providing support to the project.
• Involved in performance tuning of many custom programs.
• Executing the testing of the custom programs.
• Complete responsibility of deliverables as well as the production support.
• Handling errors and creating the error reports.
• Preparation of test review and installation documents.
• On time delivery of the deliverables.
• Ensured that the programs, scripts, procedures fully tested to ensure bug free performance.
• Following Quality guidelines pertaining to company standards.

Confidential, Irvine CA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Involved in Design phase for designing of custom interface tables.
• Design and developed the Invoice to JDE outbound interface to send required invoice information to JDE immediately after the order is closed.
• Created MD070 for the Invoice to JDE outbound interface.
• Developed a PL/SQL program for the Invoice to JDE outbound interface.
• Developed PL/SQL programs for validating the data from input tables and migrating data from the input table to Oracle staging tables.
• Designing program specifications and test cases.
• Executing the testing of the custom programs.
• Handling errors and creating the error reports.
• Preparation of test review and installation documents.
• On time delivery of the deliverables.

Confidential, Lansing MI

Senior Oracle Developer

Responsibilities:

• Analysis of the requirements.
• Designing program specifications and test cases.
• Developing required Forms and Reports.
• Modifying the existing programs as per the requirement.
• Extensively worked on Forms and Reports.
• Created the necessary tables, stored procedures, triggers, and sequences for the project.
• Wrote necessary PL/SQL Scripts for successful running of the programs.
• Coded the required user entry screen programs, background programs for the successful working of the project.
• Fine tuning the SQL Queries to improve the speed of program execution.
• Coordinated with testing team to ensure that the Testing is done successfully and the program is moved to production without defects.
• Ensured that the programs, scripts, procedures fully tested to ensure bug free performance.
• Enhancement of this module to cater to the changing needs.
• Performing testing and bug fixing.
• Solving production problems and providing support to the project.
• Complete responsibility of deliverables as well as the production support.

Confidential, Bloomington IL

Systems Analyst

Responsibilities:

• Requirement analysis and discussion with client for clarification of the requirements.
• Writing new code, modifying the existing code and reviewing them.
• Testing of modified and newly written programs.
• Delivery of the completed programs to the client.
• Enhancement of forms such as Service, Registrations, Component Detail forms.
• Creation of new forms, agents, views and reports.
• Coordinated with users to ensure that the User Acceptance Testing is done successfully.
• Ensured that the programs, scripts, procedures fully tested to ensure bug free performance.
• Provided the necessary support activity and also handled the additional enhancements as specified by the user from time to time.
• Coordinated with users to ensure that the User Acceptance Testing is done successfully and the program is moved to production without defects.
• Involved in redesigning many of the old codes to cater to the additional requirements.

Confidential

Senior Developer and Group Leader

Responsibilities:

• Analysis of the requirements.
• Designing program specifications and test cases.
• Coding for the Interface programs to extract data into flat file and uploading of data files to the Accounts Receivable application.
• Coding for the conversion programs.
• Testing of the Interface programs.
• Writing stored procedure for different complex reports using PL SQL.
• Coding for different screens.
• Created the necessary stored procedures, triggers for the project.
• Wrote necessary PL/SQL Scripts for successful running of the programs.
• Created several procedures, triggers using TOAD Software.
• Reviewing work of group members and providing necessary help to them.
• Defect Prevention Representative (DPR).
• Coded the required user entry screen programs, background programs, end of the day programs for the successful working of the project.
• Coordinated with users to ensure that the User Acceptance Testing is done successfully and the program is moved to production without defects.
• Ensured that the programs, scripts, procedures fully tested to ensure bug free performance.
• Preparation and Review of Documentation of programs.
• Working in different shifts to provide complete support to the critical billing activities.
• Requirement analysis of the business specifications and converting them into technical specifications.
• Preparation and Review of Unit Test Cases to test programs.
• Coding and peer to peer review of programs, menus & commands and testing them.
• Running SQL/400 & QUERY/400 to prepare test data for testing of programs.
• Preparation and Review of Documentation of programs if required.
• Delivery of the programs completed to client.
• Providing application as well as AS/400 to other team members.
• Analysis of the Client’s Service Request
• Preparation of test cases and test data for all the modules/screens
• Preparation of Program Specifications
• Coding for the programs and Unit and integrated testing

Confidential

Developer

Responsibilities:

• Analysis of the requirements
• Creation of Design Specifications for the system
• Preparation of test cases and test data for all the modules/screens
• Preparation of Program Specifications
• Test cases preparation and review
• Writing required functions and procedures
• Coding and Code review
• Modified existing Pro*C programs as per the requirements.
• Performing unit, integrated testing and bug fixing

Confidential

System Officer

Responsibilities:

• Analysis of the manual working process and Requirement Study.
• Creation of Design Specifications for the system.
• Developing required Forms and Reports. Developed many new forms and reports for Personnel, Payroll, Financial Accounting and Daily reporting systems.
• Modifying the existing programs as per the requirement. Modified several reports, forms, processing code of Personnel, Payroll, Financial Accounting and Daily reporting systems.
• Created the necessary tables, stored procedures, triggers, and sequences for the project.
• Wrote necessary PL/SQL Scripts for successful running of the programs.
• Coded the required user entry screen programs, background programs, end of the day programs and a host of other pro *C programs for the successful working of the project.
• Modified existing Pro*C programs as per the updated requirements.
• Maintaining backup of the database.
• Writing Shell scripts for the application.
• Performing testing and bug fixing.