We provide IT Staff Augmentation Services!

Sr. Micro Strategy Developer Resume

St Louis, MO

SUMMARY:

  • 8+ years of strong experience in Business Intelligence in designing and implementing Web based and Standalone software application with major focus on Data Warehousing and Database Applications.
  • Extensive experience as MicroStrategy Developer, Architect & Administrator building projects and creating reports and Dashboards using MicroStrategy 7.i/ 7.5/8.0/8.1/9.0/9.0.1/10.0/10.4/10.8 , Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.
  • Involved in training Business Users on MicroStrategy OLAP Services (such as view filter and derived metrics, Adhoc reports).
  • Used MicroStrategy tools like Object Manager to migrate the objects/projects between MicroStrategy environments. Strong data modeling (Logical and Physical) experience with high proficiency in using Erwin for Dimensional Modeling (Star, Snowflake schemas) and Entity - Relationship Modeling.
  • Experience in creating Report Service Documents, pixel perfect Dashboards and Visual Insight analytics templates.
  • Installing and Configuring of MicroStrategy suite including MicroStrategy Desktop, Administrator, Intelligence Server, Web, and Narrowcast Server on NT Servers and Sun Solaris Environments.
  • Experience in developing Interactive Flash Dashboards using D3 Widgets and Dynamic HTML.
  • Experience in developing Widgets using jQuery and Javascripts in D3 Widgets.
  • Advanced extensible reporting skills using MS BI, SQL Server Analysis Service (SSAS), and DAX. Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
  • Expert in creating List Reports, Crosstab Reports, Drill through Reports and Multidimensional Reports with cascading prompts, Macros, filters, calculations using Cognos.
  • Creating users, user Groups and assigning security roles for the project.
  • Monitoring user connections, caches and jobs.
  • Developed basic and user-specified Metrics (level and conditional).
  • Created drill maps for end users to drill down and recover data.
  • Worked with Logical and physical modeling along with design and implementation.
  • Involved in job scheduling, monitoring and production support in a 24/7 environment.
  • Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.
  • SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Extensive knowledge of SQL, PL/SQL and worked on very large databases in Teradata V2R5/V2R4, Oracle 10g/9i/8i/7.x, and SQL Server 2005/2008.
  • Excellent analytical and communication skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

RELEVANT SKILLS:

BI TOOLS: MICRO STRATEGY DESKTOP 7X/ 8X/ 9.X/ 10.X (MICROSTRATEGY DESKTOP, MICROSTRATEGY WEB AND WEB UNIVERSAL, MICROSTRATEGY INTELLIGENCE SERVER, REPORT SERVICES, DOCUMENTS, DYNAMIC DASHBOARDS, NARROWCAST SERVER & ENTERPRISE MANAGER.DATABASE ORACLE 8I/9I/10G/11G, TERADATA, MY SQL, MS SQL SERVER 2008/2005/2000 , MS ACCESS.ETL TOOLS INFORMATICA POWER CENTER 9.X/8.X, SQL SERVER SSIS SERVICES. OTHER TOOLS TOAD, SQL ASSISTANT, PL/SQL DEVELOPER, MS OFFICE, MICROSOFT VISIO, ERWIN, DB VISIO.

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Sr. Micro Strategy Developer

Responsibilities:

  • Worked with business users to gather requirements and prepare technical specification Documents.
  • Understanding the reporting requirements, developed the reports and redesigned the legacy reports in MicroStrategy.
  • Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters and metrics using MicroStrategy Desktop.
  • Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics.
  • Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.
  • Extensively created MicroStrategy Report Services Documents, Dashboards for Web & Mobile (iPad) users.
  • Created Report Builder, Visual Insight screens for power users to help them create their own reports, dashboards.
  • Depending on the requirement, used database specific MicroStrategy OLAP pass through functions like Apply Simple, Apply Comparison to overcome complex logic in creating objects.
  • Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
  • Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls, and worked extensively on D3 Widgets, Dynamic HTML & jQuery.
  • Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, and access controls Lists.
  • Worked on Narrowcast Server Application environment creating services using subscription sets, schedules, and Information objects.
  • Tuned ODBC driver to improve data transfer rates between database and MicroStrategy servers located at different physical locations.
  • Involved in MicroStrategy Upgrade from 10.3 to 10.10 and then to version 10.3. Used MicroStrategy Integrity Manager for regression testing during upgrade.

Environment: MicroStrategy 10.3/10.10 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Teradata, SQL Server.

Confidential, Owings Mills, MD

Sr. Micro Strategy Developer

Responsibilities:

  • Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters and metrics using MicroStrategy Desktop.
  • Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics.
  • Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.
  • Extensively created MicroStrategy Report Services Documents, Dashboards for Web & Mobile (iPad) users.
  • Created Report Builder, Visual Insight screens for power users to help them create their own reports, dashboards.
  • Depending on the requirement, used database specific MicroStrategy OLAP pass-through functions like Apply Simple, Apply Comparison to overcome complex logic in creating objects.
  • Widely used VLDB properties to set default criteria at project level and at individual report levels to overcome performance issues.
  • Created Intelligence Cubes in MicroStrategy to overcome performance issues related to Report Service Documents using high volume datasets. Using Intelligent cubes improved performance of the RS documents significantly.
  • Analyzed existing SAP Business Objects reports, documented the Technical specifications and converted SAP Business Objects reports to MicroStrategy for CRES Workplace Utilization project.
  • Used the Object Manager to migrate the objects from Development to UAT environment in MicroStrategy.
  • Involved in MicroStrategy Upgrade to 9.4.1 and then to version 10.4. Used MicroStrategy Integrity Manager for regression testing during upgrade.
  • Used Narrowcast Server to automate FX TCA Order Completion reports, Aggregate reports to internal and external clients.
  • Involved in MicroStrategy migration from Solaris to Linux, also database migration from Physical Oracle database to DHS Virtual hosts.

Environment: MicroStrategy 10/9.4.1 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Oracle 11g, DB2.

Confidential, Pittsburgh, PA

Sr. Micro Strategy Developer

Responsibilities:

  • Involved in the documentation of technical specifications of the Sales and Inventory Project.
  • Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
  • Created different Project Sources for different environments like production, testing and development.
  • Created different schema objects like Attributes, facts by using Micro-Strategy Architect of the Micro-Strategy BI Suite.
  • Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards).
  • Generated reports using Advanced Metric objects, Filters and Prompts. Also created Customized Templates to facilitate End users to create customized reports by choosing Filters, Metrics and Report Attributes.
  • Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports.
  • Created Ad-hoc reports by gathering specific requirements from the different users.
  • Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
  • Using Informatica Power Center Designer and analyzed the source data to Extract & Transform from various source systems.
  • Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
  • Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, and access controls Lists.
  • Worked on Narrowcast Server Application environment creating services using subscription sets, schedules, and Information objects.
  • Tuned ODBC driver to improve data transfer rates between database and MicroStrategy servers located at different physical locations.
  • Used database specific MicroStrategy OLAP pass through functions like Apply Simple.
  • Involved in production support (24/7).
  • Maintained a stable platform by proactively identifying and resolving any issues or bugs.

