Solution Architect, Azure Data Integrations Lead Resume

SUMMARY

Extensive leadership experience in Data Warehouse development lifecycle - Architecting, Development, Testing and Implementation of OLAP and OLTP Database systems, BI Applications, ETL Frameworks and Designed High Level Logical Database, Designed and Developed Master Data Management (MDM) solutions to support various business applications in the enterprise using scrum methodology.
Leveraged best in class SDLC processes to ensure highly available, scalable and maintainable data warehouse platform.
Strong management and interpersonal skills with the goal of developing team’s intellectual capital.

TECHNICAL SKILLS

MS Azure, Azure Data Lake Gen 2, Polybase, Databricks, Azure Synapse Studio, Azure Data Factory, Logic Apps, IBM Bluemix, AWS S3, AWS S3 Glacier, Amazon RDS, Amazon Redshift, Amazon EFS, AWS Glue, Snowflake, Salesforce, SQL Server 2018-2000, DB2
MySQL 6.3.5, PostgreSQL 8.x, Oracle11g/9i, ODI,T-SQL, PL/SQL, MDS, Integration Services (SSIS), DataStage, Talend 7.2, Data Prep, PowerShell, Informatica, Power BI, Power Pivot, Power SQL, Tableau, SAP Data Services, Hadoop HiveQL, Analysis Services(SSAS)
Reporting Services (SSRS), Tableau, Cognos Analytics, MicroStrategy, Pervasive, MS Project, TFS, MS VSS 6.0/2005, Share point 2013, MS Access, MS-Excel, Altova XML Spy, Mapforce, Visio, Erwin, Sybase Power Designer 15.3
Embarcadero ERStudio Data Architect 10.0, Enterprise Architecture, Toad Data Modeler 3.3, Microsoft Dynamics AX, Windows, Linux, RTC, JIRA, Confluence, GitHub, Bitbucket, Kanban.

PROFESSIONAL EXPERIENCE

Solution Architect, Azure Data Integrations Lead

Confidential

Responsibilities:

Gathered business requirements to design Azure Data Migration Flow Architecture and ETL Framework Models followed with Dev and Prod development in Azure Cloud.
Developed ETL jobs in SSIS, ADF and ALA to load source files from sFTP servers to ADLS.
Created stored procedures to load staging data into Azure SQL Database tables.
Migrated On-Premise data to Azure SQL Databases using Database Migration Services.
Configured Polybase in Azure Synapse Studio to create Polybase tables on ADLS Files.
Designed and Developed Reports and Dashboards for Business Analytics and Performance Matrix in Power BI, Excel and Tableau.

Data Warehouse Architect, Data Integrations Lead (W2)

Confidential

Responsibilities:

Gathered business requirements to design Azure Modern Data Warehouse Architecture and ETL Framework Models followed with POC and MVP.
Designed MDM solution Implementation Plan and implemented using Reltio MDM Cloud.
Developed ETL jobs in SSIS to load staging data from External Sources and created stored procedures to load Azure Data Warehouse tables.
Migrated On-Premise data to Azure Synapse Studio using Database Migration Services.
Configured Polybase in Azure Synapse Studio to create Polybase tables on ADLS Files.
Designed and Developed Reports and Dashboards for Business Analytics and Performance Matrix in Power BI.

Confidential

Solution Architect, Data Integrations Lead

Responsibilities:

Designed and Developed Prototypes and MVPs using Erwin for new projects to manage Reseller’s incentives in Bluemix Public cloud.
Build and mentor team to incorporate new tools and technologies for various business initiatives - For instance IBM InfoSphere MDM.
Designed and Developed Read and Write API’s by converting stored procedures to JPA code using JAVA Springboot platform
Deployed Docker images in Kubernetes using toolchain and Jenkins with GitHub on Bluemix Public Cloud in Dev, Test and Prod environments.
Configured API’s URL with Blue API ClientID and Secret to provide extra layer of Cloud security.
Developed API’s Test cases in Postman, Swagger and ReadyAPI Test Automation.
Developed Reports and Dashboards using Cognos Analytics to help Sales team to utilize the metrics for Resellers and Distributors.