Sr. Microstrategy Developer Resume
Woodland Hills, CA
SUMMARY
- 8 + years of IT experience in Business Intelligence(BI) Project Development and Implementation Using MicroStrategy 10.x/9.x/8.x Product Suites including Micro Strategy Desktop,Web,Architect,OLAP Services, Administrator, Intelligence Server, MSTR Administration - version upgrade, User Management, Security Filters, Statistical analysis using Enterprise Manager. Tableau 10/9.x
- Experience in creating Dynamic RSD’s and Visual Insight Dashboards using D3 Visualizations and custom widgets (both Web and Mobile)
- Developed interactiveTableauvisualizations after gathering Business Requirements, Interacting with the Users.
- Involved in Projects like Full Life Cycle Development of Data Warehousing, Project planning, business Requirement Analysis, Data Analysis, Logical Data Modeling, setting up Physical Schema, Data Marts, OLAP, Reporting and Security.
- Expertise in Working on Direct Project Source (Two-Tier) and Server Project Source (Three-Tier).
- Good Experience inCreating Schema Objects (Facts, Attributes, Hierarchies, and Transformations) to develop public Objects.
- 8+ years of experience in Data warehouse and OLAP applications.
- Experience in Hive/Pig and Hadoop Integration.
- Hadoop and Map reduce to MicroStrategy.
- Good Knowledge in Developing Application Objects (filters,prompts,metrics,Custom Groups, Consolidations,Drill Maps,Templates,Searches) to develop Documents and Reports.
- Hands on Experience in Creating Documents from multiple Datasets like Grid and Graph.
- System Optimization, performance monitoring and tuning experience in Multiple BI applications.
- Fine Tuning of the Micro Strategy Reports using VLDB properties, Aggregable Tables and Intelligent Cubes.
- Proficient in using RDBMS Such as Oracle and Teradata.
- Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
- Strong SQL Skills Related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.
- Good multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.
- Good Communication, Interpersonal, Analytical skills and Strong ability to perform as Part of the team.
TECHNICAL SKILLS
Business Intelligence: Micro Strategy 10/9/8.1.2 (Micro Strategy Desktop, Web, Intelligence Server, OLAP Services, Report Services, Narrowcast Server, Command Manager, Administration, Object manager, Command Manager),Tableau8.1/9/10.
ETL: Informatica
Languages: C, C++, SQL, PL/SQL.
Operating Systems: MS-DOS, Windows 98/NT/2000/XP/VISTA/7, UNIX and LINUX.
Web Technologies: MS Front Page, HTML.
Databases: Teradata, Oracle 10g/9i, SQL Server 2008 R2, Oracle SQL Developer.
PROFESSIONAL EXPERIENCE
Sr. MicroStrategy Developer
Confidential, San Antonio, TX
Responsibilities:
- Upgrade from previous version to latest versions (10.8)
- Creating Metadata security filters
- Handling Migrations from Dev-QA-Prod using object Manager
- Scheduling services through Distribution Manager and Narrowcast server
- User Management (Creation of users, Assigning security roles)
- Enterprise Manger
- Currently Working on Visual Insight dashboards which includes ESRI Maps and other D3 Visualizations
- Working on designing schematic layer for reporting purposes
- Developing MicroStrategy project from Inception
- SDK plugins for all visual cosmetic changes/Functionality Changes.
- Freeform definition reports for Transactional services
- Involved in gathering business requirement meetings and preparing BRD documents
- Involved in complete SDLC processes and scrum meetings.
Environment: MicroStrategy 10.8/10.4, Netezza, SQL Server 2012 R2, Windows XP, Erwin.
Confidential, Richardson, TX
Sr. MicroStrategy Developer
Responsibilities:
- Micro Strategy v10 Architect- build schemas and data cubes to be used by clients. Build in hierarchy and alias tables as needed.
- Coordinating with business users, ETL team and gathering requirements.
- Designing Logical data model which includes creation of Schema and Public objects
- Created various Dynamic Dashboard/documents for the business users with multiplepanel stacks, selectorsand customized widgets.
- Extensively used report services to create dashboards to create summary level reports using multiple datasets.
- Extensively worked on Dashboards and have utilized the new features to convert the dashboards into Flash mode.
- Designed and DevelopedMicroStrategy Dashboards using customized Widgets.
- Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
- MicroStrategy Mobile application configuration and development (Developing Transaction reports, Dashboards).
- Developed Transactional report services documents using Free Form SQL definition reports
- MSTR- Server configuration and maintenance.
- Upgraded MicroStrategy version from 10.2 to 10.4, installing HF on regular basis Narrowcast Services (Event Based and time triggered).
- Creating User groups, security roles, Meta Data security filters, Subscription and schedules (event and time based).
- Configuring and setting up Enterprise Manager for statistical Analysis.
- Using command manager for bulk operations, System Manger to create automating scripts.
- Objects migration and comparison using object Manager tool.
- Monitoring the server performance across the project servers using operations manager (like Memory Usage, Disk space, CPU etc).
- Managing large variety of user base by creating different user groups with different security filters.
Environment: s: MicroStrategy 10.2/10.4, Oracle 12g, Teradata, Linux, Tomcat. DataStage, Informatica.
Confidential, Woodland Hills, CA
Sr. MicroStrategy Developer (Architect, Admin & Lead)
Responsibilities:
- Lead, Develop and support several MicroStrategy projects Confidential UMG.
- Collecting business requirements from BA and Lead by understanding the Source System and translating them into report specifications for MicroStrategy platform.
- MSTR- Server configuration and maintenance.
- Managing large variety of user base by creating different user groups with different security filters.
- Responsible for gathering complex business and functional requirements and documented them into Conceptual Approach, Business Requirements, Functional Requirement, Detailed Design Document, and User Stories.
- Created schema objects (Attributes, Facts, Relationships between various attributes, Logical Tables, Drill Maps) to implement MicroStrategy Reports.
- Created Analytical engine bypass functions like Apply Simple & Apply Comparison, wherever necessary.
- Upgraded MicroStrategy environment from 9.3.0 to 9.4.1. Technical lead for the upgrade and the servers including I-servers, web servers, Narrowcast servers, Enterprise Manager, etc. Successful upgrade with zero issues.
- Performed MicroStrategy administration tasks like creation of users, groups, projects, workbooks and permission sets for MicroStrategy server logons and security checks.
- Regular Tuning of MicroStrategy reports for optimized performance using VLDB properties.
- Providing support to consultants, Technical Support engineers in creating and troubleshooting MicroStrategy SDK customizations.
- Experience in Hive/Pig No SQL languages and Hadoop Integration
- AWS Redshift Configuration and implementation.
- Handling issues and identifying bugs in the multiple database environments like- SQL Server, SQL Developer.
- Onsite training & demonstration for new business users and providing clarification to business users when and required.
- Offshore Coordination- Guiding and helping team in resolving complex production issues.
Environment: s: MicroStrategy 9.3.0/9.4.1/10.0, SQL server 2012 R2, Oracle Sql Developer, AWS Redshift, Informatica. Windows ERWIN, IIS Web server.
Confidential, Detroit, MI
Sr. Micro Strategy Developer/ Admin
Responsibilities:
- Designed and developed logical data model for MicroStrategy reporting environment.
- Identified source tables and columns required to create MicroStrategy project.
- Improved the performance of the reports by changing VLDB properties.
- Building reports on top of MDX Cubes.
- Created Ad-hoc Reports by drilling up, down, with across hierarchies.
- Developed different transformations which help business users to compare present data with previous year’s data in reports.
- Extensively used MicroStrategy Report Services to generate Report Documents.
- Modified the information displayed on the Prompt Question page by changing the layout definition file used by the prompt style that is applied.
- Migration planning and implementation with all supported service packs, hot fixes, and patches.
- Actively participated in developing Report Delivery Schedules. Modified VLDB Settings to tune the reports for faster execution.
- Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
- Experienced administrative capabilities; Project Setup (Installing, configuring, managing and controlling) and Project Lifecycle Management.
- Generated Freeform SQL reports writing SQL queries against different databases.
- Involved in troubleshooting of reports and eliminating cross joins in the SQL to produce correct results.
Environment: MicroStrategy 9.3/8.0.3, Teradata V2R6.1.1, SQL Server 2005, Windows XP, Erwin.
Confidential, Sunnyvale, CA
Sr. BI developer (MicroStrategy, Tableau)
Responsibilities:
- Gathered and analyzed relevant data and created Schemas that fit reporting requirements. Defined fact and dimension tables, created aggregate table for performance.
- Performed Requirement Analysis to collect various business measures and attributes to develop a reliableStar Schemaand requiredFactsandAttributes.
- CreatedAdministration Taskslike creatingUser Accounts, Assigning Privilegesand appliedSecurity Filters.
- Utilize in-depth knowledge of functional and Technical experience in data warehousing and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
- Extensively worked with MicroStrategy Desktop. Extensive experience in building filters, consolidations, transformations and custom groups, attributes, hierarchy, metrics, schema objects and prompts to generated reports meeting the Business Analyst needs.
- Developed reports, dashboards, SQL queries usingTableau.
- Synthesized and translate Business data needs into creative visualizations inTableau.
- PerformedTableauadministration tasks like creation of users, groups, projects, workbooks and permission sets forTableauserver logons and security checks.
- TunedTableaureports for optimized performance.
- Assistedwithbest practices during implementation and integration ofTableauPlatform.
- Collaboratedwithinternal stakeholders to drive efficiency and effectiveness of the metrics and reporting.
- Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions
- Provided various management levels with reports, Time series analysis and wide range of graphs using MicroStrategy Web.
- Worked in handling the MicroStrategy BI tools and Narrowcast Administration.
- Created various Monthly Dynamic Dashboard documents for Field marketing people with multiplepanel stacks, selectorsand customized widgets.
- Worked on Building Multidimensional Model, like multiple data sources including data warehouses, data marts, operational databases, and departmental databases.
Environment: MicroStrategy 9.0 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) MicroStrategy Narrowcast server, OLAP,Tableau7/8/8.1, Oracle 11g, Windows 2003, MicroStrategy Dashboard, Oracle.
Confidential, Morris Plains, NJ
Micro strategy Developer/Admin
Responsibilities:
- Worked with business analysts to baseline the reporting requirements.
- Worked with data architects on data needed for testing the reports and dashboards.
- Extensively worked with MicroStrategy architect to develop schema objects such as, attribute, facts, hierarchies, consolidations and transformations etc.
- Extensively used MicroStrategy Desktop to develop application objects such as reports, metrics, filters, prompts, custom groups etc.
- Createddrill mapsfor end users to drill down and recover data.
- Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basic using MicroStrategy Desktop and MicroStrategy Web.
- Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
- Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
- Worked on Creating Security Roles, MicroStrategy User Groups and Users, assigning security roles to Users and Groups.
- Designed and DevelopedMicroStrategy Dashboards using customized Widgets.
- Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
- Extensively used report services to create dashboards to create summary level reports using multiple datasets.
- Extensively worked on Dashboards and have utilized the new features to convert the dashboards into Flash mode.
Environment: MicroStrategy Desktop 9, MicroStrategy Web, MicroStrategy Administration, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MS SQL Server 2005, Windows Server2003.
Confidential
Software Engineer(MicroStrategy)
Responsibilities:
- Extensively worked on full SDLC projects to support MicroStrategy BI applications in Lennox Enterprise Data Warehouse.
- Gathered business requirement documents by interviewing users and translated them to technical requirements.
- Design data model and table structures in data warehouse using classical snow flake schema to support MicroStrategy reporting.
- Worked closely with ETL teams to understand data flow. Made recommendations to make the reports more efficient.
- Build a Leadership team MicroStrategy Android Mobile app that show that is drillable across multiple dimensions.
- Optimized MicroStrategy reports to run efficiently by using MicroStrategy Intelligent cubes, aggregates, VLDB settings and database optimizations.
- Architected and integrated data models to MicroStrategy schema to support self-service BI Adhoc environment.
- Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Facts, Filters, Metrics, Prompts, and Templates etc.).
- Created Dashboard with multiple panels and panel stacks with different selectors.
- Worked on debugging complex reports by identifying the issues and making appropriate changes.
- Involved in Code Optimization and Query Tuning to improve performance of the reports.
- Involved in UAT Testing and Defect resolution.
- Worked on Administration tasks like Creating user groups, Object Migration, Providing Access, Events and Creating subscriptions for scheduled deliveries.
- Proficient in writing pass through functions like Apply Comparison and Apply Simple.
- Worked with MicroStrategy Technical Support, and worked with them in finding the solutions and workaround for Product Related Issues.
Environment: MicroStrategy8.1/9 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) MicroStrategy Narrowcast server, ETL, OLAP, Windows Server 2003, MicroStrategy Dashboard, Teradata and SQL.