Sr. Data Analyst/ BI Developer

PROFESSIONAL SUMMARY:

Tableau:

7+ years of dedicated experience in designing and implementing Tableau solutions.

Specialized in data design, analysis, administration, development, integration, and maintenance of data warehouse, BI, ETL, and database platforms.

Extensive experience in Tableau Server, including installation, configuration, and maintenance.

Proficient in designing and developing Tableau dashboards, reports, and visualizations using Tableau Desktop.

Strong knowledge of Tableau best practices and data visualization principles.

Data Warehousing and Database Skills:

Solid understanding of data warehousing concepts.

Experience working with various databases and data sources.

Experience in the development and implementation of Database/Data Warehousing environments, BI Analytics, and Dashboards applications.

Expertise in Data Profiling, Extraction, Transformation, Loading, and Visualization using Tableau.

Analytical Problem-Solving:

Excellent problem-solving skills, capable of analyzing complex data sets and deriving actionable insights.

Strong communication and interpersonal skills for effective collaboration with cross-functional teams and stakeholders.

Other Expertise:

Proficient in designing, developing, documenting, and testing ETL jobs and mappings using DataStage.

Experience with different versions of DataStage, including the development of Enterprise Parallel jobs, Server jobs, and sequence jobs.

Worked across domains including insurance, healthcare, banking, and social networking.

Strong client relationship management skills, with a focus on problem-solving and issue resolution.

Committed to continual learning, staying updated with new tools and techniques in the field.

Proficient in data modeling, data migration (ETL using DataStage), shell scripting, and data reporting.

Experience in data extraction, analysis, cleansing, profiling, manipulation, distributed processing, and slowly changing dimensions techniques.

TECHNICAL SKILLS:

Reporting Tools

Tableau Desktop 2023.2, Tableau server, Tableau prep, Looker, Google Analytics, Power BI

Databases

Snowflake, SQL Server, Oracle 11/12C, (Oracle SQL Developer) DB2, Teradata, PostgreSQL, BigQuery, RedShift, DataBricks

Languages

Python(Pandas, NumPy, OOPS, Functional Programming), SQL, PL/SQL, R

ETL Tools

Alteryx, IBM Data Stage, Data Manager, CP4D

IDE & Utilities

Visual Studio, Jupyter Notebook

EXPERIENCE:

Client: AT&T Remote Aug 2022 – Present

Role: Tableau Developer

Responsibilities:

Requirement Gathering and Documentation:

oConducted comprehensive requirement gathering and generated Business Requirement Documents using legacy reporting systems.

Tableau Dashboard Development:

oDeveloped Tableau Dashboards and data sources, establishing subscriptions for monthly reports to end users.

oParticipated in data migration, testing, and updated Tableau reports during the transition from Teradata to Snowflakes.

Client Collaboration and Proof of Concepts (POC):

oCollaborated closely with clients to understand business needs, facilitating the creation of Proof of Concepts (POC) on Analytics.

Software Development Life Cycle (SDLC) Involvement:

oEngaged in the entire Software Development Life Cycle (SDLC) process, collaborating with ETL and DBA teams to design new schemas.

ETL Data Validation:

oValidated ETL data integrity between source and target data sources.

Validation Tools and Sprint Planning:

oUtilized DBeaver to validate all Tableau reports and cross-verify with legacy systems.

oEmployed JIRA for sprint planning, ensuring the timely delivery of tasks.

Performance Tuning and Tableau Admin Management:

oConducted performance tuning and implemented reports using best practices.

oManaged Tableau Admin activities, overseeing access, extracts, and schedules, utilizing features like data blending, filters, actions, and hierarchies.

Collaboration with Business Analysts:

oCollaborated with Business Analysts to create Technical Requirement documents and address limitations.

Service Now Utilization:

oUtilized Service Now for critical incident migrations/upgrades.

Complex Dashboard Development:

oDeveloped complex Dashboards and reports to meet business requirements.

User Support and Guidance:

oAssisted users in data validations and provided guidance on report development techniques.

AI-Enhanced Data Analysis:

oCreated multiple Data Sets, Data Modules, and Explorations using AI for data analysis and validations.

Data Source Management:

oEstablished Data source connections and Data servers as needed.

Environment:

Tableau 2022.4, Teradata, Snowflake, Oracle Database, JIRA, Slack, DBeaver, Dashboard, Exploration, Datasets, Trello.

Client: Nike Inc May 2020 – July 2022

Role: Tableau Developer

Responsibilities:

Project Management:

oIdentify and assess project risks, implementing effective mitigation plans.

oMonitor project performance and produce regular status updates on a weekly, monthly, and quarterly basis.

Resource Coordination:

oCoordinate internal resources and third-party vendors for the execution of multiple projects.

User Acceptance Testing:

oManage business requirements and facilitate user acceptance testing.

Requirement Gathering and Documentation:

oConducted requirement gathering and created comprehensive Business Requirement Documents using legacy reporting systems.

Tableau Expertise:

oWorked on Tableau Dashboards and data sources, setting up subscriptions for monthly reports.

oCreated compelling data visualizations in Tableau illustrating trends, patterns, and insights related to footwear materials.

Data Analysis and Optimization:

oConducted detailed analysis of footwear materials, including cost, availability, and quality using Tableau dashboards for strategic decision-making.

oUtilized Tableau to analyze and optimize the supply chain for footwear materials, identifying cost-saving and efficiency improvement opportunities.

AI-Enhanced Data Analysis:

oCreated multiple Data Sets, Data Modules, and Explorations using AI for data analysis and validations.

oEstablished Data source connections and Data servers as needed.

Security and Dashboards:

oCreated complex Dashboards based on user requests and assisted in setting up security measures.

oParticipated in status meetings with users and higher management to discuss task progress weekly.

Alteryx App Development:

oDeveloped a user-friendly Alteryx app for custom analyses with personalized filters.

oImplemented dynamic filtering functionality for user-specific criteria and parameters.

End-to-End Data Processing Workflow:

oDesigned and implemented a comprehensive data processing workflow within the Alteryx app for accurate and efficient analysis.

oCreated an intuitive user interface to enhance user experience and engagement.

Data Validation and Quality Checks:

oImplemented robust data validation and quality checks to ensure accuracy and reliability of results.

Result Tracking Mechanisms:

oImplemented result tracking mechanisms, allowing users to revisit and track historical analyses for trend analysis or comparison purposes.

Report Migration and Enhancement:

oMigrated existing reports from SharePoint/Excel to Tableau Server in batches.

oSuggested alternate representations of existing reports to provide in-depth insights.

Collaboration and Communication:

oInteracted with business analysts to gather ad hoc business requirements and designed functional and technical requirements documentation.

Tableau Server Management:

oDeveloped reports using Tableau and published them to Tableau Server.

oPublished Dashboards onto Tableau Server for user accessibility.

Environment:

Tableau Desktop, Tableau Prep, SharePoint, Teradata, Snowflake, Tableau Servers, Microsoft Azure SQL Data Warehouse, Alteryx, DataBricks.

Client: USP Jan 2018 – April 2020

Role: Tableau Developer/Admin

Responsibilities:

Tableau Dashboard Development:

oCreated rich dashboards in Tableau, incorporating user stories to deliver actionable insights.

oDeveloped Tableau dashboards for visualizing pharmacological data, ensuring adherence to regulatory standards.

oCrafted interactive visualizations to effectively communicate complex pharmaceutical information to stakeholders.

Data Cleaning and Preparation:

oConducted data cleaning and preparation to ensure accuracy and reliability in Tableau analyses.

Cross-Functional Collaboration:

oCollaborated with cross-functional teams to identify key performance indicators and reporting requirements.

o Provided solution approaches and implemented security groups on Tableau Server.

User Requirement Analysis:

oWorked with business analysts and users to comprehend requirements, layout, and the application's look and feel.

oCreated prompts, customized calculations, conditions, and filters for various analytical reports and dashboards.

Tableau Server Utilization:

oUtilized Tableau Server as a front-end BI tool and designed and developed workbooks, dashboards, global filter pages, and complex parameters-based calculations with Oracle, DB2, Big Query, and Microsoft SQL as back-end databases.

Drug Efficacy Monitoring:

o Designed an interactive Tableau dashboard to monitor drug efficacy trends over time.

o Provided stakeholders with real-time insights, contributing to informed decision-making in drug development.

Scrum Framework Management:

oScheduled and facilitated all aspects of the Scrum framework, including sprint planning sessions, backlog grooming, daily scrums, product demos, and sprint retrospectives.

oMaintained the Scrum team’s capacity plan, Scrum board, sprint backlog, velocity charts, and burn-down charts.

Business Operations Oversight:

o Analyzed business and technical scope, requirements, user stories, and/or use cases for Functional, Technical, and Non-Functional requirements.

o Acted as a liaison between developers and project stakeholders, fostering quality communication between engineering disciplines.

Strategic Planning and Resource Allocation:

oDeveloped and executed plans to achieve company objectives, collaborating with other managers to set operational goals.

o Allocated resources, including personnel, equipment, and financial resources, to meet operational needs.

Operational Efficiency and Compliance:

oMonitored and analyzed operational performance data, identifying areas for improvement and implementing changes to enhance efficiency and effectiveness.

oEnsured compliance with applicable laws, regulations, and industry standards.

Budget Management:

oManaged budgets and financial resources, ensuring expenses were within budgetary constraints.

Continuous Process Improvement:

oContinuously analyzed and improved business processes to enhance efficiency and identify opportunities for cost savings or other improvements.

Environment:

Tableau Desktop, Tableau Prep, Snowflake, Tableau Servers; Databases: Oracle, MySQL, SQL Server, PostgreSQL; ETL Tools: Informatica, Alteryx; Agile/Scrum Tools: JIRA.

Contact this candidate