SUMMARY:

• Data Analysis Business Intelligence Reporting SharePoint Database
• Solutions & support provided to a wide range of business environments with necessary documentation provided in full detail per Software Development Life Cycle (SDLC) as it pertains to the user and programmer.
• Plan Design Test Validate Production Maintenance
• Health Care, Technology, Medical/Science Research, Insurance, Financial, Legal, Accounting, Education, Transportation, Telecommunications, Military.
• Build projects with inputs and feedback from fellow developers and drive towards completion
• Excellent organizational skills including prioritizing, scheduling, time management, and meeting deadlines
• Structured thinking to decompose ambiguous questions into discrete data problems
• Build data expertise and own data quality for allocated areas of ownership.
• Security is a priority and must make sure all data is secure to the level needed.
• Multi - tasking with balancing numerous different priorities and demands in a fast-paced environment.
• Review existing basic to moderate report processes and recommend new or improved solutions that increase efficiency and accuracy and implement those solutions.
• Assess and troubleshoot small to medium scale production issues related to reports and data integrity of the information presented on reports and recommend/implement solutions for improvement where necessary.
• Strong interpersonal skills, ability to convey and relate ideas to others
• Able to interact cross-functionally with both technical and non-technical people
• Communicate clearly and effectively to stakeholders with varying business and technical backgrounds
• Well-versed in story-based reporting (on paper and in person) thoughtfully and holistically creating reports that address strategic marketing and business questions with a data-based narrative.
• Structured thinking to understand the key drivers to our business and identify how to modify them to improve business metrics.
• Collaborate with business/technical team members and end users through the project life cycle to gather requirements, determine best solutions, test solutions and demonstrate functionality to end users.
• Learns and adapts quickly to perform to get things done
• Strong sense of ownership, and an insatiable appetite for learning
• Team oriented but with the ability to work independently
• Action and able to thrive in a fast-paced, constantly changing work environment
• Research, analyze, determine capabilities, and propose solutions that address specific business needs
• Team oriented but with the ability to work independently

TECHNICAL SKILLS:

MS ExcelExpert20+

MS Access Expert20+

SQL Advance10

VBA Advance8

SQL Server 2000/2005/2008/2012/2014/2016 Advance8

MS SharePoint/Team FoundationAdvance5

Dashboard DesignerAdvance2

Oracle 8i, 10gIntermediate2

SAP Business Objects XI / Crystal ReportsIntermediate3

SASIntermediate<1

TableauIntermediate<1

JOB HISTORY:

Application & Reporting Analyst

Confidential

Responsibilities:

• BiweeklyStaff Productivity Report that details actions taken to manage patient needs with Confidential 's 5 main groups of patients
• Confidential Monthly Load Registry during 1st week of the month to processloading qualified patients to Confidential 's Registry.
• Confidential Monthly Drop Registry during 3rd week of the month to process patients who no longer qualify to be in the Confidential Registry.
• All data used with these reports and other ad-hoc reports involved using SQL to pull from EPIC Clarity data copied over from Production Servers every morning.

Environment: Windows 10, EHR database systems, EPIC systems application, MS Office 2016, SQL Server 2016, SQL Server Management Studio, MS Team Foundation (SharePoint)

Database & Reports Developer

Confidential, Stockton, CA

Responsibilities:

• HEDIS / P4P maintenance of SQL code logic for supporting HEDIS notification letters to providers and their patients to inform which services are requested to be tested for (cancer screenings, colonoscopy, etc.)
• Supported various authorization log reports for each health plan/carrier involving the approval/denial of medical claims, both commercial and Medicare lines of business. Each health plan/carrier requests their own specific template guidelines be met with accurate results (data types, column order, value formats, etc).
• Monthly member eligibility & daily claims EDI inloads into database systems for new health plan members, terminations, reinstatements, changes/updates.
• Monthly routine pharmacy patient data inloads into each database system for HEDIS / P4P reporting.
• Various on-demand adhoc reports including mailing lists, open authorizations & open referrals for specific providers for Health Services Dept.
• Oversee Monument Systems Xpress v 3.10 (legacy) to Plexis Quantum Choice 2015 database system transition.
• Demonstrated ability to work with all clinical coding systems

Environment: Windows 10, EHR database systems, MS Visual Studio, MS Access 2010, MS Excel 2010, SQL Server 2008 R2, SQL Server 2014, SQL Server Management Studio

Database Developer

Confidential, Milpitas, CA

Responsibilities:

• Developed a series of real-time dashboard reports using SSRS with MS Visual Studio for Finance/Sales.
• Reports were designed to be interactive drill-down functional reports for Bookings/Billings/Backlog; Grouped YTD month-over-month by SalesPerson totals to raw data customer totals by FY Month.
• Supported QPASe database system (Qualified Parts Automated System enabled) with MS Access.
• New forms/reports developed for QPASe.
• Monthly bill reporting of phone call histories using MS Excel/VBA.
• Salesforce maintenance adding licenses to Sales users.
• Support for MS Dynamics GP 2013 (12.0)

Environment: Windows Server 2003 R2, MS Visual Studio, MS Access 2003, MS Excel 2010, SQL Server 2008 R2, Windows 7.0.

Programmer Analyst

Confidential, Sacramento, CA

Responsibilities:

