PROFESSIONAL SUMMARY:

• IT professional with over 25 years of experience with databases (SQL Server, Access, PROGRESS and DB2), solving problems and helping management maximize knowledge of operations, evaluating performance and forecasting future needs and activities. My experience is centered on system analyses and developing database/reporting systems, using stored procedures to automate data manipulation and validation, to increase the efficient use of data and produce meaningful, timely reports and has included team - based projects and AGILE/Scrum methodologies.
• Many of my most recent SQL Server projects involved
• ETL migrating data between systems using SQL Server’s SSIS feature, requiring development of validation, verification and cleansing functionalities and scripts as well as tuning database performance and developing stored procedures (T-SQL) to automate execution.
• Developing Front End GUI applications with MS Access to link to various database servers as well as Excel data sources, coding in Confidential to enforce business rules for data verification and correction.
• 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 the knowledge to anticipate needs and concerns of stakeholders, managers, users and techies.

SKILL:

• Analysis/Evaluation
• AGILE Scrum
• Business Intelligence and Data Modeling
• Data Warehouse
• Data Mart
• Report Design
• SQL Server -SSRS
• SQL Server - SSAS
• Confidential
• SQL Server Database Developer
• Database Design
• Data Modeling and table structure
• Stored Procedure & Trigger Development
• SSIS/DTL-ETL
• SSRS-Report
• SSMS-Database Admin & Management
• SQL Programming
• ANSI
• T-SQL
• Technical Writing
• Microsoft Office Suite (1992 through 2014)
• Word, Excel, Power Point, Access, etc.
• Data Migration
• SQL Server ETL -DTS
• SQL Server ETL -SSIS
• Documentation Management
• Project Management
• Bookkeeping/Accounting
• Warehouse Management

TECHNICAL SKILLS:

Database Skills: SQL Server (SSMS, Confidential, SSIS, SSRS, SSAS), Access, PostGreSQL, Progress, FileMaker, SAP, Oracle, DB2

Language Skills: VB & Confidential, SQL, PostGRE SQL, RM COBOL, PROGRESS, Java Script, XHTM, XML, CSS, DOM, PERL, ABAP4, C#, C++

Application Skills: MS Excel, MS Word, MS Power Point, MS Project, MFG-Pro, MS Visio, Open Office, Adobe Acrobat, Adobe Illustrator, Corel Graphic Suite, Quark, Front Page, Visual Studio, Outlook, Ruby, Ruby on Rails, Confidential (Query, Reporting, Analysis, Framework Mgr.), ERWIN, HOGAN

Operating Systems: Windows 98 - Win 8, DOS, Novell, Unix (Xenix), MPM

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Developer

Responsibilities:

• For a recruiting firm, upgraded older databases (SWL Server and Access) to newer versions, repairing data and enforcing relational constraints
• For a health insurance form, analyzed and fine-tuned SSIS package importation functionalities
• For a political campaign, developed methods to import contact/donor information and trained volunteers in using the application, documented with an interactive user’s manual

SQL Programming and SQL Server 2008 Instructor

Confidential, Glenview, Il

Responsibilities:

• Developed and taught courses for programmers not familiar with web design and databases
• Produced training manuals on programming in XHTML, Java Script, CSS, DOM scripting and TSQL to develop effective UI applications, supporting databases, data ETL and reporting.

SQL Server Lead / Database Consultant

Confidential, Mt Prospect, Illinois

Responsibilities:

• Developed SSRS reports
• Designed databases to support data import and analysis not currently digitized
• Developed stored procedures to support K2 Import and reporting functionalities

Confidential, DeForest, Wisconsin

Consultant

Responsibilities:

• Analyzed the existing tables, stored procedures, functions, data marts and usage
• Provided troubleshooting to understand the current system’s malfunctions and Confidential reporting errors
• Established development and test environments to safely test changes in architecture and code and SQL Server version
• Converted the existing code to current T-SQL
• Redesigned the database architecture to include Primary Keys, Foreign Keys and standardized data types
• Established the means to conserve the existing keys and ids while implementing a uniform record identification methodology
• Developed views to provide Cubes to support report writing requirements

