Candidates About

 

Theodore H. Baar

Professional Profile

Hands on developer, infrastructure Architect and designer, Data Architect/Modeler, BI Architect, .NET & SharePoint Developer (Applications and BI), SFDC Integration, ODS/Data Warehouse and SQL DBA experience with a proven track record, multiple technical skill sets, proven ability to learn on the fly and experience in defining, reconciling and executing management and end user goals and needs. Leads mixed teams of consultants and in-house staff or works as part of a team or alone as a self-directed individual contributor and technical resource.

                                                            

Prior experience in accounting and finance allows a deep understanding of the budget process and the ability to identify, report and control costs in a change oriented environment whether full life cycle, support or system upgrade project. Deeply familiar with Microsoft Project Management (Admin, Development and integration with SharePoint), SDLC/RAD/Agile Development (MS Project and TFS) methodologies and Accounting and Team System Software.

 

15 Years of SQL Server all versions since 2000 through 2017 (T-SQL). 11 Years of the Microsoft BI Stack (SSIS (Expert), SSRS (Expert) and SSAS (Intermediate) ).  2 Years of Oracle.  6 Years of Access. Paradox and DB2 as Data Sources, MS SQL Data Warehouses including Azure Data Warehouse, Data Marts, ODS and working with Oracle Data Warehouse. Multidimensional and Tabular Models. 8 Years as Project(s) Data Architect.

 

SSRS, Crystal (BO), Tableau, Cognos w/Framework, Power BI, PowerView, PowerPivot, MDX and DAX

 

I have designed and created KPIs, Dashboards, Balanced Scorecards and Predictive Analytic Mapping,  run off the Transactional Databases, the Warehouse, the ODS or Data Marts; for a Boston Law Firm,  a Providence Law Firm, the Army, a Business Process Firm on two mine sites in Africa and a Providence Consulting Firm. I have worked in the Kimball Model with the snowflake or star schema and Inmon once with the snowflake schema.

 

Data Tools: Toad, Erwin, RedGate, Metadata Management and Repositories   

 

.NET: C#, VB.NET, Visual Studio (All Versions Visual Interdev through VS 2017), Python and Perl, Eclipse and Java, Azure Tools, HTML5, CSS

 

MS Server, all versions 2000 through  2016; VMWare and HYPER-V, PowerShell, IIS, Devop Tools

 

SharePoint:  12 Years (MCM) 2003 – 2016. Experience as Architect, Install, Configure and Developer,

 

Azure  (6 Projects); Azure Resource Manager, Azure Portal, Service Bus, Azure DW, App Services, VM, SQL, USQL, SSIS, Azure Data Factory, Azure Data Lake, Microservices, Functions, RedGate Data Platform, R, PolyBase, SSIS->Polybase External Tables, Azure REST API, Docker

 

Worked with Big Data benches of Hadoop, Hive, Pig, MapReduce, HBase, Storm, Kafka etc. Worked with Tomcat, Linux / Ubuntu. MongodB / NoSQL, Jenkins, Chef, Puppet

 

AWS (3 Projects); Elastic Beanstalk, Redshift, EC2 w/Docker, S3, Glacier, Data Migration Service, Lamda, Glue Preview

 

Dynamics CRM, Dynamics GP, Salesforce (with integration)

 

TFS, Microsoft Project (as SDLC and Hybrid Agile)

 

Migration and Integration Expert. Used SSIS, Datastage, Informatica, Talend, SSMA, Jitterbit, Boomi. Azure Data Factory, Talend

 

Have worked in multiple positions with ICD-9, ICD-10, CPT, DRG, HL-7, implemented HIPAA Regulations into Company Policy and Software, EDI for HCFA forms and UB04.

 

Professional Experience:

 

 

January 2018

 

Synchron Technology / Intellinet/NCR

 

Create Package 2017 SSIS Premises dB to new structure CSV Zip Files -> Create External Tables using Polybase for Consumption of CSV/Zip Compressed files. SSIS Package built with For Each Loop Container for tracking in monitor dB. Polybase package using REST API to post to monitor dB and consumed CSV/Zip files that have been ingested by Azure DW. Powershell.

 

