We provide IT Staff Augmentation Services!

Senior Microstrategy Developer Resume

New York, NY

PROFESSIONAL SUMMARY:

  • Over 9 years of strong IT Experience in Business Intelligence (BI), Data Analytics and Data Warehousing Project Development and Implementation Using Microstrategy 10.x/9.x/8.x Product Suites including Microstrategy Desktop, Web, Architect, Administrator, OLAP Services, Intelligence Server for clients in Retail, Telecommunication and Financial domain
  • Worked extensively on Schema objects with MicroStrategy Desktop/Developer like Attributes, Facts, Hierarchies and Transformations
  • Experience managing cross functional teams across all phases of the Software Development Life Cycle and product implementations; well - versed in agile and waterfall methodologies
  • Expertise in Agile Scrum, Software Development Life Cycle (SDLC), Defining Use Cases, Business Process Modeling Notation and Object-Oriented Analysis
  • Excellent understanding of Business Requirements Gathering, writing User Stories, Translating Requirements into Specifications and Application Design
  • Expertise in creating Grids, Dashboards, Visual Insight Reports to view personalized reports based on user requirements
  • Server as Microstrategy Administrator and performed Version upgrade, User Management, Security Filters, Statistical analysis using Microstrategy Enterprise Manager
  • In-depth understanding of fundamental data warehousing concepts such as Dimensional Modeling, Star and Snowflake Schemas, Data marts, Security and deployment, FACT and Dimensional tables, Logical and Physical data modeling
  • Experienced in Dimensional Data Modeling, Star Schema, and Snow Flake Schema

TECHNICAL SKILLS:

  • Microstrategy 10.3/9.x/8.x
  • Clear Quest
  • Clear Case
  • Requisite & Rose
  • UML
  • Confidential Test Director
  • Microsoft Office (Microsoft Word
  • Microsoft PowerPoint
  • Microsoft Excel)
  • MS Access
  • MS Project Server
  • MS Visio
  • MS SharePoint
  • JIRA
  • Visual Basic
  • Tableau
  • Microsoft Power BI
  • XML
  • Systems Development Life Cycle (SDLC)
  • Rational Unified Process (RUP)
  • E/R Design
  • Unix
  • KYC
  • Waterfall
  • Prototype and Agile
  • COTS
  • Oracle
  • DB2
  • ETL
  • MS Access
  • SQL Server
  • PL/SQL
  • Windows 95/98/00/XP/Vista
  • Mac OS- X and NT
  • C
  • C++
  • Global Service Desk R6
  • R11
  • Remedy incident management
  • Confidential Service Manager
  • ServiceNow

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior Microstrategy Developer

Responsibilities:

  • Develop Analytical Reports for Contact Center and Concierge projects in MicroStrategy to provide data solutions for Business users, which involve development of ad hoc reports, visual insight dashboards, Intelligent cubes, Grid and Graph reports
  • Implemented Transformations using in comparative reports like revenue this year to last year. Created transformations using transformations by tables for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.
  • Worked closely with various business functions to find opportunities to build new business enhancing reports and to automate and optimize existing critical reports
  • Key member in MSTR version upgrading
  • Involved in different administration tasks such as creating Users, Security Roles, assigning different access rights to the Users and Scheduling reports manually and using command manager scripts.
  • Developed scorecards and dashboards that provide users a highly graphical, summary view of key metrics
  • Worked with Set up schedules for various Reporting Objects, Cache clearing & Intelligent Cube refresh to automate, optimize and improve existing manual processes
  • Creating or modifying Database instances and Microstrategy Database User Configurations for new projects or existing projects.
  • Resolved Many to Many relationships between the attributes and identified the one to one and one to many relationship between the attributes
  • Conducted GAP Analysis, SWOT Analysis, Cost Benefit Analysis, Risk Analysis, and Impact Analysis and modeling Businesses Processes
  • Leveraged Agile Scrum Methodology for gathering requirements and facilitated user stories elicitation. Documented User Stories and facilitated scoping and sprint planning discussions to analyze the level of effort on project specifications
  • Led project communication, requirement gathering, Service Design Package review and signoff meetings with service center leads and owners; Interfaced with Program Management Office to ensure project goals and requirements are met
  • Spearheaded ITIL Service Design Package (SDP) documentation project for various services under 9 service centers, such as IBM MQ Operations Support Service, Service Management Operations, ITLAB, etc.
  • Listed service goals, service objectives, service description, service category, and service icons and assigned service delivery managers, service owners and service implementation members
  • Designed UML service hierarchy trees, approval flow diagrams, and service fulfillment (swim lane) and workflow diagrams using Microsoft Visio 2016
  • Collected and configured Standard Operating Procedures (SOP) for respective services under implementation
  • Drafted improvement plans, and initiatives based on industry best practices and ITIL frameworks

