Analyst-Contract Resume Waltham, MA - Hire IT People

SUMMARY:

Working towards a Master of Science in Applied Data Science. To date I have completed course work in Data Science (R), Data Analysis (Statistics/Advanced Excel), Business Analysis (Statistics/Tableau/Advanced Excel), and SQL Server (database creation, query and management).

SKILLS:

SQL and T - SQL queries and scripts
Reporting (InfoMaker, MS Report Builder, Crystal Reports)
VBA, Forms, and Macros
Statistical Data Analysis (Excel, R)
Access/Excel Application Development
Visualization (Excel, Tableau, Power BI)
Data aggregation and cleansing
Requirement Gathering, Documentation, Training

EMPLOYMENT:

Analyst-Contract

Confidential, Waltham, MA

Responsibilities:

Analyzed billing and geospatial inventory data for decision support.
Wrote proposals for analysis automation using MS Excel and Access.

Enterprise Reporting and Data Analyst

Confidential, Boston, MA

Responsibilities:

Created complex SQL and T-SQL queries and scripts for Radiation Oncology, Research, and fiscal datasets in Sybase, Oracle, and MS SQL Server databases.
Developed MS Access databases and MS Excel spreadsheets including macros and VBA coding in 2003, 2007, 2016 (Office 365) versions.
Developed reports using multiple reporting tools including InfoMaker and MS Report Builder.
Validated software upgrades, created user manuals and other documentation.
Trained and supported users.

MS Access Developer

Confidential, Boston, MA

Responsibilities:

Developed a method of proprietary system ETL to Oracle using Access 2003 database.
Wrote User Manuals and technical documentation.
Made recommendations for cleanup of multiple database systems including upgrades and data migration.

MS Access Developer

Confidential, Boston, MA

Responsibilities:

Fast track development of an Access 2007 application for event production tracking complete with GUI and reporting.

MS Excel Developer/Analyst

Confidential, Cambridge, MA

Responsibilities:

Worked closely with Project Management and Senior Developers to guide a high priority Oracle/Excel 2010 Budget and Forecast Tool back on track
Gathered requirements, developed detailed UML flows, and on sheet functionality sweetened with VBA.
Analysis extended from Development through Unit, Regression, and UAT phases.

MS Access Developer/Business Analyst

Confidential, Watertown, MA

Responsibilities:

Gathered requirements, tracked project deliverables, documented, designed, coded, and implemented MS Access 2000 database for Claims Quality Audit including SQL up/downloading.
Worked closely with users and business leaders to develop a scalable database design.

MS Access Database Developer

Confidential, Lexington, MA

Responsibilities:

Developed Access 2003 database to meet new state reporting requirements (Oracle) for community based mental health services.
Effort included GUIs, 3NF table structure, VBA, SQL, and transaction history capture.

Reporting Analyst

Confidential, Boston, MA

Responsibilities:

Automated Access/Excel 2003 reporting decreasing report generation time from 3-4 hours to 20 minutes.
Developed regular and ad hoc Excel, Access, SAP, Crystal Reports, and Business Explorer Analyzer (BEx) reporting templates for Global Supply Chain and Operations Performance & Control.
Gathered business requirements, documented development, and trained users in report generation.
Integrated SAP to Oracle reporting in Business Objects and Excel as part of a corporate merger team.

Documentation Specialist

Confidential, Boston, MA

Responsibilities:

Documented Market Planning, Innovation & Implementation Division meetings.
Coordinated e-room membership and postings for development workgroups.
Participated in the development of two new major medical insurance products.
Developed ETL for Oracle to Access CRM mailings.

Data Analyst

Confidential, Cambridge, MA

Responsibilities:

Designed and coded advanced Excel macros and Access database for ceded reinsurance accounting.
Created Access reports, forms and parameter queries for existing databases.
Sole responsibility for importing/entering bookings, compromises and payments.
Generated weekly, monthly, quarterly and ad hoc financial reports.

We provide IT Staff Augmentation Services!

Analyst-contract Resume

Waltham, MA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship