SUMMARY:

An IT professional with skills encompass system business analysis and design, preparation of business process documents, use cases, functional/technical documents, programming in multi - tier client/server environment with different DBMS/RDBMS, building front end GUIs, backend database programming, designing and developing reports

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000/NT/XP, Sun Solaris UNIX, SCO UNIX/XENIX, HP-UX Release 10.20, Windows 3.11, NOVELL NetWare, DOS

Programming Languages: SQL, PL/SQL, Pro*C, C/C++, PERL/ Confidential, HTML, JAVA/JAVA Script, COBOL, Assembly, FORTRAN, PASCAL

DBMS/RDBMS/Front End Tools: ORACLE 7.3x/8/8i/9i/10g/11g, Developer 2000(Forms 4.5/5/6/6i, Reports 2.5/6/6i, Procedure Builder, Graphics), FoxPro for Windows/DOS/LAN, FoxBASE, dBase III+, Clipper, MS-Access, Data Modeling with Rational Rose, Oracle Financial Release 12 (GL, AP, AR)

Utilities: Exceed, TOAD, SQL Navigator, Oracle Discoverer, SQL Loader, SQL Station, PVCS, FTP, VISIO, Office Vision, Microsoft Outlook, Reflection 2, Action Request System 4.0, EDI, Timbuktu Pro, Lotus Notes Desktop, ODBC, Shell Scripting, MS Project 98, MS Power Point

Word processors: Microsoft Word, Word Star, Word Perfect

Spreadsheets: MS Excel, Lotus 123

SKILLS:

• Good communication (oral and written) and interpersonal skills
• Dedicated, punctual individual who is sensitive to clientele
• Team player who also works well independently with minimum supervision
• Reliable, fast learner, always eager to take new tasks and challenges

PROFESSIONAL EXPERIENCE:

Sr. PL/SQL Developer

Confidential, Detroit, MI

Responsibilities:

• Working for Confidential (Customer Services and Billing) application
• Prepared Technical Documents related to changes/enhancements
• Assisted in impact analysis of changes made to database objects
• Developed/modified Packages/Stored Procedures/Functions/Forms/Pro*C code related to the modifications related to turn on/disconnect events for electricity and gas, billing in a multi-tier environment
• Performed Unit test/Integration test/User Acceptance Test before moving the code to production
• Debug/Troubleshoot Packages/Procedure/Forms to fix different production issues
• Resolved performance issues by Tuning the different complex queries/procedures

Environment: ORACLE 11g, SQL Developer, TOAD, SQL, PL/SQL, C/Pro*C, XML, ClearCase, Unix, Linux, Windows 7, Oracle Forms 6/Tuxedo, MS Office, Maestro, WinSCP, PUTTY

PL/SQL Developer

Confidential, Charlotte, NC

Responsibilities:

• Worked with the BA’s to discuss Business Requirements related to Promotion module of RMS using SDLC methodology. The purpose of the project was to automate the senior citizen discount functionality by introducing special code in Promotions
• Developed/modified Packages/Stored Procedures/Functions/Forms/Pro*C code related to the modifications of Promotion module in a multi-tier environment
• Resolved performance issues by Tuning the different complex queries/procedures

Environment: ORACLE 11g, Confidential (RMS), SQL Developer, TOAD, SQL, PL/SQL, C/Pro*C, XML PVCS, Unix (HP-UX 11), Linux (2.6.9), Windows 7, Oracle Forms 10.1 for Unix, JAVA/JAVA Script, MS Office, JIRA (Project/Bug Tracking), AppWorx (Batch Scheduler), Exceed

Confidential, Austin, TX

Responsibilities:

• Worked on a project to modify the different functionality in Oracle EBS and provide support to different production issues
• Prepared Technical Documents related to changes/enhancements
• Developed/modified Packages/Stored Procedures/Functions/Triggers/Form/Reports related to Oracle R12 functionality in a multi-tier environment
• Perform Unit test/Integration test/User Acceptance Test before moving the code to production
• Worked with the client at all levels
• Proposed solutions to different issues

