Director of Data Solutions and Architectures

• Jun 2020 - Present

Sr. Big Data Solution Architect

• Jun 2020 - Present

• Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure. • Architect solutions using MS Azure PaaS services such as SQL Server, HDInsight, service bus, etc • Provide technical oversight and guidance during client’s engagement execution. • Provide Cloud / Azure thought leadership through regular publications and speaking engagements. • Provide Azure technical expertise including strategic design and architectural mentorship… Show more • Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure. • Architect solutions using MS Azure PaaS services such as SQL Server, HDInsight, service bus, etc • Provide technical oversight and guidance during client’s engagement execution. • Provide Cloud / Azure thought leadership through regular publications and speaking engagements. • Provide Azure technical expertise including strategic design and architectural mentorship, assessments, POCs, etc., in support of the overall sales lifecycle or consulting engagement process. • Support the development and growth of Clearly Agile Cloud Services and Consulting Practice. • Responsible for the extraction, transformation and loading of data utilizing Snaplogic into our Data Federation Platform, TIBCO TDV. • Responsible for the development of Hive External and Internal tables which serve as the staging area for project’s Federation Platform. • Responsible for the understanding of Hadoop ecosystems components HDFS, YARN, MapReduce, Common, etc. • Responsible for the coordination of staging extracted data into various Azure BLOB storage containers. • Responsible for the handling of extracting data from data sources such as DB2, PostgreSQL, SQL, MySQL, MongoDB, Salesfore (REST API) among others. • Responsible for understanding data extraction from various REST API platforms utilizing Postman. • Responsible for coordinating the execution of PySpark data pipelines via Zeppelin notebooks. • Responsible for the Data Modeling required to merge Data Source’s Data into a Common Entity Model destination platform producing all needed mapping documents. • Responsible for the development of Machine Learning Models to implement Artificial Intelligence for various inhouse applications utilizing Scikit-learn and ML .NET • Responsible for the development of Applications utilizing the Microsoft Dynamics 365, Microsoft Common Data Services, PowerApps. Show less • Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure. • Architect solutions using MS Azure PaaS services such as SQL Server, HDInsight, service bus, etc • Provide technical oversight and guidance during client’s engagement execution. • Provide Cloud / Azure thought leadership through regular publications and speaking engagements. • Provide Azure technical expertise including strategic design and architectural mentorship… Show more • Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure. • Architect solutions using MS Azure PaaS services such as SQL Server, HDInsight, service bus, etc • Provide technical oversight and guidance during client’s engagement execution. • Provide Cloud / Azure thought leadership through regular publications and speaking engagements. • Provide Azure technical expertise including strategic design and architectural mentorship, assessments, POCs, etc., in support of the overall sales lifecycle or consulting engagement process. • Support the development and growth of Clearly Agile Cloud Services and Consulting Practice. • Responsible for the extraction, transformation and loading of data utilizing Snaplogic into our Data Federation Platform, TIBCO TDV. • Responsible for the development of Hive External and Internal tables which serve as the staging area for project’s Federation Platform. • Responsible for the understanding of Hadoop ecosystems components HDFS, YARN, MapReduce, Common, etc. • Responsible for the coordination of staging extracted data into various Azure BLOB storage containers. • Responsible for the handling of extracting data from data sources such as DB2, PostgreSQL, SQL, MySQL, MongoDB, Salesfore (REST API) among others. • Responsible for understanding data extraction from various REST API platforms utilizing Postman. • Responsible for coordinating the execution of PySpark data pipelines via Zeppelin notebooks. • Responsible for the Data Modeling required to merge Data Source’s Data into a Common Entity Model destination platform producing all needed mapping documents. • Responsible for the development of Machine Learning Models to implement Artificial Intelligence for various inhouse applications utilizing Scikit-learn and ML .NET • Responsible for the development of Applications utilizing the Microsoft Dynamics 365, Microsoft Common Data Services, PowerApps. Show less

Senior BI Manager (Consultant)

• Sep 2017 - May 2018

