TECHNOLOGY SKILLS:

• SQL Server 2008 - 2016 Data Modeling (relational & Power BI
• SQL Reporting Services dimensional) Database Administration
• SSIS/SSAS Query Optimization Sharepoint
• Transact-SQL Performance Tuning MS Excel and Access

WORK EXPERIENCE:

Confidential, Wayne, PA

SQL BI Developer

Responsibilities:

• Troubleshoot and make modifications to SSAS data source view and cubes
• Perform analysis, querying SSAS cubes
• Write stored procedures in T-SQL for performing calculations
• Populate data for data warehouse using SSIS
• Enhance SSAS Tabular data model, write DAX queries

Confidential, Philadelphia, PA

SQL BI Analyst

Responsibilities:

• Analyzed and evaluated databases in SQL 2016
• Designed custom reports and dashboards in SSRS
• Converted legacy reporting applications to SSRS 2016
• Wrote stored procedures in T-SQL
• Provided ad hoc requests for data
• Designed new ETL packages with SSIS
• Created KPI reports with Power BI
• Researched and resolved discrepancies between databases

Confidential

Responsibilities:

• Managed set up SQL servers and designed databases, created data management processes and reporting with SSIS, T-SQL and SSRS for startup food service company. Evaluated reporting platforms and BI tools.
• Designed SQL queries for health care analytics firm. Analyzed claims data from CMS database. Calculated performance metrics for providers. Designed SSRS reports.
• SQL Developer for local retail chain with 80 stores. Maintained data model with Erwin. Migrated database from SQL 2008 to 2012.
• SQL ETL Developer for health care data analytics firm. Performed analysis, wrote T-SQL and created SSIS packages to import large databases. Wrote queries to measure HEDIS compliance. Created SSAS cubes and queries based off of them. Designed reports in SSRS.

Confidential, Mt. Laurel, NJ

DBA/Senior Database Developer

Responsibilities:

• Performed DBA tasks such as backup and restore of large databases.
• Managed security including users and permissions.
• Monitored and troubleshot performance issues on server.
• Wrote deployment scripts for database migrations from SQL to Oracle.
• Designed SSIS packages for transferring and converting data.
• Completed Microsoft training on implementing Azure databases.

Confidential, Philadelphia, PA

Database Administrator

Responsibilities:

• SQL DBA for company wide windows XP migration tracking project.
• Integrated information from Active Directory and web based survey into SQL 2008 database.
• Analyzed existing data structure and processes, identified and and documented data issues.
• Maintained database model.
• Implemented changes to data structure to ensure greater accuracy and efficiency.
• Created and modified SSRS reports to track progress of upgrades.

Confidential, Wilmington, DE

Lead SQL Developer/DBA

Responsibilities:

• Lead team of SQL Developers for large home loans initiative.
• Created new data model in SQL 2008 for Short Sale survey web application.
• Analyzed existing databases and redesigned for normalization and greater efficiency.
• Successfully tailored model and rolled database out to three additional lines of business.
• Monitored SQL server to ensure processes were running.
• Performed troubleshooting of SQL server, identified and solved performance issues.
• Designed SSIS packages for transfer and processing of data between SQL, Excel and AS400.
• Created automated JAMS and SQL Agent jobs to run SSIS packages and stored procedures.
• Wrote stored procedures in T-SQL.
• Redesigned data warehouse model and table structure for dimensional modeling.
• Integrated Sharepoint data with SQL and designed sites and reports.
• Created data definitions for dictionary for data warehouse.
• Taught class of financial analysts in SQL server basics and querying.
• Mentored junior developers in SQL best practices and coding.
• Developed new dashboard reports with SSRS 2008.

Confidential, Philadelphia, PA

SQL Developer Team Lead

Responsibilities:

• Designed SQL Server database for renewable fuels, to ensure compliance with EPA regulations.
• Coordinated changes with development team
• Maintained model during revisions to new application version that was developed over months.
• Oversaw changes in accordance with SOX compliance regulations and procedures.
• Created new reports with SQL Reporting Services, including drill-down, multi-select parameters and cascading parameters.
• Wrote Transact-SQL to track transactions and aggregate sales data for reporting.
• Performed analysis of complex queries used for quarterly audit reporting, to find errors.
• Wrote queries in Access to verify transactions between two databases.

Confidential

Adjunct Faculty

Responsibilities:

• Taught database concepts such as table and index design, relationships, queries and reporting.
• Supervised student computer lab exercises and mentored students in effective data management.

Independent Consultant

Confidential, Wilmington, DE

Responsibilities:

• Responsible for integration of companywide large (100+ tables) database
• Wrote queries in Transact-SQL for populating normalized SQL database
• Designed complex queries in Access for validating imported data
• Exported data from SQL 2005 to SAP system using SSIS package
• Designed relational SQL Server database for managing fleet of equipment
• Coded queries in Transact-SQL, to track service schedules and availability of equipment
• Wrote VBA code to send complex data sets about services and usage to Excel for analysis
• Wrote Excel VBA code to create custom reports and calculations