Sambasivarao Tangella
Hyderabad
Summary
Skilled SQL, SSRS, and Power BI Developer with 5 years of experience in business intelligence and data visualization. Expertise in designing and implementing interactive reports and dashboards, with a focus on performance tuning. Proficient in DAX queries, data modeling, and managing publication settings in Power BI Service. Committed to enhancing data accuracy and optimizing performance through effective data analytics and visual solutions.
Overview
9
9
years of professional experience
Work History
SSRS, Power BI Developer
Varsun E technologies Pvt Ltd
Hyderabad
05.2022 - Current
- Participated in requirements meetings and Scrum calls to understand the report requirements.
- Identified and documented detailed business rules.
- Used Power Query / Query Editor for data transformation as per the reporting needs.
- Created a data model in Power Pivot by establishing the relationship between the tables.
- Created new columns and new measures over data models for the purpose of enhancing Power BI visuals using DAX.
- Participated in weekly and daily meetings, reviewed meetings, and communicated with business teams.
- Integrated custom visuals based on business requirements using Power BI Desktop.
- Created hierarchies and drill-down reports.
- Created Microsoft Power BI dashboards in Power BI Service using reports.
- I installed and configured data gateways to refresh and schedule the refresh of the dataset.
- Managed access of reports, dashboards, and data for individual users using roles.
- Implemented row-level security as part of security.
- Provided continued maintenance and development of bug fixes for the existing and new Power BI reports.
- Managed and resolved support tickets raised by users for production reports, conducting root cause analysis, and implementing fixes to ensure report accuracy and reliability.
- Performed data reconciliation using SQL, ensuring data accuracy across systems, and validating business-critical information.
- Analyzed ad hoc reporting requirements, translated them into optimized SQL queries, later converted them into stored procedures, and developed SSRS reports to deliver user-requested insights.
Senior Design Specialist
Cyient Ltd
Hyderabad
03.2018 - 05.2022
- Designed and developed SSRS reports based on business requirements.
- Created complex SQL queries and stored procedures for data extraction.
- Implemented report parameters and filters to enhance usability.
- Maintained documentation for reports and associated processes.
- Ensured accuracy and integrity of report data throughout development.
- Optimized report performance, addressing issues as they arose.
- Provided technical support and training sessions for users of reports.
- Collaborated with stakeholders to gather and analyze reporting requirements.
Excel Analyst
Nokia Solutions Networks Pvt Ltd
01.2017 - 03.2018
Data Entry
Gramtel Solutions
06.2016 - 01.2017
Education
B. Tech -
Eluru college of engineering and technology
Skills
- SQL and MS SQL Server
- Power BI and SSRS
- Excel
- Power Query
- Power Pivot
- Data transformation
- Data visualization
- Dashboard creation
- Business requirements gathering
- Stakeholder collaboration
- Performance optimization
- SQL querying
- Data analysis
- User support
- Collaboration skills
Project - 1
- Newmark is a commercial real estate services company, offering a wide range of services, including investment sales, debt and structured finance, agency leasing, property management, valuation and advisory, and loan servicing.
- They also utilize a revenue management system (RMS) to optimize pricing and other strategies, and Newmark's RMS leverages data analytics and forecasting to improve pricing strategies, leading to increased efficiency and profitability
- RMS is an intelligent software solution that automates necessary revenue management tasks to save time and increase efficacy
- For US-based client NEWMARK businesses, these systems work to calculate and recommend appropriate commissions for brokers, lease vendors, and customer types or channels based on the data they collect and analyze
Project - 2
- South Bay is the leader in developing low-cost, highly efficient, high-quality software solutions for the traffic violation sector
- Their solutions are used by many government agencies
- Agencies across the USA
- This project helps one of the clients in the USA to upgrade their existing system to the latest version, which will serve their customers for at least a decade with utmost convenience and bring down existing operational costs by consolidating different systems, i.e., both the application and databases into a single largest ecosystem
Accomplishments
- Delivered multiple client-facing dashboards with zero critical defects post-deployment, and recognized for optimizing legacy SSRS reports, improving load times by over 40%. Created successful POCs (Proof of Concepts) for various reporting needs, driving project approvals. Awarded internally for consistent contributions to dashboard standardization and knowledge sharing
Timeline
SSRS, Power BI Developer
Varsun E technologies Pvt Ltd
05.2022 - Current
Senior Design Specialist
Cyient Ltd
03.2018 - 05.2022
Excel Analyst
Nokia Solutions Networks Pvt Ltd
01.2017 - 03.2018
Data Entry
Gramtel Solutions
06.2016 - 01.2017
B. Tech -
Eluru college of engineering and technology
Similar Profiles
Venkata Nagaraju InakolluVenkata Nagaraju Inakollu
Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)
S ChetanS Chetan
Assistant Manager - Finance at ANIMALL TECHNOLOGIES PVT LTD, Technologies Pvt LtdAssistant Manager - Finance at ANIMALL TECHNOLOGIES PVT LTD, Technologies Pvt Ltd
Shweta SinghShweta Singh
Support Engineer-IT at I-Telemetry Technologies Pvt. Ltd. (Subsidiary of Aaxis Nano Technologies Pvt. Ltd.)Support Engineer-IT at I-Telemetry Technologies Pvt. Ltd. (Subsidiary of Aaxis Nano Technologies Pvt. Ltd.)