PROFESSIONAL SUMMARY:

• Over 5.0 years of combined IT experience in business intelligence, client calls, requirement analysis, design, development, testing, implementation and support of various projects using BI Tools like Microstrategy and Databases like MS SQL Server, MYSQL.
• Very Strong experience in Microstrategy Administration activities like Object Migration, Tuning, Monitoring and Maintaining the MSTR environments, Scheduling (Time - based and Event-based),troubleshooting MSTR Reports.
• Good Exposure in Microstrategy Version Upgrade (v9.0.1, v9.3.1, v9.4.1, v9.8.1, v10.4)
• Experience of automation of various admin activities via Systems Manager and Unix scripts.
• Excellent hands-on experience in using tools like Microstrategy Desktop, Microstrategy Web, Object Manager, Integrity Manager, Systems Manager, Enterprise Manager, WinSQL, Scan MD Tool.
• Expertise in migration process across different environments Dev/QA/STAGE/Prod .
• Experience in working on various versions of MSTR v9.0.1, v9.3.1, v9.4.1, v9.8.1, v10.4.
• Experience on establishing SSO (Single-Sign-On) using various 3rd party tools in MSTR.
• Experience on establishing ODBC Connections using various mstr built-in as well as 3rd party ODBC connections.
• Very good Experience in Troubleshooting, Application Bottlenecks and performance tuning of MSTR Reports.
• Microstrategy Certified Platform Administrator v9.4.1
• Development of MSTR reports from complex business requirements.
• Testing MSTR reports using Integrity Manager tool as well as manual testing of MSTR reports.
• Ability to work through the entire development life (SDLC) cycle from gathering requirements through implementation, development, production, support and documentation of the complete project.
• Working knowledge of Agile Projects with Complex and rapidly changing requirements.
• Experience in Test Driven Development, Waterfall model and Agile methodologies like SCRUM.

TECHNICAL SKILLS:

BI Tools: Microstrategy v9.0.1/v9.3.1/v9.4.1/v9.8.1/v10.4, Tableau

MSTR Tools Used: Microstrategy Desktop, Microstrategy Web, Object Manager, Integrity Manager, Systems Manager, Enterprise Manager, WinSQL, Scan MD Tool, Operations Manager, License Manager, Command Manager.

MSTR 3rd Party Tools Used: IBM Tivoli Access Management, CA Siteminder, Oracle Access Manager.

Databases: DB2, SQL Server 2005/2008/2012 , MySQL

PROFESSIONAL EXPERIENCE:

Confidential

BI Reporting/ Web Developer

Responsibilities:

• Coordinate with clients for the requirement analysis and designed the website based on the requirements gathered.
• Design and develop the website using HTML, CSS, JavaScript.
• Developed various reports and embedded them in the website for the analysis purpose.
• Integrated email services in the website so that users can email their problems and suggestions on the go.
• Integrate the payment gateway with external API in the website for the payment links.
• Develop test protocols and plans for testing revised application and reviewed the test result.
• Involve in review meetings and improve the website design based on the review comments.
• Made appropriate changes accordingly to best suit the needs of the client.
• Configured and Deployed the applications on to the online system.
• Designed various technical and functional documents for the project.

Confidential

Microstrategy Administrator

Responsibilities:

• Complete ownership of all enhancements, maintenance and performance activities were delivered by my team under my guidance.
• Responsibility to upgrade dependent tools wherever needed and not available in appropriate versions.
• Setting up the process of daily data loads using command manager scripts instead of Enterprise Manager Tool in MSTR v10.4
• Created Unix Scripts to automate the administration tasks during upgrade.
• Establishing ODBC connections for databases.
• User group, User creations in MSTR Developer.
• Upgrading the entire MSTR environment from v9.8.1 to v10.4
• Troubleshooting the problems and issue encountered within the time frame limit.
• Updating the ODBC.ini file to support 64-bit drivers instead of 32-bit drivers.
• Re-Installing EM completely rather than upgrading it.
• Establishing SSO Server Authentication with 3rd party tools like IBM Tivoli etc.
• Controlling and maintaining the different environments at the specific levels.
• Weekly progress team meetings and effective knowledge transfers to the Application Maintenance teams.
• Testing all the phases of the upgrade and providing maintenance manuals for the same.
• Documenting the entire process for future upgrades.
• Accepting, creating change requests through ServiceNow tool.
• Knowledge Transition on various applications (ServiceNow) to the New Team members and helped colleagues in their work assignments whenever they were stuck with issues.
• Attended all client status calls and update them on project status on daily basis.

