We provide IT Staff Augmentation Services!

Sr Business Intelligence/analytics Consultant Resume

Irving, TX

PROFESSIONAL SUMMARY:

  • Certified Business Intelligence Developer with strong experience with 9+ years of experience in the IT industry specialized in Business systems analysis, Database development and Reporting.
  • Experienced in delivering reporting solutions using SAP Business Objects Enterprise, Dashboards, Tableau Desktop (8.x/9.x/10.x), Microsoft Power BI(Certified), Oracle SQL, DB2, Teradata and PL/SQL.
  • Experienced in using Xcelsius with Live Office, QaaWS and BI Web Services in creating Dashboards & Scorecards, which are used in determining the performance and progress of the business.
  • Expert in Data Visualization development using Tableau to create complex, intuitive and innovative dashboards.
  • Experience in Full Life Cycle Development of Reporting Projects, includes Requirements gathering/analysis Design, Development, Testing and Production rollover and excellent knowledge on SDLC.
  • Experience in Troubleshooting, Performance tuning of reports and resolving issues with in Tableau Server and Visualizations for more than 200 users and assigning various extract schedules to optimize the performance
  • Experience working on Agile Methodologies with good Communication and Presentation Skills.
  • Worked closely with the business and as Tableau SME for creating the dashboards that are desired by them.
  • Good experience in preparing Unit Test Cases (UTCs), Unit Test Plan (UTPs) and Unit Test Results (UTRs) and worked with UAT teams for approvals.
  • Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices.
  • Experienced in tuning long running SQL queries for better performance.
  • Built Visualizations and Stories, Combined data sets, edit, and cleansed datasets, enriched data by creating calculated measures and attributes in the data sets.
  • Creating interactive dashboards and applied actions (filter, highlight and URL) to dashboard.
  • Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Expertise in publishing reports, content packs and maintaining the Power BI environment by setting up the Enterprise data gateways, workspace groups etc.,
  • Worked in complete Software Development Life Cycle (SDLC), starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and till maintenance.
  • Excellent Communication and Interpersonal skills. Technically sound, Result - Oriented with strong Problem-solving skills. Capable of working as a team Member or Individually with minimum supervision.

TECHNICAL SKILLS:

Operating Systems: Windows 10/7/XP/2003/2000/NT, Win Server 2008/2003 & Unix

SQL, PL/SQL, T: SQL, HTML, Java, Java Script

Databases: HANA, Oracle 11/10g/9i/8i/7.x, Teradata 14/13, SQL Server 2008/2005/2000 , IBM DB2, MS Access.

Reporting Tools: SAP Business Objects 4.1/4.0/3.1/XIR2/XI/6.x, Dashboard Designer 4.0/4.1, Xcelsius 2008/4.5, Crystal Reports, Crystal for Enterprise, Tableau 8.x/9.x/10.x, Microsoft Power BI, MS Access, MS Excel.

Tools: Oracle Enterprise Manager, Oracle SQL Developer 1.5.1, SQL Plus, SQL Loader, TOAD, Rapid SQL, Mercury Quality Center, MS Office

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr Business Intelligence/Analytics Consultant

Responsibilities:

  • Coordinate with client representatives and seek clarity on minute details to provide the best possible solution. Work with architects, functional owners and other IT shared services to design and develop systems that help meet new demands of a rapidly growing business.
  • Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons.
  • Designed, developed and implemented Tableau Business Intelligence reports.
  • Create basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
  • Executed and tested required queries and reports before publishing dashboards.
  • Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes. Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
  • Manipulated document properties to alter visuals, data tables, filters and markings via property update and Python based customization and interactivity.
  • Converted user requirements into prototypes and wireframes.
  • Used SQL to create custom queries and information links.
  • Created customized dashboards via Python scripting
  • Data blending with multiple data sources, Tableau data objects using SQL queries. Dashboards using interactive parameters, filters, sets, charts and table calculations.
  • Created dashboards, reports with Bar Charts, Scatter Plots, Map Chats, Pie Charts, Cross tables and Graphical tables using the key concepts like filtering scheme (Global Filter), (Local Filter).
  • Created Dynamic Visualizations using advanced Trellis, Scatter plots, 3D Scatter Plots, Map charts and Tree Map, Text Area, Input Field, Lists, drop down lists, Property, Document Properties, On-Demand Data and In-Database.
  • Built Power BI apps on various data sources such as flat files, SSAS OLAP Models, MS SQL database, Google Analytics, SAP BW etc.,
  • Develop reports using DAX skills to create and troubleshoot complex calculations and measures.
  • Use Microsoft Power BI and Microsoft Excel Pivot Tables, Power Query and Data Models to gather information from multiple sources and deliver information to the end user.
  • Developed dashboard reports for 360 ecommerce Order Management and extended reporting solution to the various organizations within CMC.
  • Developed Track and Trace application and embedded the Power BI reports to track the carriers sent across North America and provide a live view of the carriers.
  • Design and develop Power BI apps and distribute using content packs and app workspaces.
  • Create data flows and apply transformations to convert the Material master data from Gerdau to CMC on the Gator project using SAP Data Services.
  • Developed and Managed Co-Existence & conversion Programs for Program Mercury using BODS, BAPI, LSMW & IDOCS.
  • Create reports and dashboards using SAP Business Objects, Tableau, Microsoft Power BI and SAP Business Warehouse (BW) to support the reporting requirements.
  • Provide technical support to the end users in the form of troubleshooting guidelines and modifications to the system after it has been delivered and the end users and client representatives at this stage of the SAP BI software life cycle.

