SUMMARY:

• Senior Data Analyst, Technical Business Analyst and/or Systems Analyst with special interest in troubleshooting, analyzing and documenting applications and unsupported legacy systems.
• Highly skilled Confidential analyzing data to solve application and business problems.

TECHNICAL SKILLS:

• Oracle
• SQL Server
• SQL Queries
• T - SQL
• PL/SQL
• SQLPlus
• TOAD
• SSIS
• DTS
• XML
• XSD
• soapUI
• AGILE
• SDLC
• Spring Tool Suite (STS)
• IBM Rational Team Concert (RTC)
• Mercury Quality Center
• FileNet
• Documentum
• Datacap
• SIEBEL
• IVR
• UNIX
• EDI
• MVS Mainframe
• DB2/SQL
• TSO
• JCL
• IMS/VSAM
• RSAM
• FileAid
• General Ledger
• Accounts Receivable/Payable
• Collections
• Confidential &T legacy systems (SOCS, RNS, CABS, BOCRIS, RSAG, LFACS, etc.)
• VA legacy systems (Benefits Gateway Services).

EXPERIENCE:

Confidential, Atlanta, GA

Data Conversion Analyst

• Initial evaluation for data conversion of Randstad HealthCare (RHC) back office data from legacy system to the Atlanta PeopleSoft HR & Financial systems.
• Identify, plan and document the automated and manual data conversion efforts that are in line with overall project objectives .
• Attended Fit-Gap sessions with business units to identify and document current business processes (legacy) and how they fit into the target systems.
• After initial evaluations (stated above) - a business decision was made to postpone this RHC conversion until 2018.

Confidential, Alpharetta, GA

Senior Data Analyst / Billing & Rating Charging Analyst

• Detailed analysis of legacy billing system(s) and interfaces to prepare for future data migration.
• Perform complex SQL queries and develop ad-hoc reports to understand and quantify legacy data.
• Analyze Rating and Charging behavior in both legacy and target systems; perform post migration testing in target billing system to ensure rating and charging is consistent with legacy behavior.
• Served as mentor to other team members with respect to understanding business processes, testing methodologies, and troubleshooting defects.

Confidential, Charleston, SC

Senior Data Analyst

• Implementation of new paperless claims processing system (Veterans Benefits Management System - VBMS).
• Team expert in all areas of data - including acquisition, validation, interpretation and creation.
• Detailed XML and SQL analysis to identify data discrepancies between the newly designed application and legacy data.
• Worked with Veterans Affairs (VA) employees to fully understand existing VA legacy systems so that data integrity and functionality was preserved among systems.
• Regular use of VA applications within the BGS (Benefits Gateway Services) suite. This included: BIRLS (Beneficiary Identification Records Locator Subsystem), Map-D (Modern Awards Processing - Development), Corp-DB (Corporate Database), BDN (Benefits Delivery Network).
• Worked with Data Architects to document and update conceptual and physical data models. Provided guidance to SCRUM teams when updating or creating database tables to ensure compliance with architecture standards and best practices.
• Advised development teams in the proper use of external web services to acquire and update legacy data.
• Provided guidance to developers, requirements analysts and QA resources as to how to interpret and translate legacy data into the newly developed application.
• Discovery, documentation and translation of application defects.
• Daily use of Oracle 10g, SQLPlus, SQL Developer, SoapUI Pro, XML, IBM RTC, Spring Tool Suite, AGILE/SCRUM methodology.

Confidential, Charleston, SC

Data Analyst / Data Conversion Analyst

• Responsible for managing all aspects of converting client legacy data into Confidential ’s Enterprise CRM and Raiser’s Edge applications. Specific tasks included the import, analysis, mapping, conversion and cleansing of customer data.
• Conversion of application data from Oracle to SQL Server database. This required some manual export, data scrubbing and subsequent import into the new platform.
• Discovery and documentation of client legacy data issues, communicating proposed solutions and clean up options to the client.
• Quality testing of the converted data, identifying root cause of issues and designing/documenting proposed solutions.
• Use of Oracle SQL Developer and SQL Server Integration Services (SSIS) for ETL processes.

Confidential, Atlanta, GA

Sr. Technical Business Analyst / Application Analyst

• Responsible for analysis and repair of an existing HR document management system. Took ownership of application and brought it up to date by analyzing existing production data and system processes in order to identify and resolve hidden defects.
• Worked with business unit to understand what application ‘should’ be doing and uncovered several aspects of the database and custom code that required updates in order to meet those business needs.
• Responsible for light coding & testing (Visual Basic / .Net), heavy data analysis, table management, and large scale data cleanup in order to bring the application back up to user specifications. Converted/upgraded old SQL Server 2000 DTS package into SQL Server 2008 SSIS package.
• Acted as SME for planned migration of existing HR Document Management system (DataCap/FileNet) to the Documentum platform. Worked with solution vendor to provide system feeds, analysis and background information for existing system.

Confidential, Alpharetta, GA

Sr. Technical Business Analyst

• Business Analyst responsible for analyzing business needs of clients and stakeholders within the Revenue Accounting and Reporting arenas. Heavy concentration on the analysis and troubleshooting of production data in order to identify and resolve business, application and data integrity issues within the respective systems.
• Involved in the proposal, design and implementation of solutions to the system issues and defects.
• Worked closely with application developer to design, implement and test ETL process for historical data cleanup.
• Liaison with other project areas to coordinate interdependencies and resolve interfacing issues.

Confidential, Atlanta, GA

Sr. Technical Business Analyst / Data Conversion Analyst

• Technical Business Analyst/Data Conversion Analyst responsible for the incorporation of wireless and internet data from newly acquired companies into the existing Confidential Billing system.
• Liaison between the business units and development teams to translate (map) data, document and communicate solutions, troubleshoot/resolve issues, and verify results. Daily use of PL/SQL to write and execute complex queries in order to analyze, validate and troubleshoot converted data. Specialized in the Accounts Receivable, Pricing, Promotions and Collections areas.
• Analyzed large flat files from legacy systems in order to discover and report formatting issues prior to the conversion process.
• Worked closely with ETL developers, providing technical specifications, SQL queries, and general guidance throughout the conversion process.
• QA Analyst responsible for analyzing mainframe data feeds to the Confidential Billing System and working with the developers to identify and resolve code and interface issues.

Confidential, Atlanta, GA

Sr. Business Analyst

• Business Analyst/Test Analyst for the Confidential Consumer Technology Group. Responsible for User Acceptance Test (UAT), troubleshooting, and administration of the Siebel application (within the Consumer Desktop Platform).
• Responsible for ongoing development and maintenance of valid and repeatable Test Cases to verify/demonstrate detailed requirements for both the Siebel and legacy ordering applications.
• Responsible for testing of the IVR system options and its interface / smooth transition into the Customer Call Center Consumer Desktop Platform.
• Participated in upgrade from Siebel 7.5 to Siebel 7.8 platform. Responsible for analysis and interpretation of business requirements to ensure system design met the desired business functionality.
• Responsible for creating user documentation and training of Confidential UAT group on the new Siebel platform/functionality.