Home

Nikitha K - Tableau Developer

[email protected]

Location: Houston, Texas, USA

Relocation: Any

Visa: H1B

Nikitha K Tableau Developer +15178935038 [email protected] Houston, TX Any H1B ________________________________________ PROFESSIONAL SUMMARY As a Tableau Certified Professional, I bring a robust background in Data Analysis, with a strong emphasis on ETL (Extract, Transform, Load) processes, data mining techniques, and statistical analysis. I have a keen proficiency in SQL, Tableau, PowerBI, and Excel, honing these tools to efficiently manage large data sets, implement ETL pipelines, and provide meaningful data insights. My track record includes utilizing advanced data modeling and predictive analysis to extract relevant information and create impactful visualizations and reports. I also have substantial experience with data cleansing, ensuring data integrity in all ETL stages, from source extraction to final load in the data warehouse. My ability to interpret complex data structures and translate them into clear, actionable reports is a key strength, driving strategic decision-making and providing a comprehensive view of business operations. ________________________________________ SKILLS Data Analysis and Interpretation: Proficient in analyzing and interpreting complex datasets to inform strategic decision-making. Tableau and PowerBI Visualization: Experienced in creating dynamic, interactive dashboards and reports using Tableau and PowerBI. SQL Queries and Database Management: Expert in writing efficient SQL queries and managing databases for optimized data retrieval. Advanced Excel Proficiency: Skilled in utilizing Excel for advanced data manipulation and analysis, including pivot tables, vlookups, and complex formulas. ETL Processes: Proficient in designing and implementing ETL pipelines for data warehousing. Experienced in data extraction, transformation, and loading using various tools and languages. Data Cleansing: Skilled in performing data cleansing to ensure data integrity throughout the ETL process. Business Analysis: Requirements Elicitation, Strategic Planning, Business Process Mapping, Risk Management, Impact & Workflow Analysis, Defect Management, Test Planning. Reporting and Business Intelligence: Expert in generating insightful reports and leveraging business intelligence tools for enhanced business operations. Strong Communication Skills: Able to effectively communicate complex data insights to a variety of stakeholders. Attention to Detail: Detail-oriented approach to ensure data accuracy and consistency. Problem-Solving: Proficient in identifying and resolving data-related issues promptly and effectively. ________________________________________ TECHNICAL SKILLS DATA Tools Tableau, Power BI, Excel, SSRS, SSAS, Alteryx Databases MS SQL Server 2016/2014/2012/2008 R2/2008, Oracle, MySQL, Oracle, MS Access, SQL Server Management Studio Programming Javascript, Python Other Tools Jira, Confluence, Azure Dev-ops, MS Office Suite (Outlook, Word, Excel, PowerPoint), Microsoft 365, Postman, SOAP UI, ALM _______________________________________ CERTIFICATIONS Certified Tableau Desktop Specialist _______________________________________ PROFESSIONAL EXPERIENCE Data Analyst/ Tableau Developer April 2021 - Current CenterPoint Energy Houston, TX Responsibilities: Leveraged Tableau to develop, maintain, and manage advanced reporting, analytics, dashboards and other BI solutions. Performed and documented data analysis, data validation, and data mapping/design using Tableau. Reviewed and improved existing Tableau reports and dashboards to enhance their functionality and visual appeal. Developed interactive dashboards and reports in Tableau using calc down, parameterized functionality, and other advanced features. Developed storytelling dashboards in Tableau Desktop and published them on to the Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information. Conducted trainings and workshops to enhance the data visualization skills of the team, promoting a culture of data-driven decision making. Worked closely with stakeholders to identify business needs and translate them into technical requirements for BI solutions. Participated in gap analysis sessions, brainstorming sessions to acquire detail level business requirements from business users and different stakeholders. Involved in Requirement Scoping and analyzing high priority requirement for implementation. Created user stories, acceptance criteria based off of business requirements. Developed, shared, and updated technical documents throughout the project lifecycle in MS SharePoint site. Trained and assisted the end users in Training sessions and User Acceptance Testing (UAT). Used Tableau to automate repetitive tasks, improving the efficiency of data analysis and reporting processes. Creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis using Power BI desktop. Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts. Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI. Managed the data integration process with Tableau and PowerBI, ensuring data is correctly received, transformed, stored, and loaded in the BI tools. Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau. Experience in data blending with multiple data sources also using new features multi data source Troubleshot and resolved Tableau and PowerBI related issues, providing reliable and efficient solutions to users. Kept abreast of the latest updates and features and integrating them into existing workflows as appropriate. Environment: Tableau, Power BI Desktop, MS Excel, Power Point, MS Project MS SQL Server, Agile, JIRA, Confluence, Alteryx 11.0 & 11.3 Business Intelligence Analyst December 2019 March 2021 Factspan Analytics Atlanta, GA Responsibilities: Led the design and implementation of Tableau and PowerBI dashboards to monitor key performance indicators, significantly improving data accessibility and understanding across the organization. Conducted Joint Application Development (JAD) sessions with IT groups and identified the Key Changes and participated in Stakeholder Management to communicate effectively with them. Converted Business requirements into Functional Requirements and also captured nonfunctional requirement such as security, availability and scalability. Collaborated with cross-functional teams to gather in-depth requirements, effectively delivering comprehensive data analysis, visualization, and reporting solutions tailored to stakeholder needs. Participated in Product Backlog Grooming sessions with Product Owner, Subject Matter Experts (SMEs) and other extended business stakeholders in defining the business needs of the stakeholders. Managed large datasets and performed meticulous data cleansing, standardization, and transformation using SQL and advanced Excel functions, ensuring high levels of data accuracy and reliability. Designed and executed intricate SQL queries for comprehensive data analysis, contributing to the strategic decision-making process. Implemented SQL-based automation for routine data extraction, transformation, and loading (ETL) tasks, increasing efficiency and reducing manual errors. Leveraged SQL to create and maintain organized data structures, facilitating efficient data storage and accessibility for reporting. Collaborated with IT and database administrators to enhance SQL server performance, ensuring seamless report generation and execution. Identified and resolved SQL-related issues in reports, guaranteeing reliable and accurate reporting outputs. Conducted regular audits of SQL queries and reports to maintain high quality standards, proactively identifying and rectifying potential issues. Developed comprehensive SQL documentation to standardize reporting processes, ensuring consistency and ease of understanding among team members. Performed Functional Testing on different modules of the application and performed defect tracking and management using Jira. Pioneered the use of predictive and prescriptive analytics tools to forecast trends and model potential business scenarios, influencing strategic planning and business development efforts. Proficient in architecture with different RDBMS platforms like Oracle, SQL Server, and operating SQL Server suites like SSIS, SSRS and SSAS. Provided ongoing technical support and training to team members, fostering an environment of learning and continuous improvement. Regularly performed data audits and validation to identify data inconsistencies and inaccuracies, implementing corrective measures to maintain high data quality standards. Conducted root cause analysis on discrepancies identified in data reports, implementing corrective actions to prevent recurrence. Translated complex technical findings into an understandable narrative for non-technical stakeholders, facilitating data-driven decision-making throughout the organization. Collaborated with IT department to improve data structures and efficiency of data retrieval and storage processes. Environment: Tableau Desktop, Tableau Server, Power BI Desktop, MS Excel, Power Point, SQL server, Service now, Agile, Jira, Confluence, ETL Business Data Analyst July 2017 November 2019 Doche Cloud Technologies Hyderabad, India Responsibilities: Developed intricate SQL queries for data extraction and report generation. Implemented SQL-based automation for routine ETL tasks, increasing efficiency. Conducted regular audits of SQL queries to maintain high-quality standards. Involved in gathering Business Requirements, interacted with the Users, Design and Development teams, Project Manager and Subject Matter Experts (SMEs) to get a better understanding of the AS IS Processes. Interacted with business users and performed Gap Analysis of Client requirements Delivered training sessions to enhance team members' SQL skills. Created complex stored procedures, triggers, cursors, tables and views, and other SQL joins and statements for applications. Environment: MS Excel, Power Point, SQL server. ________________________________________ EDUCATION: Anna University Aug 2013 -June 2017 Bachelor's Degree in Electronics & Instrumentation Engineering Keywords: user interface business intelligence information technology microsoft Georgia Texas