Lead Solution Architect Resume Example
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.
|
|
- 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.
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.
- 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.
- 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.
Stratford University - City, State
Fairleigh Dickinson University - City, State
Microsoft Technology Associate - Python
Microsoft Azure Specialist : AZ 900
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:
- 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
