SUMMARY

• Enterprise Solution Architect, Data Architect leading a team of five DBAs with the charge of building out a data warehouse with SQL 2008 R2 Enterprise MS SQL Server in a clustered and highly available architecture.
• Project management experience in Enterprise - level application development with Analyst experience involving multiple projects with Fortune 500 clients.
• Database Modeling, Designing, and Implementing SSAS cubes with Kimball philosophies in data warehousing using ERWIN, PowerDesigner and Visio.
• Adept at SSIS, SSRS, and SSAS 2005/16 administration, SQL clustering and database modeling, database security implementation and architecture, and Enterprise level architecture and Business Intelligence delivery.
• Skilled at SharePoint 2010 along with Performance Point to offer interrogation of data cubes, creating dashboards to house Performance Point reports, SSRS and excel power pivot spreadsheets.
• Consistently engaged in understand the next needs for capacity in terms of servers, IO, memory and processing power to process database cubes, SSIS package and SSRS reports along with database capacity and security requirements.
• Design and implement Continuity of Business solutions, data warehouse solutions for SQL Server databases including Replication strategy and Active-Active and Active-Passive clustering
• Experience in deploying SQL Server HADR (log shipping, Replication Always On, Mirroring, Failover cluster instances).
• Implemented and Maintenance of all (HA) High Availability configurations like Log Shipping, Database Mirroring, Replication and Failover Clustering as a part of HADR Plan.
• Develop Replication on production databases for faster reporting and maximizing production performance.
• Provide expert knowledge on SQL best practices, including index structures, partitioning, DMVs, clustering, Replication, database mirroring and log shipping.
• Microsoft SQL Server database development, design and administration including T-SQL, Stored Procedures, SSIS, SSMS, SSRS, SQL Agent, Replication and SQL Profiler
• Microsoft .Net troubleshooting and development 20 years’ experience
• Kafka, Spark, and Hadoop experience
• Azure architecting data warehousing along AWS, and Google Hosting.

TECHNICAL SKILLS

Tools: /Systems/Applications: Windows Server 4.0-2012, MS SQL 7.0-2019, IIS 4.0-7.0, Visual Studio 2000-2019, Access 97-2020, Exchange 4.5-Exchange 2003, SharePoint Server 2003/2016, MS Office 95-365, SSIS, PHP, Python, MySQL, Apache, Visio, MS Project, Dreamweaver, Photoshop, and Several Different Antivirus Products, Excel 2013, Power Query, PowerBI.

PROFESSIONAL EXPERIENCE

Confidential

Enterprise Solution Architect / Data Architect

Responsibilities:

• Developed Business Requirements, Architecture Documents to build a data warehouse structure including data modeling and dimensional structure for financial/operational business reporting.
• Using a Microsoft General Dynamics accounting database, built an operational reporting and profitability Tabular model to reflect the data flowing into the enterprise.
• Worked to identify data gaps and modeled structures to provide cohesive reporting where source data failed to consistently populate data fields.
• Recommended processes to provide reporting to quickly identify actionable information and developed Power BI reports to interrogate the Tabular models connected through Office365.
• Developed DAX formulas to provide rapid statistical analysis of the data from within the Tabular model connecting millions of records with Data, Regional, Geographical and Operational dimensions.

Confidential

Data Architect - Project Manager

Responsibilities:

• Designed, Developed and Implemented a python 3 based AI/ML system which allowed for the searching of knowledge to store in a SQL and no-SQL databases.
• Along with porting the application to a mobile environment (Android).
• Designed the interface to manage the application building the neural network to train and model the results along with composing reports in Matplotlib and Excel/PowerBI.
• Modelled and implemented data models with SSAS Tabular Models along with composing DAX formulas to calculate complex equations to deliver precalculated results. Used SSIS for automating ETL pulls from diverse data sources (Oracle, .CSV files, and Hadoop).
• Organized AD groups to control access to through the PowerBI Gateway (Office365) and managed security through AD groups.
• Modelled, built and implemented stage, ODS, and data marts to structure data flow for the data life cycle.

Confidential

Data Architect

Responsibilities:

• Developed Business Requirements, Project Plan, Architecture Documents and Development to enhance a data warehouse structure including data modeling and dimensional structure for financial business reporting.
• Uploaded Salesforce data while using Power BI to check data in an independent data mart.
• Managed SSIS ETL data feeds from flat files and Oracle data sources along with creating stored procedures to standardize data transformations.
• Developed the solutions architecture for providing a dimensional model for then implementation of the data warehouse.

Confidential

Enterprise Data Architect / BI Data Architect

Responsibilities:

• Developed Business Requirements, Project Plan, Architecture Documents and Development to build a data warehouse structure including data modeling and dimensional structure for financial business reporting.
• Using a Microsoft General Dynamics accounting database, I built the income and churn Tabular model to reflect the data flowing into the enterprise. I also created an ETL system which functioned in real time to shed light on the sales team’s progress of closing sales.
• Tableau was the delivery method to the end users, so working with the Tableau developer was essential in understanding the methods of producing calculations that could be easily explained to “C” Level executives. Developed, modeled and designed Salesforce data structures.