Badges
Certifications
ashwinmprakash has not earned any certificates yet.
Work Experience
Manager Data Engineering (Data Architect)
Camsdata•  February 2024 - April 2024•  Client: Cargill
Built a dimensional data model for a Snowflake data warehouse involves structuring data into dimensions and facts tables, taking advantage of Snowflake's architecture which supports both normalized and denormalized data models for Product, Inventory and Invoicing business processes. In Azure Data Factory created and managed data pipelines, enabling to build scalable data integration solutions across cloud and on-premises data sources. Monitored and enforce data governance processes to maintain compliance with regulatory and industry standards.
Solutions Architect
Zensar Technologies Ltd•  December 2022 - March 2023•  Client: Cisco, Assurant
Architected data pipelines using AWS services such as AWS Glue, Amazon Redshift, and AWS Lambda. Managing data lakes and data warehouses, ensuring efficient data storage, retrieval, and processing. Implementing security best practices for data protection, including encryption, IAM policies, and compliance and other regulations. Collaborating with data scientists and analysts to understand their data requirements and providing solutions that enhance data accessibility and usability.
Data Engineering Manager (Data Architect), Retail
Tredence Analytics Pvt Ltd•  March 2022 - October 2022•  Client: Unilever, Pepsi, NCL
Architecting data pipelines to ingest, transform large volumes of structured and semi-structured data. Optimizing Snowflake’s compute resources for performance and cost-efficiency, leveraging auto-scaling and query optimization techniques. Implementing data security measures, including role-based access control, end-to-end encryption, and data masking to ensure compliance with regulatory standards.
Data Architect, Supply Chain Management
IT Solutions India Pvt LTD•  April 2020 - June 2021•  Client: Intel
Understanding the source systems, target systems requirements, for creation of mapping document which included source to target mapping, transformation logic, business rules, key indicators, and descriptions. Worked on identifying dimensions, facts, and various other concepts of dimensional modeling.
Technical Lead, BFSI
PKSI•  May 2018 - October 2019•  Client: Earlham Bank
In data modeling, Designed and managed data models, including logical, physical, and conceptual schemas. This often involves creating entity-relationship diagrams and ensuring data structures support business needs.
Lead Consultant, BFSI
ITC Infotech Pvt LTD•  June 2016 - November 2017•  Client: NCB Bank, Saudi
Designed Operational Data Store designed to support operational reporting and data management tasks by providing a centralized repository for current, operational data.
Assistant Manager, BSFI
Altisource Business Portfolio Solutions•  January 2012 - May 2016•  Client: Ocwen, HSBC
Designed and implemented Snowflake schema dimensional data models to enhance data analysis and reporting capabilities. Developed and maintained scalable data warehouses and data marts using Snowflake, ensuring optimal performance and data integrity.
Senior Coordinator, Basel II Credit Risk Management
Capital One•  April 2011 - October 2011•  Client: Capital One
Performed data analysis on FICO score of credit bureaus Equifax, Experian, and Trans Union. Performed credit risk analysis and identified potential new customers.
Data analyst, Software Engineer
Apex Decisions•  December 2007 - January 2011•  Client: Guess, Mandee
Built Forecasting engine using Price Elasticity by demand for clients to achieve their objectives of increasing Sales, Sale Thru, Revenue, Gross Margin, and Inventory productivity.
Education
Visvesvaraya Technological University
Computer Science, Bachelor of Engineering in Computer Science•  June 2003 - July 2007•  Percentage: 62