Bi Lead/architect Resume
Hendon, VA
SUMMARY:
- Having 14 plus years of experience in Software Design, Development, Integration, Implementation, Administration and Maintenance of Business Intelligence and Database Platforms.
- Extensive Techno - Functional experience in Tableau 8.x / 9.x / 10.x,2018.x Tableau desktop and Server,Qlick View,Power BI, SAP HANA SPS7 & SPS8,SAP BI 7.0/7.3, SAP BO 4.0/4.1, SAP BODS 4.0 and Pentaho.
- Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including Technical support, troubleshooting, report design and monitoring of system usage.
- In-depth knowledge on Tableau Desktop and Tableau Server. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
- End to end experience in designing, development, Administration and deploying data visualizations using Tableau.
- Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting in many Tableau reports.
- Designed and coded application components in an agile environment utilizing a test driven development approach.
- Conducting enterprise-wide trainings for 500+ users, ranging from developers to EVPs, Directors, Project managers and SMEs on using BI Tools focusing on best practices, standards and effective visualizations
- End to end project life cycle experience including gathering business requirements, analyzing the business processes, performing AS-IS Analysis, Identifying and analyzing the Gaps, Implementation, Designing, Configuration & Customization
- Experience in preparing Functional specification and Technical specification documents.
- Expertise in creating Report Inventory, Report Mapping document, Report business requirement documents ( BRD), Reports functional requirements documents ( FRD), User Guide, Backlog documents, SRS Documents, Use cases diagrams and report inventory document.
- Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
- Extensively worked on various versions of Tableau 8.X and 9.X. 10.X and 2018.3
- Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including Tableau server installation, upgrades, backup and restore, technical support, troubleshooting, report design and monitoring of system usage.
- Broad experience on building dashboards using Tableau and Involved in Troubleshooting,
- Performance tuning of reports and resolving issues within Tableau Server and Reports
- Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment( HA).
TECHNICAL SKILLS:
REPORTING TOOLS: Tableau Desktop 8.x/9.x/ 10.1/2018.3 , Tableau Server 8.x/9.x/ 10.1/2018.3 Qlick View, Power BI, Business Objects
APPLICATIONS: ECC 6, SAP BW 7.4, SAP BW 3.5, SAP BO 4.0,4.1, Tableau 8,9,10 and 2018.3, SAP HANA SPS6-9.
ETL & MODELLING TOOLS: SAP BODS, SAP LT, SAP HANA, Informatics 9, Web Application Designer, WEBI, Dashboard, Analysis, SAP BO Design Studio, Pentaho& SAP HANA
DATABASES& TOOLS: GreenPlum, Jethru, Koginitio,Hadoop,MapReduce,HDFS, Hive, HBASE Teradata, Sql Server 2000/2005, DB2,Oracle, SAP HANA
Operating Systems: Windows NT/XP/2000, UNIX, LINUX(Redhat)
PROFESSIONAL EXPERIENCE:
Confidential, Hendon, VA
BI Lead/Architect
Responsibilities:
- Converts business requirements and specifications into Tableau presentation and data layer application solutions through effective design, coding and testing.
- Work with the business users in gathering the project specifications by conducting user requirements gathering sessions.
- Contribute in all aspects of software development lifecycle (SDLC) including architecture, development, migrations, installations, upgrades, troubleshooting, Testing and maintenance of the Tableau platform.
- Work with enterprise wide business and IT senior management to understand reporting and data analysis needs.
- Optimize the performance of Tableau applications.
- Gather requirements from clients. Analyze requirements and highlight gaps/inconsistencies in the requirements to the client. Presented dashboard to end users to demonstrate features
- Actively participate in initial and review meetings with business users to ensure that the development of projects meets business and system requirements for design development testing and production rollover of reporting and analysis projects within Tableau Desktop
- As a Tableau Analyst, used Tableau for Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and for various data Analysis. Also, to slice and dice the data, for analyzing the data of patterns, trends and fashions of various KPIs, Measures using various graphs, charts
- Acted as Tableau Developer (for designing and developing, proto typing the various dashboards using Tableau desktop. Also involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering (Quick Filters, Cascading filters, context Filters), ranking, Top-N Analysis, hierarchies)
- Developed Visualizations using Cross tables, Bar Charts, Pie Charts, Line Charts, Scatter Plots and Combination Charts Marking, Drill Down, Hierarchies, Coloring, Calculated Columns and Custom Expressions.
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Worked on Tableau Server Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment(HA).
- Worked on Tableau server installations, upgrades, backup and restore, User permissions, scheduling, technical support, troubleshooting, report design and monitoring of system usage.
- Involved in scheduling data refresh on Tableau Server for weekly and monthly basis on business change to ensure that the views and dashboards were displaying the updated data correctly.
- Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
- Perform administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management,
- Worked on scheduling the reports using TABCMD commands.
- Extensively worked on TSM Commands
- Worked on Penthao ETL tool
- Worked with Tableau support people to work on out of box issues.
- Worked extensively in SCRUM model
Environment: Tableau 10.x,2018.3 Tableau Server10.x,2018.3,Tabcmd,Tabjolt, Oracle, Hadoop, Hive, Rally, Pentaho
Confidential, Phoenix, AZ
BI Lead
Responsibilities:
- Converts business requirements and specifications into Tableau presentation and data layer application solutions through effective design, coding and testing.
- Developed Visualizations using Cross tables, Bar Charts, Pie Charts, Line Charts, Scatter Plots and Combination Charts Marking, Drill Down, Hierarchies, Coloring, Calculated Columns and Custom Expressions.
- Effectively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Extensive use of Marks, Filters and Pages, Add Reference line, Calculation Fields to create a complex Dashboards Deep understanding of key business applications as primary sources of data for Presentation and data layer application solutions.
- Experience in develop a working knowledge of internal Big Data applications like Hadoop, Kognitio, Jethro and Green plum.
- Perform administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management
- Worked on Tableau server installations, upgrades, backup and restore, User permissions, scheduling, technical support, troubleshooting, report design and monitoring of system usage.
- Expertise with Tableau migration and scheduling.
- Experience in taking back ups and restoration of Tableau repository
- Worked extensively in SCRUM model
Environment: Tableau 9.1, 9.2,9.3,10.1, Tableau Server, Hadoop, Hive, Kognitio, Jethro, Rally
Confidential, Tampa FL
Sr. Tableau Developer/Lead
Responsibilities:
- Developed Visualizations using Cross tables, Bar Charts, Pie Charts, Line Charts, Scatter Plots and Combination Charts Marking, Drill Down, Hierarchies, Coloring, Calculated Columns and Custom Expressions etc.
- Used Data Blending, groups, combine fields, calculated fields,aggregated fields and spotlighting to compare and analyze data in different perspectives.
- Created parameters and quick filters. Created sets to display top products based on their spend.
- Extensive use of Marks, Filters and Pages, Add Reference line, Calculation Fields to create a complex Dashboards.
- Effectively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 9.1 desktop/Server.
- Perform administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, Troubleshooting and general systems maintenance.
- Perform development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment
- Worked on Tableau server installations, upgrades, backup and restore, User permissions, scheduling, technical support, troubleshooting, report design and monitoring of system usage.
- Responsible for Tableau Release process to deploy the work books.
- Monitoring the performance of dash boards in the Server.
- Communicating with the business users to get the requirements
- Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Indicators (KPI) and Measures.
Environment: Tableau Desktop 9.x, Tableau Server, Hadoop, Hive, Green plum
Confidential, San Jose CA
HANA and Tableau Lead
Responsibilities:
- Reports to Tableau visualizations which involved extensive data blending, filter actions, parameters and embedded hyperlinks.
- Excellent in optimizing dashboards, performed Data validation and testing of visualizations with backend data prior to deployment.
- Performed daily maintenance activities, performance tuning, dashboard deployments and extensively used Tab admin commands in creating and restoring backups.
- As a Lead developer, involved in heavy interaction with business users in the process of discussing the overall Reporting requirements.
- Deployed Tableau Server in clustered environment comprising of a Primary and two worker servers.
- Involved in overall coordination regarding Installation, configuration and setup of Tableau environment at the client location.
- Involved in conversion of many Business Objects
- Collaborated with internal stakeholders to drive efficiency and effectiveness of the metrics and reporting.
- Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
- Good Knowledge in Production support process and fixing issues based on SLA's
- Worked extensively in SCRUM model
Environment: Tableau Desktop 8.x, Tableau Server, Oracle 10g, SQL developer, SQL 2008, HANA SPS8, BODS.
Confidential
HANA and Tableau Lead
Responsibilities:
- Gathered user requirements, analyzed and designed software solution based on the requirements.
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Effectively used data blending feature in Tableau.
- Defined best practices for Tableau report development.
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Executed and tested required queries and reports before publishing.
- Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.
- Creating DB views for the reporting purpose.
- Preparing Report Mapping Documents as per Specifications.
- 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 the 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.
Environment: Tableau 8.3/8.2/8.1, Tableau Server, SAP BO, SQL Server 2008/2012, PL/SQL
Confidential
BI Developer
Responsibilities:
- Worked with business stakeholders, application developers, production teams and functional units to identify business needs and discuss solution options.
- Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
- Mentored business power users to create reports/dashboards.
- Design and develop Universe on top of BEX Queries to extract BI 7.0 information to WEBI reports.
- Publish the reports to the user inbox for their adhoc analysis.
- Generated various reports on Weekly, Monthly and Yearly basis
- Design and develop Xcelsius dashboards on top of Bex queries.
- Created various detailed and summary AdhocWebi reports for the business users.
- Scheduled the reports to be emailed to end users daily in PDF/Excel formats in Infoview.
- Transporting objects from Development, Quality Assurance to Production environment in 3-tier landscape for SAP BOBJ.
- Expertise in connecting to Oracle and SQL databases and troubleshooting.
Environment: SAP BO, SQL 2008, Oracle 10g
Confidential
Lead Consultant
Responsibilities:
- Gathering user requirements, analyzed and designed software solution based on the requirements of the Business Processes.
- Understanding the System Enhancement Specifications of new business requirements
- Analyzed the source systems and created Business Requirement Document (BRD).
- Done requirement analysis, impact analysis and feasibility study. Defining the acceptance criteria and preparation of design documents (High level design, Low level design) and participation in the business meetings to gather requirements or clarification to the issues rose.
- Convert functional / Business requirements into technical requirements to prepare High level design and Low level design.
- Code changes to the existing components, creating new components. Code review toidentify defect/bugs of all severities.
- Creation of implementation plan. Implementation of the changes into Production system and post implementation activities.
- Preparation of test strategy, details test plan, Progression test cases, Regression testing. Testing for unit performance, data integrity, user acceptance and modifying codes and debugging systems for desired result to be produced. Come up with test cases and execution as per requirement. Did review for Unit Test Plans, Sting test plan, Detail test plan documents.
- Involved in AAT (Application acceptation testing), CAT (Customer acceptation testing) and UAT (User Acceptance Test).
Confidential
Mainframes Consultant
Responsibilities:
- Undertake estimations of assigned BIs and SBIs.
- Done requirement analysis, impact analysis and feasibility study. Defining the acceptance criteria and preparation of design documents (High level design, Low level design) and participation in the business meetings to gather requirements or clarification to the issues rose.
- Review for Code changes done by team members.
- Did review for Unit Test Plans, Sting test plan, Detail test plan documents.
- Involved in AAT (Application acceptation testing) Testing, CAT (Customer acceptation testing) and UAT (User Acceptance Test).
- Changes to the existing programs or creation of new components, report generation using various software like COBOL, DB2, JCL and VSAM etc.
- Involved in various testing procedures like unit testing, system testing, integration and regression testing.
- Tools ENDEVOUR have been used for the change management.