September 2017 – December 2017

 

nTech Solutions

 

Power BI/SSRS->Consumption->Ingestion Break/Fix and Expand

Remote Support

Reporting SSRS and Power BI, Back End Data Flow Work:

Overall Control of Big Data Consumption through Ingestion was Talend Enterprise

Hadoop, Hortonworks, Hive, Yarn, Pig, Ambari, Resource Manager, Enterprise Talend, Azure SQL, Azure DW, USQL, Functions, Azure Data Factory

Hadoop and Azure Admin, Power BI Admin, Reporting Development & Remediation, Building Monitoring and Remediation Solutions, Docker, Azure Resource Manager, Jenkins, Linux, Powershell.

 

January 2017 - March 2017

 

Mindlance/IBM Inc. / KEMET, Inc. : Simpsonville, SC

 

Business Intelligence / Offshore Team Manager (Agile)

 

Managed Daily Scrum. of 3 Offshore Assets and 2 Onshore Assets. Developing hybrid SDLC/Agile Tool with MS Project Management with Agile Add On.

 

Team worked with DataStage, SSIS, SSRS, SSAS, Cognos, Power BI, PowerView, T-SQL, MS SQL 2016, PL/SQL, Oracle 12g, Paas

 

My Projects include Migration DB2->Oracle Data Warehouse to Azure Data Warehouse, Data Marts designed for Power BI Reporting.

 

 

January 2016 – November 2016

RSM Solutions Inc. Palatine, IL / SL Power Ventura CA

 

Senior BI/SQL Developer/DBA

 

Remote SQL Server Contract Databases, ETL, Stored Procedures, SSRS . Modify Data Sources, DataSet and reports to reflect a changed model for Finance and Operations to reflect Globalized RMB currency conversions required for compliance with new Chinese operating model/regulations. Debugging. Used SQLPerfmon, SSIS ETL, Stored Procedures, SSRS and Toad (for Reverse Engineering Data Architecture), Spotfire for secondary reporting.

 

Used Power BI for Data Mining and reverse engineering research. Toad for mapping Data Modeling.

 

Production is 2008 R2. Testing of 2014. Perfmon for query/stored procedure development. development

 

October 2015 – November 2015 (Contract Consultant)

 

Apex Systems

 

Senior Developer

 

Remote Contract Front End SharePoint Test and Code for Canadian Compliance (similar to Section 508 US).

 

April 2015 – September 2015 (Contract Consultant)

 

Capricorn Systems – US Office of Personnel Management Macon GA

 

Senior Cognos Developer, TFS Developer:

 

Framework Manager and Cognos Reports (10.2.X) with MS SQL and Oracle Data Sources. Additional tasks assigned were Heavy Cognos Testing, TFS, SharePoint (SSRS) and documentation.

 

Utilized Oracle and MS SQL 2014 Performance Tuning for Cognos Reports and Stored Procedure builds for TFS.

 

 

November 2013 – February 2015 (Contract Consultant)

 

PBManagement Providence

 

     Senior Consulting Infrastructure/Developer/Designer/Data Architecture

     Utility Infielder for Infrastructure and Development

 

Short term multiple contracts:

Azure Infrastructure with SaaS and PaaS, Monitoring and Controls, Scripting, Data Architect Work

SQL Development (2008 R2/2012) and reporting using SSRS, Crystal Reports, Cognos (8 & 10.1), and

SQL Development / Performance Tuning 2014 using Red Gate SQL Toolbelt and Erwin for Data Models

SQL Migration 2012->2014

Oracle ScoreCards using SSRS with supporting Data Mart

Tableau. Performance Tuning and Debugging.

Infrastructure maintenance and design: Active Directory, Networking and Upgrades.

SharePoint 2010 – 2013: Maintenance/Administration and SharePoint Components with Visual Studio.

MS SQL/MDX providing cubes for Excel Analysis of Data Center Costing

DW / Data Mart Development.

Azure Iaas and Paas. SSMA, SSIS

Microsoft Dynamics AX & CRM BI

Created Testing environment migration to HBase NoSQL Research environment.