• Optimized SSIS packages in order to reduce their time of execution and ergo avoid schedule conflicts. • Successfully investigated and resolved issues with RDMS in our production environment. • Developed a SQL solutions utilizing T-SQL, SSIS and SSRS to streamline the billing process of the company. • Developed a SQL solutions utilizing T-SQL, SSIS to streamline the pricing process of the company. • Successfully assisted in house DBAs troubleshoot obscure issues occurring in… Show more • Optimized SSIS packages in order to reduce their time of execution and ergo avoid schedule conflicts. • Successfully investigated and resolved issues with RDMS in our production environment. • Developed a SQL solutions utilizing T-SQL, SSIS and SSRS to streamline the billing process of the company. • Developed a SQL solutions utilizing T-SQL, SSIS to streamline the pricing process of the company. • Successfully assisted in house DBAs troubleshoot obscure issues occurring in our production environment. • Successfully assisted with the addressing of Tech Debt found around their Data Warehouse environment. • Troubleshooted and fixed tens of bugs found in the different already built DB in-house solutions. Show less • Optimized SSIS packages in order to reduce their time of execution and ergo avoid schedule conflicts. • Successfully investigated and resolved issues with RDMS in our production environment. • Developed a SQL solutions utilizing T-SQL, SSIS and SSRS to streamline the billing process of the company. • Developed a SQL solutions utilizing T-SQL, SSIS to streamline the pricing process of the company. • Successfully assisted in house DBAs troubleshoot obscure issues occurring in… Show more • Optimized SSIS packages in order to reduce their time of execution and ergo avoid schedule conflicts. • Successfully investigated and resolved issues with RDMS in our production environment. • Developed a SQL solutions utilizing T-SQL, SSIS and SSRS to streamline the billing process of the company. • Developed a SQL solutions utilizing T-SQL, SSIS to streamline the pricing process of the company. • Successfully assisted in house DBAs troubleshoot obscure issues occurring in our production environment. • Successfully assisted with the addressing of Tech Debt found around their Data Warehouse environment. • Troubleshooted and fixed tens of bugs found in the different already built DB in-house solutions. Show less

DBA/Data Architect (Consultant)

• Aug 2016 - Aug 2017

• Responsible for the assessment and implementation of the company’s Data Warehouse. • Responsible for the implementation of a Data Governance Committee. This committee aimed at the analysis and optimization of all company’s workflows responsible for bringing in all data needed for the successful implementation of all Data Marts identified as needed by the business. • Implement data quality, data integrity, and data standardization efforts across key products and databases to establish a… Show more • Responsible for the assessment and implementation of the company’s Data Warehouse. • Responsible for the implementation of a Data Governance Committee. This committee aimed at the analysis and optimization of all company’s workflows responsible for bringing in all data needed for the successful implementation of all Data Marts identified as needed by the business. • Implement data quality, data integrity, and data standardization efforts across key products and databases to establish a foundation for enabling key business processes and applications. • Responsible for the profiling of data to determine what reporting products we could immediately generate when compared against the list of data needs by the business. • Responsible for providing a Road Map for the final goal of building a sustainable and reliable Data Warehouse from which all company’s reports reported on. • Responsible for the design and implementation of hundreds of reports the company was in immediate need. • Responsible for overseeing a group of SQL developers and reports makers to insure quality assurance in the products they made. • Facilitate sessions with business and technology stakeholders to define and implement actionable metrics, key performance indicators (KPI) and data visualizations to support the reporting needs. • Responsible for maintaining our BI Infrastructure which the company utilized Zap BI as the product of preference. • Responsible for maintaining all Database Servers (SQL, PostgreSQL) the company had implemented to support the various business application in use. • Responsible for maintaining and implementing a Business Intelligence infrastructure utilizing Microsoft BI Stack (SSRS,SSIS and SSAS) utilizing in parallel Zap BI. Show less • Responsible for the assessment and implementation of the company’s Data Warehouse. • Responsible for the implementation of a Data Governance Committee. This committee aimed at the analysis and optimization of all company’s workflows responsible for bringing in all data needed for the successful implementation of all Data Marts identified as needed by the business. • Implement data quality, data integrity, and data standardization efforts across key products and databases to establish a… Show more • Responsible for the assessment and implementation of the company’s Data Warehouse. • Responsible for the implementation of a Data Governance Committee. This committee aimed at the analysis and optimization of all company’s workflows responsible for bringing in all data needed for the successful implementation of all Data Marts identified as needed by the business. • Implement data quality, data integrity, and data standardization efforts across key products and databases to establish a foundation for enabling key business processes and applications. • Responsible for the profiling of data to determine what reporting products we could immediately generate when compared against the list of data needs by the business. • Responsible for providing a Road Map for the final goal of building a sustainable and reliable Data Warehouse from which all company’s reports reported on. • Responsible for the design and implementation of hundreds of reports the company was in immediate need. • Responsible for overseeing a group of SQL developers and reports makers to insure quality assurance in the products they made. • Facilitate sessions with business and technology stakeholders to define and implement actionable metrics, key performance indicators (KPI) and data visualizations to support the reporting needs. • Responsible for maintaining our BI Infrastructure which the company utilized Zap BI as the product of preference. • Responsible for maintaining all Database Servers (SQL, PostgreSQL) the company had implemented to support the various business application in use. • Responsible for maintaining and implementing a Business Intelligence infrastructure utilizing Microsoft BI Stack (SSRS,SSIS and SSAS) utilizing in parallel Zap BI. Show less

