Description
IT professional with over 25 years of experience, solving problems and helping management maximize knowledge of business operations and manage/upgrade legacy databases (SQL Server, Access, MS Power BI, PROGRESS, DB2 and Oracle), developing and maintaining integration data flows from internal and external clients’ systems to data warehouses.
Work Experience
COMPANY | POSITION HELD | DATES WORKED |
---|---|---|
NABP | SQL Server Database designer | 1/2017 - 3/2017 |
ABS Global | SQL Server Database developer | 11/2016 - 1/2017 |
Terlato Wine | SQL Programmer | 3/2016 - 6/2016 |
S&C Electric | Documentation Consultant | 10/2013 - 11/2014 |
Exelon Corporation | Sr Procedure (Technical) Writer | 5/2004 - 11/2013 |
Education
SCHOOL | MAJOR | YEAR | DEGREE |
---|---|---|---|
Set Focus | SQL | 2009 | Some College Units Completed Degree |
University of Chicago | Biochemistry | Bachelor Degree |
Accomplishments
Highlights:
Gathering requirements, analyzing existing processes, working with stakeholders in the design and troubleshooting of data gathering, reporting, dashboards and supporting applications Migrating data using SQL Server’s Data Tools (DTS/SSIS/SSDT) and bulk insert scripts, incorporating data conversion, validation, verification and cleansing functionalities and scripts (ETL) Developing SSDT-SSRS projects to design customized reports and dashboards to analyze KPI Supporting Power BI front end GUI Utilizing / Producing Excel spreadsheets, using functions, VBA, pivot tables and macros to qualify data Developing MS Access front end GUI applications to link to various database servers as well as Excel data sources, coding in VBA to enforce business rules for data verification and correction. Acting as a bridge between business owners and technical resources to identify business information, processes and workflow to develop and fine tune application usability and efficiency Managing the change process, overseeing user acceptance testing (UAT), documenting and resolving issues, and implementing the project plan within budgetary constraintsJob Skills
Keywords
Responsibilities
Assessing and documenting current processes
Correlating the data generated by the business
Evaluating the relevance of the data models in use and the relevance of query performance to forecasted future needs and activities
Developing efficient functionalities to meet current and future requirements
Training Staff in IT applications and usages