We provide IT Staff Augmentation Services!

Data Analyst /tableau Developer Resume

Bridgewater, NJ

SUMMARY:

  • 8+ years of software development experience in teh areas requirement gathering, requirement analysis, configuration management, coding, testing, deployment and production support. Excellent Skills in Analysis, Design Jobs, Planning, Implementation and support.
  • 8+ years of experience in Data warehousing and Business Intelligence technologies along wif strong experience of data visualization using Tableau.
  • Hands on experience on Tableau 7/8.0/8.2 and Tableau Reader.
  • Wide - ranging experience in Tableau Desktop and Tableau Server in various versions of Tableau 7.0, Tableau 8.0/8.1, Tableau 9.0
  • Good knowledge on Tableau 9.0/9.1
  • Good Experience in working wif Tableau on Maps,Drill down,Drop down Mechanism.
  • Expertise in performing development activities from gathering requirements and designing solutions, through developing code/ reports to testing, release/deployment.
  • Ability to analyze and dissect user requirements and build front-end BI applications according to specifications.
  • Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries.
  • Mastered in using Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts.
  • In depth knowledge in Tableau advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines.
  • Mastered teh ability to design and deploy rich Graphic visualizations Parameters using Tableau.
  • Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
  • Expert in creating traditional as well as Web-based interactive reports using SSRS.
  • Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working wif Sites, providing access to teh users and adding them to teh specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
  • Interact wif Database, Informatica Administrators on environmental issues and work on fixing teh issues.
  • Practical understanding of teh Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Basic Knowledge on Schemas (Star, Snow flake), Data Modelling (Erwin).
  • Involved in teh development process to ensure that quality is built into teh product and verify that teh system complies wif teh functional specification.
  • Good knowledge on Creation, Review and Execution of Test Plan, Test Strategy, Test Procedures, Test Cases, Closure Summary
  • Defining job flows inHadoopenvironment using tools like Oozie for data scrubbing and processing.
  • Experience in configuring Zookeeper to provide Cluster coordination services.
  • Loading logs from multiple sources directly into HDFS using tools like Flume.
  • Good experience in performing minor and major upgrades.
  • Been part in writing technical requirement documents and low level design documents.
  • Experienced in requirement gathering/analysis, design, development, testing, and production support of reporting and analysis projects.
  • Good experience in working wif production support activities like CONTROL M,CRONTAB.
  • Worked extensively in Data stage 8.7/9.1
  • Proficient in Oracle Database and UNIX Shell Scripting.
  • Involved in Full Life Cycle Development of Reporting Projects, includes Requirements
  • Involved in Gathering/ analysis, Design, Development, Testing and Production rollover.

TECHNICAL SKILLS:

BI Tools: Tableau, MicroStrategy.

ETL Tools: Datastage,Microsoft SQL Server Integrated Services

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint, Excel)

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes

Databases: Teradata, Oracle, SQL Server, DB2, Sybase, Access

Document management: Documentum, Share point, Ultra Edit

Defect management tool: HP Quality center 10.0

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle (Waterfall, Agile, Iterative)

Scripting Languages: SQL, PL/SQL, HTML, and XML

Data modeling: Power Designer, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Bridgewater NJ

Data Analyst /Tableau Developer

Responsibilities:

  • Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
  • Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype teh same using Tableau desktop.
  • Mentored business power users to create reports/dashboards using tableau desktop.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
  • 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.
  • Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
  • Create and modify Interactive Dashboards and Creating guided navigation links wifin Interactive Dashboards.
  • Created Table of Contents (TOC), a common navigation page which had all teh links to various reports.
  • Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
  • Publish teh developed dashboard, reports on theTableauServer so that teh end users having access to teh server can view teh data.
  • Scheduled frequency and time to refresh data for teh when sources are publishes or extracted to server.
  • Design and development of various reports and dashboards that can be easily accessible through Tableau App in Ipads, IPhones, and other smart mobile phones.
  • Responsible to facilitate load testing and benchmarking teh developed product wif teh set performance standards.
  • Actively participated in clarification meeting wif teh Clients.
  • Created Test Cases and documented teh Test Results.
  • Involved in testing teh SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled teh performance issues effectively.
  • Involved in Onsite & Offshore coordination to ensure teh completeness of Deliverables.

Environment: Tableau (Desktop, Server), DataStage 8.7, Teradata, Teradata SQL Assistant, SQL, PL/SQL

Confidential, Atlanta, GA

Data Analyst /Tableau Developer

