Data Analyst/ Tableau Developer Resume
New Brunswick, NJ
SUMMARY
- 7 years of IT experience in Business Analysis, System Analysis, Data analysis, Software Design, Development, Implementation and Maintenance of Business Intelligence and across Agriculture, Airline Services, Banking and Retail domains
- Passionate individual successful at undertaking complex assignments and delivering promising results
- Skilled in data analytics, business analysis, R programming, Python, ETL design, front end development and analytical reporting.
- Highly Proficient in Agile, Iterative, and Waterfall and Scaled Agile Framework (SAFe) software development life cycles.
- Proven expertise in functional, integration and regression testing for UI and back - end.
- Expert in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture.
- Expert in designing and developing analytical reports, dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey teh story inside teh data by integrating data from multiple sources and help users to identify critical KPIs and facilitate strategic planning in teh organization.
- Strong knowledge in SQL using SQL Server and Oracle databases.
- Developed Scripts using PySpark moduleto Build ETL pipelines between S3, Snowflake and to SQL Server.
- Proven Expertise in AWS Environment.
- Worked in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Pipeline Pilot.
- Proficient in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Spotfire, Alteryx, Pipeline Pilot, Informatica, MicroStrategyand Database technologies. Knowledge of data mapping/migration, Cleansing, Profiling and Data Governance.
- Expertise in using Alteryx data tool do data cleansing, data blending and create various standardized datasets to fit teh needs of reporting.
- Outstanding Data analysis skills including Data mapping from source to target database schemas,Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
- Excellent knowledge in designing and developing dashboards using TIBCO Spotfire by extracting teh data from multiple sources (Flat files, Excel, Access, SQL server, Oracle).
- Worked in Agile methodology environments and involved in scrum meetings.
- Involved in Performance Tuning and Deployment of TIBCO Applications.
- Good understanding of Tableau Desktop architecture for designing and developing dashboards.
- Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
- Performed data mapping, logical data modelling and querying to report teh progress in migration of jobs.
- Experienced on various applications usingPythonintegrated IDEs like Eclipse, PyCharm
- Developed GIT hooks for teh local repository, code commit and remote repository, code push functionality and worked on teh GIT-Hub.
- Created and monitored robust pipelines in production. Integrated Snowflakes and mounted s3 buckets to transfer teh data through data bricks.
- Possess strong knowledge of database management in writing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
- Adept in analyzing bugs, interacting wif team members in fixing errors and User Acceptance Testing (UAT)and assisted in Post - Production support.
- Highly motivated team player wif excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
TECHNICAL SKILLS
Analysis Tools: Tableau, TIBCO Spotfire,Power BI, MS SSRS, MS SSAS, MS Excel (VBA, VLOOKUP, Pivot tables)
Databases: SQL Server, MySQL, PL/SQL, Oracle, Redshift, Teradata, PostgreSQL, NoSQL
Data Integration (ETL) Tools: Alteryx, Pipeline Pilot,Informatica, Talend MS SQL Server Integrated Service (SSIS)
Project Management: SDLC - Waterfall & Agile methodologies, project life cycle, MS Project 2013, JIRA
Languages: SQL, Python, R-Script, C#, CSS, HTML, JavaScript, jQuery
Cloud Technologies: Snowflake, AWS S3, EC2 Redshift, Data bricks, Spark, Hadoop
Application Software: MS Office, Eclipse, MATLAB, Visual Studio, MS Excel advance, MS Access, MS Visio, Toad Oracle
Manual Testing: Requirement analysis, Test scenario design, Test case design, Test data management, Test Execution, Database testing, Regression testing and Defect tracking
PROFESSIONAL EXPERIENCE
Confidential, New Brunswick, NJ
Data Analyst/ Tableau Developer
Responsibilities:
- Analyzed requirements, developed and debugged applications using BI tools
- Interacted wif teh users and business analysts to assess teh requirements and performed impact analysis.
- Translated business and data requirements into Logical data models in support of Enterprise Data Models, OLAP, Operational Data Structures and Analytical systems.
- Analyzed teh requirements from teh end users and created a wireframe to structure teh migration process.
- Performed extract, transform, and load data from a variety of data sources into AWS environment and ultimately to tableau for reporting.
- Participate in regular grooming sessions to discuss teh stories and ensured that report development tasks are up to date in teh Release Backlog using agile tools like JIRA.
- Participated in Agile meetings and helped in Sprint planning.
- Migrated multiple historical reports and Created enhancements to teh new reports based on user requirement.
- Created Tableau dashboards quickly based on teh business requirements and increased project efficiency to understand teh data visibility.
- Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in tableau reports.
- Written complex custom SQL queries and custom calculations in Marketing operations data and created effective visualizations.
- Identified Data points, mappings from historical data and created new database using teh historical information.
- Reconstructed Historical reports from SSRS to Tableau.
- Identified teh Issues in current Query structure and implemented new changes by creating indexes in stored procedures to pull data efficiently which helped in Report performance.
- Analyzed current data sets wif manual process and automatedthem.
- Identified teh database structure and provided them wif enhanced SQL queries to increase teh performance of SQL.
- Built Tableau dashboards using actions to navigate from tab to tab wifin a dashboard and even from a dashboard to otherdashboards.
- Administered user, user groups, and scheduled instances for reports in Tableau also restrict teh sensitive reports to fewer users and applied row level securities to each group.
- Built standardized and more reliable data sources. dis made enhancements and maintenance much easier while fixing teh bugs or discrepancies between teh reports.
- Published reports/dashboards on Tableau server & embedded views in other web applications.
- Worked on administration tasks such as Setting permissions, managing ownerships and providing access to teh users andadding them to teh specific group.
- Scheduled frequency and time to refresh data for teh when sources are publishes or extracted to server.
- Performed database audits and created reports in tableau based on teh audit logs.
- Worked on Tableau dashboards optimization for better performance tuning.
- Performed post production support for Jira tickets.
Environment: Tableau 2020.1 (Desktop/Server), AWS Redshift, Oracle, SQL Workbench, Snowflake, PyCharm, Jira, Agile, GitHub, SSMS, IRIS, Microsoft Office Suite
Confidential, Raritan, NJ
Data Analyst/ Tableau Developer
Responsibilities:
- Led teh development of prescriptive data model to optimize operations and increase project efficiency
- Analyzed requirements, developed and debugged applications using BI tools
- Worked wif end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
- Designed, developed, tested, and maintained Tableau reports based on user requirements.
- Preparing reports, extracts and integration of existing data as needed to support analysis, visualizations, and statistical models.
- Performed in depth analysis on data and prepared ad-hoc reports in MS Excel and SQL scripts.
- Extensively worked in preparing strategical planning and implementation of successfully delivery projects wifin teh POD and supply chain teams.
- Extract, transform, and load data from a variety of data sources into staging datasets in redshift environment and ultimately into tableau for reporting.
- Used Alteryx and/or other data preparation tools to create better or more meaningful data sets for reporting purposes.
- Maintained and ran all teh Alteryx workflows on weekly/daily basis to keep all data sets up to date
- Automated Alteryx workflows and Tableau Dashboards to get updated wif teh data.
- Created AWS EC2 instances and used S3 for data storage.
- Created python scripts to extract teh data from various sources like AWS S3, Restful APIs.
- Integrated Python scripts to teh Snowflake databases and automated them for daily loads using CronTab in AWS environment.
- Worked on designing and creating tableau dashboards. Also, automated dashboards to help stakeholders in implementation of strategic planning in teh organization.
- Worked wif leadership management team for visualizing teh key customer metrics, driving better solution in consumer POD and supply chain.
- Utilized various Tableau functions like LOD, WINDOWS SUM, WINDOWS AVG, conditional functions (IF, Nested IF, CASE, etc.), RANK, Table calculations like Percentage difference, Percent of Total, Moving Average, YTD, YOY, etc. for various measures/calculated fields.
- Worked on view orientation, Sizing, layout, Color, Fonts, Tooltips, for building Interactive dashboards/reports.
- Extensively worked on Tableau dashboards optimization for better performance and monitoring. Specifically dealing wif huge volume of data sets in tableau.
- Developed Yearly trends, Dual-axis maps in a report to show teh medical claims based on multiple regions and countries.
- Developed a fully automated continuous integration system using Git, MySQL and custom tools developed inPython
- Automated refresh schedules of SQL using python scripts and decreased teh turnaround time of data retrieval.
- Published dashboards to teh tableau server and communicated wif teh end stakeholder for PMO Usage
- Developed GIT hooks for teh local repository, code commit and remote repository, code push functionality and worked on teh GIT-Hub.
- Maintained knowledge of relevant IT services/ application offerings and methods of support delivery to provide technically accurate solutions to users
- Created Change requests for enhancements using IRIS change management system.
- Provided post production/ production support to various projects and created tickets in IRIS and Jira.
Environment: Tableau 2018.3 (Desktop/Server), AWS Redshift, Alteryx, Talend, Oracle, SQL Workbench, Snowflake, Control - M, AWS, PyCharm, Jira, Agile, GitHub, SSMS, IRIS, Microsoft Office Suite
Confidential, Richmond, VA
Data Architect
Responsibilities:
- Worked in teh Confidential Risk Management team as a data architect.
- Analyzed requirements, developed and debugged applications using BI tools
- Worked in Agile methodology environments and involved in daily standup meetings to maintain efficiency in project.
- Interacted wif teh users and business analysts to assess teh requirements and performed impact analysis
- Involved in Data migration from traditional databases to Cloud.
- Analyzed scripts in Teradata and created new queries in Snowflake using SQL Workbench during project Migration.
- Wrote scripts in Python for pulling updated information about jobs from API and loaded it on Snowflake and used teh table in Tableau
- Used Data bricks in Day to day tasks to consume teh data from data lakes to s3.
- Created and monitored robust pipelines in production. Integrated Snowflakes and mounted s3 buckets to transfer teh data through data bricks.
- Created Dashboards in Tableau based on teh user requirement for AML.
- Created affinity analysis dashboard and Radical charts for better understanding data.
- Published reports to teh server and given authentications to teh users.
- Created a Git repository and added teh project to GitHub.
- Created ad-hoc SQL queries for customer reports, executive management reports.
- Extensively worked on Tableau dashboards optimization for better performance tuning.
Environment: Tableau Desktop 10.1, Oracle SQL Developer, SQL Workbench, Snowflake, Teradata, GitHub, AWS S3&Jira
Confidential, Chesterfield, MO
Data Analyst/ Reporting Analyst
Responsibilities:
- Led teh development of prescriptive data model to optimize operations and increase packaging efficiency
- Analyzed requirements, developed and debugged applications using BI tools
- Interacted wif teh users and business analysts to assess teh requirements and performed impact analysis
- Used agile software development wif Scrum methodology.
- Worked in coordination wif clients for feasibility study of teh project in Spotfire and wif DB Teams for designing teh database as per project requirement.
- Created Information Links for many databases for populating data into Visualization from underlying databases such as Sql Server and Oracle.
- Extracted data from AWS S3 using Python and used in pipeline pilot and created reports in Spotfire and Tableau.
- Built scalable pipelines, model deployments and reusable protocols using pipeline pilot to support daily operations
- Assisted report/visualization developers and statistical modelers in filtering, tagging, joining, parsing, and normalizing data sets for use in reports & analytical models.
- Extract, transform, and load data from a variety of data sources into staging datasets and ultimately into visualization tool.
- Designed and maintained Spotfire and Tableau visualization dashboards on daily basis to facilitate Field testing all over North America
- Experience wif Spotfire application performance monitoring, capacity planning, and tuning of teh Spotfire environment.
- Extensively used Spotfire and Tableau to create data visualizations enabling prescriptive operations and increasing data visibility.
- Worked on Data blending, Data preparation using Pipeline pilot for tableau consumption and publishing data sources to Tableau server.
- Preparing reports, extracts and integration of existing data as needed to support analysis, visualizations, and statistical models.
- Extensively worked on designing and creating teh dashboards. Also, automated Dashboards to help end users to identify teh KPIs and facilitate strategic planning in teh organization.
- Extensively worked on Tableau dashboards optimization for better performance tuning.
- Developed a fully automated continuous integration system using Git, MySQL and custom tools developed inPython.
- Created a Git repositories and added those projects to GitHub.
- Created POCs on Power BI and QlikView to measure teh techniques which can be useful in Confidential
- Automated refresh schedules of SQL using python scripts and decreased teh turnaround time of data retrieval.
- Created scripts in Python and R for calling APIs through Insomnia and Postman.
- Integrated projects in teh server and organized workshops on teh projects for better usage of teh capability built in teh dashboards.
- Provided production support to various tools and created tickets in Jira.
Environment: TIBCO Spotfire 7.x, Tableau 10.x (Desktop/Server), Pipeline Pilot, Alteryx,Oracle, SQL Server, MS SQL, AWS, Python, R-Script, Power BI, SharePoint, APIs, Insomnia, Postman, GitHub, Jira, MS Office Suite
Confidential, Ashburn, VA
Data Analyst/Tableau Developer
Responsibilities:
- Involved in full project lifecycle of SDLC and coordinated wif all project teams.
- Interacted wif Subject Matter Experts and End Users and gatheird business requirements.
- Analyzed requirements, developed and debugged applications using BI tools
- Acted as a Liaison between Business Intelligence and Business User groups to relay change requests.
- Performed extensive GAP analysis in teh project as their were numerous ‘As-Is’ and ‘To-Be’ conditions.
- Developed Logical data model using Erwin and created physical data models using forward engineering.
- Translated business and data requirements into Logical data models in support of Enterprise Data Models, OLAP, Operational Data Structures and Analytical systems.
- Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
- Developed dashboards wif interactive views, drill downs and published them to teh portal wif user level security.
- Developed various reports using Tableau features like Parameters, Filters, Sets, Groups, Actions, etc. to present users wif various scenarios of predictive analysis.
- Created and updated custom SQL scripts to serve as data sources for various reports and handled performance issues effectively.
- Created extracts and scheduled data refresh on Tableau Server for weekly and monthly increments based on teh new changes to ensure that teh views and dashboards were displaying teh changed data accurately.
- Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau. Also, involved in teh administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
- Involved in collection and cleaning of large amount of unstructured data using Excel and python.
- Identified teh factors involving teh performance of teh reports and coordinated in creation of indexes, statistics to improve teh query turnaround time efficiently.
- Worked on creation of users, groups, projects, workbooks and teh appropriate permission sets for Tableau server logons and security checks.
Environment: Tableau 10.x/9.x/8.x (Desktop/Server), Alteryx, Erwin, Oracle, SQL Server, Python, GitHub, SSIS, SSRS, MS Office Suite (Word, Excel, PowerPoint)
Confidential
SQL Data Analyst/Developer
Responsibilities:
- Created and/or strengthen systems for data collection, management, reporting and analysis. Advised teh agency on technology needs to maximize efficiency and support a culture of managing to data.
- Assisted in teh creation and documentation of teh business processes for data collection, entry, reporting, review and use of data to strengthen performance management.
- Analyzed requirements developed and debugged applications using BI tools and Implemented logical and physical data modeling.
- Developed PL/SQL stored procedures for teh end-user report requirements and Created crystal reports on teh stored procedures and exported teh Business Objects reports to WEBI, to be viewed by all users on teh intranet and extranet.
- Created many simple, complex and adhoc reports using Crystal reports as main data providers and having teh Powerful functionalities like @functions and formulae.
- Created SSIS packages to load data from Oracle to SQL Server using various transformations in SSIS.
- Worked on teh Reports module of teh project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
- Identified teh dimension, fact tables and designed teh data warehouse using star schema. SSAS storage and partitions and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.
- Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
- Migrated database from SQL server 2000 to SQL server 2005 using utilities me.e. exp/imp and attach/detach for SQL servers 2005 futures.
Environment: SQL Server, SSIS, SSRS, PL/ SQL, Crystal Reports, Web Intelligence,InfoView, MS Office