Data Analyst Analytics

PRADEEP GATTI

• +1-682-***-**** • ************@*****.*** • LinkedIn • GitHub • My-Portfolio

SUMMARY

Analytical and results-driven Data Analyst with 4.5+ years of experience transforming raw data into actionable business insights. Skilled in SQL, Python, Tableau, and Excel to conduct data wrangling, statistical analysis, and dynamic visualization. Adept at designing ETL pipelines, developing interactive dashboards, and translating complex datasets into clear narratives for decision-makers. Proficient in working with relational and NoSQL databases (MySQL, SQL Server, MongoDB) and deploying analytics solutions on cloud platforms like AWS. Proven success collaborating with cross-functional teams in Agile environments to support data-driven strategies that improve operational efficiency and business outcomes. Tableau Specialist certified, with a strong foundation in programming and a passion for converting data into strategic value.

EDUCATION

Master of Science in Information Systems Stevens Institute of Technology, USA 05/2024

B. Tech in Information Technology Sree Vidyanikethan Engineering College, India 09/2020

PROFESSIONAL EXPERIENCE

Data Analyst Broad Peak Systems - Remote 08/2024 - Present

•Built and deployed data dashboards using Tableau and Python (Plotly, Matplotlib) to visualize operational KPIs and customer behavior metrics, enabling leadership to identify trends and make faster, informed decisions.

•Developed and optimized complex SQL queries and stored procedures across MySQL and SQL Server databases, enabling accurate extraction and transformation of multi-source datasets for reporting automation.

•Created end-to-end ETL workflows using Python and Pandas to clean, merge, and prepare large-scale datasets from internal systems and third-party APIs, reducing manual data processing time by 60%.

•Automated reporting pipelines using Python and scheduling tools, delivering weekly and monthly analytics reports to stakeholders, and minimizing reporting errors.

•Performed root cause analysis on data anomalies and business issues through correlation studies and trend modeling, uncovering insights that led to a 20% improvement in sales forecasting accuracy.

•Collaborated with data engineers, product managers, and UX designers to define metrics, gather business requirements, and translate analytics findings into actionable business strategies.

•Implemented data integrity and version control best practices using Git and documentation via Confluence, supporting transparent and reproducible analytics processes.

•Utilized AWS services (S3, EC2, Lambda) for storing and processing large datasets in the cloud, enabling on-demand scalability for analytics workloads and improving data availability across departments.

Data Engineer Cognizant Technology Solutions Pvt. Ltd., Hyderabad, IN 07/2020 - 07/2022

•Designed and maintained SQL queries and stored procedures to extract and validate large datasets from MySQL and SQL Server, supporting business performance dashboards used by leadership for strategic decisions.

•Developed automated ETL pipelines using Python (Pandas, NumPy) to cleanse, transform, and merge structured/unstructured data, reducing manual data preparation time by 50% and improving accuracy in monthly reports.

•Created dynamic Tableau dashboards to visualize key business metrics such as customer churn, revenue trends, and sales performance, resulting in a 25% improvement in data- driven decision-making speed across departments.

•Conducted exploratory data analysis (EDA) and statistical modeling using Python (Seaborn, Matplotlib, Scikit-learn) to uncover trends and anomalies in product usage data, informing UX design changes that boosted engagement by 15%.

•Led data quality audits and implemented validation checks using SQL scripts and conditional logic, identifying data inconsistencies and improving overall reporting accuracy by 30%.

•Collaborated with cross-functional teams (product managers, marketing, and IT) to gather data requirements, develop KPIs, and deliver customized visualizations and reports that aligned with operational goals.

•Deployed and monitored data analysis solutions on AWS (EC2, S3) to ensure scalability and security of data reporting pipelines, supporting remote data access for analytics teams across multiple geographies.

•Documented data definitions, report specifications, and process workflows in Confluence and Jira, standardizing knowledge transfer and enabling quicker onboarding of new analysts.

Java Full Stack Intern Cognizant Technology Solutions Pvt. Ltd, Hyderabad, IN 07/2019 - 05/2020

•Contributed to all stages of the SDLC, from requirements gathering and design to deployment and maintenance, ensuring smooth delivery of software features. Applied Java and

Spring Boot for backend development and feature implementation.

•Utilized SQL and Hibernate ORM frameworks to design, query, and manage databases, enabling efficient data storage and retrieval. Developed database schemas and optimized queries for improved application performance.

•Implemented automated build and deployment pipelines using Jenkins and GitLab CI, enabling smooth integration and faster delivery cycles. Ensured code integrity through automated tests during the CI process.

•Managed source code using Git, performing tasks like branching, merging, and resolving conflicts to maintain organized and clean code repositories. Collaborated with team members on GitHub or GitLab to review code and manage pull requests.

TECHNICAL SKILLS

•Web Technologies: HTML/HTML5, CSS3, CSS, XML, JavaScript, AJAX, jQuery, JSON, Bootstrap

•Methodologies: Agile/Scrum, Waterfall

•Languages: Java, C++, Python, C, TypeScript

•Front-End Technologies: Angular.js, Node.js, React.js

•Databases: MySQL, SQL Server, JDBC, NoSQL, MongoDB

•Frameworks: Spring Boot, Angular, Docker, Hibernate, Kubernetes

•Back-End Technologies: Node.js, Python, Java, .NET, Express.js

•Development Tools: Visual Studio Code, IntelliJ, Eclipse, Spring Tool Suite, Postman, SOAP UI, Jenkins, JIRA, Confluence

•Cloud Platforms, Operating Systems & Version Control: AWS, Windows, Mac, Linux, Git, GitHub, GitLab

PROJECTS & CERTIFICATIONS

•Illegal Drone Tracking (Python, Pandas, GeoPandas) – Built Python pipeline analyzing 100K+ GPS logs to detect altitude/speed anomalies; achieved 98% detection accuracy via geospatial analysis.

•MindWell Health Application (SQL, Python, Tableau) – Developed a mental health tracking platform integrating SQL insights with Tableau dashboards to visualize mood trends and care effectiveness.

•Tableau Desktop Specialist – Created KPI dashboards that improved decision-making speed by 20%.

•PMP – Project Management Professional (PMI) – Led cross-functional analytics projects, boosting delivery efficiency by 40%.

•Java Developer Certification – Applied backend logic to support data workflows and integration.

Contact this candidate