Megha Kaul
San Francisco,California
Summary
Data professional with experience in data engineering and history of supporting robust data systems. Known for effective collaboration and adaptability in dynamic environments.
Overview
5
5
years of professional experience
Work History
Business Analyst
Microsoft
04.2017 - 04.2019
- Company Overview: Dublin, Ireland
- Developed automated ETL workflows in SQL and Python to process financial data across regions.
- Designed data marts to support business forecasting and operational analytics.
- Streamlined resource optimization models using predictive analytics, enabling a 20% cost reduction.
Business Analyst
EY
02.2015 - 07.2015
- Company Overview: Bangalore, India
- Data gathering, preprocessing, and transformation using MySQL
- To carry out Descriptive and Inferential statistics using SQL, and Microsoft Excel for Tax Team
- Extensive use of Advanced Microsoft Excel functions, Pivot tables, and lookups to understand trends and seasonality
- To optimize resources and track the workflow
- To develop predictive models using machine learning algorithms in R for customer profiling and segmentation, profitability analysis, and new product development
- To conduct sentiment analysis over customer surveys to assist tax and assurance in lead generation
- Using R and Excel for cleaning, transformation, sampling, and analysis of data to derive statistically significant results
- Dashboard creation in Power BI to report daily and weekly KPIs
- Bangalore, India
Finance Analyst
Northern Trust Pvt. Ltd.
01.2014 - 01.2015
- Company Overview: Bangalore, India
- Designed dashboards in Tableau to monitor suspicious activities on the client account
- Championed inventory and transportation optimization initiatives using simulation modelling by partnering with replenishment analysts, translating into 4% savings for $1.2 million annual business to S
- America
- Analyzing data to help advise corporate clients on actual transactions and reconcile by comparing and correcting data
- Responsible for ensuring efficient identification and monitoring of suspicious activities and transactions in the bank
- To ensure timely reporting of suspicious transactions to the (AML) compliance officer and Financial Intelligence Centre
- Maintaining information database by entering, verifying, and backing up data and handling 75 large accounts for suspicious activities daily
- Identify multiple significant cases, red flags and patterns associated with the laundering of illicit funds using macros
- Responsible for identifying and researching the patterns, trends and anomalies in complex transactional and client data to detect, prevent, mitigate and report suspicious activity related to money laundering, terrorist financing and structuring
- Protects operations by keeping financial information confidential
- Bangalore, India
Education
Master of Science - Data Science
University of San Francisco
06.2023
Master of Science - Global Financial Information System
Waterford Institute of Technology
08.2016
Master of Business Administration - Bangalore University
Alliance University
Bangalore, Karnataka06.2013
Bachelor of Engineering - Electronics and Communication Engineering
Visvesvaraya Technological University
Bangalore, Karnataka07.2011
Skills
- SQL expertise
- Data security
- Data pipeline design
- Python programming
- Git version control
- ETL development
- Tableau software
- AWS services
- Real-time analytics
- Data modeling
- Database design
- Data Mining
- Descriptive/Predictive Analytics
- ETL
- Statistical Analysis
- Advanced Excel
- Microsoft Access
- Business intelligence
- Python
- C
- QlikView
Projects
- Creating a CI/CD automated pipeline with AWS Elastic Container Registry (ECR) and Elastic Container Service (ECS) involves integrating various AWS services like CodePipeline, CodeBuild, and CodeDeploy. 08/01/24-10/31/24
- Track Me- Virtual Healthcare System, Created a system design for a Virtual healthcare system. 08/01/23-10/31/23
- ABC Database Design, Designed the database model to enable the capture, classification, and clustering of customers for targeted marketing of specific financial products/services. 09/01/15-12/31/15
Timeline
Business Analyst
Microsoft
04.2017 - 04.2019
Business Analyst
EY
02.2015 - 07.2015
Finance Analyst
Northern Trust Pvt. Ltd.
01.2014 - 01.2015
Master of Science - Global Financial Information System
Waterford Institute of Technology
Master of Business Administration - Bangalore University
Alliance University
Bachelor of Engineering - Electronics and Communication Engineering
Visvesvaraya Technological University
Master of Science - Data Science
University of San Francisco
Similar Profiles
Shubham SinghShubham Singh
Software Developer II (Level 62) at MicrosoftSoftware Developer II (Level 62) at Microsoft
DIVJOT SINGHDIVJOT SINGH
Software Engineer II at MicrosoftSoftware Engineer II at Microsoft
Premlata KumariPremlata Kumari
Technical Program Manager at MicrosoftTechnical Program Manager at Microsoft
REAGAN M. HARKINREAGAN M. HARKIN
Customer Experience Program Mgr., Dragon Copilot at MicrosoftCustomer Experience Program Mgr., Dragon Copilot at Microsoft
Chiquita TownsendChiquita Townsend
Software Engineer at Meyers and Hart CoSoftware Engineer at Meyers and Hart Co