Robert Lewis

Lead Business Systems Analyst

Mesa, AZ 85210
Phone: (480) 463-3043
Email: robert_lewis@outlook.com
LinkedIn: www.linkedin.com/in/robertlewisaz

 

I am a Lead Business Systems Analyst with more than 20 years of experience leading, managing, and implementing, complex, cross-functional projects. As a project leader I effectively facilitate meetings, to engage stakeholders and elicit accurate requirements.

I have an extensive technical background which I draw upon to assess change, identify gaps, and address both functional, and non-functional, business requirements from both the end user, and developer, perspectives.

My knowledge and passion enables me to aid organizational growth and mentor my associates.

 

SKILLS

  • Business Analysis Planning and Monitoring
  • Requirements Analysis and Design Definition
  • Requirements Life Cycle Management
  • SDLC Methodologies (Waterfall, Agile)
  • Project Management
  • Stakeholder Elicitation and Collaboration
  • Risk Analysis and Management
  • Solution Evaluation
  • Gap Analysis
  • Strategy Analysis

 

PERSONAL QUALIFICATIONS

  • 15+ years of analysis/design of internally developed systems.
  • 20+ years of cross-functional systems experience.
  • Self-motivated and able to manage tasks and work independently as well as with a team.
  • Comfortable working in a dynamic, fast changing environment.
  • Excellent communications skills (written and oral), customer service skills and problem solving skills.
  • Demonstrated ability to work in a diverse and technical rich environment.
  • Self-starter, with an ability to learn and grow beyond formal training.
  • Able to make critical and successful decisions under pressure.
  • Effective at building constructive relationships with stakeholders and gain their trust.
  • Knowledgeable about emerging business solutions, technologies, and delivery methodologies.
  • Skilled at working collaboratively within a physical or virtual environment.
  • Demonstrated ability to work effectively with outside vendors.
  • Experience integrating solutions across diverse technical platforms.
  • Strong technical background.
  • Excellent trouble shooting skills.

 

WORK EXPERIENCE

Contractor/TEKsystems
Business Systems Consultant (Wells Fargo)
11/2016 – Present
Chandler, AZ

Technical and functional Business Systems Consultant (BSC), within the Enterprise Risk Management Technology (ERMT) team, executing a complex enterprise wide PCI DSS regulatory project for Currency Transaction Reporting (CTR) Systems.

  • Primary point of contact for enterprise wide regulatory and compliance project.
  • Understand and interpret PCI DSS and enterprise requirements and determine impact to LOB applications.
  • Design and document functional specifications to align with enterprise and PCI DSS security standards.
  • Function as SME for all PCI DSS remediation activities across all LOB applications and systems.
  • Translate requirements and designs to produce technical, functional and support documentation.
  • Consult with developers on technical implementation of design solutions.
  • Provide support and guidance during development and testing of solutions.
  • Influence and build relationships with stakeholders, technology leadership, internal and external service providers and architecture teams.
  • Provide guidance to divisional application managers on enterprise technology roadmap for PCI DSS compliance.

Skills Used: Strategic Planning, MS Office Suite, MS Project, MS Visio, SharePoint, Remedy, Documentum, Structured Query Language (SQL), Oracle, Test Planning, Test Coordination, Issue Management

 

Mod Indigo
Business Systems Analyst
05/2014 – 11/2016
Scottsdale, AZ

Self-employed, freelance Business Systems Analyst, consulting for small businesses. Recommend and implement database driven solutions to streamline processes, enhance customer experience, eliminate duplication and increase productivity.

Engage Clients in Support of Business Needs

  • Generate proposals in response to client RFP’s.
  • Conduct discovery and requirements sessions to understand the client’s issues and business rules.
  • Generate detailed recommendations to address issues and enhance customer experience.
  • Create estimates based on project needs.
  • Manage projects, including SOW’s, schedules, time tracking, and billing.

