lead solution architect resume example with 9 years of experience

Jessica Claire
Montgomery Street, San Francisco, CA 94105 609 Johnson Ave., 49204, Tulsa, OK
Home: (555) 432-1000 - Cell: - - - -
Professional Summary

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

Strong acumen in Data architecture, ETL and creating scalable cloud solutions with proven expertise.

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 API Apps, Microservices which leverage Cache based systems like Redis for providing delivery metrics.

Created various SQL Storeprocs, 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.

Strong working knowledge in developing Restful webservices and Micro Services using Golang .

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 Azure Keyvault services to handle the service account credentials

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.

  • Programming: Python, Golang, VBA and Knowledge in C# & Java
  • Web: HTML, CSS, Bootstrap, JavaScript
  • Visualization: Tableau, Power BI
  • Code Repositories: Azure DevOps, TFS, GIT
  • OS: Linux, Windows IIS
  • Databases: MS SQL Server, Azure SQL Database
  • Cloud: Microsoft Azure, AWS EC2,
  • 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 Architect Nokia Virtual Office California, CA,
  • 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 focused Python-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 Lead Caterpillar El Reno, OK,

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 Developer American Medical Association Chicago, IL,
  • 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 Analyst Northwest Bancorp, Inc. North Webster, IN,
  • 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.
Expected in 10/2012 to to
Master of Science: Software Engineering
Stratford University - Falls Church, VA
Expected in 12/2009 to to
MBA: Finance
Fairleigh Dickinson University - Teaneck, NJ

Microsoft Technology Associate - Python

Microsoft Azure Specialist : AZ 900

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

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


  • Master of Science
  • MBA

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: