Software Professional with ** years experience in Unix /web/database application, client-server- browser-based application environment, this include Six years of extensive knowledge of Energy Trade and Risk Management (ETRM) applications such as Openlink Endur, Allegro NG-which include Gas Nomination, Gas scheduling, Gas settlements, Customer Balancing and Volume Management.
Has unique knowledge of the Commodities markets from a combination of IT, compliance and legal perspective. Has a strong understanding of wholesale, markets sales and trading issues from technology, business and compliance perspective.
SUMMARY
Experienced Business/QA analyst in energy trading (Merrill Lynch Bank of America, Repsol, DTE Energy, British Petroleum, and Shell Trading)
Extensive experience in Commodity, Crude, Gas, physical and financial trading environment
Optimizing and maintaining a build process as part of an overall software configuration management scheme.
Experience in managing implementation of trading systems, leading a straight-through processing project and working in client/server computing and multi-location environments as an analyst/team coordinator
Provide analysis and insight on better utilization of the Allegro (Version8.0)
Analyze new functionality in Allegro and Endur to guide developers in reaching solutions to functional issues
Provide analysis and insight on better utilization of the OpenLink Endur product
Analyze functional specifications to develop technical design documents
Expert in Agile and Waterfall project management methodologies
Excellent knowledge of Agile & Scrum development environment, multiple web browsers, and automated testing suites
Provide technical support to users of testing methodologies mainly on an enterprise level.
Experience in supporting Openlink's Endur application (version 8.2)
Designing, developing and implementing manual and automated test for Functional, Integration, and Regression testing.
Involvement in project request and Analysis Phases.
Working knowledge of Software Development Life Cycle (SDLC) Methodology.
Creating and defining software testing architecture, which includes the key technical decisions that constrains the overall design and implementation for a project
Facilitating formal reviews and inspections, and ensuring that they occurred when required and are conducted to a satisfactory standards
Great interpersonal skills and the ability to deal with all levels of business users and management.
Very good Analytical skills, which have been demonstrated in a business environment.
Establishing standards for test documentation and test progress reporting.
Participating in project-wide review of requirements, system architecture, and detailed design documents.
Responsible for evaluating project planning and project assessment artifacts at major review points in the testing Lifecycle.
Effectively participated in estimation, planning, cost-of-quality and quality risk analysis.
Managing file movement in the development and maintenance life cycle including the movement of files from one testing environment to another.
Strong team player that interacts effectively with technical and non-technical members of an organization
Proactive, strategic thinker with strong analytical skills
Stung communication skills, decision maker with demonstrated leadership, detailed oriented with an ability to work well in a fast-paced environment.
Performing end user training during and after deployment.
Experience in Quality Assurance practices and procedures
Experience in systems specifications analysis, testing methodology and test plan
Experience in functional testing techniques including system, acceptance and regression testing
Experience with automated test tools for functional and performance testing
Competent knowledge of software development lifecycles and how they pertain to test practices and Quality Assurance
Experience with defining and documenting test plans, test cases, test scenarios and test results
TECHNICAL SKILLS
O/S: Windows 7, MAC 7.X, 8.X, Sun Solaris, MAINFRAME, AS/400, DBU 6.0, 7.0, Linux, Novell for Win2K
Software: MS-Office, MS-Project, MS- Visio, Lotus applications, TortoiseSVN
Database: SQL Server 2000, 2003 and 2005 Oracle, MS Access. DB2, Teradata
Test tools: Quality Center 11.0, WinRunner 7.5 with Terminal Emulator Add-in, Quick TestPro 11.0, Rational TestManager, IBM Requisite Pro, and Rational Clearquest
PM Tools: Primavera P3e, P5, P6, MS-Office, MS-Project, MS- Visio.
Trading Commodities Tools: Openlink Endur 8x, Allegro 8.0, Aries, SolArc Right Angle, Discovery, JDE, Business Objects, Crystal Reports
Professional Experience
Stewart Lender Services, Houston, TX March 2015 to Present
System Analyst
Assist management with testing schedule and software releases
Create a product roadmap for the various stages and releases throughout the project lifecycle
Conduct sessions with the stakeholders and end users to determine the critical business processes and identify key functional requirements for the application system
Develop test plans and detailed functional and usability test cases (manual), test scenarios, testing environments
Responsible for running test validations, developing testing plans, and estimating project resource
Work independently and as part of a cross functional team that creates, reviews, and executes test procedure
Perform regression testing to ensure all reported defects have been resolved
Participate from the early stages of software development and collaborate with other teams regularly through all stages of the project life cycle
Draft and revise test plans and scripts, execute test scripts according to application requirements documentation
Responsible for test planning, creating test scenarios, writing test cases/scripts for manual testing
Review and sign-off on all release documentation
Perform regression testing on bug fixes associated to subsystem
Engage in SDLC from Business Requirements Analysis to Development, Testing, Deployment, Documentation and Support
Create new scripts when necessary and modify existing test scripts for the application change
Work in the Agile/Scrum development environment with frequently changing requirements and features set
Participate in Sprint stand up and daily scrum meetings to discuss multiple application software
Interact with Business Analysts and Software Developers for bug reviews and participate in QA meetings
Actively participate in daily Scrum meetings and reviews
Perform tests on various features of Agile development process
Responsible for developing functional testing via automation scripts and conducting defect root cause analysis
Manage testing tools and execute tests on automated scripts
Responsible for Database testing using SQL queries in MS SQL Server
Utilize SQL queries to verify data on the front-end application against the back-end database
Merrill Lynch, Houston, TX March 2O11 – February 2015
Senior BA/QA Analyst
Project: Onboarding of new desks and products, monthly releases, application enhancements and creation of testing processes.
Responsible for testing onboarding of new trade desks in Europe, Asia, Singapore, and the United States
Implement QA Standards for all workstream to follow when creating Test Script and Test Scenarios
Collect data from end-users and stakeholders; interpret data to write and review requirements, including conducting requirement workshops
Create Requirement documents for New Business
Gather and analyze data and technical requirements for new implementation as well as troubleshoot for existing software
Responsible for creating test cases from Use cases. Also responsible for working with senior management to schedule and plan Quality Assurance
Create design and specification document for new desks
Facilitate testing per project needs including identifying risks involved with requirement changes, working closely with end-users to understand scope of change, identifying requirements versus implementation changes, and updating pertinent details during scrum meetings, with iterations lasting 2 weeks, using Agile methodology
Utilize Waterfall methodology per project needs from requirement gathering phase, interacting closely with development team during design phase, integration testing, UAT and production release and maintenance
Ensure all stakeholders sign-off requirement document before proceeding with the project design phase
Cross reference requirements with project definition to ensure no mismatch; manage requirements throughout project life
Develop strategic plans for different test cycles
Advice the Client on innovative testing products and solution
Define and administer standard testing architecture methodologies, processes, and tools across the engagement
Define entry and exit criteria for each test cycle
Create test estimates and define/build reusable testing for the Project
Define Test metrics and reporting to measure and control progress and quality of testing activities (from preparation to execution quality)
Work closely with Dev, PM, and Stakeholders to drive project deliverables
Manage off-shore automation team of 4 including identifying test cases needed, automation regression test suites, daily status calls, documentation of issue deliverables, and utilizing one single platform via sharepoint to keep information centered
Assist offshore team to adapt an issue management process and facilitate issues resolution in a timely fashion
Responsible for creation of Automation regression manual test cases
Support and drive automation within project
Decrease automation script run
Oversee the implementation of a version control for automation scripts
Responsible for management of +3000 test data
Coordinate with Dev team on management of automation, SIT and UAT test environments
Execute, modify and update automation scripts in QTP
Create automation testing user guide for reference
Create and execute manual and automated tests for multiple software builds within scheduled releases
Ensure all Test cases identified for each test cycle are correctly documented, have been executed and appropriate defects raised
Ensure there is a documented business workarounds for any open defects which remain in each test cycle
Co-ordinate all UAT sessions, User workshops, and System training with support teams as well as with end users
Provide meaningful metrics, analyze trends to upper management
Partner with IT and business support group peers to identify and resolve issues
Document, review and certify defects, tests and requirements in HP Quality Center
Ensure a measureable reductions in Test Cycle durations
Delivery of meaningful and timely user testing
Centralized SIT and UAT Management
Creation of QA Gateways for BA/Dev/Test/Release
Responsible for creating common set of Testing terms across BA/QA/PM/Dev
Developed Training Materials on Quality Center 10.0 and trained different workstream on how to use the tool
Responsible for setting up access for end users in the SIT and UAT environments, including appropriate trader/marketer privileges and/or limitations
Project: Implementing additional Dodd Frank Reporting Changes.
Responsible for managing additional Dodd Frank reporting requirements for Canada and US
Assess and analyze project requirements with reference to identifying the need for diverse resources
Manage scope and schedule for entire project and across multiple disciplines with completion of project on time
Exemplify multitasking skills in performing diverse tasks, including schedule development, analysis, cost control, requirement gathering, test plan and test case creation, testing and defect reporting and management, resource leveling and analysis
Collaborate between business and development team throughout project span
Maintain compliance with Dodd Frank Reporting rules and regulations as applicable to region, including federal and state regulations through development and implementation
Provide technical support and quality control from development to implementation, to production release
Manage end user expectation by providing detailed testing and resolution of all issues prior to production release. Act on client feedback
Provide hands-on training for Front Office, Mid Office, Trade Control and Operations Management team, including creating users manuals for reference
Provide post-release support across all disciplines
Project: Implement Dodd Frank Real Time Reporting
Create SIT and UAT Test Plan, Test Scenarios, Use Cases and Test Cases for all applicable applications for Front, Mid, Trade Control, and Back office
Identify areas to be scoped for Financial and Physical Natural Gas, Coal and Dry Freight, Power, as well as Crude and Refined Products
Translate high level business requirement into functional specifications for the organization
Work closely with project manager to meet deadlines related to testing and release schedules
Assist in the business process designs and documentation
Execute manual test cases, including all down-streams for all Dodd Frank RTR events
Manage/update daily testing results and system defects with emphasis to a complete list of High, Critical and Blockers
Identify and execute all levels of relevant testing including unit, system, integration, regression, and user acceptance
Update management with daily testing results using traceability matrix
Coordinate user acceptance testing, provide users with test cases, and update/track defects appropriately
Ensure successful releases to Production with no break to current system functionality
Create Dodd Frank events user-guide for relevant systems for user referencing
Monitor/provide end-user support post-release for new business processes
Project: Moved from current process of posting 2400+ GL accounting transaction information once a month from SolArc to JDE to producing a Daily Balance
Test that gross level accounting data posts to JDE on a daily basis for the Crude desk
Ensure all source systems feed accounting data to a repository which in turn feeds the downstream systems and ensure reconciliation with PnL
Ensure all Inventory adjustment entries are reversed for prior business day and replaced with current close of business posting
Validate data sent from SolArc exclude invalid accounts, or data missing account coding
Test new fields within repository populate correctly with data sent from SolArc
Ensure all accounting data excludes settlement entries for daily posts
Create EOD daily report at a trade level within SolArc to compare the snapshots used for U.K vs. U.S
Work with BA, Data Repository Team, SolArc team, JDE team, and End Users (accounting)
Test and reconcile Data reported from SolArc Right Angle to JDE after code changes were completed
Ensure DBS project released into production after successful execution of unit testing, regression testing, and performance testing
Project: Migration of Precious Metals to Openlink Endur Metals Instance
Lead the test strategy and high level deployment plan development for involving the migration of precious metals to Openlink Endur
Use the Openlink Commodities infrastructure, front to back
Migrate all necessary data from the current platform to Openlink Endur
Perform Trade entry, amendments, confirmations, reconciliations, allocations, accruals, invoicing and Cash/Physical settlement and brokerage settlement via Openlink Endur
Define the Project Testing approach cycles as well as the high level deployment plan
Develop strategic plans for different test cycles
Assist with data conversion experience to make sure there is accurate data for every test cycles
Define Testing resource allocation and manage the project testing team
Implement and managed the defect tracking process on the project
Work with Development team to facilitate all severity1 defects fixes
Derive business processes, elicit and analyze user and organizational needs
Repsol YPF, The WoodLands, TX June 2010 - January 2011
BA/QA Analyst
Responsible for regression testing Allegro 8.0 for front-office, mid-office, and back-office
Gather functional requirements from end-users, and translate into Use Cases
Create Test Cases for Trade booking, Trade amendments, Pipelines, Scheduling, Transportation, Accounting, Settlements
Test all new Allegro Maintenance Releases (MR) in various cycles within Quality Center
Validate both NG and LNG transactions on physical, financial, and transport transactions
Expertise in physical and financial Energy trading
Develop close working relationships with Energy Trading groups (i.e. Traders, Schedulers, etc.)
Provide workshop for Schedulers on Allegro Natural Gas pathing and scheduling
Strategize and recommend a solution business process for Allegro 8.0
Work with project manager to estimate effort and create a testing plan
Develop test plan and test cases to ensure testing strategy adequately test all relevant parts of the Allegro 8.0
Provide functional leadership, including monitoring and reporting ongoing testing issues on Allegro 8.0
Log and monitor defects in Quality Center 10.0
Provide training to System administrators on the implementation of Quality Center 10.0 version and incorporating Allegro business processes within Quality Center
Create and modify deal entry templates and deal skins
Responsible for maintaining the Requirement Traceability metrix and finding out gaps within the Requirement coverage
Shell Trading, Houston, TX June 2009 - June 2010
Senior BA
Developed Business requirement documents on Create Non-Batch Movement task for the project by providing a task flow diagram and contextual information around each of the activities within Create Non-Batch Movement flow.
Documented business and technical requirements, along with developing design specifications, test plans, and use cases for business requirements.
Create test cases for Crude nomination, and Crude scheduling from one pipeline to another pipeline
Create Business requirements and assessment of current Openlink Endur v.5 to implementation of Endur 9x and integration with AcuRisk, Nucleus, performance evaluation for remote locations and Cash Month Position Management.
Actualize Crude Nomination in Cmotion
Assisted the front office to develop some high level execution scripts for deal capture
Assisted the back office (OPS) to develop high level scenario on Monitor Movement of crude
Meet with OLF developers for review sessions, integrate Nucleus into Endur and write extraction requirements.
Review dBase logic and Endur GUI. Cmotion, Deal management, Deal Entry, Deal Capture and Deal modeling and transaction history, Crude, gas, scheduling, front office and mid-back operations, Daily Volume cuts and Price Changes, position monitoring, scheduling, and tactical tradebook.
Write short charter for financial reconciliations and build roadmap for Openlink Endur 9.x implementation, testing and extraction of Nucleus archived and real-time data.
Support a highly diverse portfolio of applications including: electric wholesale and retail trading, scheduling, risk management, settlement and accounting.
Create and modify deal entry templates and deal skins.
Create and modify Endur reports using SQL, Business Objects and Crystal report
DTE Energy, Detroit, MI April 2008 - May 2009
Senior QA Analyst
Lead and participate in meetings with project sponsors at the project and technical level to provide project status and ongoing updates
Ensure that deployments of Allegro 8.0 follow established methodology and processes to ensure quality, repeatability, and efficiency of the software implementation
Create detailed test cases for regression testing of Allegro 8.0
Create UAT testing training for the business users
Create a defined business process documentation for the front, mid-office, and back-office
Create test cases for the Contract, Logistics, Trades, Pipeline, Scheduling, Positions within Allegro 8.0
Created test cases for the New MR’s to validate issues that has been fixed
Lead requirements gathering/definition, requirements documentation, solution design, test plan/test case design and all levels of testing including unit, system, regression, and user acceptance
Work closely with the business analyst, and the developers on gas flow from one meter to another meter
Involve business users in testing at the appropriate level to ensure quality end product
Review Requirements for testability, and define tests.
Work with team lead to develop a data flow model that clearly defines roles/responsibilities of each team member
Execute test cases, diagnose and resolve problems and generate problem reports
Smoke test the testing environment every time a new build is deployed from the development team
Lead Subsystem through UAT
Create data decks for UAT testers
Track and communicate all defects found during UAT to the appropriate Subsystem Lead
Perform daily health checks in the UAT testing environment
BP (British Petroleum), Houston, TX March 2007 – April 2008
Senior QA Analyst
Create test cases for gas nomination and gas scheduling
Perform system performance analysis and research regarding root causes of memory leakage. This involved perusing the error and performance logs on the Endur file system as well as the NT logs on the application servers
Develop and enhanced documentation for OpenLink Endur internal processes and bespoke processes built on-site
Work with a team to guide direction of IT and Business-related projects involved with the Endur system and related environments
Assist in the training of new starters to increase understanding of the Endur software system
Develop release process and documentation for Physical Gas and Power implementation
Manage script migration from the source code repository (CVS) to the testing and production environments
Manage release processes for new and updated coding solutions
Assist in development and testing in a specialist capacity
Use TOAD to access the oracle database tables to perform backend testing of the application
Work closely with the business analyst, and the developers on gas flow from one meter to another meter
Create gas deals between one counterparty and another counterparty
Conducts analysis and quality-control tests to ensure that software meets or exceeds specified standards and end-user requirements
Track and communicate all defect found in QC to appropriate subsystem
Perform regression testing on bug fixes associated to subsystem
Perform component integration testing to test the functionality of each screen
Drafts and revise test plans and scripts, execute test scripts according to application requirement documentation
Recommend and implement changes to enhance the effectiveness of quality assurance strategies
Work closely with the offshore team to ensure deliverables are delivered.
ACS, Houston, TX May 2005 - March 2007
Systems Analyst
Execute test cases, manual and automated, and documenting results
Collaborate with the development team in preparing the test environment, data set up, and process execution
Report, track, and monitor defects and test blocking issues.
Review requirements for test creation/modification
Integrate tests with other design elements (other software and hardware) and the development and execution of test plans.
Identify test configuration, test input, and expected results.
Development of product test requirements and test specification, implementation of the test software (WinRunner and Test Director) and script writing system test descriptions to very requirements.
Create manual and automated test scripts using WinRunner. Performed text, field, bitmap, and screen area verification
Create High-level base scripts to perform Data Driven Test, Database Checks, Batch and functions.
Utilize test director to track and report defects.
Review and analyze design documents for testability
Develop and maintain automated test scripts for back-end/batch system components
Lead requirements analysis and definition for new Projects with clients
Evaluate information gathered from multiple sources, reconcile conflicts and translate high-level information into details
Perform regression tests
EDUCATION AND CERTIFICATIONS
University of Houston - Downtown
BA in Computer Information Systems