We provide IT Staff Augmentation Services!

Micro Strategy Developer Resume

SUMMARY

  • Having 7+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
  • Extensive experience in Business Intelligence, ETL and Data warehousing Technologies with expertise in MicroStrategy versions 8.x/9.x/10.x: Intelligence Server, Administrator, Architect, Desktop Designer, MicroStrategy Web Administration, Security Administration, Object Manager, Integrity Manager, Report Services, Dashboards, Enterprise Manager and Narrowcast Server.
  • Strong experience with full Software Development Life Cycle(SDLC) which includes Requirement Analysis, Design, Development, Implementation, Testing, Deployment, Production Support, Maintenance, Built and Release management.
  • Proficient in installation and configuration of MicroStrategy in distributed environments
  • Good Experience and comfortable to adhere with Organizational goals, Information strategy planning, Requirement analysis, Quality Processes, Project Management Process, Leadership skills etc.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using MicroStrategy.
  • Extensive experience working as a Business Intelligence Consultant with specialization in Cognos, MicroStrategy, SSRS.
  • Extensive experience working in Windows, UNIX, LINUX environments.
  • Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, MS Access and client/server applications.
  • Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
  • Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
  • Worked with Database teams on upgrading the Metadata and Database versions.
  • Responsible for reviewing all the testing deliverables and conducting meetings with the stakeholders about the project milestones, issues and dependencies.
  • Used MicroStrategy tools like Object Manager to migrate the objects/projects between MicroStrategy environments and MicroStrategy Command Manager to run the automated scripts.
  • Fine tuning of the MicroStrategy Reports using Data mart reports, Aggregate Tables and Intelligent Cubes.
  • Extensively worked on delivering reports and business intelligence solutions on the web using MicroStrategy Narrowcast Server.
  • Maintaining Server level control and admin process documentation (Server Upgradation, Configuration and metadata definitions)
  • Extensive working experience in Packages, Procedures, Cursors and Triggers.
  • Experience in the testing and performs testing activities such as unit, integration and User Acceptance Testing (UAT).
  • Excellent Communication, Interpersonal, Analytical skills and Strong ability to perform as member of the team.

TECHNICAL SKILLS

BI Tools: MicroStrategy 10/9.x/8.1.x (Intelligence Server, Administrator, Desktop/Developer, Architect, Web, Distribution Services, Visual Insight, Narrowcast Server, Mobile, Integrity Manager, OLAP), Cognos 10.

ETL Tools: Informatica Power Center 9.x/8.x, SQL Server SSIS services.

Databases: Oracle 11g/10g/9i, Teradata 13.x/V2R6, Sybase, Netezza, MS SQL Server

Programming: PL/SQL, SQL Loader, SQL Plus, TSQL, C, C++, HTML, CSSJavaScript

Operating Systems: Windows Servers, UNIX, Linux

Other Tools: Toad, PL/SQL Developer, SQL Assistant, MS Office, Microsoft Visio, Erwin

PROFESSIONAL EXPERIENCE

Micro Strategy Developer

Confidential

Responsibilities:

  • Involved in reviewing business requirements and analyzing data sources form Excel/MS SQL Server for design, development, testing of reporting and analysis projects within MicroStrategy.
  • Working with data extracts of 4 GB in size, optimizing and managing these extracts by refreshing the schedules.
  • Involved in MicroStrategy upgrade from 9.4.1 to 10.2 using Integrity Manager.
  • Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary.
  • Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters and metrics using MicroStrategy Desktop
  • Working with Business users, Analysts, Team Lead and Functional Analysts to identify process improving opportunities in data analytics and data modeling.
  • Implementing new advancements and enhancements to translate data into visualizations.
  • Designing the mock ups, KPI model designs, Financial planning in support for PS operations, initiatives and strategies in new opportunities available.
  • 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.
  • Used the Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy
  • Created Report Builder, Visual Insight screens for power users to help them create their own reports, dashboards.
  • Experience in MicroStrategy Intelligence Server, which is optimized for enterprise querying, reporting, and OLAP analysis.
  • Designing the mock ups, KPI model designs, Financial planning in support for PS operations, initiatives and strategies in new opportunities available. .
  • Widely used VLDB properties to set default criteria at project level and at individual report levels to overcome performance issues.

