We provide IT Staff Augmentation Services!

Sr. Tableau Developr / Sr. Data Analyst Resume

Winston-salem, NC

SUMMARY

  • 8+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
  • 5 years of extensive experience in Tableau Desktop, Tableau Server, Tableau Public, Tableau Online, and Tableau Reader in various versions of Tableau.
  • Experience in all phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing, documentation, implementation and maintenance.
  • Extensive knowledge in modeling Business Processes (As - Is and To-Be), Use Cases, Activity Diagrams, Data Flow Diagrams, Process flow Diagrams, and Network diagrams.
  • Extensive knowledge with operational, project and process engineering management using PMBOK, Agile, Lean and Six Sigma methodologies.
  • Strong experience in requirement gathering and analysis process in a client facing role.
  • Experience of creating Functional Specification Documents (FSD), Business Requirement Documents.
  • Created, modified, and administered analytics Intelligence Dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and tables in Tableau.
  • Proficient in creating complex KPI scorecards and interactive dashboard using data visualizations like heat maps, treemaps, circle views, bar charts, lines, pie charts, area charts, box and whisker, gantts, bubbles and highlight tables that helped business get a good handle on the team's productivity.
  • Experience in the Development, Implementation of Database/Data Warehousing, BI Analytics and Dashboards applications usingData Profiling, Data Extraction,Data Transformation,Data Loading, data visualization and reporting tools.
  • Expertise in Performance Tuning of Tableau reports by following best practices in source data like data blending, custom SQL etc.
  • Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), OLAP SAP BW, MS Excel, MS Access, Teradata and DB2.
  • Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
  • Extensive knowledge and experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
  • Extensive experience in ETL design, development and maintenance using SQL, PL/SQL, SQL Loader, Informatica Power Center 7.x/8.x/9.x.
  • Strong experience in OLTP/OLAP System Study, Analysis and E-R modeling, developing Schemas such as Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
  • Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
  • Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.
  • Well versed in query optimization for performance tuning and monitoring of processes.
  • Experience working as a BI Consultant with specialization in Business Objects 6.5/ XIR2/ XI3.1/ Crystal XI and Web Intelligence.
  • In-depth knowledge in building/maintaining Repository, Universes and creating adhoc reports.
  • Working in both Semantic layers of Business objects like Universes and Business views as Data source for Crystal reports.
  • Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
  • Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

TECHNICAL SKILLS

BI Tools: Tableau (Desktop/ Server/ Reader/ Public/ Online/ Mobile), SAP BO, SSRS, Crystal Reports, MS Excel

ETL Tools: Informatica, DataStage, Microsoft SQL Server Integration Services (SSIS)

Modeling Tools: Power Designer, ERwin, ER Studio, MS Visio, Rational Rose, DOORS

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

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

Defect Management Tool: HP Quality Center

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

Scripting Languages: SQL, PL/SQL, Vizql, C, C++, HTML, COBOL, JCL, and XML

Front End/ Client Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes, Teradata SQL Assistant, Toad, Putty, SQL Developer, Share Point

PROFESSIONAL EXPERIENCE

Confidential, Winston-Salem, NC

Sr. Tableau Developr / Sr. Data Analyst

