Manager Tableau
Resume:
Certified Microstrategy and Tableau Consultant
Jude Wellington
Email ****.**********@****************.***
(ph) 612-***-****
Summary:
• Tableau Desktop 10 Qualified Associate.
• Microstrategy Certified Developer.
• Microstrategy Certified Engine Specialist.
• Microstrategy Certified Dashboard developer.
• Sound Experience in Reporting, Analytics and Modeling using Microstrategy and Tableau.
• Good Understanding of Business Objects. Have converted Business Objects reports to Microstrategy.
• Good Knowledge on Microstrategy Architecture and Administration.
• Hands on experience in migrating objects between various environments in microstrategy.
• Experience in writing Business Requirement Documents.
• Good Understanding of ETL tools. Have work experience in Alteryx.
• Experience in managing Tableau Online Server.
• Have used critical features of Tableau like Parameters, Filters and Actions.
• Involved in optimizing dashboard using techniques like table aggregation or data extracts.
• Hands on experience of Data Warehouse Architecture and Designing.
• Hands on experience in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis.
• Involved in Data Analysis and Modeling for the OLAP and OLTP system.
• Highly skilled in Gathering, Interpreting and Analyzing Complex data.
• Advanced sql programming in databases like Teradata, SQL Server, Netezza, DB2 and Oracle.
• Expert level skills using Excel, PowerPoint and Word.
• Guided and mentored team members.
• Having good exposure in offshore-onsite model.
• Provided training for business users in Microstrategy and Tableau.
• Can work independently with minimum directions.
• Good knowledge of various test cycles – unit/system/integrated/enterprise. Certified Microstrategy and Tableau Consultant
Technical Skills:
Languages: SQL, PL/SQL, C, C++, COBOL, Python 2.7
Databases: Oracle 10g/9i/8i, SQL Server 2005/2003/2000, DB2 V9, MS Access, Teradata V10, Netezza, Hadoop, IMS DB, IDMS
BI Tools: Tableau V10, Microstrategy DesktopV8.1, V9 & V10 Microstrategy Architect V8.1, V9 & V10, Alteryx
Tools: TOAD, MS Project, Teradata SQL assistant, SQL server management studio Education:
• Bachelors of Engineering in Electronics and Communication, India (1998 – 2002) Experience:
Wells Fargo Home Mortgage, Minneapolis, MN
Aug 2017 – Till Date
Analytic Consultant helped in developing dashboards using Microstrategy: My responsibilities included:
• Actively participated in the requirement gathering.
• Wrote complex SQL to support the reporting requirements.
• Provided technical and design suggestions in building the dashboards.
• Taking care of the issues opened in JIRA.
• Provided support for the schema development in Microstrategy.
• Introduced Tableau to the team for developing custom US maps to show Wells Fargo home mortgage markets.
• Perform data analysis and fixed existing data issues. Environment: Teradata, Tableau 10, Microstrategy 11, SQl Server Teradata Corporation / Centene Corporation, St. Louis, MO May 2015 – June 2017
Microstrategy/Tableau Consultant working in multiple business divisions within Centene. Created dashboards that displayed the HEDIS measures of each providers and gives a summarized view of the bonus amount payable/paid to each provider in every markets/plan. Developed business intelligence application that categorizes the providers based on the various metrics calculations and show the loyalty ratio for any particular provider. Certified Microstrategy and Tableau Consultant
Helped the business team for a smooth transition from traditional excel reporting to Business Intelligence applications.
Some of the Business teams were running their reporting on Business Objects. Helped those teams by converting their reporting to microstrategy.
Responsibilities:
• Created Worksheets and Dashboards in Tableau.
• Used advanced features in Tableau like Parameters, Table calculations, Actions and Filters.
• Involved in Architecting the microstrategy project, created reports, and dashboards.
• Actively participated in Data Modeling.
• Involved in Data Analysis for the ETL systems.
• Participated in Tableau to Microstrategy and Business Objects to Microstrategy Conversion projects.
• Designing and Developing dashboards and scorecard using Tableau.
• Experience in Creating Users in Tableau Online.
• Managing Site, Projects and Worksheets in Tableau Online Server.
• Created schedules in Tableau Server.
Environment: Tableau V10, Microstrategy V10, Teradata, JIRA, SQL Server, Business Objects Teradata Corporation / VALSPAR, Minneapolis, MN
April 2015 – May 2015
BI Consultant involved in grid report and dashboard development. The microstrategy application was dedicated to track the inventory of the raw materials. Coordinated with the Business Analyst to gather business requirements and worked with the Business users to support their UAT.
• Participated in Design Sessions for dashboards.
• Gathered requirements from the user.
• Assisted in testing the reports and dashboards.
Environment: Microstrategy V9, Oracle.
Teradata Corporation / Liberty mutual, Seattle, WA October 2014 – April 2015
BI Consultant focused on gathering customer requirements, analysis and building of Microstrategy intelligence cubes. Maintained their existing tableau dashboards with enhancement requests. SQL scripts were written to automate the ETL process to load data into the source system. The dashboards that we built for Liberty mutual were considered the “gold standard” within the company.
• Involved in Gathering requirements.
• Created the schema layer for the dashboard creation. Certified Microstrategy and Tableau Consultant
• Participated in design sessions.
• Created the reports to support dashboard development. Environment: Microstrategy V9, Tableau, Teradata. MS- Access Teradata Corporation / Centene Corporation, St. Louis, MO April 2014 – September 2014
Microstrategy Consultant helped the Business Intelligence Manager to effectively maintain their Microstrategy environment by creating Enterprise Manager Dashboards. The dashboards focused on the number of jobs and time taken by each job at day, month and quarter level. This application helped the BI Manager take decisions on which dashboards that needs to be cached and the data applications that needs to be retired.
• Gathered the requirements from the user.
• Prepared the list of metrics requested and validated them with the metrics that came of out of the box.
• Created reports that were used to support dashboard development.
• Actively participated in dashboard design sessions. Environment: Microstrategy V9, SQL Server, Enterprise Manager. Teradata Corporation, Minneapolis, MN
February 2014 – March 2014
Did a proof of concept project to understand the complexity in migrating their BI application’s database from Teradata to Hadoop. Integrity Manager was used to compare the results between Teradata - legacy reports and the Hadoop reports. This work identified defect patterns across all issues that allowed a detailed estimate on the cost of the total conversion.
• Use Integrity Manager to compare the reports between mstr-Hadoop and mstr-Teradata project.
• Fix the data issues in the mstr-Hadoop projects.
• Fix the report failures in Hadoop project.
• Provide a ballpark estimate on the complete conversion. Environment: Microstrategy V9, Tableau, Teradata, Hadoop, Integrity Manager Teradata Corporation / United Health Group
August 2011 – January 2014
Microstrategy Architect across multiple projects developed dashboards, analyzed and modeled data as per the client’s requirements. Also developed schema objects, public objects, Freeform SQL Reports, Transaction Service Reports and Stored Procedures. Provided advice to management on the appropriate BI tool(s) for their program, served as an internal subject matter expert for vendor sales presentations, and internal trainer for Microstrategy powered applications. Certified Microstrategy and Tableau Consultant
• Created various custom products using microstrategy.
• One of the pioneers in testing and implementing transaction services.
• Talk with other BI product vendors to discuss about their product offerings. Microstrategy Corporation / Limited Brands
February 2011 – July 2011
Microstrategy Analyst involved in fixing the existing issues in the reporting environment. Was actively converting their existing ms-excel reports into microstrategy.
• Created public objects like – filters, prompts, metrics and drill maps.
• Created schema objects – attributes, facts and hierarchies.
• Fixed the data issues in the existing dashboards.
• Created new reports and dashboards for business users. Microstrategy Corporation / Panda Express
Nov 2010 – Jan 2011
Microstrategy Consultant actively involved in deploying microstrategy for Panda Express. Their Lawson enterprise reporting was done through microstrategy. Also coordinated an offshore team in Warsaw, Poland and Shanghai, China.
• Involved from product installation to delivery of the reports.
• Participated in creating the data modeling.
• Developed public objects like filters, prompts and metrics.
• Developed schema objects – attributes and facts.
• Created the reports as per the client requirements. Microstrategy Corp / Lowes Corp, Mooresville, NC
March 2010 – Oct 2010
Tech lead
Performance Reporting
This project gives the statistical analysis of the performance of each stores located in United States. The reporting done through this project helped the Executives of the company to take critical decisions like which product needs to be promoted and which product needs to be stopped selling in the Market. The project work involved creation of reports and documents. Responsibilities:
• Participated in the meetings/discussions to understand the purpose and objective of the initiative/project.
• Created Solution Specification document and technical requirements as an input to application design.
• Provided technical guidance and leadership as required by various business units.
• Maintained an Offshore team of 7 members in Warsaw, Poland. Certified Microstrategy and Tableau Consultant
• Worked on the issues that were identified in the reports and documents after Microstrategy 8 was upgraded to Microstrategy 9.
• Assisted the Architect team to develop schema objects and also in logical & Physical data modeling.
• Worked on some report conversions – the existing excel reporting was converted to MicroStrategy reports.
• Maintained the ETL jobs in mainframe environment. SDI Health Care – Plymouth Meeting, PA
Sep 2007 – Mar 2010
Sales Analysis & Intelligence - Lead Report Developer The customer wants to have some system which can give him intelligent informational reports regarding his existing business situations and how he can analyze specifically his business .He wants to get specific answers through various angles. This system is concerned with taking care of sales analysis and distribution analysis of the products.
Responsibilities:
• Participated in the meetings/discussions to understand the purpose and objective of the initiative/project.
• Created functional and technical requirements as an input to application design.
• Worked with the team to ensure appropriate aggregations are created in support of reporting and analytics needs.
• Created transformational metrics (Sales, Sales Target, Market Share, and Growth) to compare monthly, quarterly and annual sales.
• Involved in creating Security filters to end users to access data Based on their privileges.
• Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
• Created various types of simple and compound reports using the Microstrategy Functionalities like Dill up, Drill Down, Prompts, Outline, and Metrics etc.
• Development experience in SQL, joins – inner/outer, grouping, sorting, filtering etc
• Developed various Metrics, Filters, Consolidations, Custom Groups and Prompts to give decision makers a handy tool to choose the criteria for reports and view information from different perspectives.
MetLife – Philadelphia, PA & Chennai, India
April 2006 – August 2007
Corporate Business Transaction –Analyst/ Report Developer Maintained the CBT application, developed reports and provided 24/7 production support. The major component of the CBT application is the CCIF database, which contains all the USAA member details such as member personal information, day-to-day transactions, claim details and property and casualty information.
Certified Microstrategy and Tableau Consultant
Responsibilities:
• Gathered and refined business requirements from the business users.
• Provided technical guidance and leadership as required by business units.
• Participated in creating processes and workflow norms for efficient development, integration and support.
• Coordinated efforts of development team in bringing together from conceptualization to deployment by managing roadmap, scheduling efforts and meeting milestones.
• Managed, prioritized, and implemented enhancement requests as required.
• Developed Scorecards and Dashboards that provide users a highly graphical, summary view of key metrics.
• Identified and developed creative solutions to drive operational efficiency across the organization.
J.C Penny – Chennai, India
August 2004 – March 2006
Analyst/Reports Developer
Incident tickets – In Data Warehouse part, there are many divisions and the team takes care of the report, which includes the Incident, Problem and follow-ups. Moreover, the higher officials use these reports for the weekly meeting. Each report consists of different data source. Responsibilities:
• Involved in interacting with the users and gathering the requirements, and analyzed the needs of the end users.
• Worked with business units to identify strategic and tactical opportunities, implementing technical solutions and non-technical alternatives.
• Provided technical guidance and leadership as required by business units.
• Documented and driven consensus on application functionality and requirements.
• Liaised with consultants and internal resources to produce and deliver applications.
• Managed, prioritized, and implemented enhancement requests as required.
• Built programs, queries, and reports as required by project specifications.
• Identified and developed creative solutions to drive operational efficiency across the organization.
• Developed logical and physical data model by defining strategy for Star Schema with Fact and Dimension tables with Detail, Summary, Look-up Tables, Indexes and Views.
• Extensively involved in data modeling to create attribute relationships.
• Developed new reports and converted existing reports for the business line to satisfy the specifications using Microstrategy Desktop and Microstrategy web.
• Created Facts, Attributes and Hierarchies using the Microstrategy Architect.
• Developed various Metrics, Filters, Consolidations, Custom Groups and Prompts to give decision makers a handy tool to choose the criteria for reports and view information from different perspectives.
JUDE WELLINGTON
DATE OF COMPLETION: 08,January 2017
Bob Watts
Executive VP, Worldwide Professional Services
Date Granted
This Certifies:
Has Satisfied All Requirements and Hereby Merits the Title: MCD CERTIFICATION 2014 14
MICROSTRATEGY CERTIFIED DEVELOPER V9.4.1
Jude Wellington
21 May 2014
Bob Watts
Executive VP, Worldwide Professional Services
Date Granted
This Certifies:
Has Satisfied All Requirements and Hereby Merits the Title: CES CERTIFICATION 2014 14
MICROSTRATEGY CERTIFIED ENGINE SPECIALIST V9.3.1
Jude Wellington
12 March 2014
Bob Watts
Executive VP, Worldwide Professional Services
Date Granted
This Certifies:
Has Satisfied All Requirements and Hereby Merits the Title: CDMD CERTIFICATION 2014 14
MicroStrategy Certified Dashboard and Mobile Designer V9.4.1 Jude Wellington
30 April 2014
Contact this candidate