We provide IT Staff Augmentation Services!

Resume

4.00/5 (Submit Your Rating)

Tableau Architect Bi, ConsultanT

SUMMARY

  • A Tableau certified BI architect - cum-developer, an experienced BI Manager with specialization in data analysis, BI environment design, performance reporting, KPI dashboards and data visualization.

PROFESSIONAL EXPERIENCE

Confidential

Tableau Architect (BI Consultant

Responsibilities:

  • Accomplishments along Tableau Dashboarding activities:
  • Liaised with Confidential Marketing, Store Operations, Merchandising, and with the Customer Loyalty departments. Established relation & trust with the business groups while pursuing & delivering projects
  • Created various dashboards for Marketing, Store Operations, Merchandising, and Customer Loyalty groups
  • Implemented Row level security,enabling the hierarchy within organization to utilize same dashboard, but, only see the level of data that their hierarchy was authorized to
  • Created an intranet embedded dashboard for field offices while providing them “Click to export PDF” functionality
  • Developed automated system to export views/dashboards into PDF and email to list of select users on a specified schedule. (Using TabCMD & PowerShell)
  • Developed complex calculated fields (using LOD calcs, Table Calcs, Windows Calcs, etc) for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports
  • Blended data from multiple data sources into one report; upgraded to cross database joins
  • Updated existing dashboards to utilize Extracts and implemented full vs incremental refresh logic
  • Created mobile dashboards for MUSA specific Samsung Galaxy tablets for field managers
  • Experienced in reports & server performance optimization (Using both Tableau performance recoding, dektop side, as well as server side; auditing the dashoard designs for performance; query & extracts optimization etc to identify bottlenecks and reduce latency)
  • Conducted Tableau training sessions for the business users with Tableau desktop licenses, around how to design efficiencies, and publishing best practices
  • Accomplishments at MUSA regarding Tableau Admin activities include:
  • Conducted initial research & planning sessions, requirement elicitations around short term use and future growth modeling to architect the hardware environment for Tableau
  • Deployed a new Tableau Server environment; upgraded Confidential from Tableau 9.3 to 10.1 (later on patched to 10.3, subsequently upgraded to 10.5). The implementation was across Dev,Test, and Prod environments (following SDLC process). Also decomissioned Tableau 9 environment
  • Set up, configured & maintained on premesis distributed Tableau server infrastructure
  • Set up TabJolt for load testing the Tableau dashboards before migrating them over from Tableau 9 to 10
  • Configured Tableau server for Active Directory authentication, and implemented SSL certificates
  • Maintained Security by creating/managing user accounts, user groups, and Licenses
  • Proficient in using TabAdmin & TabCMD
  • Automated periodic backups, log cleanups of the tableau server for disaster recovery and business continuity plan
  • To monitor Tableau server performance, implemented TabMon and connected with Tableau’s Postgres SQL database and built the Admin View dashboards
  • Interfacing with Tableau support group for any support requests tickets
  • Created SOPs and best practice documents for development and administration of the tableau Platform

Confidential

Consulting Manager, BI & Analytics

Responsibilities:

  • Managed a team of BA, Data and Tableau consultants to provide end-to-end solutioning, while interfacing daily with stakeholders and organized on/off-shore operations
  • Working at Sogeti managed projects for the client “ Confidential & Confidential ” (JNJ), multinational medical devices, pharmaceutical and consumer packaged goods manufacture.
  • Implemented multiple BI & Analytics projects at JNJ, encompassing data ETL activities to bring data from various data sources into Enterprise Data Lake (EDL), developing Tableau dashboards and reporting automation systems
  • Engaged in new project pursuits, leads, and creating POCs
  • Conducted Tableau workshop(s) and training session at Confidential & Confidential
  • Regarded as the highest point of escalation for the complex Tableau issues
  • Confidential & Confidential ( Supply Chain):
  • Confidential & Confidential OneMD Supply Chain Analytics group had handful dashboards built in Tableau. These views provided some intelligence about metrics, albiet marred with latency issues. Working with the department managers and my team’s efforts we successfully implemented OneMD v 1.0
  • Using performance recording & tuning implemented industry best practices in the environment.
  • Consolidated 12 of existing dashboard views into one interactive 2-sheets view that facilitated a systemetic flow with and provided a succinct story(Implementation of Context filters, Action/URL Filters, dynamic Tooltips, Drill down, utilizing Top-N )
  • Upgraded their dashboard environment from Tableau 9.2 to 10.1.
  • Implemented JNJ corporate color palettes, and logo schemes
  • Utilized Device-Designer and implemented the mobile versions of the dashboards for field analysts on the go (iPad, iPhone, and Android)
  • Full service solution implementation using Tableau TabCmd & Python scripting (pdf report generation)
  • Confidential & Confidential ( GSD Ops Support):
  • Working in RAD and JAD environment with the client, set up the roadmap for their performance metrics
  • Ddeveloped GSD Operations Metrics Dashboard and Implemented Support groups KPIs in dashboard that was later on implemented and used across the globe in over 100 countries

Confidential

Reporting Lead, Sr. Business Analyst

Responsibilities:

  • Liased between DISH IT VMDev team, Programming, Product Development and Rentrak for viewer measurement enumeration, operational activities, as well as new developments
  • Managed a small team of data and business analysts
  • Managed relation with Rentrak/ComScore to ensure DISH set-top-box data is collected, processed, and viewership ratings are calculated accurately. Also responsible for calculated management of annual expense budget of $375K used for new development at Rentrak by ensuing higher ROI dictates the projects priorities
  • Tableau qualified associate, dashboard and reporting specialist; Managed, designed and executed ad campaign performance reporting across all ad products; identified KPIs and developed & operationalized Tableau dashboards
  • Automated the Media Sales national addressable campaign reporting by creating a self-service Tableau solution for account executive & sales staff; saving department 15+hrs/week in time
  • Automated political addressable campaigns reporting merging DISH and Confidential data doing business under “D2 media”. Utilized Rentrak addressable API to load DISH and Confidential data into Netezza and using Tableau dashboards to present D2 media summary campaign reports
  • Conducted quantitative and qualitative ad-hoc analyses on ad promo effectiveness and viewers’ behaviors to optimize ad buying, and built case studies to support marketing presentations
  • Well versed in BI tools (SQL, Hyperion, Merced, Tableau), data analysis (SPSS, Monte Carlo Simulation, Advanced in MS Excel), data warehousing (Netezza, Teradata, Hadoop), and PM methodologies
  • Full life cycle implementation experience in data warehouse as well as enterprise software projects (front-end, frameworks, middleware SOA, and back-end integration)
  • Primary interface between IT developers and business executives: from eliciting project requirements, identifying areas of opportunities & improvement, creating ROI, project scoping, and securing sponsorships/approvals to project execution, monitoring, UAT, and its implementation
  • Managed, led & mentored a team of junior PMs & Business Analysts
  • Developed in house lunch and learn program for the DISH IT teams by bringing on SMEs from various technological backgrounds and conducted 25+ sessions during 1.5 year

Confidential, Houston TX

Sr. Manager

Responsibilities:

  • Built an analytics team focused on Custmer Service division (Contact Centers) performance reporting
  • Developed new reporting tools & dashboards to provide an effective and efficient data delivery with meaningful analysis and insight into trends
  • Created balanced site scorecard and developed a pay-for-performance matrix for call center agents
  • Using regression models in SPSS reverse engineered average handle time (AHT) goals by type of customer calls/issues and shaved 3 seconds off agents’ AHT resulting in $3MM saving per year
  • Conducted an ad-hoc study and statistical analysis of attrition in customer service call centers, and made recommendations to the executive team around attendance policies and hiring practices
  • Acted as liaison between Operations Team and vendors for a strategic planning, development and rollout of a universal web based performance management tool, MERCED
  • Worked with IT and call center site leadership teams in rolling out the new application releases
  • Managed a direct staff of 8 managers, with responsibility for 800 employees across all shifts of 18 hours a day staffed advanced tech call center
  • Reduced center’s cost per minute from 60¢ to 44¢ by implementing creative scheduling, AHT reductions (by 3 seconds), and successful launch of integrated outbound/inbound routing logic
  • Improved center’s attendance from 84% to a record high 92% by developing new procedures, implementing new staffing model and incentive programs for employees. Implemented agent self-service for schedule/shift bidding, improving morale and schedule compliance
  • Introduced employee referral program coupled with employee training/career-pathing, improving candidate quality and lowering attrition by 7%
  • Responsible for producing call volumes forecast, and creating staffing plans to meet staffing needs
  • Liaised with IT and created SOPs for workforce management that were implemented across all O&O Call Centers resulting in higher efficiencies and consistency
  • Improved schedule compliance from 60% to 85%, reducing annual workforce costs by $0.25MM
  • Successfully led the enterprise rollout of eWFM ASPECT & RTA along with a complete overhaul of IVR
  • Created international language outbound department of 50 heads, created processes, and managed outbound campaigns for Sales, and retention; integrated with Chat & e-Care to improve occupancy

We'd love your feedback!