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 at 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;
• AT&T legacy systems (SOCS
• RNS
• CABS
• BOCRIS
• RSAG
• LFACS
• VA legacy systems (Benefits Gateway Services).

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Data Conversion Analyst

Responsibilities:

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

Confidential, Atlanta GA

Application Architect

• Application Architect, responsible for retirement of existing Order Manager System and the conversion/transition of its functions to other new and existing Confidential Systems.
• Subject Matter Expert and Conversion Analyst for the transfer of data from retired system to its predecessors.
• SQL Reporting Analyst, responsible for creating and providing the customer with daily and weekly reports to track order activity and volumes for the retiring system.

Confidential

Data Architect

• Data Architect, responsible for data creation and manipulation in the Confidential production and test environments. Role required the analysis and interpretation of user and system requirements in order to develop/locate data for testing. Involved detailed analysis of billing data and accounts to ensure future changes to billing systems were adequately tested.
• Technical Architect, responsible for analyzing the existing production and test environments in order to develop/form suitable environment for SRT testing.
• Program Manager responsible for status, timelines and project deliverables for the SRT effort.

Confidential

Network Delivery and Order Manager

• Business Process Analyst, responsible for reviewing Third Party Vendor Conceptual and System designs to ensure business requirements were met. Actively participated in requirements and design reviews between vendor and business customers.
• Application Architect, responsible for understanding requirements and assisting developers in understanding/implementing these requirements. Served as application architect / application expert through all phases of the System Development Lifecycle.
• Business Analyst responsible for training and assisting business unit with changes to daily work tasks and procedures due to implementation of a new Work Item Manager system. Also responsible for implementing temporary workarounds when system defects were uncovered. Worked with business unit to analyze and document proper work tasks, documented procedures for workarounds (until system fix could be implemented) and relayed information back to vendor in order to implement an appropriate system fix.
• Application Support Specialist, responsible for analyzing issues, determining root cause, and reporting defects. Also responsible for daily system administration and installation/upgrades of vendor software in test and production environments.
• Functional SME (Subject Matter Expert) for service order creation and management, providing expertise and detailed impact analysis to Confidential Senior Executives.
• Liaison between testers, end users and developers.
• Team expert/resource for issues involving Confidential legacy systems (several years of experience with SOCS, CABS, BOCRIS, RSAG, LFACS, etc.).
• Part of team to analyze, design, code and test additions/enhancements to 3rd Party vendor software.

Confidential, Atlanta, GA

Integrated Data Network Initiative

• Managed schedules of Confidential teams building new interfaces to 3rd party vendor application.
• Responsible for initial implementation and troubleshooting of various interface technologies into the new application test environment, including EDI, CORBA, XML, FCIF, Visibroker, WMC, TopCOM, MQ Series, Connect:Direct, Navigator.
• Responsible for understanding functional and technical requirements of new application.
• ssisted 3rd Party Vendor and Confidential Interface teams with troubleshooting and design of interfaces.
• Liaison between Testers, Business Users, Local Developers and 3rd Party Vendor.
• Assisted testers with troubleshooting both functional and technical issues.
• Acted as application expert for the Delivery Order Manager portion of new solution.

Confidential

Application Architect

• Review and analysis of conceptual designs for Billing Interfaces to WCC.
• Liaison between the Carrier Access Billing System (CABS) organization and the WCC Interfaces group.
• Analysis of the proposed Siebel system environment in order to map/coordinate data from the CABS Interfaces.
• Participation in application design and documentation of the WCC Contract Management project (Business Data Manager) including Project Charter, all phases of test planning, conversion planning, and system architecture documentation.
• Participation in all phases of system test, including planning, documentation and execution.
• Coordination of defect tracking process and resolution of defects.
• Liaison between Documentum Developers (third party vendor) and user group.
• Worked with user group ( Confidential /AMS) to refine system requirements and incorporate into overall system designs.