- As a CFS team member, interacted with Functional/End-users to gather requirements for Core reporting system.
- By understanding Exceptional features and User expectations for reporting system, by designed Business Requirement Packages (BRP's) to successfully implement Business logic.
- Worked in Tableau environment to Create dashboards including weekly , monthly , daily reports.
- Utilized Tableau Desktop to publish them to server
- Managed Production, Test and Development environments including installation of patches, security administration and access controls.
- Involved in writing complex business rules for populating dimension tables, fact tables, and Aggregate tables.
- Resolved the loops using Contexts and checked the Integrity of the Universes.
- Exported the Universes to Repository for making it available to users
- Created complex reports like Detail level Transaction reports, monthly Aging, YTD cash goal reports,
- Created Quarterly reports by creating multiple queries, sub queries, and merged dimensions, ranking features in single report.
- Created Complex workbook to visualize Wal-Mart & Target sales using scattered plots , bar charts by tableau desktop
- Applied Multi-dimensional analysis such as slice and dice, drill functions at report level.
- Created Workbooks and dashboards for analyzing statistical billing data using Tableau 6.0
- Identify risks associated with the testing strategy, then document and communicate such risk to stakeholders
- Involved resolving Error's in the reports like context error, Syntax errors, Multivalve Error, Timeout errors,
- Created custom Function's (Date range, Time functions, array functions, and Conditional formatting functions in the reports.
Environment: Rich Client, Info-View Web Intelligence, CCM, CMC, Designer, Crystal Reports XI, Crystal Xcelsius 2008, SQL 2008, Oracle 10g, SAP LOGON GUI 7.10 (FSCM ERP R/3), ECM Live link workspace, Import Wizard, Microsoft Excel 2007, Tableau 6.0