We provide IT Staff Augmentation Services!

Tableau Developer/admin Resume

SUMMARY:

  • Total 6 years of Extensive Experience in IT Environment.
  • 4 years experience in Tableau and Power BI.
  • Experience in Analysis, Design, Development and Maintenance of various Business Intelligence Tools like Tableau Server, Tableau Desktop, power BI and SQL server.
  • Expert in Data Visualization development using Tableau to create complex and innovative dashboards.
  • Handled various responsibilities in Database issues, Data mapping and reporting solutions.
  • Experience in extracting and combining Data from different Data sources, different Databases and Data warehouses
  • Extensive experience in Tableau Desktop workbook design, reports and dashboard design and Tableau Administration/server includes technical support, troubleshooting, user / group setup, permissions, security roles and monitoring of system usage.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps and forecasted reports.
  • Extensively Used Data Blending to Join Multiple Data Sources and Rendering the data into visualization in Tableau
  • Deep conceptual knowledge of Tableau architecture including VizQL server, Application Server Data Engine and Data server.
  • Created dashboards, reports, analytics and advanced data visualizations
  • Designed and deployed dashboards, reports with drill down, drill through and Drop down menu option.
  • Strong SQL skills including use of nested table expressions, unions, multi - table joins
  • Excellent data skills, including the ability to analyze, visualize, and present data in a clear and concise manner.
  • An excellent communicator with exceptional interpersonal skills, ability to interact effectively with clients, business users and peers to get the work done smoothly
  • Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
  • Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau's Advanced Capabilities.
  • Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
  • Experience in all phases of software development life cycle (SDLC), including Requirement gathering and documentation, Use Case Documentation, FRD Specification, Business Case Study & Analysis, Quality Assurance & Testing.
  • Expert in Microsoft Excel (Pivot Tables, Vlookup, Hlookup).
  • Expertise in ETL tools like SSIS and reporting tools such as SSRS,Power BI.
  • Developed complex SQL queries using common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
  • Experience in Desktop Application and Web Application Testing.
  • Excellent knowledge of Manual Testing concepts and skills.
  • Experience in the areas of analysis, design and development of Business Intelligence solution using Visual Studio (SSDT)- Power BI.
  • Translate business requirements into ETL and report specifications.
  • Maintained database using backups and refreshing in testing environment.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using power BI and SSIS.
  • Proficient in performing data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.

TECHNICAL SKILLS:

Business & Modeling tools: Power BI, MS Office, SQL,SSIS

Methodologies: Agile, Waterfall

Project Management Tools: MS Project, MS Excel

Database: Oracle SQL, My SQL, MS SQL Server

Data Analysis: Data mining, Data warehousing, RDBMS

Testing Tools: Test Director 8.0, Quality Center 9.2, HP ALM

Operating Systems: Unix, Window 2000 Server, Windows Server 2003, XP, Windows 7

Reporting Tools: Power BI, Excel, Macros, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Newjersy, NJ

Tableau Developer/Admin

Roles and Responsibilities:

  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Created new reports based on requirements.
  • Worked with Internal modeling team for data analysis and profiling.
  • Designed and implemented basic SQL queries for testing and report/data validation.
  • Created SRD (System Requirements Doc) to facilitate the ETL team to develop their SDS (System Design Specification doc).
  • Help to Design reporting solutions to meet business requirements.
  • Involved in developing complex reports for various new projects and converted excel reports in to Business objects for ease of use and maintenance.
  • Experience in using SSRS in creating and managing reports for an organization.
  • Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
  • Facilitated UAT (User Acceptance Testing) for all the converted internal systems with business users, management group and team members.
  • Experience in using SSIS in solving complex business problems.
  • Used SSIS, SSRS for solving business problems and creating reports in organization.
  • Involved in interacting with the end-user (client) to gather business requirements.
  • Participated in analyzing and modelling the requirements for the logical and physical design of the database using star schema and normalization techniques.
  • Developed complex mappings to load data from Source System (Oracle) and flat files.
  • Created dashboards by extracting data from different sources using parameters, sets, groups and calculations. Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard. Involved in creating calculated fields, mapping and hierarchies.
  • Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
  • Responsible for translating business needs and rules into business requirements.
  • Created database requirements through requirement elicitation for business needs, documentation and management.
  • Understanding and translation of the current existing reporting system SSRS reports to convert them as Tableau reports and dashboards.
  • Experience using the Tableau tool to handle the various data feeds from different data sources using the Tableau Desktop tool.
  • Building the customized and interactive dashboards using multiple data sources.
  • Good Experience in working on Tableau data analysis as Tableau Analyst and building, developing the Tableau development dashboards as a Tableau Developer and Publishing the developed Tableau dashboards to Tableau server with security and authentication as a Tableau Administrator.
  • Read and reviewed design document of requirements for project needs.
  • Assisted in writing test cases and test approached for requirements.
  • Coordinated and lead walk through sessions.
  • Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
  • Monitored the Data quality of the daily processes and ensure integrity of data was maintained to ensure effective functioning of the department.
  • Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel.
  • Created views for reporting purpose which involves complex SQL queries with sub- queries, inline views, multi table joins, with clause and outer joins as per the functional needs in the Business Requirements Document (BRD).

