Data Analyst Software Development

SHASHIDHAR REDDY BOREDDY

Data Analyst

Irving, Tx ******************@*****.*** +1-234-***-**** LinkedIn GitHub

PROFESSIONAL SUMMARY

•Accumulated 3 years of comprehensive experience as a Data Analyst with a focus on Data Modeling, Data Source Evaluation, and a deep understanding of Data Warehousing.

•Proficient in the end-to-end Software Development Life Cycle (SDLC) for projects, adeptly applying methodologies like Agile and Waterfall to ensure successful project execution.

•Demonstrated expertise in leveraging Python libraries, including NumPy, Pandas, Matplotlib, Seaborn, and SciPy, to perform advanced data analysis, visualization, and scientific computing using Visual Studio Code and PyCharm.

•Competent in creating filters, parameters, and calculated sets to design interactive dashboards and worksheets using tools such as Tableau and Power BI and Advanced Excel.

•Possess a strong understanding of relational database systems, including MySQL and SQL Server, for efficient data retrieval and management.

•Proficiently maintain Git repositories for efficient code version storage, enabling collaborative development and source code management.

•Designed and developed comprehensive weekly and monthly reports using Excel, employing advanced techniques such as charts, graphs, and pivot tables.

•Possess a blend of strong interpersonal, analytical, critical thinking, and communication skills, enabling effective collaboration and data-driven decision-making.

EDUCATION

• Master of Science in Business Analytics: Kent State University, Kent, Ohio.

• Bachelor’s in business analytics Specialization: Osmania University, India.

WORK EXPERIENCE

State of Ohio (Ohio Department of Health), OH Jan 2023 – Current Data Analyst

•Extracted healthcare data from sources such as electronic health records (EHRs), claims data in structured formats (e.g., CSV, XML), and clinical databases using SQL databases.

•Implemented data preprocessing techniques, including handling missing values, outlier detection, and data normalization.

•Developed and maintained predictive models, such as logistic regression, decision trees, and random forests, for clinical decision support and operational optimization.

•Utilized Jupyter notebooks for model development and evaluation, with libraries like Scikit-Learn and TensorFlow for machine learning.

•Designed metrics and KPIs to predict and prevent customer discontinuation, improving retention rates.

•Managed sensitive client data securely, adhering to healthcare data privacy regulations like HIPAA.

•Conducted data standardization and formatting tasks using R and Microsoft Excel before importing data into a centralized database SQL Server.

•Analyzed business data using SQL queries and stored procedures in PostgreSQL, and utilized Azure Synapse for ETL, transforming and loading data into analytics pipelines for healthcare data.

•Worked with engineers and teams for the identification of the consumer data requirements for recommending best practices to implement to resolve the issues and enhance security.

•Assisted the Reporting & Analytics team by providing data expertise, conducting research, and optimizing data access for standard and ad hoc reporting processes.

•Refined Power BI and Excel data models using R, boosting reporting speed by 25% and enabling real-time data access for 500+ users.

•Worked with Jira to track stories, tasks, and tickets in an Agile and Scrum environment, including sprint planning, stand-ups, and retrospectives.

Fidelity Investments, India Jan 2021 - July 2022 Data Analyst (Associate)

•Designed and developed Relational Database Management, Database Design, and Database architecture System using Mongo DB, PostgreSQL, and SQL Server.

•Developed SAS data listings, used AWS S3 and Glue for processing, and converted Word and Excel data into SAS datasets, improving financial metrics accuracy by 25%.

•Created Tableau advanced charts using geo maps, Gantt charts, Pareto charts, and scatter plots for providing multidimensional views.

•Designed and deployed reports with Drill Down, Drill Through, and Drop-down menu options and Parameterized and Linked reports using Tableau.

•Setting up project baselines, branching, merging, and taking regular backups of the source in GIT and SVN.

•Experienced in using statistical methods, metrics, quantitative methods, and strategic project plans for data collection and later given the responsibility to validate the data integrity.

•Developed T-SQL and MySQL database objects, including Business Stored Procedures, Tables, Views, Indexes, Triggers, Constraints, User Roles, and User-Defined Functions.

•Wrote Python scripts to parse JSON documents, load data into the database, and migrate and verify data from the old server to the Jira database.

•Generated data reports for the BI tools team by exporting analyzed data to AWS RDS and Redshift for data visualization using tools like Tableau and Quick Sight.

•Responsible for report automation and data mining using advanced MS Excel PivotTables, Charts, Graphs, Macros, and VBA.

•Collaborated with cross-functional teams, including data engineers and business analysts, to iteratively develop and deliver data solutions.

SKILLS & Other

Methodologies: SDLC, Agile, Waterfall

Programming Languages: Python, R, SQL, VBA Macros

IDEs: Visual Studio Code, PyCharm

Data Analysis Packages: NumPy, Pandas, Matplotlib, SciPy, Seaborn, ggplot2, dplyr, tidyr, plotly

Data Modeling Tools: Sigma Catalog

Cloud Technologies: AWS(S3,SNS,SQS,EMR,EC2),Azure

Data Visualization Tools: Amazon Quick Sight, Tableau, Power BI, Advanced Excel

Other Tools: MS Office Suite (Word, PowerPoint, Visio), ETL (SSIS), OLAP & OLTP, Unify, SAS, KPI, Vision, Strategy Status, Research, Decision Making, Business Models, Analytics, Validation, Stakeholders, Databases: MySQL, Oracle, T-SQL, Monet DB, Teradata, PostgreSQL, SQL Server, ETL (SSIS)

Other Technical Skills: Data Cleaning, Statistics, Data Modeling, Data Wrangling, Tensor, Data Warehousing, Data Architecture, Database Building, Data Governance, Data Analysis, Application Development, Analytical Skills, Information Management, Operations Support, Root Cause Analysis, Quantitative Analysis, Technical Documentation, Project Management, Ad Hoc Analysis, Statistical Analysis, Financial Analysis, Pivot Tables, Google Analytics, Adobe Analytics

Operating Systems: Windows, Linux

Others: Leadership, Communication, Decision-making, Cross-functional collaboration, Analyzing, Stakeholder management, Problem-Solving, Root Cause Analysis, Critical Thinking, Time Management, Adaptability.

CERTIFICATIONS

• AWS Certified: Solutions Architect – Associate (Valid until 2027).

Contact this candidate