Microstrategy Developer
Resume:
Sandeep C
MicroStrategy Developer
*************@*****.***
Summary:
Around 5+ years of Professional experience which includes Design, Development, Data Visualization and implementation of MicroStrategy applications with proficiency in creating Attribute, Facts, Template, Filter, Prompts, Metric, Reports, Documents and Dashboards using MicroStrategy 10.4/10.2/9.4.1/9.3/9.2.1 and other lower versions.
Full life cycle implementation of MicroStrategy applications, which includes Business requirements definition, Create Schema Objects and Public Objects, Move them from Dev to QA and from QA to Production environment.
Experience in executing all phases of Software Development Life Cycle from Requirement Analysis to Go Live and support, meeting client SLAs and development of objects required post go-live.
Expertise in application and reporting development, including supporting processes and activities; project management, architecture and design, software development, testing, training, and all associated documentation.
Used Vertica database for BI type queries on Star/Snowflake schemas.
Extensive experience in Installing, Configuring and Using MicroStrategy tool Suite (MicroStrategy Intelligence Server, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Narrowcast Server, MicroStrategy OLAP Services and MicroStrategy Distribution Services).
Experience in user facing roles (Gathering Requirement, establishing project objective, leading meetings).
Preparing the Technical Specification documents, Developing.
Extensive knowledge on SQL/PLSQL.
Strong ability to analyze and debug SQL and recognize MicroStrategy query improvements.
Good Knowledge on MicroStrategy administrator tasks like object migration.
Extensive experience with Business objects by creating crystal reports, Dashboards.
Expertise in creating Schema Objects (facts, attributes, User Hierarchies, Transformations).
Expertise in Developing Application Objects (filters, metrics, prompts, Custom Groups, Consolidations, Templates, Drill Maps) to Build Documents and reports.
Expertise in creating MicroStrategy documents, Grid reports, dashboards for various business environments.
Experienced in building solutions to enable self-service BI by architecting Ad-hoc MicroStrategy schema.
Experience in Performance Optimization of MSTR Reports, using Intelligent Cubes for better performance and to reduce the load on Database.
Experience in creating Report Service Documents, pixel perfect Dashboards and Visual Insight analytics.
Used ITIL Framework while delivering the project.
Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
Worked closely with the MicroStrategy Admin teams during the project migrations and fixing the metadata issues and also in configuring the governing settings at the project level and on Intelligence server. Implementing effective caching strategy using linked templates and filters.
Supported various testing phases Unit testing, Performance Testing and UAT.
Expertise in the concepts of Data Warehousing, ER Modeling, Dimensional Modeling, Facts and Dimensional Tables.
Involved in training Business users on MicroStrategy Reporting, providing necessary documents and Support.
Experience with revamping existing dashboards to mobile and creating new mobile dashboards.
Good understanding of ETL technologies like Data Stage and Informatica.
Good knowledge of MicroStrategy Web and Web Administration.
Expertise in creating interactive Dashboard, Scorecards and Documents based on user requirements.
Worked on customizing and optimizing the query performance of report using VLDB properties.
Good knowledge in Star schema and Snowflake Schema.
Experience in creating time series transformations like YTD, MTD, and LY etc. using Transformations.
Well-Organized, Energetic, Quick learner, Team Player. Ability to adjust to new and challenging situations.
Excellent analytical, programming, written, verbal, communication and interpersonal skills and Leadership Qualities.
Created drill maps for end users to drill down and recover data.
Technical Skills:
BI Tools
MicroStrategy Desktop 10.4/10.2/9.4.1/9.3/9.2.1/8.1X, MicroStrategy Architect, Admin, MicroStrategy Web, Business Objects, MicroStrategy Intelligent Server, Visual Insight, MicroStrategy Narrow Cast Server, Distribution Services, Integrity Manager, Enterprise Manager, Project Source Manager, Connectivity Wizard, Object Manager.
ETL Tools
Data Stage, SSIS, Informatica.
Data Modelling Tools
Erwin, Toad
Databases
SQL Server2005/2008, Oracle, Teradata
Programming Languages
HTML, XML
Operating Systems
Window Server XP/2000/2008/2010
Query Tools
SQL server management studio, SQL Developer
Southern Company, Atlanta, GA June 2017 – Present
Role: Sr. MicroStrategy Developer
Responsibilities:
Effectively participated in Agile SDLC methodologies working with cross functional teams. Successfully demonstrated multitasking capabilities by involving in multiple projects and support initiatives.
Importing tables using Warehouse catalog and Creating Logical Tables.
Designed Interactive Dashboards in MicroStrategy Web to assess company's performance and monitored the overall goals of the business.
Created Proof-Of-Concepts for all reports and dashboards to double check the performance of the SQL
Reporting involves development of new Documents, Dashboards and Visual Insight dashboards
Extensively involved in data modeling to create attribute relationships, and hierarchies
Developed new reports and converted existing reports for the business line to satisfy the specifications.
Creating Dash Board Reports to view personalized reports based on company's requirements
Created different kind of Dashboards like Trend, performance summary, traditional metric, dynamic content in both the interactive & express mode.
Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets
Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
Generated and implemented MicroStrategy reports by creating projects, Attributes, Hierarchies, Metrics, filters, and Templates using MicroStrategy Architect.
Created data sets and dashboards using Intelligent Cubes to improve the performance
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.
Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the
Flash version& Express Version of the dashboards.
Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
Created the Data mart reports based on specific requirements and running the existing Data mart reports for weekly and monthly loads.
Worked with users from different functional teams across the organization in gathering requirements for developing dashboards and Key Performance Index dashboards.
Environment: MicroStrategy 10.4 (MicroStrategy Mobile, MicroStrategy Administrator, MicroStrategy
Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager,
MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager,
MicroStrategy Intelligence Server), SQL server management studio, MYSQL, Windows 10.
TJX Companies, Marlborough MA Feb 2016 – May 2017
Role: Sr. MicroStrategy Developer
Responsibilities:
Effectively participated in Agile SDLC methodologies. Successfully demonstrated multitasking capabilities by involving in multiple projects and support initiatives.
Involved in importing tables using Warehouse catalog and Creating Logical Tables.
Created Attributes, Facts, Transformations and Hierarchies using MicroStrategy Architect
Designed Interactive Dashboards in MicroStrategy Web to assess company's performance and monitored the overall goals of the business.
Extensively involved in data modeling to create attribute relationships, and hierarchies
Created different kind of Dashboards like Trend, performance summary, traditional metric, dynamic content in both the interactive & express mode.
Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets
Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
Generated and implemented MicroStrategy reports by creating projects, Attributes, Hierarchies, Metrics, filters, and Templates using MicroStrategy Architect.
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.
Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the
Flash version& Express Version of the dashboards.
Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
Created the Data mart reports based on specific requirements and running the existing Data mart reports for weekly and monthly loads.
Worked with users from different functional teams across the organization in gathering requirements for developing dashboards and Key Performance Index Financial dashboards.
Environment: MicroStrategy 10.3/10.2 (MicroStrategy Mobile, MicroStrategy Administrator, MicroStrategy
Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager,
MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager,
MicroStrategy Intelligence Server), Teradata, Oracle 12c/11g, UNIX, Windows XP.
American Airlines, Dallas, TX Dec 2014 to Jan 2016
Role: MicroStrategy Developer
American Airlines, Inc. (AA) is a major American airline headquartered in Fort Worth, Texas. Operating an extensive international and domestic network, American Airlines is the world's largest airline by fleet size and revenue, and the second largest by number of destinations served.
Responsibilities:
Responsible for gathering and refining business requirements from the Business users.
Troubleshooting of reports, SQL statements and report performance to ensure that the system is continually running at peak performance.
Used analytical and governing settings in VLDB properties to tune the SQL and metrics involving nulls and zeroes.
Involved in the design/development life cycle including gathering requirements, user interaction and report design and development.
Created facts, dimensions, and attributes using MicroStrategy Developer.
Created metrics, filters, and templates for the reports.
Designed Dashboards using the selectors’ radio buttons, check boxes, panels, slider and button bar etc. summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
Implemented Nested Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
Actively participated in developing Entity-Relationship (ER) Diagrams, and Data Dictionaries, by gathering information from the Business Users and detailed analysis of the data.
Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drill down to claim (lowest) level.
Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.
Also, worked as ETL support contact supporting Informatica mappings to load data into data warehouse.
Depending on the requirement, used database specific MicroStrategy OLAP pass through functions like Apply Simple and Apply Comparison to overcome complex logic in creating objects.
Experience working in various environments with change management, defect tracking and status reporting processes.
Created and deployed Mobile/IPad Dashboards.
Used free form SQL editor for complex report creation.
Used SQL Developer extensively to test and debug MicroStrategy reports as a key step in data validation.
Environment: MicroStrategy 9.4/9.4.1 (Desktop, Administrator, Web), SQL server, MicroStrategy Intelligence Server, Distribution Services, Oracle 11g, Netezza, Windows server.
Associated Press, NYC, NY Nov 2013 – Dec 2014
MicroStrategy Developer
Associated Press is one of the largest and most trusted sources of independent newsgathering, supplying a steady stream of news to its members, international subscribers and commercial customers. It is neither privately owned nor government-funded; instead, as a not-for-profit news cooperative owned by its American newspaper and broadcast members, it can maintain its single-minded focus on newsgathering and its commitment to the highest standards of objective, accurate journalism.
Responsibilities:
Involved in design/development life cycle including gathering requirements, user interaction and report, design and development.
Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
Configured Enterprise Manger and developed customized reports to depict the usage and performance of reports, User activity and Cache analysis.
Developed a web course and took several classes to train the end users to efficiently use MSTR.
Created several data marts using MSTR for different tools to access large datasets.
Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner.
Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level.
Worked with end users along with Business Analysts to build reports and dynamic dashboards.
Worked on administrative tasks like User Groups, Roles, Privileges, Cache Management.
Involved extensively in the overall lifecycle of the Data Warehouse integration project.
Performed testing of all reports for the final deployment.
Provided Business user training for the MicroStrategy Desktop/Web.
Architected schema objects such as MicroStrategy Attributes, Facts, Transformations and Hierarchies.
Created above store reports to support field coaches and general managers. The reports were highly visual and drillable.
Aggregate tables were designed to efficiently run reports.
Worked in on-off shore model to fulfill business requirement and assigning work to off shore
Performance optimization using VLDB properties, created I–Cubes to improve performance and to reduce the load on database during Peak hours.
Built numerous dashboards to meet Operational and financial reporting that enabled senior executive to easily visualize overall business
Created ad-hoc reports and freeform SQL reports depending on user requirement.
Environment: MicroStrategy v9.2.1, MicroStrategy 9.0.1(Architect, Desktop, Report services, Dashboards, Enterprise Manager) Teradata, Windows XP.
Logic Systems, Hyderabad, India Aug 2012 –Oct 2013
Role: MicroStrategy Developer
Logic Systems is a leading provider of integrated business software platforms that help organizations automate and accelerate their existing processes, reduce overhead, and improve ROI. Built on open platform architecture, our software solutions can be rapidly deployed and easily configured to meet the needs of small, medium and large enterprises. I worked as the MicroStrategy developer developing reports for the clients on a very large database.
Responsibilities:
Architected schema objects such as attributes, facts and transformations.
Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, compound Metrics and Prompts.
Created reports with various object prompts to generate various Ad hoc reports.
Implemented the user defined MicroStrategy objects like custom groups and consolidations according to the requirement.
Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Desktop 8.1x that can be re-used to build any number of metrics.
Involved in Testing of reports and Migrated MicroStrategy7i projects from development to acceptance and to production.
Created reports with various object prompts to generate
Various Ad hoc reports.
Environment: MicroStrategy 8.1x, Windows 95/NT/2000.
Contact this candidate