Sneha A Email & Phone Number

United States

Santa Monica, California, United States

Collaborated closely with business analysts and Data Warehouse architects to comprehend source data intricacies and the Warehouse requirements. Led the design and development of Data Analytics and Warehouse solutions, utilizing Tableau, Cognos, Oracle, Exadata, and Informatica. Spearheaded solution design and implementation of Business Intelligence reports and OLAP cubes, performing extensive GAP analysis to bridge 'As-Is' and 'To-Be' conditions.Utilized SAS/SQL and SAS/Base for data extraction, transformation, and analysis, deriving actionable insights. Developed QlikView applications for intuitive data visualizations and employed Python and Jupyter Notebook for enhanced automation and efficiency in data processing tasks. Managed databases including Snowflake, Teradata, MySQL, and PostgreSQL, optimizing queries and performance for efficient data retrieval and storage.Leveraged Azure services like Azure Data Factory and Azure Data Lake for data integration, and utilized Apache Zookeeper for distributed coordination in big data ecosystems. Collaborated with cross-functional teams using Jira Software and Slack, conducted web traffic analysis using Google Analytics, and ensured data integrity through extensive SQL-based validation and backend testing.

Pittsburgh, Pennsylvania, United States

Dedicated to analyzing business requirements and design specifications to drive efficient ETL processes, thriving in UNIX environments. Adept at data analysis, cleansing, and mapping, with a focus on delivering cost-effective data storage and processing solutions on AWS. Skilled in developing Tableau visualizations and dashboards, with expertise in Loan IQ configuration and reporting modules.experience in working with regression models, classification models, casual modeling, ML data model training, and testing.Developed and implemented statistical models to analyze customer behavior, improving retention rates by 15%.Conducted exploratory data analysis (EDA) to identify trends and patterns, leading to actionable insights for marketing strategies.Designed and executed randomized controlled trials (RCTs) to evaluate the effectiveness of new marketing campaigns, ensuring robust causal inference.Used propensity score matching to analyze observational data, allowing for better understanding of treatment effects.Led A/B testing initiatives for website design changes, analyzing results to inform UX improvements that increased conversion rates by 25%.Developed comprehensive testing frameworks to ensure statistical significance and reliability in experimental results.Experience with statistical analysis and modeling, casual modeling, A/B testing, regression modeling.Strong in SQL optimizations and performance analysis, with a background in data visualization using Tableau and QlikView. Proficient in big data processing and analysis using Hadoop and Hive, managing data pipelines with Apache Airflow, and leveraging BI tools like Power BI and Google Analytics. Skilled in project management using JIRA and providing expertise in data analysis and reporting with statistical software such as SPSS and R.

Mumbai, Maharashtra, India

Led cross-functional teams in implementing Scrum Agile methodologies and acted as a vital liaison between business user groups and technical teams. Conducted comprehensive BI applications and database system studies to ensure seamless system design, integration, and application maintenance. Provided extensive training sessions to empower team members with Azure data analytics skills and best practices.Implemented change data capture (CDC) and validated data flows to maintain historical data integrity. Managed Azure cloud services, conducted statistical analysis with SAS, and optimized PostgreSQL and Oracle databases for peak performance. Generated professional reports and visualizations in IBM SPSS and designed interactive dashboards with Tableau and Power BI.Proficient in data masking validation and project tracking with Jira. Developed automated workflows using Azure Logic Apps and executed ETL tasks with Informatica. Demonstrated adeptness in multitasking across projects and effectively collaborated with professionals at various levels. Conducted root cause analysis and validated business requirements to ensure data integrity and reliability.

Mumbai, Maharashtra, India

Managed requirements gathering and architecture, leveraging expertise in writing complex queries and stored procedures to ensure efficient data management. Utilized Tableau to create action filters, parameters, and calculated sets, facilitating the preparation of insightful dashboards and worksheets.Proficiently handled Workflow Manager tasks, including sessions, events, decision-making, and scheduling, ensuring smooth workflow operations. Implemented data workflows and storage solutions on AWS, such as S3, EC2, and Redshift, emphasizing scalability and reliability.Excelled in implementing DAX calculations in Power BI for advanced analytics and deriving new metrics. Demonstrated proficiency in MS Excel for data manipulation, employing functions like VLOOKUP and Pivot Tables for comprehensive insights.Expertise in Python and R programming languages for statistical analysis, data manipulation, and machine learning modeling in Jupyter Notebooks. Developed and maintained automated data ingestion processes on AWS, integrating diverse data sources seamlessly.