Environment: Oracle EBS R12, ORACLE 11g, Oracle Developer 2000, PL/SQL Developer, TOAD, SQL, PL/SQL, Mercurial, Windows XP, UNIX, MS Office, Control-M

PL/SQL Developer

Confidential

Responsibilities:

• Lead a team of developers in the Merchandise Hub project in which HBC group was bringing all its companies to one common database which mostly involve Data Migration from Mainframe to Oracle database in a client server environment
• Prepared Technical Documents related to changes/enhancements in Agile environment
• Assisted in impact analysis of changes made to database objects
• Developed/modified Packages/Stored Procedures/Functions/Database Triggers
• Perform Unit/Integration test/UAT - User Acceptance Test before moving the code to production
• Worked on loading XML files of different utilities companies (Gas/Power) to Oracle database
• Created UNIX shell scripts for batch programs
• Actively took part in meetings with the client

Environment: ORACLE 11g, PL/SQL Developer, Oracle SQL Developer Data Modeler, SQL, PL/SQL, XML, Mercurial, Windows 7, Office 2010

Senior PL/SQL Developer

Confidential

Responsibilities:

• Provided support to the Billing system in multi-tier environment
• Developed/modified Packages/Stored Procedures/Functions/Triggers/Shell Scripts
• Perform Unit/Integration test/UAT - User Acceptance Test before moving the code to production
• Worked on Forms/Reports/SQL Loader
• Worked with the client at all levels
• Provided production support on call basis
• Build different complex queries on ad hoc basis

Environment: ORACLE 10g/11g, Developer 2000(Forms 6i, Reports 6i), C/Pro*C, SQL, PL/SQL, Windows 95/NT/XP, UNIX, TOAD, SQL Navigator, MS Access, Microsoft Visual SourceSafe

Senior Consultant

Confidential

Responsibilities:

• Developed Packages/Stored Procedures/Functions/Database Triggers/Shell Scripts in a multi-tier environment
• Worked on Forms/Reports/SQL Loader
• Developed complex queries
• Worked with the client at all levels
• Perform Unit/Integration test/UAT - User Acceptance Test before moving the code to production
• Provided production support on call basis
• Provided Training to the users
• Developed interfaces to send account related information to SAP FI/CO
• ETL Processes
• Analysis/Design/Documentation of the systems
• Support/Modifications/Enhancements of the systems

Environment: ORACLE 9i/10g/11g, Developer 2000(Forms 6/6i, Reports 6/6i, Project Builder, Procedure Builder), C/Pro*C, SQL, PL/SQL, Windows 95/NT/XP, Sun Solaris UNIX, TOAD, SQL Navigator, MS Access, MS Project 98, Microsoft Visual SourceSafe, SAP

Sr. Analyst Programmer

Confidential

Responsibilities:

• Developed/modified Classification/Replenishment system project
• Developed Database Objects/Stored Procedures/Functions/Forms/Crystal Reports
• Created UNIX shell scripts
• Provided production support on call basis
• Ad-hoc queries

Environment: ORACLE 7.3/8i/9i, Developer 2000(Forms 6/6i Reports 6/6i, Project Builder, Procedure Builder), HTML, PERL, JAVA/JAVA Script, C/Pro*C, SQL Loader, Oracle Discoverer, SQL, PL/SQL, Windows 95/NT, Sun Solaris UNIX, SQL Navigator, Crystal Report 8.5, MS Access, MS Project 98, Reflection 2, Action Request System 4.0, Timbuktu Pro, Exceed

Analyst Programmer

Confidential

Responsibilities:

• Provided consulting services to renowned retail system Confidential Merchandising System which is developed under ORACLE using ORACLE development tools.

Environment: ORACLE 7.x/8, Developer 2000(Forms 4.5/5,Reports 2.5), SQL, PL/SQL, Pro* C, Windows 95/NT, Sun Solaris UNIX, Exceed, TOAD, PVCS, FTP