SUMMARY

• Around 6+ years of experience as Data Analyst, ETL, transforming data into Analytics and visuals to make an informed decision.
• Hands - on experience on Tableau 2021.4/2020.4/2019.1/2018. x and 10.x Tableau Prep Mastered the ability to design and deploy rich Graphic visualizations using Tableau and python.
• Skilled in using Pandas, NumPy, Matplotlib, Seaborn, and Python for performing exploratory and predictive data analysis.
• Involved in Full Life Cycle Development of Reporting Projects, including Requirements gathering, Analysis, Design, Development, Testing, and Production rollover.
• Extensive knowledge in Dimensional Data modeling, Star Schema, Snow-Flake Schema, Normalization, and Physical and Logical modeling.
• Extensive experience in working with Tableau Desktop, Tableau Server, and Tableau online in various versions of Tableau as a Developer and Admin.
• Exceptional experience in dealing with various databases like Azure SQL Data, MS SQL Server 16, PostgreSQL 14, MS Access 2016, and MYSQL.
• Strong understanding and experience of data warehousing platforms, reporting automation, and data visualization.
• Expertise in Agile Scrum Methodology to implement project life cycles of reports design and development created calculated fields using Built-in functions.
• Used and created Data Blending, Groups, combine fields, calculated fields, and Context filters to analyze data from different perspectives to satisfy the business need.
• Strong understanding of advanced Tableau features including Calculated fields, parameters, table calculations, row-level security, joins, data blending, and dashboard actions.
• Expertise in designing and developing efficient dashboards using Tableau (Desktop/Server) using data from multiple sources like Oracle, SQL Server, Teradata, DB2, and Flat Files.
• Developed reports using features like Filters, Sorts, Sets, and Reference lines in different kinds of charts to help power users in creating and modifying worksheets and data visualizations.
• Developed dashboards using both Extracts and Live Data Connections published Workbooks by creating user filters for security so intended users can view them.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management knowledge on Data warehouse models viz., Star Schema and Snowflakes and RDBMS concepts.
• An intelligent and responsible report developer, fast learner, with good technical abilities and skills developed by a strong work ethic and self-learning.
• Possess excellent communication skills along with dedication, and commitment to work.

TECHNICAL SKILLS

Programming Languages: SQL, Python, PySpark.

Big Data Technologies: Databricks, AWS, S3 AWS EMR, Jupiter Notebook, Bamboo, Bitbucket

BI Reporting Tools: Tableau, Power BI

Databases: PostgreSQL, MySQL, MS SQL Server, Athena, Oracle

PROFESSIONAL EXPERIENCE

Confidential, DE

Data Analyst

Responsibilities:

• Worked with large data sets, automate data extraction, built monitoring/reporting dashboards and high-value, automated Business Intelligence solutions (data warehousing and visualization)
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets using databricks for call activity data, and social media data from various vendors like Facebook, YouTube, linked in, etc.
• Prepared SQL Queries to validate the data in both source and target databases.
• Perform data profiling on the source data and present analyst documents and solutions to fix the issue.
• Developed sales dashboard to build weekly sales trends, generating dual-axis bar chart, Pie chart, and Bubble chart with multiple measures and data blending in case of merging different sources for sales performance dash.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Published and scheduled BI reports and dashboards.
• Perform analysis to solve business problems and drive better decisions.
• Developed CI/CD pipeline for dev/test and production pipeline for Databricks using Bitbucket repo.
• Integrated Claims and clinical data using common data elements and created and presented dashboards to provide analytical insights into data to the client.
• Very good knowledge of Project management, Scrum, data analysis, and data integration.
• Designed & developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Accountable for the overall solution and release planning of the capabilities through multiple projects under a program.
• Forecast the technical risks, and dependencies and work with PMO to mitigate/resolve them the issues.
• Work very closely with development/testing teams to ensure proper implementation.

Technologies: Databricks, AWS EMR, S3, Airflow, Tableau, Athena, Apache SPARK

Confidential, PA

Data Analyst

Responsibilities:

• Actively involved in understanding requirement documents.
• Strong experience in creating dashboards, and KPIs to identify the issues on the drug and its journey from manufacture details all the ways to the issues reported using Trackwise data.
• Created Data ingestion pipeline with PySpark code to Ingest ERP, Trackwise data using Databricks into AWS S3.
• Designed and developed various weekly and Monthly reports showing detailed information that could be used to send information to a diverse group of users, clients, and managers.
• Interacting with the business team/stakeholder to understand the new requirements, translate the requirement into BRD, and work with developers to explain the BRD and QC the results in the test environment.
• Designed and developed various weekly and Monthly reports showing detailed information that could be used to send information to a diverse group of users, clients, and managers.
• Used Tableau to extract data from external sources and modify data to a certain format as required for consumption in the dashboards.
• Tested API call using POSTMAN tool to make sure data integration between VEEVA CRM, and AWS API Call is working.
• Resolved Defects, presented the Defect Status reports, and reported observed design inconsistencies.
• Queried RDBMSOracle with SQL,PL/SQLfor data integrity.
• Analyzing Schema and worked on Data mart with dimension and fact tables.

Technologies: Informatica10.4, Tableau, Oracle, Databricks, AWS S3, GlobalScape, Tidal

Confidential, West Chester, PA

Data Analyst

Responsibilities:

• Responsible to develop sales reports based on the requirement documents for Calls, Territory alignment, and Call targets.
• Visually verified the data and graphs in BI tools to make sure they meet expectations.
• Create and executed the query in SQL server and compared the results with the reports.
• Log the bugs in an excel sheet and coordinated with a developer to rectify the bug.
• Created different Action filters, Parameters, and calculated fields for the dashboards.
• Hands-on development in creating and modifying worksheets and data visualizations dashboards.
• Developed ETL routine to Integrate customer, Territory, Territory alignment, and Call target into Salesforce.com.
• Developed dashboards in Tableau for Sales History summarized global sales and Territory level sales which help businesses identify better and weaker territories.

Technologies: Salesforce.com, SQL server, Informatica, Tableau, MS, Erwin, and Windows Server