Business Intelligence Analyst

Page * of *

Michelle A. Smith

(c) *** – *** – **18 (e) **************************@*****.***

PERSONAL STATEMENT

I am passionate about delivering bottom line impact to my employers by mining available data and presenting it in a way that enables them to make smart decisions fast. I have 15+ years’ Business Intelligence experience using a diverse technical skill set to successfully manage shifting business priorities. TECHNICAL TOOLS

SQL Server Studio • SSRS • Teradata • PL/SQL • Toad • OBIEE • SAS Business Objects • MicroStrategy • Visual Studio • VBA • MS Excel MS SharePoint • MS Visio • MS Project • MS Access • MS PowerPoint KNOWLEDGE AND COMPETENCIES

Strategic and tactical troubleshooter with strong root cause analysis expertise

Committed to promoting employer’s Mission, Vision and Values throughout all work endeavors

Performs well under fire, leading the way, setting the example, establishing the work environment

Communicates and interacts effectively and professionally with all organizational levels and clients

Successful with leading and mentoring technical teams

Completed AutoTrader.com’s 14-month internal management/leadership training series

“Manage Smarter”

Completed Technology Association of Georgia’s 12-month leadership program “Women In Technology - Careers In Action” (sponsored by AutoTrader.com)

PROFESSIONAL EXPERIENCE AND ACCOMPLISHMENTS

CENTENE: PEACH STATE HEALTH PLAN ATLANTA, GA 02/2016 - 05/2016 DATA ANALYST IV: Provided advanced analytical support using SSRS, SQL Server Studio, Teradata and VBA. GENTIVA HEALTH SERVICES ATLANTA, GA 04/2014 - 07/2015 PROGRAMMER/ANALYST, LEAD: Built and published MicroStrategy reports, documents and dashboards. EMORY UNIVERSITY ATLANTA, GA 11/2012 - 09/2013

RESEARCH INFORMATICS ANALYST: Provided biomedical informatics, technical standards and methodologies in support of the Organ Transplant Team. Voluntary exit due to family health crisis. PYRAMID CONSULTING ATLANTA, GA 04/2012 - 10/2012

COX COMMUNICATIONS – PL/SQL DEVELOPER: With a small team, built a reporting application capturing data from Oracle and presenting it via an advanced Visual Basic customization of Microsoft Excel. AUTOTRADER ATLANTA, GA 09/2005 – 08/2011

DASHBOARDS & SCORECARDS: Designed and built status reporting systems; saves several person-hours per department per day. Employed SQL, advanced MS Excel (VBA), MicroStrategy, SharePoint and MS PowerPoint for this report set. These products drive successful achievement and evolution of KPIs. Attended Stephen Few’s ‘Visual Information’ 3-day class in preparation for this work. PERFORMANCE REPORTING – APPLICATION SUPPORT TEAM: Designed and built reports to establish existing team value and progress toward goals. Primarily used MicroStrategy, PL/SQL and MS Excel to create and maintain these reports. Won ‘IT Unsung Hero’ award for this work. AD HOC REPORT PROGRAMMER – BUSINESS INTELLIGENCE: Wrote data mining programs to answer questions brought by internal customers (sales, marketing, customer operations, etc.) and external clients

(via sales staff). Primarily used PL/SQL, SAS and UNIX to access Oracle databases. Won achievement spot bonus for creation of reports that measure use of ‘Research and Compare’ page site features; these reports establish the value of the site features for top tier customers. MICHELLE A SMITH

**************************@*****.***

404 – 547 – 0918

Page 2 of 2

LOCKHEED MARTIN (Contract Position via SM&A) Marietta, GA 2002 – 2003 C-130J Commercial Engineering Change Proposal Division (CECP) SOFTWARE ENGINEER: Analyzed business process and identified opportunity to streamline multiple departments’ efforts from Statement of Work (SOW) to Basis of Estimate (BOE). Designed this cost-saving process as a new component of the existing CECP web-enabled database to control content, schedule and assembly of submissions from each Individual Process Team (IPT); this process saves several person-hours per department per day. WEB DATABASE ADMINISTRATOR: Updated physical database and/or stored procedures, views, functions and other database objects in test environment. Effectively used cursors, temp tables and other tools to implement end user action requests and restore non-performing systems. Coordinated required downtime for migration of tested changes with end user absence. Provided on-call technical support. Provided documentation for software design cycle. Wrote on-screen and hard copy user manuals. PROPOSAL COORDINATOR: Designed, built, trained users and maintained the Commercial Compliance Matrix for the Royal Air Force Defensive Systems (RAFDS) proposal. Ensured absolute accuracy and completeness of all information submitted. Final submission resulted in a new process standard for the C-130J CECP Team. Accountable to meet laws governing defense contracting. ROBERT HALF San Francisco, CA 2000 - 2002

Information Technology Consulting

Designed and Built Relational Database Management Systems (RDBMS) for key clients. TRI Financial: HUD-Insured Subsidized Housing Community Project Development Mortgage Broker Designed system architecture effecting business migration from hard copy to electronic submission of information required to secure HUD Insurance on community projects valued to several hundred million dollars. This both increased the accuracy and decreased the time required for submission, thereby improving revenues and enhancing customer relationships. PricewaterhouseCoopers: Consultant - Administration Division. Designed, built and launched new, user-friendly application to manage communications for several hundred consultants. This allowed a small number of on-site staff to provide both a smooth relocation to a new building site and a seamless transition to a new hoteling system. Commended for providing thorough yet easy to understand technical writing and for designing innovative technical training programs.

PACIFIC GROWTH EQUITIES San Francisco, CA 1999 - 2000 Investment Banking Boutique; recruited by former partner at prior employer Volpe, Welty & Company. RELATIONAL DATABASE DESIGNER: Designed database which coordinates the flow of information between two departments involving several levels of rights and permissions to control confidentiality of information as required by the federal government.

CORPORATE FINANCE DEPARTMENT ADMINISTRATION: Set up administrative systems for new, fast growing Corporate Finance Department. Accountable for task management and document submission for multi-million dollar transactions in keeping with SEC regulations. Automated job descriptions by programming job-based custom desktop(s) including customized help menus and shortcuts using MS Office products and VB. Provided electronic and hard-copy documentation for each. EDUCATION

Master of Arts (MA) coursework, Linguistics, San Francisco State University Bachelor of Arts (BA) coursework, English, San Francisco State University Associate of Arts (AA) degree, Psychology, Los Angeles Pierce College

Contact this candidate