Environment: Microstrategy 10.4/9.4.1 (Developer, Architect, Administrator, Web, Object Manager, Enterprise Manager, Command Manager, DB Query Tool, Office), MS Visio 2016, Agile/Scrum Methodology, Microsoft Office suite 2016, SharePoint 2016, SQL, Windows 10

Confidential, Stamford, CT

Microstrategy Developer/ Administrator

Responsibilities:

  • Involved in creating User Stories, prioritization, iteration / Sprint planning, Release planning, Scrum Retrospective by working with key members of the project
  • Involved for collecting and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
  • Lead team in Dimensional Modeling by selecting the business process, declaring the grain, and choosing the dimensions and facts.
  • Designed, developed and maintained a self-serve environment by providing users knowledge and training with various stages of the process.
  • Developed the Transactional Dashboard and reports to automate and maintain the user groups for various projects.
  • Created a DB instances for Microstrategy and added all the tables, table prefixes and updated the table structure required for the Project.
  • Architected schema objects such as Facts, Attributes, Hierarchies and Transformations.
  • Analyzed and developed Application Objects (Metrics, Reports, Documents, filters, prompts) using MicroStrategy Desktop and MicroStrategy web interfaces.
  • Created metrics (simple, nested & compound), advanced filters, advanced prompts, advanced report designs and drill maps.
  • Worked on Visual Insights, Dashboards and Scorecards and used several widgets like Bubble Grid, Micro charts, Fish Eye, Heat Map and demonstrated to the business users.
  • Managing large variety of user base by creating different user groups with different security filters.
  • Worked as backup administrator in charge of adding new users to groups and assigning them security privileges.
  • Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
  • Created number of Normalized database tables with different constraints to maintain integrity. Triggers were implemented on the tables to maintain validity check on the data.
  • Created Report Builder, Visual Insight screens for power users to help them create their own reports, dashboards.
  • Implemented OLAP Functions like Apply Simple, Apply Comparison for the complicated filters, attributes and metrics.
  • Understand the type of schemas that best support MicroStrategy in different scenarios
  • Analysis and Troubleshooting of the SQL generated by Microstrategy
  • Managed issues as they occur, providing the appropriate vetting of the severity of the issue and performing the required management of the high impacting severity problems as agreed in the Incident Management process and Service Level Agreements (SLAs)
  • Gathered user requirements to develop requirement documents, functional specification documents, testing methodology documents and training documents.
  • Performed financial analysis, business trending, and competitive analysis, marketing analysis, overall customer/data analysis, forecasting and budgeting
  • Acted as a liaison between the functional department analysts and the Business Intelligence team
  • Worked closely with various business functions to find opportunities to build new business enhancing reports and to automate existing labor and time intensive critical reports
  • Involved in Installation and Configuration of MicroStrategy I-Server, Web server and Narrowcast server
  • Created and presented reports and data visualizations to senior leadership and stakeholders, providing insight into the overall health of the Commercial Business and helped make calculated and informed business decisions
  • Identified and monitored Key Performance Indicators across the commercial business
  • Collaborated with business counterparts to ensure data is being managed and reported correctly (i.e. IT, Finance, Sales, and Operations)
  • Implemented OLAP Functions like Apply Simple, Apply Comparison for the complicated filters, attributes and metrics
  • Analysis and Troubleshooting of the SQL generated by Microstrategy
  • System Optimization, performance monitoring and tuning experience in MicroStrategy Business Intelligence environment using MicroStrategy Enterprise Manager
  • Created Process Work flows, Functional Specifications, and responsible for preparing Software Requirement Specifications (SRS), Functional Specification Document (FSD), PRDs (Product Requirement Documents) and final Design Document as per SEI CMM standards.

Environment: Microstrategy 10.1 - 10.3, MS Visio, Agile/Scrum Methodology, Microsoft Office suite, SharePoint 2010, SQL, Windows Vista/7

Confidential, Providence, RI

Microstrategy Developer

