We provide IT Staff Augmentation Services!

Sap Native Hana / Tableau Architect Resume

San Jose, CA

SUMMARY:

  • 11 years of total IT experience in the Analysis, Design, Development, Deployment and Project management of Business Intelligence applications with excellent skills in EDW industries.
  • 10 Years of experience in Enterprise Resource planning, product design and development and a total of 8 Full Life cycle implementation experience of a Decision support system.
  • Expertise in Native Hana hands - on development experience: creating SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access), SAP HANA Live (Analytics).
  • Involved in creating Dashboards using Tableau Desktop and Tableau Server.
  • Created incremental refreshes for data sources and scheduling extracts on Tableau server.
  • Experience in Architecture, Installation, Configuration and Administration of Tableau Server in a multi-server and multi-tier environment.
  • Introduced Tableau to Client’s to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions.
  • Excellent knowledge in Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP) and Data Marts. Knowledge on Data modeling using Dimensional Data modeling - Star Schema Modeling, Snowflake Modeling.
  • Experienced in client facing, requirement gathering, analyzing, documenting and providing the solutions with POC.
  • Assisted clients in business process improvement to maximize software functionality and demonstrated tool training & usage.
  • Good Understanding of requirements management, change management, software development and testing phases process while designing project implementation plan.
  • Experienced in Preparation of complex project plans, documenting several templates to track the status of the project and assisting in project progress meetings.
  • Recognized for strong communication, negotiation and client relation management skills.

TECHNICAL SKILLS:

BI: Tableau 10/9/8.x/7/6 Desktop/Server/Public, SAP HANA, Bank Analyzer, HANA Studio, BW on HANA, SAP BI 7.1/7.3, BW 3.x/7.x, SAP BIBO 4.2/4.1/4.0,XIR3/R2/6x/5x, BI Launch Pad, IDT, UDT, UMT, LCM, Promotion Management, Live Office, Crystal Reports 2008/XIR2/10, Xcelsius 4.1, Design Studio, BOBJ Explorer, SAP Lumira, SAP Mobile, BRIO Tool, MS Analysis for Office, Infomatica 8.5, DataStage 8.x, ERWIN 3.5,TOAD, SQL Developer, SQL, PL/SQL, Web servers & App. Servers (IIS, Apache, Tomcat).

Databases: ORACLE 7.1/8.0/8i/9i,10g/11i, SQL Server 2008/2005, DB2, Teradata v2r6

OS: Unix (HP), AIX, Win2k Servers, NT, Windows 95/98, XP, Vista, Windows 7

ERP Modules: SAP R/3 (4.7) FICO, SD, MM, PM, WM, PP, ECC 6.0

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

SAP Native HANA / Tableau Architect

Responsibilities:

  • Working as BI reporting/ Tableau Architect, played a vital role in SAP BI/HANA/BO/Tableau Global Implementation of a team of 10 members (offshore 6 and onshore 4).
  • Coordinated with team, Business Users, Technical Developers and Business Analysts.
  • Involved through all phases of Requirements Gathering, Gap Analysis, Blue printing, Functional/Technical Specs, Development, Go-live, rollout and post implementation support of SAP BI in APO, COPA, FI, MM, SD Implemented according to SAP.
  • Interacting with business heads and users to provide better solutions and explaining the capabilities of the BI, Tableau and HANA.
  • Worked on Tableau architecture design, Tableau administration and installations.
  • Advanced knowledge of Tableau BI application creation and server-side functionalities, Tableau Mobile, Tableau Desktop, Tableau Public and Big Data experience.
  • Creating users, groups, projects, Data connections, settings as a tableau administrator.
  • Connected Tableau server to publish dashboard to a central location for portal integration.
  • Connected Tableau server with share-point portal and setup auto refresh feature.
  • Hands-on development assisting users in creating and modifying Tableau worksheets, data visualizations, story boards and dashboards.
  • Creation of metrics, attributes, filters, reports, and dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data in Tableau.
  • Created visualization for logistics calculation and department spend analysis using Tableau Dashboard / Stories.
  • Worked on native SAP HANA application modelling and development using HANA studio; Data Modeler, Developer, HANA Administration Perspectives.
  • Heavily used Attribute views, Analytical views, column store/row store tables, analytical privileges, data provisioning, HANA SQL Script, calculation views, calculated columns, filter expressions, data pruning, triangulation… etc.
  • Coordination and work along with the SAP & BW teams to ensure the timely execution of data loads and delta loads to the reporting tables as well as testing the quality of data and providing inputs to the Business.
  • Involved in the Sprint planning, creation of Epics, Backlogs, Stories, Road Blocks and Risks in Agile methodology and provided weekly status on reporting deliverables and upcoming task details to team.
  • Actively involved with Basis tem in upgrading the BOBJ environments to BI 4.1 SP6 and BI 4.2 SP1, SP2 and SP3 environments and post upgrade validations.
  • Involved in PFIT reporting/security requirements discussions and provided best practices for BOBJ content migration to target environments and coordinated with PFIT team in migrating BOBJ content to Test environment.