Environment: MicroStrategy 10/ 9.3 9.4 (Intelligence Server, AdministratorDesktop/Developer), Linux, Oracle 11gR2, SQL Server, Jira, Agile/Scrum, Oracle, DB2, Microsoft Windows, Mozilla Firefox, Google Chrome, Internet Explorer.

MicroStrategy Developer

Confidential

Responsibilities:

  • Analyze data from various sources and creating reports weekly, monthly and quarterly reports using Excel, SQL, Tableau and IBM Cognos.
  • Generated and implemented MicroStrategy reports by creating Schema Objects (Like Facts, Attributes, Hierarchies, Transformations) and Application Objects (Like Metrics, Filters, Prompts, Custom Groups and Consolidations).
  • Extensively worked on Advanced Prompts, Conditional Transformation Metrics and Level Metrics to create complex reports.
  • Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
  • Prepared Dashboards using calculations, parameters in MicroStrategy and created calculated fields, groups, sets and hierarchies etc.
  • Carried out database testing by creating and executing SQL queries.
  • Involved in Troubleshooting MicroStrategy Web Reports and tuning queries for report performance.
  • Expertise in customize SQL query by setting VLDB properties at different levels Database Instance, Report and Metric.
  • Worked with Free-Form SQL reports to create reports that are not supported by existing schema model.
  • Running the Extract schedules on daily, weekly, monthly basis and also refreshing all the published data sources.
  • Work with different functional teams to connect different Oracle data sources and systems.
  • Created Report Service Documents from the existing Grid based Reports with extensive customization to meet the user needs.
  • Created Dashboards, static and dynamic and scoreboard reports for effective web-based report solutions.

Environment: MicroStrategy 9.0.2/9.2.0 (Intelligent Server, Narrowcast Server, OLAP Services, MicroStrategy Desktop, Report Editor, MicroStrategy Web), Oracle 9i, DB2, Windows vista/XP

MicroStrategy Developer

Confidential, JERSY CITY, NJ

Responsibilities:

  • Involved in creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Scheduled data extracts and monitor on daily basis.
  • Generated and implemented MicroStrategy reports by creating Attributes, Hierarchies, Metrics, filters, and Templates using MicroStrategy Architect.
  • Worked with all levels of SDLC from analysis through implementation and support.
  • Participated in test planning and test script definition.
  • Created Report Service documents with multiple layouts formatted as per the business requirements.
  • Used the Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy
  • Resolved end user reporting problems through collaboration with IT and Operations.

Environment: MicroStrategy 9.2.1, Report Services, MicroStrategy Desktop, MicroStrategy Web, Mobile, MicroStrategy Dashboards, MS-Excel, Toad, Oracle 10g.

SQL Developer

Confidential

Responsibilities:

  • Created databases objects using T-SQL scripts, stored procedures, views.
  • Scheduled, conducted meetings with client and work group members to identify requirements documented them in Specification Documents to Identified Priorities.
  • Designed Logical and Physical data models using ERWIN data modeling tool.
  • Created complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
  • Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
  • Generated Reports using Global Variables, Expressions and Functions based on the requirements.
  • Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
  • Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
  • Created Complex Stored Procedures and automated them using SQL Server Agent.
  • Experience in implemented Stored Procedures and Triggers for automating tasks.
  • Generated MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
  • Worked with Enterprise Manager for job scheduling and batch queries.
  • Compressed data files by removing empty database pages and updating index statistics, managed and monitored the system utilization.

Environment: MS SQL Server Management Studio 2005/2008, Query Analyzer, SQL Profiler, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), DB2, Oracle9i, XML, ASP.Net, Windows 2003 /2000.

Hire Now