Samuel Philips
Data Analyst / BI Developer • Hyderabad, Telangana • j**************@gmail.com • +91*******430 • linkedin.com/••••• • drivetube.ai/•••••
Professional Summary
Data Analyst with 9+ years of experience building BI solutions and analytical pipelines using Power BI, DAX, SQL Server and MySQL. I specialize in end-to-end reporting — requirements gathering, ETL with Power Query and SSIS, semantic modeling, and production Power BI dashboards for e-commerce, hospitality and consulting clients. I have designed DAX measures and data models to deliver timely KPIs and automated reporting, and built ETL processes to consolidate multi-source transactional data for reliable analytics. At Amazon I analyzed payment transaction datasets and improved reconciliation workflows; as a freelancer I standardized reporting and automated recurring reports to reduce manual effort. I apply Advanced Excel and Python for exploratory analysis and validation, and use Tableau selectively for executive visualizations. I prioritize clear documentation and stakeholder enablement to maximize dashboard adoption and drive data-driven decisions.
Technical Skills
Programming Language: Python
Databases: Microsoft SQL Server,MySQL
Data Warehousing: Data Modeling
Data Analysis & Visualization: Power BI,Tableau,Power Query,Pivot Tables,DAX
Data Integration & ETL: ETL
Project Management & Collaboration: Jira,Agile,Semantic Models
Work Experience
SIT
Hyderabad, Telangana
Business Analyst Intern
May 2025 – Jan 2026
Internship supporting BI/reporting work for business stakeholders; delivered Power BI dashboards and validation for internal reporting needs.
Tech Stack: Power BI, DAX, Jira
- Gathered and refined reporting requirements with business and technical stakeholders to define KPIs, data sources and acceptance criteria.
- Designed Power BI semantic models and optimized relationships to ensure accurate aggregation and performant report visuals.
- Implemented DAX measures and calculated columns to enable month-over-month and YTD comparisons for operational KPIs.
- Performed dashboard testing and data validation using reconciliation samples to guarantee report accuracy and data lineage.
- Documented report specifications and tracked development issues using Jira to ensure timely delivery of stakeholder-requested features.
- Trained stakeholders on dashboard navigation and self-service features to improve adoption and reduce ad-hoc report requests.
BI Developer | Analyst | Freelancer
BI Developer | Analyst | Freelancer
Aug 2020 – May 2025
Contract BI work delivering end-to-end Power BI reporting solutions and data preparation for multiple clients across domains.
Tech Stack: Power BI, Power Query, DAX, Excel
- Delivered end-to-end Power BI reporting solutions from requirement gathering to production deployment and stakeholder handover.
- Engineered data transformations with Power Query to standardize client datasets originating from relational sources and flat files.
- Automated recurring reporting workflows and scheduled refreshes to reduce manual effort and standardize delivery cadence.
- Processed and validated large datasets using Advanced Excel pivot tables and SQL-derived extracts to ensure downstream report quality.
- Translated business requirements into KPIs and authored DAX measures to provide actionable, client-aligned metrics.
- Implemented documentation and deployment guides to enable client teams to maintain dashboards and refresh schedules independently.
Amazon
Hyderabad, Telangana
Transaction Risk Analyst
July 2019 – July 2020
Analytics role within e-commerce transactional operations focused on payment lifecycle, reconciliation and operational reporting.
Tech Stack: SQL Server, Power BI, DAX, Power Query, SSIS, Tableau
- Analyzed payment lifecycle and transactional datasets using SQL Server to detect anomalies and prepare inputs for reconciliations.
- Created Power BI dashboards with DAX measures to surface payment KPIs and trends for operations and finance stakeholders.
- Performed data reconciliation and root-cause analysis on discrepancies to ensure invoicing accuracy and reporting integrity.
- Built ETL processes using Power Query and SSIS to consolidate multi-source transaction data for the reporting layer.
- Produced auxiliary visualizations in Tableau to validate Power BI outputs and support executive-level summaries.
- Delivered process and reporting improvements that reduced operational losses by 25% through standardized reconciliation workflows.
C3i
Hyderabad, Telangana
Technical Analyst
May 2017 – March 2018
Operational and testing support role executing SQL-based validation, invoicing reconciliation and STLC activities for operational reports.
Tech Stack: SQL, Agile, STLC
- Executed SQL queries for data extraction and validation to correct and improve the accuracy of operational reporting.
- Backed invoicing and reconciliation processes by preparing validated datasets and structured reporting artifacts.
- Conducted STLC tasks including test case execution, defect logging and verification to accelerate resolution of data issues.
- Diagnosed recurring system downtime impacts through log analysis and data checks, enabling targeted remediation steps.
- Documented data workflows and validation rules to reduce recurring discrepancies and support knowledge transfer.
- Drove Agile ceremonies and clarified data requirements to development and testing teams to aid sprint delivery.
Projects
Budget Forecast Reporting Dashboard
Tools Used: Power BI, Power Query, SSIS, DAX
- Combined multiple data sources using Power Query and SSIS to create a unified dataset for budget and forecast analysis.
- Modeled data and authored advanced DAX calculations in Power BI to track budgetary KPIs and present scenario-based forecasts.
- Presented the dashboard to stakeholders and incorporated feedback to align visualizations with decision-making requirements.
Hospitality Domain Data Analysis (AtliQ Grand Hotel)
Tools Used: Python, SQL
- Used SQL to extract relational data and Python for exploratory data analysis to identify revenue and market-share drivers.
- Executed ETL-style cleaning and transformation to prepare datasets for KPI extraction and time-series analysis.
- Delivered actionable recommendations from EDA that guided pricing and promotional decisions to improve occupancy and revenue mix.
Education
JNTUH
Bachelor of Technology in Mechanical Engineering • Aug 2013 – May 2017
Certifications
Microsoft Power BI Data Analyst Associate — Microsoft
Microsoft Office Specialist: Excel Associate — Microsoft
Data Science Professional — ODIN School
Powered by Drivetube · Create your own profile at drivetube.ai
Explore Drivetube
- Drivetube Profile — your free digital resume — at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept. Documentation.
- Free Job Board — verified openings crawled ATS-by-ATS from 100,000+ real company career pages across 35 ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed. Documentation.
- Job Hunt Program — managed job hunting, a one-time purchase from $199.99. JobScout matches verified roles to your real experience band, Blend AI writes a uniquely tailored resume and cover letter for every application, and the Autofill extension fills the form — or Let Us Apply submits it for you. Documentation.
- Resume Writing Services — human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile. Documentation.
- Community Membership — from $4.99/month (₹1,999/year in India). Unlocks the gated job-board filters — visa sponsorship, security clearance, workplace and application time — plus Job-Scout AI matching, Resume Report AI, Interview AI prep sheets, Recruiter Outreach AI sent from your own Gmail, Apply or Skip triage, a daily market feed and a $10,000+ library including 23 ATS-validated resume templates. Documentation.
- Drivetube Hire — for employers — hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do. Documentation.
Full product documentation — every product explained, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.
The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.