SUMMARY:

• 10+ years IT experience in the areas of Data Warehousing and Business Intelligence
• Around 10 years of MicroStrategy Development, administration and Architect experience including installation, configuration and designing in large - scale enterprise environments.
• 10 years of experience in using MicroStrategy Desktop/Developer, Integrity manager, Object manager and command manager tools.
• Proficient in MicroStrategy Design, Architecture and administration on Linux and AIX platforms
• Proficient in managing MicroStrategy Report and Schema layer, I-server and web server.
• Having nearly 10+ years of experience with design, development of OLAP and data Confidential systems like MicroStrategy and Informatica.
• Experienced MicroStrategy Architect, Administrator & Developer and has experience in leading and co-coordinating with offshore teams by handling multiple assignments and multiple technologies (MicroStrategy and Informatica) simultaneously.
• Designed MicroStrategy architecture and created dashboards Including MicroStrategy mobile.
• Worked on MicroStrategy upgrade from 9.2.1 to 9.3.1 including AIX to Linux conversion, Oracle to SQL server Metadata conversion, Metadata creation & Mobile SDK customizations.
• Worked as MicroStrategy Mobile Report Developer, Architect and Administrator.
• Performed upgrade of MicroStrategy production environment (AIX) from 9.0.2 to 9.2.1 at McDonald’s.
• Implemented Distribution services as alternative for Narrowcast services.
• Created MicroStrategy Mobile reports for top level executives and emailed reports to iOS supported devices using Distribution services.
• Good experience in MicroStrategy platform administration using MicroStrategy desktop, Intelligence Server, Web server and Narrowcast server.
• Good experience in performance tuning which involves reports and intelligent cubes, scheduling, user management, and security management.
• Good experience in developing, deploying and supporting projects that use MicroStrategy intelligence server
• Good experience in supporting MicroStrategy production applications and environment.
• Extensively worked on MicroStrategy Desktop, Object Manager, Command Manager, Integrity Manager, Enterprise Manager, Distribution Services, Scan MD, Mobile and web.
• Worked with Intelligence server (AIX), Web server (AIX) and Narrowcast server
• Worked with MicroStrategy Intelligence server, involved in Managing Users, User Groups and Administration of security.
• Implemented Multisource feature in 9.0.2 to improve database performance Created and configured new projects in production environment
• Created Command manager scripts for user management and configuration objects management
• Experience in creating Dashboards that can provide an insight analysis on the business for senior management
• Trained key end users on Distribution Service and QA resources on MicroStrategy web functionality and usage.
• Knowledge of Teradata, Oracle 9i, PL/SQL and data warehousing methodology and Architecture
• Having good knowledge and experience on Informatica and worked on ETL testing using Informatica and datastage.

TECHNICAL SKILLS:

OLAP Tools: MicroStrategy 8.x, 9.x & 10.x.

Analytical Tools: Tableau 9.X

ETL Tools: Informatica 9.6.1, 9.5.1, Data stage

Operating Systems: Windows-98 / 2000 / NT/ XP, 7, UNIX.

Databases: Teradata, Oracle, PL/SQL, SQL Server, MS ACCESS.

PROFESSIONAL EXPERIENCE:

Confidential

Environment: MicroStrategy 9.x, Informatica 9.5.0, Teradata & Oracle

Responsibilities:

• Assist in the gathering, analyzing, and documenting of requirements with Business
• Provide transition of requirements to BI Project Architect
• Conduct Peer review of Architecture & Design for development standards
• Review Migration list and work with admin team to prioritize requests
• Update/Review standards for MicroStrategy development life cycle
• BI Architect Build Roles and Perform POC activities on new technologies where applicable
• Provide BI technical solutions to meet requirements
• Worked on free form SQL reports

Confidential, Oakbrook, IL

Environment: MicroStrategy 8.x and 9.x, Teradata

Responsibilities:

• Worked with MicroStrategy premium support to resolve technical issues.
• Conducted Integrity manager testing across different environments.
• Designed MicroStrategy mobile reports for executive users like McDonalds CEO.
• Executed performance tuning, user management, and security management.
• Worked on MicroStrategy SDK including Web and Mobile SDK customizations.
• Worked with Teradata DBA for cubes performance and schedules.
• Conversion of metadata from Oracle to SQL server.
• Upgraded MicroStrategy production environment and projects from 9.0.2 to 9.2.1.
• Implemented Distribution services as alternative for Narrowcast services.
• Created Mobile version of Distribution service reports.
• Involved in MicroStrategy upgrade and validations from 9.0.0 to 9.0.2.
• Implemented Multisource feature in 9.0.2 which requires different setup for databases
• Created project & configuration objects required for new project, and configured new project with DBI, DB connection, connection maps, security roles, security filter and EM statistics
• Implemented new security for global market users and US market users
• Created Time based and event based cube schedules for better performance of the reports
• MicroStrategy Enterprise Manager setup to capture statistics of report and server usage
• Extensively involved in MicroStrategy object migrations from one environment to another environment like dev to test and prod.
• Extensively involved in Narrowcast object migrations from one environment to another environment
• Scheduled narrowcast reports to distribute through email to executive users
• Performed project backups and duplications in to different databases
• Created users and involved in Administration of ACL and security
• Implemented new security setup in all environment
• Created users in MicroStrategy using Command Manager.
• Created Command manger scripts to create DB logins and connection maps
• Created Command manger scripts to cleanup unused DB logins
• Created users in Narrowcast subscription portal using Command Manager.
• Involved in updating services for Narrowcast subscription portal and other services.
• Created services, schedules in Narrowcast Server and executed narrowcast services.
• Involved in Managing Users, User Groups and Security Filters.
• Worked on Scan MD for resolution of metadata inconsistencies.
• Troubleshooting MicroStrategy report data issues and performance issues.
• Troubleshooting Intelligence Server and Narrowcast server issues.
• Troubleshooting Enterprise manager data load issues.
• Providing 3rd level support for technical issues and troubleshooting report design.
• Experience in administration of Micro Strategy Web and Intelligence servers across multiple environments.
• Experience in supporting multiple business customers and multiple MicroStrategy projects.
• Monitoring servers and involved in cleanup activities related to Intelligence and web servers.
• Changed server level settings to overcome end user issues with caches and History lists.
• Provided solutions to users to get rid of cache and History list issues
• Created Enterprise Manager Reports for executive management.
• Co-ordination with portal engineering teams and AIX server teams based on different requirements
• Co-ordination with off-shore teams for performing maintenance activities.