Lead Solution Architect Resume Example Mindshare USA LLC

LEAD SOLUTION ARCHITECT

Professional Summary

Lead Solution Architect, Data Evangelist and Engineering Manager with 9+ years of experience and a proven knowledge of creating Cloud Solutions - Architectural design, Analysis, Development, Testing and Implementation in MarTech industry.

Built variety of AdTech, MarTech, Search,DMP Analytic Solutions which are serving multi-billion dollar industry clients well and widely benefited the organization.

Strong acumen in Data architecture, ETL and creating scalable Cloud solutions with proven expertise in AdTech/MarTech sectors.

Strong Knowledge of AdServers (DCM, DFA, Sizmek etc), Media Planning systems like MediaOcean and various industry standard media systems.

Defined Azure architecture for a cloud based enterprise reporting solution leveraging Azure App Services, Azure logic Apps, Redis Cache and Azure SQL Database which is rolled to entire organization.

Started the Adoption of DevOps lifecycle - by creating various CI-CD pipelines which made the code release seamless.

Created various SQL Store procedures, ADF pipelines and Logic Apps to handle data quality checks and transformations.

Experience in creating REST API's in Golang, Python which are consumed by various other supporting solutions.

Expertise in ETL Developer using SQL Server Integration Services 2008 and 2012 and Azure Data Factory

Hands on experience on T-SQL, SSIS, SSAS, SSRS, DAX, Power Pivot and Power View reports

Created SSAS Tabular perspectives and Calculated Measures which are consumed by various stake holders.

Created self-support mini solutions like QnA maker which is using Azure Cognitive Services

Hands on experience in creating user stories and reports like JIRA, Azure DevOps.

Excellent coding and problem - solving skills with ability to work as Developer as well

Experience in using Agile, SCRUM and Waterfall methodology to deliver the projects.

Well recognized for strong leadership and project management capabilities while leading cross-function teams in an agile fast paced environment.

Skills

Programming: Python, Golang, VBA and Knowledge in C# & Java
Web: HTML, CSS, Bootstrap, JavaScript
Visualization: Tableau, Power BI, Looker
Code Repositories: Azure DevOps, TFS, GIT
OS: Linux, Windows IIS
Databases: MS SQL Server, Azure SQL Database, BigQuery
Cloud: Microsoft Azure, AWS EC2, GCP
ETL: SSIS, ADF
Analysis Services: SSAS Tabular

Scripting skills
Cloud services
Team management and Supervision
Project organization
Business analysis, operations and Process Improvement
Firewalls
Technical Analysis
Team management
Software Documentation

Work History

10/2018 to Current

Lead Solution ArchitectMindshare USA LLC – New York, NY

Monitored and tested application performance to identify potential bottlenecks, develop solutions, and collaborate with developers on solution implementation.
As a lead architect in Technology team, responsible for creating enterprise solutions which service Mindshare Analytics, Investment and other stakeholders.
Introduced the DevOps best practices and culture including CI-CD pipelines, code reviews and standards.
MS-Baseline: Besides acting as lead solution architect responsible for design, development for this cloud-based enterprise Reporting Solution - I've also worked as SQL backend engineer for this initiative. This assignment deals with transformation of current On-premise enterprise legacy reporting solutions to cloud (Azure) including the infrastructure, selection of PAAS offerings and other integrations with SAAS with modern implementations like Redis Cache. Introduced some new tech-stack like cache-based services like Azure Redis
MS-Synapse: As a Technology lead, I'm responsible for design, development and implementation of this project from ground up. This initiative is a Web based project responsible for handling various simulations of the media plans uploaded by the stakeholders. Responsible for entire Azure PAAS development, deployment and maintenance.· This is a Web focusedPython-Django implementation, with a MS-Solver component hosted/written in C#. · Played a stragic role in Pen-Testing.
MS-Astra: Mindshare' proprietary survey analysis tool, completely developed in-house from ground up. Besides leading the solution design, implementation and development – I've also written some backend API services in Python for this initiative.Introduced tech-stacks like Elastic search services and micro services style of architecture
DQ-BOT: Mindshare Data Quality QnA Maker service, responsible for answering various data quality questions.Have coded custom C# routines to tackle the query handling and auditing the questions posted and logging the questions back to the Azure SQL DB for compliance purposes.
DIG-Automation: This initiative involves automating trafficking sheets and processing being currently done by Investment Groups and data stragic teams. This project involves transforming the raw data extracts, doing etl operations and finally outputting them back to Trafficking Exports which are sent out to various 3rd party advertisers, ad-ops professionals. Used VBA, Python and various SQL store procedures to handle various utilities necessary for the initiative.