Data Center Power Work

Informatica 9.X & SSIS

Migrate SharePoint 2010 Premises to Office 365 SharePoint Cloud. Used MetaLogix Tool Set

PWA Components for MS Project Server 2013 allowing remote Project Management

Customized Web Parts, Master Pages and Applications to SharePoint 2013 Apps

Dundas Integration to back end created SQL Data Marts. Integration both on .NET apps and SharePoint Web Parts.

SalesForce Reporting & Integration

Review AvePoint versus Metalogix versus Tzunami

Power Pivot. Power BI (PowerView), DAX

    Scorecards and KPIs for multiple clients.

Hadoop with Java. Hive, Pig, HBase, Squoop and NOSQL

MongoDB queries, creation, correction and performance

MS  SQL->MongoDB Migration

Dynamics GP 2013 R2 Configuration & Customization, Reporting DataMarts and Cubes

Test bench comparing configuration adjustments for Redshift reporting queries Vs. a Vs. Datamarts.

Test Bench comparing Redshift querying external Data.

 

 

           

 

Cyberay Solar Power

IT, Engineering and Presentation Work

        Dr.  David Disanto MD (Neurosurgeon)

        Mobile: 401-241-4444

 

May 2014 – July (Contractor)

 

       FRA LLC Providence

       Kevin Jarry Micro Tech Staffing Group

      Kevin.Jarry@mtsg.com

 

       SQL DBA 2008 R2, 2012 and 2014

       Migration 2008 R2->2014

       Performance Tuning and Debugging; Queries and Complex Stored Procedures.

Relativity Software Infrastructure Installs (Tool for Forensic Analysis requiring 6 Server Setup)

SharePoint 2010 Maintenance and SharePoint Components with Visual Studio.

MS Access driving backup system.

       SSAS for Cubes & SSRS Reporting

       SSMA for Database Move

     

 

 

November 2011 – October 2013 (Staff)

 

Senior System Architect / Data Architect BI Architect

 

Sokolove Law LLC / D50 Media: Wellesley, MA

 

Tasked to Review, Analyze, Retire and rebuild Infrastructure while maintaining Legacy and targeting maintenance of current operations while, expanding scope and moving key CRM application from 10 year old operational CRM system, in parts, to SalesForce Core linking back to new back-office system of ODS MS SQL databases, supporting 4 reporting systems; Cognos 10, Crystal, Tableau and SSRS, Goal was a consolidated and Automated BI System. Migrated non-MS RDMS to SQL Server using SSMA.

 

Supported and extended the Intranet and Customer facing extranet SharePoint Portal creating an improved indexing tool set with enhanced search for a 6 TB legal document database, critical to main LOB, and created customized components utilizing .NET tools, Upgraded to SharePoint 2010 and built a whole series of BI components for specialized data reporting and access in near real time, building out the back end Datamart with CDC and complex views for reporting. All controlled by Roles in Active Directory. Built out, customized, Administered and took through testing a 2013 SharePoint Installation.

 

After the analysis stage and planning for Legacy we retired 60 physical servers, regularized and expanded our Amazon AWS presence (this was the choice of the Social Media Teams) and built out a VMWARE 4.X Installation with a physical installation of 4.X VSPHERE and 3 Physical servers supporting 192 GB RAM; all this supporting 40+ VMs replacing everything from 2005 through 2008 Server and SQL. 6 Months later we switched to 5.X which allowed RAM expansion and SQL 2012. Added additional 30 VMs. Directly responsible for a growing Amazon AWS installation, supporting Social Media Data, Software Development needs and Microsoft Azure sites that supported Data Marts for reporting, SaaS for Development. Created scripting for support. Perfmon and SQL Toolbelt for Query/Stored Procedure Tuning.

 

Operations Azure; AD. Iaas, Paas. Data Marts supporting multiple Reporting Platforms.

 

Designed an ODS which had the real time operational role. Designed the Data Warehouse which served as the source for Datamarts, role specific for multiple reporting platforms. Data Modeling both in Legacy and New BI-Centric Model. Implemented Metadata Management for Legal Documents and Test Bench for Social Media Data.

 

