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
• Confidential 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

Responsibilities:

• 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

Business Systems Analyst

Responsibilities:

• 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.

Business Systems Analyst

Responsibilities:

• Gathered Requirements for Oracle SQL reporting of EPIC and Clarity Clinical Hospital data
• Used Business Intelligence Qlikview 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

Responsibilities:

• 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. .

Business Systems Analyst

Responsibilities:

• Completed large extensive hyperlinked indexed training document for Research & development using SharePoint and Box.com
• Performed Qlikview 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 need

Business Systems Analyst

Responsibilities:

• 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.

Business Systems Analyst

Responsibilities:

• Tested Departmental (Mobility) divisions for server migration, and upgrades for Telecom Billing systems
• Used Qlikview 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

Business Systems Analyst

Responsibilities:

• 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.

Data Quality Business Analyst

Responsibilities:

• Administered and coordinated data quality processes focused on client billing compliances and Purchasing using SharePoint
• Created Operational Performance dashboards in SharePoint modeled after Qlikview
• 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 Confidential 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

Business Systems Analyst

Responsibilities:

• 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 Confidential SharePoint.
• Prototyped process enhancements for usability using PowerPoint, Visio and Snagit
• Used Confidential 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

Business Systems Analyst

Responsibilities:

• 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 Confidential Project for project tracking and reporting project status.

Business Systems Analyst

Responsibilities:

• 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 Confidential Project for project tracking and Mercury Suite Tools for defect tracking
• Used Visio for diagramming concept and context diagrams for Functional Requirements

Business Systems Analyst

Responsibilities:

• 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

Business Systems Analyst

Responsibilities:

• 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.

Production Support Business Systems Analyst

Responsibilities:

• 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.

Business Systems Analyst

Responsibilities:

• 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.

Systems Auditor

Responsibilities:

• Audited several IT departments using SDLC (best practices) to check for ERP controls for PeopleSoft Payroll and G/L.
• Compiled reports and technical assessments for management concerning security recommendations to maintain integrity in data processing.
• Used Sarbanes Oxley compliance guidelines throughout the audits.
• Used Visio and PowerPoint to diagram process flow for daily activities involving security procedures.

Business Systems Analyst

Responsibilities:

• Assisted in upgrades of new relational database releases of ORACLE 8i, 9i, for LAWSON 8.03 COBOL Payroll and LAWSON ERP Financial system.
• Participated in JAD facilitations sessions. Designed program and dataflow diagrams in Visio and PowerPoint to defining process of migration
• Wrote many CRYSTAL reports and SQL queries to support daily payroll processing requests.
• Help customize LAWSON Payroll forms and process for interfaces and school payroll issues. Did Quality Assurance of the entire Payroll process. Helped client reconcile converted journal entries balances to Lawson.
• Downloaded student test information to ACCESS, and EXCEL to be uploaded to ORACLE load file format for data warehousing.
• Updated MS PROJECT and VISIO process flow with daily work in progress.
• Used ENCRYPTION technology for HOPE Scholarship processing.
• Modified and maintained reporting and relational database applications for information processing using Z/OS TSO/ISPF, FILEAID, UNIX AIX shell scripting, ENDEVOR. Wrote COBOL II, CICS, DB2, ORACLE SQL, EASYTRIEVE +, SAS programs for critical government funding student applications.
• Utilized stored procedures and sort utilities to maximize better performance.
• Uploaded FTP files to AS400 system.
• Used structured RUP methodologies, standards, and utilities for SDLC, daily production support, and imaging documentation.
• Frequently transmitted files using PCANYWHERE by FTP to the state and federal government.
• Used CA7, CA11, RACF for production scheduling.

Configuration Manager

Responsibilities:

• Manager for building releases of software for broadband communications software.
• Tracked program problems for management and team using CLARIFY.
• Maintained ACCESS and EXCEL data of changes made.
• Created VISIO process flow diagrams for testing.
• Gather requirements to testing specific build specifications.
• Built CD’s for internal and external use using SOLARIS UNIX Visual SOURCESAVE and CLEARCASE scripting tools.
• Maintained XTML for company website concerning changes to releases and documentation.
• Worked with software engineers to integrate C+ embedded SQL changes to versions of release software. Maintained changes for Channel Logos for clients using PHOTOSHOP.
• Wrote and modified CRYSTAL, CLARIFY, and CLEARCASE reports and scripts for levels of CCM testing.

Technical Support Consultant

Responsibilities:

• Technical Support Consultant for GEAC ERP Human Resources Package (formerly D&B Software MSA E Series). Developed fixes and modifications for Human Resources in COBOL and CICS in an OS/MVS environment. Used TSO/ISPF, IDMS, MQ SERIES, IBM utilities, JCL, VISIO, CHANGEMAN, CLEARCASE and MS OFFICE.
• Wrote COBOL II programs using strict coding standards and procedures.
• Developed Functional Specification Documentation for Quarterly Regulatory Bulletins for GENTRAN EDI, https, and AS2 transactions for UNIX and mainframe environments.
• Flowcharted complex system changes using VISIO for clarification in functional specification document.
• System and Unit tested current releases of Human Resource Package. In addition, helped Customer Support Department with client issues needing resolution, many times having to talk directly with the client that reported the problem.
• Wrote test scripts using COBOL, JCL, and TSO.
• Used code analysis tool to reduce debugging time.
• Ran CLEARCASE reports to track problem resolution.

Systems Consultant

Responsibilities:

• Worked on Y2K conversion for major reporting system (SCARS) for MCI-WORLDCOM as a team lead.
• Updated batch, COBOLII, CICS, IDMS, and DB2 ERP customer service programs to year 2000 compliance standards.
• Coordinated production and maintenance areas of the IT department to implement changes in CICS, batch, and DB2 environment using TSO/ISPF AIX UNIX.
• Used ENDEVOR and FILEAID for creating test data.
• Became familiar with cellular Billing procedures, financial applications, and file transfer requirements.
• Managed two other programmer analysts.
• Used WINRUNNER and LOADRUNNER to do all testing. Used VISIO to flowchart Y2K data flow considerations for management and development team.
• Created and maintained SAS reports to verify data changes on ISAM and VSAM files. In addition, maintained CLEARCASE scripts and CLARIFY reports for tracking Y2K resolutions.

Systems Analyst

Responsibilities:

• Worked on COBOLII, CICS, DATACOM, VSAM Y2K conversion for Financials A/R, and Retail billing packages. Made necessary changes to JCL and programs for Y2K considerations.
• Ran all Unit and System batch tests for Relational database and Peoplesoft systems. Used Y2K tools, and methodology for date manipulation.
• Unit, string, and regression batch testing using CA7 and CA11.
• Followed strict coding standards, for making Y2K changes to company standards using TSO/ISPF (CHANGEMAN).
• Used VISIO to illustrate Y2K data flow considerations for management and development team. Checked all systems for compliance.

Production Coordinator

Responsibilities:

• Worked on-call for batch COBOLII, MVS/JCL processing for ERP Cellular Billing Rating (VIRTUOSO) package using OSS/BSS AIX UNIX.
• Debugged EDI in batch processing.
• Responsible for editing and validating data received from C+, UNIX downloads. CA-7 and CA-11 was used extensively for production job submission.
• Used CHANGEMAN for version releases of programs to be tested. Unit, string and regression batch testing were used for development.
• Maintained internal and external customer support for regional ALLTEL users.
• FLOWCHARTER and VISIO were used to diagram nightly production process to improve efficiency. SAS was used for ad-hoc reporting to verify production data