Business Analyst/architect Resume
Columbus, OhiO
SUMMARY:
- 30 years working on group and individual projects simultaneously, T - shaped skills, With so many I-shaped skills, Think Ben Franklin
- 22 years application support, system & business analysis, system and database design and testing - team motivator, mentor, leader
- 22 years IBM mainframes, Syncsort, Fileaid, TSO, Procs, ZOS / OS MVS JCL, Gener, JES3, COBOL, TSO, ISPF, ESA
- 22 years experience with Systems Design Life Cycle in a Client Server Environment, SDM, SDLC, RUP
- 22 years experience with IMS DB/DC, MFS, DLI, BMP, BMC SOFTWARE, Checkpoint Restart, VSAM
- 22 years experience with Translating Business Strategy/Drivers into IT requirements - Project Estimations
- 22 years experience with the definition & enforcement of standard data element names, abbreviations, characteristics, values, aliases.
- 22 years experience with the enforcement and maintenance of governance policies, processes, performance measurements, UX/UI Design
- 16 years experience with Microsoft Office (Word, Excel, Project Manager, Power Point etc.) DB2, SPUFI, QMF, SQL, Binds, Declgen, Joins, Cursors, Dynamic SQL
- 16 years experience with Project Discovery approaches and estimations RFI/RFP/RFQ / RFC monitoring
- 4 years experience running my own business, monitoring & modifying Best Practices Hands on experience in developing and managing Business Intelligence applications
- 2 years experience JAVA, Focus, Halappi, Scripts, HTML, REXX, Java, Stored Procedures triggered by Java, WLM, BMC Software, Stored Procedures
- 2 years experience with State Clients 1 year coding experience CICS 6 years design; 6 months Princeton SofTech's Relational Tools “Move For DB2”
- Utilized quality disciplines to manage new application development projects through complete project lifecycles
- Experience with and gut level understanding of ITIL, Waterfall, RUP, & Agile, Unified Software development methodology.
- Work effectively with senior management in planning future feature development and implementation.
- Participating in the budget and long-range strategic planning process. management strategies. Proven ability to contribute to long-term company success and profitability
- Creatively view (and suggest solutions to) problems arising from changing business process variables.
- Used my experience providing insight into key business dynamics such as competitive activities and industry trends. Senior Advisor to the Release Planning Team
- Deep understanding of Business, Market and Industry functionality and current IT trends - Responsible for Project Success
- Served on the following teams: ISG, ITSCM, CMS, SKMS, SPM, CAB, CSIP, PIR, SPM, BAR and BSA
- Helped define: CBFs, BIA, BCP, KPI, SIP, SLT, SLR, SOR, SWOT, VBF, CMM, CSFs, MoR, RACI Chart
- Versatile and Experienced Business Analyst with a solid background fueling process improvements in regard to cost, performance & efficiency.
- Adept communicator with expertise in strategic planning, competitive analysis, assessment, team leadership and project management.
- Exceptional written and verbal communication skills and interpersonal skills. Proven ability to contribute to long-term company success and profitability
- Self motivated with can-do attitude; adaptive with the ability to grasp things quickly. resolved conflicts to drive decisions
- Proven experience in significant, complex multi-tier architecture, multi-million dollar software development
- Relationship manager with product owners and development teams to create an environment of continuous improvement. A team builder.
- ITIL is the liaison between technical and non-technical personnel - includes Value Added and Business Best Practice guidance, Identify Key Performance Indicators, Project Metrics, Milestones, Key Deliverables, Risk Abatement, Company wide approach to IT integration
- PRINCE2 & PMBOK Knowledge, Life insurance and Real Estate licenses - Intimate knowledge of Contract Law & Insurance
- Served on various Governing Boards of NP organizations for many years advising on planning, strategy, personnel issues
TECHNICAL SKILLS:
COBOL II, MF COBOL
OS MVS JCL SQL
EASYTRIEVE, QUICKJOB, REXX, CLISTS
FOCUS, MARK IV, SAS, CICS
OS JCL JES 2, JES 3
MVS XA ZOS
Windows XP, 7 AS400 Client Server, NDM, FTP
SOFTWARE:
CA7 and UCC7
Lotus Notes, Outlook, SharePoint
MS-ACCESS, PROJECT, EXCEL, WORD, Visio, PowerPt.
Workbench / Animator
FTP and MQ Series - TCPIP
TSO ISPF ESA - EXPEDITER - HALLAPI
Spufi, QMF, SQL, DB2 v 9
Adobe, Rational Rose
IMS DB/DC DLI & BMP & MPP & MFS & BTS
FILEAID / FILEAID IMS
IBM UTILITIES ABEND AIDE
CHANGEMAN, ENDEAVOR, APS, PUPS, DCCS
Data Architecture, Capacity and Structure Management:
Use Cases Wireframes UML
Logical Data Designs/Models
Data Integrity / Profiling
Embarcadero Data Modeling Tool
Data Warehousing / Facets
Data Mapping / Mining / ETL
Referential Integrity
Identify Data and Solution Patterns
Inovis-data normalization
Source to Target Mapping
Business Intelligence
Data Modeling, Data Blending, Taxonomies
Data Normalization - EDI
Entity Relationship Diagrams
Logical Data Models
SCM - Software Configuration Management
Data Access Efficiency
Managing Data Requirements
Data Flow Diagrams
Data Conversion/Translation Strategies
DDLT0 IDCAMS VSAM
ACB, PCB, PSB, DCB Gens
RDMS Design - WLM
DB2 Stored Procedures - DB2 Connect - UDB
Convert Enterprise Assets to Information Assets
Modeling/Mapping Artifacts to a Data Architecture Framework SOA
Documentation of External Documents/References/Interfaces
Documentation of Source and Target Systems
Insurance
Health Care
Workman’s Comp
Part / Item Number Conversion
Bar Code Reader / Printer Oil &Gas
Warranty
Warehousing
Point of Service
Resource Tracking / Management
Medical / Health Insurance Manufacturing
Invoicing
Fraud Detection
Order Processing
Distribution Center Expansion
Bill of Materials / Lading Inventory Control
Accounting
Transportation
Government Taxation
Telephone Wire Pair Tracking
Mathematical Modeling Payroll / Employee Benefits
Other Tools / Skills:
Functional Design Doc.
Process & Event Diagrams
Project Scope Definition Project Charters / Scope / Feasibility
Resource Management
Fit - Gap -Trade-Off Analysis
CRUD, System & Program Flow Diagrams / Traceability Matrix
JAD Chairperson
RACI Chart Development
Prioritization and Management of Requirements & Deliverables
Full SDLC and RUP
Group Motivational Skills
Offshore/ Cross Cultural /Cross-Functional Project Management
Strategy/Roadmap/BPR
RAD / Agile Development
Project Rollout Control / Software DeploymentQuality Assurance / Metrics
Cost/Benefit Analysis - ROI
Trend Analysis, Capacity Planning, Resource Plans, Budgets
Project Proposal Prep
Mentoring & Training Staff
Customer, Team, Vendor Coordination
Customer Focus / Training
Project Planning / Charting
Detailed Work Plans, Schedules, Project Estimates
Disaster Recovery
ISO/SOX Standards Compliant
Service Failure Analysis (SFA) / Root Cause Analysis (RCA)
SLA/SLO compliance
Management of Risk (MoR)
Process Efficiency Analysis Supportability Assessment
Flexible Problem Resolution
Top Echelon Status Reporting
Requirements Traceability Documents, SOW, BRD, CSD, TDD
Prototyping / ERD diagrams
Business Process Redesign
Test Director / Test Manager
Business Objects Reporting/Design
Applications Test Cases for Unit, UAT, System Tests
Business Continuity Planning / Business Re-alignment Restructure
EXPERIENCE:
Business Analyst/Architect
Confidential, Columbus, Ohio
Environment: Data Control, Refresh, Teradata, Hadoop Database/DataWarehouse, ETL, Mainframe Modernization, RSA, UX/UI, ITSM, SAS, EDI
Responsibilities:
- Coordinated the large parallel test of Teradata to Hadoop with off shore 3rd party supplier TATA. Wrote the requirements for changes to the batch processes.
- Since JPM was moving from Teradata to Hadoop - they decided to reconfigure some of the AML processes to streamline mainframe code, ITSM Framework
- I spent much of my time tracking down connections and explaining why Business Objects were not working as they had in the past, DDL, Link, server problems.
- CMDB - designed the structure to gathered elements and guided customers on how to create ad hoc reports. Completed project on time under budget.
Data Manager/ Business Analyst
Confidential, Allen Park, Michigan
Responsibilities:
- Coordinated world wide use of 3 test regions and 26 vehicle lines among 14 separate test organizations with competitive and conflicting goals. Persona Def.
- Supported One Note/ SharePoint worldwide reservation system. Managed 2 offshore off hours resources. Synced Production to test regions. COBOL TSO
- Used the home grown CMDB to monitor issues, create tickets, manage data refreshes and provide customer service. Suggested CMDB redesign for ad hoc purposes
- Central clearing house for questions about data construction and provided direction for process control. Quick View Plus to manipulate files. BMC software
- Streamlined processes and documented process improvements. Managed 16 major data refreshes in less than a year. Coordinated with off shore 3rd party supplier.
- Chaired the weekly Monday morning meeting to align efforts of the other managers to achieve harmony in the test regions. Signed off on 3rd party supplier contrct.
- Prior to this Data was corrupted and deleted. Tests failed for mysterious reasons. Competing groups had open turf wars over test data regions. Created User Stories
- My success is the fact that the teams now have an orderly process by which testing can continue without ruining the tests of other groups.
Mainframe Support / Business Analyst
Confidential, Grand Rapids, Michigan
Responsibilities:
- Supported the Meijer Credit and Debit Card processing system - COBOl, Easytrieve, IMS, DB2,TSO, Interface to Web-based applications
- Fixed production abends. Diagnosed problems with data and scheduling. Repaired COBOL and JCL errors. Reviewed system design.
- Created system documentation where there was none. Provided on and off site 24/7 support for critical systems. SKU processing, Live testing
- Front-line support for customer calls and emails by taking ownership and accountability for the call resolution process. FTP, EDI, MQ Series
- Participate in Defect Triage, customer/support as appropriate. Prioritize, escalate and track incidents according to the SLA.Created User Stories
- Created system documentation by Maintaining logs of all issues and ensure consistent resolutions for all production processes. Persona Def.
- Facilitated timely turn-around of production abends, customer service requests, and post-launch issues. Participate in updating training content
- Managed incidents, defects & change requests. Prioritize requests from other project managers. Created & closed Remedy Tickets
- Timekeeping, Payroll, W-2 computations. Personal gratification that I can go back to basics and be successful
Mainframe Support / Business Analyst
Confidential, Brownstown, Michigan
Environment: COBOL, JCL, ITSM, Sixsigma, SharePoint, FileManager, SYNCSORT, Endevor, MOBIUS, SQL, Agile, Data Security
Responsibilities:
- Supported the largest Warehousing complex in the USA - COBOl, SAS, File Manager, IMS, DB2,TSO, Interface to Unix. SharePoint testing.
- Front-line support for global customer calls and emails by taking ownership and accountability for the call resolution process.
- Provide a vehicle to document all support interactions in the Call tracking system to reflect the status of the call. Front End/Back End Testing
- Created system documentation by Maintaining logs of all issues and ensure consistent resolutions for all production processes.
- Facilitated timely turn-around of production abends, customer service requests, and post-launch issues. FTP, EDI, MQ Series
- Managed incidents, defects and change requests. Prioritize requests from other project managers & 3rd Party Vendors. Created User Stories
- Reviewed system design and Monitor and provide support to workflows and provide expert knowledge on all workflow designs. eTracker Tickets for Change-Man and Endevor issues. Personal gratification that I can go back to basics and be successful
New Dev. Test Lead/Business Analyst
Confidential, Southfield, Michigan
Environment: Technical Data Store/Data Warehousing, MMIS, ClearQuest, ETL, Connecture, Front/Back End Tests, Agile, ITSM, REMEDY
Responsibilities:
- Business Process Redesign - Wrote Test Cases conducted JAD sessions, Built Financial Models to represent real world experiences.
- Modified technical diagrams using Visio. Facilitated global requirements meetings with stakeholders & suppliers. Served on CMS team.
- Responsible for assisting the offshore team in understanding the user requirements, Installation, Issue Management, Product Disposition
- Participate in Defect Triage, issue investigation and resolution customer/support as appropriate. Manage customer issues by gathering clear and concise description of the problems, investigate customer incidents. Tested feedback links to reinsurance and risk adjustment
- Created and maintained Project Status Dashboard, tested Business Objects. Created User Stories, Requirements Traceability
- Edited XML files Inbound Requests/Outbound Requests IBR / OBR - Participate in defect reviews - automated SharePoint testing
- Corrected Visio documents. Wrote the FRD and the Persona Definitions - The clearing point for all things Direct Enrollment related
- Met Government Mandated start of FFM / Exchanges part of the Patient Protection and Affordable Care Act (PPACA) avoided penalties.
New Dev. Lead Bus/Sys Analyst/Coordinator
Confidential, Owings Mills, Maryland
Environment: Data Warehouse, ETL, ALM, MMIS, UX/UI Design, Agile, Business Continuity, Persona Def., ITSM, HIPAA, ITSM
Responsibilities:
- Wrote requirements conducted JAD sessions, Gave guidance on Challenging Customers, Id Risk Groups
- Call center feature enhancement. Installation, Issue Management, Built Financial Models to represent real experiences. Created User Stories
- Participated in the process of configuration management. Created a traceability matrix of the requirements to design using MS Excel.
- Requirement elicitation through interviews with business and technical staff In corporate these requirements into a variety of artifacts
- Used data from Actuarial Data Stores to create live representations of MLR calculations to enhance the dialog for Call Center clerks.
- Determine impact of functional requirements in collaboration with other feature team members on various aspects of existing system.
- Responsible for assisting the offshore team in understanding the user requirements, Installation, Issue Management, Product Disposition
- Work with the Development Team, & Stakeholders to identify & document high level business requirements for inclusion in a Business Case.
- Issue resolution - Shared Knowledge on Insurance and Government Regulations and Industry standards, Structured Questioning, VISIO
- Reinsurance, Risk Corridors, Risk Adjustment - Medical Loss Ratio - Heath Insurance Exchanges, SSRS reporting software, Peer Reviews
- Business Impact Analysis, Data Analysis, Functional Process Redesign, Structured Peer Reviews, TRMS to HPX conversion, Capitation
- My Success was a completed test system design - verified to user satisfaction
New Dev. Lead Bus/Sys Analyst / QA Test
Confidential
Environment: RX fulfillment, AS400, SQL, DB2, BPR, MS Project, Use Case, HPQC, UX/UI Design, Regulatory compliance, Agile, Business Cont. Plan
Responsibilities:
- Developed Event Diagrams, Process Diagrams, System and Program Flow Diagrams, Context Diagram, Actor Definitions - Data Mapping
- Responsible for assisting the offshore team in understanding the user requirements. Installation, Issue Management, Product Disposition
- Developed test data according to the user requirements to perform unit tests. Participated in the ongoing process of configuration management.
- Prepared test cases and performed Unit UAT, System integration (SIT) and Regression test, Timekeeping, Payroll, W-2 computations
- Communicate with system end users to gather system feedback, conduct defect reviews and improve functionality. Created User Stories
- Multidimensional, metadata analysis Coordinate with Offshore Teams. Maintain safety, security, and privacy standards
- Kept the IT program manager apprised of documentation status and inform management of progress, risks / challenges
- Participate in Defect Triage, issue investigation and resolution customer/support as appropriate. Manage customer issues by gathering clear and concise description of the problems, investigate customer incidents by identifying and reproducing software issues Communicate status reports and/or incident resolution paths back to the customers. Prioritize, escalate and track incidents according to the SLA.
- Wrote much of the BRD, Test Cases, Test scripts, Technical Specs. Gave guidance on BRD and Business Process Redesign - Issue resolution
- Defined stage scope and boundaries via deliverables and timetable - defined business case - update risk log - Business Impact Analysis
- Lead Development of Requirements Project Rollout Coordination & Control - Hands on leadership - Embarcadero Data Modeling Tool
- Completed test system design - verified to user satisfaction Excellent ability to plan, document and develop procedures & objectives in support of critical projects for clients - Process redesign to meet customer objectives -Prioritization & Management of Requirements & Deliverables
New Dev. Lead Bus/Sys Analyst / Data Modeler QA Test
Confidential, Auburn Hills, Michigan
Environment: SAP, Materials & Asset Management (MM), Share Pt., Business Continuity, Use Case, Fit - Gap, Prototyping, MS Project
Responsibilities:
- Met with customers & chaired meetings to gather requirements & conduct JAD sessions - Documented Business Requirements & Processes
- Responsible for assisting the offshore team in understanding the user requirements. Installation, Issue Management, Product Disposition
- Developed test data according to the user requirements to perform unit tests. Participated in the ongoing process of configuration management.
- Communicate with system end users to gather system feedback, conduct defect reviews and improve functionality.
- Multidimensional, metadata analysis Coordinate with Offshore Teams. Participate in updating training content,
- Became an expert on specific features and participate in any changes even after implementation to production. SKU Processing
- Determine impact of functional requirements in collaboration with other feature team members on various aspects of existing system.
- Wrote the Detail Test Design - Lead Development of Requirements - Wrote Technical Specs - Used SAS for ad hoc reporting - Coded SQL
- Developed Event Diagrams, Process Diagrams, System and Program Flow Diagrams, Context Diagram, Actor Definitions - core competency
- Defined stage scope and boundaries via deliverables and timetable - defined business case - update risk log - Hands on leadership
- Kept the IT program manager apprised of documentation status and inform management of progress, risks / challenges
- Completed test system design - verified to customer satisfaction Excellent ability to plan, document and develop procedures & objectives in support of critical projects for clients - Lead Development of Requirements Project Rollout Coordination & Control – Customer Delighted
Supplier Change Lead Bus/Sys Analyst
Confidential, Sacramento
Environment: Timekeeping, Payroll, DB2, PHI, Sybase, BPR, MS Project, Use Case, Wire Frame, Power Pt, MMIS, HIPAA, Agile, CFR
Responsibilities:
- SLR-Defined stage scope and boundaries via deliverables and timetable – defined business case – update risk log - Business Impact Analysis
- Lead Development of Requirements - Wrote Technical Specs- Embarcadero Data Modeling Tool Use Cases – UML – Data Mapping. Served on CMS team.
- Excellent ability to plan, document and develop procedures, and objectives in support of critical projects for clients – Resource Planning
- Completed test system design, built, executed and test reports - verified to customer satisfaction – Issue resolution – State Level Repository
- Kept the IT program manager apprised of documentation status and inform management of progress, risks / challenges. Micro Focus re-hosting.
- Became an expert on specific features and participate in any changes even after implementation to production. Participated in configuration management.
- Communicate with system end users to gather system feedback, conduct defect reviews and improve functionality. Business Objects Reporting/Design
- Member f the change advisory board (CAB) which provides support to a change management team by approving requested changes and assisting in the assessment and prioritization of changes. Organize and conduct vendor evaluation. Participate in updating training content, Timekeeping, Payroll, W-2 computations
- Determine impact of functional requirements in collaboration with other feature team members on various aspects of existing system.
- Manage deployment of web-based, Client-Server, and Mainframe applications, Installation, Issue Management, Product Disposition
- Developed Event Diagrams, Process Diagrams, System and Program Flow Diagrams, Wireframes-Used SAS for ad hoc reporting
- Became the focal point for questions - Validated code and defects against requirements - Saving the State of Calif. $50 million
New Dev. Management Lead Bus/Sys Analysts/Data Modelers QA Tester
Confidential, Detroit, Michigan
Environment: ETL, BPR, MS Project, JAD, Rational Rose, Use Case, Wire Frame, Power Pt., Asset Management, SQ Server, Agile
Responsibilities:
- Led the effort to optimize Business Processes using advanced IT tools - measurable cost savings – Cost Benefit Analysis - Completed Power Point documentation and presented it to the client
- Using a scaled down Prince2 methodology Prince2 produced product and process focused documents under direction of the Project Board - Project planning – Issue resolution
- Provided technical, user and business assurance documents during the start and middle of the project - Data Mapping – Business Architecture - Embarcadero Data Modeling Tool
- Defined stage scope and boundaries via deliverables and timetable – defined business case – update risk log – Developed ad hoc Task Forces - Wrote new training manuals
- Design and Development for both OLTP and Data warehousing environments. data mapping. Participated in the ongoing process of configuration management.
- Communicate with system end users to gather system feedback, conduct defect reviews and improve functionality. SKU Processing
- Determine impact of functional requirements in collaboration with other feature team members on various aspects of existing system.
- Lead Development of Requirements Project Rollout Coordination & Control – Hands on leadership – Resource Planning– USE Cases – UML - User Stories – automated testing
- Developed Event Diagrams, Process Diagrams, System and Program Flow Diagrams, Wireframes – automated testing - Completed Power Point documentation and presented it to the client
- Wrote Context, Entity Relationship, Data Flow, Use Case, Class, Activity, Sequence, Extensions Diagrams, Wireframes, Business Rules, Performance Constraint, Parent/Child Relationship, Spec Docs, Project Dashboard, Traceability Matrix, efficiency via reuse opportunity, Business Objects/Artifacts
New Development Management Lead Bus/Sys Analysts / Data Modelers/ QA Tester
Confidential, Detroit, Michigan
Environment: Excel, SAS, JAVA, VB, Data Warehouse / Mining, ORACLE 10g, Crystal Reports, Rational Rose, UML. Asset Management
Responsibilities:
- Manager and QA for Web based applications – JAVA, .Net, etc. – Analysis and QA only – lead group of 5 developers
- Played a key role by offering expertise in project management, test case development & business analysis, various aspects of the software development & implementation cycle
- Using Prince2 produced product and process focused documents under direction of the Project Board– Hands on leadership – Issue resolution
- Provided technical, user and business assurance documents during the start and middle of the project - MS Project– Project planning -
- Defined stage scope and boundaries via deliverables and timetable – defined business case – update risk log – Business Impact Analysis Cost Benefit Analysis
- Developed Event Diagrams, Process Diagrams, System and Program Flow Diagrams, Wireframes – Embarcadero Data modeling Tool
- Design and Development for both OLTP and Data warehousing environments. data mapping. Participated in the ongoing process of configuration management.
- Communicate with system end users to gather system feedback, conduct defect reviews and improve functionality.
- Determine impact of functional requirements in collaboration with other feature team members on various aspects of existing system.
- Met with customers & chaired meetings to gather requirements & conduct JAD sessions - Project Coordination & Control – Data Mapping
- Took direction from and reported to the Project Board using a scaled down Prince2 methodology Agile Story development
- Entity/Object/Artifact definition, cardinality, optimization of relationships, (association,, aggregation, composition, inheritance, dependency)
- Completed test system design, built, executed tests - verified to customer satisfaction – Bill of Lading – Resource Planning - $4M cost savings