DBA/Data Architect (Consultant)

• Jun 2014 - Jul 2016

• Responsible for implementing a Datawharehouse infrastructure with different data sources such as MySQL, SQL 2008 R2, Access Databases as well as Excel and Flat Files. • Responsible for the automation of internal financial buisness processes relevant to commissions, billing, collections and other accounting departments. • Responsible for the analysis and interpretations of legacy systems and processes in place. • Responsible for the re-design and implementation of exising legacy… Show more • Responsible for implementing a Datawharehouse infrastructure with different data sources such as MySQL, SQL 2008 R2, Access Databases as well as Excel and Flat Files. • Responsible for the automation of internal financial buisness processes relevant to commissions, billing, collections and other accounting departments. • Responsible for the analysis and interpretations of legacy systems and processes in place. • Responsible for the re-design and implementation of exising legacy systems and processes. • Responsible for the implementation and maintanaince of a Buisness Intelligence infrasructure. This includes SSRS, SSIS, and SSAS. Show less • Responsible for implementing a Datawharehouse infrastructure with different data sources such as MySQL, SQL 2008 R2, Access Databases as well as Excel and Flat Files. • Responsible for the automation of internal financial buisness processes relevant to commissions, billing, collections and other accounting departments. • Responsible for the analysis and interpretations of legacy systems and processes in place. • Responsible for the re-design and implementation of exising legacy… Show more • Responsible for implementing a Datawharehouse infrastructure with different data sources such as MySQL, SQL 2008 R2, Access Databases as well as Excel and Flat Files. • Responsible for the automation of internal financial buisness processes relevant to commissions, billing, collections and other accounting departments. • Responsible for the analysis and interpretations of legacy systems and processes in place. • Responsible for the re-design and implementation of exising legacy systems and processes. • Responsible for the implementation and maintanaince of a Buisness Intelligence infrasructure. This includes SSRS, SSIS, and SSAS. Show less

SQL Developer (Consultant)

• Feb 2014 - Jun 2014

• Responsible for the development of optimized SQL server store procedures called and needed by front end web applications. • Responsible for the development of SSRS reports required by different key departments within the company. • Responsible for the troubleshooting of databases whenever needed. • Responsible for collaborating on the design and implementation of databases and its relevant objects. • Participant and main collaborator of detecting access problems to in house… Show more • Responsible for the development of optimized SQL server store procedures called and needed by front end web applications. • Responsible for the development of SSRS reports required by different key departments within the company. • Responsible for the troubleshooting of databases whenever needed. • Responsible for collaborating on the design and implementation of databases and its relevant objects. • Participant and main collaborator of detecting access problems to in house database servers whenever they occurred. • Responbsible for implementing SSIS solutions that automated the Importation and Exportation of client's consumable data. • Responsible for the research, analysis and design of ad-hoc solutions to address client's request. Show less • Responsible for the development of optimized SQL server store procedures called and needed by front end web applications. • Responsible for the development of SSRS reports required by different key departments within the company. • Responsible for the troubleshooting of databases whenever needed. • Responsible for collaborating on the design and implementation of databases and its relevant objects. • Participant and main collaborator of detecting access problems to in house… Show more • Responsible for the development of optimized SQL server store procedures called and needed by front end web applications. • Responsible for the development of SSRS reports required by different key departments within the company. • Responsible for the troubleshooting of databases whenever needed. • Responsible for collaborating on the design and implementation of databases and its relevant objects. • Participant and main collaborator of detecting access problems to in house database servers whenever they occurred. • Responbsible for implementing SSIS solutions that automated the Importation and Exportation of client's consumable data. • Responsible for the research, analysis and design of ad-hoc solutions to address client's request. Show less

