Summary
Overview
Work History
Education
Skills
Timeline
Generic

Abhinay Tallapaka

Hyderabad,TG

Summary

Solution-oriented and highly analytical information enthusiast with 6+ years of experience in information collection, data transformation, analytics, visualization and delivering accurate insights across diverse industries. Proven record of delivering top-class business intelligence solutions from concept, definition, technical architecture, integration, and report visualization.

  • Skilled in performing data transfer between different heterogeneous systems (Excel, Flat Files, XML file, JSON, OLTP DB) and SQL server as part of Data migration, Data maintenance.
  • Developed and implemented reporting, analytics, and Data visualization solutions with Power BI.
  • Working knowledge of Power BI (Power Pivot, Power View, Power BI Online, Power BI Desktop, Power BI Publisher) and DAX.
  • Design and Implement reporting solutions using Reporting Services, Power BI, or other data visualization tools.
  • Design and develop reporting data module for Marketing Analysis.
  • Creating Row Level Security with Power BI Desktop and integration with Power BI Service portal.
  • Experience in optimizing reports and setting up Power BI service, gateways, and scheduling data refresh.
  • Experience at creating, configuring, and maintaining system database.
  • A self-starter with ability to work independently with well-developed analytical skills.
  • Successfully co-ordinate with lead and completed the task as per Iteration/deliverables on time.
  • Collaborated in Software Development Life Cycle (SDLC) using different methodologies.

Overview

12
12
years of professional experience

Work History

Senior Power BI Developer

Ivy Comptech
06.2022 - Current
  • Developed interactive Power BI dashboards for tracking daily and weekly revenue, customer behavior, and betting across different betting products (e.g., sports betting, gaming machines) to identify trends and anomalies.
  • Connected Power BI to various data sources(SQL data base, excel), including point-of-sale systems, customer relationship management (CRM) tools, and external data feeds to provide a holistic view of operations.
  • Created Operational reports to visualize cash inflows and outflows to manage liquidity effectively.
  • Created Fraud detection and regulatory compliance reports to highlight unusual betting patterns and to comply with gambling regulations.
  • Created a dashboard that segmented customers based on betting behavior, helping the marketing team tailor campaigns effectively.
  • Created Event impact analysis reports during major events like world cups, grand nationals etc., of betting volumes and customer engagement metrics during event promotions.
  • Publishing to Power BI web services, Data gateway, Maintenance and Hand over.
  • Manage Access and Permissions in Power BI service and implementing Row level security(RLS) if needed.
  • Setting uo scheduled refresh to ensure that report is up to date as this is crucial for the betting industry, where real time data is vital for decision-making.
  • Collaborate with business partners to gather requirements on new Power BI projects and visualize the outcomes through reports.
  • Continuously gathering feedback from users and iterate on the report design and functionality.
  • Actively participated in client demos and document preparations


BI Developer

Infosys Ltd.
10.2016 - 06.2022
  • Involved in Requirement Gathering & Analysis, Data Modelling, Coding, Code review, Unit testing, Integration testing, Team management.
  • Developed Operational Reports, Revenue Reports, System Reports, visual reports, dashboards and KPI scorecards using Power BI and SSRS
  • Developed and maintained interactive Power BI dashboards to monitor branch performance and key financial metrics, resulting in improved decision-making processes.
  • Understood, identified, acquired, and analyzed data from multiple sources to streamline the delivery of information across the company platforms using ETL tools and Ms. SQL server.
  • Involved in designing the transformation logic from Operational Database (OLTP) to Data Warehouse (OLAP).
  • Demonstrated outstanding communication skills to gather business requirements from end-users and translate them into a meaningful visual product.
  • Effectively communicated and interacted with business and technical personnel to solve complex, data related business and technical problems.
  • Actively participate in work group/team activities as an enthusiastic, positive, and dependable team member.

Senior Process Analyst

Royal Bank of Scotland, RBS
10.2012 - 10.2016
  • Reconciling around 300 general ledger accounts daily which include major products of mortgages and ensuring that all transactions recorded in the general ledger match the underlying source documents and external statements.
  • Identifying unauthorized transactions and potential fraud by revealing discrepancies and ensuring that all the discrepancies are investigated promptly.
  • Generate internal reports using excel Application to provide analysis for weekly, monthly, quarterly, and annually. This created a one stop for all reporting needs and saved company time and resources that was prior spent on single report creation.
  • Experience with reconciliation software and tools to streamline processes and reduce errors.
  • Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
  • Experience in designing automated reports using UIPath and RPA. This has improved efficiency, accuracy and saved time and money for the business.
  • Ability to use MS. Power Point, and Excel pivot tables to analyze and present reports to staff and management.
  • Establish good working relationships with the development team and stakeholders to gather requirements/business rules and ensure they align with the client/ users

Education

B.E - Electronics And Communications Engineering

SCSVMV University
Kanchipuram, India
04.2012

Skills

Platform:

Advanced MS Excel, MS Words, MS PowerPoint, Ms Outlook

SQL Server Management Studio (SSMS)

SQL Server Integration Services (SSIS)

BI Tools: MS SQL Server, SSRS, Power BI, MS Office Suite, SharePoint, Power BI Service, DAX

Management :

JIRA, Confluence, Agile

Finance tools: T-Recs, Checkfree Frontier, World pay

Timeline

Senior Power BI Developer

Ivy Comptech
06.2022 - Current

BI Developer

Infosys Ltd.
10.2016 - 06.2022

Senior Process Analyst

Royal Bank of Scotland, RBS
10.2012 - 10.2016

B.E - Electronics And Communications Engineering

SCSVMV University

Similar Profiles

CREATE PROFILE
Abhinay Tallapaka