Siva Jyothi V Raparla
Virginia, USA
Mobile: +1-571-***-**** ad7obr@r.postjobfree.com
Summary:
Extensive 19 years of experience in IBM which includes 7+ years of working experience in Business Intelligence reporting tools (Tableau reporting and dashboards).
Proficient in design and development and modeling of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries.
Mastered in using Filters, sorts, groups and sets, reference lines, Bands and Boxes in different kinds of charts.
In depth knowledge in Tableau advance analysis features like Actions, Calculations, Forecasting, Parameters and Trend Lines.
Mastered the ability to design and deploy rich Graphic Visualizations Parameters using Tableau.
Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownership, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
Practical understanding of the Data Modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
Adopted to agile methodology.
Working in the agile model projects. Using jira to update the user stories prepared according to the scrum time lines.
Configured SSO SAML with sales force to tableau.
Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design
Designing, testing, and developing analytical models and solutions. Creating dynamic and interactive data visualizations, dashboards, and reports. Publishing within a variety of visualization platforms, including: Domo, Tableau, SAP Business Objects, etc.
Experience in Installation, configuration, patching and administration of Tableau across the environments.
Experience in designing and building the Universe (business view of the database), and updating the existing Universes, developing canned/ad-hoc reports, scheduling the processes/reports and administering the BO activities.
Expertise in Designing and Implementing of Security Model for BOE. Successful in implementing the three-level security in Business Objects (User Level, Object Level and Data Level Security) and maintained 8000 users by creating multiple Custom Access Levels and adding the users to appropriate Business Objects groups.
Experience in tracking the KYI and facilitate required training programs.
Experience in making the accounts/clients to be Audit Ready.
Screening and Scheduling candidate interviews. Planning and executing large recruitment drive over weekends and across locations.
Planning on sourcing for candidates with niche skills
Collating, maintaining trackers and updating all the relevant databases.
Designed reports to find the Top Defects which hit the process.
Had good experience in publishing Power BI Desktop reports to the Power BI service. Deployed Power BI Pro for Business users to view reports on the service and local report server. Had good Experience in publishing and sharing BI objects in Power BI Workspace, designed and maintained Power BI dashboard in Power BI App.
Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.
Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.
Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
Demonstrated expertise in designing and building Power BI reports, including developing data models, creating measures using DAX, and creating visualizations that provide actionable insights for business stakeholders.
Experience in tracking the KYI and facilitate required training programs.
Experience in making the accounts/clients to be Audit Ready.
Technical Skills:
Business Intelligence: Tableau, Power BI
Reporting Tools: Tableau Desktop, Power BI, MS Access, MS Excel, Crystal Reports,
Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Access, Teams, Skype, slack,
Reporting Packages: Power BI Desktop/Service, MS Office
Data Visualization Tools: Power BI, Tableau
Certifications: Agile Explorer, Six Sigma White Belt, ITIL trained.
Professional Experience:
IBM India Pvt Ltd. Apr 2005– May 2024
Business Information Management Specialist -Tableau (2019-2024)
Project: IBM Internal Project and NBS
Responsibilities:
Experience in providing Business Intelligence and support for cross-functional strategic and operational projects.
Design the prototype of the dashboard and getting requirement signed off from the client.
Documentation for the dashboard.
Design the dashboard wireframe.
Finalize the view/format for the current dashboard. Describe the data model based on the requirements.
Writing Custom SQL queries for the required dashboard format.
Implementing the tableau LOD and calculated fields in the dashboards.
Using trend lines and fore casting techniques.
Scheduling reports and subscribing user to the dashboards.
Work directly with functional analysts and business users in understanding the information needs of the business and involving in developing new data warehouse/BI functionalities or tools to meet these requirements.
Design, develop, test and implement operational reports and executive level dashboards.
Maintain production reporting systems to ensure reliable performance and scalability
Different views on application data is shown in a single dashboard by using Blending techniques from multiple data sources.
Used multiple dates in a single date parameter to use it globally.
Used collapsible menu to accumulate the multiple filters to give the flexibility for the user to choose.
Used the container techniques to overcome the hide and seek functionality.
Design, develop, test and implement operational reports and executive level dashboards.
Maintain production reporting systems to ensure reliable performance and scalability
Utilized data blending activities for Tableau functionalities.
Designed initial data model to aid team in data collection to be used for Tableau visuals for sprint.
Different views on application data is shown in a single dashboard by using Blending techniques from multiple data sources.
Created a few POC sample dashboards using DOMO Visualization tool.
Design Dashboards using Filters, Parameters and Action Filters
Used Trend Lines, Parameters, Aggregate Functions, Filters.
Work directly with functional analysts and business users in understanding the information needs of the business and involving in developing new data warehouse/BI functionalities or tools to meet these requirements.
Design, develop, test and implement operational reports and executive level dashboards.
Maintain production reporting systems to ensure reliable performance and scalability
Educates internal and external clients on appropriate utilization of business intelligence product suite.
Created various views in Power BI like Tree maps, Heat Maps, Scatter plots, Slicer, Text Boxes, Geographic maps, Line chart and Pie charts.
Connect Tableau to various data sources using data blending techniques such as R Studio. Created dashboards using Tableau for easy tracking of the KPI and publish them on Tableau server using Tableau Public.
Interpreted and analyzed data via descriptive and predictive modeling tools such as Tableau to help the management in decision making.
Leverage geospatial mapping features.Ingesting geospatial data and exploring the geospatial tools in Tableau Desktop. Exploring various business scenarios and use cases for geospatial mapping. Customizing maps and expanding on simple visuals using internal and external tools.
Apply advanced calculations to key business use cases.
Integrate predictive analytics assets.
Creating rich dashboards using Tableau Dashboard and applying actionable insights.
Implementing user level security to restrict the data by group level and user level.
Publishing dashboards to tableau server and managing the security for users.
Demonstrated expertise in designing and building Power BI reports, including developing data models, creating measures using DAX, and creating visualizations that provide actionable insights for business stakeholders.
Proficient in designing and developing data models and DAX expressions in Power BI, optimizing performance, and creating efficient data flows for large datasets.
Expert in extracting and migrating data from diverse data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server using Import Export Wizard, DTS, SSIS, BCP & Bulk Insert utilities.
Demonstrated understanding of the principles of data warehousing, including data modeling and multi-dimensional modeling using Fact Tables, Dimension Tables, and star schema modeling.
Experience on publishing Power BI reports on dashboards in Power BI server and Power BI Mobile App.
Experienced in designing, developing, and deploying different types of reports using SSRS, including Tabular, Matrix, Chart, Drill-down, List, Ad-hoc, Parameterized, and Cascading reports.
Experience migrating reports from Crystal Enterprise to SSRS.
Experience in creating row-level security, troubleshoot data access, scheduling data refresh, and manage workspaces in Power BI.
Successfully designed and developed Power BI datasets, incorporating data from diverse sources, such as databases, APIs, and cloud platforms, to deliver comprehensive and insightful reports.
Implemented partitioning and aggregations in Power BI datasets, significantly reducing query response times and enhancing end-user experience with large datasets.
Actively engaged in Power BI Governance, enforcing data policies, and promoting best practices to ensure data integrity and consistency across the organization.
Developed and maintained Power BI documentation, including data dictionaries, data lineage, and system documentation, ensuring knowledge sharing and compliance with data governance standards.
Used recently introduced Power BI to create self-service BI capabilities and use tabular models. Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
Maintain accurate data spreadsheets for reporting and analysis.
Conduct analyses and provide reports as required from Sales, Operations, and Finance.
Experienced in designing, developing, and deploying different types of reports using SSRS, including Tabular, Matrix, Chart, Drill-down, List, Ad-hoc, Parameterized, and Cascading reports.
Experienced in designing, developing, and deploying different types of reports using SSRS, including Tabular, Matrix, Chart, Drill-down, List, Ad-hoc, Parameterized, and Cascading reports.
Experience migrating reports from Crystal Enterprise to SSRS.
Experience in creating row-level security, troubleshoot data access, scheduling data refresh, and manage workspaces in Power BI.
Successfully designed and developed Power BI datasets, incorporating data from diverse sources, such as databases, APIs, and cloud platforms, to deliver comprehensive and insightful reports.
Implemented partitioning and aggregations in Power BI datasets, significantly reducing query response times and enhancing end-user experience with large datasets.
Managed Power BI workspaces and datasets, overseeing data source connections, refreshing schedules, and maintaining dataset metadata for accurate and up-to-date reporting.
Resource Deployment Manager – Graduate Hires program Management (2011-2019)
Handling screening and Scheduling candidate interviews. Planning and executing large recruitment drive over weekends and across locations.
Planning on sourcing for candidates with niche skills.
Fulfilling client’s requirements on time.
Interacting with Consulting Agencies for large scale sourcing.
Collating, maintaining trackers and updating all the relevant databases.
Sourcing resumes through consultants, screening and conducting initial interviews, scheduling interviews with Technical Engineers.
Co-ordinated with colleges for the Campus interviews.
Co-ordinated with different vendors for the contractor hiring. Involve in the complete process of hiring Graduates Hires.
Supporting management decision making with qualitative analysis and bringing insights.
Work with Delivery Project Executives and other areas to investigate discrepancies or rectify incomplete data/information.
Plans & Controls Manager – AT&T (2009-2011)
Operations planning and monitoring in terms of overall headcount, training.
Responsible to make sure there is no deviation from a background check or joining / Exit formalities for the team.
Work on the forecast for quarter and tracking and analysis of variance including non-labor expenses.
Involved in the analysis of infrastructure requirements for the tower, collaborates with PO team.
Analysis of billing and staffing requirements of tower and the claims data on weekly basis.
Responsible to publish the bi-weekly Capacity drill down reports, after analysis of any gaps that are found.
Analysis of Metrics for the Capacity Module Reporting.
Analysis of the Tower Metrics to the IBM US Management.
Analyses the scorecard provided by PO team and work on the areas of improvement.
Billing, Process. Right communication of status & Represent Tower in Org. requirements.
Support New Business - Migration, Transition, cost optimization, Modeling, Get Right skills for Business- Staffing, Skill Req.& training plans & execution, SME Dev.
Cost Optimization & GP: Graduate hire intake and alignment, ARC, RRC and Resource Mgmt. (Forecasting, In/Out) – analysis, approvals, Average Band, Operational Efficiency.
Quality Analyst (2008-2009)
Involved in project of Improvement of Customer Satisfaction.
Monitoring calls and giving relevant feedback to the respective agents.
Concentrating on the bottom performers in the team. Conduct refresher trainings.
Conduct Calibration sessions with the Operations and Agents.
Designed reports to find the Top Defects which hit the process
Analysis on different areas on the performance of the team on a weekly basis.
Part of Projects run to improve the CSAT of the process (completed)
Was part of a critic’s process and implemented all the actions from Quality. Project moved to one of
the best performers team.
Sr. Technical Remote Specialist and Advisor Analyst (2005-2008)
Senior Technical Analyst for Client Help desk. Handling of all the Issues related to Computer, Software and Hardware.
Management of Sage reports for scheduling to keep a check on unscheduled percentage of the team.
Active Participation in Meetings with Manager and to monitor Weekly Status of the process.
Submitting the Billing Reports of the process and the project details to the client on a Monthly basis.
Tracking the Dashboard and Updating the team about the Daily metrics to meet the SLA.
Collating CSAT data and Exhaustive D-SAT analysis for Training Need Identification.
Trained Peers on Applications. Focal point for New- hires for process related Queries.
Monitoring of the CMS tool to reduce the Abandon rate and increase the STA (Speed to Answer).
Making of Shift and Break Schedules for the entire team.
Scheduling the shifts for the complete Process and coordinating with the Boulder Team. Tracking the Attendance of the team to maintain the Schedule Adherence.
Concentrating on the bottom performers in the team and improving their Scores. Conduct up trainings.
Updating team reports and other information for Client Meetings
Have concentrated on the scores like AHT and other call flow standards.
SPECEIAL ACHIVEMENTS
IBM -GBS Service Excellence Award (SEA)-2021
Manager's Choice Award -2021
Manager's Choice Cash Award – 2020 (July & Sep) program for the practice " Driving all the Centre
initiatives.”
Manager's Choice Award - 2020 program for the practice " New Process Implementation".
Manager's Choice Award - 2019 program for the practice "Show Personal Interest" from 2 different managers.
Manager's Choice Award - 2017 program for the practice "Show Personal Interest" from 3 different managers.
Manager's Choice Award - 2016 program for the practice "Show Personal Interest" from 2 different managers.
GBS Service Excellence Award (SEA) program for the practice “Put the Client First”.
EDUCATIONAL QUALIFICATION
MBA (Human Resource & Finance) - Annamalai University
Graduate in Math & Sciences - Nagarjuna University