Confidential, Chicago, Ill.

SQL-Server programmer

Responsibilities:

• Used Red Gate applications to identify all SQL code where inventory classifications were pertinent.
• Analyzed existing Access databases, Qlik-view and SSIS reports for relevancy
• Interviewed users and managers to identify any existing problems, un-met needs and other concerns
• Updated all relevant code, prioritizing the work to ensure no interruption in daily ETL and reporting activity.
• Worked with users to do BDD testing daily to identify and correct problems.

Confidential, Mn

Consultant

Responsibilities:

• The use of Confidential Report and Query Studios to design customizes reports and training users
• The development and maintenance of SQL Server 2008 databases
• Created Flow charts by using Visio2000 for the Project detailed flow.
• Using SSIS to design and implement ETL solutions, training analysts in SSIS and XML
• The design and development of Access front-end databases
• Training Business Analysts in gathering data and designing and completing analytical reports.

Developer/Trainer

Confidential, Schaumburg, IL

Responsibilities:

• Consulted on the design and content of an existing Confidential training course, incorporating sections on system analysis, business processes and database concepts
• Edited a series of training manuals for Confidential Studios and applications
• Used PowerPoint and Visio to produce the Instructor’s tools for teaching the courses

Database Developer / Procedure Writer

Confidential, Oakbrook, IL & Philadelphia, PA

Responsibilities:

• Managed multiple projects, coordinating progress with work plans and Access/SQL Server databases. Worked with cross-functional project teams to document existing processes and procedures and establishing goals and constraints.
• Participated in project planning, established project concepts and scope for reengineering processes, clarifying procedures, and documenting technical methods to standardize best practices and design effective
• Gathered business requirements, analyzed business needs, business processes and stored procedures, established repository databases, UI and user technical manuals.
• Developed a document numbering database schema to generate document numbers conforming to the Corporate Standard, implemented user acceptance testing and used BI metrics to report on schedule compliance. Trained Document Control SMEs in the classification of documents and use of databases to number and track documents

SQL Database Analyst

Confidential, Western Springs, IL

Responsibilities:

• Analyzed business processes, gathered business requirements, establishing the project scope, revamped existing website to allow real-time UI for customer data access.
• Conducted user acceptance testing and call center activity analysis on a SQL Server SharePoint website
• Assisted the Project Manager with complete SDLC processes including development of process flow charts, timelines, business requirements, functional requirements, design specifications, and many other documentation deliverables for Confidential project
• Developed a prototype UI and trained client-truckers’ staffs to enter data and analyze trends to interpret relative costs scenarios.

Analyst / Database Consultant

Confidential, Glenview, IL

Responsibilities:

• Developed data migration tools (ETL) and prototype UIs to synchronize with ERP SAP 4 and SQL Server accounting application and analysis tools and DSS applications
• Established cost-effective schedule for return/upgrade of leased equipment, verifying effectiveness through user acceptance testing with Excel analytical spreadsheets.
• Coordinated call center operations to capture and use real-time database UIs.

Confidential, Hazel Crest, IL

Access DBA

Responsibilities:

• Analyzed the existing system flow, established work scope through gathering business requirements, developing custom prototype UIs for diverse user groups.
• Gathered functional requirements, upgraded host server OS and improved automated Access application and UI, overseeing user acceptance testing
• Improved the hospital's management capabilities, implementing analytical reporting with improvements to automated Access applications.
• Trained ER staff to enter data and clerical staff to generate State required reports
• Trained ER and HR managers to analyze trends in foot-traffic and staffing needs over time and analyze the quality of customer care delivered using charts based on time-efficiency calculations.

Programmer/Database Analyst

Confidential, Wheeling, IL

Responsibilities:

• Developed Business Intelligence functionalities, improving accuracy of reporting data
• Trained finance staff to generate what-if scenario reports forecasting cost-savings and income generated through scheduled purchasing raw material and selling scrap material.
• Increased cash flow and, allowing client to realize recovered costs and track raw materials.