BI - SQL Lead Developer

• May 2013 - Sep 2013

• Responsible for the conversion of Crystal Reports to SSRS Reports. • Responsible for the training of senior staff members about SQL SSRS solutions. • Responsible for administering the right configuration and deployment of SSRS solutions. • Responsible for assisting Management staff with the configuration and maintenance of Reporting Services Server. • Responsible for the conversion of Crystal Reports to SSRS Reports. • Responsible for the training of senior staff members about SQL SSRS solutions. • Responsible for administering the right configuration and deployment of SSRS solutions. • Responsible for assisting Management staff with the configuration and maintenance of Reporting Services Server.

SQL Developer

• May 2012 - Apr 2013

• Responsible for developing complex SSIS interfaces to handle inbound and outbound interchange of business-client data. • Responsible for the debugging/modification of already developed complex SSIS interfaces to meet changes in the business rules governing them. • Responsible for testing on SSIS Interfaces developed by other team members. • Responsible for developing complex SSRS reports used by the executive team of the company. • Responsible for debugging and/or modifying… Show more • Responsible for developing complex SSIS interfaces to handle inbound and outbound interchange of business-client data. • Responsible for the debugging/modification of already developed complex SSIS interfaces to meet changes in the business rules governing them. • Responsible for testing on SSIS Interfaces developed by other team members. • Responsible for developing complex SSRS reports used by the executive team of the company. • Responsible for debugging and/or modifying already developed SSRS reports. • Responsible for migrating SSIS 2005 packages to SSIS 2008. • Responsible for patching/developing multiple parameterized Store Procedures utilized to support different new and existing in-house applications. • Responsible for the analysis and implementation of DB schema modifications needed to support requested projects. • Responsible for tuning the performance and analysis of the behavior of existing SSIS/SSRS solutions utilizing Execution Plan, Database Engine Tuning Advisor and SQL Profiler. Show less • Responsible for developing complex SSIS interfaces to handle inbound and outbound interchange of business-client data. • Responsible for the debugging/modification of already developed complex SSIS interfaces to meet changes in the business rules governing them. • Responsible for testing on SSIS Interfaces developed by other team members. • Responsible for developing complex SSRS reports used by the executive team of the company. • Responsible for debugging and/or modifying… Show more • Responsible for developing complex SSIS interfaces to handle inbound and outbound interchange of business-client data. • Responsible for the debugging/modification of already developed complex SSIS interfaces to meet changes in the business rules governing them. • Responsible for testing on SSIS Interfaces developed by other team members. • Responsible for developing complex SSRS reports used by the executive team of the company. • Responsible for debugging and/or modifying already developed SSRS reports. • Responsible for migrating SSIS 2005 packages to SSIS 2008. • Responsible for patching/developing multiple parameterized Store Procedures utilized to support different new and existing in-house applications. • Responsible for the analysis and implementation of DB schema modifications needed to support requested projects. • Responsible for tuning the performance and analysis of the behavior of existing SSIS/SSRS solutions utilizing Execution Plan, Database Engine Tuning Advisor and SQL Profiler. Show less

Software and Systems Engineer

• Jun 2003 - Apr 2012

