Rama Krishnan

Client: Tractor Supply by Allivet , USA Domain: E-Commerce, Pet Pharmacy, Subscription Business Model Tools/Technology: MS SQL Server, Power BI, Advaned Excel, OLAP, 🤝 Defining Business Problems: Analyze historical data of customer opt-ins and opt-outs to identify root causes and improve customer retention in a subscription-based business model. 📝 Cross-Department Collaboration: Work closely with Customer Service, Verification, Fulfillment, and Logistics teams to oversee the entire process from order placement to product delivery, ensuring efficiency and customer satisfaction. 📈 E-commerce Data Research: Conduct business research using e-commerce data to assist the strategic team in developing promotions, coupons, and discounts tailored to customer needs. 📊 Issue Identification and Resolution: Investigate the root causes of order cancellations, delays, inventory discrepancies, and shipping issues to enhance operational efficiency and customer experience. 🗒️Predictive Modelling: Developed and operationalized machine learning models to predict veterinary prescription cancellations and customer subscription opt-outs, enhancing the ability to proactively manage and mitigate these issues.

Domain: Dispute, Chargebacks, Credit & Payment Industry Tools: Power BI, QuickSight, SQL, VS Code, DBeaver, Pentaho Technology: AWS Athena, AWS S3, AWS RDS, ML, DS, MySQL, PostgreSQL, Python 📈 Data Analysis and Reporting: Using Power BI & QuickSight, I've performed root cause analysis, created ad-hoc reports, and structured risk-based KPI reports, often using complex DAX in PowerBI and LAA & LAC in QuickSight. Delivered billing reports for Finance team to perform seamless billing activity to the clients. 📊 Report Migration: Implemented report consolidation project to enhance operational insight by centralizing all reports for improved usability. Migrated more than 25 reports from Power BI and Excel to AWS QuickSight as part of report consolidation efforts. Applied Row Level Security to each report and shared them with various managerial levels within the organization. 📚 Performance and Vulnerability Assessment: Tracked operational teams’ performance using PowerBI and advanced SQL concepts includes Aggregate, Scaler and Window Functions. Evaluated task completion time and pending tasks. 📃 Presales Collaboration: Coordinating with the sales team on presales projects and conducting ROI analysis for potential clients to provide valuable insights. Automated analysis using AWS Services such as S3, Athena and QuickSight. 📉 Advanced Analytics: Leveraging AWS QuickSight, I've developed advanced analytics and automated vulnerability email reports, empowering clients to monitor their performance and gain insights into chargeback prevention. 🗂️ Data Warehouse: Collaborated with Data Engineering team in setting up data warehouse for data quality improvement and analytical purpose. Using Python and SQL as the primary script in building data warehouse by applying DDL, DML, DQL Concepts. 📐 Technical Knowledge Transfer: Keeping pace with evolving BI tools, I've actively engaged in detailed knowledge transfer sessions with Microsoft and AWS teams on a monthly basis.

Client: Mashreq Bank, UAE Project: Credit Operations| Team: MIS Reporting | Business Process Associate Tools: Flex cube Oracle, MS Office, Power BI, Advanced Excel 📃 Consolidating production and operations report from all the teams and sending it to the supervisors/managers. 📈 Responsible to maintain prebuild power bi & excel reports and verifying dataflow frequently. 📉 Assisted on supervisor/manager’s presentations for board meeting preparing data related contents. 📝 Gathering requirement developing data model by loading the data from CSV, Excel files to the power query and created a view for the dashboard requirement. 📚 Understanding the AS-IS TO-BE process and socialize with Project & Programme Manager. 📐 Point of contact for internal and external stakeholders regarding data related queries and delivering them on time.