Design and Develop Solutions to Address Current and Future Business Needs

  • Design database driven business solutions for web and data transformations.
  • Design and implement cross-system ETL and data transfer solutions for clients.
  • Manage solution development and testing; design and code (PHP, SQL, etc.) solutions as needed.
  • Write training documents and conduct training sessions with client.
  • Install and configure custom solutions into client’s production environment.
  • Recommend and design reporting solutions.

Skills Used: Structured Query Language (SQL), Complex SQL Queries, Database Design, MySQL, XML, Test Planning, Test Coordination, Issue Management, Unix/Linux, Apache, WordPress, SharePoint

 

The Bon Ton Stores, Inc.
Lead Business Analyst
02/2007 – 05/2014
Milwaukee, WI

Manage design, development, testing, and implementation of medium to large size projects. Leverage organization’s internal Service Oriented Architecture (SOA) to design and integrate omni-channel (web, mobile and kiosk) solutions utilizing IBM WebSphere’s multi-tier eCommerce architecture. Support management in project planning, project estimating, scope analysis, project coordination, overall department budgeting and long-range planning processes.

Analyze Business Needs and Recommend Solutions to Address Current or Future Business State

  • Work with the stakeholders to define processes and work flows in support of business needs.
  • Provide technical assistance to identify, evaluate, and develop cost effective, efficient solutions.
  • Analyze processes and solutions, provide feedback on usability, user experience, and customer experience.
  • Generate strategy and document data mappings for conversions and cross-system integrations.
  • Perform data analysis and research using advanced structured query language (SQL) techniques.

Establish Priorities and Manage Systems Development Life Cycle (SDLC) Process

  • Support management with budgeting, capital expense, and long-range planning tasks.
  • Prepare and revise estimates in support of the project plan and schedule.
  • Verify project estimates, including full-time equivalent (FTE) and return on investment (ROI) projections.
  • Manage stakeholder involvement to obtain project approvals throughout the development process.
  • Manage project scope and requirements changes.

Manage Application and Systems Development, Testing and Implementation

  • Utilize Object Oriented Analysis & Design (OOAD) methodologies to design value added solutions.
  • Engage stakeholders, generate user stories, and maintain product backlog.
  • Lead joint application development (JAD) sessions to capture business rules and requirements.
  • Translate requirements and user stories into actionable design documents, and test and use cases.
  • Generate data and process models utilizing standardized Unified Modelling Language (UML).
  • Create entity relationships diagrams to define and document custom and existing database designs.
  • Manage user acceptance testing (UAT) with stakeholders and Quality Assurance team.

Provide Ongoing Support for Applications and Overall Requirements Life Cycle Management

  • Function as primary liaison between stakeholders at all levels and IT.
  • Manage and maintain requirements and design information from inception to retirement.
  • Serve as domain subject matter expert (SME) for functional and non-functional questions/issues.
  • Assist with, and document, root cause analysis (RCA), and problem resolution.

Mentor Analysts and Developers

  • Develop and administer training programs for new analysts and developers.
  • Instruct analysts and developers in the company standards and practices of the SDLC process.
  • Mentor analysts in effective stakeholder engagement.

Skills Used: Structured Query Language (SQL), Complex SQL Queries, Database Design, Oracle, SQL Server, XML, Test Planning, Test Coordination, Issue Management, Strategic Planning, Unix/Linux, IBM Mainframe, Web Services, Service Oriented Architecture (SOA), Multi-Tier Architecture (n-Tier), UX Design, Apache, Jira, Clarity, SharePoint

 

The Bon Ton Stores, Inc.
Senior Business Analyst
06/1999 – 01/2007
Milwaukee, WI

Lead design, development, testing, and implementation of systems enhancements and solutions. Manage small to medium size projects. Assist in large project planning and budgeting.