Environment: SAP Business Objects Business Intelligence Platform 4.1 SP4, SAP HANA, Google Analytics, MS-SQL Server 2016/2014/2012/2008 R2, SSAS, MS Power BI, Web Intelligence, Analysis for OLAP, Dashboards, BEx, SAP BW.

Confidential, Inver Grove Heights, MN

Sr Business Intelligence Analyst/Developer

Responsibilities:

  • Gathered the functional requirements from the Business users, Business Process Owners to build the Functional specifications and ensure the accuracy of the reporting specifications.
  • Worked with the Business users to refine the reporting requirements for PFI (Processing foods and Ingredients) reporting for the SAP Implementation.
  • Built various reports such as Consolidated P&L, PFI Flash, Cost Center Summary, Overhead Analysis, SG&A etc., for the FTM (Finance to Manage) team.
  • Build the Production variance and the pricing variances for product costing using SAP Hana & Web Intelligence.
  • Leveraged the Hana direct connectivity to WebI and built ad-hoc and standard reports based on the reporting requirements.
  • Supporting the existing WebI reports based on BW environment.

Environment: SAP Business Objects Business Intelligence Platform 4.2 SP2, SAP HANA, Web Intelligence, Analysis for OLAP, Dashboards, BEx, SAP BW.

Confidential, Hopkins, MN

Sr Business Intelligence Developer

Responsibilities:

  • Gathered the functional Requirements from the Business users, Business Process Owners to build the Functional specifications, ensure the accuracy of the reporting specifications.
  • Develop the Analytic, Attribute and Calculation views for the Strategic Portfolio Dashboard and Innovation Dashboard.
  • Develop the Hana models for measuring various key performance indicators for Confidential Business Services and made them available for reporting via Business Objects, Tableau, Power BI and other reporting tools
  • Worked on different SAP reporting tools including HANA, IDT, UDT, Web Intelligence, Dashboards, Design Studio, Lumira and Crystal for Enterprise.
  • Build Universes in the Information Design Tool using a relational Connection on top of the SAP HANA models, Oracle and SQL Server databases
  • Created different reports such as On demand, Ad Hoc, Summary reports, Sub Reports and Cross Tab reports to serve the user needs
  • Extensively used Web Intelligence to build complex reports from multiple data providers using Merge Dimensions, Calculation contexts and various features of WebI
  • Created Data Restrictions on the underlying tables used by the universe using Data Security Profiles in Information Design Tool.
  • Designed and developed kpi dashboards using SAP Design Studio 1.5
  • Designed and developed Confidential Transportation and Logistics Dashboard using Bex Queries and SAP Dashboards.
  • Customized the CSS files for the Design Studio applications based on the dashboard requirement. the IT team on leveraging the SAP Design Studio to build the responsive dashboards on the SAP Hana live views.
  • Design Master /detail Dashboards with Design studio by connecting to BEx queries and customized CSS for enhancing the visual appearance of the applications.
  • Developed a bi weekly dashboard, Production Assurance Dashboard, to review the ITIL metrics using excel xml maps published from an access database.
  • Used Central Management Console (CMC) of Business Objects Enterprise to maintain reports scheduling tasks
  • Responsible for BO Universe & Reports in different testing methodologies like Unit, System, UAT, Performance, Updating the defect logs, finding solutions, conveying messages between the Development and the QA teams.
  • Involved in the requirements gathering sessions and provided the feasible solutions to the users based on the requirements.
  • Set up Power BI Enterprise Data Gateways to build reports against various data sources.
  • Built power BI reports and dashboards for Finance Shared Services to track the performance of the Reporting Units
  • Set up and maintain the Workspace groups on power BI service to share the reports and dashboards with the business users.

