M: 818-***-**** ad1rbz@r.postjobfree.com

PROFESSIONAL SUMMARY

Innovation Leader and enterprise architect skilled in building/leading cutting-edge technologies to solve business problems. I thrive on solutioning and architecting strategic enterprise solutions across different clouds (AWS/Azure/MDM/Snowflake/Salesforce/Databricks) and various technologies. I have vast experience in managing/leading, architecting, designing and developing various projects/solutions within insurance, manufacturing, retail and financial industries. My experience and specialties include end to end solution for data Integration, data mining skills to extract data from large datasets to discern meaningful information. I am multifaceted and have demonstrated superior competencies in designing/or modifying systems architecture to accurately meet business needs. My background feature unique experience in working with clients to accelerate projects while recommending best practice architecture. My passion for career in solution architecture is back by my versatility, adaptability, and a commitment to thoroughness and excellence.

TECHNICAL SKILLS

Extensive experience in the field of Data Integration, Data Analytics, Data Warehouse, Business Intelligence, Application Development, Conceptualization, design and Implementation of projects

Extensive knowledge of Aws Cloud services like Athena, DynamoDB, EMR, EC2, S3, VPC, kinesiss,CloudWatch, Lambda, IAM etc.

Extensive knowledge and expertise in different Data stores like Snowflake, Netezza, Pura-Data, Teradata, Oracle, SQL, Redshift, Aurora, MySQL, Postgres, and Integration tools like Talend, SSIS, Pentaho, Big-Decision, Azure Data Factory, Informatica Power Center

Python (NumPy, Pandas,

Solid Knowledge architecting and building various end to end self-service and operational reporting systems with Snowflake, Power-BI, Tableau, Qlik, Data Bricks and Big Decision

Hands on experience building Data Lakes in different clouds (AWS/Azure) and extending their functionality with Delta Lake using Azure Data Bricks.

Sound Knowledge of Big Data Ecosystem like HDFS, Spark, Hive, HQL, Spark SQL

Expert level skills and specialization in technical project Lead/management, ETL Architecture, Application Development, Production Support to Decision Support system

Extensive Knowledge modelling Structured, Unstructured databases using various Tools like SQL Architect, Erwin

Hands on Experience with Python, C#.net, VB

AWARDS AND RECOGNISTION

Silver Hammer Winner 2016, the most honorable award in Harbor Freight tools to recognize the employee of the year for Data and Analytics department

DNA Team Recognition/Honor 2017 for Instituting policies and procedures responsible for reducing downtime and increasing department efficiency by providing enhanced server architecture to support 24/7 support for Jobs and Reports.

Client wins Forrester/InfoWorld Enterprise Architecture Award 2020 (check link below for details) for “Lexmark – Digital Twin/Thread” project

Winner of 2020 Titan Award in Cognizant for Implementation and Architecture for project “Lexmark – Digital Twin/Thread”

ACCOMPLISHMENTS CHRNOLOGY

PennyMac,01/21 to current FVP, App Development

Strategic Focus

I operate as a leader who is able to envision the big picture strategy and operationalize execution roadmaps while patterning across the executive team to build alignment, elevate the value of IT to the business and optimize the IT return-on-investment. Strategic successes include rolling out new enterprise service offerings leveraging new data analytics, Data science tools operating within IT budget by applying cost effective(onsite/offshore) model.

Solution-Oriented Analytical Practice

I got the opportunity to orchestrate numerous digital transformations involving multiple clouds like AWS/Azure, snowflake, MDM, Salesforce, SFMC, CDP Platform (Tealium) where I get to wear multiple hats from being technical architect, business operation SME and Hands on Program lead.

Expertise in building modern data platforms that is scalable, responsive and intelligent to deliver consistent, and continuous data pipelines (supporting hot/cold data). These pipelines are designed and integrated with data standardization, data ingestion policies along with Enterprise MDM cloud to validate Customer data Integrity. Data observability platform helps you monitor and control data's quality and continuously report data accountability and metrics to ops, business and technical partners.

Leaderships and Wins

I am leading 20+ direct reports; 2 horizontal teams (AWS, Snowflake) and 3 vertical data platform teams (MDM, Customer C360, CDP) supporting and building tech tools for marketing, retail business.

Driving Business growth by introducing digital cloud based and cost-effective solutions for better productivity and speed. It helps increase digital business 40% YoY by continuous engagement with clients and reduce tech debt by 60%

Responsible for building enterprise-wide platform called “Lead Generation” which help capture hot prospects and their interest in converting into a customer nearly real time.

Work closely with cross functional team of product managers, engineers and data scientists to identify business driven opportunities for marketing campaigns to drive social media advertising efforts using various predictive models, further resulting in 25% increase in quality of leads.

Build scalable, serverless data factory/platform allowing developers to build faster data pipeline with no to little code, further empowering decision-makers/business in decision making with correct information.

Cognizant, 01/18 to Dec 2020 Sr Manager/Hybrid Cloud Data Architect

Lexmark/ Digital Thread and Cloud Managed Services: Enterprise Data Architect leading the Digital Twin/Thread project which help Lexmark grow their business capabilities by delivering printing/imaging solutions and services with higher performance and at lower cost. It’s an Implementation of platform across multi-clouds (AWS/Azure) and technologies like (data bricks, big decision) by connecting real to nearly real time interoperable IOT devices in addition to various hybrid data stores on cloud (redshift, S3) as well as On-Premise (Oracle, SQL, MySQL).

It further empowers the manufacturing business to extend their business to their partners/customers as different services like MPS, CPM. The solution is focused on improving operations through predictive replenishment, maintenance and service with the key focus on maintaining single truth of source by having robust data lake (Azure Gen2)/delta lake (Data Bricks), which further equipped with various BI tools like snowflake, Databricks, Power BI helping business run their own analytics and operational queries. This solution helps them reduce the time to market by closing the loop between virtual models or their printers/cartridges and performance throughout their lifecycle.

Solution Provide Business Glossary, Data Catalog and End to End data lineage

Data Privacy Management by RBAC, PII Interceptor matching and built in Integration with data encryption keys in big decision

Data Discovery, Metadata Manager (Hive Based) and much more

Enterprise level Common Data Model

Data Lake Protection using POSIX ACLs, Application Roles

Service Now Requests for Data Lake and Big Decision access

CCPA/ Data Governance: Enterprise BI Lead Architect for a project called CCPA (California Consumer Privacy Act) for AAA, Orange County. CCPA is a Compliance project, which help consumer protect and give right to know their data which is being used/sold/shared by AAA. To be compliant with CCPA Law, AAA need to build a system which allow them to process on demand consumer requests for data deletion/retrieval/Opt-outs. I help them design/architect/develop dynamic approach which can be used in SQL/Teradata and will process all consumer requests on demand. The Dynamic approach is designed to accommodate any future changes in databases and will help them stay in sync with Data governance databases.

One Architecture which support all platforms on premise and cloud (AWS)

It will auto maintain any changes in databases (SQL/Teradata/Big Data/Cloud)

Centralize repository for Data Governance

Dynamic Templates to accommodate all new/changes in existing tables/views

Integration with IIB/BPM web/micro custom services

Easy/Self Manage code

Exception/Error Handling to provide better visibility to issues

Harbor Freight Tools, 10/14 to 01/18 Sr Manager Data Analytical and Technology

Harbor Freight Tools is one of the fastest growing retailers with new opening of store every 3 day and total of 860+ stores. As part of Data Analytics Team, we serve every department in the company and provide enterprise reporting and self-serve data solutions. I manage the team of senior engineers and responsible for providing/supporting/enhancing server architectures to support the continuous growth of company.

Lead architect in planning migration of terabytes of data from Netezza to Pure-Data by supporting current production and no down time strategy.

Lead architect in designing the Data-Warehouse/Data-Lake/Data-Marts to support self-serve BI platform using Tableau, Qlik and SSRS

Architect centralized custom Security Model to support dynamic access, distribution of reports and functionality using various BI platforms like SSRS, Tableau and Qlik

Responsible for enhancing/supporting server architecture to support 24/7 Real-Time and Data-Driven reporting.

Help setup/create disaster recovery process for all servers.

Develop and enhance various dashboards to provide better visibility to different trends and metrics.

Implement various processes to improve Data Quality and Data Governance.

Implement rules and regulations and automate self-archiving and purging procedures in order to increase high performance and decrease load time.

Help setup centralized logging process for all Jobs.

Partner with various teams to setup cross department trainings in order to gain business knowledge.

Help setup ‘Lunch and Learns’ inside the team to share tribal knowledge among peers.

Setup Notification processes to alert data anomalies, increase in load times and failure of processes outside our team.

Penny Mac, 08/11 to 10/14 IT Solution Manager

I get to create one of the biggest and critical reporting system in the company, called LAR. The Corporate Loan Activity Report (LAR) is the foundation for all reporting to the Non-GSE investors as well as the main source for accounting data for revenue recognition's (servicing revenues, gain or loss on sales or liquidations of loans, etc.) and loan inventory. This is also the main source for Treasury in managing the NPLs as well as for the budgeting and forecasting group for valuations. The current automation has reduced over 80 hours of manual work on a monthly basis and improved overall data quality

Working with analysts, business users and development teams to understand business requirements and preparing the detailed design plans and development strategy

Design and implement data mart for LAR Reporting. Fully automated end to end process of LAR, which includes data uploads, execution of LAR, pre and post validations.

Incorporate high level of transparency between systems and open various channels of audit both for internal and external auditors. Self-Validation, Exception routines has been created to avoid and check various levels of integrities. Versioning and archiving process has been placed to track each and every version of LAR

Self-Deployment procedure has been created to which automatically script stored procedures and functions based on staging or prod deployment. Created self-documenting, self-monitoring procedures, which will alert the users on failures, unusual activities. Expertise in writing simple to complex, efficient, resource friendly SQL procedures (Stored procedure, Views, SQL Scripts) with or without exception handling.

Managing data dictionaries, data models and Meta data for various systems, build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Collaborated with the application developers in data modeling and E-R design of the systems. Developed processes / reports based on business/Client Requirement.

Performed tuning and automation of various applications involving different platforms using ETL packages.

Interviewing Services of America, 03/06 –07/11 Project Manager/Sr. Software Programmer

Successfully Managed the end to end development of “ORT Lite” project

It is a standard Online reporting tool designed for clients who are cost-conscious and have standard requirements to track business performance online with the flexibility of custom reporting. Define scope of project, mapping business requirements to Technical requirements, Manage off shore team, Conducting Status Meetings, Develop Timelines and delivery dates for different phases of Project, Involvement in continuous design Improvement of Product.

Data Migration of Sales customer management (SCM) system to Dynamics CRM S/W

My Role is to develop SCM Data Dictionary, Successful Data Mapping of 2 systems and then Migration of SCM data into Dynamics CRM System using SSIS.

Successfully link and build the complex Automation process involving various jobs on different Platforms in different regions for Build-A-Bear using SQL server 2005, .NET/C#, SSIS, SSRS.

Database Planning, Designing, Implementation and tunings of various Quota management systems used by phone, CATI and web based surveys for well-known clients like BABW, Lowes, Wal-Mart, Staples, Dollar General,Gap, Banana-Republic, old-Navy, and many more.

Building and planning of Automation process to manage constant loads of data, self-alerting and reporting systems for internal and external resources.

Design and Implementation of ETLs from various source systems like CATI, internet/WEB, phone, XML to build real time reporting systems for Dollar General, BABW, Gap/ON/BR and many more using SSIS.

Build various type of SSRS like Linked, snapshot, parameterized and web based (using .net/c#) reports for internal/External clients as well as custom SSRS reports using visual studio.net and their implantation in web based pages for Online reporting tools. Active involvement in building, designing, implementation of reconciliation process for various jobs. Handle successful migration/linking of various databases

E-Base Technology, 06/05 –12/05 Software Programmer

Developed Web based Wish-list Module for shopping cart using ASP .Net, C#.

Designed software requirements and implemented code for employee time tracking system. Participated in software testing and code inspections.

Worked as an analyst and developer on the team responsible for creating a Database tool having user-friendly interface with two view panels for different data sources featuring copy, move, update, insert and delete operations.

Extensive involvement in Unit and Integration testing.

Auto Manager Inc., Santa Monica CA 07/03 – 06/05 Programmer Analyst

Responsible for collecting requirements, implementation, unit and integration testing for customized Reporting module to analyze contacts, vendors, prospects and partners of the Company. Application features includes bulk Email, Export, Print, user defined query, sorting, grouping and summarized reporting.

Responsible for implementation of Desk-Manager product using PC-Install Scripting language. It has User friendly interface for selecting version and option of Demo/Deskman or Both for creating executable file for setup.

Planned and managed full development process.

EDUCATION

Data Science & Machine Learning by MIT IDSS

Masters in Computer Science and Technology, Punjabi University India

Business Intelligence and Data Warehousing, UC Irvine

UNIQUE SKILLS

Teams: Organize and build top-notch teams both for in-sourcing and out. Provide the best mix of cost-optimized resources that can be mobilized quickly for deployment of major initiatives. Build accountabilities and provide hands-on guidance to inspire teams to create innovative products/solutions that lead. Mentor teams; reward them.

Projects: Manage multiple enterprise-wide projects that help keep the business on top of its game. Organize projects and provide clear dashboards for everyone to see. Avoid surprises.

Processes: Establish highly efficient development processes and infrastructure, virtually eliminating drudgery and freeing-up teams to do creative work. Create an environment to innovate.

Certificates

AWS Data Specialty

AWS Certified Developer – Associate

AWS Certified Architect – Associate

Databricks Accreditation

Snow-Pro Certified

AWS Certified Data Analytics – Specialty

Good Shares

Lexmark Digital Thread Award

https://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgo.forrester.com%2Fblogs%2Fthe-2020-forrester-and-infoworld-ea-awards-contest-winners-focus-on-business-architecture-digital-transformation-and-governance%2F&data=02%7C01%7CRamneek.Kaur%40cognizant.com%7C915acaf277994a78aeff08d86c800c07%7Cde08c40719b9427d9fe8edf254300ca7%7C0%7C0%7C637378644515783248&sdata=9Y%2BJXFkumLYbzoYLwg1Wz9Tiw5gt%2FjbnVaZEMrk0HvE%3D&reserved=0

Contact this candidate