10/2013 to 10/2018

Technology Team LeadMindshare USA LLC – New York, NY

DRAW (Data reporting and Analytics Warehouse): This is a centralized data warehouse built in MS-SQL Server. The central repository primary goal is to provide key stakeholders various Digital Campaign performance KPI's and performance metrics

Architected the entire data warehouse solution from conception to reality.
Migrated the entire SQL 2008 data warehouses into SQL 2012 and later to Azure SQL databases
Used Kimball's methodology and design principles.
Established Data Architecture guidelines and developed various custom data quality components which audit the quality of the data entering the warehouses.
Clients served include Unilever, Facebook, GMI, KC and many other enterprise clients.
Supported continuous process and performance improvement for manufacturing issues, robustness and compliance.
Managed implementation of new technological improvements resulting in increased efficiency.
Managed minimum of 5 projects each year while maintaining adherence to budget, schedule and scope requirements.
Establishing SQL Standards and Review Process for Data Governance Team and also internal Technology Team
Establishing plan and process for resolving defect backlogs by leveraging source safe tools like Team Foundation Server
Mentored and developed a staff comprised of Senior Business Intelligence Developers, IT Summer Interns.

10/2012 to 03/2013

Senior BI DeveloperMindshare USA LLC – New York, NY

Created various SSIS modules, SQL Store procs to populate the warehouse.
Created DAX and VB scripts for calculated dimensions and Excel reporting.
Used various SSIS Transformation routines like Lookup, Merge, Union, Conversion, Derived Column, Aggregations
Developed various custom tools which support the DATA transfer and Data Processing from various flat files to central CRG system.
Created store procedures in VBA Excel to retrieve data from Database and re-routed them to higher authorities for financial analysis.

02/2010 to 02/2011

Senior Business Intelligence AnalystBartronics America Inc. – Iselin, NJ

Gathered requirements from Doctors, Healthcare professionals and Financial Analysts for designing and providing effective solution for EHR Reporting project, which involved both Doctor & Patient Orders.
Enhanced the Electronic Health Reporting (EHR) Reporting application wherein the new version integrated both the Doctors and the Patient Orders in a single report directly.
Created various Functional Specification Documents for Outsourcing Department for identifying the sourcing agencies and Contractors.
Enhanced the Stat Tax Information Reporting (STIR) application where the new version integrated both the web server and excel report directly.
Created store procedures in VBA Excel to retrieve data from Oracle database and maintained Tax Report Generator (TRG) for the company.

Education

10/2012

Master of Science: Software Engineering
Stratford University - Falls Church, VA

12/2009

MBA: Finance
Fairleigh Dickinson University - Teaneck, NJ

Certifications

Microsoft Technology Associate - Python

Microsoft Azure Specialist : AZ 900

Resume Overview

Companies Worked For:

Mindshare USA LLC
Bartronics America Inc.

School Attended

Stratford University
Fairleigh Dickinson University

Job Titles Held:

Lead Solution Architect
Technology Team Lead
Senior BI Developer
Senior Business Intelligence Analyst

Degrees

Master of Science : Software Engineering
MBA : Finance

Lead Solution Architect Resume Example

Resume Score: 80%

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes