SUMMARY:

Senior Systems Analyst with extensive business experience serving as project lead in software implementations, data analysis and reporting, vendor relationships management, design and support applications that improve operations, enhance system functionality and process redesign across the healthcare, non - profit, academic and banking sectors.

CORE COMPETENCIES:

• Project management; highly proficient in handling multiple projects with the ability to quickly learn new technologies within fast-paced environments
• Demonstrated success working in a team-based environment and ability to manage projects with geographically diverse teams and vendor partners
• Strong analytical, organizational, detail-oriented, communication and problem-solving skills

TECHNICAL SKILLS:

Languages: HTML, Javascript, C

Platforms: Visual Studio .NET

Applications: MS Office, MS Project, MS Visio, SharePoint, PowerCAMPUS, Naviance College Prep Tools

Databases: SQL Server

Other: Content Management Software, Crystal Reports, Dreamweaver, SQL Server Integration Services (SSIS), Microsoft SQL Reporting Services (SSRS), Business Objects XI Desktop Intelligence, Web Intelligence, Universe Designer, Teradata SQL Assistant v.15, SAS Enterprise Guide 7.1

PROFESSIONAL EXPERIENCE:

Confidential, Wallingford, CT

Business Info Developer

Responsibilities:

• Write programs, queries and reports against data warehouse to pull medical, pharmacy, dental, vision claims and provider data using Teradata SQL Assistant and SAS Enterprise Guide; produce web based and pivot table reports for business users and analysis to enhance reporting functionality and that help identify trends and aberrancies based on captured data
• Serve as a tester for Change Management Board with new development of standardized reporting and ad hocs using the data warehouse; perform QAQC of SQL scripts, queries and functional user acceptance testing (UAT)
• Create documentation and conduct training for web-based report library

Senior Business Info Analyst

Confidential

Responsibilities:

• Created and supported Large Underwriting department’s report library utilizing Teradata SQL queries, Business Objects and SAS EG tools; created, analyzed and published reports to SharePoint sites.
• Managed and created Performance Guarantees, volume, utilization, and financial reports to enterprise for trend and performance tracking on a monthly and quarterly basis.
• Created documentation on Report Library and provided training to staff on reporting procedures.
• Revised and automated reporting process by creating quality and test checkpoints as a proactive measure during project cycle. Reporting time is now reduced to 2 days instead of a week.
• Participated in various systems enhancement projects for Confidential ’s Data Warehouse (AEDW) developing business / technical requirements, test and deployment plans while collaborating with management, developers, and cross functional staff using the SAS and Business Objects tools.

Confidential, Wallingford, CT

Systems Analyst

Responsibilities:

• Served as project lead and report developer for enterprise applications used by faculty, staff and students; wrote technical and business process documentation; led vendor evaluation and analysis for new systems implementation projects.
• Implemented Electronic Health Record management system for health, athletics and counseling departments. Electronic Health Record system was used to manage medical, athletic, counseling and billing health records. Collaborated with Software As software (SaaS) and claims processing vendors, configuring data extractions, payments and claims processing.
• Designed web-based ASP.NET Internet applications and enhancements linked to firm-wide SQL databases; served as project manager to build custom web based forms for student registration, functions, and school-wide events and Summer Programs department.
• Configured, tested and deployed SSIS packages for ETL data load functions across multiple database systems and automated claims processing and payment functions; managed data migrations including text and XML files between student information systems including CoursEval, Summer Programs, enrollments, and Naviance College Planning systems; initiated process improvement functions post implementation.
• Served as a report developer for faculty and staff utilized Microsoft SQL queries and Crystal Reports; provided technical analysis, developed checkpoint queries and alerts to ensure data integrity and accuracy between various student information systems and other applications

Confidential, Waterbury, CT

Data Quality Analyst

Responsibilities:

• Managed cardiac database for company and Saint Mary’s and Waterbury Hospitals and created reporting library utilizing Microsoft SQL Business Reporting Services (SSRS).
• The database application was utilized to submit data to national and state registries.
• Established and automated validation processes for clinicians and management for data submissions and quality review. This has resulted in lower costs with resources, a quicker turnaround in evaluating patient outcomes and providing timely quality reports.
• Developed SQL views, queries and reports and modified XML files in data warehouse for trend analysis, reporting and outcomes improvement efforts; created custom application forms and database fields for process improvement.
• Collaborated with vendors, users and IT staff on application and database upgrades; conduct monthly maintenance tasks for database application.
• Served as Project Manager in process improvement for overall Heart Center quality data operations.
• Spearheaded user Quality Committee that oversaw data outcomes after each submission while improving data submission process.
• Served as web designer for redesign of company website and content infrastructure using Content Management software. Managed company’s Facebook and Twitter social media campaigns and created social media and marketing campaigns for community-based initiatives
• Developed electronic internal and external newsletters for Heart Center personnel and community as a tool to foster unity, and educate public on Heart Center programs, news and health initiatives.