SUMMARY:

• Fifteen plus years of professional experience in Analysis, Design, Modeling, Development, Support and Implementation of applications in the client/server environment using Oracle 11i/11g/10g/9i/8i/8.0/7.x, Developer 2000, Designer 2000, SQL, PL/SQL, Forms 11g/10g/6i/6.0/4.5,3.0 Reports 10g/6i/6.0/2.5, SQR Reports, PRO*C.
• Extensive experience in PL/SQL Stored Procedures, Database Triggers, Toolbars, Performance Tuning and Batch Processing.
• Extensive knowledge of the Oracle architecture, Oracle Memory structures, Logical & Physical Structures, Data Dictionaries and with PL/SQL.
• Experience numerous Oracle implementations through full infrastructure and performance optimizations including I/O optimization, SQL Tuning and Backup and Recovery Planning, Testing and Implementation.
• Extensive experience in using Oracle Reports 6I & Forms 6I.
• Proficient in Installation, Setup, Configuration, Maintenance and Tuning of Oracle 8i /9i//11i/11g/8.0/7.x/ under UNIX (Sun Solaris 2.6, 7, 8) and Windows NT environment.
• Extensively worked in Oracle based application software Design, Development, and Implementation and application Maintenance.
• In - depth knowledge of SQL and PL/SQL, PRO*C.
• Proficient in developing PL/SQL packages, SSIS, stored procedures and triggers.
• Good knowledge and understanding of Data Warehousing.
• Worked on all phases of development lifecycle, from gathering requirements to testing, implementation, and support.
• Design and develop Oracle packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Created system for capturing, reporting, and correcting error data.

PROFESSIONAL EXPERIENCE:

Confidential, Houston TX

Information Delivery, Data Management and Production Support

Responsibilities:

• Provide full lifecycle support to clients from initial client interaction and requirements analysis through design, coding, testing, debugging, implementation and Provide ongoing application support and troubleshooting.
• Created template expense Auditing reports, enabled descriptive flex fields in the Excel spread sheets, customized documentation and messages by modifying the standard help files for the self-service expense module. Customized the Workflow process of expense reports by modifying existing procedures and developing new procedures in the Web Expense PL/SQL packages.
• Responsibilities included collecting user requirements, performing feasibility analysis, proposing functional and technical specifications, developing code per the specifications, doing code reviews, facilitate source code control.
• Developed Pl/Sql procedures & functions to support the reports by retrieving the data from the data warehousing application. Developed Actuate Reports and SQL Reports to fulfil the reporting needs of the users.
• Used XML, TXT to display the reports. Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Enforced database integrity using primary keys and foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations

Environment: ORACLE 10g, 11g, Reports, Oracle PL/SQL, SQL, TOAD, UNIX, HTML, Windows XP, SQL, SQL LOADER, batch process.

Confidential, Plano, TX

Senior Data Analyst and Developer and Production Support

Responsibilities:

• Open trouble tickets and view status; review details of past service issues and sign up to receive trouble ticket updates via email.
• Check account balance; view, download, and analyse bills and call detail reports. Pay bills online, update mailing address, or “go green” and sign up for paperless statements.
• Review accounts and manage user access: add users, reset passwords, change user IDs, and more.
• Email inquiries to XO Customer Care; browse or search the XO Knowledge Base (repair and troubleshooting information and FAQs).
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting using Parallel Queries.
• Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders maintenance requests, bug fixes, enhancements, data changes, etc.
• Used Toad to Extract and test the data in the database. Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for optimization.
• This system elimination of manual tracking of inventory and sales data. Preparing stored procedures, packages, functions and database triggers to implement required functionality and supports Seibel.

Environment: ORACLE 10g, 11g, Reports, Oracle PL/SQL, SQL, TOAD, UNIX, HTML, Windows XP, SQL, SQL LOADER, batch process.

Confidential, Atlanta, GA

Senior Data Analyst and Developer

Responsibilities:

• The primary purpose of eTally is to provide intraday sales data to enable managers to track the daily progress of sales towards attainment of sales targets for Southeast Region Consumer.
• MyIntraday will automate the gathering of intraday issued order sales for U-verse, Wireless, and DTV data, provide an interface for gathering manual order tallies for Wireline and DSL issued orders, and migrate in-scope eTally functionality.
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements
• Worked with various performance tuning techniques using tools provided by Oracle like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, HINTS, DBMS PROFILER etc.
• Designing the packages required in SSIS for loading the data in the Project.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling. Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Used Dynamic SQL (DBMS SQL, DBMS DDL) in function and procedure.
• Generate SQL Scripts and create views for reports.

