TECHNICAL SKILLS

• Azure Data Factory
• Azure Date Lake (Gen1/Gen2)
• HDInsight
• Azure Data Lake Analytics
• Azure Databricks
• Azure SQL Datawarehouse
• Azure SSAS
• Azure Databricks
• Azure Service Bus
• CosmoDB
• TOAD
• Java
• .NET C#/VB.Net
• WebServices
• Power BI
• SSIS
• SSAS
• SSRS
• Informatica
• MongoDB(NoSql)
• Oracle 10g/11g
• DB2
• DB2i
• Tableau
• Cognos 10/11
• Visio
• PowerShell Scripting
• Spark
• Hadoop
• Sharepoint
• Windows Server
• Power Point
• Excel
• Word
• Erwin
• DAX
• MDX
• SQL SERVER
• MYSQL
• PostGresSQL
• Amazon Web Services (AWS)
• Amazon S3
• CDC Attunity/Microsoft
• Agile Jira
• HyperV/VMware

PROFESSIONAL EXPERIENCE

Confidential, FL

TECHNICAL SOLUTIONS DATA ARCHITECT

Responsibilities:

• Lead technical sessions, perform technical analysis and produce technical documentation relating to the overall architecture of each integration project.
• Provide expert level assistance and guidance to TBC’s development teams regarding design best practices and technical issues.
• Work directly with project stakeholders to define and document the use cases, functional / non - functional requirements, and gaps, for each integration project.
• Maintained a high degree of business functional knowledge
• Participated in design sessions, detailed design documentation, technology evaluations, definition of deliverables and MVPs - specifically data models, dictionaries and related data knowledge-base.
• Carried a lead role around the core data modeling tasks for ingestion through to consumption. Including but not limited to; conceptual, logical and physical modeling, data curation and meta-data management topics.
• Provided critical input to the integration of meta-data into the platform design in order to be data driven.
• Maintained knowledge of technology roadmaps, vendor application roadmaps, industry trends and shares knowledge of risks, opportunities and services available to build a competitive advantage and improve efficiency and effectiveness of the business in specific relation to the capturing, transformation and quality of enterprise data.
• Worked with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimized and updated logical and physical data models to support new and existing projects.
• Maintained conceptual, logical and physical data models along with corresponding metadata.
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Installed/Configured and deployed Master Data Services (MDS) to manage organization data into models/entities and create the rules for updating data and control the users who updates the data.
• Recommended opportunities for reuse of data models in new environments.
• Design data solutions for our customers using the enterprise data modeling tools such as Erwin Data Modeler, and Idera ER/Studio
• Designed all normal form models and Star Schema/ and Snowflake including MDM attribute modelling
• Performed reverse engineering of physical data models from databases and SQL scripts.
• Evaluated data models and physical databases for variances and discrepancies.
• Validated business data objects for accuracy and completeness.
• Analyzed data-related system integration challenges and propose appropriate solutions.
• Developed data models according to company standards.
• Experience in defining logical and physical data models; and RDBMS and NoSQL databases ( MongoDB, MS Azure Cosmos)
• Deployed SQL Server Data Distribution and disaster recovery methodologies Replication, Database Mirroring, and AlwaysOn and SQLLite DB Backup.
• Designed/maintained and enforced quality control programs throughout the Enterprise Data Warehouse via via Micro Services and Azure Machine Learning Services, also include testing data automation processes.
• Design and promote AWS data pipelines, AWS DataSync bi-directional transfer results to AWS Amazon S3 then Amazon RDS SQL Server, and Amazon RDS PostgresSQL .
• Uploaded files to Amazon S3 using Python scripts
• Worked with various Data stewards to enforce security throughout the reports and data repository layers.
• Lead weekly sessions with dba’s and architects identifying processes with low performance scores and strategies on how we can improve them.
• CO-Lead business requirement sessions with internal clients and propose best practices for data integration, security and data distribution. All business requirements were managed through an agile process (Jira tool).
• Designed developed backend, middleware and front end processes Angular 4,Vb.net/C#
• Worked with complex data formats/interfaces such as VSAM, XML, JSON .
• Developed processes in SSIS/PowerShell to support “continuous” integration on Windows Application Servers
• Extensive SSAS Development (MDX Scripting)/ Auto Partition Strategies. SSAS .Net Assembly development. Dimension development and design. Auto Security Administration.
• Development of real time operations SSRS reports and Power BI dashboards using metrics that measure high availability and throughput .
• Developed azure based monitoring, alerting and active monitoring of risks to site SLA’s
• Developed and deployed Integration Azure solutions for high availability, elastic load distribution and high throughput for SAP, Teradata, Oracle and SQL Server, Mysql and PostgresSql transactional sources in Data Streaming and batch modes.
• Experience in defining logical and physical data models; and RDBMS and NoSQL databases ( MongoDB, MS Azure Cosmos).
• Experience in solution building platforms IaaS, PaaS, SaaS
• Developed processes in ETL SSIS/PowerShell to support “continuous” integration on Windows Application Servers
• Extensive SSAS Development (MDX Scripting)/ Auto Partition Strategies. SSAS .Net Assembly development. Dimension development and design. Auto Security Administration.
• Development of real time operations SSRS reports and Power BI dashboards using metrics that measure high availability and throughput .
• Provide best practices in the planning and creation of Azure HDInsight Clusters including cluster types -Hadoop, HBase Kafka ML Services and Spark
• Used Azure Machine Learning (AML) pipelines to build dynamic and reusable workflows with alerts and learning automation capabilities against data received from retail stores all over the country.
• Designed Data Integration pipelines for Data Stores Azure Data Lake Storage GEN2 data lake solution/Azure Blob Storage
• Azure Data Factory - Created and Scheduled pipelines that ingest data from disparate data stores in addition transform the data by using services such as Azure Data Analytics /Azure HDInsight Hadoop and Azure Machine Learning
• Implemented and used Data Lake Analytics for defining data governance /controlling user permissions in Azure Data Lake
• Created HDInsight Clusters (Hadoop/Hive) to process batch and streaming data 24/7 from legacy systems
• Designed and deployed Azure Service Bus to connect ON Premise services with public cloud services utilizing custom API’s
• Design and develop robust programs leveraging existing libraries written .NET and R.
• Designed Data Integration pipelines for Data Stores Azure Data Lake Storage GEN2 data lake solution/Azure Blob Storage
• Designed and deployed Data Pipelines and Azure Zones