Environment: Native SAP HANA, SAP HANA Studio, SAP Bank Analyzer, HANA SQL, Tableau 9/10 Server/ Desktop/Public, SAP BI 7.3, BW 3.x/7.x, SAP BOBJ 4.1 SP5/SP6, BI 4.2 SP1, BOBJ Explorer 4.1 SP5, Dashboards Design Studio, Oracle 11, SQL Server 2008, SQL Developer, SAP Lumira, MS AAO.

Confidential, San Ramon, CA

Sr. Tableau Developer / Solution Architect

Responsibilities:

  • Interacted with the Business End-Users, Analysts and SMEs of Gas Distribution/Transmission departments of PGE to identify business requirements, document specifications and actively involved in implementing AGILE methodology.
  • Involved in the project scope & charter and Project Planning of the Leak Survey Mobility & Leak Management projects in PG&E Gas Distribution/Transmission departments and provided estimates of the deliverables.
  • Involved in feasibility and analysis phase of Leak Survey, Mobility Analysis, Advanced Leak Detection techniques and documented business requirements, technical specifications for developing reporting solutions.
  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Worked with advanced Tableau topics such as complex calculations, table calculations, parameters, geographic mapping, data blending, extract optimization to create advanced chart types and visualizations to visualize the data to Business Heads.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Connected Tableau server to publish dashboard to a central location for portal integration.
  • Connected Tableau server with share-point portal and setup auto refresh feature.
  • Created visualization for logistics calculation and department spend analysis
  • Worked closely with business power users to create reports/dashboards using tableau desktop.
  • Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • 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.
  • Involved in creating advanced Tableau functionalities such as geographic mapping, data blending, extract optimization to create advanced chart types and visualizations.
  • Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
  • Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Connected Tableau server to publish dashboards and visualizations to central location for portal integration.
  • Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Involved in report tuning, caching, specifying query governing thresholds, and report optimizations; and created test cases and documented the test results.
  • Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau Desktop 8.x/9, Tableau Server, SAP BIBO 4.1SP3/SP5, Crystal Reports, SAP BW 7.1, ECC 6.0, Xcelsius 2008, Dashboards Design Studio, Tableau 9.0, Data Stage 8.1, SQL, PL/SQL, Oracle 10g, Windows Server 2003.

Confidential, Santa Clara, CA

SAP BI / Tableau Lead