• Data extracted, using SQL, from NextGen 5.8 electronic practice management system that resides with SQL Server.
• Using SQL Server 2008 R2 for SQL Programming to build/modify reports for clinical indicators for accordance with UDS (Uniform Data System) standards.
• Providing application support with NextGen EPMS in regards to EMR/EPM records (electronic medical/patient records).
• Trained/tested for the following grant funding reports:
• NextGen ERM Memorized Reports
• HOPWA, Hourly pay rates of service
• MAI, Minority Aids Initiative
• APR/IPR (annual/interim) reports for Ryan White federal grant.
• Cardinal Registration for Pharmacy audit reporting. (cardinal.com)
• HIV/AIDS Bureau Performance Measures for U.S. Health and Human Services/Human Resources and Services Administration.

Environment: NextGen 5.8, MS Excel 2008, SQL Server 2008 R2, I2I Systems (previewed), Windows 7.0.

Reporting Analyst

Confidential, Sacramento, CA

Responsibilities:

• Managing multiple reporting ETL (Extract Transform Load) processes from relational databases, including experience working in multiple SQL Server environments.
• Moving/combining data from one server to another to combine in a single report using SQL Code in MS SQL Server Studio and SQL Server 2008 Integration Services Package Execution Utility.
• Frequent daily reporting processes include initial pulls from SQL Server Studio with aggregations in MS Access using SQL Server tables as ODBC imported tables and/or using linked tables.
• Other reports involve extracting data directly from BusinessObjects XI InfoView and Crystal Reports.
• Maintenance of multiple pivot tables in MS Excel with their data sources copied/imported from: MS Access / SQL Server studio / BusinessObjects XI InfoView / Crystal Reports.
• Report names include: Registration Denials, Missing Charges, ASC, ATB By Location, Enrollment Summary, Frequent Flyer, Trended Claims, Pre-Payments Analysis, Charity Care Patients Seen Previous Year.

Environment: MS Access/Excel ’97-2007, SAP BusinessObjects XI Enterprise 3.1/InfoView/Crystal Reports, SharePoint MOSS 2007, SQL Server 2008 R2, MS Dynamics CRM 4.0, Windows XP & 7.0.

Data Analyst/Application Developer

Confidential, Folsom, CA

Responsibilities:

• Design/develop/implement/maintain new applications to support decision processes, and provide analytical tools.
• Serve the Sales Operations group as the lead in the development and maintenance of developed Access/Excel/SQL/VB applications in a wide range of reporting projects.
• Manage applications/solutions that have one user to as many as 200.
• Develop/Oversee production assembly of SharePoint Dashboards using data connections from multiple sources.
• MS SharePoint Designer for creation of SharePoint Dashboards used with Microsoft PerformancePoint Server.
• Delivered Weekly POS and Asset Management Reports using BusinessObjects XI Crystal Reporting functions.
• Utilized BusinessObjects XI desktop Intelligence to import, modify/formulate data before exporting/importing data thru MS Access for weekly inventory reports and displaying compilation of overall monthly data in MS Excel using pivots/charts to summarize Asset Management on a 4-regional basis, Americas/Europe/Asia/Japan.
• Developed, tested, modified prototype reports using MS SQL Server Reports (SSRS) to display/illustrate real-time data to replace existing reports for future use.

Environment: MS Access/Excel 2007, SAP/BusinessObjects XI Desktop Intelligence, SharePoint MOSS 2007, SQL Server 2003, MS SharePoint Dashboard Designer, MS PerformancePoint Server 2007, ProClarity Data Warehouse, MS SSRS, Windows 7.

Database /SharePoint Administrator

Confidential, Novato, CA

Responsibilities:

• Database Administrator supporting database applications used by the Buck Institute including MS SharePoint, MySQL, Oracle 8i, MS Access.
• Administrator using SharePoint Central Administration, STSADM commands, site templates.
• Implemented SharePoint Search Server with Microsoft Server 2003.
• Maintained websites using IIS 6/7 with MS SharePoint 2.0/3.0.
• Administered users and teams using Microsoft SharePoint with Active Directory.
• SharePoint Administrator/Programmer to oversee the testing, developing, and implementing SharePoint Sites used by over a dozen labs and departments.
• Tested, maintained, and upgraded MS SharePoint 2.0 to 3.0 on virtual server environments using VMWare as well as live production servers.
• Programmed SQL Server 2000 to utilize email notifications based on SharePoint List data to notify Help Desk automatically of new employees.
• Implemented Data Sync Design Studio for synching research data with an Excel Front-End that is automated to synch data on SharePoint list Back-End data source.
• Familiarity with SharePoint Designer, Workflow paths, MS SharePoint 2010.
• Supported/Developed WAMP environments with MySQL and PHP.
• Supported using InfoPath as a Front-End application to maintain inventory purchase orders with SharePoint lists.
• Managed a project to design an in-house online Poster Request Order system for Buck Institute researchers using PHP, MySQL, JQuery, Java, HTML.
• Created MS Access Front-End to a MySQL Back-End data source using ODBC connection to run reports off of live-data.
• Installed and used virtual machine environments for testing various projects using VMWare.

Environment: SharePoint 2.0 &3.0 (2007), VMware, SQL Server 2000, Data Sync Design Studio, MySQL, Oracle 8i, MS Access, WAMP, PHP, JQuery, Java, HTML, MS Windows XP & 7

Confidential

Residential Child Counselor

Responsibilities:

• Provided direct supervision of Severely Emotionally Disturbed Children.
• Helped to coordinate daily activities and facilitate group meetings with children.
• Drove children to meet their families on weekend visits.
• Organized and coordinated occasional field trips with children on good trust status.
• Transitioned children to school day program.
• Distinguished night shift counselor both as full-time and as on-call status ensuring children were safely in bed while managing house chores.
• Assisted in training fellow night shift staff in later years to ensure all tasks were well managed.
• Cooked and prepared meals.
• Trained in CPR and Crisis Management skills.