Michael Blackmore Email & Phone Number

Lake Zurich, Il, Us

Lake Zurich, Il, Us

Create SSIS packages to load and pull warehouse shipping Operational Data Store from Various EDI Source for order Fulfilment and last Mile Delivery NetSuite , EDI -ASN -Flat File -XML

Performed requirements, design, development and testing of a Customer Service Workflow system.Managed Solution design and progressCoordinate testing and release schedulingProvide User documentation and trainingManage UAT & QA Environments Develop SQL Stored Procedures and Triggers to automate workflow tasks processingPerformed database performance tuning on backend SQL Server databaseIdentify appropriate schema enhancements or indexes to optimize database performanceCreate, Design and Manage Microsoft SharePoint Team siteCreate KPI metrics for monitoring Customer Service Representative Department progressCreate SSIS PackagesCreate process to synchronize legacy Btrieve data tables to SQL Server repositoryCreate data transformation process to upload SQL Server data into Oracle Data warehouse

Macon, Georgia, Us

Chicago, Il, Us

• Creating SSRS reporting Suite on SharePoint site• Create custom SSRS Code assembles for report enhancements• Create SQLServer 2012 Power View Ad-hoc integration to Excel 2013• Create MS Analysis service Tabular Data Model• Dimensional data modeling and DAX (Data Analysis Expressions) Scripting• Integration Services 2012 Configuration , Scripting and deployment

Deerfield, Il, Us

Indianapolis, Indiana, Us

Member of the Data services team for an insurance company in the Chicago LoopCreate SSIS PackagesCreate a data extraction process to pull insurance claim data from a SQL Server data repository, transform data into xml messages, for upload into PeopleSoft for paymentCreate SSRS ReportsCreated a suite of complex financial reports delineating earning, Loss reserves, administration and Brokers fees Create SSAS ProjectsCreate Data Cube warehouse support for Financial reporting packageUtilize Microsoft TFS Auto Build and deploy (Team Foundation Server)Utilize MS DBPRO ( Microsoft Database Pro)Create database transformation scripts to promote Development TSQL code to QA and production.Reporting Solution Developer Sirius Technologies Inc.April 2007 to March 2008Performed requirements, design, development and testing of Web based financial reporting using SQL Reporting services 2005Create Stored Procedures and triggers for data extraction and migrationPerformance tuning utilizing indexes and udf functions Utilize ETL process to migrate data from multiple sources using SQL Server Integration Services.Create new SSIS PackagesMigrate existing DTS Packages up to 2005 standards

Performed requirements, design, and development and testing of application for case management and workflow handling.Technology used C#, SQL server and MS AccessPerformed requirements, design, development and testing of a module plug-in for a documentation system.Technology is VB.Net, SQL server, Kofax document imaging and FileNet.Performed requirements, design, and development and testing of application to provide Inventory in transit adjustments to a world wide demand planning tool.Managed team of developersCoordinated integration of new software solution into existing database structure.Technology was MS Access Project front end to a SQL Server database.Ongoing Development of an E-commerce web site which delivers statistical data to consumers on a fee based usage.Technology used is ASP.NET, ADO.NET, SQL Server Reporting services, and SQL Server database.

Performed requirements, design, development and testing of application to provide Land Title services over the Internet.Managed both client and customer relationships to ensure clear expectations were set, proper information was communicated and thorough testing was performedTechnology was B2B XML Data exchange application using XML.NET, ADO.NET, ASP.NET and SQL Server integration. Performed requirements, design, development and testing of application to provide cycle count management and tracking.Managed team consisting of Fourth Shift expert, database designer, and user testing resourcesIntegrated with Fourth Shift ERP packageTechnology was MS Access, VB.NET & SQL ServerPerformed requirements, design, development and testing of a custom medical questionnaire using electronic forms.Reported to lead physician for project and coordinated team of users to review, test and be trained on application.Technology took advantage of TabletPC functions, combining them with Microsoft Office InfoPath form technologies, in which XML forms populate a MS Access database.

Responsible for implementation, maintenance, support and upgrades for all applications, computer infrastructure, telecommunications infrastructure for 100 person manufacturer and distributor of wedding accessories. Responsibilities included:Made2Manage ERP packageFinancial reportingForecastingShippingReceivingAccounts receivableAccounts payableBar codingDatabase administrationDesign and creationPerformance tuningSecurityManagement of all technology vendors and subcontractorsDesigned and developed data warehouse and custom reporting systems that use itManagement reporting Sales trackingCommission reporting Performed requirements, designed, developed, tested and implemented web site www.beverlyclark.comPerformed requirements, designed, developed, tested and implemented new E commerce site for Beverly Clark www.bridalaccessories.comManaged EDI & Barcode technology implementationSelected productsManaged integration and implementationProvided user trainingPerformed requirements, designed, developed, tested and implemented secure web site for custom financial reporting to investor group

Performed business process improvement for Asset Audit Company. Designed, developed and implemented new processes that took advantage of document imaging technology, bar coding and automated document indexing. When implemented, the improvements reduced processing effort by over 80%.Implemented Great Plains Small Business Manager for governmental agency. Performed requirements, system selection, system configuration and data conversion. Trained users in the use of the new system. Integrated Great Plains to additional systems.Performed requirements, developed RFP and performed vendor selection for new data and voice communications network for $6 billion bank with 55 locations. Selected solution saved customer over 50% on their costs.

Us

Performed requirements, designed, developed and implemented a corporate website for sales force management. Worked with senior management, Managed external product vendor, and trained users in system operationTechnology used was customized Microsoft Active Server Pages accessing a SQL Server database that was downloaded from and AS/400.Performed requirements, designed, developed and implemented application to analyze customer questionnaires.Technology used was Microsoft Access accessing a SQL Server database Performed requirements, designed, developed and implemented application systems to create catalog Technology used was SQl Server, Visual Basic and Quark PublisherPerformed requirements, designed, developed and implemented application commission reporting system

responsible for providing competitive bids, project plans, meeting deadlines, hiring and managing support staff, negotiating contractsFull time Project Manager. Estimated projects, created bids, and managed teams of 4 to 30 people on projects with values exceeding $1.5 million.