Responsibilities:

  • Interacted with Functional Analysts and Business Users in gathering project requirements and involved in BRD discussions and Project Plan.
  • Involved in planning, design, development, implementation and production deployment of three major projects with SSG, Varian and PDC.
  • Extensively worked in implementing reporting solutions for FI-GL, FI-AP/AR, SD, MM, CRM, Warehouse Management modules and SSG, AGS, EES and Display Business Segments.
  • Worked with Basis team on setting up the BOBJ environment for versions 4.1 SP2, SP3 & SP5, Explorer 4.1 SP3, SP5 versions, MS Analysis for office version 1.4 SP4, 1.4 SP6, Xcelsius 4.1 and Design Studio 4.1 versions.
  • Worked with C-Level Executives and helped them with analyzing Sales Operations.
  • Created dashboards for senior Executives to track multiple KPIs in Accounting and Finance.
  • Conducted source data analysis, performed data profiling and synthesized data for developing visuals.
  • Spearheaded the discussions and strategized data sources from SAP BW to flow into Tableau workbooks/ dashboards.
  • Consulted on Tableau server performance enhancements; upgrades from version 8.0 to 8.1.5 and server reconfiguration based on workbook complexity and data extraction
  • Customized the Tableau landing page with site listing as icons and descriptions
  • Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Generate KPI for customer satisfaction survey results and disease management.
  • Maintained Test log and Wrote Test Evaluation, Summary Reports in Tableau.
  • Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
  • Involved in multiple cycles of Tableau reports and dashboards testing, FUT, ITC & UAT testing cycles and involved in bug fixes and report fixes based on the user suggestions and involved in the reports data reconciliation testing with source systems.
  • Created analysis for office workbooks with different functions and charts for reusability and published them to repository for usage by business users.
  • Prepared technical specification documents and project documentation.
  • Worked with Onsite-Offshore team setup environment.

Environment: Tableau 8.3/8/1, Tableau Server 8.3, MS-Excel, MS SQL Server 2008, SharePoint, HPQC, SAP HANA V1.0, HANA Studio, SAP BI 7.1/7.3, SAP BOBJ 4.0/4.1 SP2/SP3/SP5, Oracle 10g.

Confidential, New York

Sr. Tableau Developer

Responsibilities:

  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlines proposed solutions.
  • Expertise in Resolving the Daily issues in the Daily Production Environment.
  • Data collection and leveraging on data manipulation teams for required data and new KPI generation for Scorecards.
  • Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
  • Effectively used data blending, filters, actions, Hierarchies feature in tableau.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Executed and tested required queries and reports before publishing.
  • Converted metric insight reports to tableau reports.
  • Working extensively with Tableau Business Intelligence tool to develop various dashboards.
  • Working extensively using Excel to validate the data and use as the source data files.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Identifying Data problems of conversion Data and giving cause of analysis (Reconciliation).
  • Created Balance Sheet and General Ledger related dashboards and score cards to provide the users with business information.
  • Worked extensively with the BA teams to resolve the issues & plan and execute the releases.

Environment: Tableau 6/7.x, Tableau Server, MS-Excel, MS SQL Server 2008, Business Objects XI 3.1/4.0, Life Cycle Manager, Promotion Management, Crystal Reports, Web Intelligence, IDT, UDT, UMT, Oracle 9i/10g, Windows Server2003.

Confidential, New York

Sr. BI Consultant / Functional Lead

Responsibilities:

  • Analyzed users need, design and develop various decision support reports and applications for optimum performance
  • Involved in the upgrade of Crystal Reports Enterprise to Business Objects Enterprise XI3.
  • Migrated folders, sub-folders and objects using the import wizard from Crystal Reports 10 to Business objects XI3
  • Setup users and groups in CMC and created user profiles
  • Modify reports from Business Objects XIr2 to Business Objects XI3
  • Installed fix packs and service packs on DEV, QA and PROD crystal servers
  • Created ODBC configurations on DEV and PROD Business Objects servers
  • Troubleshoot both crystal reports and BOE server issues
  • Migrated Financial Reports to work for Global Financial Consolidation
  • Globalization of Accounting Analytical reports across Nomura Worldwide
  • ERP (8.8 to 9.1) migration remediation of Business Objects Universes and web intelligence reports