Environment: Oracle 11i SQL/PLSQL, SSIS, Tools-Oracle developer, Toad, SQL Navigator, Windows NT.

Confidential, Bentonville, AR

Sr. Programmer Analyst

Responsibilities:

• Provided Production support and Troubleshooting.
• Efficient Oracle packages for data transfers between different layers.
• System for capturing, reporting, and correcting error data. Performance Tuning of Queries and Packages.
• Worked with various performance tuning techniques using tools provided by Oracle like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, HINTS, DBMS PROFILER etc.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

Environment: -Solaris 10, Oracle 11G SQL/PLSQL, SSIS,Tools-Oracle developer suite, Toad, SQL Navigator, Windows NT., Reports.

Confidential, St Louis, MO

Technical Lead, Developer

Responsibilities:

• Provided Customer support in code building, deployment. Requirement gathering for the requested change from customer.
• Analysis of the requirements. Design and develop Oracle forms/reports, Oracle packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Provide configurations changes to Oracle application server 10g.
• Build efficient Oracle packages for data transfers between different layers.
• Created system for capturing, reporting, and correcting error data. Performance Tuning of Queries and Packages.
• Worked with tuning of SSIS packages for better performance.
• Worked with various performance tuning techniques using tools provided by Oracle like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, HINTS, DBMS PROFILER etc.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

Environment: -Solaris 10, Oracle 10G SQL/PLSQL, SSIS,Tools-Oracle developer suite, MS-VSS, Toad, SQL Navigator, Windows NT., Oracle Reports/Forms.

Confidential, Austin, TX

Consultant

Responsibilities:

• Working on TIERS project which is a real-time system which helps DHS eligibility staff in delivering services and benefits for the needy people. The application is based on the SOA architecture for connecting to different systems.
• Created Partitions for large tables.
• Designed and developed complex PLSQL packages and SQL loader scripts that can load, process.
• Developed scripts using SQL loader to load data into tables.

Environment: ORACLE 10g,11g, Oracle PL/SQL,SQL, REPORTS 10g, SQL Navigator, UNIX, HTML, Windows XP, SQL, SQL LOADER, batch process.

Confidential, Woodland, TX

Senior Data Analyst and Developer

Responsibilities:

• Develop and maintain databases and data systems necessary for projects and department functions in conjunction with other team members.
• Analyse and problem solve issues with current and planned systems as they relate to the integration and management of clinical/financial data.
• Acquire and abstract primary or secondary data from existing internal or external data sources. Develop and implement data collection systems and other strategies that optimize data quality and completeness.
• Interpret data and develop recommendations based on findings. Monitor data dictionary statistics
• Create and present quality dashboards and ad hoc reports. Works under general supervision of Technical Lead on all phases of SDLC lifecycle on large Data centric implementation.
• Responsible for reviewing data accuracy, completeness and produce high quality software that fits business needs.
• Responsible for maintaining SQL standards and design documentation.

Environment: ORACLE 10g,11g, Reports, Oracle PL/SQL,SQL, REPORTS 10g, TOAD, UNIX, HTML, Windows XP, SQL, SQL LOADER, batch process.

Confidential, Saint Louis, MO

Technical Consultant and Developer

Responsibilities:

• Developing forms, reports for Order Entry sales system. This system automated sales and inventory functions. This system elimination of manual tracking of inventory and sales data. Preparing stored procedures, packages, functions and database triggers to implement required functionality.
• Developed REPORTS for vendor details, their contact details, and notes using REPORTS 6i /10g.
• Developed interface screens for data entry and data validations using FORMS 6i/10g.
• Developed REPORTS for transaction details, item details, stock availability and fast/slow/non-moving stocks using REPORTS 10g.

Environment: ORACLE 10g, ORACLE /9i/10g, PL/SQL, FORMS 11i/10g, REPORTS 10g, Discoverer Plus, Discoverer Viewer, SQL Navigator, HTML, Windows XP, SQL LOADER.

Confidential, Augusta, ME

Technical Consultant and Programmer/Developer

Responsibilities:

• Wrote and modified Oracle PL/SQL, SQL statements, stored procedures and functions
• Tuned the SQL using Explain Plan to increase performances of Reports.
• Used PL/SQL extensively to create extract from Data Warehouse for Down Stream System
• Used SQL-LOADER extensively to load data to small Data Mart
• Used SQL/TOAD to query complex relational databases and validate reporting results
• Fine-tuned PL/SQL Procedures for better performance
• Used the EXPLAIN PLAN to fine-tune the complex query.
• UNIX shell script to create environment variables and load data.
• Developed SQL*loader scripts to load the data from flat files to the Oracle Tables
• Extensively involved in Analysis, Design, Development and Testing.
• Modeling and Logical/Physical design of database schema.
• Used Reverse Engineering in ERWIN to identify the problems in previous data model.