Responsibilities:

  • Gathering reporting requirements.
  • Creation and maintenance of different projects in Microstrategy
  • Responsible for set up of security roles/user groups for different Business groups.
  • Develop and maintain Microstrategy reports, dashboards and end-user applications.
  • Worked on three different projects starting from creating the fact tables and dimension tables till the creation of the Report service document.
  • Creating and linking aliases for different dashboards to not have business users look for URL’s to access desired dashboards.
  • Design, develop and implement BI system enabling non-technical users to leverage data for strategic decision making.
  • Utilize various Microstrategy reporting tools to deliver insights to targeted audiences (Web reporter, Web Analyst, Web Professional, Report services etc.,)
  • Experience in creating and optimizing Microstrategy Dynamic dashboards, documents and Visual Insight Analysis.
  • Develop extensible components on top of Microstrategy in line with business priorities, e.g. Flash based components in Report services, using different widgets (maps, micro charts etc.,)
  • Created dynamic dashboards for iPhone, iPad using MicroStrategy mobile
  • Design, develop and implement reporting and analysis environment, including template driven and parameterized reports.
  • Develop ad hoc interfaces enabling end users to generate their own reports.
  • Configure new projects and model data for data warehouse and BI purposes.
  • Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
  • Configure new projects and model data for data warehouse and BI purposes.
  • Create, test and troubleshoot reports.
  • Providing production support for different projects and tracking/updating the defect log sheet from users.
  • Migration planning and implementation with all supported service packs, hot fixes, and patches.
  • Running Integrity manager for health-check for different projects.
  • Using Enterprise manager to generate reports which would help business to identify users who need Microstrategy services the most and also help in clean- up of obsolete users.
  • Extensively worked on MicroStrategy Administration that includes Intelligence Server Administration, configuration of Memory settings, and Performance monitoring.

Environment: Microstrategy 9.5 - 10.1, Windows 7, 8 & 10, UNIX, MS Visio, SQL, Oracle, PL/SQL, SOA, ALM, MS Project, MS Office, UAT

Confidential

Business Systems Analyst / Microstrategy Developer

Responsibilities:

  • Created Microstrategy Objects Metrics, Filters, Prompts, Templates, Consolidations, Transformations, and Custom Groups using MicroStrategy Desktop
  • Determined KPIs to measure operational performance; provided process improvement recommendations to stakeholders and Executives
  • Oversee and manage all Major Incidents for accounts located in the Command Center for North America IT Operations team
  • Created different Transformations to get the last year’s actual transactions, week to day, week to period, week to quarter and week to year and effectively used them with the Metrics
  • Involved in comparing the reports and Data marts across different environments and testing them using the MicroStrategy Integrity Manager
  • Established risk and project management practices, providing approvals for critical change requests from development and production teams
  • Evaluated the declining customer satisfaction rates; implemented an internal quality assurance process mitigating risks by 30%
  • Created Dynamic Enterprise Dashboards and utilized the new features to convert the dashboards into Flash mode
  • Worked in Disaster Recovery ensuring that all documents are up to date and accurate. Made suggestions on how to improve based on previous issues performing root cause analysis
  • Led the identification, analysis, design and delivery phases of WebSphere Application Server (WAS) installations for various business platforms
  • Developed wireframes, use cases and technical documentation for multiple projects
  • Actively Involved in testing the MicroStrategy Objects and Reports in MicroStrategy Environment.
  • Determined severity of outages and technical issues; restored normal service operation by ITIL standards.
  • Coordinated activities across cross functional teams during the overall incident management lifecycle; achieved improvement in service level agreement by 10%
  • Developed Dashboards and Documents in Microstrategy, allowing the leadership team to easily identify data trends
  • Created different Project Sources for different environments like production, testing and development.
  • Spearheaded the delivery of a call routing analysis procedure saving 80 effort hours a week.
  • Advocated and streamlined learning program for newly hired technical analysts; reduced training hours by 40%.

Environment: Microstrategy 9.0.2 - 9.4.1, Windows 7, 8 & 10, UNIX, MS Visio, SQL, WAS, Oracle, PL/SQL, MS Project, Waterfall

Confidential

Technical Analyst

Responsibilities:

  • Identified recurring defects of Confidential laptop hardware and performed root cause analysis; designed a technical solution reducing incident rate by 60%.
  • Responsible for engaging, escalating and communicating with cross-functional groups within Confidential and customer organizations.
  • Diagnose, troubleshoot and resolve a range of software, hardware and connectivity issues. Excel in asking probing questions and researching, analyzing and rectifying problems.
  • Partnered with Tier III technicians based in the Confidential to resolve complex problems that required escalation. Provided detailed descriptions of issues in trouble ticket system and followed up diligently to ensure swift resolutions.
  • Collaborated with cross functional teams across different geographical locations to successfully drive product enhancements currently occupying 30% of client printer market share.

Hire Now