Environment: Business Objects Enterprise XI3.1, Web Intelligence XI3.1, BO Dashboard Manager, Crystal Reports 2008, Xcelsius, Peoplesoft 9.1, Oracle 10G, Informatica 8.5, VB6.0, EBI Version Manager, IBM Clear Quest, Windows NT, MS Office 2007, SQL, PL SQL, Toad 8.6.1, SQL Developer, Citrix Platform.

Confidential, Charlottesville, VA

Sr. BOBJ Administrator

Responsibilities:

  • Involved in security design for the BO Enterprise by creating folders, users and user groups as per the specifications according to the different Departments.
  • Production Support the users with their reports and be responsible for solving admin issues with the Database connectivity, response time and security of users.
  • Involve in Unit testing, system integration testing and user accepting testing for data validation for Inventory.
  • Understood business requirements, designed the solution document, tested, and managed offshore team from client site
  • Design and build Universes as per the business processes of different Departments.
  • Create complex Linked Universes to reduce development and maintenance time.
  • Define security filters to implement Row level and Column level security
  • Handle Embedded Functions like @Prompt, @Select, and @Where, @Aggregate awareness in the designer to handle User requests for report generators
  • Move content from dev-test-prod enivironments using import wizard and biar files.
  • Create Dashboards in Xcelsius with features such as drill down charts, Interactive Calendar components, alert methods

Environment: Business Objects Enterprise XI3.1, Oracle 9i, Data Integrator 11.5, Windows 2000, MS Office 2003, SQL, PL SQL, UNIX, SQL Developer, Citrix Platform.

Confidential, Collegeville, PA

Sr. BI Consultant

Responsibilities:

  • Involved in requirement gathering and data analysis for reporting from business users.
  • Created High-level and Detail-level documentation of the project.
  • Involved in the upgrade of Crystal Reports Enterprise to Business Objects Enterprise XI3.
  • Migrated folders, sub-folders and objects using the import wizard from Crystal Reports 10 to Business objects XI3
  • Setup users and groups in CMC and created user profiles
  • Modify reports from Crystal Reports 10 to Business Objects XI3
  • Used PVCS version control manager to store different versions of Business Objects Reports as well as stored procedures, packages and XML files
  • Maintained and managed all the maintenance of the DEV, QA and PROD BOE servers
  • Managed an offshore Kanbay team of 8 developers & testers to work on the development & testing of over 50 reports and six universes.

Environment: Crystal Enterprise 10, Business Objects Enterprise XI3.1, SQL Server 2000/2005, Oracle 9i, DB2, DataStage 7.5, Windows 2000, MS Office 2003, SQL, PL SQL, UNIX, Toad 8.6x, PVCS Version Control Manager and Lotus Notes.

Confidential, Greenwich, CT

BI Consultant

Responsibilities:

  • Working in the Home and Office Delivery Division as Business Objects Enterprise Administrator and Reports Specialist.
  • Meet with Business users to understand and analyze business requirements.
  • Installation & Configuration of Business Objects XIR2 Enterprise Suite of Products for Production Environment.
  • Responsible for Business Objects Servers maintenance using CMC, CMS.
  • Defined Complex Security set up for end users, groups using CMC and configured rights.
  • Designed universes and Sales Marketing reports, Confidential and adhoc reports, and organizational charts on top of those universes.
  • Involved in complete software development life cycle from Requirement analysis to UAT and Maintenance.
  • Created formulas using Crystal syntax and basic syntax.
  • Worked with the ETL team in solving issues using SQL Server Integration Services (SSIS).
  • Used APOS - Info Scheduler and Instance Manager to Schedule, Refresh and Distribute Reports & maintaining Instances of financial reports for at least 90 days.

Environment: Business Objects XIr2, Crystal Enterprise 10/XIr2/2008, Crystal Analysis Services 10, Business Objects XIr2, SQL Server 2000/2005, SSIS, SSRS, OLAP Cubes, Windows 2000, MS Office 2003, APOS - Info Scheduler, APOS-Instance Manager, SQL, PL SQL, UNIX.

Hire Now