Ankit Sharma

Proficient in installing, configuring and administration of Tableau server and performance tuning for optimization.
Experience including technical support, troubleshooting and monitoring of system usage.
Experience in connecting to different type of data sources.
Experince in creating Tableau Data Extracts, publishing to Tableau server and scheduling on demand to refresh the Tableau Data Extract to get the updated data from the data source.
Experience in the maintenace and scheduling of Tablea Data Extracts using Tableau Server and Tableau command line utility.
Experience in installing, configuring, upgrading the Tableau server.
Creating, users, groups, projects, sites on Tableau server.
Backup, data recovery and service restoration management & incident, problem and service outage management.

• Project: Mosaic
• Objective: Maintain application availability for business reporting while leading the team, Performing Reporting, testing, Quality assurance activities, and tracking
• The job responsibilities include resolving daily Issues, Monitoring and fixing data load issues daily, user training and documentation
• The project requires conducting duties using SAP modules like BW, Environmental Compliance, and Sustainability Performance management, SAC,
• BOBJ, HANA, BODS, Tableau & Spotfire
• Operating Systems: Windows Server
• Hardware: Azure Cloud, Windows server 2016
• Software / Special Tools: Business Objects, BO Data Services, HANA, SAC, Power BI
• Designed and managed SAP business objects, SAC, and HANA applications
• Used SAP Analytics Cloud, Power BI, and SAP BusinessObjects to design, develop, test, and implement business applications
• Installed and patched SAP BO 4.0/4.1/4.2 clustered configuration on RHEL/Windows
• Servers and a Visual Basic extension upgrade for SAP Design Studio and SAP Lumira
• Worked on automation of server availability & schedules to reduce manual efforts by creating advanced dashboards and reports for analyzing the application usage trend, report usage trend based on the business area, and system resources usage trend to identify the peak load time of the system
• Monitored & maintained the multi-server environment (Sandbox, Development, Quality & production systems) of SAP Business Objects, Business Objects Data Services
• Maintained Audit & CMS database for Business Objects system statistics analysis
• Managed and supervised authentication, authorization, job scheduling, publications, security, single sign-on with SiteMinder/SAML, and object migration
• Optimized SAC dashboards according to the business requirements
• Implemented row-level-securities, hierarchies, and complex calculations in SAC
• Created Power BI reports with hierarchies, parameters, buttons, and bookmarks as an
• Expert and implemented row-level security
• Worked with datasets, models and live universes
• Skilled in creating optimized datasets and creating measures & calculations using DAX functions
• Experienced in automation of server availability & schedules to reduce manual efforts
• Monitored & maintained the multi-server environment (Sandbox, Development, Quality & production systems) of SAC, SAP Business Objects, Business Objects Data Services & HANA
• Conducted knowledge sharing sessions at the organizational level with the team
• Prepared the sizing & resizing recommendation of the SAP Business objects servers based on the system resource usage trends.

• Project: Loblaw
• Objective: Project provides reports to large user base of client
• It is retail client and
• BO reports cover all store and management users so very high number of active users and a large BOBJ configuration to accommodate large user base
• Environments have to be managed well and fine-tuned for smooth functioning
• Software / Special Tools: Business Objects, SAS, Sybase SQL Anywhere
• Automated report schedule with CA workspace automation
• Configured alerts to the mailbox using the Monitoring tool and SMTP configuration
• Configured APS servers and reporting services according to the environment and user concurrency
• Deployed Web Application on the web server
• Identified limitations and drawbacks in the existing process and took those to resolution
• Installed patches and SAP HANA client on UNIX/Linux and Microsoft Windows operating systems
• Oversaw Reports scheduling, Migrations & Backup
• Created User access management to systems based on the roles of individual users within the enterprise
• Conducted the knowledge sharing session with teammates.

• Project: Enterprise Analytics
• Objective: BO HANA Migration project was basically for migrating Congo's and java reporting to SAP BusinessObjects
• TCS being a mammoth by itself, the volume of data is monstrous and so is the number of active users
• This calls for an efficient warehouse design and more importantly high availability of the environments as well as the proper administration of the BusinessObjects Environment for better performance of the Reports on desktop and mobile
• Operating Systems: Linux RHEL 6
• Software / Special Tools: BOBJ, Cognos, Informatica, Oracle 11G
• Managed the architecture of BusinessObjects
• Installed and configured & upgraded BusinessObjects 4.0/4.1 and maintained the multi- server environment to do the best tuning of the BusinessObjects Environment for performance management
• Developed complex reports, including queries, charts, drill-throughs and relevant hands- on administration
• Handled requirements analysis, design and selection of the appropriate BI tool based on user requirements
• Created advanced dashboards and reports drill down conditional rendering, prompts etc
• Using Report Studio, Dashboards, Crystal Reports, Webi
• Customized Mobile application according to organizational needs & configuration
• Implemented security in Business Objects, LDAP based authentication and authorization,
• Single-sign-on with SiteMinder
• Scheduled, Monitored and Supervised Jobs & publications
• Managed BusinessObjects reports access to users, report level securities, Migration of reports etc
• Maintained Audit & CMS database
• Created dashboards, Webi reports, crystal reports, design studio reports
• Provided L2 support on Informatica during ETL operations.