Senior Business Analyst/subject Matter Expert Resume
SUMMARY:
- Information Technology Professional with experience managing the entire System Development Life Cycle (SDLC).
- Liaison between the Business Stakeholders and Technical teams for development/enhancements to the Web Base and back - end applications for supporting the Open Road Toll(ORT) Industry.
- Have experiences in Enterprise Data Warehouse/Data Marts/front end user interfaces, Data Steward, Business Object’s Instructor/Mentor, Enterprise reporting, and integration of Commercial off the Shelf (COTS) software packages. Create high level process diagrams, Business/Functioal Requirements, Work flows, Use Cases, user interface (UI)(Web/Back-office) functionality.
TECHNICAL SKILLS:
Project/Change Management: SharePoint, Rational Requisite Pro, Microsoft Office's Excel, Word, PowerPoint, Visio, Project, Clarity, Lotus Notes
Testing / Quality: Mercury Change Management, Mercury Quality Center, Test Director, Rational ClearQuest
Business Intelligence/Data Warehouse: Business Objects, Cognos, Query Tool - Toad
Enterprise Application Integration (EAI): SeeBeyond (Monk),Vitria
Data Base/File Management: Oracle, SQL, Access, DB2, Datacom DB, Amigo, VSAM/ISAM/BDAM
PROFESSIONAL EXPERIENCE:
Confidential
Senior Business Analyst/Subject Matter Expert
Responsibilities:- Led business analysis for supporting the Confidentials Hub and Confidentials system. TheConfidentials Hub supports 7 toll agencies (Confidentials,Confidentials,Confidentials,Confidentials,Confidentials,Confidentials,Confidentials) and will interface with other Hub(s); current Hub integration effort is with Confidentials. Working with Business Owners, 3rd party toll authorities, Design/Development, and testing teams. (current)
- Led business analysis for supporting the Confidentials which is the integration of Toll Transaction/adjustments and Disposition processing for the collection of 3rd party toll fares (Confidentials,Confidentials,Confidentials). Worked with Business Owners, 3rd party toll authorities, Design/Development, and Testing teams. (2 years)
- Worked with Sr. System Architect and prepared a high-level toll transaction processing work flow diagrams (drill down by functional area) which consists over 200 individual work activities. (2 months)
- Led business analysis, created high level process diagrams, Business Requirements, Use Cases, user interface (UI)(Web/Back-office) functionality, prepared the test execution plan, test cases, and executed all test cases for the implementation of an in-house developed Commercial off the Shelf (COTS) Toll Road System. Areas of responsibilities are the coordination for the customization to the Toll Customer Account Registration/Management (web-site) and Customer Service Center (back office) applications. (1 ½ years)
- Led business analysis effort for the Customer Correspondence/Complaints Management Tracking system used by Customer Service Center's Representative for tracking all communication to and from the toll customer. (3 months)
Business Intelligence (BI) Platform Manager / Senior Business Analyst
Responsibilities:- Led SDLC effort for a cost saving of $530,000/yearly with the integration from a 3rd party software SAP/Khimetrics to KSS’ PriceStrat and Heartbeat (Price Optimization and Sales Analyst Reporting) application. Created a high level interfaces diagram, eliciting business requirements and report specifications, reviewed general design, conducted User Acceptance Testing (UAT), deployed client software, and provided triage training for the helpdesk’s (Confidentials). Coordinated efforts with Merchandising/Pricing Department to provide competitive retail prices in the Market place for merchandise sold in 7-Eleven stores. (6 months)
- Guided the cost saving over $100,000/yearly in expenses by providing additional efficiencies with the integration of a 3rd party Food Sensory Panel Survey Internet Service Provider which automated manually supported Merchandising surveys processes. (3 months)
- Managed SDLC processes for the entire Enterprise Data Warehouse(EDW)/Data Marts(DM)/front end user interfaces by obtaining high level estimates for new subject areas/enhancements, eliciting business requirements, reviewing/supporting general design, conducting UAT, training helpdesk’s (TelVista), and executing data mining activities/ad hoc reporting. Mentored Business Object’s 600 Power Users across the organization and integrated Japan’s Information Sales Analysis which supported ~1800 end-users for Merchandising and Operations (Local/Field offices). (7 ½ years)
- Identified process efficiencies in the BI/Reporting areas which contributed to cost saving over $1 million/yearly. Conducted a survey with Business Stakeholders to determine usage, business value, Total Cost of Ownership, recommendation for simplification, reduce data redundancy/retention and identification of the single source of the truth. (1 year)
- Coordinated upgrade for the BI Cognos hardware and software environment working with IBM/Cognos consultants.(3 months)
- Presented overview of the Item Master and key fields required to the International Dept’s and Indonesia Franchisees owners.
- Led SDLC efforts for a multiple platform integration of Credit/Debit Card information from 7-Eleven Store’s Point of Sales which allowed a ~$45 million Credit/Debit Card fee charge to the Franchisees. (6 months)
- Authored 7-Eleven’s Business Intelligence (BI) Business Requirements Specification Template based on Business Rules Methodology (Terms, Facts, Fact Model, and Business Rules) and Web Reports Specification Template.
- Instructor for Business Object’s Power User training class (3 day course/ 5 times a year) 15-20 students/class and weekly mentoring meetings on-site for local and non-local Power Users via Conference Room/web meeting. (5 years)
Enterprise Application Integration (EAI) Analyst / Senior Consultant
Responsibilities:- Led integration efforts for the gathering of business requirements, technical specifications, and developing EAI Pub/Sub interface types for the following: File, TCIP, FTP, MQ Series, Dart (Oracle, SQL 7.0)
- Used SeeBeyond - e*Gate (middle ware) Monk coding which translated XML transactions from ERCOT to TXU for the following e*Gate interfaces: Emergency Electric Outages, EDI Meter Reads (867), Invoices (810), Registration (814), Service Orders (650), and EDI Reject (824) transactions based on Texas Set(x1.5).
- Resolved e*Gate interface issues, performed design and code reviews, prepared test plans, executed all testing phases, mentored e*Gate developers, and supported intermediate production, and the high availability production environments. This effort supported 3rd party CISPlus application and ERCOT to ensure TXU is in compliance for the Texas Energy deregulation.
Internet Technology Services / Legacy integration / Senior Consultant
Responsibilities:
- Led development of the following web sites:
- Energycareer.com using Cold Fusion, JavaScript, HTML,SQL7.0 - (Created Tables/Views, Stored and Triggers)
- GEAI.com using ASP, JavaScript, VBScript,HTML,SQL7.0 - (Created Tables/Views, Stored Procedures)
- Platedate.com using Cold Fusion, JavaScript,HTML,SQL7.0- (Created Tables/Views, Stored Procedures)
- PPAI.com using HTML, and ASP with ADO and VBScript (9 months)
- Performed process review analysis and recommended short/long term integration strategies for improving process efficiencies for GTE’s SuperPages.com web site and Directory Legacy systems. (3 months)
- Involved in the deployment of new PCs to GTE’s Sales Force by documenting the communication plan, timeline, and deployment roles working closely with GTE’s Executives, Directors, Managers, and Project Leaders. (3 months)
- Managed 10 consultants for the remediation of the 7-Eleven's M/F Legacy Human Resource and Payroll Systems; a Y2K compliance project. (1 year)
Re-engineering effort Business Analysis / Developer / Senior Consultant
Responsibilities:- Involved in a re-engineering project; created a high level processes diagram, business/system process specifications for the Real Estate TConfidentials working closely with Confidentialss Department Heads, Team Leaders, Business Team Members, Technical Support, and MCI Consultants. (1 ½ years)
- Developed Confidentials's Performance Monitoring and Non-Maintenance File Exchange Systems in Cobol II, DB2 and SQL. (6 months)
Re-engineering Effort Project Leader / Senior Analyst
Responsibilities:- Managed the SDLC effort for creating high level process diagrams, gathering of business requirements, reviewing general design, and performing UAT to support the distribution of application information from the Data Base host server (in Oracle) to 5,000+ 7-Eleven Store's In-Store Processor (ISP), Ordering Hand Held Device, Point of Sale (POS) registers, and 100+ Vendor Terminal Systems (VTS) "vendor computer and the MF (Legacy Applications) via the Network server for the following applications:
- Centralized Sales Tax Rates System a 3rd party integration (Internet sales tax rate provider) (6 months)
- Merchandising Strategic function’s Product Assortment(Centralized Item Master) (3 years)
- Retail Accounting Automation System. (1 year)
- Performed current situation and gap analysis betweenConfidentials ,Confidentials ; primary with a Merchandising focus as a member of the Strategic Study and Planning Team. (6 months)
- Software development experiences also included project leadership, program / analysis for Special Projects - Client / Server, Check Collection, International, Ticket Quik and Retail Petroleum.
PROFESSIONAL DEVELOPMENT:
- TDWI (The Data Warehousing Institute) (2008, 2007, & 2003) - Certified Business Intelligence Professional (CBIP)
- International Business Rules Forum
- Business Objects National Convention
- Distributed Programming using Java Technology, Sun
- Java Programming, Sun
- Vitria Intensive Program, DMR Consulting
- SQL 7.0, Carrollton, Texas
- E-Commerce Solution Engineering, SMU
- Business Telecommunication, Mountain View College
- SCO UNIX System V/386 Administration, Pro Consultants Inc.
- Database Management, (Master Level), University of Texas at Arlington
- Principles of Management, North Lake College
- Dale Carnegie Graduate, Dallas, Texas
- 36/System Training, IBM training centers
- ITIL (IT Service Management)
- Business Rules Training
- SeeBeyond - e*Gate, TXU
- OOO Application Analysis and Java Technology (UML), Sun
- Fujitsu I-Flow, Fujitsu
- Visual Interdev, Carrollton, Texas
- Web Site Planning, SMU
- Power Builder, East Field College
- 'C' Programming, Mountain View College
- AS/400 Training, IBM training centers
- 'Ideal' Programming, University of Texas at Arlington