SUMMARY

• Experience with Azure transformation projects and Azure architecture decision - making.
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.
• Architect and implement ETL and data movement solutions using Azure Data Factory (ADF), SSIS
• Develop Power BI reports & effective dashboards after gathering and translating end-user requirements.
• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database, and SQL Data warehouse environment.
• Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure.
• Datacenter Migration, Azure Data Services have a strong virtualization experience.
• Experience in troubleshooting and resolving architecture problems including database and storage, network, security and applications.
• Experience managing Big Data platform deployed in Azure Cloud.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.
• Experience in Monitoring and Tuning SQL Server Performance.
• Experience in configuration of report server and report manager for job scheduling, giving permissions to a different level of users in SQL Server Reporting Services (SSRS).
• Expert in creating, debugging, configuring, and deploying ETL packages designed MS SQL Server Integration Services (SSIS).
• Configure SQL Azure firewall for a security mechanism.
• Work in wearing multiple hats: Azure Architect/System Engineering, network operations and data engineering.
• Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools).
• Collaborate with application architects on infrastructure as a service (IaaS) applications to Platform as a Service (PaaS).
• Deploy Azure Resource Manager JSON Templates from PowerShell.
• Experience in Performance Tuning and Optimization (PTO), Microsoft Hyper-V virtual infrastructure.
• Ensure compliance with server-specific architectural standards and implementation practices.
• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.
• Implement ad-hoc analysis solutions using Azure Data Lake Analytics/Store, HDInsight.
• Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure.
• Advice on cost efficiency for future usage and cost optimization for current infrastructure.
• Establish, design, and support an enterprise Cloud SQL architecture that provides the required capacity, control and supports the long-term strategic goals for an enterprise database solution.

TECHNICAL SKILLS

Tools: SSMS, Power BI, MS Office (Excel, SharePoint, Visio), Adobe Analytics, Azure Data Factories, Azure Data Lake, Azure SQL Databases, Azure Management tools

Version Control: GIT

Programming Languages: .NET, C#, JSON, U-SQL

Version Control: SVN, CVS, TFS, GIT, Bit Bucket

Platforms: Windows, Linux

Databases: SQL Server, MySQL, Oracle

PROFESSIONAL EXPERIENCE

Confidential, Las Vegas, NV

Azure Data Engineer

Responsibilities:

• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.
• Migrate data from traditional database systems to Azure databases.
• Design and implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools.
• Experience in DWH/BI project implementation using Azure Data Factory.
• Interacts with Business Analysts, Users, and SMEs on elaborating requirements.
• Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure.
• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.
• Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure.
• Setup and maintain the Azure SQL Database, Azure Analysis Service, Azure SQL Data warehouse, Azure Data Factory, Azure SQL Data warehouse.
• Develop conceptual solutions & create proofs-of-concept to demonstrate viability of solutions.
• Implement Copy activity, Custom Azure Data Factory Pipeline Activities.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
• Create C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads.
• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL Datawarehouse environment. experience in DWH/BI project implementation using Azure DF and databricks.
• Architect, design and validate Azure infrastructure-as-a-Service (IaaS) environment
• Develop dashboards and visualizations to help business users analyze data as well as providing data insight to upper management with a focus on Microsoft products like SQL Server Reporting Services (SSRS) and Power BI.
• Responsible for creating Requirements Documentation for various projects.
• Strong analytical skills, proven ability to work well in a multi-disciplined team environment and adapt at learning new tools and processes with ease.

Environment: Azure SQL, Azure Storage Explorer, Azure Storage, Azure Blob Storage, Azure Backup, Azure Files, Azure Data Lake Storage, SQL Server Management Studio 2016, Visual Studio 2015, VSTS, Azure Blob, Power BI, PowerShell, C# .Net, SSIS, DataGrid, ETL Extract Transformation and Load, Business Intelligence (BI).

Confidential, Southfield, MI

Azure Data Engineer

Responsibilities:

• Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools).
• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure, etc.
• Implement ad-hoc analysis solutions using Azure Data Lake Analytics/Store, HDInsight.
• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure, etc.
• Collaborate with application architects on infrastructure as a service (IaaS) applications to Platform as a Service (PaaS).
• Build Complex distributed systems involving huge amounts of data handling, collecting metrics building data pipeline, and Analytics.
• Architect and implement ETL and data movement solutions using Azure Data Factory, SSIS create and run SSIS Package ADF V2 Azure-SSIS IR.
• Migrate data from traditional database systems to Azure databases.
• Deploying Azure Resource Manager JSON Templates from PowerShell worked on Azure suite: Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure SQL Data Warehouse, Azure Analysis Service.
• Engage with business users to gather requirements, design visualizations, and provide training to use self-service BI tools.
• Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure.
• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.
• Identify potential problems and recommend alternative technical solutions.
• Participating in Technical Architecture Documents, Project Design, and Implementation discussions.
• Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure.
• Migration of on-premise data (Oracle/ SQL Server/ DB2/ MongoDB) to Azure Data Lake Store (ADLS) using Azure Data Factory (ADF V1/V2).

