Ashutosh Zode

• Worked closely with the product owners, technical delivery team and solution architects from internal organizations to ensure data driven vision
• Involved in requirement elicitation to create business requirement and functional requirement documents
• Analyzed data requirements, application and processing architectures and database schemas while designing, developing, amending, optimizing and certifying database designs
• Drafted strategic business intelligence roadmap for business requirement
• Worked on Process Improvement for Personal Investing Products with customer segmentation
• Mapped process activities to identify shortfalls and propose options to rectify operational inefficiencies
• Partnered with functional leads to build data products
• Created Generic data pipeline using Airflow to train and build models
• Led Data engineering team with competency in Alteryx, Airflow and Control-m

Projects:

Sales Effectiveness:

• Build Sales Effectiveness dashboard for Bonus calculation based Securities Transaction by sales team.
• Used Market Reference Data to build End to End Data Pipeline and was partly responsible for Data Governance.

Client Segmentation:

• Created Annual Client Segmentation strategy to identify customer and securities to sell.
• Used Securities Master data and third party data pack to identify financial instrument to sell.
• This data acts as input for ML model, which identify time and frequency to reach out client based on historical buying patterns

• Led team of 7 data engineers and data scientist responsible for client on-boarding and creating robust data pipelines using Talend and building self serving dashboards
• Developing models/insights around customer churn behavior, new customer acquisition & on-boarding process, customer profitability & growth scenarios
• Working closely with business managers and stakeholders in understanding business issues and recommending solutions using data visualization tools like Tableau, Power BI etc.
• Optimizing digital marketing efforts by measuring campaign effectiveness and ROI in key areas such as PPC, SEO, Email and Display.

• Partnered with product managers and other stakeholders to understand business requirements and created clear and concise documents with well-defined objectives and goals
• Extracted data from multiple sources and optimized ETL execution plan for quick retrieval of large datasets using AWS Glue thereby reducing data extraction turnaround time
• Developing robust data pipelines to support reporting and analysis needs using tools like python and shell scripting.
• Created highly flexible Domo and Tableau dashboard to enable self-service reporting capabilities for Leader's ad-hoc analysis thereby reduced turnaround time by 16% for RH's supply chain
• Used market basket analysis to increase average products cross-sell

• Designed automated workflow and ETL jobs using Pyspark to extract data from various business Applications
• Developed interactive graphics and visualizations of large unstructured data in browser-friendly formats
• Built dashboard and reports in Domo, Tableau and QlikView for download related metrics like Top SKU Downloads, average time to download, user demographics, Marketing channel etc.
• Designed dashboard to showcase advanced visualization using parameter for metrics like # of orders, conversion rate, average order value, revenue per order, return on investment, etc.
• Used SQL to generate test scenarios validating reports and dashboards Delivered presentations, demonstrations and managed proofs-of-concept for product managers.

• Prepare data by analyzing Data model and creating appropriate joins by examining relationships among the tables
• Connect to different data sources and load and extract data to be analyzed using MS SQL SSIS Designing and developing dashboards using various metrics in Tableau to show performance charts for metrics like numbers of visitors, daily unique visitors, percentage of returning visitors, etc.
• Analyzed web traffic Efficiently, planned and implemented objective and goal driven strategy to maximize ROI of marketing campaign
• Built model to analyze key topic based sentiments of twitter and Facebook feeds of campaign using Lexical text analysis.
• Identifying consumer behavior by analyzing Survey data, providing insights for creative team.

• Roles and Responsibilities Developed high-performance parser and collector engine using C++ for Analytics tool Used PL/SQL Cursors, Procedure and function for process monitoring and data reconciliation Performance tuning of reports and migrating reports to Tableau.
• Providing report output using VB scripts in ppt format to the business users.
• Development of Reports and Dashboards end to end in Tableau that involves creation of Multiple datasources, data blending, cross database joins, hierarchies, charts, filters, trend & reference linesSkillset.