Summary
Overview
Work History
Education
Skills
Certification
Clearance
Timeline
Generic

Hassan Mansoor

Haymarket,VA

Summary

Technical Architect with 16 years of experience overall. Currently lead the development of data architecture to support clients across various industries including Federal, Private Banking, and Commercial. 15 years of experience working with complex federal and private projects including business process improvement and development of business and solution architecture using both Data Fabric and Mesh architecture for disparate data sources.


Extensive experience with Cloud Technologies such as AWS and Azure and implementing alongside big data utilizing Hadoop with Spark and Kafka for data streaming for past five years. In addition, using Snowflake Snowpipe, Streams tasks.


Alongside Big Data technologies been involved in advanced data analytics for AML and Fraud detection for the financial industry using Machine Learning Algorithm programming in SAS, Python and R for Govt and Banks.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Sr. Architect Data Engineering Lead

Smartronix
11.2018 - Current
  • As part of SLG solutions group I serve as a technical lead for knowledge of for cloud solution architecture for backend engineering and migration for legacy on prem ERP and CRM systems
  • Provide technical leadership for the migration and planning efforts across multiple projects for CRM, HRMS and financial applications for large scale integrations using full AWS stack; Kinesis, Glue, Lambda
  • Developed a comprehensive data migration strategy that outlines the approach, processes, and tools necessary for the successful migration of existing data assets from an on-premises to the AWS cloud, Snowflake for petabyte Datawarehouse and Snap logic for backend integrations
  • Lead in design and architecture road map and requirements of complex systems and diagram models from conceptual to physical implementation of Snowflake data warehouse
  • Lead effort on data architecture best practices for design, data quality
  • Develop a plan for the full migration of the on-premises workloads to the AWS cloud, including the reengineering of pipelines from source to cloud
  • Developed backend ETL using Snowpipe, streams and tasks for data ingestion
  • Designed and developed an S3 data lake utilizing Databricks for ingestion.
  • Led design team to achieve seamless project execution, ensuring all deadlines and milestones were met.
  • Fostered innovation within the design team by staying current on industry trends and advancements in technology.

Sr Data Architect

Deloitte
03.2017 - 11.2018
  • Helped plan and migrate multiple mission-critical applications to AWS GovCloud
  • Provided guidance on extension of existing on-premise environment to a hybrid cloud model
  • As part of the migrations, helped design an establishing a scalable architecture, optimizing orchestration tools, and integrating the existing and new environments
  • Worked within NIAID division
  • Led modeling effort for the data models, comprised of 11 data models across 11 health subject areas
  • Help manage data governance program with Task by the CIO on Big Data efforts using AWS and Hadoop
  • Developed solution level business and data architecture in support of the OCICB to secure annual IT investments for the NIH
  • Guide NIH Nvision data initiative through requirements gathering and translated requirements into data and information models
  • Supported a business process reengineering effort of transcribing 700+ models from vision format into BPMN standards using System Architect
  • Developed the integrated Information Modeling Report document, which included the scope, AS-IS gap analysis, and TO-BE solution model
  • Manage a team of four database developers and two business intelligence Developers.

Technical Lead

Serco
07.2015 - 03.2017
  • At Serco Inc for CMS within the Affordable Care Act project
  • My main role had been to provide guidance in architecture development of their current Cloud system in Microsoft Azure and also act as a Data SME for analytics for Sr
  • Management
  • With contractor support I have built the Income Verification Tracking database and Analytic repository for applicants and metric reporting on ACA geographic areas
  • Part of my day-to-day duties had been primarily to understand the various filings and metrics via SQL and BI reporting
  • Also designing the full-scale Data Warehouse and ETL for handling larger volumes of application processing and tracking which entails large tax and photo documents (i.e
  • 1040, 1099, SSA, JPEG)
  • Utilizing R and python programming as well for ACA and CMS visualization metric reporting.
  • Rapidly prototyped new data processing capabilities to confirm integration feasibility into existing systems.
  • Enhanced system performance with thorough code reviews, debugging, and optimization techniques.
  • Instituted code review practices that fostered an environment of constructive feedback exchange among team members leading to better overall code quality and maintainability.
  • Boosted team productivity by implementing automated testing frameworks that reduced manual testing efforts and increased overall code quality.

Sr. Data Architect

Onyx Government Solutions
03.2014 - 07.2015
  • Fincen is a division within Treasury that is responsible for Anti Money Laundering, fraud and terrorism related financial activities as part of the Bank Secrecy Act
  • It primarily reports on all of the Banking activity for deposits over 10K and foreign nationals for OFAC division
  • Provide architecture guideline on Data Warehouse development and maintenance
  • Design new reporting environment (Tableau) for analysis groups
  • Work on Big data design and architecture with MongoDB
  • Developed Scala API for Kafka to provide faster data streaming
  • Redesigned and remediated ETL jobs in Data Stage Ver 8.5
  • Implemented Informatica Exchange for Mongo DB applications.

Data Architect

The Carlyle Group
03.2011 - 03.2014
  • The Carlyle Group is a Private Equity firm in Washington DC
  • I was a Data Architect within their architecture group
  • I was in charge report development and design for the Equity Management Group and Compensation group at Carlyle
  • My main role was also to work with the Database Lead to work with the end users to facilitate their requirements for reports and proper data management as well
  • Created and updated legacy complex SQL logic for data warehouse development
  • Performed database design and implementation from logical to physical
  • Create Tableau Financial dashboards for corporate reporting and wealth management
  • Designed for various Data migration jobs via Informatica PowerCenter and Address validation
  • Lead on Business Objects Enterprise Architecture (Integration, JSP development, Crystal reports development)
  • Work with Clients across various Groups (Fund Management, Compensation Group, Human Resources) for Requirement gathering and interpretation into Report Development
  • Perform database administration functions such as backup, replication and disaster recovery
  • Create and Setup Business Objects Reporting Environment (Crystal Reports, Webi, Universe Design Xcelecius etc.)
  • Designed and maintained comprehensive system documentation for easy reference by internal teams, ensuring smooth knowledge transfer during staff transitions.
  • Collaborated with system architects, design analysts and others to understand business and industry requirements.

Technical Lead

Leidos
03.2013 - 06

Education

Political Science -

Quincy University
07.2003

Skills

  • Task Prioritization
  • Historic Preservation Techniques
  • Fellow of the American Society of Interior Designers (FASID)
  • Material Selection Knowledge
  • Source and Version Control: Git, Github
  • Cloud Computing
  • API design knowledge
  • Software Testing and Validation
  • Software Deployment
  • Technological integration
  • Software Architecture Design
  • Design development

Certification

  • AWS Cloud Practioner-Current
  • AWS Solutions Architect-Expiring September 2023
  • Snowflake Technical Sales Professional-Current
  • Snowflake Pro Core-Current

Clearance

Secret DoD

Timeline

Sr. Architect Data Engineering Lead

Smartronix
11.2018 - Current

Sr Data Architect

Deloitte
03.2017 - 11.2018

Technical Lead

Serco
07.2015 - 03.2017

Sr. Data Architect

Onyx Government Solutions
03.2014 - 07.2015

Technical Lead

Leidos
03.2013 - 06

Data Architect

The Carlyle Group
03.2011 - 03.2014

Political Science -

Quincy University

Similar Profiles

CREATE PROFILE
Hassan Mansoor