• Responsible for the developing and maintenance of in-house already developed SQL based software. • Responsible for the formulations of RAD documents for new to develop solutions. • Responsible for the recommendation and accessing of new technologies. • Responsible for the implementation of new third party software whenever a merging occurred or a partnership took place. • Responsible for the development and deployment of web applications utilizing Visual Studio 2010 and IIS… Show more • Responsible for the developing and maintenance of in-house already developed SQL based software. • Responsible for the formulations of RAD documents for new to develop solutions. • Responsible for the recommendation and accessing of new technologies. • Responsible for the implementation of new third party software whenever a merging occurred or a partnership took place. • Responsible for the development and deployment of web applications utilizing Visual Studio 2010 and IIS 6.0/7.0 • Responsible for the quick resolution of Network Issues whenever they occurred. • Responsible for the configuration of network peripherals (Cisco) needed for connecting remote offices nationwide. • Lead administrator of our Active Directory, SQL, DNS, DHCP, MS Exchange, IIS servers. • Responsible for configuring rules in our PIX firewalls to comply with our security policies and company expansion. • Responsible for the deployment and construction of hardware servers to support software solutions designed to address business logistics. • Responsible for the right deployment and implementation of third party enterprise solutions. • Responsible for the recommendation and accessing of new technologies. • Responsible for the implementation of new third party software whenever a merging occurred or a partnership took place. • Responsible for the quick resolution of Network Issues whenever they occurred. Show less • Responsible for the developing and maintenance of in-house already developed SQL based software. • Responsible for the formulations of RAD documents for new to develop solutions. • Responsible for the recommendation and accessing of new technologies. • Responsible for the implementation of new third party software whenever a merging occurred or a partnership took place. • Responsible for the development and deployment of web applications utilizing Visual Studio 2010 and IIS… Show more • Responsible for the developing and maintenance of in-house already developed SQL based software. • Responsible for the formulations of RAD documents for new to develop solutions. • Responsible for the recommendation and accessing of new technologies. • Responsible for the implementation of new third party software whenever a merging occurred or a partnership took place. • Responsible for the development and deployment of web applications utilizing Visual Studio 2010 and IIS 6.0/7.0 • Responsible for the quick resolution of Network Issues whenever they occurred. • Responsible for the configuration of network peripherals (Cisco) needed for connecting remote offices nationwide. • Lead administrator of our Active Directory, SQL, DNS, DHCP, MS Exchange, IIS servers. • Responsible for configuring rules in our PIX firewalls to comply with our security policies and company expansion. • Responsible for the deployment and construction of hardware servers to support software solutions designed to address business logistics. • Responsible for the right deployment and implementation of third party enterprise solutions. • Responsible for the recommendation and accessing of new technologies. • Responsible for the implementation of new third party software whenever a merging occurred or a partnership took place. • Responsible for the quick resolution of Network Issues whenever they occurred. Show less

Software Engineer

• 2001 - 2003

• Responsible for developing dashboard for in house telecommunication switches. • Responsible for contributing in the analysis and design of software solutions to support internal needs. • Responsible for developing needed telecommunication modules applicable to internal communication systems. • Responsible for the developing of design and functionality documents for all software developed. • Responsible for training staff in the usage of all developed software. • Responsible for… Show more • Responsible for developing dashboard for in house telecommunication switches. • Responsible for contributing in the analysis and design of software solutions to support internal needs. • Responsible for developing needed telecommunication modules applicable to internal communication systems. • Responsible for the developing of design and functionality documents for all software developed. • Responsible for training staff in the usage of all developed software. • Responsible for assisting in the deployment and testing of all developed software. Show less • Responsible for developing dashboard for in house telecommunication switches. • Responsible for contributing in the analysis and design of software solutions to support internal needs. • Responsible for developing needed telecommunication modules applicable to internal communication systems. • Responsible for the developing of design and functionality documents for all software developed. • Responsible for training staff in the usage of all developed software. • Responsible for… Show more • Responsible for developing dashboard for in house telecommunication switches. • Responsible for contributing in the analysis and design of software solutions to support internal needs. • Responsible for developing needed telecommunication modules applicable to internal communication systems. • Responsible for the developing of design and functionality documents for all software developed. • Responsible for training staff in the usage of all developed software. • Responsible for assisting in the deployment and testing of all developed software. Show less