Environment: SQL Server Management Studio 2014, Visual Studio 2015, VSTS, Azure SQL, Azure Storage Explorer, Azure Blob, Power BI, PowerShell, C# .Net, SSIS, DataGrid, ETL Extract Transformation and Load, Business Intelligence (BI), Azure Storage, Azure Data Factory, Azure SQL Analytics, Azure Blob Storage, Azure Backup, Azure Files, Azure Data Lake Storage, Azure App Services, Azure Web Apps, Azure Logic Apps, Azure Virtual Machine (VM), Windows Server, Unix, LINUX.

Confidential, St. Petersburg, FL

Windows Administrator

Responsibilities:

• Respond to local area network (LAN) and wide area network (WAN) user requests for system upgrades and changes.
• Perform software installations and upgrades to operating systems and layered software packages.
• Monitor communications performance using visual, diagnostic equipment, status indicator checking methods, etc., to locate problems
• Manage the lifecycle for technical support documentation including Standard Operating Procedures and work instructions.
• Schedule installations and upgrades and maintain them in accordance with established IT policies and procedures.
• Use network management tools such as the Cisco Identity Services Engine (ISE) and Cisco Prime to identify, troubleshoot, and resolve wired and wireless networking issues on LAN equipment and/or PCs and other end-user devices.
• Track and report issues in our ticketing system.
• Participate in statewide projects to plan and implement system operation, optimization, enhancements, and upgrades.
• Set up, configure, and troubleshoot AV collaboration systems and software used by staff.
• Ensure data/media recoverability by implementing a schedule of system backups and database archive operations. Implement and promote standard operating procedures.
• Administer data backup systems at remote offices to ensure data availability, security, and recoverability. Quickly restore data accidentally deleted by customers.

Environment: SQL Server, Windows Server, Windows 2008 R2, /2000 Server(64bit), Windows 2000 Advanced Server, Windows XP, Unix, LINUX, Shell Script

Confidential

Windows Administrator

Responsibilities:

• Knowledge of managing security and metrics of the data presented using the Admin portal.
• Strong knowledge of Active Directory (building & maintaining group policies, administrative templates, sites, and services, etc.).
• Experience troubleshooting handheld devices, including Android and iPhone.
• Experience administering Microsoft SQL Server.
• Responsible for installing or upgrading Windows-based systems and servers, managing user access to the servers through RBAC identity systems, and maintaining the security and stability of the windows servers.
• Perform routine system maintenance and resolve server-side issues as they arise.
• Perform OS and application upgrades and server migrations to the cloud repository.
• Working both independently with little supervision as well as in a team environment.
• Assisting external customers with the development and troubleshooting of IT and software systems Hands-on administration and operation of scalable IT infrastructures.
• Monitor system performance to prevent slowdowns and crashes. Examine daily traffic logs and reports or receive direct reports from end-users.
• Experience with configuration and deployment of common Linux web and application servers (RabbitMQ, postfix, apache, nginx, MySQL).
• Maintain and Support Windows servers and applications.
• Must have experience with IIS.
• Incident Management: Logging tickets, Triaging tickets, and identifying the issue. If it is a bug in the system, then log a defect for development and if it is an issue with the business process then call the business stakeholder and explain the issue.
• Daily Checks: Check daily logs so see if there are any errors.
• Performance Monitoring: Monitor systems for performance (monitoring, recording, and alerting Memory/CPU usage patterns).

Environment: SQL Server 2012,2008, SQL 2005,2000, Windows Server 2012, Windows 2008 R2, /2000 Server(64bit), Windows 2000 Advanced Server, Windows XP, Unix, LINUX, Shell Script

Confidential

Systems Administrator

Responsibilities:

• Configure, administer and troubleshoot physical and virtual (VMware) servers running Windows Server R2 and higher operating systems. These servers host Microsoft File Services, Print Services and other applications and services.
• Install and configure PC hardware, software, accessories, and printers.
• Respond to and resolve IT customer service requests (walk-ups, phone calls and emails). Follow-up with customers to ensure service delivery results are satisfactory.
• Diagnose and resolve/repair PC hardware, software, peripheral, and printer issues. Work with hardware and software vendors to resolve more complex issues.
• Recommend hardware and software solutions that address emerging business needs.
• Monitor and tune the system to achieve optimum performance levels.
• Ensure workstation/server data integrity by evaluating, implementing, and managing appropriate software and hardware solutions.
• Conduct hardware and software audits of workstations and servers to ensure compliance with established standards, policies, and configuration guidelines.
• Configure, implement, and maintain voice, data and network communications systems.
• Utilize electronic and telephone equipment.
• Provide maintenance support for various systems such as electronic mail, message centers, or other computer-automated communications systems.
• Interface with vendors on new technology and system updates.

Environment: : SQL Server 2012,2008, SQL 2005,2000, Windows Server 2012, Windows 2008 R2, Windows 2000 Advanced Server, Windows XP, Unix, LINUX, Shell Script