SEARCH

Lead Solution Architect Resume Example

Love this resume?Build Your Own Now
LEAD SOLUTION ARCHITECT
Professional Summary

Lead Solution architect, Senior BI/Data engineer and Engineering Manager with 9+ years of experience and a proven knowledge of Azure Architectural design, Analysis, Development, Testing and Implementation.

Well recognized for strong leadership and project management capabilities while leading cross-function teams in an agile fast paced environment. Strong acumen in data architecture, etl and creating scalable cloud solutions with proven expertise.

Skills
  • Programming: Python, Golang, Familiarity in C# & Java, VBA
  • Web: HTML, CSS, Bootstrap, JavaScript
  • Visualization: Tableau, Power BI
  • Repos: TFS, GIT, Azure DevOps
  • OS: Linux, Windows IIS
  • Databases: MS SQL Server, Azure SQL Database
  • Cloud: Microsoft Azure, AWS, LogicApps
  • ETL: SSIS, ADF
  • Analysis Services: SSAS Tabular
  • Scripting skills
  • Cloud services
  • Business analysis
  • Team management and Supervision
  • Project organization
  • Business operations and Process Improvement
  • Firewalls
  • Technical Analysis
  • Team management
Work History
10/2018 to Current
Lead Solution ArchitectCompany Name – City, State
  • 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 backend engineer for this initiative. This assignment also 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 LeadCompany Name – City, State

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 the Data 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 DeveloperCompany Name – City, State
  • 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 AnalystCompany Name – City, State
  • 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 - City, State
12/2009
MBA: Finance
Fairleigh Dickinson University - City, State
Certifications

Microsoft Technology Associate - Python

Microsoft Azure Specialist : AZ 900

Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

76Average
Resume Strength
  • Word choice
  • Length
  • Measurable results
  • Strong summary
  • Typos

Resume Overview

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

Similar Resumes

View All
Lead-Solution-Architect-resume-sample

Lead Solution Architect

Tehachapi, California