Business/Data Analyst
Banking and Finance
مجموع سنوات الخبرة :5 years, 2 أشهر
LOCATION: Gurugram, India DESCRIPTION:
• To prevent criminal elements from using the Banking system for money laundering activities.
• To enable the Bank to know/understand the customers and their financial dealings better, which in turn would help the Bank to manage risks prudently.
• To put in place appropriate controls for detection and reporting of suspicious activities in accordance with applicable laws/laid down procedures.
• To comply with applicable laws and regulatory guidelines.
• To take necessary steps to ensure that the concerned staf is adequately trained in AML procedures.
• Performing customer due diligence, advanced due diligence, and risk classification processes,
• Making risk classifications of customers,
• To show maximum performance for the company to act in accordance with laws and regulations,
• Making identify verification for customers who perform transactions outside the specified rules and scenarios
• Financial Services, AML, Data Analysis, Business Intelligence Environment: Power BI/Tableau, Excel, SQL
INDUSTRY: Finance Client: Cetera Financial Group DURATION: Oct 2020 - Oct 2022 ROLE: Business Analyst LOCATION: Gurugram, India DESCRIPTION:
• Works with management to define opportunities and support business decisions by providing primary and secondary research support on Internal and Market Survey Data
• Conduct competitive analysis for the engagement of the financial advisors and other staf verticals to assist in new program developments
• Provide insights on the markets by tracking developments and metrics
• Presents data and findings for management decision making, may make recommendations based on findings
• Works directly with cross-functional teams, external clients and media agencies to create research presentations and summaries
• Integrate Salesforce extracts with industry databases to provide product and customer analyses
• Visualization - Designs data visualization, data transformation modules, bring data to life visually.
• Marketing Survey Data, Attrition or retention analysis, Customer Segmentation, Process improvement for the Complete Transition of an Advisor (Committed-Pre-Boarding- On Boarding - Integration - Pending Close Close Won) to make the overall process more robust and cost efective. Key Projects Worked On
• Customer Profile Analysis (Client Appreciation)
• Crossover Analysis (Client Appreciation)
• Attrition Analysis
• Velocity Analysis (to see the journey of an advisors/non-advisors from transition to onboarding to close won status)
• .com_Branch_Manager_List (Automation to convert the texts/words from ppt to excel list and then converted it into JSON file which is then used for the cetera.com website)
• Text Analytics (to see the customer behaviour in diferent surveys) Statistical Project: Provided statistical approach to help clients with the root cause and insights on their specialized fields. Performed advance statistical technique as the guidance to their decision making.
• Customer Segmentation (Used K-Means Technique to identify diferent segments of advisors) Business Impact
• Data turnaround time is reduced, Deep understanding of the survey which is helping in the improvement of Survey Response, Customer Segmentation, Text Analytics, and to help them understand the Attrition Rate (past ~3 yrs.)
• Helping them to launch new Survey's and more frequent Ad Hoc exploratory/deep Analysis to understand the present situation
• Improvement in data quality and the positive survey results Environment: Power BI/Tableau, Python, Salesforce, Qualtrics, Snowflake
INDUSTRY: Product Based DURATION: Apr 2020 - Oct 2020 ROLE: Data Analyst LOCATION: Gurugram, India DESCRIPTION:
• The role focused on overall company performance at the international level (APAC).
• Identification of gaps in the data to perform further analysis in the improvement of the company's revenue (Used SAS and Excel to serve this purpose)
• Responsible to prepare a data model using Power BI and excel based dashboards which includes
o Getting data from diferent data sources (SQL Server, Excel, Azure SAP Hana) and cleaning of the data
o Live Dashboard creation and maintenance which can be used by the Sales, Marketing, and finance teams to see the trends or the performance of their respective regions by publishing it to the Power Bi online with Row level security.
• Working mostly on Amazon, Flipkart, Alibaba, and internal data.
• Integrated an API (used Python to web scraped the excel file from the Amazon and Keepa.com to get few data which I used in the performance analysis of the products) & data sources into structured datasets to generate automated performance tracking dashboards, liaising closely with other key stakeholders and business partners throughout the region
• Owner of monthly digital marketing & e-commerce reporting, KPI & target tracking with the main objective of automating the reporting process as much as possible and ensuring consistency with Medela Global ecommerce reporting
• Develop a regional view by markets & channels to measure performance and optimize investment across digital marketing & e-commerce activity
• Analyse overall market & channel data to track marketing & business performance, translate data to insights, and flag issues/optimization opportunities
• Generate consumer insights and view of demographics, behaviour, patterns & correlations that will enable marketing teams to optimize marketing investment & performance
• Performance analysis across several domains, including Portfolio, Operations, Financial, E-tailer Standards, Campaigns, Market-Share, with deep-dive studies on performance issues/opportunities.
• Deliver valuable insights and improvement recommendations to country leaders, marketing teams & business partners across the region
• Assist Global Digital Analytics Manager with commentary for Global update, and implementing regional API solutions globally Environment: Power BI, Python
INDUSTRY: Product Based CLIENT: Google Inc. DURATION: Aug 2014 - Sep 2015 ROLE: SAS Reporting LOCATION: Gurgaon, India Key Profile:
• Maintained updated knowledge in SAS for working on modules like Category sale and analysis, Return interface analysis, Sale trend analysis
• Worked on enhancement of existing SAS Codes based on client requirements to evaluate data sourced for various feed from the source system
• Assessed breach based on duplicates, delta values and/or missing values and exposure of merchants using SAS to highlight discrepancies to the senior management
• Involved in design & development of SAS Code based on ad-hoc requirements. Prepared & presented reports using ODS
• Prepared & maintained updated project documentation based on operational and statutory requirements aimed at seamless implementation of project phases Environment: SAS/Base, VBA and Excel.