Responsibilities:

  • Prepared project reports for management and assisted teh project manager in teh development of weekly and monthly status reports, policies and procedures.
  • Developing and maintaining high level overview of teh project and design flows using MS Visio.
  • Worked on Business Intelligence standardization to create database layers wif user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
  • Creating and modifying Business Intelligence analytical reports using Tableau.
  • Used geographic view which clearly gives teh performance of a particular state.
  • Developed customized calculations when required.
  • Worked on drill through reports by creating HTML references.
  • Created various actions in database like filter actions to send information to other tableau worksheets and to connect teh same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between teh views on teh sheet.
  • Designed business intelligence dashboard using Tableau Desktop and publishing teh same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
  • Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
  • Worked on Performance tuning of report wif huge queries using concurrent query execution for better performance of report.
  • Addressing and Troubleshooting issues on a daily basis.
  • Launched R-statistical tool for statistical computing and Graphics.
  • Working wif data delivery teams to setup new Hadoop users. This job includes setting up Linux users, setting up Kerberos TEMPprincipals and testing HDFS, Hive.
  • Cluster maintenance as well as creation and removal of nodes.
  • Monitor Hadoop cluster connectivity and security
  • Manage and review Hadoop log files.
  • Uploaded data to Hadoop Hive and combined new tables wif existing databases.
  • Created Hive tables to store teh processed results in a tabular format and written Hive scripts to transform and aggregate teh disparate data.
  • Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
  • Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
  • Actively tracking schedule, clear and crisp communications wif key resources, stake holders and SMEs to keep everyone involved in teh project on teh same page, milestone tracking and avoiding scope creep issues.

Environment:Tableau (Desktop, Server), Hadoop 0.20.2 - PIG, Hive, Datastage 8.7,Oracle developer, SQL, Share Point, Agile-Scrum, UNIX, MS VISIO, Microsoft Office Suite.

Confidential, Eden Prairie, MN

BI Consultant

Responsibilities:

  • Liaison for project managers, managers, directors, and stakeholders.
  • Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.
  • Conducted gap analysis for re-engineering, and upgrading teh current system where ever necessary.
  • Develop, derive and clarify functional specifications and Use cases.
  • Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
  • Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
  • Reported all events and requirements through established reporting mechanisms in SSRS.
  • Migrated Stored Procedures from 2008R2 to SQL Server 2012using SSIS.
  • Created and Deployed of Ad-hoc and Customized Reports to satisfy business needs using SSRS.
  • Created SSIS Packages to (ETL) Extract, Transform and Load teh data into Reporting instance to generate teh reports easily and quickly.
  • Identification analysis and resolution of compliance issues through corporate data analysis standardization. (SSAS, SSRS and Oracle DBMS SQL).
  • Involved in Regression testing, Unit testing (UAT) and fixing issues in teh Reports during validation and before approving teh reports to Production Environment.
  • Designed teh conceptual and business process models.
  • Implementation of new systems including teh integration of teh new system wif existing systems.
  • Verifying installed systems to ensure that they adequately meet user requirements.
  • Physical design of data record data files and databases.
  • Involved in writing Test Cases, procedures, reports and approval of software release.
  • Monitoring teh project during Development phase and involved in User acceptance testing (UAT) once teh change requests are released from system testing.
  • Designed and Developed Complex Active reports and Dashboards wif different data visualizations using Tableau desktop on Sales, Finance data.
  • Designed and developed complex views based on reporting requirements in Teradata and used teh same as source in Tableau report development.
  • Creation of universe using IDT on top of SAP HANA models.
  • Designed BO Web Intelligence reports for different modules on top of universe built using IDT.
  • Development and Publishing teh webi and Dashboard reports on SAP Mobile Application
  • Created and maintained reports using Crystal reports Database expert, Grouping expert and Cross tab expert
  • Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables to improve teh performance of Tableau reports/Dashboards.
  • Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2000 and SQL Server 2005
  • Developed Technical requirements, design requirements and user acceptance documentation by placing Screen shots of actual Report and tested report in documentation.
  • Worked wif power users in user acceptance testing of various reports/ dashboards in Tableau prior to deployment of same in Production environment.
  • Assisted in project management activities like planning, development, task allocation, project execution
  • Provided full project life cycle flowcharting, analysis and documentation.
  • Deployment of defect free code while managing teh timeline set for teh project.