Confidential

TECHNICAL SOLUTIONS DATA ARCHITECT

Responsibilities:

• SQL Server MDM and Data Quality development
• Provide ETL SSIS design, development and unit testing estimations based on business
• Lead the architecture and design of the SOA data warehouse, data marts and BI dashboard reports which will support various data initiatives.
• Created a custom Integration infrastructure and Replication Service with SSIS 2016 and BizTalk 2016 to integrate with Microsoft CRM
• Developed Power BI and Tableau (SharePoint Web Part) In SharePoint 2013/2016
• Developed advance complexed scalable ETL SSIS solutions utilizing Microsoft Azure Service Bus, Web Services (Rest and Web API), and Microsoft Stream Insight Server Platform
• Developed Entity/API web services
• Developed and written back end processes using Google Geocoding API's for property identification (e.g. convert verified addressed longitude and latitude coordinates)
• Designed data streaming and repository encryption security framework
• Creating U-SQL projects in Visual Studio against Microsoft Azure Data Lake to populate data warehouse
• Understood and translated business needs into data models supporting long-term solutions.
• Worked with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimized and updated logical and physical data models to support new and existing projects.
• Maintained conceptual, logical and physical data models along with corresponding metadata.
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommended opportunities for reuse of data models in new environments.
• Performed reverse engineering of physical data models from databases and SQL scripts.
• Evaluated data models and physical databases for variances and discrepancies.
• Validated business data objects for accuracy and completeness.
• Analyzed data-related system integration challenges and propose appropriate solutions.
• Developed data models according to company standards.
• Developed Bi-directional (upload and download) services to Azure Blob Storages
• Built and design operational data stores sourced by Azure Data lakes, PostgreSQL,PeopleSoft, Sybase, Oracle, MYSQL, NOSQL, Azure SQL Server and SQL Server Via ETL and Custom CDC processes
• Built a customized notification platform in .NET for data warehouse utilizing SQL Server Broker Services and Azure Service Bus
• Design developed SSAS cube infrastructure (Tabular and Multidimensional), wrote complexed mdx scripts assisted with SSAS assembly components written In C#.
• Designed and developed SSIS with BT Scripts for Teradata import and extraction in Teradata STAGING / EDW data repositories
• Integrate Notification Services with Microsoft Dynamics CRM to broadcast status on Web and Mobile Applications (.net development CRM SDK)
• Created Custom SSRS Reporting for Microsoft Dynamics CRM
• Serve as the Project SharePoint Online/and on premise Architect
• Create SharePoint flowcharts, wire diagrams, and slides to convey technical information to technical and non-technical audiences.
• Responsible for building VMWare/Hyper V Virtual Azure development environments

Confidential

Data Architect and SQL/CRM developer / Azure Developer

Responsibilities:

• Designed and developed Azure blob storage and Azure SQL
• Assessed/Design Proof Of Concept SOA Enterprise Data Warehouse
• SQL Server MDM and Data Quality development
• Worked with System resources to implement server SQL Server 2012 Clusters in addition assisted in SQL Cluster administration.
• Design Proof of Concept Integration Bus for Offshore Web Analytical Systems.
• Developed C#/VB.net Middleware via active directory and WMI processes detecting users logging on to the network and accessing databases
• Extracting and Migrating data (SSIS and Web Services) into Microsoft Dynamics CRM 2013
• Created Custom SSRS Reporting for Microsoft Dynamics CRM
• Provide guidance in optimizing SQL SERVER 2012 OLTP External and Internal environments
• SSAS MDX\DAX development and optimization guidance.
• Provide guidance in optimizing SSIS/SSAS (tabular and multi dimension) /SSRS environments .
• Installed and configured SharePoint 2013 Farms for Business Intelligence Domain
• Conducted SharePoint performance and scalability testing, and capacity analysis/planning
• Developed and assist in designing complex page layouts for SharePoint 2013
• Developed custom reporting web parts for SharePoint 2013 in Visual Studio 2012
• Validate and prepare detailed specifications and documentation of SharePoint environments and provide knowledge transfer to other technical staff.
• Developed Power view, Excel Service and Performance point reports.
• Created BCS’s and external content lists and views using SharePoint Designer
• Created custom Workflows using SharePoint Designer and Visual Studio
• Designed a security paradigm involving Active Directory and SharePoint’s Secure Store Service

Confidential

Data Architect/Microsft CRM Developer /SharePoint Architect/MSBI SSAS Developer

Responsibilities:

• Design Information Architecture, Governance plan, Workflow designs and Taxonomy, Design POC and proposed solutions. Prepared Architecture diagram from existing environment Manage offshore team of seven developers and four onsite SharePoint professionals
• Created custom Workflows using SharePoint Designer and Visual Studio
• Write and Implement Best Practices for performance optimization for various portals
• SharePoint Webpart modification and new development in Visual Studio C# .NET
• Assisted in the implementation Enterprise Search, Information Management Policies, Various permission levels, Content Types, Manage Implementation from classic ASP applications to SharePoint, SharePoint 2010 installation and configuration in development environment and extensively worked on Portal Performance optimization.
• SSAS Architecture and Developer including MDX
• Extracting and Migrating data (SSIS and Web Services) into Microsoft Dynamics CRM 2011
• Developing .Net Applications to interface with Microsoft Dynamics CRM
• Created Custom SSRS Reporting for Microsoft Dynamics CRM
• Design and implementation of SharePoint search and FAST search.
• Created BCS’s and external content lists and views using SharePoint Designer
• Created custom Workflows using SharePoint Designer and Visual Studio
• Administrate of SharePoint farms - backups/restore, load balancing, database maintenance, proactive system health monitoring, configuration.
• Validate and prepare detailed specifications and documentation of SharePoint environments and provide knowledge transfer to other technical staff
• Conducted SharePoint performance and scalability testing, and capacity analysis/planning
• Instead of customers calling the help desk department and the transaction was entered manually into a CRM system, customers would now email the helpdesk department, my application will read and update the CRM system automatically, direct the emails to individuals in the helpdesk department and maintain a “load balance” between the helpdesk operators. The email server was MICROSOFT EXCHANGE and CDO objects were used to control the functionality of exchange and outlook in .NET application.
• Built and administrate a 2 node cluster on a Windows 2000 Server.
• BI (Business Intelligence) Tools: Crystal Report / Microsoft Office Pivot Tables

Confidential

SQL Database Administrator/SQL Server Developer

Responsibilities:

• Administrated the database and system departments.
• Wrote store procedures, triggers and created indexes.
• Designed and deployed a replication solution over LAN and WAN environments.
• Optimized SQL Servers and used various tools like Query Analyzer, SQL Server Profiler, SQL Performance Monitor, Data Transformation Services and DBCC on daily basis.
• Implemented SQL SERVER maintenance plans.
• Created/Designed a Automated Email Reporting System using Crystal Reports against a SQL RDMS.
• Oversaw network and database architecture, and software installation and customization. Provided infrastructure administration to ensure server configuration, operating systems, routers, switches and hubs are working properly with redundancy. Ensure adequate development, testing, and production environments.
• The development hardware was composed of (4) raid level servers accompanied with 3 standard servers (IDE). Operations was composed of (8) raid level servers which hosted 500 + users (including remote users). Operating system used were Windows 2000 and Windows NT4. The development platform was Visual Basic 6 (with ADO, MTS, COM+) and SQL 7 and SQL 6.5 as the RDMS (s), EXCHANGE SERVER 5.5.