Home

NEHA raghukula - Power BI and Tableau

[email protected]

Location: Irving, Texas, USA

Relocation: yes

Visa: GC

Senior Data Analyst Power BI and Tableau Over 8 years of extensive IT Experience as a Sr. Tableau Reporting Developer, Power BI, SAP WEB Intelligence, Looker Developer & Admin, Data Visualization Engineer (QA), Alteryx operator and Tableau Server Administrator, Business System Analyst, in IT Security, Mass Media, Video Entertainment, Health and Life Insurance, Banking, SCM, Financial and Retail. PROFESSIONAL SUMMARY Extensive experience across various Tableau versions, excelling in data analysis, statistical analysis, and predictive analysis using Excel, SSRS, and Tableau. Proficient in SSRS, Power BI, and Alteryx, with a focus on advanced DAX and Power Query for sophisticated data modeling. Expertise in dimensional data modeling, SDLC methodologies (Agile, Waterfall), and the development of enterprise-level data marts and warehouses using SSIS, SSRS, and SSAS. Deep understanding of TSQL, machine learning, mathematical modeling, and operations research. Mastery in SQL, NumPy, Pandas, Scikit-learn for data analysis, model development, and working with relational databases. Hands-on experience in Azure Data Lake Analytics for analyzing structured and non-structured data. Comprehensive skills in BI projects from analysis to deployment, utilizing SSIS, Informatica, Oracle ERP, and Siebel CRM. Proficient in creating solution-driven views and dashboards in Power BI, Tableau, and Big Query. Leadership in BI administration, user management, and report scheduling. Extensive work with OBIEE Administration Tool and Presentation Services. Experienced in BI Publisher reports generation and leading BI projects and teams. Versatile skills in BI development, ETL design, and development using SSIS. Adept in BI administration, ensuring optimal performance of Tableau dashboards and reports. Proven expertise in creating various visualizations and reports for top-level management, emphasizing efficient data cleansing and processing. Enthusiastic and project-oriented team player with excellent communication skills. Ability to manage multiple assignments, troubleshoot, and optimize ETL and reporting analysis. Proactive approach to workload management, with a keen eye for identifying opportunities for additional contribution. EDUCATION Bachelor of Engineering in Computer Science from Osmania University, India. TECHNICAL SKILLS OLAP/Reporting Tools: SSRS, SSAS, MDX, Tableau, Power BI Relational Databases: SQL Server database 2014/2012/2008 R2/2005, Oracle 11g, SQL Server Azure, MS Access SQL Server Tools: Microsoft Visual Studio 2010/2013/2015, SQL server management studio ETL Tools: Informatica, SSIS, Alteryx Frontend Tools: Microsoft Project, Microsoft Office Document Management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum, Google Sheets Other Tools: MS Office 2003/2007/2010 and 2013, Power pivot, Power Builder, GIT, CI-CD, Jupyter Notebook. Programming languages: C, SQL, PL/SQL, T-SQL, JAVA, Batch scripting, R, Python Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables, SAS, SSIS, and Splunk Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Serve. PROFESSIONAL EXPERIENCE Comcast, Philadelphia, PA March 2022 Present Principal BI Engineer Engineered ETL processes for the central Datawarehouse team using SSIS, T-SQL, and stored procedures. Played a key role in developing Analytics and Scorecards in Tableau to enhance processes, identify data issues, and conduct root cause analysis. Automated monthly business reports through SSIS and Tableau. Established permissions and groups for projects in SQL Server DB. Designed and implemented SSIS packages for moving data from diverse sources to destination flat files and databases. Created dynamic and customizable data visualization models in Tableau, integrating multiple data sources such as text files, MS Excel, SQL Server, Presto, and Hive. Developed a Star Schema in Big Query and monitored Big Query, Data Proc, and Cloud Data Flow jobs through Stack driver for all workflows. Implemented complex calculations using Power BI DAX for dashboards. Formulated data cleansing techniques using Power BI DAX. Generated BI Publisher reports in various templates like RTF, XLS, PDF. Implemented Bursting to send personalized emails using BI Publisher. Created Tableau Data Extracts (.TDE) and Server Published connections to optimize dashboard performance. Customized refresh schedules on Server Published Connections for reflecting the latest data on dashboards. Integrated various data sources using Tableau Joins to create visualizations. Developed custom admin views using the Tableau Postgres repository by collaborating with the server. Utilized Parameters/parameter actions and calculated variables to dynamically pivot transactions table based on stratification factors. Produced reports using Tableau, SSIS, TSQL, and OBIEE. Contributed to the conversion of multiple Tableau workbooks to point to Snowflake DB as part of the cloud migration project. Developed Custom Facts and Dimensions, constructing OBIEE reports to support APS Development teams in accessing issues/ticket data. Constructed multiple Tableau reports with data sourced from Snowflake and Oracle DB. Implemented an Ad hoc system in OBIEE for ITRC data. Engineered a custom Tableau report displaying Infrastructure counts for different APS Organizations and integrated it into OBIEE dashboards. Developed SSIS packages and Stored Procedures for loading data into the Datawarehouse. Environment: Tableau (Desktop/Server), Power BI, SSIS, T-SQL, SQL Server, Big Query, Cloud Data Flow, Power BI DAX, BI Publisher, Snowflake, OBIEE. BlackRock Financial Management Inc, San Francisco, CA. Mar 20 Feb 22 Senior BI Developer/Analyst Implemented both out-of-the-box and custom-built Oracle BI applications, including Procurement & Spend Analytics, Project Analytics, and HR Analytics. Migrated legacy Excel reports and OBIEE reports to Tableau. Created various charts (Bar, Donut charts, Heatmaps) using Tableau Desktop and published them to the server. Collaborated with Business Groups to identify, analyze, and document Business Requirements. Gathered requirements for GAP Analysis and translated them into technical design documents. Designed and developed Custom Mappings, Workflows, and registered them in DAC. Worked extensively with Oracle EBS tables, OLTP flat files, and integrated and loaded data into the Data Warehouse (OLAP) system. Integrated OBIEE with EBS using EBS responsibilities and security profiles. Implemented Operating Unit-based data-level security by leveraging the EBS security model. Implemented incremental logic for Stage load mappings and insert/update logic for all custom Fact mappings. Implemented Multiuser Development Environment (MUDE) using Oracle BI Administration Tool. Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector, and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite. Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor. Troubleshot data issues in out-of-the-box reports. Trained end-users in using the OBIEE reports and Dashboards. Environment: Tableau, OBIEE, Oracle BI Administration Tool, Informatica, OLAP, EBS, SQL, DAC, Snowflake. Client: Conduent, Raleigh, NC Dec 19 Jan 20 Role: Data Visualization Engineer (Tableau/ Power BI) Comprehended application requirements and functionality from specifications. Formulated, tested, and sustained Tableau functional reports in accordance with user specifications. Collaborated with business users, ETL developers, project managers, and QA team members. Constructed Tableau data visualizations, utilizing various chart types and graphical representations. Applied ER Modeling, Dimensional Modeling (including Star Schema and Snowflake Schema), and OLAP tools. Demonstrated advanced proficiency in Tableau calculations, handling intricate calculations with large datasets. Ensured compliance with Tableau best practices during the final gateway check before PROD deployment. Evaluated and improved existing report procedures, enhancing effectiveness and efficiency. Developed desktop and mobile dashboards to boost sales growth in AMER, EMEA, and APAC regions. Utilized advanced Tableau features, including Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations. Published and shared reports using Tableau Server, fostering collaboration with business users. Crafted impactful Tableau visualizations, incorporating calculations, parameters, calculated fields, groups, sets, and hierarchies for insightful dashboards. Managed operations and support for the Big Data Analytics platform, Splunk, and Tableau visualizations. Demonstrated expertise in Power BI modeling, data storytelling, and understanding decision-making processes with data. Acted as the subject matter expert for MS Power BI. Environment: Tableau (Desktop/ Server), BOBJ, Looker (Lookml Development/Desktop/ Admin, Server), Hadoop, HANA Client: US Bank |Minneapolis, MN Dec 18 Aug 19 Role: Data Analyst- Tableau/Power BI Developer Engaged in consulting with clients and internal stakeholders to collect requirements and plan milestones across research, development, and implementation phases of the project lifecycle. Designed prototypes of dashboards using both Tableau and Power BI, providing users with plug-and-play functionality. Developed dynamic dashboards illustrating the company's annual performance using various graphs. Created custom tables, views, and aggregations for reports in the Power BI data layer environment. Participated in requirements gathering, analysis, solution design, development oversight, change management, and deployment facilitation. Extracted data from diverse sources, applied complex business logic to normalize raw network data, enabling effective anomaly detection by BI teams. Assessed changes going to production, fine-tuned Tableau server processes, and deployed Tableau workbooks to production. Developed MicroStrategy Dynamic Dashboards in Flash Mode using several controls and extensively worked on widgets. Deployed Tableau workbooks to production and participated in all cadence meetings related to releases. Collaborated with Tableau Elite support to resolve any server or desktop-related issues within Anthem. Wrote T-SQL queries (DDL and DML), stored procedures, and used them to build packages, handling slowly changing dimensions for data history maintenance. Developed solution-driven views and dashboards in Power BI, utilizing various chart types such as Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, and Scatter Plots. Indexed processed data, designed dashboards, and generated alerts in Splunk for support teams to utilize and act upon. Developed and published reports and dashboards using Power BI, employing effective DAX formulas and expressions. Utilized Power Query in Power BI for data model pivoting and un-pivoting, data cleansing, and massaging. Used the query editor in Power BI to perform operations like fetching data from different files. Created reports using SSRS, Excel services, and Power BI, deploying them on SharePoint Server as per business requirements. Developed Power BI reports using Tabular SSAS models as source data in Power BI desktop and published reports to service. Led the Go-Live process, ensuring that once production data is tested positively with no issues, the project and its dashboards are set to go live for the intended audience. Imported custom visualizations and employed various data visualizations with Power BI. Environment: Tableau (Desktop/Server), Power BI, SSRS, Hadoop, SQL, Oracle, Facets, Informatica, Agile, Jira, Snow, SSMS, Toad. Client: Bank of NY Melon, Philadelphia, PA (Offshore from India) Jan 16 Nov 18 Role: Tableau Developer / Dashboard Reporting Analyst Engaged with business stakeholders to gather and comprehend requirements. Translated business needs into system requirements by communicating on both non-technical and technical levels with the business and System Analyst, respectively. Conducted walkthrough sessions with user groups to confirm comprehensive requirement capture and obtained sign-off on requirement documents. Identified key facts and dimensions essential for supporting business requirements and developed logical dimensional models. Facilitated and participated in JAD sessions with users, modelers, and developers to resolve issues. Assessed source data quality and documented source-to-target mapping, defining rules and transformations for various SSIS ETL packages. Created Data Definitions and contributed to maintaining the Metadata repository. Developed Tableau worksheets, involving Schema Import and business logic implementation through customization. Built, published, and customized interactive reports and dashboards, scheduling reports using Tableau Server. Implemented Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel. Worked on motion chart, Bubble chart, Drill down analysis using Tableau Desktop. Designed customized reports using various chart types in Excel and SSRS. Created stored procedures, views, and custom SQL queries to import data from SQL server to Tableau/SSRS. Tested reports, uploaded Tableau dashboards to the server, and provided production support for Tableau users. Demonstrated ability to work efficiently under tight deadlines with a focus on detail. Provided hands-on development assistance to users in creating and modifying worksheets and data visualization dashboards. Defined and created procedures for installing Tableau Desktop in silent mode and established best practices for Tableau report development. Environment: Tableau (Desktop/Server), SSIS, SQL Server, Excel, SSRS. Ahalya Bench Sales Recruiter Vdrive IT Solutions Inc. | 800 E Campbell Road, Suite # 157 | Richardson, TX 75081 Office: +1 (469)-988-5899 [email protected] Keywords: cprogramm continuous integration continuous deployment quality analyst business intelligence database active directory rlang information technology golang microsoft procedural language California Minnesota New York North Carolina Pennsylvania Texas