SUMMARY

• Datawarehousing developer specialized in MicroStrategy Architecture, Development and Administration.
• 6 years’ experience in implementing various Business Intelligence reporting solutions using MicroStrategy reporting suite.
• Has gained client reputation as a trusted team player and ability to solve complex technical problems.
• Developed solutions in Finance, Retail, Banking and technology domains on both large and small scale end to end MicroStrategy implementations.
• Versatile in agile and traditional approaches of software development process.

TECHNICAL SKILLS

BI Tools: MicroStrategy 10.3/9.x/8.x (Administrator, Desktop, Intelligence Server, Architect, Web, Visual Insight, Object Manager, Integrity Manager, Narrowcast Server, Enterprise Manager, Distribution Services, MicroStrategy Office), Spotfire,Tableau.

Database: Oracle, SQL Server, Teradata, Netezza, HP Vertica, DB2

Scripting: SQL, Python, Hive, Pig

PROFESSIONAL EXPERIENCE

Confidential, Dallas

MicroStrategy Consultant

Responsibilities:

• MicroStrategy developer responsible to developing, deploying and supporting MicroStrategy reporting solutions pointing to Enterprise datawarehouse in Netezza database.
• Gathered and documented end user requirements from business users. Created mock ups of requirements to match the user needs
• Responsible for implementing new reporting projects and day to day support activities. Supported Finance, Marketing and HR teams
• Created MicroStrategy Self Service BI adhoc environments using Visual Insights which enables users to create their own visualizations
• Developed MicroStrategy dashboard suite for marketing users to report campaign metrics. Used Intelligent cubes and multiple visualizations and widgets
• Developed MicroStrategy schema by mapping to data model. Build attributes, facts and hierarchies
• Involved in data modelling to support MicroStrategy reporting. Build data model using ER modelling tools
• Wrote Freeform SQL to support certain temporary requirements
• Optimized reports by fine tuning queries using MicroStrategy VLDB settings
• Worked wif offshore working team to explain client requirements and develop reports.
• Developed MicroStrategy dashboard in Mobile environment
• Participated in project that migrated from MicroStrategy 9.4 to 10.2 version.
• Monitored the usage statistics about objects, reports, and user sessions by using Enterprise Manager. Wrote command manager scripts to clean up unused reports
• Unit tested the reports developed by the other developers
• Migrated reports from Tableau environment to MicroStrategy

Environment: MicroStrategy 10.3/9.4 (Desktop, Architect, Web, OLAP Services, Administration), Vertica, Oracle, Windows, Linux

Confidential, San Jose

MicroStrategy Architect/Administrator

Responsibilities:

• Collaborated wif stakeholders to understand business needs and come up wif solutions that used MicroStrategy reporting solution. Documented business requirements, created wireframes and mockups to get business alignment
• Interacted wif multiple retail business departments including Buying, Inventory Planning, Marketing, Store Leadership, Finance and Creative
• Developed suite of MicroStrategy dashboards that were rendered using Visual insights that enabled self - service visualization. Build numerous intelligent cubes that feed the dashboard
• Migrated legacy reports and dashboards into MicroStrategy by re-architecting the and associated other reports objects to equivalent MicroStrategy objects leveraging powerful MSTR functionalities such as Attributes, Prompt, Filters, Consolidation and Custom groups.
• Served as the first point of contact for incoming data requests and systems questions from business users
• Experience wif data flow and process modeling, analyzing business requirements and translating to written architectural, design, and functional specifications.
• Project level administrator managing 3 different Microstrategy project environment.
• Build MicroStrategy environment in Amazon AWS cloud. Installed MicroStrategy software and configured metadata, build new project and set up schema
• Responsible for tracking, monitoring and reporting on all work wifin the Software Development area and efficient assignment and organization of work, scheduling and planning projects ad hoc requests and issues

Environment: MicroStrategy 9.0.1/9.0 (Intelligent Server, OLAP Services, MicroStrategy Desktop, MicroStrategy Web), AWS, Oracle Exadata, Windows

Confidential, Redmond

MicroStrategy Developer

Responsibilities:

• Involved in developing Metrics, Compound metrics, Condition Metrics, custom groups and Filters. Designed test cases for metrics validation and communicate wif offshore team for testing.
• Advanced experience developing complex MicroStrategy reports and Report Services Documents.
• Used extensive Prompts to design interactive reports in as per user requirements
• Performance optimization was done to existing reports and report response time was brought down remarkably.
• Provided technical support when users had trouble running reports.
• Maintained good interaction wif the project manager, team lead and the QA manager, by submitting change control on a regular basis, and providing justification for emergency fixes to the change management.
• Used analytical and governing settings in VLDB properties to tune the SQL and metrics involving nulls and zeroes.
• Responsible for tracking, monitoring and reporting on all work wifin the Software Development area and efficient assignment and organization of work, scheduling and planning projects ad hoc requests and issues

Environment: MicroStrategy 9.0.1(Desktop, Web, Configuration Wizard, Object Manager, Command Manager, Enterprise Manager), Sql Server 2005, Netezza, Windows

Confidential, Dallas

MicroStrategy Developer

Responsibilities:

• Developed weekly reports of employee activity and client satisfaction to monitor inTEMPeffective methods
• Experience wif data flow and process modeling, analyzing business requirements and translating to written architectural, design, and functional specifications.
• Project level administrator managing 3 different Microstrategy project environment.
• Excellent experience in analyzing and developing data cleansing strategy in the ongoing design of the data warehouse.
• Formulated and defined functional requirements and documentation based on accepted CMS user criteria.
• Building MicroStrategy objects (Attributes, Facts, Metrics, Filters, Prompts and etc) to support business process change or enhancements through projects.
• Excellent experience in analyzing and resolving bottlenecks in report performance.
• Experience in developing and using Pass through functions for complex reports.
• Provided various management levels wif reports, analysis time series graphs and pie charts using MicroStrategy Web.
• Used MicroStrategy Report Services to create highly formatted document for the analysis of UI/Report managers wifin CSC.
• Involved in educating Management staff on Microstrategy Architecture, techniques and testing procedures
• Fine tune MicroStrategy report performance by adjusting VLDB settings and other MicroStrategy parameters.
• Analyze SQL performance using database tools.
• Developed weekly reports of employee activity and client satisfaction to monitor inTEMPeffective methods
• Experience wif data flow and process modeling, analyzing business requirements and translating to written architectural, design, and functional specifications.
• Project level administrator managing 3 different Microstrategy project environment.
• Excellent experience in analyzing and developing data cleansing strategy in the ongoing design of the data warehouse.
• Formulated and defined functional requirements and documentation based on accepted CMS user criteria.
• Building MicroStrategy objects (Attributes, Facts, Metrics, Filters, Prompts and etc) to support business process change or enhancements through projects.
• Excellent experience in analyzing and resolving bottlenecks in report performance.
• Experience in developing and using Pass through functions for complex reports.
• Provided various management levels wif reports, analysis time series graphs and pie charts using MicroStrategy Web.
• Used MicroStrategy Report Services to create highly formatted document for the analysis of UI/Report managers wifin CSC.
• Involved in educating Management staff on Microstrategy Architecture, techniques and testing procedures
• Fine tune MicroStrategy report performance by adjusting VLDB settings and other MicroStrategy parameters.
• Analyze SQL performance using database tools.

Environment: MicroStrategy 9.0.1/8.1.2 (Intelligent Server, Desktop, Web, Office, OLAP Services), SQL Server 2008/2005, Windows XP.