The Data Warehouse was fed by the ODS which was populated by the Two CRM Packages (SFDC and ,NET Backoffice), Google Analytics and ETL transactions from purchased Databases and Government Data. Another Stream used Google Analytics Data populating specialized Data Marts with merged data for the Social Media Team and Predictive Analytics Team.

 

Office 365 Conversion.

 

Test Bench Hadoop (on Ubuntu) with Java, Apache Hive, Spark & Squoop Site for Data Mining in NoSQL. Decision made to stay with SQL 2012 for Data Mining. Built out Test Bench Dynamics AX.

Red Hat Bench with JBoss supporting jBPM (5) Workflow Test Bench for AWS Site supporting D50 Media Division.

 

Test Bench for Social Media Data using Redshift. Request was to offload data to S3 and creat GZIP files for delivery to Data Researchers using spreadsheets and Tableau. Second test was to create Data Marts with the same data. Component test for loading the same data into SQL for Data Marts in Operations.

 

Talend Operational Site for Big Data and Data Integration.

 

Led/executed the effort to identify a product, test and install/replace Backup Exec with AppAssure. Reduced maintenance (required by large quantity of tape swaps) 80% with no off hour presence local requirement or tape bays.  Managed 2 NX series NAS and a Legacy Power Vault SAN. 

 

Supported MS GP 2010 for Finance; Customization including ETL transfers to the ODS. Installed, upgraded and supported the Visual Studio 2012->TFS environment used by straight line development at Sokolove Law and the Social Media Environment (AWS based) at D50 Media.

 

