Shiva Basina
Summary
Business Intelligence Specialist with 11+ years of experience in BI technologies including Tableau, Power BI Skilled in gathering business requirements, creating data-driven dashboards, and enabling informed decision-making. Strong experience in Agile methodologies. Known for translating business needs into effective BI solutions and leading teams in high-impact projects.
Overview
12
12
years of professional experience
Work History
Lead Tableau Developer
Synechron Technologies
03.2021 - Current
- Designed Tableau dashboards to deliver real-time insights that drove data-driven decision-making.
- Created and maintained multiple reports to show Revenue, Balance, Trade, Score Cards, Deals and Summary dashboards.
- Facilitated design sessions across organizational levels to gather requirements, ensuring solutions aligned with business needs.
- Built complex mappings, mapplets, taskflows, and workflows to support high-volume batch and near real-time data processing.
- Implemented data integration solutions using Informatica Cloud Data Integration (CDI) and Cloud Application Integration (CAI).
- Provided mentorship and coaching to the team, guiding them through the learning curve of analytics and visualizations.
- Collaborate with stake holders to gather business requirements and translate them into Tableau dashboards.
- Implement best practices and optimizing report performance.
- Added PPR extensions to dashboards to get downloaded by PPT, PDF, Excel with desired format.
- Created Dashboards for PPT & PDF mode to download directly for Presentations for stake holders.
- Designed and developed scalable ETL pipelines using Informatica Intelligent Cloud Services (IICS) to ingest, transform, and load data from multiple heterogeneous sources into enterprise data warehouses.
- Designed and developed multiple business analytical reports.
- Worked on created POC projects and generated Tableau data extracts and leveraged them to create complex storyboards.
- Lead cross-functional teams/workgroups to bridge gaps between business and technical teams.
- Worked on data validation in the migration project and created data dictionary documents, data mapping, data flow charts, and confluence pages for future training.
- Used APIs to extract data for reporting in Tableau.
- Build different visualizations and reports in Tableau using Snowflake Data.
- Develop and optimize product management processes and provide product management leadership and training.
- Extracting data from different sources connecting them and used the same to create dashboard using AWS.
- Leverage analytics capabilities, domain expertise, and technical expertise across teams to execute the full product development lifecycle.
- Build plans to solve those problems with other product managers, engineering managers, and business leaders.
- Recreated existing SQL server in Snowflake.
- Provide education and consultation to clients as well as internal colleagues and training of staff to operationalize the solution. Assist in the review of release notes and documentation and collaborate with Content Team as necessary for content development.
- Perform demonstrations of product features and workflow as needed. Maintain knowledge of industry trends in data display, visualization, advanced analytics, and reporting.
- Effectively used tabcmd for the maintenance of the server. Scheduled tasks, imported user list, restarted server and performed various other roles through tabcmd.
- Developed User Acceptance Testing (UAT) documentation for Tableau reports, enhancing report performance and user satisfaction.
- Analyzed existing reports for identifying common KPI metrics to create common metadata and self-service metadata.
- Responsible for scorecard reports for Bankers and other executive teams.
- Analyzed business requirements, performed data wrangling, data profiling, and Gap Analysis.
- Skilled at working independently and collaboratively in a team environment.
- Provided technical solutions to offshore and onshore team members.
- Secured Tableau server to protect the Tableau environment, security group and AWS Direct Connect.
- Analyze security logs, monitoring logs, firewall logs, intrusion prevention system logs, and network and correlate logs using numerous database query techniques and tools.
- Collaborated with Citi Bank in Capital Markets domain.
- Environment: Tableau Desktop 2019.4, 2020.1, Tableau Server 2019.4, 2020.1, Power BI Desktop, Oracle 18.0, JIRA, Excel, HRIS, MS Office, CSV, Windows 10.
Associate Process Manager
eClerx Services pvt
07.2017 - 03.2021
- Designed and implemented Tableau and Power BI dashboards for senior management.
- Oversaw server administration and report migrations.
- Bridged communication between business users and technical teams.
- Managed offshore teams and mentored junior developers.
- Led Power BI to Tableau migration project.
- Implemented error handling, logging, and monitoring mechanisms for robust ETL execution and faster issue resolution.
- Collaborated with business stakeholders and analysts to convert business requirements into effective technical ETL solutions.
- Set project priorities and work through team leaders to advance projects from development through implementation, including manpower/work plans, reporting, and quality standards.
- Educated customers on how to leverage BI technology to assist them with their transactions.
- Define and deploy product vision for Analytics by working closely with the nursing department and marketing team to oversee that product capabilities are accurately represented, and growth opportunities are identified.
- Develop and maintain BI reporting strategy and business by developing our business models, defining our product objectives, and managing our business.
- Proactively provide technical analysis expertise and direction in developing, maintaining, and enhancing health and Wellness data needs, such as key operational and clinical metrics.
- Manage technical projects ensuring that project plan target dates are met and implemented to enhance and maintain reports.
- Designed data structure and optimized data model by modifying loading scripts/custom SQL in QlikView and Tableau to tune report performance.
- Used API’s to extract data for reporting in Tableau.
- Proactively review SAS report metadata to understand trends and provide recommendations to business users for continuous improvement and transfer to tableau report visualization.
- Created Inpatient and Outpatient reports to analyze sales and revenue by a provider for management reporting and weekly/monthly Behavioral health team performance reports.
- Created interactive Commercial and Medicare Advantage, FEP Authorization trend reports.
- Lead cross-functional teams/workgroups to bridge gaps between business and technical teams.
- Conducting analyses to assess the budget impact of new drugs, assess adherence to policies and appropriateness of drug utilization, reimbursement by third-party payers, and other analyses to support cost-effective use of drugs.
- Participated in data migration project to Snowflake cloud platform.
- Validate the SAS dataset and migrate SAS data sets into the SQL server to use for tableau reports.
- Writing SQL queries for data validation by using join conditions. Created SQL Documentation.
- Worked on the QA environment to test other reports and suggested solutions for the performance.
- Used various ETL tools to extract data into Tableau Desktop and data wrangling using SSIS in data preparation phase.
- Supported data migration and modernization initiatives, including legacy to cloud (Snowflake) transitions.
- Work on data validation in the migration project and created documents like data dictionaries, data mapping, data flow charts, and confluence pages for future training.
- Worked in Tableau environment to create dashboards like weekly, monthly, and daily reports using tableau desktop & publish them to server.
- Created company tableau chart guide template for training purposes.
- Created user groups and projects on Tableau Server to streamline data access.
- Involve in the deployment of new dashboards to the Test and Production environment.
- Client: Credit Suisse, Switzerland | Domain: Banking
- Environment: Tableau Desktop 10.5, Tableau Server 10.5, EPIC, Microsoft SQL Server, Informatica, Oracle 12c, confluence, Excel, MS Office, CSV, JIRA, Power BI, QlikSense, QlikView, AWS, Windows 10.
BI Developer
Shura Technologies pvt
04.2014 - 07.2017
- Support business users in utilizing data analytics for operational improvements.
- Facilitated requirements gathering by collaborating with business stakeholders to ensure project alignment.
- Played a cross-functional role between the DreamWorks team and NBC universal studios team.
- Designed, developed, and maintained daily and monthly summary, team rendering benchmark reports.
- Created Movie Render Analysis reports for Boss Baby, How to Train Your Dragon 2, and Captain Underpants.
- Enhanced render team performance by developing and maintaining detailed render shot links reports.
- Developed SQL queries for Tableau dashboards to meet specific business analysis needs.
- Used Git and Jira for code submissions and review process.
- Created project documentation for future knowledge and provided 24/7-production support for Tableau users.
- Migrated Excel Reports into interactive Tableau Dashboard and Good Flexibility.
- Provided training to business users and gathered their feedback to improve the reports.
- Created SQL Documentation for Benchmark queries and implemented new methods for better performance.
- Writing SQL queries for data validation by using join conditions and involved to create Documentation for debugging reports for Tableau.
- Managed deployment of ETL jobs across environments (Dev, QA, Prod) using CI/CD best practices.
- Provided support to the offshore Tableau development team and administration team.
- Performed Analysis and Design of existing transaction sets and modification of these transaction sets to ensure HIPAA compliance.
- Developed the table documentation for Tableau Dashboards. Wrote SQL queries for custom reports.
- Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for the production Database and supporting it.
- Analyzed poorly performing SQL queries to improve application performance.
- Developed a database to store transaction data and a data warehouse for historical forecasts and real demand by vaccine and country.
- Executed the publishing of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers.
- Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, and combination charts in excel and tableau.
- Assisted users to publish and collaborate reports via a web browser & embed Tableau view in other web applications like SharePoint.
- Contributed to all phases of the project lifecycle (SDLC): planning, requirements gathering, design, development, testing, and implementation.
- Delivered training for users on interaction, filtering, sorting, and customization of views.
- Collaborated with Samsung in Singapore on retail projects.
Education
Btech - Computer Science Engineering
Jntu
Hyderabad04-2014
Skills
- Tableau
- Tableau Prep
- Power BI
- Business Intelligence
- SQL
- Data Warehousing
- Data Integration
- Healthcare Analytics
- Data Mining
- Python
- R
- SAS
- Salesforce
- MS SQL Server
- ORACLE
- DB2
- Shell Scripting
- Version Control
- Continuous Deployment
- Agile Methodologies
- IT Service Management
- JIRA
- MS Office
- Excel
- Microsoft Word
- PowerPoint
- Documentation Management
Certificate Link
https://cp.certmetrics.com/tableau/en/history/exams
Tableau Public
https://public.tableau.com/app/profile/shivaprasad6319/vizzes
Timeline
Lead Tableau Developer
Synechron Technologies
03.2021 - Current
Associate Process Manager
eClerx Services pvt
07.2017 - 03.2021
BI Developer
Shura Technologies pvt
04.2014 - 07.2017
Btech - Computer Science Engineering
Jntu