Data Analyst Resume
Darlington, SC
SUMMARY:
- Expertise in data mining and analysis, report design and deployment
- Expert in business process engineering and software development life cycle, including analysis, design, development, testing and implementation of software applications.
- Expertise in serving as liaison between IT and business.
- Adept at reducing development costs and providing traceability of projects.
- Extensive experience managing people and/or projects.
- Excellent people, communication, analytical, interpersonal, and presentation skills; expert at managing multiple projects simultaneously.
- Quick study, able to multi - task and work with limited supervision with a proven track record of success.
TECHNICAL SKILLS:
Databases: Paradox, MS Access, SQL 2014
GUI/Tools: MS Office, Access, Excel, MS Project, Visio, PowerPoint, Outlook, SQL Server Management Studio, Crystal Reports, Business Objects, SharePoint, Power BI
PROFESSIONAL EXPERIENCE:
Confidential, Darlington, SC
Data Analyst
Responsibilities:
- Provide technical expertise on data storage structures, data security, data quality, data mining and data cleansing
- Implement practices to ensure compliance with HIPAA regulations
- Query development for data analysis and metric generation
- Design and manage the reporting environment, including data sources, integrity, user accessibility and security
- Provide quality assurance of imported and exported data
- Support initiative for data integrity and normalization
- Produce ongoing ad-hoc reporting and analysis
- Development, maintenance and distribution of production and management reporting
- Access operational and financial risks of system enhancements and upgrades
- Train end users on reports and dashboards
- Developed Business Objects ad hoc reporting from McKesson Enterprise Rx (a cloud-delivered pharmacy management system), creating custom data extracts to meet pharmacy production and financial reporting needs.
- Developed and provided quarterly data mining and file production of clinical data delivered to a healthcare analytics firm whose initiative has led to new opportunities for improved access to healthcare and better management of cardiovascular disease in the southern U.S.
- Created and maintained MS Access database to which extracts were imported daily for data mining and analysis.
- Coordinated with COO, pharmacists and subject matter experts to develop lookup tables, queries and reports in MS Access to manipulate data (500k + records) and produce concise, timely and actionable daily production reports that led to improvements in queue management, business process improvements, decreased required re-work and increased profitability.
- Produced analysis and financial reporting for senior management in Access that linked to MS Excel pivot table with pharmacy financials. Responsible for data analytics and data visualization.
- Worked with HR and key stakeholders within the business to develop company-wide employee evaluation process using automated MS Excel worksheet.
- In the process of re-engineering all aforementioned MS Access analytics using SQL Server Management Studio and Power BI
Confidential
Operations Manager
Responsibilities:
- Manage teams of installers/refinishers
- Assess operational and financial risks for residential and commercial projects
- Coordinate projects; Communicate changes and progress; Compete projects on time and budget; Manage project team activities
- Prioritize projects based on urgency and customer demand
- Effectively delegate tasks to team leaders/members to ensure customer satisfaction
- Serve as chief point of contact with regards to customer communication, ensuring customer needs and expectations are met or exceeded
- Advise upper management on production issues related to problems identified on site and make recommendations for efficient and cost effective remediation
- Complete, maintain and process pertinent computer software and paperwork
- Understand business implications of decisions; Display orientation to profitability; Align work with overall strategic goals
Confidential
Vice President, Management Reporting
Responsibilities:
- Managed a team of analysts serving senior management executives with department-wide, mission critical managerial reporting and data analysis.
- Solely responsible for 1,200 employee department’s 40 page weekly and monthly summary reporting.
- Analyzed data from disparate sources and produced reports to highlight efficiency opportunities in functional departments.
- Established data collection standards and conducted vendor risk assessments for external data feeds.
- Assisted in data gathering and analysis in developing departmental annual $25M budget.
- Served as main point of contact for internal and external audits. Gathered data and provided analysis and participated in projects to improve the process. Experienced Data Analyst with extensive experience performing data modeling, data mapping, data cleansing, and building data dictionaries. Expertise designing, implementing, and supporting Enterprise-grade technical solutions meeting complex business requirements.
- Developed capacity models utilizing MS Excel to analyze department staffing needs based on volume fluctuations and business process changes resulting in proactive approach to staffing, business processing reengineering efforts and outsourcing opportunities.
- Developed MS Access data repository and reporting tool for gathering expenses at the cost center level which resulted in increased accountability and reduced overall department expenses.
- Successfully managed vendor relationship with multiple international outsourcing companies with respect to data exchanges. Developed vendor scorecards to track performance vs. goals.
- Selected to participate in Washington Mutual’s “Roadmap to Leadership Success” program, designed to train, evaluate talent and promote successful mid-level managers into senior management roles.
Confidential, Florence, SC
Senior Business Analyst
Responsibilities:
- Identified appropriate internal and external data sources required for analysis and reporting of key performance indicators (KPI) and coordinated data feeds to populate necessary data repositories.
- Developed robust and time-sensitive reports to measure department performance against goals.
- Evaluated effectiveness of new applications and business processes, comparing results to original proposals to ensure best practices are met.
- Developed and maintained queries and programs for accessing, extracting and analyzing data. Interpreted results and communicated findings with department heads.
- Understood and provided support and data analysis during internal and external audits. Communicated conclusions, audit concerns, exposure risks and participated in corrective action plans to mitigate risks.
- Created a means of collecting inter-departmental data from several work units and disparate data sources in an effort to provide senior management with an accurate and timely end to end cycle time analysis. Used Crystal Reports to develop dynamic reporting tool, the results of which resulted in multiple business process reengineering projects that reduced overall department cycle time by 35%.
- Designed and developed database application in MS Access as a project tracking tool.
- Implemented and trained users on database application.
- Developed, database instruction manual presentation on Power Point.
- Designed and developed various reports that satisfied management s weekly time reporting.
- Performed all DBA related responsibilities, including repair and maintenance.
- Modified existing MS Access databases used to capture government loans and developed robust reports to accurately track department performance against government regulations. Results and business process reengineering that followed mitigated risks, increased processing time and resulted in significant cost savings.
- Selected as a Washington Mutual Home Loans Summit Club Winner - 2004 for outstanding performance.
Confidential, Oakbrook Terrace, IL
Senior Business Analyst
Responsibilities:
- Liaised with system users and IT.
- Responsible for strategic analysis, planning, communication and translation of Global B-2-B trade exchange business requirements into Product Development Objectives.
- Created specific deliverable expectations for Engineering/Systems Development and then delivered and evangelized resulting products/processes to various business units.
- Established controls to ensure data quality, security and appropriate user accessibility.
- Conducted vendor risk assessments pertaining to external data feeds.
- Identified critical and non-critical datasets and assisted in the improvement and maintenance of data quality and integrity.
- Proactively identified inefficiencies in system use from technical and process viewpoints and proposed changes that included process redesign and/or system enhancements. Responsible for requirements gathering and responsible to interpret business process and business data models.
- Liaised with Outbound Marketing Group to define and deliver customer, and customer acquisition-focused materials.
- Provided an independent analysis of data quality and recommended repairs when appropriate.
- Assisted in the on-time business delivery of major content management and database-driven transaction processing trade exchange system, resulting in the consolidation of disparate global legacy systems.
- Participated in the functional definition, testing and coordinated delivery of customer self-serve Internet trading system.
- Responsible for planning and successfully of U.S. employees with respect to new systems, including business process re-engineering definition and deployment.
- Assisted in the functional definition and delivery of three major enhancements to the trading engine within six months of initial release.
- Established requirements and assisted in the implementation of an accurate and successful data translation/mapping from legacy systems to newly designed software solution.
Confidential, M ilford, CT
VICE PRESIDENT
Responsibilities:
- Reported to the CEO, serve as liaison between system users and IT.
- Managed all technical and telephony vendor relationships.
- Identified and managed system enhancements to ensure continual software and hardware development.
- Provided business expertise to system users with respect to use of the system, techniques, data elements, best practices and standards.
- Successfully planned and implemented four business acquisitions, which included coordination of software conversions, data migrations and validation, end-user and the development and distribution of customer marketing plans
- Sold and successfully implemented and supported proprietary software to ten regional trade exchanges
- Developed manual, conducted successful company-wide sessions resulting in consistent and common business practices
- Successfully negotiated existing telephony contracts for a 30% cost savings
Confidential, Hyannis, MA
DIRECTOR OF OPERATIONS
Responsibilities:
- Reported to the CEO, provided critical leadership in all areas of the business.
- Solely responsible for staffing, and management of daily operations.
- Led sales effort, marketing and revenue generation efforts.
- Managed all vendor relationships.
- Solely responsible for company P & L.
- Represented the business in the local community and at National Trade Association conventions.
Confidential, Hartford, CT
ASSISTANT MANAGER, NEW BUSINESS MARKETING
Responsibilities:
- Prepared formal marketing proposals for 10,000+ employee sized new business submissions.
- Authored tailor-made responses to detailed consultant specifications, questionnaires and complex financial requests.
- Proposed solutions to prospects’ employee benefit issues, with an emphasis on managed health care.
- Participated in sales presentations and claim office demonstrations.
Confidential, Hartford, CT
SOFTWARE DEVELOPER
Responsibilities:
- Developed, maintained and enhanced employee workstations.
- Developed, maintained and enhanced New Business Prospect Information system (Paradox).
- Developed new approaches to collect and analyze data for reporting purposes.
- Provided technical support, with an emphasis on marketing for customer briefings, sales presentations and claim office demonstrations.