Rss

Contact_user

Sandra S

Database and Analysis Generalist

Occupation:

Database Designer

Location:

Schaumburg, IL

Education Level:

Bachelor

Will Relocate:

YES

CollapseDescription

PROFESSIONAL SUMMARY: IT professional with over 25 years of experience designing relational databases (SQL Server, Access, PROGRESS and DB2), solving problems and helping management maximize knowledge of business operations, evaluating database and query performance incorporating forecasted future needs and activities. My experience is centered on system analyses, developing database/reporting systems, using functions, views and complex stored procedures to automate data manipulation and validation increasing the efficient use of data and producing meaningful, timely reports based on team-based projects and AGILE/Scrum methodologies. Many of my most recent SQL Server/Access projects involved * Gathering requirements, analyzing existing processes and designing customized database systems * Working with stakeholders in the design and troubleshooting of data imports and exports (ETL) * Migrating data using SQL Server's Data Tools (SSDT/SSIS) and bulk insert scripts, incorporating data conversion, validation, verification and cleansing functionalities and scripts. * Developing SSDT-SSRS projects to design customized reports and dashboards to analyze KPI * Developing Front End GUI applications with MS Access to link to various database servers as well as Excel data sources, coding in VBA to enforce business rules for data verification and correction. * Designing, coding and implementing stored procedures to standardize and automate repeating data manipulations. * Analyzing and performance tuning OLTP and OLAP database systems * Determining criteria to decide if servers should be actual or cloud-based (Azure, AWS, etc.) I have always been involved in analyzing the system flow, processes and data usage, documenting the industry environment and needs and then developing systems to effective meet business requirements, documenting the applications, writing user manuals and, as necessary, designing and teaching classes on all system components. My experience in working in a wide range of industries, spanning healthcare, insurance, finance, manufacturing, retail, wholesale and utilities gives me understanding of the needs and concerns of stakeholders, managers, users. Note: For over 20 years I have been working as a contractor and often worked up to 3 at one time. The following examples are some of the more significant contracts.

Right_template4_bottom

CollapseWork Experience

COMPANY POSITION HELD DATES WORKED

exelon Energy Procedure writer III 3/2004 - 11/2013
Right_template4_bottom

CollapseEducation

SCHOOL MAJOR YEAR DEGREE

University of Chicago Biochemistry Bachelor Degree
Right_template4_bottom

CollapseAccomplishments

Highlights:

Companies I like:

Any company needing help organizing business data

Left_template4_bottom

CollapseJob Skills

Left_template4_bottom

CollapseKeywords

Left_template4_bottom