Data Analyst Business

SRUTHI KALIMAKOLAN

Data Analyst/Business Analyst

+1-334-***-**** Montgomery AL, 36117 ***********@*****.***

https://www.linkedin.com/in/sruthi-k0112/

PROFESSIONAL SUMMARY

• An experienced data analyst with 4+ years of professional experience with strong communication, leadership, and interpersonal skills.

• Experience in data visualization using Python, R, and Tableau.

• Strong experience in databases like Mongo DB, MySQL, and SQL servers.

• Experience in various phases of the Software Development life cycle.

• Experience with Data Analytics, Data Wrangling, Data Exploration, and Data Visualization.

• Used Git and GitHub for version Controlling.

• Working knowledge of Amazon Web Services (AWS) and Cloud Data Management.

• Knowledge in creating and developing PowerBI Dashboards into a rich look.

• Experience in developing data applications in Windows and macOS environments.

• Solid academic project experience with problem-solving, analysis, communication, and teamwork skills.

• Experience in coding SQL/PLSQL using Procedures, Triggers, and Packages. EDUCATION

Master of Science, Auburn University, Montgomery, AL 05/2023 Bachelor of Technology, Jawaharlal Nehru Technological University, Hyderabad 06/2019 Skills

Data Analytics: Tableau, Power BI, Python, SharePoint List, MS Office suite, Google Analytics, APP Script Project Management Tools: MS Project, MS Outlook, Excel, PowerPoint, MS SharePoint, Visio, Jira, Confluence IDEs: Visual Studio Code, PyCharm, Jupyter notebook, Spyder Packages: NumPy, Pandas, Matplotlib, Seaborn, SciPy, ggplot2 Databases: MYSQL, SQL Server, NoSQL

Methodology: SDLC, Agile, Waterfall

Cloud: AWS, GCP (Google Cloud Platform)

Experience

Data Analyst/ Business Analyst 03/2023 - Current

Humana USA

• Designed and maintained complex SQL queries for data analysis and extraction to identify trends such as policy acquisition times and customer retention rates.

• Used Python to visually analyze datasets, gaining insights into policyholder behavior and claim patterns.

• Designed and reviewed Tableau dashboards for comprehensive insurance data visualization, including bar graphs, scatter plots, geographical maps, and Gantt charts.

• Migrated historical policy data into the AWS cloud and set up automated processes for incoming data streams, ensuring timely data updates.

• Converted charts into crosstabs for detailed data analysis in MS Excel, and managed physical and logical data modeling, metadata documentation, and user documentation.

• Managed projects using agile methodology to ensure timely software delivery.

• Performed data cleansing and preparation using SQL and Excel, ensuring high-quality data for analysis.

• Conducted data mining to analyze insurance data patterns, aiding in fraud detection and risk management.

• Utilized Python and SQL for data manipulation, model construction, and validation, improving accuracy in risk assessment.

Data Analyst/Business Analyst 08/2020 – 12/2021

Technology Networks India

• Developed Python automation to optimize processes within Google’s FedRAMP team, enhancing team efficiency and reducing 3 weekly manual work hours.

• Optimized team efficiency by 10% by creating dynamic product dashboards using Google Cloud Platform, Python, SQL, and dashboarding tools like Tableau & Power BI.

• Improved data models and cleansed data using SQL and Excel, ensuring high-quality data for projects.

• Utilized SSIS and Talend Open Studio for ETL tasks, delivering technical solutions to business stakeholders.

• Designed and developed enterprise-wide operational reports for senior management using Tableau and Power BI.

• Contributed to 15% increase in project efficiency by participating in project planning sessions, leading to better analysis of business requirements and more effective proposed solutions.

• Enhanced project management plan by using Confluence, Jira and One note for business process, and process flow, resulting in amplified project coordination and streamlined operations, leading to client satisfaction.

• Accelerated client’s security measures by assisting in conducting comprehensive security control audits, resulting in lifting data integrity and increased protection against potential security threats. Data Analyst 07/2018 – 07/2020

Kellton India

• Utilized statistical analysis to polish the organization’s integrity during onboarding and offboarding processes, leading to a 20% reduction in data errors and Strengthening decision-making for the IT team.

• Incorporated R, SQL, Excel, and Tableau to manipulate and analyze retail supply chain data.

• Automated the integration of data from GIT, AWS, SLACK, Outlook, and NIST using Python and Pandas, reducing data processing time by 30% and improving data accuracy, leading to more informed business decisions.

• Utilized SSIS and Talend Open Studio for ETL tasks, delivering technical solutions to business stakeholders.

• Worked on Data modeling and advanced SQL with Columnar Databases using AWS.

• Implemented Python Pandas automation for efficient handling of dormant and bot accounts, resulting in a 3% cost saving and reduction in access to dormant accounts. Certifications

Data Analytics Bootcamp from YouTube

Data Analytics Essentials from Cisco

Contact this candidate