SELECTED ACCOMPLISHMENTS

• As business analyst, created, maintained, and updated deliverables through facilitating input from business and technical stakeholders in which the deliverables included, business requirements, functional requirements, technical requirements, use cases, technical design documentation of current and future state processes which allowed the business to enhance existing trading and invoicing application on time and within budget, saving the business about 500,000.00 in cost overruns and improving application performance by 95 .

• Created clear and complete documented defect reports for anomalies found during test procedures and issues were resolved based on priority/severity,cuttingdeployment time by almost 80 .
• Performed business process and reporting improvements necessary to establish a platform for growth by reducing human error by 97 , thus, saving the client over 1.5 million a year.
• Provided support to business users on how to auto generate invoices,hence, improving operational efficiencies by almost 97 .
• As business consultant, implemented Endur Back Office Desktop for Confirmations, Settlements and Accounting, as compared to the legacy system allowing the client to realize over 4.8 million in costs reduction over a period of three years, improving productivity by 85 and 65 savings in time and effort.
• Lead DBA and as Team Lead for Oracle 9iRAC installation on windows 2003 servers in support of the HQDA-TS application webification effort, which provided 99.9 uptime of this application.
• Performed Oracle Partitioning, Advance Queuing and Index-Only Tables to enhance performance and to reduce bottlenecks on data entry as well as retrieval, thus, improving work productivity by over 95 in two years.

SKILLS ABILITIES

PROFESSIONAL EXPERIENCE

Business Analyst,

Confidential

Responsibilities Accomplishments

• Responsible for interacting with internal customers to effectively handle, log and communicate incidents and problems by leveraging technology and business skills to identify and solve problems quickly.
• Worked with settlement accounting group to quickly generate AR invoices, allowing business to collect 90 of monthly sales revenues efficiently and on time.
• Provided technical assistance in identifying, evaluating, and developing system requirements and procedures but not exclusively limited to the requirements associated with the Accounting and Settlements modules of Endur trading system.
• Created, maintained, and updated deliverables through facilitating input from business and technical stakeholders.
• The Deliverables included, business requirements, functional requirements, technical requirements, use cases, technical design documentation of current and future state processes which allows the business to enhance existing trading and invoicing application on time and within budget, saving the business about 500,000.00 in cost overruns and improving application performance by 95 .
• Prepared and delivered month end accounting reports, recommendations, or alternatives that address existing and potential problem areas across the business.
• Responsible for producing well-structured, documented and maintainable test scenarios and/or scripts and identifying associated expected results for manual testing.
• Responsible for maintenance of the test cases and scripts. Test cases need to support validation of business requirements and/or any design specific functionality.
• Responsible for test case creation to include but not limited to positive and negative testing scenarios as well as security and/or access testing.
• Prepared Test Case design, monitor and perform Quality Assurance QA testing to ensure accuracy, quality and stability while maximizing system performance and scalability.

Sr.Consultant Business Analyst,

Confidential

Responsibilities Accomplishments:

• Provided support to appropriately search and associate Counterparties to Brokers Exchange of Future for Swap EFS transactions confirmed through ICE eConfirm and CME Clearport website for Gas and Powertrades allowing the organization to meet its reporting deadline established by the Commodity and Futures Trade Commission CFTC .

• Provided support to facilitate requirements gathering workshops for the design of Position Limits Reporting PLR .
• Prepared detailed report in Gaps analysis between application and businessin fulfillment of DF rule making areas.
• Performed key administrative activities including, workshop notes from Natural gas SENA ,and Refined Products STUSCO and Crude STUSCO meetings with Shell Trading North America STNA team to be disseminated to business stakeholders.
• Created final functional design report document for Large Swaps Trader Reporting LTR and Position Limits Reporting PLR allowing the organization to comply with DF act by almost 85 .

Business Consultant/QA,

Confidential

• As Back Office consultant, involved in the implementation of Endur Back Office Desktop for Confirmations, Settlements and Accounting Modules.
• Interacted with back office and risk group to gather and document business requirements
• Designed, configured, tested and trained the users on how to use the system effectively, reducing data entry errors by over 95 .
• Provided the ability for NG Physical and Derivatives and NGL derivatives trading group to capture and manage physical and financial deals in a single place.
• Provided the ability for the Back Office group to invoice transactions based on the entire contract. This solution gave the NG Physical and Derivatives and NGL derivatives Settlements and Confirmations groups the ability to more easily manage transactions and their values in a single place improving productivity by 85 and 65 savings in time and effort as compared to the legacy system allowing the client to realize over 4.8 million in costs over a period of three years.
• Provided technical assistance in identifying, evaluating, and developing system requirements and procedures
• Designed test cases, monitor and perform Quality Assurance QA testing to ensure accuracy, quality and stability while maximizing system performance and scalability.
• Responsible for producing well-structured, documented and maintainable test scenarios and/or scripts and identifying associated expected results for manual testing.

Confidential