MSTR Versions Used: MSTR v9.8.1, v10.4

Confidential

MSTR Administrator

Responsibilities:

• Object Migration - Drag and Drop approach & Creating and importing packages.
• ACL (Access Control List) updates.
• Creating /Loading/Unloading/Duplicating Projects.
• Configuring MSTR Diagnostics Logs in Linux Server.
• Running ScanMD tool to fix any Schema related errors.
• Running Integrity Manager Tool for comparing MSTR reports.
• Running Command Manager Tools for various admin activities.
• Running Enterprise Manager project to collect statistics and improve performance of system.
• Automated admin activities like Object Migration (Dev-QA) using System Manager.
• Automated alerts for failed services and Intelligence Server crash via emails using System Manager, Command Manager.
• Created Schedules - Event & Time based for cube refresh, reports and documents to optimize the environment.
• Controlling and maintaining the different environments at the specific levels.
• Weekly progress team meetings and effective knowledge transfers to the respective teams.
• Knowledge on I-Server and project configuration settings.
• Developed various MSTR reports using Schema Objects as well as Public Objects.
• Attended all client status calls and update them on project status on daily basis.

MSTR Versions Used: MSTR v9.4.1, v9.8.1

Confidential

MSTR Administrator

Responsibilities:

• Testing all the phases of the upgrade both manual and through Integrity Manager and providing maintenance manuals for the same.
• Developed various MSTR reports using Schema Objects as well as Public Objects.
• Object Migration - Drag and Drop approach & Creating and importing packages.
• ACL (Access Control List) updates.
• Creating /Loading/Unloading/Duplicating Projects.
• Configuring MSTR Diagnostics Logs in Linux Server.
• Running ScanMD tool to fix any Schema related errors.
• Running Integrity Manager Tool for comparing MSTR reports.
• Controlling and maintaining the different environments at the specific levels.
• Extensive Knowledge on I-Server and project configuration settings.
• Upgrade of MSTR environments - v9.0.1 - v9.3.1 -v9.4.1 -v9.8.1
• Configuring of Enterprise Manager project for logging project statistics.
• SSO/ Server Authentication set-up and administration.
• Migrated Web Delivery Subscriptions from Narrowcast server to Distribution Services.
• Accepting, creating change requests through ServiceNow tool.
• Knowledge Transition on various applications (ServiceNow) to the New Team members and helped colleagues in their work assignments whenever they were stuck with issues.
• Attended all client status calls and update them on project status on daily basis.

MSTR Versions Used: MSTR v9.0.1, v9.3.1, v9.4.1, v9.8.1

Confidential

Software Engineer

Responsibilities:

• Working in a team to develop software for the company in java programming language.
• Introduced to BI concepts and tools like Microstrategy, OBIEE, Business Objects.
• Developed various reports in Microstrategy and OBIEE for an Business Analysis Project.
• Worked with the team to elevate technology and consistently apply best practices.
• Executed full software development life cycle (SDLC) in the project.
• Developed flowcharts, layouts and documentation to identify requirements and solutions.
• Analyzed, designed and developed test and test-automation suites.
• Executed well-designed, testable code.
• Produced specifications and determined operational feasibility.
• Evaluated user feedback and made changes to project accordingly.
• Provided ongoing maintenance, support and enhancements in the software development.
• Complied with project plans and industry standards.

Confidential

Software Engineer - Trainee

Responsibilities:

• Working in a team to develop software for the company in java programming language to automate the employee leave functionality and its various components .
• Collaborated cross-functionality with data analysts, business users, project managers and other engineers to provide effective solutions.
• Worked with the team to elevate technology and consistently apply best practices.
• Executed full software development life cycle (SDLC) in the project.
• Developed flowcharts, layouts and documentation to identify requirements and solutions.
• Analyzed, designed and developed test and test-automation suites.
• Executed well-designed, testable code.
• Produced specifications and determined operational feasibility.
• Integrated software components into a fully functional software system.
• Developed software verification plans and quality assurance procedures.
• Documented and maintained software functionality according to client requirements.
• Evaluated user feedback and made changes to project accordingly.
• Provided ongoing maintenance, support and enhancements in the software development.
• Complied with project plans and industry standards