SUMMARY:

Highly organized problem solver with significant and progressive experience in data analysis and report design. Demonstrated success in implementing IT projects. Experienced in interfacing with subject matter experts, developers, vendors, and senior management. Excellent communicator with emphasis on building strong customer relationships.

CORE COMPETENCIES:

Data Analysis | Report Writing | Database Design Data Modeling & Transformation | Leadership

TECHNICAL SKILLS:

Structured Query Language (SQL)

Team Foundation Server (TFS)

TOAD

SDLC/AGILE Methodology

Data Warehouse (Oracle, Informix, Microsoft SQL Server)

Microsoft Office: Access, Excel, Word, PowerPoint, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Morrisville, NC

Business Analyst

Responsibilities:

• Perform analytical skills necessary to define requirements for reporting products, design reports that successfully meet business needs.
• Collaborate with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs.
• Closely collaborate with Quality Assurance and Software Development to ensure that the delivered products exceed customer expectations.
• Review database designs and queries to assess whether they meet business requirements.
• Receive and respond to feedback from user acceptance testing.

Confidential, Cary, NC

Data Analyst, Medicare Risk Adjustment

Responsibilities:

• Collected information and gathered resources, arming business leaders with necessary tools to make smart strategic and tactical decisions, and contributing to success of MRA business strategy.
• Created Microsoft Access databases using macros, reports, forms and queries through SQL scripting, importing and transforming data, and generating health provider statistics.
• Developed and designed weekly and ad hoc health provider and medical record retrieval reports using SQL Server, Excel, QlikView and Verscend, tracking performance, and assisting with annual bids.
• Developed training module, presenting virtually through WebEx to associates for refresher classes in Excel, PowerPoint, Verscend and Outlook.
• Designed SharePoint site for team workflow, education and accolades, increasing efficiency by 50% due to consolidation of touch points.

Confidential, Research Triangle Park, NC

Manager / Senior Data Analyst

Responsibilities:

• Spearheaded development of new department in RTP, NC, hiring and managing 2 data analysts, and maintaining personal workload in high - energy and fluid environment.
• Ensured effective implementation of changes and improvements to business unit performance by evaluating current methods and strategies, including gathering business requirements, developing and designing reports using data extracted from data warehouse through SQL scripts and exporting to Excel.
• Reduced number of compensatory fees assessed by client 50% while increasing customer satisfaction by producing accurate analysis and forecasting methods.
• Enabled productivity within 1st day of mortgage servicing software application conversion to new architecture by leading remediation of SQL scripts through testing, analysis, and data mapping.

Confidential, Research Triangle Park, NC

Business Analyst

Responsibilities:

• Produced monthly US and Canada chassis reports for external vendors by using MS Excel, increasing productivity.
• Reduced production of chassis reports 25% by automating reports through customization of MS Access database.

Confidential, Raleigh, NC

Interim Information Manager

Responsibilities:

• Managed external vendor and restaurant manager relationships successfully, building and maintaining working relationships.
• Ensured seamless work flow by producing weekly, monthly, and quarterly management reports, reflecting restaurant revenue and sales metrics by using Crystal and MS Excel.
• Reflected revised annual criteria by redesigning quarterly Restaurant Bonus Scorecards and quarterly Restaurant KPI Scorecards.

Confidential, Raleigh, NC

Senior Business Reporting Analyst

Responsibilities:

• Collected / analyzed data and reviewed business processes, identifying opportunities for cost control and process improvements.
• Built strong business partner relationships by interacting with all levels of management and external clients / vendors.
• Managed 3 data analysts while managing my own workload, facilitating smooth business functions, and driving organizational objectives.
• Enhanced efficiency through generating over 200 daily reports 50% by using MS Access.
• Improved efficiency of operational workflow by gathering requirements, designing, developing, and implementing workflow and operational management reports for business units.
• Upgraded 20 MS Access databases to newer version, achieving no down-time through effective project management.

Confidential, Raleigh, NC

Business Systems Analyst

Responsibilities:

• Transformed high-level business requirements for software development projects and enhancements into detailed functional specifications with minimal iterations, driving process efficiency.
• Developed functional manual and automated test plans and scripts, validating successful design, development and implementation of system and reporting deliverables.

Business Analyst

Confidential

Responsibilities:

• Conducted Joint Application Development (JAD) sessions, gathering business requirements, and ensuring successful migration of client business processes.
• Created test plans and coordinated user-acceptance testing for business units, ensuring successful software implementation.
• Led many mortgage servicing projects by creating project plans, tracking milestones and assigning resources.