PROFESSIONAL EXPERIENCE:

Microsoft BI Architect

Confidential, Oak Brook, IL

Responsibilities:

• Met with vice presidents and directors to gather and document business requirements that were used to validate the SSAS cubes .
• Worked with the Microsoft 2012 BI Stack ( SSDT, SSIS, SSAS and SSRS ) to develop OLAP cubes for operational BI reporting purposes.
• Created new data marts using SQL Server 2012 from SAP E1 data into a staging, data warehouse and data mart layer using SSIS packages
• Creates SSIS packages to perform three level QC checks for the imported data and to populate/generate the operational SSAS cubes
• Developed SSIS packages using Visual Studio 2013 for ETL into the SSAS cube and for version control
• Developed and managed BI end user presentation layer training and documentation using PowerPivot and PowerBI
• Defined BI framework model, semantic layers and Metadata repositories to support operational reporting and administration.
• Defined and enforced coding standards, design styles and best practices.
• Provided ongoing 2nd level support for related applications and technologies.

Enterprise Architect

Confidential, Chicago, IL

Responsibilities:

• Met with directors and managers to create a strategic BI roadmap that included a five year plan.
• Supported the creation of project scoring models to ensure accurate planning for the development effort, technical complexity, cost,and dependencies
• Programmed the ETL and data cleansing system for the adjudication of our members health claims using Transact*SQL and SSIS packages.
• Managed a team of 6 - 12 healthcare consultants to develop the Health Care data warehouse and enforced standards and procedures.
• Provided weekly claims reports from the Health Care data warehouse to partners and third party vendors using MS Excel.
• Created data marts and dimensional models using SQL Server 2012 to support on-going application development projects
• Maintained the conceptual, logical and physical schemas for the data warehouse using ERWin Data Architecture and ERWin Azure modeling tools
• Maintained project version control using Visual Studio 2013 for SSIS packages and SQL code
• Maintained data sets and health reports using AWS / S3
• Developed a backup strategy using MS Azure and SQL Server 2012
• Generated weekly health claim reports with EdgeServer and RegTap in order to comply with the federal government standards for health care insurance
• Maintained the extensive Technology and Product Portfolio.
• Defined enterprise level architecture and application development principles, standards, and processes.

Senior Application Engineer

Confidential, Deerfield, IL

Responsibilities:

• Met with the data scientist and directors to gather and document the business requirements for the marketing score card.
• Programmed the ETL and marketing algorithms for the marketing score card using Transact*SQL for a 15 pB Netezza database
• Developed machine learning applications in Spark using neural network classifiers
• Developed neural network classifiers using Transact*SQL in Netezza
• Developed analytical reports using Scala in Hortonworks Hadoop framework using HDFS, HBase, Sqoop, Hive, Pig and Kafka for marketing and sales BI reporting.
• Developed advanced analytical reports and scorecards using Scala in DataBricks
• Developed 12 Use Cases in Jira for Big Data management
• AGILE SCRUM methodology used to develop new projects
• Created Netezza enterprise wide performance tuning and naming standards
• Created data lineage and MDM diagrams for Big Data strategic planning
• Documented MS SQL Server 2012 development procedures and naming standards

Senior Data Enterprise Architect

Confidential, Chicago, IL

Responsibilities:

• Lead regularly scheduled design meetings with managers and directors to review the Enterprise Data Dictionary using MS Excel.
• Maintained the financial and Microstrategy enterprise data warehouse in SQL Server 2012
• Designed and expanded the Enterprise Data Warehouse design using both the Kimball and Inmon approach
• Developed conceptual, logical and physical data models using ER/Studio for 298 production databases
• Created and designed 24 new data marts within SQL Server 2012
• Developed new projects within an Agile SCRUM and DSDM methodology
• Implemented statistical reporting metrics , KPI's and profit drivers from the financial data warehouse for Microstrategy cubes and reports
• Developed financial reports using SSRS and Tableau .
• Created PowerPivot reports using DAX within PowerPivot
• Developed an MDM strategy and action plan for enterprise wide improvements
• Diagnosed and implemented performance tuning using Execution Plans and MS Profiler on production stored procedures using Transact*SQL
• Developed Big Data standards and procedures; implemented Hadoop as part of the Enterprise Analytic platform
• Developed process flow diagrams for the marketing and sales systems using PowerPoint .

Senior BI Analyst

Confidential, Mundelein, IL

Responsibilities:

• Lead discussion groups with directors and managers to develop the enterprise BI Architecture strategy and BI tool selection
• Documented and developed the 'best practice' approach for BI development within a SQL Server 2008/2005 environment
• Created and maintain the ETL process for the data mart using SSIS packages
• Created and maintained finance reporting cubes in SSAS in the development and production environment
• Developed and maintained financial, material management, sales and validation reports using SSRS in the development and production environment
• Deployed to production environment using Business Intelligence Development Studio (BIDS) using Visual Studio
• Maintained version control of all SQL Server 2008 objects using Visual Source Safe
• Created and maintained process flow charts of the production environment using Visio
• Analyzed reports for performance improvements using execution plans and made recommendations to the developers
• Develop and maintain conceptual, logical and physical schemas for the healthcare and financial areas using Visio
• Developed and maintained SSMS data warehouse tables using Kimball approach in a development, training and production environment

Consultant/Business Intelligence Developer

Confidential, Chicago, IL

Responsibilities:

• Develop and maintain logical and physical schemas using Embarcadero ER/Studio
• Developed and maintained SSMS data warehouse tables using Kimball approach in a development, training and production environment
• Created and maintain the ETL process for the financial and insurance data mart using SSIS packages
• Created and maintained finance reporting cubes in SSAS in the development and production environment
• Deployed to production environment using Business Intelligence Development Studio (BIDS)
• Maintained version control of all SSMS, SSIS, SSAS and SSRS objects using Visual Source Safe
• Created and maintained process flow charts of the production environment using Visio
• Created and maintain the data warehouse capacity planning reports
• Document and develop the 'best practice' approach for SQL Server 2008/2005 development

Consultant/Business Intelligence Developer

Confidential, Downers Grove, IL

Responsibilities:

• Implemented and maintained the 'best practice' approach to business intelligence development
• Maintained 31 SSRS monthly strategic reports in a development, training and production environment
• Maintained SSMS data warehouse tables using Kimball approach in a development, training and production environment
• Created and maintained Monthly report cube in SSAS in the development environment.
• Deployed to production environment using Business Intelligence Development Studio (BIDS)
• Created and maintained the Scorecard Audit Process with 31 Scorecard Audit charts and graphs.
• Created and maintain the ETL process for Scorecard Audit using SSIS packages
• Enhanced TSQL and MDX code to provide cleaner data and to correct infinity errors
• Maintained version control of all SSMS, SSIS, SSAS and SSRS objects using Visual Source Safe

Consultant /Sr. Database Architect

Confidential, Chicago, IL

Responsibilities:

• MS SQL Server 2008 Subject Matter Expert (SME) for a SaaS company
• Provided performance tuning techniques, monitoring and recommendations
• Maintained and tuned 14 production MS SQL Server 2008 databases
• Reviewed TSQL code for performance issues and provided 'best practice' recommendations for improvement
• Wrote and maintained ETL code using TSQL and SSIS packages
• Implemented snap shot replication from OLTP databases for SSRS reporting purposes
• Implemented Performance Governor as part of the load balancing strategy
• Created strategic planning guide and provided strategic recommendations for database growth and procedures

Senior Business Data Warehouse Developer

Confidential, Chicago, IL

Responsibilities:

• Primary support for the Finance Business Intelligence team.
• Documented business requirements during JAD meetings with managers and staff using Use Case diagrams
• Using Visual Studio, converted 57 mission critical DTS packages to SSIS 2005 packages using the enterprise template that allowed for table storage of connection threads, run times, error messages
• Developed 36 new SSIS packages using SSIS data flow templates
• Migrated database platform from SSMS 2005 to SSMS 2008
• Using the Lean Agile methodology (Poppendieck), delivered 30 day time fame projects within a Zackman framework
• Created and maintained financial reports in a development and production environment using MS Reporting Services (SSRS)
• Migrated data and maintained reports using MS Excel pivot tables
• Developed MS Analysis Services (SSAS) cubes and pivot tables to used for data mining and analysis
• Created a scorecards, dashboards and linear regression reports using MS PerformancePoint.

Business Intelligence Database Developer

Confidential, Naperville, IL

Responsibilities:

• Reviewed and validated regression algorithms with the business analysts.
• Using Execution Plans and MS Profiler, analyzed T-SQL and C#.NET code for performance tuning and enhancement areas. Enhancements applied to the three-tiered .NET production environment
• Maintained UML diagrams using Enterprise Architect and provided training to the team on enterprise modeling techniques
• Documented, tested and maintained development and production DTS and SSIS 2005 packages used for ETL processes and production support.
• Developed and maintained CLR assemblies to improve program performance in the .NET environment
• Provided strategic recommendations for future hardware and software requirements based upon growth patterns and estimated project plans
• Maintained regular database maintenance, service packs and backup schedules on all servers.

Business Intelligence / Datawarehouse Database Administrator

Confidential, Rosemont, IL

Responsibilities:

• Maintained and developed production MDD data warehouse in a MOLAP, ROLAP and HOLAP design.
• Primary support for development and maintenance of the MS Dynamics Great Plains application
• Documented, tested and maintained 17 production DTS and SSIS 2005 packages used for ETL processes and production support.
• Developed and maintained Business Intelligence reports using MS Analysis Services (SSAS) and MS Reporting Services (SSRS)
• Using Execution Plans and MS Profiler, analyzed Confidential code for performance tuning and enhancement areas. Enhancements applied to the clustered, three-tier production environment
• Provided 24/7 production support for MS SQLServer 2005/2000 databases; migrating from MS SQL Server 2000 to MS SQL Server 2005.

Sr. SQLServer Database Administrator

Confidential, Chicago, IL

Responsibilities:

• Primary support for 85 DTS and SSIS 2005 packages
• Provided 24/7 production support for 35 instances of MS SQLServer 2005/2000 clustered, SAN environment; migrating from MS SQL Server 2000 to MS SQL Server 2005.
• Maintained merge and snapshot replication between all production and development environments
• Using MS Profiler, analyze Confidential code for tuning and program enhancement areas. Enhancements applied to the clustered, three-tier production environment

Sr. SQLServer Data Base Administrator

Confidential, Lake Forest, IL

Responsibilities:

• MS SQL Server Subject Matter Expert (SME)
• Provided 24/7 production support for 21 instances of MS SQLServer 2000 in a clustered SAN environment; 4.67 terabytes total.
• Maintained snapshot replication between all production environments
• Maintains logical and physical schemas using ERWin.
• Using MS Profiler, analyzed Confidential code for tuning and program enhancement areas. Enhancements applied to the clustered, three-tier production environment
• Performed daily performance monitoring, performance diagnosis and performance tuning
• Maintained monthly, weekly and daily system performance reports
• Maintained regular database maintenance and backup schedules using Veritas

Data Base Administrator

Confidential, Northbrook, IL

Responsibilities:

• Provided 24/7 production support for 21 instances of MS SQLserver; 15 gB total.
• Designed and maintained database schemas (conceptual, logical, physical) and enterprise data dictionary using ERWin
• Using MS Profiler, analyzed ASP and COBOL code for tuning and program enhancement areas. Enhancements were applied to the clustered, three-tier production environment
• Enhanced security levels by creating roles and permission levels for all instances
• Created stored procedures using Transact SQL /DTS/ Job Scheduler to cleanse and report data quality of daily loading processes
• Using MS SQLServer DTS feature, custom designed and implemented ETL system. Migrated 3.5 gB from AS400 to MS SQLServer2000 staging area.
• Installed seventeen instances of MS SQLServer 2000 / MS SQLServer desktop and applied Service Packs 2.0 and 3.0

Senior SQLServer Administrator

Confidential, Chicago, IL

Responsibilities:

• Provided 24/7 SQLServer DBA support in the development, staging and clustered production environment
• Developed and maintained replication environment (snap shot and transactional) for seven MS SQLServer instances
• Using MS Profiler, analyzed Visual basic, ASP, XML and UML code for tuning and program enhancement areas. Enhancements were applied to the clustered, 'x'-tier production environment
• Designed and maintained database schemas (conceptual, logical, physical) using ERWin
• Maintained an 'x-tiered' architecture using ASP and Visual Basic

Data Warehouse Architect

Confidential, Northbrook, IL

Responsibilities:

• Enhanced MS SQLServer SSIS system using DTS/Job Scheduler and replication (snap shot only)
• Migrated 1.5 gB data from AS400 sources
• Designed and implemented BackUp and Recovery strategy for MS SQLServer environment using Windows 200 and DTS utilities

Enterprise Data Architect

Confidential, Chicago, IL

Responsibilities:

• From JAD sessions with Vice Presidents, directors and managers selected and developed appropriate database platforms
• Using ERWin 3.5, custom designed and implemented logical and physical schemas (Inman approach) to insure the enterprise data warehouse architecture (Zachman approach) was as flexible, scalable, user friendly and maintainable as possible
• Reviewed business needs and selected the best tools from the MS suite of products to be used with MS SQLServer 2000, Active X and Active Directory

Enterprise Data Architect

Confidential, Chicago, IL

Responsibilities:

• Reviewed business needs and selected the best tools from the MS suite of products to be used with MS SQLServer 2000, Active X and Active Directory
• From JAD sessions with Vice Presidents, directors and managers selected and developed appropriate database platforms
• Using ERWin 3.5, custom designed and implemented logical and physical schemas (Inman approach) to insure the enterprise data warehouse architecture (Zachman approach) was as flexible, scalable, user friendly and maintainable as possible

Oracle Technical Applications Specialist

Confidential, Chicago, IL

Responsibilities:

• Using ERWin 3.5, maintained conceptual, logical and physical schemas
• Created stored procedures using SQLPLUS to implement schemas onto MS SQLServer and Oracle7 platforms.