Sayali - Data Analyst |
[email protected] |
Location: , , USA |
Relocation: Yes |
Visa: H1B |
SAYALI
Best Regards.. Louis IT Sales recruiter [email protected] +1 (732) 347 6970; EXT: 211 linkedin.com/in/kalyani-mahesh-442ab0259. 7 Lincoln Highway, Suite 227B, Edison, NJ 08820 www.cognitech.tech/ SUMMARY Results-driven Data Analyst with 9+ years of experience in delivering impactful, data-driven business insights across industries including banking, healthcare, e-commerce, Expert in SQL with deep Automated experience in querying large datasets and building optimized analytics pipelines, and telecom. Partnered with engineering teams to optimize and scale data pipelines on AWS and Snowflake. Expert in translating complex datasets into strategic recommendations using advanced analytics, predictive modeling, and BI tools. Proficient with SQL, Python, Tableau, Power BI, Snowflake, and cloud platforms like GCP and AWS. Skilled in A/B testing, experimentation design, KPI development, and cross-functional collaboration. Proficient in Python, Tableau, Power BI, Snowflake, and cloud platforms including GCP and AWS, Strong collaborator with cross-functional teams, excelling in stakeholder communication, KPI development, Developed data quality checks and documentation for cross-functional team alignment and data pipeline optimization. ________________________________________ SKILLS Languages: Python (Pandas, NumPy, Matplotlib, SciPy), SQL, Java Databases: PostgreSQL, MongoDB, Snowflake, Oracle, IBM DB2 BI & Visualization: Tableau, Power BI, Looker, Alteryx, Excel (VLOOKUP, Pivot Tables) ETL & Cloud Tools: GCP (BigQuery, Looker Studio), Talend, Apache Airflow, Jenkins, AWS AI/ML: TensorFlow, Keras, Scikit-learn, Time Series Analysis, Clustering, A/B Testing Other Tools: Git, JIRA, Spring Boot, REST API, Postman ________________________________________ PROFESSIONAL EXPERIENCE Data Analyst - Verizon, New York City, NY Nov 2022 Present Developed interactive Tableau dashboards with ROAS, CLTV, and conversion metrics, helping marketing and sales teams improve targeting and reduce CAC by 18%. Collaborated with business users to gather requirements and translated them into SQL-based KPIs and executive dashboards. Created Tableau dashboards for patient lifecycle, resource utilization, and drug efficacy insights. Designed and implemented A/B testing frameworks to measure campaign effectiveness, experiment lift, and product feature adoption. Automated ETL workflows using Python and Talend for real-time dashboard updates, improving reporting efficiency by 40%. Developed predictive models in Python (Scikit-learn) to forecast re-admissions and supply bottlenecks. Supported data lineage and mapping documentation; streamlined communication across tech and business units. Conducted campaign-level performance tracking and attribution modeling across web and CRM systems. Created KPI alerts and data stories in Tableau to help stakeholders monitor customer behavior and retention in real time. Partnered with engineering teams to scale pipelines on GCP BigQuery and Snowflake; implemented robust data quality checks. Delivered insights through stakeholder presentations and executive data stories using Tableau and PowerPoint. Data Analyst - Accenture, Pune, IN Jun 2020 Dec 2021 Healthcare & Life Sciences Project (Client: Baxter) Delivered custom dashboards using Tableau to monitor drug efficacy, patient lifecycle, and resource utilization across departments. Analyzed financial risk and default probabilities using SQL and time series modeling in Python. Developed complex Oracle and DB2 SQL scripts for clinical trial data validation and analysis. Built automated financial reports and comparisons using SQL and Excel macros. Built predictive models using Python (Scikit-learn) to identify bottlenecks in supply chains and patient re-admission trends. Led technical documentation of ETL logic and created REST APIs for real-time reporting dashboards. Integrated CI/CD workflows for dashboard releases via Jenkins and Git. Supported migration from Excel-based reports to Power BI dashboards hosted on AWS Redshift. Conducted root cause analysis on failed transactions and implemented fixes using Python scripts. Presented regular performance updates to stakeholders with supporting visuals and narratives. Conducted UAT testing and QA for dashboard rollouts. Collaborated on BRDs, reconciliations, and QA testing for newly implemented reports. Acted as liaison between development team and QA analysts for bug tracking and resolution. Associate Software Engineer - Accenture, Pune, IN Nov 2018 May 2020 Finance Project (Client: PNC Bank) Analyzed and visualized loan default risk using Tableau dashboards and Python time series models. Performed financial trend analysis using SQL queries and reduced manual reporting time by 50%. Created interactive dashboards on asset health and risk profiles, improving executive reporting accuracy. Implemented A/B testing strategies to validate marketing campaigns and compliance alerts. Developed logic for automated financial statement comparisons using Excel macros and SQL procedures, Created reconciliations, BRDs, and functional test cases for new finance reports. Collaborated with the treasury team to evaluate bond portfolio risks and interest rate scenarios. Supported migration from legacy Excel reporting to BI dashboards, enabling real-time insights. Assisted auditors with data sampling, population matching, and transaction traceability. Documented BRDs and created functional test cases. Data Analyst - Xceed Technologies, Hyderabad, IN Mar 2016 Oct 2018 Built Power BI dashboards for network performance (uptime, downtime, latency) monitoring. Migrated legacy reports to Snowflake and Looker Studio, enabling centralized analytics. Developed anomaly detection models in Python to reduce fault response time by 30%. Integrated Talend ETL jobs to cleanse and transform large telecom datasets. Led the migration of reporting workflows to Looker Studio and Snowflake, enabling centralized self-service analytics. Integrated Talend ETL workflows to clean, standardize, and load large telecom datasets. Conducted root cause analysis on recurring connectivity issues and presented mitigation strategies. Developed KPI reports for internal operations and customer service improvement. Created Python scripts to automate daily health checks of telecom infrastructure. Authored SQL queries for recurring reporting needs and telecom fault trend tracking. Supported telecom engineers in analyzing performance degradation across regions. Conducted quality assurance checks on network-level raw data and reconciled gaps. Keywords: continuous integration continuous deployment quality analyst artificial intelligence machine learning business intelligence information technology New Jersey New York |