Venkata Meesala
Sr. Business Intelligence Analyst/Lead
Hire this person
Send a job offer directly to this candidate
About
Over 20 years of experience in Analysis, Design, Development and Maintenance of Business Intelligence applications. Over 20 years of experience in Development and Administration of Business Intelligence Data Visualization tools like Tableau, Power BI, QlikView and SAP Business Objects. Over 18 years of experience in providing SAP Business Objects Reporting Solutions to Financial, Healthcare, Retail, Telecom and Manufacturing Domains. 13+ years of experience in design and development of Data Visualizations/Dashboards using Tableau and Power BI. 5+ years of experience in creating Reports and Data extracts from Salesforce.
Strong
Expertise in migrating and configuring Business Intelligence Reporting tools (Tableau, Power BI and SAP Business Objects) from On Premises to Microsoft Azure (Hybrid) platform including Firewalls and Load Balancer. Expert in Trouble shooting various Report and Dashboard issues occurred during development and migration. Strong experience in creating multi-source enabled Data sources for Dashboard development.
Work closely with Database and ETL teams in preparing the Logical & Physical data models and ETL. Strong experience in working with various business units in requirement gathering and documentation of Business Requirements, Functional Requirements and Use Cases.
Strong
Experience in prioritizing Customer requirements and creating the appropriate technical specifications and develop Proof of Concepts.
Strong
Experience in all phases of the Project life cycle and conduct UAT (User Acceptance Testing) Sessions and Train End users in various Business Intelligence Tools. Strong ability in translating business requirements into technical solutions. Coordinate with Cross Functional Teams to ensure all the Development process is aligned.
Conduct
Performance reviews and provide feedback to Management.
Experience working in Agile, Waterfall, DevOps and Kanban Environments. Mentor and Train Application Developers in Dashboard development and Issue Resolution.
Prepare End
User documentation and create User stories.
Experience
Sr. Business Intelligence Analyst/Lead - United States Automobile Association (USAA) - San Antonio, TX
(2022-10 - 2026-05)
As a Business Intelligence Lead, my responsibilities included
- Work closely with Business units in identifying requirements for Dashboard development and Application Improvements
- Document Business Requirements and Technical Specifications to define User Acceptance criteria
- Assisted in BI tool evaluation including the development of proof-of-concept and pilot solutions
- Develop & Deploy Data Visualizations for various Business Units within USAA using Power BI Desktop and Tableau Desktop
- Work with Data Engineers to develop Data Sources such as Snowflake for Tableau and Power BI models
- Performed data mapping, created data models, and worked closely with Informatica ETL Developers to ensure proper ETL of data from sources including Snowflake
- Developed complex measures, calculated columns to support business Requirements and KPIs using advanced DAX (M Language) and LOD expressions
- Work on Publishing and Scheduling Power BI Dashboards and Tableau Data sources
- Developed Power BI Dashboards connecting to Lakehouse and Data warehouse Data flows in Microsoft Fabric
- Worked on Ad-hoc SQL Query creation and Data mapping of various Tableau Data Sources and Power BI models both on-prem and hosted in Azure cloud
- Set up User access and implement Role Level security (RLS) for Tableau and Power BI Dashboards
- Manage Power BI Service components including workspaces, datasets, data gateways, refresh schedules, and capacity utilization using Microsoft Fabric
- Configure and support data gateways for on‑premises and hybrid data sources In Power BI
- Work on Consulting and Ad-hoc Data extract Requests
- Troubleshoot issues related to reports, datasets, refresh errors, and user access
- Mentor Team members and Train End Users in using Business Intelligence applications
Business Intelligence Technical Lead - Citi Bank - Irving, TX
(2021-09 - 2022-09)
As a Business Intelligence Technical Lead, my responsibilities included
- Work with Executive management and Data Quality teams in converting existing QlikView Dashboards to Power BI
- Reviewed and documented existing code in QlikView and implemented the same logic in defining data models for Power BI Datasets
- Identify KPIs/Metrics from Business Units and Developed Custom Data Visualizations using Power BI
- Created interactive features such as drill-throughs, bookmarks, custom visuals, and parameterized reports in Power BI Desktop and scorecards to meet customer requirements
- Created custom DAX expressions in Power BI Dashboard development and Performance Improvements
- Performed administrative tasks like Creating Users and assigning them security
- Manage Power BI Service components including workspaces, datasets, data gateways, refresh schedules, and capacity utilization
- Worked on Ad-hoc SQL Query creation and Data mapping of various Power BI datasets and Power BI models
- Work closely with Business Users (Analysts) in resolving Issues with Power BI Dashboards
- Mentor Team members and Train End Users in using Power BI applications
Business Intelligence Architect - Charter Communications - St. Louis, MO
(2021-01 - 2021-07)
As a Business Intelligence Architect, my responsibilities included
- Work closely with Executive management and Business Stake holders in defining the requirements for Data mapping and Reporting
- Create Data models for various Business modules like Capital Reporting, Invoice Management, Purchase Orders and Accounting
- Develop HANA Calculated/STANDARD Views for Reporting using Aggregates and STAR Joins
- Develop custom Dashboards and Reports for various Business Units using SAP Business Objects Enterprise 4.3
- Setup the Security model for End Users to access Business Objects content based on the project requirements using CMC (Central Management console)
- Performed administrative tasks like Creating Users and assigning them security, Maintaining BO servers and migrating Universes and Reports from DEV to TEST. PROD Environments
- Troubleshooting Business objects environmental issues
- Setup Business Objects security for accessing applications
- Monitor Regular Health checks with Scrum master and updated stakeholders on regular progress
- Developed Universes using Information Design Tool
- Developed Data Cubes and Complex Reports and Dashboards using IBM Cognos
- Coordinated with Teams across to ensure all the Dev needs are aligned
- Recreated existing Lumira Dashboards into Tableau Data Visualizations
- Design, develop, and test Tableau scripts to import data from source systems and test Tableau dashboards and Scorecards to meet customer requirements
- Working in a Rapid and Agile Development environment with frequent deliveries
- Participation in Daily Scrum Stand Up, Planning Activities, Retrospective, Product Backlog Grooming and Product demo calls for the User Stories assigned to Product Owners
- Involvement in the Release Management and Change Management Process for the User Stories to get deployed in the Production Environment
- Used JIRA tool for Creating and Updating User Story tasks on daily timely basis
Sr. Business Intelligence Developer / Lead - American Cancer Society - Atlanta, GA
(2016-06 - 2020-10)
- Participate in work-stream planning process including inception, technical design, development, testing, delivery, training, and adoption of BI solutions that emphasize speed to market results
- Assist in BI tool evaluation including the development of proof-of-concept and pilot solutions
- Assess Business requirements and making recommendations for how to most effectively visualize information from both development and consultative perspectives
- Developed Interactive Data visualizations using Power BI Desktop and published them to Power BI Service
- Setup User access and implemented Row Level Security for Business Users in Power BI Service
- Perform Business Objects Product Installation and configuration of Server and Client components Load Balancing and Performance
- Setup the Security model for End Users to access Business Objects content based on the project requirements using CMC (Central Management console)
- Performed administrative tasks like Creating Users and assigning them security, Maintaining BO servers and migrating Universes and Reports from DEV to TEST. PROD Environments
- Troubleshooting Business objects environmental issues
- Developed Data visualizations using Tableau Desktop and published them to Tableau Server
- Setup Row Level Security in Tableau
- Developed Data cubes and Dashboards using IBM Cognos
- Work with various Business units in identifying the requirements for universe design and report development
- Developed Standard and Adhoc Reports using Web Intelligence
- Work with Team Lead and Functional teams to design implement WEBI folder structure and Security
- Installed and configured Server sizing and Load balancing for BOBJ applications on Azure Cloud platform
- Create reports for various Marketing campaigns using Salesforce
- Develop Universes using UDT and IDT (Information Design Tool)
- Migrate universes and reports between environments
- Troubleshoot data issues in Salesforce, Teradata and Siebel
- Train Business users in report development and Dashboards using Salesforce and Tableau
- Monitor Performance of Business Objects servers
- Monitor Land desk tickets on a daily basis and help resolving data issues with a quick turn around
- Implemented Single Sign On (SSO) to BI Launchpad and Salesforce applications
- Define and Implement development standards for Universe design, Report development and BI Dashboards
- Coordinated with Teams across to ensure all the Dev needs are aligned
- Conducted Performance reviews and provided feedback
- Work in a Rapid and Agile Development environment with frequent deliveries
- Participation in Daily Scrum Stand Up, Planning Activities, Retrospective, Product Backlog Grooming and Product demo calls for the User Stories assigned to Product Owners
- Involvement in the Release Management and Change Management Process for the User Stories to get deployed in the Production Environment
- Used JIRA tool for Creating and Updating User Story tasks on a daily timely basis
Business Intelligence Analyst/Technical Lead - Blue Cross Blue Shield of NC
(2015-02 - 2016-05)
- Architect, design and develop Deployment strategies
- Create Proof of Concepts and turning them into real time solutions
- Define and Implement development standards for Universe design, Report development and BI Dashboards
- Work with Management team in planning and leading the migration of Business Objects 3.3 environment to BI 4.1
- Perform Product Installation and configuration of BI 4.1 Server and Client components
- Work with Business Units in identifying the Universes and Reports for migration to BI 4.1
- Analyze the existing reports to determine the Migration strategy & Timelines
- Analyze the business requirements and create Data Visualizations using Tableau 8.0
- Publish Tableau Dashboards to Tableau Server and setup Refresh Schedules of the Data Sources
- Promote Tableau Dashboards from Dev to QA and Production using Tableau Content Migration Tool
- Responsible for design, development and maintenance of Business Objects Universes, Webi and Crystal Reports
- Setup the Security model for accessing the Business Objects content based on the project requirements using CMC (Central Management console)
- Responsible for troubleshooting issues occurred during content migration and Report
- Train End users in creating the Adhoc reports and Data Visualizations
- Worked in an Agile Development environment with frequent deliveries
- Participation in Daily Scrum Stand Up, Planning Activities, Retrospective, Product Backlog Grooming and Product demo calls for the User Stories assigned to Product Owners
- Involvement in the Release Management and Change Management Process for the User Stories to get deployed in the Production Environment
Business Objects Technical Analyst - eBay Enterprise Inc. - Melville, NY
(2013-11 - 2014-12)
SAP Business Objects Administrator - Data Scan Technologies - Alpharetta, GA
(2012-11 - 2013-09)
SAP Business Objects Analyst - Research in Motion Corp - Alpharetta, GA
(2009-09 - 2012-09)
Education
Bachelor's Degree - Engineering - Osmania University