Saketh Puskuri
Summary
Data enthusiast with 3.5 years of experience as a Data Analyst and Database Developer. Proven expertise in SQL, Python, and Power BI. Experienced in problem scoping, insights generation, data scripting, data modeling, and data monitoring. Adept at working with stakeholders to deliver high-quality data solutions that meet business objectives.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst
RxAdvance
Southborough, MA
05.2023 - Current
- Participated in Scrum meetings to discuss user stories and stakeholder requirements.
- Managed data ingestion from diverse sources, including Rest APIs and on-premises SQL Server databases.
- Developed and optimized ETL processes for efficient data transformation and integration.
- Ensured data access security and integrity.
- Created data transformation scripts using Python for automation and efficiency.
- Configured automated notifications for monitoring any data pipeline failures.
- Loaded and transformed data for advanced analysis and reporting.
- Developed interactive dashboards and reports in Power BI, enabling data-driven decision-making.
- Conducted performance tuning and optimization of SQL queries for better data retrieval and processing.
Data Analyst
MTX Group
Albany, NY
03.2021 - 04.2023
- Developed and analyzed financial data modules, including Account Receivables, Invoice Generation, and Unapplied Cash amounts.
- Analyzed metrics for Account Receivables, Cash, Invoices, and Collections to improve financial processes.
- Optimized SQL workflows to minimize data discrepancies, achieving a 50% reduction in filing issues.
- Addressed dashboard metric issues to ensure accurate invoice amounts.
- Guided team members on high-priority tasks and provided data-driven solutions.
- Built and maintained Power BI dashboards to visualize financial data and track key performance indicators.
- Conducted root cause analysis on data discrepancies and implemented corrective actions.
Database Developer Intern
MTX Group
Hyderabad, IN
08.2020 - 01.2021
- Collaborated with UI teams to design and implement stored procedures, user-defined functions, and triggers.
- Developed T-SQL modules to enhance existing data models based on business requirements.
- Ensured data integrity through robust validation processes.
- Created physical and logical ER diagrams and implemented indexing strategies to optimize query performance.
- Provided support for T-SQL development and monitored database performance.
- Participated in the design and implementation of database solutions for various projects.
- Assisted in developing and maintaining database documentation to ensure clarity and accessibility for ongoing system maintenance.
Education
Master of Science - Data Science
SUNY At Albany
Albany, NYBachelor of Science - Information Technology
Sreenidhi Institute of Science And Technology
HyderabadSkills
- Statistical Methods: Hypothesis Generation, Univariate Analysis, Bivariate Analysis
- Machine Learning: Linear Regression, Logistic Regression, Decision Trees, Random Forest, K-Nearest Neighbors, K-Means Clustering
- Data Analytics: SQL, Python, R, Power BI, Jupyter Notebook
- Database Languages: SQL, DB2
- Tools and Technologies: SQL Server, MySQL, PyCharm, Visual Studio, MS Excel
- Functional Skills: Process Interpretation, Analytical Ability, Team Management, Interpersonal Communication, Problem Solving
Certification
- DP-900 Microsoft Azure Data Fundamentals
- PL-300 Microsoft Power BI Data Analyst
- IBM Data Science Professional Certificate (Coursera)
Accomplishments
- Star Performer for the Year.
- Star Team Award
Timeline
Data Analyst
RxAdvance
05.2023 - Current
Data Analyst
MTX Group
03.2021 - 04.2023
Database Developer Intern
MTX Group
08.2020 - 01.2021
Master of Science - Data Science
SUNY At Albany
Bachelor of Science - Information Technology
Sreenidhi Institute of Science And Technology
Similar Profiles
Chandy JayChandy Jay
Technical Manager/Solutions Architect Enterprise at RxAdvanceTechnical Manager/Solutions Architect Enterprise at RxAdvance
Kaushal SinghKaushal Singh
Batch Ops Engineer at RxAdvance PBMBatch Ops Engineer at RxAdvance PBM
Saurabh YadavSaurabh Yadav
Clinical Pharmacy Technician at Rxadvance Private Ltd.Clinical Pharmacy Technician at Rxadvance Private Ltd.
Lenina MirzaLenina Mirza
Data Analyst (Customer Support Data Analyst) at Mazda Australia Pty LtdData Analyst (Customer Support Data Analyst) at Mazda Australia Pty Ltd
Jonathon NanceJonathon Nance
Senior Data Analyst /Lead Data Analyst at Two Kings CasinoSenior Data Analyst /Lead Data Analyst at Two Kings Casino