Environment: MicroStrategy 10/9.4.1 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Oracle 11g, Sybase.

Confidential, Newark, NJ

Sr. Micro Strategy Developer

Responsibilities:

  • Worked with business users to gather requirements and prepared technical specification Documents.
  • Understanding the reporting requirements, developing the reports and redesigning the legacy reports in MicroStrategy.
  • Involved in Dimensional Data Modeling, Data Architecture, Business and Data Analysis.
  • Developed MicroStrategy Schema objects and Application objects like Metrics, Filters, Prompts, Consolidations, Custom Groups, and Project objects like Subtotals.
  • Designed Reports, Documents and Dashboards using Desktop.
  • Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
  • Created ad-hoc reports by drilling up, down, within and across Hierarchies.
  • Created Transformations to calculate YTD (Year to date), MTD (Month to date) metrics.
  • Implemented Report Data Options, Formatting, Dynamic Dates, Advanced Sorting, Prompt Ordering, and Totals, Outline Mode based upon the business user change request during UAT Testing.
  • Validated end user report requests using SQL queries and MicroStrategy tools.
  • Used Object Manager to move the reports from Development Project to QA/Production Project.
  • Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Executed data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
  • Involved in optimization of code and tuning queries for performance.
  • Provided production support for ongoing issues.

Environment: MicroStrategy 9.4.1/9.3 (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), UNIX, Windows Server, SQL server.

Confidential, Boston, MA

Microstrategy Developer

Responsibilities:

  • Used Object Manager to move the reports from Development Project to QA/Production Project.
  • Involved in providing solutions for Complex Time Dimension related issues.
  • Designed MicroStrategy Schema objects and Application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy Desktop and Architect.
  • Worked extensively on Complex reporting needs, which involved creating Consolidations and Custom Groups.
  • Enabled the Advanced Qualification option for the Filter Editor, and created Custom Expressions to build Relationship filters according to the Business logic.
  • Created the Analytical engine bypass functions like Apply Simple & Apply Comparison whenever necessary.
  • Created different Transformations to get the last year actual transactions, Month to Date (MTD), Quarter to Date (QTD), Year to date (YTD) calculations and effectively used them with the metrics.
  • Implemented Drill Maps functionality in various reports.
  • Used the Object Manager to migrate objects between DEV, UAT and Production environments.
  • Optimized Query Performance using VLDB settings.
  • Created and configured the Narrowcast Server to execute and deliver reports to your emails using dynamic subscriptions.
  • Worked as MicroStrategy support admin to handle some of the administrative tasks.

Environment: MicroStrategy 9.3/9.0 (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), Windows Server, SQL server

Confidential, Beaverton, OR

BI Developer

Responsibilities:

  • Participated in the 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 Manager and developed customized reports to depict the usage and performance of reports, User activity and Cache analysis.
  • 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 with the DBA on issues of database performance and security.
  • Worked on administrative tasks like User Groups, Roles, Privileges, and Cache Management.
  • Involved extensively in the overall lifecycle of the Data Warehouse integration project.

Environment: MicroStrategy 9.x/8.x (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), Linux, Windows Server, SQL server, Oracle.

Hire Now