SUMMARY

• My experience includes significant involvement in Programming in Oracle, C, C++. Among my proficiencies are System Programming in UNIX (Sun Solaris)/AIX and scripting using Korn and Bash shell. Excellent communication and analytical skills, team player and self - motivated.

PROFESSIONAL EXPERIENCE

Confidential

Analyst/Lead Developer

Responsibilities:

• Meet business team members to understand their requirements.
• Participate in peer reviews and software developments, analyze functional and technical requirements.
• Create Autosys Jobs to initiate Stored Procedures to move data from Landing to Staging.
• Write complex strategy in PL/SQL to move data from Landing to Staging.
• Use PL/SQL to create and modify code.
• Monitor performance and make recommendations for tuning code.
• Figure out issues, if these jobs run into any issue.
• Wrote SQL queries to retrieve information from database and analyze the data.
• Facilitate team members if some complex situation arrives.
• Work in Agile environment.
• Perform analysis and provide data for testing and document for proof.

Confidential

Team Lead/Analyst

Responsibilities:

• Lead multiple projects and mentor team to the completion of projects.
• Analyzed functional and technical requirements for the project to accomplish the task.
• Participates in systems requirement and reviews with customers to understand requirements.
• Prepared specifications, required for programming changes like structures, input/output, functional and business requirements.
• As a lead proposed alternative approaches of the current system.
• Involved in the Software Development Life Cycle.
• Written new code to compare and sync two environments tables data, using oracle function.
• Design consumer and business bundles model to improve current system to a very efficient and improved Bundle model.
• Written an in-house tool to sync two environments, which will automatically identify the out of sync data and sync it.
• Design new improved schema to implement quick turnaround for new promotions and offers.
• Improve Ordering system performance by writing complex XMLs using PL/SQL using TOAD.
• Written many different PL/SQL Packages with very complex logic required by the ordering systems to cater their requirements in a very efficient way. In other words the turnaround time has to be sub second.
• Convert many complex data requirements from front end to provide the tabular data into XML which saves them lots of time from converting this data into XMLs.
• Automate whole manual Products transfer process using PL/SQL and UNIX shell scripts using Korn Shell.
• Written database Table Comparison Tool using Excel VBA. It compares the rows of two tables and highlights the differences. Makes is easier for user to pinpoint the differences.
• Written Automated Excel reports using VBA and PL/SQL, depicting sales trends for Directors.
• This report has used all the Data Warehouse concepts like Data Source, Staging, Summary Data, and Dimensions Tables Fact Tables etc.
• Written Adapters and Services in Java.
• Analysis of current residential provisioning system.
• Propose different ways to improve their current system.
• Written new PL/SQL and Pro*C code for Oracle 9i/10g/11g to handle all the provisioning requests for small business as well as residential customers (VIPR), which are being called by EJBs and COM components.
• Fine tune slow running queries.
• For ESP project wrote Java EJB services and adapter Beans for a new Web Enable services to communicate with the databases.
• Designed a new Database instance VIPR using ERWIN.
• Installing and configuring Informatica client. Writing new transformations to move data from three different Oracle instances.

Confidential

Analyst/Developer

Responsibilities:

• Get the logic that needed to be implemented.
• Analyze their code and look for bugs and identify slow running queries.
• Apply correct logic and performance improvement techniques.
• Their code starts to perform much better and correct result.

Confidential

Analyst/Developer

Responsibilities:

• Analyze Confidential environment and propose suggestions to improve their overall performance.
• Propose ways to improve their business logic implementations.
• Pin points their bottlenecks in their daily processes.
• Design a whole new process to replace AS/400. This consist of new improved user friendly front end with better and faster back end which consist of COM components, Pro*C and PL/SQL using Oracle 8i.
• Design a new Bin Label printing process using Visual Basic, which handles new promotions for over 650 stores.
• Use ORACLE TUNING techniques to improve the performance of existing code up to 2000%.
• Alter existing Oracle Forms fix business rules and improve performance.
• Fix business rules and efficiency of codes written in Pro*C.
• Written code in Visual Basic to reroute files created on a PC to a UNIX and AS/400 machines.

Confidential

Analyst/Team Lead

Responsibilities:

• Using Oracle Financial (AR), automate entire Invoice Generation process. Using PL/SQL, SQL*Plus, Pro*C and UNIX shell.
• Analyzed the current PL/SQL code for Invoice Billing System.
• Debugged and stabilized the current code.
• Written new invoice generation code in PL/SQL.
• Written new verification reports in SQL*PLUS for these new invoices.
• Analyzed the whole environment and laying out plan to improve the performance of Invoice Billing System.
• Performance analysis included rewriting entire existing code in Pro*C.
• Analyzed the effects and how to automate the whole Cycle Billing environment in Oracle Financial (AR).
• Automate the generation of control reports via Oracle Financial, before and after Cycle Billing for verification purposes.
• Running the current applications in Oracle Financial (AR).