In 2012 we began the effort to replace our principal .NET CRM system, Pivotal, with Salesforce. Tested two products in situ (Microsoft CRM and SalesForce. Management chose SFDC as the CRM,  Led/executed the effort to identify a product, test and install a near real time ETL / EDS Data Integration product (Jitterbit) that would both allow us to constantly stream data to and from SalesForce and the Data from Legacy Systems (MS SQL, Oracle, Google Analytics, Flat Files, Dynamics GP & CRM, and Files requiring specialized Disambiguation Software. A growing percentage of functions were replaced by SalesForce with the information returned to the Legacy CRM systems both for operation, archiving and reporting use. By 2014 the Local CRM system would be in SalesForce and the same near real time Data Integration ETL, Jitterbit, software would be morphed into a support system to stream data to a planned ODS (Operational Data Store) This would contain Operational and Back-Office Databases which would then automatically present feeds to support everything from a Data Warehouse to the four reporting engines to real time Dashboard Feeds to SharePoint and reporting Dashboards. SharePoint ASP.NET Entity Data Framework, MVC 3 Design Pattern were used.

 

I led/executed the effort to identify, test, install and support a new high end reporting product for the Analytics Group at Sokolove Law, LLC. The product was Tableau and it is still currently in use both for Predictive Analytics and reporting.

 

I built out the needed servers, installed and configured Tableau, built out needed Data Marts and the Repository, designed the first 25 reports, trained two SMEs and acted in general oversight for the product.

 

I designed and created KPIs, run off either the ODS or Data Marts.

 

I built Dashboards, Balanced Scorecards and Predictive Analytic Mapping.

 

Managed, designed and tested SSIS to replace Datastage and Informatica. All the while supported analysis, ETL dBs and Reporting covering everything from government table intakes to operational reporting to Google Analytics. Designed Cubes from ODS (MDX) to serve Finance Reporting in Excel with Power Pivot/Power View.

 

 

Implemented MS Project Server (2010 – Server and Professional) for SDLC controlling Major Hardware and Software Builds, PWA and Data Access control mechanisms inside SharePoint 2010.

 

Implemented TFS for Agile/Scrum Methodology.

 

Created KPIs for Management Controls, from multiple sources, assembled into Scorecards inside web parts.

 

Installed AWS test bench for Apache Cassandra. Tested with JDBC, CQL and NoSQL. Decision made that Cassandra Scaling was unnecessary so Test Bench retired.

 

Installed Test Bench for MongoDB in Azure, Migrated reduced scale set of Files and Databases from Master NAS and created MS SQL Data Marts to support existing Reporting/Dashboard platforms. Set up test Data Mining queries.

 

This was accomplished with a team of 5 people plus a single offshore Team.

 

December 2010 – October 2011:

 

Senior Developer: BI / SharePoint

 

Short Term Contracts in SQL (Design, ETL, Performance Tuning, Stored Procedures, Triggers and Debugging), SharePoint, .NET and BI Development. Three and Four week projects with hard deliverables. E.G. SSRS reports for consulting firm. Ongoing support for performance and updating SSRS Reports for Medical SAAS Package. Report and analysis contract (completed 04/28/2011) for Blue Mountain Labs (Bick Group) tasked me to install, analyze, test against client points of examination and report on (120 pages) on 7 major (7 identified by Blue Mountain Lab’s Fortune 500 client including Tableau 7 - 8, Panorama, QlikView, GoodData, MS BI Tools etc.); cloud based (in memory) and Hybrid Reporting packages. Used Amazon AWS. Microsoft SQL T-SQ, Globalized Orientation/ Localization and Oracle PL/SQL. Microsoft CRM customizations and reporting. Perfmon for Tuning.

 

February 2010 – November 2010 BI Lead - Implementation Services LLC Carmel, Indiana 46302

Work Sites at two gold mines in Africa (Red Back Mining, Now Kinross after merger) in Ghana and Mauritania. Implementation Services LLC is a Business Process Consulting firm. Data Architecture & Design  with hands on SQL DBA and BI development using SSIS and SSAS design for ETL conversion from diverse client platforms (MS SQL, Oracle, Paradox, Access etc.) to Consolidated SQL 2008 Data Mart driving proprietary BI software, Performance Analytix^tm . BI Architect: Built Data Warehouse for standard reporting. Training client users (expats and locals) in use of same, in French where applicable; in Mauritania and Ghana. IT Consulting ranging from network redesign, Data Conversion Platforms (MS SQL & Oracle PL/SQL using Erwin for Data Modeling, Oracle Forms, Wireless Designs and Software Redesign, Development and reconfiguration to support engineering retraining and process re-engineering. Integrated data to ODS and downstream to Data Warehouse from Mainpac (Logistics and Asset Management), Sun Financials, Connections to Dynamics CRM & GP, Chemical Processing Data and Heavy Machinery Feeds ( IOT ); built custom data feeds to Dundas Dashboards. Implemented MS Project Server and Professional, 2010, SDLC, All work set up so as to feed 2007 converted to 2010 SharePoint installation and ASP.NET. Created scorecards with data driven KPIs. Entire system Globalized Orientation / Localization. Designed Dashboards. Designed test bench Azure cloud for Data Marts delivered over satellite downlink. Trained Administrator of new system. MVC 2 Design Pattern.

 

November 2009 – January 2010 Corporate Technologies / Intermountain Technology Group 4795 Emerald Street Boise ID 83706 208-319-2770 – Sara Stamp. Client: Rhode Island Resource Recovery Johnson, RI Statewide Landfill and Recycling operation. Business Intelligence Consulting for establishing reporting mechanisms and data mining. OLAP Cube design, MDX, building and deployment. Tools: 2008 Server, SSIS, SSAS, Visual Studio, SSRS, Excel, Business Objects

 

August 2009 – October 2009  TXPractitioner^tm (see below) Data Architect and Development Role: Project to upgrade Database to MS SQL Server 2008 and Billing Component to .NET with EDI automation. VB.NET, ASP.NET 3.5, Ajax w/JavaScript and DHTML, Replaced Crystal with SSRS. Reporting front end bolted into SharePoint 2007 installation with Silverlight Components.

 

November 2008 – 05/29/2009   Senior SharePoint Developer - Development Division DOIM – Business Intelligence - SharePoint Team: Letterkenny Army Depot (LEAD), Chambersburg, PA - US Army (Contracted through TekSystems, Harrisburg PA).

 

Letterkenny is a US Army Munitions and Maintenance Facility with 2400 employees with the mission of storing Munitions and Maintenance, Repair and Upgrades of everything from Humvees, Armored Vehicles, Patriot Missiles and complex Logistical Assemblies to support the Warfighter in the field.

 

Implemented tools for Business Intelligence effort combining data within SharePoint 2007 from custom (.net w/ASP.NET 3.5 with Ajax, JavaScript and DHTML) front ends, Oracle, MS SQL Server (2005), Mainframe Extracts, XML Databases and the Army’s LMP System (SAP). Wrote custom reporting devices, SSIS modules, Cubes with SSAS and SSRS reports accessing Oracle and SQL Server Databases. Built applications, Workflows/InfoPath forms and SSRS Report Modules for Blackout/Brownout Period between Mainframe Shutdowns and LMP coming online as well as other solutions.

 

All Development/Reporting created to output through SharePoint to customer business units. Custom Web Parts and Scorecards/KPI used for specialized informational purposes and custom front page presentations. Customized, and specialized Silverlight web parts, Business Unit front pages redesigned within SharePoint Parts Modified with .NET, CML and XSLT.

 

Principal Tools were Visual Studio 2008, TFS and Microsoft Project Server. Implemented Project Server and SharePoint Elements to control 6 Sigma micro-projects. Developed Hybrid Project Server utilizing Agile components.

 

Architected Infrastructure and Set up Server Farms for Test & Development based on SharePoint 2007, Project Server 2007 and BizTalk 2006. Trained PM Personnel in application of MS Project Management (Project Manager 2007->Project Server). Analyzed opportunities for using and developing protocols and custom code for long running process controls with BizTalk. Oracle DBA and developed cubes accessing multiple sources so internal customers can access with their report devices and generate their own one off reports. Set up test device for SQL Server 2008.

 

September 2007 – November 2008   GIDS Project, Pfizer, Inc. (Contracted through Tri-Com Consulting Group)

 

Tech Lead

 

Tech Lead on GIDS (Globalized Information Dissemination System) Project. SharePoint based platform project utilized highly customized BDC, components and indexing. Implemented and coordinated the Architectural and technical aspects of delivery on distributed Pfizer Platform of Factiva/Dow Jones News Aggregator and other Feeds to 90,000 employees on Globalized company-wide SharePoint Platform (Automatic Globalized Orientation / Localization for language, time and currencies 4 continents).. Delivery mechanisms included a mix of Factiva’s software front ends, customized .NET (VB.NET, C# and ASP.NET 3.5) upgrades of existing apps controlled by Globalized teams with locations spread between New York and India, SQL Server 2005 w/XML RSS Feeds and customized SharePoint 2007 Portals/MOSS 2007 modified/configured with .NET, XML and XSLT. Principal Programming tool was Visual Studio, Coordinated Offshore teams migrating from Plumtree to SharePoint 2007 and managed using customized Team Sites. Used Informatica for legacy databases. Created aggregator specific web parts and components for dissemination to IP Teams. Consulted with and coordinated groups of Internal Information Professionals; development teams located in Globalized company core sites. Set up Templated SharePoint Sites to communicate change management information, Scorecards with KPIs, Always approached as SaaS. Learning Resources, programming guidelines and standards. Responsible for Paper Documentation on critical parts of the Change Management and SDLC work flows. Developed a web based security application to control access between Pfizer and Factiva/Dow Jones. Contributed to and documented the Full Life Cycle Control and Reporting requirements for technical matters ranging from Design, Performance, Testing and Engineering Requirements. Go live date was March 14, 2008 for Release 1 and October 3, 2008 for Release 2. Completed analysis, architecture and requirements documents and prototypes for the next stage Knowledge Management and Dissemination Tool Sets for high level SharePoint Sites.

 

April 2002 – September 2007  

 

LEAD TECHNOLOGIST  

      

ReservoirTech Inc. Providence, RI

 

ReservoirTech is a service intensive VAR with special skill sets in service intensive hardware delivery and implementation, VOIP phone systems with infrastructure integration and software product and projects; execution, management and delivery.

 

Integrated with Custom Software on Client Sites. Lead technologist and Project manager serving in sales suppo