SUMMARY

• Over 10 years of professional experience in detail - oriented Data Analysis & Database Management
• Substantial analytical, technical and problem solving skills combined with a strong cross-functional understanding of business processes and information technology needs
• Ability to work closely with business users to understand their data & reporting needs
• Experience in managing accuracy and integrity of various data systems
• Proficient in design and development of reports and dashboards to support business analysis for corporate wide reporting using SSRS, Tableau, SQL, MS BI tools & Crystal Reports
• Strong proficiency in multi-vendor coordination for successful system implementation & integration
• Extensive experience in providing support and training to end-users
• Excellent project management, communication, analytical, interpersonal skills and ability to perform independently and as part of a team

TECHNICAL SKILLS

• SQL
• Tableau Desktop
• Business Intelligence Development Studio (BIDS)
• MS SQL Server 2008
• SSRS
• SSAS
• SQL Server Query Analyzer; Visual Studio
• MS SharePoint
• Microsoft Access
• Abila netFORUM CRM
• SumTotal LMS
• Reporting and Analysis Solutions
• MS Office
• SFTP

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Provide insightful clinical analyses for the network s clinicians and administrators
• Provide reports that highlight variations in utilization, clinical practice, patient satisfactionPaid for Performance and clinical outcomes using cubes
• Perform exploratory data analyses of reports and datasets
• Collaborate in evaluating the clinical impacts of various quality improvement and cost reduction interventions
• Perform analyses of patient characteristics that are associated with particular health outcomes or future use of health care services
• Work with Tableau to create dashboards, Stories and other visual displays, to provide clear and insightful views of performance
• Work closely with users to identify reporting needs, define report specifications, and produce reports that help them guide business decisions
• Conduct detailed audits, quality reviews, and ad - hoc reporting as needed
• Collaborate with Information Services in developing and deploying reporting tools to meet the broad spectrum of analytical needs across our delivery system
• Optimize recurring reporting processes to inform existing and emerging care delivery systems
• Identified and created workflow procedures and/or system configuration modifications

Confidential

Information Systems Senior Specialist

Responsibilities:

• Used SSRS & BI tools to develop KPI reports and dashboards for Executive use
• Created stored procedures in SQL Server to create reports in SSRS and publish them in the netFORUM for staff to use on ad - hoc basis
• Maintained statistics of Information system operations for internal and external reporting
• Created & automated complex financial reports in AMS for Accounting staff use
• Developed, reviewed and evaluated Information Systems resources, policies, and procedures
• Provided advice and assistance with complex data acquisition and collection situations
• Prepared and presented training material for educational instruction to staff on the use of department applications and software
• Developed user and technical documentation of the new features and functionality for staff to use
• Trained staff on regular basis to enable them efficiently leverage the systems
• Responsible for maintaining integrity of two database systems by constant monitoring and analysis
• Created system reports and data extracts in order to monitor appropriate use of the system
• To increase the accuracy of the data, regularly built & ran reports to identify any data anomalies
• Responsible for the deployment of the software upgrades of the CRM systems
• Responsible for resolution of user & data issues in the system via internal ticketing tool
• Provide technical support to staff members and train them on proper query techniques
• Worked closely with vendor for system implementation/integration; issue resolution and new features
• Led upgrade of systems and modules by reviewing material; drafting testing scripts and collaborated with team to test functionality
• Provided guidance and recommendation involving program modifications or upgrades that interface with database software as needed
• Responsible for creating, editing sites & libraries in MS Share Point

Confidential

Project Manager

Responsibilities:

• Provided technical and project management support to several clients
• Responsible for production timetables and regular status reporting to the client
• On - point for all client/project team coordination and overall client satisfaction
• Responsible for building workflow from group planning session and capitalizing on competencies of technical and design team
• Wrote and executed test plans based on the Work Flow Analysis for quality assurance
• Created SQL reports for the different clients

IT Specialist

Responsibilities:

• Analysis of client business systems and requirements
• Performed Work Flow Analysis to document implementation processes
• Created specifications and scenarios for data integration between various systems
• Performed data cleanup, data exports, and reporting in SQL Server
• Implementation documentation and client user training & support
• Created test plans for the enhancements to client database management systems
• Created and edited several training course manuals

Confidential

Database Coordinator

Responsibilities:

• Responsible for management of system and data of the certification management tool zapCertify
• Performed regular analysis of data to identify & eliminate data anomalies
• Created automated & ad - hoc reports & dashboards using SQL queries and Crystal Reports
• Handled issues from system users and managed problem tickets to resolution
• Created over 100 change requests to fix system deficiencies and procedural enhancements
• Performed extensive testing to ensure that ETL of data into system went without any exceptions
• Project management and served as technical liaison with vendors for system issues and general health
• Coordinated/managed meetings with PES, Cyzap, TMAR, SHRM IT, and SHRM Accounting
• Ensured completion of five high-profile projects by using pro-active management and consistent follow- ups
• Responsible for updating Confidential .org web content using a content management system
• Provided staff training on core business applications
• System backup and disaster recovery planning
• Took initiative to install the MSDE version of the SQL server to restore database backups theirby saving Confidential ver $10,000 in initial and recurring monthly costs
• Setup procedures with Cyzap to perform monthly database downloads and create archives