Business Analyst - Data Warehousing Resume
SUMMARY:
- Project Management System Implementation Business Systems Analysis
- Top - flight solution/results driven leader with a proven ability to effectively manage and implement large-scale, high-visibility projects by applying comprehensive knowledge of design, systems analysis, and full project lifecycle management.
AREAS OF EXPERTISE:
Healthcare Payer Systems Change and Defect Management
Logistic/Supply Chain Data System Development & Implementation
Work Flow Analysis & Redesign Technical Specification Development
Risk Assessment/Mitigation Techniques Requirements Engineering
Stakeholder Management Process Improvement
TECHNICAL SUMMARY:
Business Apps: Oracle SQL Developer; SQL Server Management Studio (SSMS); Pegasystems, TriZetto
Tools: Oracle OBIEE, FACETS; Serena Business Manager (SBM); Beeline; McKesson ClaimsXten; 3M Coding and Reimbursement; HP Application Lifecycle Management (ALM); Oracle Application Express (APEX); SharePoint; Pivotal Tracker; Project Data Manager (PDM); EDI Transaction Sets 240, 270/271, 837, 835, 834, 820; Confidential ; HL7 (Inbound); Electronic Error Correction (EEC); Rational RequisitePro & ClearQuest; MyEclispe; ISPF Editor, IBM; eFDE; ICCF Editor, IBM; Microsoft Visio; PlanView; Clarity; Microsoft Project.
Databases: SQL Server; SQL Azure, Oracle; Data Warehouse; Microsoft Access; DB2.
Methodologies: Project Management, Project Management Institute (PMI); Business Process Modeling Notation (BPMN); Agile, Waterfall, SLDC; User Stories, Use Cases; Business, Functional & Technical Requirements.
CAREER HISTORY:
Business Analyst - Data Warehousing
Confidential
Responsibilities:
- Responsible for interfacing with the business unit (Business Resolution Team) to review requirements, lead JAR/JAD sessions, schedule meetings, prepare test plans, and create system requirement documents for use by system analyst to produce detail design documents for Department of Child Support specific projects.
- Create and maintain the strategic partnership between Business needs and Technology delivery in OIT.
- Developing Statement of Work (SOWs), business requirements and related business rules based on needs of the Client Support Services.
- Work closely with the business users and Applications Leads in the definition, testing, training, implementation, and support of these applications as it relates to OIT.
- Identify requirements via industry standard analysis techniques such as data flow modeling, workflow analysis, and functional decomposition analysis.
- Participate in daily stand-up meetings with both OIT and Business Partners to facilitate the understanding, clarification, and implementation of requirements.
- Meets with project team(s) regularly to review project deliverables and deadlines.
- Provides single point of contact for assigned project.
Technical Systems Analyst
Confidential
Responsibilities:
- Translated business requirement into functional specifications for the IT community, managed changes to such specifications and educated the IT community on the direction of the business.
- Participated in the creation of complex PRD (Project Requirements Document) which includes defining Business, User, functional and non-functional requirements needed for approval by Business and for use by Design, Development and Testing teams. Participated in creation of Requirements Management Plan (RMP) for complex projects and less complex projects, to define, organize and schedule requirements management and development activities.
- Led testing efforts by defining, developing and implementing practices and procedures for complete end user test, and ensures all user acceptance tests are conducted and documented according to standards.
- Participated in the exploration of alternative business solutions for complex processes, programs or applications, and performed Gap Analysis of alternative business process solutions. Presented those Gap analysis finding to management.
- Facilitated department project status meetings between Project Managers, Technical Delivery Managers and senior management. Provided project status documentation for Senior Leadership.
- Reviewed resumes selected and interviewed potential candidates for Project Management and Business Systems Analyst positions.
Confidential, Alpharetta, GA
Sr. Business Systems Analyst
Responsibilities:
- Supported Small Package business processes requiring design and/or integration of database solutions to manage route activity including electronic billing and invoicing, shipment tracing/visibility products.
- Led project team members through the process of developing and maintaining requirements from analysis to deployment.
- Presented functional requirements document and UAT results for review and sign-off.
- Coordinated and performed feasibility studies and proposals for evaluation by appropriate users and managers.
- Investigated, resolved and escalated issues as needed.
Confidential, Lawrenceville, GA
Adjunct instructor, computer science division
Responsibilities:
- Prepared and maintained all required documentation and administrative reports.
- Taught Oracle Structured Query Language 11g (SQL), Entity Relationship Diagramming (ERD), and basic database conceptual & physical design concepts.
Confidential, Atlanta, GA
Sr. Business Analyst
Responsibilities:
- Developed Personnel business process workflows of current and future state for Employee, Non-Employee and Fellow In/Out-Processing functions, Contractor and Non-Vendor Extensions.
- Gathered business requirements and developed Business Requirements Documents (BRD).
- Facilitated meetings with stakeholders, SMEs and Workgroup members to review and validate process workflows and business requirements. Acquired signoffs and approvals as required.
- Active National Agency Check with Inquiries (NACI) Clearance.
Confidential, Atlanta, GA
Business Systems Manager
Responsibilities:
- Identified business requirements and created Change System Request (CSR) to assist internal and external development staff with system coding.
- Performed pre- and post-production activities/tasks to validate system enhancement for Professional, Inpatient and Outpatient claims process.
- Gathered requirements and created required documentation for a long-term solution which applies a Tier Status (preferred or non-preferred Facility) to Facility Inpatient and Outpatient claims submitted by Individual and SHOP (Small Group) markets.
- Facilitated meetings between stakeholders, SMEs and technical staff to address questions related to system changes.
Confidential, Gaithersburg, MD
Lead business analyst
Responsibilities:
- Coordinated the efforts of multiple business analysts to launch Individual Direct line of business for ACA on FACETS environment for Enrollment & Eligibility, Billing and Claims departments.
- Performed Enrollment & Eligibility, Billing and Claims tasks to identify triggers and current state conditions of Pega workflows. Documented as-is and to-be workflows in preparation of ACA implementation.
- Evaluated and documented FACETS system configuration changes for updates to Standard Operating Procedures (SOPs) and Training department processes. Created and gave group presentations of production changes to internal stakeholders.
- Documented business requirements including essential health benefits (EHB), Indian Health Services (IHS), Cost Share Reduction (CSR), Advanced Premium Tax Credits (APTC), and translated them into functional specifications.