We provide IT Staff Augmentation Services!

Sr. Tableau Developer/ Admin Resume

Richmond, VA

SUMMARY:

  • I am an experienced Data Analyst with a strong data analysis, data visualization, data cleansing, and process automation background.
  • I have extensive experience in creating intuitive and easy to understand dashboards using Tableau.
  • I have successfully performed various data extract, data transform, and data load jobs to/from relational databases using complex SQL queries, SAS codes, and python scripts.
  • I have automated several business processes and repetitive tasks with the help of python scripting language.

TECHNICAL SKILLS:

Data Analytic/Visualization Tools: Tableau (9 &10), Tableau Server, Tableau Reader, Base SAS, Advanced SAS, SAS Enterprise, Excel (XL Miner)

Programming/Scripting Languages: Python, SQL, Hive Query Language, Shell Script

Databases: Hadoop, AWS, Teradata, SQL Server 2012, MySQL, Oracle

Operating Systems: Windows, LINUX, UNIX

Office Tools: Microsoft Office Suite (MS Office, MS Excel, MS Power Point)

PROFESSIONAL EXPERIENCE:

Sr. Tableau Developer/ Admin

Confidential, Richmond, VA

Responsibilities:

  • Design, Develop, and Implement end - to- end automated business reports using Tableau, Python, and SQL.
  • Build, publish, and customize interactive reports and dashboards, scheduling reports using Tableau server.
  • Develop SQL/Python/HQL scripts to automate repetitive tasks; data pull, data cleansing, and data loading.
  • Analyze data, create visualization using Tableau, and present findings to the commercial team for further analysis/decision.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Design, Develop, and validate data quality checks to ensure data quality meets business standard.
  • Automated customer risk model using python and tableau.
  • Upkeep existing visualizations and pipelines as data environments change and more requirements are added.
  • Saved 370+ man hours per year by automating various processes and manual tasks with the help of python scripts and tableau dashboards.
  • Develop scripts in python to automate data pull and scrubbing jobs from various websites, do data scrubbing, and insert to database tables.
  • Create centralized dashboard for multiple line of business to streamline and expedite decision making process and provided functionality to visualize data in real time.
  • Create interactive Tableau dashboards using parameters, sets, groups, hierarchies, and calculations.
  • Responsible for debugging and troubleshooting stored procedures and complex SQL queries.
  • Discover/gather requirements for data analytical projects and provide suggestions to improve overall development.

Sr. Tableau Developer/ Admin

Confidential, New York, NY

Responsibilities:

  • Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis
  • Consolidated data, developed operations and procedures, improving workflow by 18%.
  • Create interactive Tableau dashboards using parameters, sets, groups, hierarchies, and calculations.
  • Responsible for debugging and troubleshooting stored procedures and complex SQL queries.
  • Discover/gather requirements for data analytical projects and provide suggestions to improve overall development.
  • Created centralized Tableau Dashboard for Risk Management Team to expedite decision making process.
  • Developed and automated several Extract, Transform, and Load scripts to pull data from various sources (Hadoop, Oracle, flat files) and upload to Teradata.
  • Pulled data from various sources like Oracle, Excel, Teradata, Access, and DB2 to analyze the data and produce the reports
  • Implemented flexible analytics solutions by providing various tools to users empowering them in turn freeing up IT resources.
  • Explained technical concepts and analytics-driven findings to business people including C-level executives, and explained business processes, concepts, challenges, and issues to technical resources.
  • Presented findings and data to team to improve strategies and operations
  • Develop Tableau dashboards to visualize project performance and drill down on current inefficiencies
  • Developed basic to complex SQL queries to research, analyze, and troubleshoot data and to create business reports .

Tableau Developer/ Admin

Confidential, Springfield, IL

Responsibilities:

  • Designed and developed various analytical reports from multiple data sources by blending data in Tableau Desktop.
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
  • Published Workbooks by creating user filters so that only appropriate teams can view it.
  • Built dashboards for measures with forecast, trend line and reference lines prepared new datasets from raw data files using python’s numpy, pandas, and scipy and imported into Teradata using SQL scripts.
  • Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
  • Analyzed large datasets and performed various analysis including statistical analysis, fraud detection, and duplicate/phantom vendors
  • Worked with Teradata SQL development teams and business users to investigate/resolve the raised issues and monitoring the technical processes.
  • Used Teradata Utilities like BTEQ, SQL Assistant to extract data and run various scripts.
  • Generated statistical analysis files, summary tables, listings and graphs using SAS, python, and tableau.
  • Created various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, and Parameters etc., in Tableau.
  • Worked a great extent with the design and development of Tableau Desktop which includes preparing dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
  • Generate routine and ad-hoc reports using PROC PRINT, PROC FREQ and PROC REPORT.
  • Developed SAS macros for data cleaning and reporting.

Data Visualization Expert (Tableau)

Confidential, Springfield, IL

Responsibilities:

  • Imported data from different file formats and creating datasets to get desired output using Import procedure.
  • Developed various data extraction scripts to expedite audit process.
  • Modified existing scripts by adding new codes, do-loops, and if-then statements to reduce overall run time.
  • Written, inserted and updated SQL scripts to import data between the systems environments
  • Created various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, and Parameters etc., in Tableau.
  • Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports
  • Generated context filters and used performance actions while handling huge volume of data
  • Pulled data from various sources like Oracle, Excel, Teradata, Access, and DB2 to analyze the data and produce the reports
  • Performed in depth analysis and data & prepared weekly, biweekly, monthly reports by using MS Excel, MS Access, and SQL.
  • Created SAS Customized Reports using the Data Null technique. Generated graphs using SAS/GRAPH and the SAS Graphics Editor.
  • Applied routine SAS macros to create tables, graphs and listings.
  • Created test cases, test conditions and test plans for quality analysis.

Data Analyst (Tableau and SAS)

Confidential, Cary, NC

Responsibilities:

  • Generated statistical analysis files, summary tables, listings and graphs using SAS.
  • Prepared new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Formats, and Functions.
  • Generated routine and ad-hoc reports using PROC PRINT, PROC FREQ and PROC REPORT.
  • Generated required Charts, Graphs and reports using Proc REPORT, Proc GPLOT and SAS/Graph for graphical analysis.
  • Understanding the requirements from the business users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
  • Analyzed existing requirements with end user and documented them for Tableau.
  • Prepared and published customized reports/dashboards.
  • Utilized statistical procedures like Freq, Report, SQL and Transpose to generate tables, listings for summarizing data reports
  • Used SAS/ODS facility to generate custom reports and thus directing SAS output to RTF, HTML and PDF files
  • Verification of the fixed bugs and subsequently closing them if they passed the test cases.
  • Worked with Tableau administrator in managing Production, Test and Development environments.
  • Used data blending feature in tableau and defined best practices for Tableau report development.
  • Created reports in Tableau using SQL Queries and Stored procedures.
  • Created reports using Custom SQL for complex report views.
  • Executed and tested required queries and reports before publishing.
  • Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups

Jr. Data Analyst

Confidential

Responsibilities:

  • Consistently maintained a high-standard performance record via exceptional service, follow-through, and specific attention to detail which resulted in higher sales.
  • Analyzed complex situations, designed practical solutions, and implemented cost-effective plans.
  • Supervised all the staff in delivering all services to clients.
  • Ensured customer satisfaction and developed the clear business propositions
  • Developed personnel, motivated staff to exceed goals, and improved production and sales.
  • Introduced new services based on customers need and increased revenue by 20 percent within a year.

Hire Now