Business Systems Analyst Resume
Atlanta, GA
TECHNICAL SKILLS:
- UNIX
- UNIX SHELL SCRIPTING
- SOLARUS UNIX
- AIX UNIX
- GENTRAN for UNIX and MAINFRAME
- ANSI X12
- XML
- MQ Series
- FTP
- HTML
- XML
- AS2
- CICS/COBOLII
- IDMS
- IMS
- JCL
- MS PROJECT
- DB2
- VSAM
- MS OFFICE XP /WORD/EXCEL/ACCESS
- ORACLE PL/SQL
- CRYSTAL
- CLEARCASE
- CLEARQUEST
- XREDITOR
- WINDOWS XP
- JAVA
- .NET
- AS400 COBOL
- CL
- FILEAID
- C+
- TSO/ISPF
- DATACOM
- IBM UTILITIES
- FOCUS
- MICROSOFT SQL SERVER
- EASYTRIEVE+
- PCANYWHERE
- VISUAL BASIC
- COGNOS
- VISIO
- ENDEVOR
- SQL
- PEOPLESOFT
- LAWSON
- CHANGE SYNERGY
- CCM
- RATIONAL TOOLS
- RUP
- UML
PROFESSIONAL EXPERIENCE:
Confidential, Atlanta, GA
Business Systems Analyst
- Gathered Requirements for SharePoint / Oracle/ Java Confidential HR Site for preventing de - duplication of data and process improvement
- Conducted Agile Scrum JAD sessions with subject matter experts and SharePoint Developers.
- Mapped Clinical data for HIV / TB medications and treatment
- Wrote many test cases for governmental mandated DATIM / PEPFAR data reporting
- Used Visio diagrams to clarify data and work flow of business processes improvements
- Test Lead for all new development for (Data for Performance Management) SharePoint site and verified functional requirements.
- Assisted with Java, Angular, and Oracle Quality Assurance with Developer
- Monitored and reported Oracle SQL /MS SQL Server / SAS de-duplication data analytics
- Provided SharePoint support for functional design enhancements testing and internal site reporting
Confidential, Atlanta, GA
Business Systems Analyst
- Gathered Requirements for Agile Scum testing Oracle reporting websites for server migration
- Managed BA team on completion of various testing scenarios for Oracle reporting websites server migrations
- Time mapped medical data for data analysis and Risk management
- Wrote many Use cases for HL7 Quality Center testing, and vendor verification
- Developed Uses Cases, and Test Scripts in ALM HP / AMS for work flow reporting processes testing, and used Visio to diagram process and system flow of business processes
- Developed Data analytics for measuring testing performance for State Unemployment and Health Services Applications
- Maintained and enhanced Quality Measurement SharePoint Site for Data analytics and Process Measurements.
- Provided QA assistance for JAVA and Oracle PL/SQL Development
- Conducted Gap analysis of functional requirements for change management
- Used UML processes to identify, categorize and prioritize change implementation.
Confidential, Atlanta, GA
Business Systems Analyst
- Gathered Requirements for Oracle SQL reporting of EPIC and Clarity Clinical Hospital data
- Used Business Intelligence Confidential tool to identify data mart collection areas requirements
- Conducted Agile Scrum JAD sessions for EPIC module HL7 upgrades and ICD-9 conversion to ICD-10
- Mapped Clinical lab data for Outcome treatment procedures
- Researched MS Access databases PIVOT tables, VlOOKUPS to gather and analyze data requirements for reports to be converted to SSRS, Oracle SQL and SAS.
- Developed Uses Cases for identification of work flow reporting processes, and used Visio to diagram process and system flow of business processes
- Loaded requirements to Quality Measures SharePoint Sites for Data analytics and process measurements.
Confidential, Atlanta, GA
Business Systems Analyst
- Created and updated over 55 uses cases and Functional Requirement documents for Websphere (Middleware), JD Edwards E1 Procurement Commerce business systems
- Assisted PM with Project schedule and work breakdown structure
- Used SharePoint site to maintain and store digital content for collaboration with business units and developers
- Conducted over 15 JAD sessions via Webex with Subject Matter Experts to gather requirements for new release of multi-language web-site
- Used Visio to diagram process Wire-framing and system flow of business processes
- Gathered requirements for Oracle On-demand CRM Purchasing system, Manufacturing and Logistics systems
- Used UML templates and processes to gathering requirements and develop requirements traceability. .
Confidential, Carrollton, GA
Business Systems Analyst
- Completed large extensive hyperlinked indexed training document for Research & development using SharePoint and Box.com
- Performed Confidential analyses to size business opportunities and guide management in decision making
- Conducted Agile JAD sessions with Subject Matter Experts on current business processes
- Participated in Gap analysis of business requirements, work flow processes and interfaces with EPIC modules (ADT, ASAP).
- Gathered requirements of Salesforce.com, force.com current reporting and POS billing processing needs
Confidential, Atlanta, GA
Business Systems Analyst
- Gathered requirements for DOL Medicaid Medicare Claim Billing processing for ICD-10 mandated changes for Agile Scrum development.
- Developed test plans for releases of changes for ICD-10 implementation on SharePoint
- Participated in Gap analysis of business and governmental requirements and compliances.
- Developed requirement traceability matrix in Access for functional requirements of each release
- Data Mapped SME vendor crosswalk data issues of ICD-9 to ICD10 code set data mapping conversion
- Conducted ICD-10 impact analysis for Risk Management, online screens, reports, and system interfaces.
- Facilitated and participated in many JAD sessions with Business Units.
Confidential, Atlanta, GA
Business Systems Analyst
- Tested Departmental (Mobility) divisions for server migration, and upgrades for Telecom Billing systems
- Used Confidential to provide a dashboard to monitor key performance indicators
- Compared and data mapped production data (Oracle 11.x) with migrated server data using Oracle PL/SQL, SQL Assistant and Toad for Oracle ODBC.
- Used SSRS and Stored procedures for reporting on interfaces summarizing data from Business Intelligence data (Hyperian) Middleware
- Requirements Traceability utilized using Rational Rose Req Pro and UML using Agile methodology
- Use PIVOT Tables and VLOOKUPS to analyze and provide quality controls for data collection.
- Verified Business Intelligence (Business objects) reports in test matched production reports.
- Process Visualization for new development using IRISE
- Working toward becoming a subject matter resource on Business Intelligence reporting for Dimensions and Hierarchies for UNIX based(PFT) Profitability, Billing and Rating
Confidential, Columbus, GA
Business Systems Analyst
- Created Use Cases for consolidation and streamlining of Insurance Purchasing processes for UNIX, CRM .Net environment Agile product development
- Used Visio for diagramming of data flow and process flow enhancements
- Data Mapped SharePoint list data for migration to a MS SQL 2007 database table
- Verified data migrated to new databases using SSRS
- Participated in JAD session, peer reviews of enhancement requirements, and use case definition.
- Gathered requirements for Salesforce.com and Clarity for customer experience
- Gathered business requirements and created VISIO process flows for As-Is and To-Be processes in SharePoint
- Used Lean Six Sigma process modeling to identify wastes, metric measurements and target areas for Unix based Logistics automation improvements.
- Assisted with data modeling of a data repository for SharePoint data using CA Erwin.
Confidential, Tucker, GA
Data Quality Business Analyst
- Administered and coordinated data quality processes focused on client billing compliances and Purchasing using SharePoint
- Created Operational Performance dashboards in SharePoint modeled after Confidential
- Facilitated Agile Scrum JAD sessions with developers, quality assurance testing and internal business
- Supported Oracle Peoplesoft HR applications and reports processing for department
- Developed EXCEL spreadsheets, VLOOKUPS, PIVOTABLES, dashboards, and macros with VBA code to access and analyze large amounts of billing data and metered data.
- Provided Quality assurance of ETL, SOA, ITIL processes and procedures
- Data Mapped and modeled data entities for a billing .Net data conversion
- Used Visio extensively for data flow and process diagramming of new release of Data Portal and process enhancements
- Used Microsoft Project to manage Agile / Procurement project initiatives.
- Used DMS documentation extensively to create data quality initiatives
- Produced monthly analysis of data quality received from System Operations for GSOC management
- Gathered and analyzed business requirements for Product development enhancements to existing billing and Web based .NET accounting systems using Scrum Agile and Waterfall methodologies.
- Used PI and eDNA to perform data quality analysis and trends of real time data
- Created SQL (SSIS, SSAS, SSRS) Crystal reports using MS SQL 2008 to analyze daily data issues for Billing department, also used Oracle PL/SQL 11.x for ODBC data validation
- Provided Billing Process flow enhancement recommendations to senior management
- Used Erwin Process Modeling and Data Modeling to verified data relationship integrity and better understand data relationships
- Created UML/use cases and used Visio for data flow and process flow diagramming
- Used automated testing tools and stored SQL procedures for Quality Assurance verification of LOADSTAR data
Confidential, Alpharetta. GA
Business Systems Analyst
- Gathered requirements for Payroll, HR, and (Total Comp) Benefits packages for Billing process flow product development enhancements.
- Used Rational ClearCase and ClearQuest for defect tracking and reporting
- Verified Oracle Database requirements and access using Toad, HTML, XML, PL/SQL and Enterprise reporting.
- Standardized documentation and processes used in gathering and storing requirements on Microsoft SharePoint.
- Prototyped process enhancements for usability using PowerPoint, Visio and Snagit
- Used Microsoft Project for project tracking and reporting project status.
- Assisted offshore developers, QA staff in UAT testing, with Auto Scripting
- Facilitated JAD sessions with developers, Agile quality assurance testing and internal business
- Used PMBOK best practices for project management and process development
Confidential, Atlanta, GA
Business Systems Analyst
- Gathered requirements for Government Research and Non-Research Process Procurement flow to identify areas needing streamlining.
- Facilitated JAD sessions with Subject Matter experts to identify AS-IS and TO-BE processes for Financial Billing Applications.
- Documented data usage support of ongoing analysis, data calls or Oracle and MS Server 2003 and strategic planning for data interfaces.
- Verified Data requirements using SQL/ Crystal Reporting (Oracle PL/SQL / MS SQL 2003).
- Assisted with training of ERP Grant management systems (IMPACII) and best practices.
- Developed Process Modeling diagrams using VISIO and BPWIN using Rational tools that included UML/ Use case diagrams for actor, and data relationships.
- Used Microsoft Project for project tracking and reporting project status.
Confidential, Atlanta, GA
Business Systems Analyst
- Gathered requirements from user groups for Scope and Design (RUP, RATIONAL Rose) documentation for OPTICS Financial Sales and Billing tracking system using MS Server 2003,HP UNIX, ORACLE 10g, EXCEL, and Web, XML based systems
- Designed “mocked-up” screen changes proposed to customer for Web (Portal) Middleware related changes for formalized SCOPE and Design documents.
- Developed creative user Confidential solutions, that addressed business requirement needs
- Developed user Confidential prototypes for consistency and ease of use.
- Managed usability standards and best practices for applications
- Collaborated extensively with design analyst, users, and management for product development
- Managed, Coordinated and facilitated software releases for sales performance software
- Created Functional Requirements, Test Cases, and maintained SOX compliances documentation and approvals
- Developed test plans, test strategy, and verified results using SQL queries with users
- Worked remotely using VPN security encrypted networks, levels and classes
- Used Microsoft Project for project tracking and Mercury Suite Tools for defect tracking
- Used Visio for diagramming concept and context diagrams for Functional Requirements
Confidential, Atlanta, GA
Business Systems Analyst
- Gathered requirements for Scope and Design (RUP) documentation for Wellpoint ERP Claim Bill processing, and Customer Relations systems
- Coordinated and facilitated JAD sessions between the customer and the technical team outlining assumptions, constraints and risks.
- Developed user Confidential solutions that meet business, client and customer goals
- Created High level LOE documents estimating cost and time needed to complete projects
- Developed test plans, test strategy, and expected results
- Tested HIPAA XML and X12 transaction cases using XMSPY. Used Clearquest, Clearcase, SQL, Rational tools and Crystal reporting for defect tracking
- Worked remotely using VPN security encrypted networks, levels and classes
Confidential, Columbia, SC
Business Systems Analyst
- Gathered requirements for Scope and Design (UML, RUP) documentation for Confidential for Government ERP Claim Billing systems
- Participated in JAD sessions for National Provider Indicator initiative for TRICARE processing.
- Developed reports and queries using Crystal
- Designed “mocked-up” screen changes proposed to customer for Web (Portal) related changes for formalized SCOPE and Design documents.
- Coordinated and facilitated JAD sessions between the customer and the technical team outlining assumptions, constraints and risks for HIT.
- Used Visio and PowerPoint to diagram context, concept diagrams, process flows and detail claim processing logic.
- Worked with technical programming team to communicate client’s needs for modifications to business applications.
- Used HIPAA and Confidential corporate guidelines and methodology to support lines of business. Modified HIPAA ANSI X12, 837, 270, 271, 276 and 277 EDI transactions Confidential used for receiving and transmitting.
- Formulated changes to Oracle 9i table processing, Legacy system, and OS/390 for report and image storage.
Confidential, Atlanta, GA
Production Support Business Systems Analyst
- Provided Lawson High Level Process flow engineering support for 8.03 Lawson ERP COBOL JAVA J2EE Payroll System to be deployed to client sites.
- Performed regression, unit, and system testing for quality control of new releases of Lawson based software. Ensured that project assumptions, risks, constraints and issues were effectively identified, documented, and managed throughout the project.
- Used Scripting tools for automation. Formatted changes to LAWSON scripted forms for GL and Oracle Interfaces, for 401k and Pension plans.
- Used BSI for TAX updates for LAWSON Payroll.
- Diagrammed changes in Visio and PowerPoint for extensive data analysis in JAD sessions with users and clients.
- Wrote SQL queries for quality assurance analysis of entire payroll process. Reports generated were later converted to Crystal.
- Defined Lawson process flow diagrams, and logical flow charts using VISIO.
Confidential, Atlanta, GA
Business Systems Analyst
- Supported EDI GENTRAN migration upgrade and UPC tracking from 4010 to 4030 for UNIX and mainframe material management ERP systems.
- Gather requirements from users group for formalized Scope and Design documentation.
- EDI experience with documents 850, 856, 810, X12, and EDI VAN Messaging. Assisted in Debugging
- EDI Data Communication messages.
- Interfaced with Business Partners, VANS, and users on problem determination and resolution.
- Used ENDEVOR and MVS/JCL to change control procedures to be moved to production.
- Developed DB2 SQL modifications for programs to improve efficiency.
- Analyzed business requirements and processes to rewrite data flow.
- Conducted all unit and system test of all new upgrade changes. Implemented production changes for new RFID/barcode changes that affected reports, screens, and database inquiry using DB2 Utilities.
- Did additional DB2 SQL queries for users to assist in marketing, inventory flow, and procurement.