Responsibilities:

  • Worked closely with the business users to identify various KPI’s and designed solutions to enhance business decision-making.
  • Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
  • Developing and maintaining high level overview of the data flows using MS Visio.
  • Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
  • Developed and modified Business Intelligence analytical reports/ dashboards dealing with Origination, Portfolio Risk, Consumer Credit, FP&A and Marketing using Tableau desktop.
  • Prepare dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Develop Scripts to load data into tableau and work with multiple data by data blending.
  • Extracted data from various sources (SQL Server, Teradata, SAS, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data.
  • 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 Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
  • Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
  • Created very complex Dashboards using Tableau using the drill down, drill across, actions for business steering committee.
  • Design and development of various reports and dashboards that can be easily accessible through Tableau App in Ipads, IPhones, and other smart mobile phones.
  • Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
  • Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
  • Designed, Developed and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Integrated Tableau visualizations onto web applications using Java API scripting.
  • Defined Custom Geo Coding to extend existing role, add new role and add new hierarchies to view on Geographic maps.
  • Generate context filters and use performance actions while handling huge volume of data.
  • Involved in Tableau Server Installation and Configuration, creating users, groups, and projects and assigning access levels.
  • Preformed Data mining for the identification of unusual data records or data errors that require further investigation.
  • Co-ordinated Tableau TWBX files till UAT/Production environments.
  • Worked with end users in creating complex dashboards in an iterative process.
  • Configuring scheduled updates (Automatic and User notified) for optimal performance.
  • Monitored user activity on a weekly basis for benchmarking adaptability and usability of reports.
  • Defined best practices for Tableau report development.

Environment: Tableau (Desktop/Server), SAS, SQL Server, Java API, Microsoft office Suite (Word, Excel, PowerPoint)

Confidential, Omaha, NE

Sr. Tableau Developer / Sr. Data Analyst

Responsibilities:

  • Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
  • Participate in the Business and Specifications requirements gathering sessions and convert it into Design specifications.
  • Review the estimations, analysis & solution documents, technical specifications.
  • Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
  • Worked extensively with MS Visio and Rational tools to document requirements
  • Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
  • Prepared ETL design document which consists of the database structure, change data capture, Error handling, restart and refresh strategies
  • Performed Data Mapping between the data sources.
  • Compared and Tested Source data with XML Output flow.
  • Collected data on various process measurements and formatted into graphs using Tableau software.
  • Mentored business power users to Create, customize & share interactive web dashboards in minutes with simple drag & drop and also to access dashboards from any browser or tablet.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, custom Geo Maps, Trend Lines and Statistics, Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI’s.
  • Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
  • Defined and created procedures to install Tableau desktop in silent mode.
  • Defined best practices for Tableau report development.
  • Worked with Tableau Administrator in Installing Tableau Server in Dev, QA and Prod environments and documented upgrade plan from tableau 8.0 to 8.1
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Created incremental refreshes for data sources on Tableau server.
  • Connected Tableau server with SharePoint portal and setup auto refresh feature.
  • Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Expert in generating complex dashboard reports, adhoc, business views along with user acceptance test and data accuracy test.
  • Coordinated database middleware issues with DBA's, system performance with System Architects.
  • Configuring the analysis for scheduling auto emails from Tableau automation.
  • Experience of Client-Interaction on onsite/Offshore.

Environment: Tableau (Desktop/ Server), Teradata, Oracle, SQL Server, Erwin, Java API, MS Visio, RUP methodology, Microsoft Office Suite ( Word, Excel, Power Point).

Confidential, Malvern, PA

Tableau Lead Developer / Sr. Data Analyst

Responsibilities:

  • Involved in defining the whole project life cycle, following RUP methodology. Developed a vision plan that defined the primary goals and objectives of the project. Analyze business requirements and segregated them into high level and low level.
  • Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
  • Assisted Project Manager in developing design and specification, according to the requirement and information gathered during JAD sessions and other forms of information gathering methods.
  • Extensively involved in ETL code using Informatica tool in order to meet requirements for extract, cleansing, transformation and loading of data from source to target data structures.
  • Determining Interface requirement for source and target systems.
  • Developing and maintaining high level overview of the project and design flows using MS Visio.
  • Cleansing, Aggregation, and Joining of Data and also provide a historical View of Confidential ’sdata.
  • Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
  • Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Interact professionally with diverse group of professionals in the organization including managers and executives.
  • Standardize Tableau for shared service deployment and data blending, embed functionalities in Tableau.
  • Designed multiple Dashboards for CDI, helping them to convert from manual reporting.
  • Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
  • Developed Standard Operating Procedures (SOP) for Monitoring.
  • Experience in converting OBIEE content into Tableau BI content.
  • Experience in providing Tableau server and tableau desktop training.
  • Helped in designing Data-warehouses/ETL workflows required for the reporting applications.
  • Experience with Teradata.
  • Experienced with trouble shoot of Teradata connection.
  • Actively participated in clarification meeting with the Clients.
  • Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
  • Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau (Desktop/ Server), Teradata, Fast Load, Oracle, SQL, PL/SQL, SQL Developer, Informatica Power Center, SQL 2008, R2, DB2, Microsoft Office Suite ( Word, Excel, PowerPoint).

Confidential, Madison, NJ

Data Analyst / Tableau Developer

Responsibilities:

  • Involved in requirement gathering/analysis from the on-site team leads, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
  • Led information-gathering meetings with users to gather business requirements. Used event analysis and data modeling techniques to gather and document requirements. Delivered business requirements document and preliminary logical data model.
  • Wrote and delivered the high level business requirements document, process flows and a conceptual data model.
  • Conducted structured walkthroughs with the entire user community.
  • Documented the data requirements and system changes into detailed functional specifications, created data mapping documents from various source data feeds to the target databases.
  • Designed database layers with aggregate tables and materialized views based on source data need for reporting requirements to improve performance of Tableau reports.
  • Analyze the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
  • Developed complex SQL scripts for fetching data in to Tableau as per the business needs.
  • Generated dashboards to compare the expected weekly sales vs projected sales used dual axis for comparison.
  • Generated tableau dashboards for sales with forecast and reference lines.
  • Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
  • Scheduled the publishing of dashboards from Tableau Server on weekly basis.
  • Sending the dashboards to users by emails with the help of admin team with subscriptions.
  • Given training/demos to users on Tableau Desktop for development.
  • Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
  • Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
  • Involved in license management SLA's with Tableau support.
  • Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Built complex formulas in Tableau for various business calculations.
  • Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau(Desktop/Server), MySQL Server, SQL Server 2008, Oracle 10g, PL/SQL, SQL Server Management Studio, UNIX, Visual Studio, Microsoft Office Suite ( Word, Excel, PowerPoint).

Confidential, Charlotte, NC

Business Systems Analyst / Data Analyst

Responsibilities:

  • Interacted with business users for gathering requirements and look and feel of the applications to be developed.
  • Worked on Master Data Management (MDM), analytics and data integration using Service Oriented Architecture (SOA).
  • Worked on architectural review and developed programs for data governance and metadata management.
  • Participated in Business Analysis, talking to business Users and determining the entities for Data Model.
  • Evaluated and enhanced current data model as per the requirement
  • Analyzed the source data coming from Oracle, SQL server, SAS, Lawson and flat files. Worked with Data Warehouse team in developing Dimensional Model. Designed and developed Star Schema and created Fact and Dimension Tables for the Warehouse using Erwin.
  • Designed ETL specification documents to load the data in target using various transformations according to the business requirements.
  • Extensively used Informatica- Power center for extracting, transforming and loading into different databases.
  • Customized the OBIEE Repository (physical, BMM, and presentation layers).
  • Created dimension hierarchies, aggregates, and keys in the BMM layer.
  • Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
  • Worked on performance tuning of various OBIEE Reports / Dashboard.
  • Performed queries to fetch new data, and create reports in Business Objects XI3.1 by connecting to Oracle Data Sources.
  • Created various reports like Master/Detail reports, Cross Tab reports, Slice and Dice reports, Charts using Freehand SQL and Stored Procedure as data providers.
  • Involved in migrating reports using the report migration utility.
  • Created and maintained Business Objects & Web Intelligence reports.

Environment: Informatica Power Center, SAP Business Objects XI3.1, ERWIN, OBIEE, Oracle 10g/9i, Teradata, TOAD, SAS, Lawson, Mainframe, UNIX, Shell scripting, Microsoft Office Suite ( Word, Excel, PowerPoint).

Confidential

Business ObjectsDeveloper

Responsibilities:

  • Designed and developed Universes by defining joins, cardinalities between tables, linked the existing Universes using Business Objects.
  • Created Aliases, Multiple contexts for catering different functional areas in a single user query.
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
  • Customized LOVs in Universes for quicker performance of reports.
  • Interacted with the Business Users to analyze the business process and gathered the requirements, made necessary changes to schema objects to fulfill their reporting and business needs.
  • Experience in universe migration across repositories.
  • Performed queries to fetch new data, and create reports in Business Objects 6.5 by connecting to Oracle Data Sources.
  • Created various reports like Master/Detail reports, Cross Tab reports, Slice and Dice reports, Charts using Freehand SQL and Stored Procedure as data providers.
  • Used calculations, variables, breaks, sorting, filters, alerts and prompts while developing and creating reports.
  • Involved in migrating reports and universes from 5.x to 6.5 and Web Intelligence reports using the report migration utility.
  • Created and maintained Business Objects & Web Intelligence reports.
  • Created reports based on PL/SQL.
  • Published existing reports to corporate intranet through Web Intelligence.

Environment: Business Objects 6.5.1, Web Intelligence 6.X, BCA 6.5, Oracle 9i, Microsoft Excel, HTML, Windows XP.

Confidential

Business Objects Developer

Responsibilities:

  • Create/develop special ad-hoc reports, database queries, status reports, etc. as requested using BOXIR2.
  • Provide ad-hoc analysis and reporting to business units.
  • Created E-R schema by identifying entities and their related attributes.
  • Worked on Erwin tool in created E-R diagrams.
  • Designed and developed tables in MS Access Database.
  • Analyzing requirements, technical design and development areas.
  • Developed the reports in Reports Designer using Vertical stacked chart, Pie Chart to view the quarterly metrics.
  • Created complex reports using the multiple data providers and synchronized the data providers by linking the commonobjectsto create the common reports.
  • Created parameter driven reports according to user requirements using Web I.
  • Exported the Universes to Repository for making it available to users.
  • Created tables, indexes, sequences and constraints.

Environment: BOXIR2 Designer, Desktop Intelligence, Web Intelligence, HTML, Microsoft Excel.

Hire Now