Business Analyst Resume Profile, TX - Hire IT People

RELEVANT EXPERIENCE

Client interfacing role with gathering business requirements and implementation.
Data analysis reporting solutions through the use of SQL scripts
Development of web based enrollment and plan comparison tools
Full lifecycle development of ETL processes data mapping, translation, loading
Established time needed in development and testing in order to determine project pricing
Proven effectiveness in communicating to both business and development teams throughout change process
Brokering resolution in difficult situations, setting realistic deadlines for client
Establish test cases and tested enhancements, partnering with development for any modifications

CORE SKILLS

Roles: Business Analyst, Data Analyst, ETL Analyst, QA Analyst, Team Lead

Tools Methodologies: SQL Server, Access, Excel, Visio, Word

Industries:Health Welfare, COBRA, Retail, Education, Mortgage

CAREER HISTORY

Confidential

Business Analyst - Telecommute

Create scripts for adhoc and SSRS reports in SQL Server - applying joins, embedded queries, calculated fields, and aggregate functions
Issue Resolution Utilized data mining, replication, negative testing and factor in downstream and cross-functional implications when formulating a solution
Implemented 834 file facilitated all steps in software development lifecycle
Develop web-based benefits solution for large market employer 80,000 participants . Translate plan design rules and eligibility, determine scope, and ensure content and functionality met requirements through user acceptance testing.
Through process improvement, standardizing and documenting, was able to transition billing process to lower cost associate.
Use tools like share screen and WebX to effectively work with others virtually

Confidential

Business Analyst

System and table setup for health benefits eligibility and letter platform.
Create SQL reporting in relational database for data manipulation and mining purposes.
Created process rules for Web Enroll Solution - Allowed for linking of health benefits PDF to client defined populations.
Implemented file interface prototype by creating file specifications, data mapping, and data processing rules for data feed process. Created test cases and worked with development on process refinement. Established and met project benchmarks.
Analyze output error reports on file exchanges, identify opportunities for process improvement and risk mitigation.

Confidential

IT Data Analyst, Contractor

Applied understanding of Best Buy's data structure in order to drive reporting solutions.
Integrated new data sources to minimize issues in Subscription Software Team workflow, saving 15,000 annually in processing time.
Represented team's interest in cross-functional team regarding Best Buy POS enhancements/issues
Negotiated with IT to recover 20,000 transactions, prioritize resources to identify and resolve systemic issues.
Re-designed two MS Access databases with complete suite of forms, queries and macros.
Added functionality to enable new reporting metrics such as issue aging.

Confidential

Reporting Analyst/Team Lead

Built reporting executables for financial process improvement.
Automatedrefunding process, saving 800 staffing hours annually.
Represented team's interest in ERP implementation project, ensuring that delivered product met business requirements.
Consolidated two years of quarterly spreadsheets into a MS Access database, gained reporting capability on key measures such as account aging and volume.