Analyze Business Needs of Assigned Applications

  • Facilitate requirements gathering meetings with business partners and JAD sessions.
  • Define high-level, functional, and detailed requirements for application development projects.
  • Translate requirements into a design of process models, logical data requirements, work flows, and test and use cases.
  • Work with the business partners to design presentation formats for user interfaces, web interfaces, reports, and forms.
  • Work with development group to ensure that data relationships and technical requirements are understood, and that the product deliverables match the requirements of the business processes and intended use.
  • Ensure business rules are captured and executed in the proper place and time.
  • Ensure development standards are addressed within the applications.
  • Provide technical assistance by identifying, evaluating, and developing cost effective and efficient solutions.

Establish and Coordinate Application Testing and Implementation Plans

  • Develop test plans based on requirements.
  • Create cross system tests to verify integration between new and legacy systems, and internal and external hosted systems.
  • Perform application and system testing using both hands on tests and automated testing tools such as Selenium, soapUI, etc.
  • Coordinate issue tracking and resolution in conjunction with the business partners, and development and QA groups.
  • Verify stress testing results to ensure accuracy, and maintain performance on new or enhanced applications.

Provide Ongoing Support for the Business Partner

  • Work with the business partners to define and develop processes and work flows in support of business needs.
  • Serve as primary support contact for application system support and functional questions/issues, and be accountable to the business partner for overall satisfaction with all IT deliverables.
  • Make recommendations and implement solutions to eliminate process complexities, improve productivity and eliminate production issues or outages.
  • Work with technical services and operations to identify and correct application performance issues.

Skills Used: SQL, Database Design, Oracle, SQL Server, Java, JSP, ASP, ASP.NET, C#, Restful API’s, XML, XSL, XSLT, Test Planning, Test Coordination, Issue Management, Unix / Linux, IBM Mainframe, Web Services, Service Oriented Architecture (SOA), Multi-Tier Architecture (n-Tier), UX Design, Apache, IIS

 

Show Additional Work Experience

Additional Work Experience

The Bon Ton Stores, Inc.
IT Hardware Analyst
02/1999 – 05/1999
Milwaukee, WI

The Bon Ton Stores, Inc.
Advertising Systems Specialist
10/1994 – 01/1999
Milwaukee, WI

The Bon Ton Stores, Inc.
Advertising Broadcast Coordinator
02/1994 – 09/1994
Milwaukee, WI

The Bon Ton Stores, Inc.
Advertising Signwriter
10/1989 – 01/1994
Milwaukee, WI

Hide Additional Work Experience

 

EDUCATION

Bachelor of Arts (BA) English and Mass Communications
University of Wisconsin – Stevens Point
08/1986 – 06/1989

 

COURSES AND SEMINARS

Harvard ManageMentor Plus Management Development Program:

  • Becoming a Manager
  • Business Case Development
  • Diversity
  • Giving and Receiving Feedback
  • Making Business Decisions
  • Managing Difficult Interactions
  • Managing Upward
  • Managing Your Time
  • Persuading Others
  • Project Management
  • Setting Goals
  • Thinking Strategically
  • Writing Skills

View all Education, Courses and Seminars

 

TECHNICAL SKILLS

  • Databases
    • SQL Server (MS SQL Server)
    • Oracle
    • DB2 (IBM DB2)
    • MySQL
    • Teradata
    • Structured Query Language (SQL)
    • Database Design
  • Microsoft Packages
    • MS Office Suite
    • MS Project
    • MS Visio
  • Collaboration / Management
    • MS SharePoint
    • Clarity
    • Jira
  • Web Design / Development
    • HTML / DHTML / XHTML
    • JavaScript / VBScript / JQuery
    • Service Oriented Architecture (SOA)
    • Multi-Tier Architecture (n-Tier)
  • Development Technologies
    • Application Programming Interface (API)
    • AJAX / JSON / SOAP
    • Java / JSP
    • PHP
    • ASP / ASP.NET / C#
    • XML / XSL / XSLT
    • Python
    • Perl

View all Technical Skills

 

REFERENCES

Available upon request.

 

TRAVEL

Able to travel both domestically and internationally as needed.