Environment: Tableau, Data Analysis,Oracle 9i,SQL,PLSQL,Ms Visio,Linux,UNIX,Windows XP,MS Project, MS Access, Pivot Tables,MS Excel, MS Word,SSRS,SSIS.

Confidential

Tableau/Power BI Developer/Admin

Roles and Responsibilities:

  • Analyzed requirements, designed, developed, deployed and documented software components.
  • Participate in daily agile meeting, weekly and monthly staff meetings and collaborate with various teams to develop and support ongoing analyses.
  • Conduct data accuracy analysis and support stakeholders for decision-making.
  • Analyzing data using advance Excel functions such as Pivot Table, Charts and Graphs.
  • Performed data cleansing, data validation and mapping as described in the business requirements.
  • Designed and implemented complex SQL queries for QA testing and report/ data validation.
  • Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
  • Created naming and system standards for lookup, transformation and target tables.
  • Worked on Manual test cases for UAT testing and use SQL for querying and analysis purposes on various source tables and conditions applied.
  • Created Functional Requirement Documents from BRD (business requirement Document) and Project Initiation Documents.
  • Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data profiling on source Data.
  • Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
  • Conducted User Acceptance testing (UAT) and A/B testing worked with users and vendor who build the system.
  • Managed the testing and verification of HIPAA standard transactions, and EDI messages like (837, 835, 834),Validate the date from EDI transaction.
  • Worked closely on 834 transaction code for Benefit Enrollment and was involved in Validation of HIPAA for 837, 834 EDI transactions
  • Responsible for defining the functional requirement documents for each source to target interface.
  • Analyzed various source systems to understand the relationship between different source Tables
  • Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
  • Involved in designing the integrated Data Warehouse for the company to store the data from the OLTP systems.
  • Involved in Data analysis for data conversion - included data mapping from source to target database schemas, specification and writing data extract scripts/programming of data conversion, in test and production environments.
  • Developed dashboard, Charts and reports using Power BI.
  • Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
  • Interact with Project Teams, Developers, Business Analysts and Clients.
  • Developed complex mappings to load data from Source System (Oracle) and flat files.
  • Extensively worked with Quality Analyst to make sure that the functionality meets requirements.
  • Worked with GUI team for designing the screens and assisted in developing mockup screens and prototyping of the user interface for usability testing.
  • Prepared system Test Plan and scenarios for Test Scripts.
  • Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.

Environment: PL/SQL,SQLServer, Oracle 10g,Windows XP,Excel, Oracle, Unix,Pivot Tables,Power BI, Waterfall and Agile methodology,UML Diagrams and Flow Charts, MS Office, MS Access, ALM/Quality Center.

Confidential

Admin Quality Analyst Trainee

Roles and Responsibilities

  • Involved in writing and implementing Test plans, various Test cases.
  • Involved in SDLC and STLC Life cycles of the project.
  • Logged the defects and properly handled the issue resolution.
  • Strong Experience in Functionality testing, System testing, Regression testing, Negative testing, Positive testing, User Acceptance Testing and Boundary Value Testing, performance testing, stress testing, load Testing.
  • Worked on created User ids and password for the employees of the organization using various applications.
  • Created User accounts and provided permissions to the account holders.
  • Responsible for Design and Normalization of the database tables.
  • Checked the logs for authenticated users.
  • Worked on the backend and wrote SQL queries whenever required.
  • Created tables,views,indexes on the tables.
  • Involved in scrum meeting whenever necessary.
  • Requirement gathering and analysis by interaction with client.
  • Involved in scrum meeting whenever necessary.
  • Execution of Test Cases using Manual Testing concepts.
  • Bug Reporting and following the defect life cycle.
  • Testing Business Scenarios and the change requests and respective impact on the functionality.
  • Create Test Specification document as per requirement in MS Excel.
  • Worked on the backend and wrote SQL queries whenever required.
  • Created tables, views, indexes on the tables.
  • Perform detailed testing and write/execute test plans for black box, white box and regression testing.
  • Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues, Defect Management by Logging and Tracking bugs during execution in Test lab.
  • Creating & Executing Test cases for different forms as per test spec.
  • Using SQL for checking data manipulations manually.
  • Involved in end to end system testing and regression testing across different windows operating systems.
  • Identify risks and raise it for better quality by logging Bugs in Bugzilla.
  • Work towards deadlines and prioritizing workload.
  • Perform the testing on different enterprise OS platforms of Windows 10 and Windows 7 and Windows 8.

Environment: SDLC,Waterfall and Agile methodology,MS Project,Jira,MS Excel,SQL,MS Word,MS Office,MS Access, ALM/Quality Center.

Hire Now