Data Analyst Machine Learning

THILAK YACHAM

860-***-**** Gmail LinkedIn

Summary

• Data Analyst with over 3 years of extensive proficiency in Python, SAS, and Alteryx, harnessing these tools to develop AI and machine learning models for predictive analytics and business forecasting.

• Possesses excellent proficiency in Python for AI, SQL and NoSQL databases, where I adeptly perform complex queries and data manipulations to extract actionable insights from large datasets.

• Expertise in automating ETL processes using Python Scripts on AWS Airflow and enhancing productivity with data transformation and in statistical analysis and predictive modelling with SAS to support business requirements.

• Continuously enhancing my Apache Spark and Hadoop skills for big data processing and ETL processes using Alteryx and Ecxel Macros. Certifications

Databricks Generative AI Microsoft Azure Data Engineer Associate Power BI for Data Analysis Python for Data Science Databricks Lakehouse Generic Opkey Automation Testing (Salesforce, Workday, Coupa, Oracle) Work Experience

TIAA NC, United States

Data Analyst Aug 2023 – Present

• Performed statistical analysis using R to forecast financial trends, aiding in the development of investment strategies and risk assessments.

• Conducted data extraction, transformation, and analysis using SQL queries to derive actionable insights from large datasets.

• Extracted, transformed, and loaded financial data from Salesforce into SQL databases for in-depth analysis and reporting.

• Provided day-to-day support for Salesforce users, troubleshooting issues, and optimizing workflows to enhance user productivity within the financial domain.

• Designed interactive dashboards and reports in Tableau to visualize key performance indicators (KPIs) and trends for business stakeholders.

• Utilized Salesforce Einstein Analytics to create predictive models, identifying trends and forecasting financial outcomes for strategic planning. Metrix IT SC, United States

Data Analyst Intern Feb 2023 – May 2023

• Developed and optimized R scripts for data extraction, transformation, and loading processes, improving data pipeline efficiency by 25%.

• Performed Data analysis and Data profiling using complex SQL on various sources systems including Oracle and Teradata.

• Implemented and maintained third-party applications within Salesforce, enhancing the platform's capabilities to meet specific financial business needs.

• Developed comprehensive data integration processes to ensure seamless data flow from AWS sources into Tableau dashboards. Alorica Bangalore, India

Data Analyst Jan 2021 – Dec 2021

• Automated data extraction processes from Salesforce using R scripts, reducing manual efforts and increasing data processing efficiency.

• Implemented complex joins, aggregations, and subqueries to answer business questions and support decision-making processes using SQL queries.

• Built Alteryx workflows to streamline ETL processes, improving data accuracy and efficiency.

• Facilitated seamless data integrations between Salesforce and external financial systems, ensuring accurate and timely data exchange across platforms.

• Developed and maintained dashboards and reports in Tableau, delivering real-time visual data insights that led to a 15% increase in operational efficiency across departments.

• Automated data integration processes between Salesforce and external financial systems, ensuring data accuracy and consistency across platforms. Venture Softech Bangalore, India

Data Analyst Intern July 2020 – Dec 2020

• Utilized R to clean and preprocess large financial datasets, ensuring data accuracy and consistency for in-depth analysis.

• Optimized SQL queries and database performance, reducing query execution time by 30% and enhancing reporting efficiency.

• Built Alteryx workflows to streamline ETL processes, improving data accuracy and efficiency.

• Utilized advanced Excel techniques and VBA macros to automate routine data manipulation tasks, enhancing reporting efficiency and cutting down on manual data entry by 70%.

Projects

Capstone

• Developed a powerful recommendation engine using machine learning algorithms to deliver personalized course and job recommendations based on individual student preferences.

• Leveraged collaborative filtering, content-based filtering, and Natural Language Processing (NLP) to analyse extensive data and provide highly relevant recommendations.

• Exploited Flask to deploy the prediction model as a web application and capitalized data visualization techniques with Matplotlib, Seaborn, and Tableau to communicate actionable insights derived from the prediction mode. Education

•

Master of Science in Data Analytics May 2023

Clark University Worcester, Massachusetts

Bachelor of Computer Applications June 2021

CMR University Bangalore, India

Technical Skills & Tools

• Programming Tools: Python, R, SQL, T-SQL, SQL, MySQL, NoSQL, PostgreSQL, Java, C++, C, C, Apache Spark, Hadoop

• Business Intelligence Tools: Tableau, Power BI, QlikView, IBM Cognos, Looker

• Cloud Technologies: Azure, AWS, Snowflake, GCP, Oracle Database

• Extract Transform and Load (ETL): Tableau Prep and Alteryx, SSIS

• Other Skills: Critical Thinking, Communication, Active listening, Client-facing experience, Problem Solving, Analysis, Team Collaboration, Solution oriented, Collaborative Relationship Building, Data-Driven Decision Making

Contact this candidate