Data Analyst
Resume:
AL HUMMEL
**** ******* *****, **** ********, PA *5108
**********@*****.***
PROFILE
Quality Assurance / Business Technical Analyst / Data Analyst
Experienced in the development, testing and integration of enhanced parallel testing processes into existing legacy health claim production modules using a variety of query languages and Microsoft Excel and Access, COBOL and proprietary analysis and documentation tools.
Experienced in querying and manipulating data using SQL, Cognos, Teradata and DB2Copy for the gathering and correlation of specific claim field values for analysis and reporting.
Experienced with data transfers for various types of files (XLS, TXT, CSV, Customer delimiters).
Experienced on various computer systems and computer languages, researching, compiling and analyzing data content, integrating systems, writing specification, code and documentation to create client-specific program packages, data reporting and data transmission.
Experienced in the creation and use of Excel workbooks utilizing macros, pivot tables, vlookups, charts, formulas and other features for analysis and reporting purposes.
Experienced with Windows 98/2000/2010/Vista/XP/7/10, Access, Excel, Word, Powerpoint, Visio and other PC based applications.
Experience with programming languages including: Pick Basic, Data Basic, Visual Basic, English Retrieval, DATABUS and COBOL on Reality and Unix operating systems.
Certified in: CompTIA A+, CompTIA Network+. Microsoft Certified Professional.
Strong Analytical and documentation skills.
Team player with the ability to work individually without supervision. EMPLOYMENT HISTORY
United HealthCare Services – Minneapolis, MN December 2016 – April 2017 Business Analyst
Responsibilities as Business Analyst in multiple software implementation/update projects for United HealthCare include:
Assess and interpret customer needs and requirements.
Identify solutions to non-standard requests and problems.
Solve complex problems and conduct complex analyses.
Translate concepts into practice.
Provide explanations and business information for difficult issues.
Demonstrate understanding of business capabilities, functions, processes and business cycles.
Apply understanding of health care and technology industry trends to software business solutions.
Demonstrate and apply understanding of applicable regulations (e.g., HIPAA, SOX) and UHG policies/standards (e.g., RSA, security).
Demonstrate understanding of the difference between business requirements and technical solutions.
Maintain awareness of best practices/approaches related to the business analysis discipline (e.g., Business Analysis Body of Knowledge).
Define the approach and effort required for defining business requirements (i.e., business, functional and non-functional).
Define and update the project schedule to track/measure progress of the requirements-gathering process (e.g., status, milestones, tasks, deliverables).
Define approach for storing and updating business requirements (e.g., SharePoint, ADR, Rally, Quality Center).
Adhere to established project lifecycle standards/requirements (e.g., SDLC, UDP, RSA, ADR requirements).
Gather information needed for the definition of requirements (e.g., business use cases, user stories).
Facilitate all needed requirements-gathering activities (e.g., meetings, workshops, JAD sessions).
Identify the business impact of system/application changes, using appropriate tools as needed.
Identify capability gaps between current state and desired state.
Collaborate with technology stakeholders to communicate business and technical requirements.
Collaborate with project team members to create detailed requirements documents (e.g., PRDs, Requirements Specifications, assumptions and constraints, VFQs, user stories).
Ensure that project requirements are clearly and comprehensively documented, understood and support traceability (e.g., peer review, SMART, requirements traceability matrix, Agile inspection).
Ensure that project requirements meet all applicable regulations (e.g., HIPAA, SOX, ARRA, DOI, audit requirements).
Identify and/or establish appropriate testing metrics/targets to validate that business requirements are being met (e.g., performance metrics, process deliverables, traceability, business value).
Conduct and/or support testing activities, as appropriate (e.g., production testing, regression testing, user acceptance testing, production validation, compliance with test scenarios).
Plan/execute user testing scenarios/scripts and prepare test data -Translate problems/issues identified during the testing/piloting process, and engage the appropriate stakeholdersto help identify impact and potential solutions.
Communicate testing results to appropriate stakeholders.
Validate usability of technical solutions prior to deployment.
Participate in creation of implementation plans for identified solutions.
Provide ongoing support to ensure proper implementation and adoption of the solution. Highmark - Pittsburgh, PA November 2008 – December 2016 September 2006 – April 2008
Quality Assurance / Business Technical Analyst / Data Analyst Responsibilities as Analyst for the Highmark Legacy Modernization project and ongoing corporate code releases as a Highmark employee and previous contractor through Accenture Technology Solutions, ConsultUSA and Computer Aid:
Owning, managing and performing the Electronic Claims Process Parallel comparison process, in which IMS information is gathered and compared through mainframe JCL processes and downloaded to a LAN. Using Excel, the data is then reformatted, summarized and reported for claims adjudication for each code release.
Developing, testing and integrating enhanced parallel processes into existing legacy health claim production modules using Rational Suite of Testing Tools, JCL job control language, SQL query language, Access, COBOL, Excel and proprietary analysis and documentation tools.
Extensive use of Microsoft Office applications. Daily use of Excel data imports and maintenance, pivot tables, formulas and Vlookup functions as the team's main tool in Claims discrepancy analysis.
Building and usage of Cognos and Access database queries and tools to gather and correlate claim field values for analysis and reporting.
Use of Rational Requisite Pro to identify, define, document and manage business requirements and features within Claims Processing systems.
Developing and documenting Q.A. and Functional test efforts, proprietary tools and processes.
Building, executing and documenting test scripts using Rational TestManager.
Automating manual test scripts using Rational Functional Tester.
Use of Rational ClearQuest defect management tool to log, define, manage and pass potential application defects identified in Quality Assurance and Parallel testing efforts.
Identifying, documenting and analyzing data fields, values and business requirements impacted by revisions to legacy processes
Editing and revising application features, supplemental requirements, test cases and test scripts to match changing Business and Technical Requirements.
Researching, analyzing and documenting current health claims processes.
Editing Cobol programs to identify and define fields impacted by programs within the Claims Validation process.
Developing client relationships and addressing all areas of client concern related to an all- encompassing, multi-year, multi-million dollar legacy upgrade project. Morneau Sobeco – Pittsburgh, PA April 2008 – November 2008 Operations Analyst / Data Analyst
Responsibilities as Operations / Data Analyst and Functional Tester for the Visteon account of Morneau Sobeco (a Toronto, ON based Benefits Administration company):
Developing SQL queries, Access databases and Excel reports as needed to research, correct and report information gathered and processed by Morneau Sobeco.
First point of contact for any Visteon client operations, data processing, file transmission, HRIS, and Benefits related changes, issues or concerns.
Working closely with external and internal clients and Morneau Sobeco developers and serving as a liaison to insure business requirements are translated into fully representative technical requirements.
Use of Devtrack issue logging and tracking tool for the management of any environmental, operational or application revisions within the HRIS or Payroll systems.
Developing and implementing manual test scripts for the testing of any change requests logged and promoted through the test environment and into production.
Monitoring incoming HRIS and Post Payroll files from clients or their third party representatives, researching and fixing data or transmission errors and insuring clean addition of data to Morneau Sobeco’s environment.
Executing monthly reconciliations of 17 insurer eligibility files with current information housed in Morneau Sobeco’s database.
Preparing, verifying and validating Pre Payroll data and insuring delivery of complete and accurate payroll deduction information to our clients and third party payroll processors.
Researching, verifying and validating ANSI 834 benefit transaction data sent to our clients and third party insurers.
Transportation Concepts, Inc. - Aliquippa, PA February 1986 – August 2006 I.T. / Operations Manager
Responsibilities as Operations Manager of a 35-employee freight audit company:
Building, maintaining and utilizing custom inter-system Electronic Data Interchange, data transfer, data transmission and data translation processes in which ANSI X12 transportation transaction sets 104, 110, 204, 210 and 214 were received, acknowledged, translated and processed for multiple corporate clients.
Serving as Business Analyst for all projects pertaining to transportation related data gathering, analyzing, reporting and transmission for all corporate clients, transportation directors and accounts payable managers.
Creating and implementing processes and procedures, directing and managing all aspects of computer operations and data processing within Reality databases utilizing Pick operating systems, connected LAN and desktop computers operating in a variety of Windows operating environments.
Planning, building, implementing and administering all aspects of customer accounts, customer relations and customer support for corporate clients such as Ingersoll-Rand, Anchor Glass Container, Sikorsky Aircraft, Flowserve Corporation and BASF Inmont.
Diagnosing hardware and software problems and determining solutions for company’s mainframe and desktop computers.
Creating and implementing procedures, supervising and planning workload and workflow for information systems, customer service, data entry, mailroom, proofreading, accounts payable and clerical departments.
Creating, integrating and maintaining all data entry, data processing, check processing, invoicing and reporting systems and processes within the company.
Building and maintaining customer-specific databases and all related support processes.
Creating and maintaining client carrier routing guides, carrier performance reports, optimal carrier reports, carrier comparison reports and freight claims processes.
Building, maintaining and utilizing client-specific logistics lane and rate analysis systems.
Developing and evolving lifetime and fiscal business plans, company sales strategies and budgets for the organization and individual departments.
Building and maintaining supplier and vendor relations. Researching, developing, distributing and analyzing Request for Proposals.
Evaluating company resource requirements and directing the procurement of equipment, software and all other office materials.
Developing and implementing employee education and incentive programs, compiling and maintaining employee compensation data and processing bi-weekly payroll.
Interviewing, hiring and reviewing performance of employees and directing all other personnel functions.
Setting-up and managing domestic and international bank accounts, data interface and reconciliation for four separate banking institutions. EDUCATION
MS Learning Partners, Birmingham, AL
Microsoft and CompTIA Certifications
School of Computer Technology, Pittsburgh, PA
Business Applications Programming (QPA - 4.0)
Pennsylvania State University, State College, PA
B.A. Degree - Labor Relations
Contact this candidate