• As Back Office consultant, responsibled in the implementation of Endur Back Office Desktop for Settlements and Confirmations modules.
• Designed and configured the system for the Physical and Derivatives Trading analysts to capture and manage physical and financial trades in a single place.
• Interacted with back office and risk group to gather and document business requirements
• Designed, configured, tested and trained the users on how to use the system effectively, reducing data entry errors by over 95 .
• Provided the ability for the Back Office group to partially invoice based on delivery tickets as opposed to entire contract. This solution gave the Physical and Derivatives Back Office groups the ability to more easily manage physical and financial deals and their values in a single place reducing task time and effort with higher productivity and reduction in human error by 97 saving the client over 2.5 million a year.
• Provided technical assistance in identifying, evaluating, and developing system requirements and procedures
• Designed test cases, monitor and perform Quality Assurance QA testing to ensure accuracy, quality and stability while maximizing system performance and scalability.
• Responsible for producing well-structured, documented and maintainable test scenarios and/or scripts and identifying associated expected results for manual testing.

Confidential

• As Back Office consultant, responsibled in the implementation of the Endur Coal Scheduling Module - cMotion.
• Designed and configured the system for the Coal Trading group to capture and manage transportation deals in a single place.
• Interacted with back office and risk group to gather and document business requirements
• Designed, configured, tested and trained the users on how to use the system effectively, reducing data entry errors by over 95 .
• Provided the capability for the Accounting group to partially invoice based on delivery tickets as opposed to entire contract. This solution gave the Coal Trading group the ability to more easily manage physical deals and their values in a single place improving position management, risk control and operations, saving the client over 2 million a year.
• Provided technical assistance in identifying, evaluating, and developing system requirements and procedures
• Designed test cases, monitor and perform Quality Assurance QA testing to ensure accuracy, quality and stability while maximizing system performance and scalability.
• Responsible for producing well-structured, documented and maintainable test scenarios and/or scripts and identifying associated expected results for manual testing.

Confidential

Responsibilities Accomplishments:

As a part of Phase III, there was a need to bring on an additional resource to assist in the development of the ODS in order to build out the Profit Loss P L Explained Report and provide assistance on the other set of credit reports.

Duties Included but not limited to the following:

• Responsible for the design, build, and implementation of the Energy Trading Risk Management ETRM Operational Data Store ODS at British Gas BG LNG which involved writing PL/SQL stored Procedures that interfaced with Nucleus database to migrate real-time energy trading data into an Operational Data Store ODS running on Oracle9i improving productivity by 80 and reporting by 65 .
• Responsible for loading consolidated and cleaned-up Transaction and Master Data into ODS.
• Built complete Data Model, Identify type of other Data sources, Connectivity/ETL, Data Targets, and Reporting Objects.
• Identified the extractors on the R/3 OLTP systems and defined the Transfer structures on the source and target systems.
• Performed application design activities, e.g., writing functional designs, documenting business requirements, assisting in conducting gap analysis between business requirements and software, and creating functional requirements as an input to application design.
• Analyzed business-reporting requirements that could be satisfied by Business Content InfoCubes.

Senior Systems Architect Confidential

Responsibilities Accomplishments:

Managed the analysis, design, development, test, deployment and maintenance of a Document Correspondence Database for the United States Department of Defense at the Pentagon. This involved Data Modeling techniques using Army Standards, and Metadata Management. In addition, provided thought leadership and content development engagements, to include development of database strategy, and solutions blueprints. Oversaw Headquarter Department of the Army Tracking System HQDA TS project portfolio to ensure timely delivery, and overall end-user satisfaction Lead project risk assessments, provide assurance and direction to project steering committee Developed project key metrics, identified and managed project dependencies, and ensured conformance to SDLC and CobIT frameworks. Other responsibilities included providing technical leadership and professional coaching to junior developers and interns.

Duties included the following:

• Technical team lead performing information system audits, analysis of general IT processes and controls, which includes planning and development for audit testing and evaluation, validation, quality assurance, accreditation, and acceptance.
• Evaluated and tested the internal controls of system governance using CobIT framework.
• Responsible for data integrity, quality assurance and data definition, consistent with Army's data definition and security standard.
• Responsible for assuring Y2K data compliance in the Oracle Forms and Reports for the HQDA-TS by identifying and modifying PL/SQL codes and security vulnerabilities that are not consistent with Y2K bug fixes.
• Development and deployment of Web version of HQDA-TS Database technology infrastructure and applications improving ease of use by 93 .
• Installed and configured Oracle8.0.4.3 on I70 HP-UX v11.0 to be used as test bed for Y2K compliance test. In addition, IT infrastructure audits using the CobIT Framework, including vulnerability assessments methodology, Intrusion Detection System, firewalls, and encryption.
• Lead DBA and Team Lead for Oracle 9iRAC installation on windows 2003 servers in support of the HQDA-TS application webification effort, which provided 99.9 uptime of this application.
• Performed Oracle Partitioning, Advance Queuing and Index-Only Tables to enhance performance and to reduce bottlenecks on data entry as well as retrieval, thus, improving work productivity by over 95 in two years.
• Developed batch programs using PL/SQL as well as ORACLE packages to load data into the database.
• Changed existing PL/SQL programs and developed new programs to reflect new business rules.
• Prepared training documents, database design, technical documents, and mentoring team members.
• Gathered customer requirements and created design documents.