We provide IT Staff Augmentation Services!

Bi Analytics Engineer Resume

SUMMARY:

  • Expertise with Administration of Business intelligence tools like MicroStrategy and Tableau
  • 7 Years hands on experience as Microstrategy Administrator on Linux and Windows Environment
  • Expertise in installing, configuring, upgrade and Maintenance of Microstrategy Environment
  • Installed and configured Microstrategy environment 9.x, 10.x for 100k + users on Linux architecture and windows server 2008/2012 R2
  • Managing Microstrategy upgrades - upgraded Microstrategy intelligence server, metadata projects to the latest available version
  • Migrated Microstrategy platform to new hardware and consolidated small environments into a single consolidated environment which reduced saving millions in licensing & hardware
  • Create packages using Microstrategy object manager to migrate the objects changes to higher environments like UAT and PROD from DEV environment
  • Duplicating new project copies across environments using project duplication wizard and merging same projects using project merge
  • Automated scripts for BAU tasks using system manager and command manager
  • Integrating Microstrategy scripts with third party job schedulers like Autosys, JAMS, control+M
  • Installed and integrated R with Microstrategy
  • Installed and configured narrowcast server system
  • Upgraded the narrowcast repository from 9.x version to 10.x version
  • Migrating Narrowcast repository from one environment to a consolidated environment
  • Installed and configured the Enterprise Manager console and Project. Experience with handling data loads from command manager from 10.x version
  • Upgrade the Enterprise manager and statistics repository
  • Installed and Configured Microstrategy Web. experience with upgrading the Microstrategy web, installing D3 Visualizations, plugins, ESRI, Mapbox
  • Installed and configured MicroStrategy Office
  • Configured Microstrategy with various data sources like Composite, Netezza, Cloudera Impala, MySQL, SSAS cubes, Salesforce, Teradata, Informatica Data Services.
  • Configured MicroStrategy and Tableau to connect to Arcadia Analytical Views
  • Responsible for capturing the environment usage and performance statistics
  • Worked as production support engineer to resolve the issue in real time to make the environment available as per SLA
  • Experience in working with different operating systems like Linux, windows NT/ 2000/20 R2
  • Excellent communication skills and experience working with business user community and Microstrategy developers
  • Expertise with Installing and Upgrading the Tableau environment on Linux platform
  • Automated the scripts to install and configure Tableau environment for both single node and High available installations
  • Integrated Tableau environment with LDAP and SAML

PROFESSIONAL EXPERIENCE:

Confidential

BI Analytics Engineer

Responsibilities:

  • Installation and configuration
  • Upgrade Environment
  • Certify MicroStrategy suite
  • Certify Tableau Server on Linux
  • Standards and Benchmarking
  • Documentation
  • Architect and engineer solutions to enable Confidential to securely and efficiently utilize MicroStrategy Enterprise Reporting Business Intelligence Platform
  • Gather the application team requirements and based on Confidential standards design and develop Linux shell scripts to build the MicroStrategy Server package
  • Test the package built to validate and verify that it meets all the security standards along with application requirements
  • Certify the software package to be installed on Confidential Servers.
  • Document the Software Package deployment instructions and help application teams during deployment and maintenance
  • Validate all the new functionalities released by vendor to check for the vulnerabilities and propose solutions to integrate them with other enterprise tools
  • Develop code snippets using MicroStrategy software development kit (MSTR SDK) to customize the MSTR suite based on business or app team requirements
  • Automate the MicroStrategy platform installation and configuration to provide BI platform as a service
  • Develop Linux Shell scripts, MicroStrategy Command Manager, system manager scripts to reduce manual intervention
  • Worked on proposing the cross-border data regulations to make sure that operations team does not have access to any data that they are not supposed to see without disrupting their administrator access
  • Implemented Encryption Key Manager in MicroStrategy to encrypt the metadata, cache, cube, History list and session recovery files so that the sensitive data is protected.
  • Integrated MicroStrategy with CyberArk security for securing the MicroStrategy administrator, metadata and reporting database passwords.
  • Architect and engineer solutions to enable Confidential to securely and efficiently utilize Tableau on Linux Platform
  • Automate the Tableau software installation, TSM configuration and Topology set up using Linux scripts which would help end users to install the product seamlessly with minimal inputs and no human errors
  • Integrate Tableau environment with SAML to use it for Authentication and Integrate with LDAP to set up Authorization
  • Tableau server configured with Arcadia, Hive, Impala both to run as service account and as delegated user id