Environment: ORACLE 10g/11g, PL/SQL, FORMS, REPORTS, SSIS, SQL Navigator, UNIX, HTML, Windows XP, SQL LOADER.

Confidential, Houston, TX

Technical Consultant and Developer

Responsibilities:

• Developing forms, reports for manufacturing, HR & Payroll, Order Entry sales system. This system automated sales and inventory functions. This system elimination of manual tracking of inventory and sales data. Preparing stored procedures, packages, functions and database triggers to implement required functionality.
• Redesigning existing Reports to Oracle Reports 10g
• Customizing different reports in GL, AR and AP such as Account Analysis Reports, as per user requirements.

Environment: ORACLE 10g, ORACLE /9i/10g, PL/SQL, FORMS 11i/10g, REPORTS 10g, Discoverer Plus, Discoverer Viewer, TOAD, UNIX, HTML, Windows XP, SQL LOADER

Confidential, Dallas, TX

Software Developer

Responsibilities:

• Developed and improved various key modules of the custom built Store Automation Project delivering measured improvements in efficiency and productivity in day to day operations in the areas of ordering, receiving, inventory, management, merchandise planning, POS Integration and Price management.
• Responsible for rescue maintenance as needed across a spectrum of store developed applications built on Oracle*Forms, Oracle*Reports, Oracle PL/SQL, and Oracle Pro*C.
• Worked in Retek Merchandising System (RMS) and modified vendors order receiving for the Store Automation Project. Application development in forms and reports using oracle 10g and converted oracle 9i to 10g.
• Complete programming and/or analysis and design assignments given by the customer for any effort associated with the Store Automation Project.
• Manage problem tickets assigned to my group and acted as the primary developer during a production crisis to manage other resources with resolving the issues reported.
• PL/SQL is used to process data input and output for the web based.
• Developed REPORTS for vendor details, their contact details, and notes using REPORTS 6i /10g. Developed interface screens for data entry and data validations using FORMS 6i/10g.
• Developed REPORTS for transaction details, item details, stock availability and fast/slow/non-moving stocks using REPORTS 6i. Designed and Developed user interface screens using FORMS.
• Designed and implemented several REPORTS for invoice, purchase order, stock levels and inventory accounting using REPORTS. Created stored procedures, functions and triggers using PL/SQL, TOAD.
• Expert skills in using TOAD, Explain Plan, TKPROF for Performance & Tuning.
• Experience in using various PL/SQL features of Table Functions, PL/SQL Tables, VArrays, Partitioned Tables, REF Cursors in the Development of Stored Procedures.
• Worked on Business Intelligence tools like Business Objects and Crystal Reports.
• Data modeling experience in Entity-Relationship Model, Dimensional Data Model, Fact and Dimensions tables, Conceptual, Logical and Physical data modeling.
• Developed user-interface screens for data transactions using FORMS. Implemented FORMS involving master/detail relationship between the blocks.

Confidential, Redmond, WA

Sr. Programmer

Responsibilities:

• Responsible for CDRlive, this product is designed to capture and analyse the call details.
• Analysed using CDRlive for MSC performance, route optimization, subscriber usage performance, handset usage performance, cell site, traffic usage performance, Inter - network roaming, call failure analysis and market information. Analysis/design custom reports requests from customers using SQL & PL/SQL. Developed user-interface screens for data transactions using FORMS 6i.
• Designed and implemented several REPORTS for invoice, purchase order and inventory accounting using REPORTS 6i.
• Designed the database architecture using ERwin (Entity-Relationship tool for Windows)
• Developed reports using SQL, PL/SQL, TOAD and Business Objects for Confidential network and Cingular network to capture the roamers who came into the market. Traffic growth analysis and planning.
• Identified and analysed worst performing areas in the network and subscriber issues and experience. Effectively communicate network/handset issues to engineer and customer support.
• Worked with JAVA developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Confidential, Arlington, VA

Applications Developer/ Software Engineer

Responsibilities:

• Responsible for the analysis, design and development Radio Station Information, application development in forms and reports using oracle 8i,TOAD, PL/SQL,SQL for Arbitron Washington/Baltimore.
• The software changes to expedite program crediting in diary processing. The program numbering and reaccrediting is primarily performed in the market analysis.

Confidential, Minneapolis, MN

Applications Developer / Performance Engineer

Responsibilities:

