SUMMARY:

• 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, cutting deployment 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.
• Strong Business Process Re-engineering
• Extensive knowledge in SQL scripting
• Skilled in Confidential Endur Implementations of Trading systems and good understanding of trading lifecycle.
• Strong business requirement gathering and documentation knowledge.
• Strong Data Modeling knowledge utilizing IDEF1x and IDEF1o methodologies.
• Strong interpersonal skills working with business and IT department.
• Extensive knowledge in vendor package demo and selection process for clients.
• Strong QA/UAT design, testing and documentation
• Extensive knowledge in Crude, Confidential, NGL and Coal Trading and logistics utilizing various mechanisms
• Excellent verbal and written communication skills and a ‘Can Do’ attitude.
• Strong analytical and problem solving skills
• Extensive knowledge in Change Management.
• Extensive knowledge of Microsoft Word, Excel, PowerPoint, Visio, Project and Publisher.
• Skilled in Erwin data modeling tool, TOAD, SQLPLUS, CASE and ITIL methodologies.
• Familiarity with Allegro Trading system
• Strong knowledge of Test Track and Service Now for QA and Change Management documentation respectively.
• Product selection process through Request for Information (RFI) or Request for Proposal (RFP) from clients.
• Extensive knowledge in Configuration Management.
• Very detailed oriented.
• Very knowledgeable in Oracle RDBMS and interfaces to SAP and Oracle G/L.
• Knowledgeable in conducting and documenting business and Application fit gap analysis.

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential, Houston, TX

Responsibilities:

• 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, Houston, TX

Responsibilities:

• Provided support to facilitate requirements gathering workshops for the design of Position Limits Reporting (PLR).
• Prepared detailed report in Gaps analysis between application and business in fulfillment of DF rule making areas.
• 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, Houston, TX

Responsibilities:

• 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 Confidential Physical and Derivatives and NGL derivatives trading group to capture and manage physical and Confidential 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 Confidential 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.
• Designed and configured the system for the Physical and Derivatives Trading analysts to capture and manage physical and Confidential 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 Confidential 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.
• 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.

Consultant

Confidential, Houston, TX

Responsibilities:

• 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, Reston, VA

Responsibilities:

• 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 documents, database design, technical documents, and mentoring team members.
• Gathered customer requirements and created design documents.