Home

Sidharth Kalyanapu - Lead Power BI Developer / Tableau Developer

[email protected]

Location: Plano, Texas, USA

Relocation: Yes

Visa: H1B

Name: SIDHARTHA Contact: 281-769-1263 Email: [email protected] LinkedIn: https://www.linkedin.com/in/kalyan-sid-360842282/ Lead BI / Tableau Developer Summary: Having around 13 years of IT experience and 8+ years experience in Business Analysis, System Analysis, Data analysis, software design, development, testing and maintenance of BI/Data Warehousing environment, Extensive experience in working with Tableau, Power BI, Alteryx, and Informatica. Experience in creating solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau and Power BI Experienced in PMI Project Management Principles, facilitating issues, resolving conflicts, developing/ documenting policies and procedures. Excellent Experience in all Software Development Life Cycle (SDLC) phases including requirement analysis, design, development, implementation, testing and support. Experience in requirement Analysis, Architecture, Design and development of Enterprise applications. Exceptional ability to adapt to latest technologies, perseverant, innovative, creative, energetic, organized and self-starter. Experienced in developing Power BI reports and dashboards from multiple data sources using data blending. Strong leadership skills with proven ability to increase productivity manage multiple projects and achieve organizational goals. Mentor and develop new leaders/managers within the organization. Experience in creating solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau and Power BI. Designed Tableau dashboards using Hierarchies, filters, calculated fields, Sets, Groups, and Parameters. Implemented Tableau security at the Data (Data security) and object (Roles and Permissions) level. In-depth knowledge on Tableau Desktop, Tableau Reader, Tableau Public and Tableau Server of various versions. Experience including Analysis, Modeling, design and development of Tableau reports and Dashboards for analytics for reporting applications. The primary objective is to provide valuable insights and reporting capabilities to support informed decision-making and drive business growth. The Lead BI professional leads a team of analysts, developers, and engineers, setting the overall strategy, managing projects, and ensuring the successful delivery of BI initiatives. They collaborate closely with stakeholders to understand their reporting needs, analyze complex business data, design and develop data models and solutions, and create reports, dashboards, and visualizations. Additionally, they stay updated with the latest BI trends and technologies, identify opportunities for process improvements, and foster a culture of collaboration and innovation within the team. Effective communication, leadership, and technical skills are crucial for this role's success in driving the organization's BI strategy and delivering actionable insights to stakeholders. Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality. Created incremental refreshes for data sources on Tableau server. Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations. Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau. Created dashboards using Tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights. Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users. Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information. Technical Skills: Relational Databases/BI Tools Tableau , Power BI, SAP Business Objects, Microstrategy, Snowflake, SQL Server, Oracle 9i & 10g, Oracle Analytics Cloud Database Tools SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, ODBC,SQL OLEDB, DBCC, ADO, Business, Intelligence Studio, Crystal Reports. Languages C, C++, UNIX Shell Scripts, Python, T-SQL. Operating Systems Windows 2012, Windows 2008 R2 server, Win ME/NT/XP, UNIX/Linix Web Servers IIS 5.0/6.0, Apache, Tomcat. ETL Tableau Prep, SSIS, DTS, IICS, Talend, Alterxy Other Tools Microsoft Visual Studio 2003/2005, Service Center, MS Visio, NHibernate, Windows System Monitor. Education : Master's degree (Master of computer Applications) from "Chhatrapati Shahu Ji Maharaj University" in the year 2008 Certifications: Tableau Certified Data Analyst Power BI Certified Data Analyst IIBA Standard Trained as Business Analyst Experience: Centene, St Louis, MO Mar 2023 - Till Date Lead BI Developer Responsibilities: Responsible to develop Tableau Reports and Dashboards for Enterprise level and share them with Executive teams. Interacting with stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery. Involved in development of Tableau visualizations which includes preparing dashboards using various reporting objects such as facts, attributes, transformations, filters, prompts, calculated fields, parameters, groups, sets and hierarchies. Designing and development of dashboards and reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter/Box Plots, Geographic Visualizations, Pie/Bubble/Waterfall Charts, Heat Maps, Funnel Charts, and Tree Maps. Developed and published reports and dashboards using Power BI and written effective DAX formulasand expressionsCreated Paginated reports using Power Bi Report Builder for both On Prem and Cloud Data Sources. Responsible for creating reports using Tableau desktop and publishing reports to Tableau server. Configured different data sources using Tableau Desktop. Created best visualizations reports as per the business requirements using Tableau desktop professional edition. Blended data using multiple data sources (primary and secondary). Enabled Tableau Actions to drill down from Dashboard to worksheet. Extensive experience on creating trend reports including forecast and trend lines. Configured incremental data refresh for the data sources. Prepared BI Interactive Dashboards using calculations, parameters in Tableau and Power BI. Troubleshoot and support reports in Power BI workspaces whenever there are issues in production. Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports. Involved in generating reports from excel database for Tableau Dashboard. Designed and developed Tableau visualizations which include preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies. Developed different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Bubbles, Histograms, Bullets, Heat maps and Highlight tables. Having knowledge on Oracle Analytics Cloud to prepare a couple of reports for a POC. Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance. Environment: Windows 10, React, Angular, Tableau Desktop, Tableau Server, Tambo, Alteryx, Oracle 12c/11gR2, Crystal Reports, SQL Developer, MS-SQL Server, SSIS, SSRS, MS-Access and JavaScript, Python. Global Partner, Boston, MA Nov 2019 - Mar 2023 Sr. Tableau / Power BI Developer Responsibilities: Gathering business requirements from various users of different Departments. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. Effectively used data blending feature in Tableau. Administered user, user groups, and scheduled instances for reports in Tableau. Connecting Snowflake to get the data to build reports Working with Snowflake team to create business logics inside the snowflake team and to create views or SP s as per the business. Created Power BI reports by using Joins in multiple tables from multiples database using complex SQL queries. Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements. Experience in custom visuals and groups creation in Power BI. Experience in scheduling refresh of Power BI reports, hourly and on-demand. Apply the Business rules on the data coming from multiple operating companies. Maintain the business rules in a table for visibility to all required processes to develop Power BI reports & effective Executed and tested required queries and reports before publishing. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau. Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications. Expertise creating Shell scripting as per the requirement. Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business s needs. Provided support for Tableau developed objects and understand tool administration. Created a Backup Script which takes Tableau Server Backup & Logs daily basis and moved to NAS location. Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server. Environment: Tableau Desktop 2021.x, Alteryx, SQL developer, SQL Server 2008, Oracle 12, Right Angel, Flat files Citi Bank, India Sep 2015 Oct 2019 Tableau Developer Responsibilities: Involving the requirement gathering workshop and responsible to create BRD documents. Making use of dynamic connection to extract data from several servers for the creation of Dashboards in Tableau Created YOY, QOQ, MOM, YTD, and MTD using Table calculations Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. Effectively used data blending feature in Tableau. Defined best practices for Tableau report development. Administered user, user groups, and scheduled instances for reports in Tableau. Hands on expertise on change request or migrating the dashboards from Dev to QA and QA to Prod. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau. Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications. Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business s needs. Extensive working with the SAS team to connect the data. Provided support for Tableau developed objects and understand tool administration. Environment: Tableau Desktop 10, Oracle 12 and Flat files Ericson, India Sep 2009 Aug 2015 SAP Security consultant/ Business Intelligence Developer Responsibilities: Develop, support, maintain, and test, Developer Suit (Form, Report), SQL/PL-SQL, Program Design, create and maintain data model and data. Create Tableau software (BI), dashboards, data analysis, visualization, report, Develop, Maintain, Test using Oracle SQL, PL-SQL including Program Unit According to Business Analyst and Function Requirements. Tableau development lifecycle from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment. Design, create and extend application layer to manage the CMS data repository and ETL (Extract, Transform, and Load) feeds from multiple sources. Design and develop and support Performance and Capacity Application Dashboard using APEX. Design, develop and support complex performance and capacity charts and reports using Tableau Tool. Expertise with data architecture, data interoperability and data analytics using Tableau and SQLs Assist Seagate DBAs and Application Developers with Oracle SQL troubleshooting, performance tuning and enhancements Environment: Micro Strategy Server, and Desktop 7,8 and 9, SQL Server 2008/2012, Oracle 11g, Keywords: cprogramm cplusplus quality analyst business intelligence information technology microsoft procedural language Massachusetts Missouri