• Responsible for Retek Merchandising System (RMS) performance testing, functional areas under various data volumes for RMS 11.0.x. fully familiar RMS Functional areas including scenarios with new product transformation and testing modules. All tests performed in Retek’s Performance Lab in Minneapolis, Minnesota.
• Significant performance tuning (i.e., code enhancements, recapturing code, SQL tuning, table partitioning and indexing) for all areas tested for the RMS. Wrote stored procedures, packages, functions and database triggers to implement required functionality, and also performed unit testing and system integration.
• Tuned PL/ SQL procedures and function for better performance results. Participated in testing and troubleshooting of the applications.
• Designed required views and SQL statements to access data in an efficient way. Designed and developed various Reports and complex forms. Designed and developed primary database objects (tables, views, indexes). Designing of the Logical and Physical Database Objects using ERWIN.

Confidential, Baton Rouge, LA

Information Technology Applications Programmer/Analyst 1

Responsibilities:

• Responsible for users need reports, programming, analysis, designs and tests.
• Designed, developed and implemented various applications using MS-SQL and Web FOCUS.
• Created Stored Procedures, Views and Database Triggers using SQL & PL/SQL, TOAD. Developed PL/SQL Procedures for Advanced Targeting Tool.
• Developed complex queries to extract and manipulate data. Performed query analysis and enhanced Query performance by taking advantage of Oracles indexing features and table partitioning features. Fully familiar with unemployment Insurance operations and needs, worked closely with users divisions in the areas of Policy services, claims delivering the information on schedule by creating either new or modifying the existing reports using COBOL, MS-SQL, SQL, JCL, TSO, DB2, Excel. Enhanced and modified database packages and stored procedures, functions and triggers, to ensure compliance with business specifications.
• Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.
• Migrated a VB6 imaging application to ASP.NET (VB.NET). Volunteered to write a web application (VB.Net) to allow users to change their Oracle passwords from the intranet.

Confidential, Baton Rouge, LA

Associate Software Engineer

Responsibilities:

• Responsible for the analysis, design and development needs of the company’s underwriting sub system and goldmine sub system using Oracle, SQR and HTML, PRO*C.
• Designed, developed and implemented the underwriting sub system that supported the functional areas of policy creation, invoicing, payment processing, cancellations, reinstatements, etc. The sub system is integrated with quotes, claims, and audit management sub systems of the Lagniappe. The entire system is web enabled and accessible to policy holders nationwide. Designing of the Logical and Physical Database Objects using ERWIN.
• Familiar with Workers Compensation Insurance operations and needs, worked closely with the Quality Assurance and End User Divisions in the areas of Policy Holders Services, Audits, Claims and Collections delivering the information sought on schedule by creating either new or modifying the existing Oracle Forms, Oracle Reports, SQL Reports, Structured Query Reports (SQR's) using Oracle 8.x, 9i, Oracle Discoverer, Oracle Forms & Reports 6i and SQR 4.3.5 respectively. Converted Oracle Forms and Reports from Versions 4.5 and 2.5 to Oracle Forms and Reports Versions 6i. Designed ODBC connection to Oracle 8.x.
• Created PL/SQL scripts to convert Oracle Database Tables to Powercomp System (Power Builder dependent) usable Database Tables to enable the implementation of a New Powercomp System for the policyholder Services in the areas of Audits, Collections and Documents. Application development in forms and reports using oracle 8i and Oracle Discoverer.
• Responsible for the timely conversion, testing and implementation of the existing Oracle Forms and Reports from 4.5 and 2.5 to Oracle forms and Reports 6i. Converted Oracle Database Tables to Powercomp System Usable Database Tables. Responsible for the timely generation, testing and implementation of PL/SQL script for conversion and testing of various Policy Holder Services documents and Audit functional tables from the existing data base to Powercomp database. Created new SQR reports as well as converted some existing reports in close discussions with the Data Users and Quality Assurance Divisions to generate valuable reports for Policy Holder Services using the Powercomp database.
• Designed and developed a fully data driven system with menus created dynamically from the database. Worked with Business Analysts to help define and set overall project development priorities.
• Designed required views and SQL statements to access data in an efficient way. Designed and developed over 70 forms using Oracle Forms Builder and Designer.
• Developed over 50 reports using Oracle Reports Builder. Developed a customized data access toolbar which appears on all the forms making data access easier.
• Identify various types of external data sources, decoding, migrating data to newly designed Oracle RDBMS tables after solving bad data errors.
• Developed a script to load data from external sources using SQL*Loader. Developed script for weekly database backup, as well as for forms and reports. Created data flow diagrams in MS Visio.