Technologies:

MicroStrategy v9.4.1, v10.2 HF1, v10.4 HF3, v10.4 HF5, v10.5, v10.7, v10.9, v10.11:

Tableau 10.5, 2018.1, 2018.1.1, 2018.3.2:

Databases: Oracle 9i, 10g, 11g r2, 12c, Netezza, MongoDB, Hadoop

Third Party Tools: SiteMinder, JIRA, ServiceNow, LDAP

OS: RHEL 5.x, 6.x, 7.x, Microsoft windows server 2008, 2012 R2

Confidential

Administrator and support engineer

Responsibilities:

  • Installation and configuration
  • Upgrade Environment
  • Simplify and Improve
  • Code Movement
  • Performance Improvement
  • Support and Maintenance
  • Documentation
  • Install and configure the Microstrategy suite so that developers can have readily available system to develop their reports
  • Upgrade the Microstrategy platform to latest versions released by vendor
  • Handle the Environment consolidation of various Microstrategy environments available into a single consolidated platform as part of SIM (simplify and Improve) effort
  • Maintain the application servers to identify and resolve the issues to make the environment available to users 24 X 7
  • Design application security model to comply with global information standards by assigning security roles and privileges based on the role and group to ensure data security and separation of duties
  • Deploy application code changes between DEV, TEST and PROD environments as per client’s change management standards
  • Design scripts to automate the day to day work and reducing the manual intervention which helped in reducing the cost to customer
  • Work on performance tuning to provide the best response time to users during peak times
  • Support liaison to work with vendor to resolve the issues identified and apply the patches provided by the vendor

Technologies:

Microstrategy v8, v9.3, v 9.4.1, v10.2 HF1, v10.4 HF3

Databases: Oracle 9i, 10g, 11g r2, 12c, Netezza, Teradata, Composite

Third Party Tools: Autosys, JAMS, Control+D, Remedy, SiteMinder, JIRA

OS: RHEL 5.x, 6.x, 7.x, Microsoft windows server 2008, 2012 R2

Confidential

Administrator and support engineer

Responsibilities:

  • Installation and configuration
  • Upgrade Environment
  • Simplify and Improve
  • Code Movement
  • Performance Improvement
  • Support and Maintenance
  • Documentation
  • Worked with Business units for requirements gathering, analyzing the requirements and functional separation documents
  • Installing Microstrategy environment for developing the LOB required custom reports
  • Configuring the Microstrategy environment and tuning the Intelligence Server and project to improve the performance
  • Installing the Microstrategy related security patches like Hotfixes and Patching for fixing the bugs reported by users
  • Managing Microstrategy Upgrades - upgraded the Microstrategy Intelligence Server, Metadata projects to the latest available version
  • Worked with ETL teams for coordinating the outage during refresh
  • Integrated the Microstrategy scripts with third party job schedulers like Autosys which will automatically take the project down during DB refresh and publishing the cubes and triggering subscriptions once data is synched
  • Documenting user manuals and users in effectively using the application for their business analysis and improvement

Technical Information:

Microstrategy v8, v9.3, v 9.4.1

Databases: Oracle 9i, 10g, 11g r2, 12c

Third Party Tools: Autosys, JAMS, Control+D, Remedy, Siteminder, JIRA

OS: RHEL 5.x, 6.x, 7.x, Microsoft windows server 2008, 2012 R2

Hire Now