Environment: SAP Business Objects Business Intelligence Platform 4.1, Business Objects 3.1, SAP HANA, Web Intelligence, Crystal Reports, Dashboards, BEx, SAP BW, Relational databases and SQL, Microsoft Power BI, Tableau 9.x/10.2

Confidential, San Diego, CA

Sr Business Intelligence Consultant

Responsibilities:

  • Gathering the requirements for the reporting solutions to be built in Web Intelligence, Dashboards, Crystal for Enterprise, Explorer and Analysis for Office.
  • Involved in different phases of the project like analyzing requirement, planning, execution and maintenance.
  • Working closely with business in creating dashboards based on the data from various Data sources.
  • Worked as Tableau SME in migrating the dashboards from Excel reports and Business objects to Tableau Dashboards.
  • Developing Tableau data visualization using Donut charts, Waterfall, Cross Map, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Dual axis, Triple axis, scorecards, dashboards using stack bars, scattered plots, Gantt charts and various other charts based on the business desired.
  • Strong report/dashboard design experience and passionate practitioner of effective data visualization.
  • Extensively participated in the requirements gathering phase for the project and closely worked with the other teams to extract data from different sources.
  • Designing and building of Universes, Classes and Objects based upon revenue, cost, performance and customer management systems.
  • Resolution of loops, fan traps, chasm traps using contexts and aliases and its combinations, checking of cardinalities, maintaining integrity of the Universes.
  • Integration experience of SAP HANA with Tableau for high performance Visualizations, Dashboard analysis
  • Worked also as a Data Analyst in documenting the report specifications, interacted with Business Analysts and End Users and gathered technical/functional requirements to develop standard and ad-hoc reports.
  • Created Exploration views on top of Billing and COPA cubes as per the user requirements.
  • Created the base reports for the Ops Flash Dashboard and P&L Scorecard, to leverage the BI Web Services to build the dashboard.
  • Designed Complex reports using sub reports, dynamic cascading prompts for parameter passage, manual cross tabs using Crystal syntax with extensive usage of Local, Global and Shared variables at report formulae.
  • Promoting various reports across the Development, QA and Production environments using LCM (Life Cycle Management Tool).

Environment: SAP Business Objects 4.0 SP4/SP5, Tableau Desktop8.x, Dashboards 4.0, Crystal For Enterprise, SAP BW 7.3, HP Mercury Quality Center 9.2.

Confidential, Sunnyvale, CA

Sr. SAP Business Objects Developer

Responsibilities:

  • Coordinated with the DBA to identify the data needs and extracting the data to the database.
  • Responsible for creating the reports (On demand, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical, etc.) for SCE Business users using Webi, Crystal, and integrating Xcelsius 2008 with Reports by passing parameters to address the business questions.
  • Designed Complex reports using sub reports, dynamic cascading prompts for parameter passage, manual cross tabs using Crystal syntax with extensive usage of Local, Global and Shared variables at report formulae.
  • Created Balanced Scorecards using KPIs (Key Performance Indicators) to access the quality of execution and consolidated multiple reports into a single dashboard.
  • Promoting the reports, folders and user security across various environments, i.e., from Sandbox, Dev, QA and production using the Life Cycle Manager.

Environment: ), SAP Business Objects Enterprise 4.0, Web Intelligence, Dashboards, Oracle, SQL Server, HP Mercury Quality Center 9.2

Confidential, Hershey, PA

SAP BO/BI Developer

Responsibilities:

  • Gathered the functional Requirements from the Business users, Supply Chain Analysts, Business Process Owners to build the Functional specifications, ensure the accuracy of the reporting specifications.
  • Developed flexible queries using filters, navigational attributes, variables in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
  • Designing the Universe for the Supply Chain Dashboard and Scorecards.
  • Developed several Complex Reports (various features included multiple groupings, drilldowns, parameter fields, formulae and conditional formatting) using Crystal Reports.
  • Developed the POS reports in crystal for the POS team to understand the daily statistics of the sales for each Merchant product category.
  • Created and scheduled the publications to distribute the POS reports to specific merchant daily.

Environment: Windows Server 2003/XP, Business Objects Enterprise XI R3.1/4.0, Teradata, SAP BW 3.5, Xcelsius 2008, Business View Manager

Hire Now