Data Consultant Resume

Summary

5 yrs of hands-on experience with Relational Databases, SQL, and Business Intelligence (BI) solutions
Advanced experience in Microsoft products such as Excel, Access and PowerPoint
Knowledge in importing data for use in reporting software, spreadsheets, graphs and flowcharts
Knowledge and experience with report writing tools, particularly SQL Server Reporting Services (SRSS)
Customer-facing consulting exp in Health Care, Communications, High-Tech, Manufacturing, and Retail industries
Adept at working in a high-pressured environment, maintaining workload, and driving projects to closure
Ability to lead, inspire, and promote a team environment

Experience

Confidential. May 2011 - PresentData Consultant

Develop complex reports using custom SQL scripts to extract and present data including but not limited to patient chart info, ICD-9 or ICD-10 codes, etc.
Develop SQL queries and/or procedures and functions for complex data requests.
Customize database by loading hospital-specific data using text/csv files created/formatted in Microsoft Excel and imported into Microsoft SQL Server via T-SQL.
Provide analysis and insight into completed reports created via SQL code
Participate in 8-to-10 months long Hospital ED (Emergency Department) software implementation cycles
Formulate recommendations based upon analysis of data and trends
Troubleshoot client application using Remote Desktop Protocol (RDP) to fix issues while operating within HIPAA regulations
Facilitate 3-day training classes monthly for new/existing clients on the practical uses of IBM Cognos reporting software

ConfidentialJuly 2008 – May 2011Telco Billing Data Analyst

Maintained/created SQL Server database structures such as tables, views, and stored procedures.
Troubleshot data related issues and provided solutions.
Analyzed and develop new local provisioning process documentation, business requirements, and system upgrade recommendations. New documentation cut the new hire training and on-boarding process from 2 weeks to 3 Days. System upgrades helped current employee manage workload and save tremendous time in addressing high priority action items.
Coded custom queries and automating selected reports for end-user. Designed and created a unique hands-off reporting structure that saved time spent on bill run analysis and research by 43% on average.
Performed business process modeling
Supported data extraction, analysis, and reporting requirements using Microsoft SQL Server BI 2008
Conduct regression testing before system upgrades
Performed customer account audits to validate provisioning and usage rating processes:
Investigate and correct problems for lines of service (POTS, UNE-P, etc.), if processes break down
Collaborated with product development on specifications
Maintain documentation for compliance and state regulatory purposes

ConfidentialJuly 2004 – June 2007Consultant (Business Analyst), Consumer Products and Distribution

Collaborated with technical and functional specialists to deliver creative solutions to fortune 500 customers
Supported business transformation projects for customers from several industries (retail, technology, investment banking, and manufacturing)
Performed hands-on data extraction and collection; analyzed data using MS Access (SQL) & Excel supporting several functional areas (including but not limited to purchasing, sales, accounting, and finance); provided forecasting reports and recommendations
Facilitated requirements gathering and analysis as a part of client implementation lifecycle; completed corresponding process analysis, test cases, and documentation
Performed as a functional lead to audit, assess, and expose business loss areas and recommend improvement opportunities to streamline operations and reduce overall shrink
Designed/Implemented various types of IBP (Interim Business process) solutions, adapting to current system design, enabling the enhancement of system-business process interaction for a leading manufacturer
Created/Managed backlogs of requirements and worked with various stakeholders to prioritize the backlog

EducationB.Sc.�in Business Management�
Major: Business Management
Minor: Management Information System (MIS)Training

SAP Business Information Warehouse (BW) 7.0
Synchronization and alignment of BW master data w/ design of BW info providers & database extractors
Data loads based on various methods including Full and Delta loads
Creation/maintenance of complex queries incl. Calculated KeyFigures, Restricted KeyFigures, and Formulas
Creation and maintenance of reports with BEx Analyzer & BEx Browser
Design of custom cubes, ODS, Extractors, Multiproviders, etc.
Activation of business content & data sources from R/3 (creation of flat files to load the legacy data)

Computing Skills

Flow Diagrams
Advanced SQL
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
Crystal Reports (SAP BusinessObjects) 9
MS Office 2010 Suite of Applications – Word, Excel, Access, PowerPoint, Visio, and Outlook
HTML and Perl Scripting Language