We provide IT Staff Augmentation Services!

Systems Analyst Manager/sr. Sql Server Developer Consultant Resume

Chicago, IL

SUMMARY:

  • An accomplished SQL Server Database Developer, SQL Server BI Developer, Data Analyst, and .NET software developer (C#.NET) with extensive experience developing data driven software applications.
  • SQL T/SQL programming including creating databases, tables, views, stored procedures, user - defined functions, triggers, etc. Knowledge of performance tuning, index tuning, & query optimization.
  • Experience creating robust ETL packages with SQL Server Integration Services (SSIS), creating reports and charts using SQL Server Reporting Services (SSRS) and designing data warehouse cubes using SQL Server Analysis Services (SSAS).

COMPUTER SOFTWARE:

  • Visual Studio 2013, C#, ASP.NET, Winforms, Webforms & .NET Framework 4.5
  • Visual Studio 2010, C#, ASP.NET, Winforms, Webforms & .NET Framework 4.0
  • Visual Studio 2008, C#, ASP.NET, Winforms, Webforms & .NET Framework 3.5
  • Microsoft Office 2010 including Word, Excel, Access, PowerPoint, & Outlook.
  • Microsoft Team Foundation Server (TFS) 2010.
  • Microsoft Visio
  • Business Intelligence Markup Language using BIDS Helper for SSIS
  • Microsoft SQL Server 2014 including Transact SQL (T/SQL), SSDT, SSIS, SSRS, SSAS.
  • Microsoft SQL Server 2012 including Transact SQL (T/SQL), SSDT, SSIS, SSRS, SSAS.
  • Microsoft SQL Server 2008R2 including Transact SQL (T/SQL), BIDS, SSIS, SSRS, SSAS.
  • Microsoft SQL Server 2005 including Transact SQL (T/SQL), BIDS, SSIS, SSRS, SSAS.
  • Microsoft SQL Server 2000 including Transact SQL (T/SQL), DTS.
  • Microsoft SQL Server 7.0 including Transact SQL (T/SQL), DTS.
  • Microsoft Access 2010.
  • Microsoft Visual FoxPro 9.0, 8.0, 7.0.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Systems Analyst Manager/Sr. SQL Server Developer Consultant

Responsibilities:

  • Led a team of three developers responsible for creating Medicare and Medicaid patient & financial reports.
  • Removed all logic and Excel functions from Excel reports and used T/SQL to add that functionality through stored procedures.
  • Provided production support for users and IT staff.
  • Trained other SQL Server developers to use advanced features in SQL Server 2012.
  • Created MS Access application to monitor Confidential case workers and staff.
  • Saved 30 hours of weekly development time by automating 45 Medicaid/Medicare compliance reports for the State of Illinois.
  • Created desktop application in MS Access to allow Confidential managers to monitor case workers and other Confidential employees.
  • Video training allowed SQL Server Developers to quickly understand new concepts and Microsoft Best Practices while creating stored procedures and other SQL Server objects.

Confidential, Chicago, IL

Sr. SQL Server Developer/Sr. BI Developer Consultant

Responsibilities:

  • Responsible for gathering technical requirements, creating technical specification documents, and Statement of Work documents.
  • Create “proof of concept” applications for approval by IT managers.
  • Design, develop, test, and implement SSIS packages, SSRS reports and SSAS cubes.
  • Create SSIS packages to populate the Enterprise Data Warehouse.
  • Create SSRS reports for management and various departments.
  • Led technical design meetings and participated in code reviews.
  • Technical specification documents, process diagrams, and proof of concept development assures IT managers that development will succeed.
  • Cube development and SSRS reports allowed managers to better understand sales trends and sales data.
  • New SSIS packages streamline Enterprise Data Warehouse updates including rebuilding dimension tables and fact tables.

Confidential, Chicago, IL

Sr. SQL Server Developer/SQL Server BI Developer Consultant

Responsibilities:

  • Created SQL Server 2014 SSAS Tabular Data Warehouse to store client data.
  • Created dimension tables and fact tables from OLTP data to be part of the Data Warehouse.
  • Developed SSIS packages using BIML tool (BIDS Helper) that process data from Excel, CSV, or text files into SQL Server tables.
  • Created star-schema based SSAS cubes to analyze data.
  • Created reports for management and stakeholders using SSRS.
  • Led the project to build the Tabular Data Warehouse and store client data in-house.
  • Created BI objects for the Data Warehouse to analyze data, and as the basis for analytics and reporting.
  • Created complex, SQL stored procedures that automate file format testing to eliminate data errors.

Confidential, Chicago, IL

Sr. SQL Server Developer/SQL Server BI Developer Consultant

Responsibilities:

  • Used SQL Server 2008R2 and SQL Server 2012 to create Data Marts to store client data.
  • Created stored procedures to automate database tasks and encrypt healthcare data.
  • Developed C# Winform application to import and encrypt/decrypt health care data.
  • Data Marts gave users, hospital managers, and administrators the ability to identify, analyze, and output healthcare data.
  • C# application successfully imported data to be used for analysis and to share with other healthcare facilities.
  • Created SSIS packages and SSRS reports for Medical department.

Confidential, Chicago, IL

Sr. SQL Server Developer/C# Developer Consultant

Responsibilities:

  • Built Tabular model Analysis Services database with SQL Server 2012.
  • Created Data Marts for Production and Sales Depts.
  • Created a WinForms front-end to allow Accounting to run real and staged month-end processing.
  • Automated time and expense reporting for accounting department using custom stored procedures,
  • Created a multi-dimensional model data warehouse based on Kimball methodologies and using a Star schema.
  • Created Parent/Child SSIS packages to create Fact tables and Dimension tables to get source data from OLTP databases, sum and/or aggregate data, and create the tables necessary for the data warehouse.
  • Created SSAS cubes using SQL Server Analysis Service that use data warehouse data as the basis for analytics and reporting.
  • Created a Tabular designed Analysis Services database that proved extremely fast and allowed data to be analyzed quickly and easily.

Confidential, Chicago, IL

Sr. SQL Server Developer/SQL Server Report Writer Consultant

Responsibilities:

  • Review functional requirements and create design specifications for SSIS packages and SSRS reports. Build data sources (DS) and data source views (DSV) to enhance the database schema as the basis for SSAS cubes and SSRS reports. Create and deploy SSIS packages. Created client designed custom reports and charts using SQL Server 2008 SSRS. Wrote stored procedures to verify selected data. Reports created include drill-down reports, bar charts, line charts, & summary reports.
  • Assisted senior management in requirements gathering, designing, building, and implementing SQL Server Business Intelligence SSRS reports, & SSIS packages.
  • Automated SSRS reports saved development time and standardize report development and delivery.
  • Creating data source views allows users to create Named Calculations and Named Queries when creating SSIS packages and SSRS reports.

Confidential, Lisle, IL

Sr. SQL Server Developer/SQL Server BI Developer Consultant

Responsibilities:

  • Created, developed and deployed an SSIS Management Framework application to organize, manage, monitor, and restart SSIS packages from a single Winforms central application.
  • Created a C# deployment tool capable of deploying .SQL scripts, classic .ASP and .NET .ASPX pages, web services files and SSIS packages.
  • New SSIS Management Framework organized SSIS packages and allowed for central management.
  • New SQL stored procedures created an e-mail alert system based on previous time slots to allow a user to check for SSIS package failure and be notified if a failure took place.
  • New WinDeploy deployment tool will help eliminate deployment errors while creating logs in text format to alert the users of any errors a script may have encountered. The rollback feature is performed in minutes instead of hours.

Confidential, Chicago, IL

Sr. SQL Server Developer/C# Developer Consultant

Responsibilities:

  • Converted a legacy Visual FoxPro application to C# using Visual Studio 2008.
  • Created business requirement, design documentation, and technical specification documents.
  • Created SQL Server 2008 database, tables, views and SSIS packages to support a hosted web application. in a client specific format.
  • Used Microsoft Visio to create system documentation.
  • SSIS tasks included Data Flow Task, Execute SQL Task, FTP Task, File System Task, Send Mail Task, Lookup Task, Fuzzy Lookup Task, Conditional Split Task, & Derived Column Task
  • Assisted senior management in requirements gathering, designing, building, and implementing SQL Server Business Intelligence SSRS reports, & SSIS packages.
  • Successfully created a C# console application by recreating a Visual FoxPro 9.0 application to C#.
  • Used SSIS packages to streamline data import/export functionality.

Confidential, Chicago, IL

Sr. SQL Server Developer/SQL Server BI Developer Consultant

Responsibilities:

  • Created custom SSIS packages using SQL Server 2008 that output specially formatted text files to be used for predictive analytics.
  • Some SSIS tasks used include Control Flow tasks, Data Flow tasks, File System task, Script task, FTP task and Send Mail task, Transformations include Data Flow Transformations, Conditional Split, Data Conversion, Lookup and Fuzzy Lookup.
  • Designed and created new SSIS packages using SSIS/BIDS Helper BIML tool to transfer data from various sources on a daily, weekly or monthly schedule.
  • Created stored procedures and complex queries from a commercial medical database as the basis for reporting or analysis.
  • Created SSIS packages that automatically create files used for custom software packages.
  • Created a new data warehouse as the basis for data analysis (SSAS) and reports (SSRS).
  • Created data dictionary, and schema design documents using stored procedures that read database and table extended properties.

Confidential, Lisle, IL

Sr. SQL Server Developer/C# Developer Consultant

Responsibilities:

  • Responsible for support of North American clients using critical business applications.
  • Added functionality or enhanced legacy systems written in Visual FoxPro 6.0.
  • Used Microsoft Visio to create an overview of a proposed Data Warehouse.
  • Designed and created a Data Warehouse as the basis for SQL Server reports (SSRS).
  • Created SQL Server 2008 queries and stored procedures to add functionality and maximize application efficiency while increasing security.
  • Successfully converted SQL Server data to assist HR in establishing a new major payroll provider, saving revenue and simplifying HR and payroll functions nationwide.
  • Designed and built a new Data Warehouse as the basis for reporting, thus standardizing company part numbers, methodology for month-end accounting, and standardizing reports.
  • Designed & built new SSIS packages that extract mainframe data and load SQL Server tables as the basis for major PC applications. The new SSIS packages streamlined ETL operations.

Hire Now