Data Analyst Resume
Mclean, VA
SUMMARY
- Over 7 years professional experience in Tableau 8.x/9.x/10.x/2018.x/2019.x, Tableau Server, Tableau reader and MS SQL Server, Oracle PL/SQL
- Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage
- Hands on experience on deploying and scheduling reports to generate all daily, weekly, monthly and quarterly reports including status. Established best practices for enterprise Tableau environment and application intake and development processes.
- Developed and modified drill - down, drill-through, linked reports, subreport, charts, Formulas, parameterized reports, Navigation reports and dynamic reports using Tableau.
- Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
- Proficient in creating solution driven dashboards by developing different chart types including Dual Axis, Crosstab, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs and Histograms, Funnel Charts, Box Plots, Waterfall Charts, and other making use of actions, other local and global filters according to the end user requirement
- Strong skill set in implementing forecasting, Data Blending, Customized queries, Hyperlink Objects, Color-coded tabs etc. in Tableau desktop
- Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately
- Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
- Experience working in Agile & System Development Life Cycle (SDLC)
- Extensive knowledge in various reporting objects like attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups and parameters
- Strong advanced tableau developer skills such as nested calculation, table calculations, parameters, geographic mapping, data blending, and extract optimization
- Thorough understanding of Kimball/Inman strategies, KPI, Data mining structures
- Expert in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
- Well versed in implementing Data blending, data visualization Replace references, customized queries and advanced visualizations in Tableau
- Experienced on Python 3.x with packages including NumPy, Pandas, Matplotlib, Pyspark and Jupyter notebook.
- Outstanding analytical and problem-solving skills communicating effectively to accomplish all project deliverables in a fast-paced environment
TECHNICAL SKILLS
RDBMS: Amazon Redshift, MS SQL Server 2016/2014/2012/2008 R2/2008/2005, MySQL, Oracle 11g/10g
Reporting: Tableau 8.x/9.x/10.X/2018.x/2019.x, Tableau Server 10.x/2018.x, Power BI, SQL Server Reporting Services data visualization (SSRS), Excel 2016/2013/2007
Languages: T-SQL, PL/SQL, Python 3.x (Pandas, Numpy, Seaborn, Matplotlib, Pyspark, sqlalchemy)
ETL tools: Informatica, SSIS, Tableau Prep
Development Platforms: Visual Studio 2015/2010/2008 , SharePoint 2013/2010
Project Management: JIRA, Slack, Microsoft Project, SharePoint
PROFESSIONAL EXPERIENCE
Confidential, Mclean, VA
Data Analyst
Responsibilities:
- Worked on the development of Tableau Dashboard reports for Key Performance Indicators of 10 metrics to convey information for 13 divisions
- Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently
- Read business user requirements, analyzed data, and designed or adjusted reporting solutions in Tableau Desktop based on the requirements and discussions
- Experienced in the maintenance and scheduling of Tableau Data extracts using Tableau server to save up to 40% of working time
- Developed and executed custom SQL query to retrieve data from the amazon redshift database
- Executed and optimized python code to load monthly data into database
- Automated refresh process using python script using Pandas and sqlalchemy to load monthly data and ensured data quality, consistency, integrity
- Built Pivot tables using MS Excel when requested to display analysis and data validation result with visual
- Integrated and Managed metadata to improved knowledge about the enterprise’s data, allowing the operations and decisions to function with accurate data when needed
- Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
- Trained and educated business users to interactive with tableau dashboards by face to face metrics review meeting
- Managed and delivered on ad-hoc reporting requests from users and managers
- Monitored and tracked data loading into data marts as daily routine of data validation
Environment: Tableau Desktop 2018.1.6/2019.2 , Tableau Reader 2018.3, Tableau Server 2018.1.6, SQL work bench, Amazon Redshift, Python 3, Jupyter notebook, JIRA, Slack, MS Excel, Zoom, Agile/SCRUM
Confidential, Danbury, CT
Tableau Developer
Responsibilities:
- Helped the data management team integrate the data mart built into the in-progress data warehouse.
- Perform data analysis on the existing SSIS packages and SQL server data model
- Optimized Tableau reports and generated performance analysis dashboards
- Used calculated fields, quick filters, parameters and action filters to create dynamic charts and tooltips
- Implemented solutions using actions filters to navigate between various dashboards by using Tableau
- Worked to create, develop and deploy multiple Drill down, Drill through, Sub-report and Parameterized reports by using Tableau 10.X
- Developed various data connections from data source to Tableau Desktop for report and dashboard development
- Created different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heatmaps and Donut Chart
- Effectively used data blending, filters, actions, hierarchies feature in Tableau.
- Published Workbooks by creating user filters so that only appropriate users can view/edit them.
- Generated context filters and handled performance issues while dealing with huge volume of data.
- Generated tableau dashboards with forecast and reference lines.
- Usage of Tableau Desktop for blending databases and creating different interactive views and dashboards.
- Scheduled data refresh on Tableau Server for weekly and monthly increments to ensure that the worksheet and dashboard were displaying the changed data accurately.
- Implemented permissions for users and ensure user security according to various clearance levels of business users
- Involved in documenting the project steps and presenting to the team members
Environment: Tableau desktop 10.x, Tableau Server 10, Tableau Reader, SQL Server, InformaticaMS Excel, PowerPoint, Slack, Agile/SCRUM
Confidential, Cherry Hill, NJ
Tableau Developer
Responsibilities:
- Designed and implemented complex SSIS package to migrate data from multiple data sources for data analysis and front-end display
- Monitored project status to meet milestones and resolved issues with data quality or the ability to deliver to timescales or estimates
- Scheduled SSIS Packages, stored procedures and reports with SQL server agent and Windows batch file commands based on time interval to load many data
- Created Error and Performance reports on SSIS Packages and alerts for successful or unsuccessful completion of scheduled jobs using SQL Server Agent Job Task and Event Handlers
- Generated Tableau Dashboards with quick/context/global filters, parameters and calculated fields on Tableau reports to visualize the trend and distribution of data using Tableau
- Built nested formulas in Tableau for various business calculations
- Used Tableau for creating a matrix and tabular, drill down, drill through, sub-reports and parameterized reports based on requirements
- Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions
- Designed, created and deployed ad hoc reports, drill down reports, drill through reports, tabular reports, form reports, multi-column reports, matrix, as well as charts in Tableau requested by the end user
- Used PowerPivot when requested to display analysis result with visual
Environment: Tableau Server, Tableau Desktop 9.x, SQL Server 2012, SQL Server Management Studio (SSMS), MS BI Suite (SSIS), SQL Server Data Tools (SSDT), Visual Studio 2010, MS Office Suite 2010 (ExcelPowerPoint, Word)
Confidential, Summit, NJ
Tableau Developer
Responsibilities:
- Involved in gathering requirements from business managers and created documentation template and documented project requirements
- Involved in reviewing business requirements and analyzing data source from Oracle/SQL Server/Excel
- Used T-SQL in SQL Server to develop complex Stored Procedures, Triggers, Clustered Index & Non-Clustered Index, Views, and User-Defined Functions (UDFs)
- Performed Performance tuning on existing queries by analyzing execution plans, logs/statistics, and traces in SQL Server Profiler/Database Engine Tuning Advisor
- Used ETL process to Extract, Transform and Load the Data into stage area and data warehouse
- Extensively worked on Drill-down, Drill-through and Matrix reports using Tableau
- Involved in creating interactive dashboards and applied actions (filter, highlight and URL) to dashboard
- Designed and implemented indexing to optimize transactional and reporting performance
- Generated Tableau Dashboards with quick/context/global filters, parameters and calculated fields on Tableau reports
- Developed meaningful tableau dashboards with advanced data visualization, calculation, and user-friendly interactions to support decision making
- Provided Production support to Tableau users and wrote customized SQL query to support business requirements
- Reviewed documents with QA team, clarified any questions or issues, and presented to the project manager for approval and implementation
Environment: SQL Server 2010, SQL Server Management Studio (SSMS), SSIS, Business Intelligence Development Studio, Visual Studio 2008/2010, Tableau Desktop8.x, Tableau Server, MS Office Suite 2013 (Excel/Word/PowerPoint)
Confidential
SQL Server/ Tableau Developer
Responsibilities:
- Gather and document project requirements and translated them into the functional and non-functional specification for BI reports and applications.
- Responsible for creating database objects based on business requirements such as User Defined Functions (UDFs), Views, Stored Procedures, etc.
- Responsible for creating database objects like Views, Stored Procedure, Triggers, User-Defined Functions(UDFs) etc. using Transact-SQL(T-SQL) 2008 to store data and to maintain database efficiently
- Designed the new report using Transact-SQL(T-SQL) and SSRS, illustrated by interactive dashboards, linked reports, sub-reports, parameterized reports and drill-down, drill-through reports using Tableau
- Involved in incremental loading task by implementing the Slowly Changing Dimension to maintain historical data in the data warehouse. Applied different types of transformations like Data Conversion, Multicasting, Conditional Split, Derived Column in SSIS.
- Debugged and troubleshot the ETL packages by using breakpoint, analyzing progress, catching error information by SQL command in SSIS.
- Worked with production control team to deploy code and for schedule run in both staging while testing and production. Responsible for providing on-call production support for daily job and ETL loads.
- Developed SSIS packages using different types of event handler to clean up temporary data storage when a package or task finishes running, send an e-mail message when an error or a warning occurs or when a task fails.
- Dealt with data cleansing such as data type conversion, format changing, missing value handling. And generated documents for data validation to ensure data consistency in staging area.
- Developed many Tabular reports, Matrix reports, created many Cascaded parameters to achieve Drill-down reports, Drill-through reports in SSRS 2008.
- Achieved data visualization, Reporting, and Analysis. Created Dashboards with Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts
Environment: s: Tableau Desktop, Tableau Server, MS SQL Server 2008 (T-SQL), SQL Server Management Studio, SQL Server Integration Service, SQL Server Reporting Service, MS Office Suite 2010.