Environment: Data stage 8.5, Data modelling, Tableau (Desktop/Server), MicroStrategy (Desktop/ Server), Oracle, Teradata SQL Assistant, TOAD, PLSQL Developer, MS VISIO, SSRSMicrosoft (Word, Access, Excel, Outlook

Confidential, Natick, MA

SQL/ BI Developer

Responsibilities:

  • Played a key role in gathering and documenting Business requirements.
  • Conducted Requirement walk-through meetings wif key stakeholders.
  • Participated in technical walk-through meetings to develop teh functional design for teh implementation.
  • Performed detailed requirement analysis and created data mapping documents
  • Acted as liaison between Business Intelligence and Business User groups to relay change requests.
  • Performed extensive GAP analysis in teh project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
  • Oversee teh performance of Design to develop technical solutions from Analysis documents.
  • Designed teh conceptual data and business process models.
  • Identified teh key facts and dimensions necessary to support teh business requirements. Develop teh logical dimensional models.
  • Make use of data modeling techniques in designing teh data marts project.
  • Extensively involved in Data mapping and Data modeling.
  • Assisted teh DBA in converting teh logical models to physical.
  • Conduct Design discussions and meetings to come out wif teh appropriate Data Mart using Kimball Methodology.
  • Developed mappings and workflows in Informatica to extract data files for third party vendors.
  • Created views and extracted data from Teradata base tables and uploaded data to oracle staging server from Teradata tables, using fast export concept.
  • Involved in modifying Teradata stored procedures and performance tuning of various tables.
  • Managing metadata by mapping dimensions and fact tables of various schemas/data models
  • Generated reports like subject area reports, entity relationship diagrams, attribute reports, table reports, column reports, indexing reports, relationship reports using ERwin Tool.
  • Conducted JAD sessions, design discussions and SOS meetings to come out wif teh appropriate data mart.
  • Experience defining enterprise data location architectures for ODS, Data mart, and Data Warehouse data.
  • Created test cases for carrying out unit testing and part of functional testing.

Environment: Data Stage 8.5,Erwin, Control M, Oracle, Toad,SQL Developer, TOAD, UNIX, MS Visio, MS Office Suite (Word, PowerPoint, Excel).

Confidential, Dallas, TX

Data Analyst

Responsibilities:

  • Involved in gathering user requirements along wif business analysts.
  • Conducted logical data analysis and data modelling JAD sessions, documented data-related standards.
  • Identified teh key facts and dimensions necessary to support teh business requirements. Develop teh logical dimensional models.
  • Created views and extracted data from Teradata base tables and uploaded data to oracle staging server from Teradata tables, using fast export concept.
  • Gather all teh Sales Analysis report prototypes from teh business analysts belonging to different Business units.
  • Created and modified of Attributes, Facts, Metrics, Filters and other report objects.
  • Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating and modifying complex reports.
  • Updated attribute relationships to make MicroStrategy SQL engine generate correct SQL.
  • Created Attributes, Facts for different MicroStrategy projects.
  • Responsible for teh end Users training for teh MicroStrategy Web interface.
  • Apply Functions in MicroStrategy like teh ApplySimple & ApplyComparison whenever necessary.
  • Conducted data validation testing to ensure data quality.
  • Active Participation in checking teh data at database level and at MicroStrategy level in case of displaying wrong data.

Environment Data stage 8.5, putty,Control MSQL Server 2005/2008/2008 R2, MS Access, MS Excel, MS PowerPoint,R, SAS, Informatica ETL, VBScript, HTML, XML, Visio, ASP.NET, VB.NET, BIDS.

Confidential

Business Analyst

Responsibilities

  • Involved in developing Bankruptcy transaction prototype based on in-house research, technology and client development teams' feedback.
  • Interacted wif user groups to derive teh functional requirements.
  • Involved in documentation during various phases of development life cycle.
  • Create Use Case diagram and Activity diagrams through MS-Visio and Smart Draw thus defining teh data process.
  • Designed cohesive platform interface for Bankruptcy and Buyback databases, wif inputs from Technology and Design Teams.
  • Actively led teh testing of teh new and enhanced features and designs for back-end and platform.
  • Performed manual/functional testing by executing test cases prior to automation.
  • Handled post launch testing after each launch to ensure that no new bugs affecting other transaction or non-transaction datasets.
  • Prepared process and training manuals on different aspects of transaction datasets under supervision.
  • Good MS-Excel, VBA and SQL database skills, wif proven ability to multi-task, prioritize, and wif strong attention to detail.
  • Adept at preparing business presentations, reviewing and organizing financial data, and developing qualitative and quantitative analysis.
  • Impart training session for new recruiters, educating them wif work process, research skills & issues and implement them in day to day functional process as applicable.
  • Work in close coordination wif various functional and technical teams for related issues and solutions.
  • Documentation handling, functional testing and working on change requests related to products like Celsus and Deal Track.

Environment: Agile-Scrum, Oracle, SQL Server 2005, MS Access, MS EXCEL, MS Visio, MS Office Suite.

Hire Now