Data Analyst Business Intelligence

Location:

Hyderabad, Telangana, India

Posted:

September 10, 2025

Contact this candidate

Resume:

SUMMARY

Rohith Abhinav Dasari

Data Analyst

+1-216-***-**** **************@*****.*** United States

Over 5 years of hands-on IT experience in Data Warehousing, Data Analysis, Business Intelligence, and Database Development.

Proficient in all phases of the Software Development Life Cycle (SDLC) including analysis, design, development, testing, and deployment.

Strong expertise in Dimensional Modeling, Relational Modeling, and designing Star and Snowflake schemas.

Skilled in designing Fact and Dimension tables for efficient data analysis and reporting.

Extensive experience with data modeling tools such as ERwin and PowerDesigner for both logical and physical model design.

Strong command of SQL, PL/SQL, Toad scripting, and writing Stored Procedures, Functions, and Triggers.

Experience working with Oracle (11g/10g/9i/8i), SQL Server, DB2, Teradata, and Microsoft Access.

Proficient in ETL development using tools like Informatica and SSIS for large-scale data migration and transformation.

Expertise in performance tuning, query optimization, indexing, caching, and buffer tuning for high-performance systems.

Solid understanding of Enterprise Information Management (EIM) and Master Data Management (MDM) principles.

Adept at conducting Joint Application Development (JAD) sessions and capturing business requirements effectively.

Experience working closely with business users, data architects, and project stakeholders to translate requirements into data models.

Proficient in data visualization tools such as Power BI, Tableau, and Excel for generating analytical dashboards and reports.

Strong documentation skills, including preparing technical specifications, data dictionaries, and process documentation.

Excellent interpersonal and communication skills, with a proven ability to mentor junior team members and foster collaboration.

Experience in Agile/Scrum environments, contributing to sprint planning, development, and timely delivery of BI features.

Knowledge of data governance, data quality standards, and compliance frameworks including GDPR.

Ability to reverse engineer databases and perform impact analysis for changes in legacy systems.

Experience conducting code reviews, data validation, and ensuring alignment with best practices and organizational standards.

Proven ability to deliver robust data solutions under tight deadlines with a focus on scalability, performance, and maintainability.

EMPLOYMENT HISTORY

Data Analyst Intern, DataNest Analytics, San Francisco, US. July 2024-June 2025

Analyzed large datasets using SQL and Python to identify trends, correlations, and outliers supporting business decisions.

Designed and developed interactive dashboards in Power BI/Tableau, streamlining executive reporting for multiple departments.

Collaborated with cross-functional teams (Product, Marketing, Finance) to define KPIs and monitor campaign performance.

Automated repetitive data tasks and reports using Python scripts and Excel macros, saving over 10 hours per week.

Conducted A/B testing and statistical analysis to evaluate the impact of marketing strategies and product enhancements.

Created and maintained data pipelines using ETL tools, ensuring consistent and accurate data delivery to analytics platforms.

Participated in data quality assurance by identifying missing data, outliers, and inconsistencies using Python and Excel.

Used cloud platforms (AWS/GCP) for data storage, querying, and integration with business intelligence tools.

Supported data modeling initiatives, contributing to star schema designs for optimized OLAP queries.

Documented workflows, created training material, and mentored junior interns in data handling best practices.

Integrated U.S. and global datasets to localize insights and support market-specific business strategies.

Presented analytical findings and actionable recommendations to leadership, contributing to a 15% increase in customer engagement.

Data Analyst, Aspire Systems, Hyderabad,India Mar 2021- Dec 2022

Designed star and snowflake schemas for marketing, sales, and customer data marts.

Developed reusable SQL scripts and templates to improve efficiency across teams.

Integrated data from flat files, Excel, and relational databases using manual ETL pipelines.

Documented data dictionaries and entity relationships to improve team collaboration.

Participated in daily stand-up meetings, sprint planning, and backlog grooming sessions.

Implemented exception handling in PL/SQL code to minimize load failures.

Worked with QA teams for end-to-end testing of BI reports and database objects.

Identified and fixed data anomalies, ensuring regulatory and audit compliance.

Created Excel-based dashboards and pivot reports for non-technical stakeholders.

Coordinated directly with business analysts to clarify requirements and define acceptance criteria.

Assisted in the migration of legacy reports to Power BI, ensuring consistency with historical data.

Scheduled and monitored ETL jobs using SQL Server Agent and Unix cron jobs.

Optimized PL/SQL procedures and queries, improving report load times by up to 40%.

Maintained and enhanced operational reports used by sales, finance, and customer support teams.

Conducted UAT sessions with end-users to validate data accuracy and report functionality.

Developed parameterized SQL queries for dynamic reporting and ad-hoc analysis.

Collaborated with DBAs to manage data archival strategies and improve query performance.

Tracked data lineage to ensure traceability and support root cause analysis.

Created mock-ups and wireframes to visualize dashboards before development.

Participated in cross-functional data governance meetings to standardize metrics and definitions.

Data Analyst, Invenio business solutions, Hyderabad, India June 2018 – Feb 2021