We provide IT Staff Augmentation Services!

Sr.microstrategy Developer/architect Resume

Chester, PA

Professional Summary

  • Morethan 8 year’s professional experience in Full life cycle development gathering requirements, documentation, participating in design, development, testing and deploying BI solutions using MicroStrategy.
  • Experienced in various project management methodologies like Sprint, Agile, SCRUM and Water Fall based.
  • Well versed with all the products of MicroStrategy Product Suite namely Micro Strategy’s Intelligence Server, Architect, Administrator, Desktop, Web and Narrowcast Server.
  • Expertise in creating interactive dashboard Reports and Scorecards to view personalized reports based on user requirements.
  • Experienced in using Micro Strategy’s Intelligent Server Optimizations.
  • Ability to analyze existing reports & systems and strong experience in gathering reporting requirements.
  • Running Reports/ Data Marts, managing Report Caches and Migrating Projects to MicroStrategy Production server after the enhancements are done.
  • Experienced in Data Analysis, Identification of dimensions, Facts, Measures and Hierarchies.
  • Experienced in developing Ad-hoc interfaces enabling end-users to generate their own reports.
  • Basic understanding of ETL tools such as Informatica.
  • Good understanding of ROLAP Star Schema modeling, Snowflake modeling, Fact, Lookup and Dimensions Tables, Physical and Logical Data Modeling.
  • Expertise in Defining MicroStrategy Narrow Cast Server objects like Service, Schedule, Subscription set and Information Objects.
  • Strong working knowledge of SQL, ability to understand and write complex SQL using Stored Procedures, Joins, Views, Triggers and Indexing strategies.
  • Proficient in using Netezza, Oracle 10g, SQL Server 2005/2008.
  • Experience in optimization of code and tuning queries for performance.
  • Ability to perform extensive Quality Assurance (QA) on MicroStrategy reports.
  • Resolving skills of user-identified functional and technical issues relating to MS reporting services.
  • Excellent communication and interpersonal skills.
  • Ability to work under minimum supervision and have the ability to grasp technical concepts quickly.
  • Highly efficient in problem solving and trouble shooting skills.

Education

  • Bachelor’s in Information Technology.

Technical Skills

  • BI Tools: MicroStrategy Desktop 9.2.1/8.x.x/7.5.2/7i/7.0/6.0, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligent Server, MicroStrategy Narrow Cast Server and MicroStrategy SDK.
  • ETL Tools: Data Stage, SSIS, SSAS, Ab Initio, Informatica, MS DTS and Data Junction.
  • Data Modeling Tools: ER Studio 8/7.x, Erwin Data Modeler 7/4/3.5.2,
  • MS Visio 2010/2007/2003.
  • Databases: Oracle 10g/9i/8i/7.0/6.x, Tera data, SQL Server 2008/2005/2003, Sybase, IBM DB2, MS Access 2010/07/03/00, Netezza.
  • Programming Languages: HTML, DHTML, VB 6, Java Script, XML, XSL, SQL, PL/SQL, and T-SQL.
  • Internet: ASP.Net 3.5/2/0, JSP, JavaScript, IIS 7.0/6/5.

Operating Systems: Windows 95/98/NT/2K/XP/2003/Vista, Linux and UNIX.
Professional Experience

Confidential,Chester,PA Feb,2012 – Till Date
Sr.MicroStrategy Developer/Architect

Environment: MicroStrategy Desktop 9.2.1, Advanced Query Tool, Oracle, Excel, and Netezza.

Responsibilities:

  • Participated in requirements gathering to identify the Business user’s needs.
  • Experience with Star Schema, Snow Flake Schema and Hybrid Schema.
  • Worked on facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect and added them to MicroStrategy Project which was created using Project Builder.
  • Created Complex filters with advanced qualifications involving the ‘Apply’ functions.
  • Implemented drill functionality on the reports using Drill Maps.
  • Created compound metrics forcing dimensionality and conditionality. Created HTML documents according to the user perspective. Built Templates for future reporting needs.
  • Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.
  • Designed dynamic dashboards (Performance Summary, Metrics, Dynamic Content, Dynamic Visualization) utilizing different modes (Full screen, Flash, Interactive, View, Editable).
  • Created different Transformations to get the last year actual transactions, week-to-day, week-to-period, week-to-quarter, and week-to-year.
  • Worked with MicroStrategy enterprise manager and Integrity manager.
  • Worked on the performance tuning of the MicroStrategy reports.
  • Performed extensive testing both functional and system on development objects.
  • Worked and coordinated with the QA team for UAT and creating test plans.
  • Interacted with business users in understanding and assisting them regarding any issue during testing and production support.
  • Performed beta and regression testing, test plan creation and Quality Assurance to ensure the right outputs for the reports

Confidential,Rockville, MD Aug, 2010 – Feb,2012
BI (MicroStrategy) Developer/Architect

Environment: MicroStrategy Desktop 9.2.1/9.01, MicroStrategy Architect, MicroStrategy Intelligence Server, MicroStrategy Web, ER Studio, WinSql and Netezza.

Responsibilities:

  • Participated in requirements gathering to identify the Business user’s needs.
  • Involved in creating Logical and Physical Models using ER Studio.
  • Involved in Data Modeling and Data Warehousing Using Multi Dimensional Model, Star and Snow Flake Schemas.
  • Created DDL’s for tables and executed them to create tables in the warehouse for ETL data loads.
  • Assisted ETL developers in writing their ETL logic for table’s population.
  • Involved in design of prototype of reports, documents and dashboards based on requirements.
  • Created MicroStrategy Schema objects and Public objects using MicroStrategy Desktop.
  • CreatedAttributes, Facts, and Hierarchies, logical views, advanced filters, custom groups, consolidations, prompts, metrics (simple, compound, derived, summary and level) and report templates.
  • Created reports, report service documents and dynamic dashboards.
  • Developed few forecasting reports to give exposure towards forecasting to the users.
  • Used grids, graphs and grid-graphs and various formatting techniques in development of report service documents.
  • Used different types of selectors, graphs, bars and widgets in the development of dynamic dashboards for stunning visualizations of data.
  • Used apply functions like apply simple; apply comparison to meet the report requirements wherever necessary.
  • Created ad-hoc reports in grid, graph mode, consisting of data analysis by combining a template with filters, using MicroStrategy Desktop and Web.
  • Used Free-form sql for complex report creation.
  • Used advanced sorting,smart totals, page-by and different functionalities.
  • AppliedOLAPfunctions to calculate metrics.
  • Improved the report performance using VLDB Properties, Caching and created aggregate tables.
  • Implemented drill functionality on the reports using Drill Maps.
  • Implemented Report Services and generated the documents to be distributed to end users usingNarrowcast Subscription.
  • Used MicroStrategy Object Manager to deploy the MicroStrategy Objects from the development stage to the Test stage and then to the Production.
  • Used ScanMD tool whenever necessary to troubleshoot any inconsistencies in the MD.
  • Worked with MicroStrategy enterprise manager and Integrity manager.
  • Worked on the performance tuning of the MicroStrategy reports.
  • Performed extensive testing both functional and system on development objects.
  • Worked and coordinated with the QA team for UAT and creating test plans.
  • Interacted with business users in understanding and assisting them regarding any issue during testing and production support.

Confidential,NJ Mar, 2009 – Aug, 2010 MicroStrategy Developer/Architect

Environment: MicroStrategy 9.0.1/8.1.1,Desktop Reports, Documents, Web Intelligence Reports, Architect, Narrowcast Server, Agent, Dash Boards, VLDB and Sql Server 2008.

Responsibilities:

  • Worked with client to gather requirements and prepare technical specifications Documents.
  • Involved in design of proto type of reports based on requirements.
  • Involved in Dimensional Data Modeling, Star Schema and Snowflake Schema.
  • Created Dash Board Reports using Intelligent Cubes to view personalized reports based on user requirements and used Widgets in the designing.
  • Worked with Object Manager, Command Manager, NCS, Intelligence Server and Web Servers.
  • Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports.
  • Involved in installation and configuration of Microstrategy9.0.1 and MicroStrategy 8.1.1.
  • Creating Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, reports) needed to create the MicroStrategy objects necessary for the deliverable.
  • Involved in up gradation of Schema objects (Attributes, Facts, Hierarchies, and Transformations) and Application objects from 8.1.1 to 9.0.
  • Architected the projects and created all the necessary schema, application and configuration objects.
  • Creating advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
  • Creation ofCanned ReportsandAd-hoc Reportsfrom the Schema Objects and Public Objects.
  • Involved in Developing Reports by using Free Form SQL Queries in MicroStrategy Desktop.
  • Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
  • Involved in creation of Data Mart Reports and Aggregate tables to improve performance of reports.
  • Register and loads MicroStrategy project for three-tier (Client connects to metadata thru server) and using MicroStrategy Intelligence Server.
  • Create database instances, connections, and logins.
  • Set up security for Project Administrators.
  • Creates governing for MicroStrategy projects such as maximum values for report execution time, report result rows, number of executing jobs per users (not to exceed server maximum values).
  • Scheduled reports through the MicroStrategy Narrowcast server and created services to deliver a wide range of personalized information to users through email.
  • Creates Statistics databases for Enterprise Manager.
  • Maintains the integrity of the metadata using ScanMD and MD doctor.
  • Maintains and configures test and production servers.
  • Scheduled administrative tasks.
  • Interfaces with MicroStrategy support for technical issues.
  • Experienced in using MicroStrategy SDK and Web Customizations.
  • Executes Object Manger to migrate objects from one project environment to another.
  • Assist Project Administrative and Project Team Members with Data Warehouse Support.
  • Intensively working with complex PL/SQL stored Procedures, Packages, Constraints, Functions and Triggers.
  • Strong proficiency in using SQL Query Analyzer to run the queries and scripts against SQL Server.
  • Involved in optimization of code and tuning queries for performance using Sql Server.
  • Implementation of MicroStrategy office to publish the MicroStrategy reports in Excel.
  • Performed beta and regression testing, test plan creation and Quality Assurance to ensure the right outputs for the reports.

Confidential,Utah Jan, 2008 – Feb, 2009 MicroStrategy Developer/Architect

Environment: MicroStrategy 8.1.1(Agent, Architect, Intelligent Server, Web, Narrowcast Server, Desktop), Dynamic Dashboards and Oracle 10g.

Responsibilities:

  • Involved in Data Modeling and Data Warehousing Using Multi Dimensional Model, Star and Snow Flake Schemas.
  • Worked with the source systems to have a clear understanding of the data flow and interacted with the users to collect the business requirements.
  • Created the requirements Documentation for the MicroStrategy projects and also documented the MicroStrategy Environment.
  • ETL plans and data validation .Developing and executing SQL scripts to test data between source and target.
  • Responsible for maintaining the Intelligence Server, maintaining the Metadata repositories for different environments, taking regular backups of the Metadata, maintaining the MicroStrategy Web Servers, used Command Manager Scripts for user role creation etc.
  • Used MicroStrategy Object Manager to deploy the MicroStrategy Objects from the development stage to the Test stage and then to the Production.
  • Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect and added them to MicroStrategy Project which was created using Project Builder.
  • Worked extensively on creating Application Objects like Metrics and Compound metrics, Filters, and Custom Groups for complex reports.
  • Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.
  • Created Complex filters with advanced qualifications involving the ‘Apply’ functions.
  • Created Transformations (table based, formula based) for using in comparative reports like sales this year to sales last year.
  • Implemented drill functionality on the reports using Drill Maps.
  • Created compound metrics forcing dimensionality and conditionality. Created HTML documents according to the user perspective. Built Templates for future reporting needs.
  • Designed dynamic dashboards (Performance Summary, Metrics, Dynamic Content, Dynamic Visualization) utilizing different modes (Full screen, Flash, Interactive, View, Editable).
  • Worked extensively on writing stored procedures, triggers, views and joins using Oracle 10g.
  • Reviewed, analyzed, and modified Oracle Forms/Reports application including encoding and debugging.
  • Performed extensive Quality Assurance on data and MicroStrategy reports.

Confidential,Irving, TX Mar, 2007 – Dec, 2007
MicroStrategy Developer/Architect

Environment: MicroStrategy Desktop 8.0.2, MicroStrategy Architect 8.0.2, MicroStrategy Intelligence Server 8.0.2, MicroStrategy Web 8.0.2, Erwin 7.1, Sql Server 2005.

Responsibilities:

  • Responsible for gathering and refining business requirement from the Business users.
  • Involved in creating Logical and Physical Models using Erwin.
  • Generated and implemented MicroStrategy Schema Objects and Application Objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy Desktop and Architect.
  • Worked extensively on creating Application Objects like Metrics, Filters, Custom Groups and Consolidations for complex reports.
  • Created different Transformations to get the last year actual transactions, week-to-day, week-to-period, week-to-quarter, and week-to-year.
  • Created three types of reports Enterprise reports, Dashboard analysis reports, and Ad-hoc reports.
  • Extensively used MicroStrategy Report Service to generate electronic snapshots of business data and presented them in a visually appealing and intuitive format.
  • Implemented Star and Snow Flake Schema to fit reporting, query and business analysis requirements.
  • Created Dashboards to present critical company data in a single report.
  • Based upon the business user change request on UAT testing, implemented Report Data Options, Formatting, Dynamic Dates, Advanced Sorting, Prompt Ordering
  • Improved the report performance using VLDB Properties, Caching and created aggregate tables.
  • Assisted DBA to design and create Tables in the Oracle database to improve the performance of reports.
  • Worked on complex queries, stored procedures, views and joins using Sql Server 2005.
  • Involved in SQL tuning process to increase the speed of queries in database.

Confidential,Norwalk, CT Apr, 2006 – Feb, 2007
MicroStrategy Consultant

Environment: MicroStrategy Desktop 7.5/8.0, MicroStrategy Web, MicroStrategy Intelligence Server, SQL Server 2005, Oracle 9i, Erwin Data Modeler 3.5.2.

Responsibilities:

  • Developed new reports and converted existing reports for the business line to satisfy the specifications.
  • Contacted ETLand data modeling team in building of data models.
  • Worked with Erwin Data Modeler tool for creating data models.
  • Resolved attribute role problems in Data models by developing table Aliases and Attribute Role recognition methods in VLDB settings.
  • Created reports objects such asFilters, Metrics and Templatesin MicroStrategy Desktop.
  • Designed report templates to generate reports in grid and graph mode.
  • Upgraded from MicroStrategy 7.5 version to MicroStrategy 8.0.
  • Created Drill Maps to obtain aggregated results.
  • Used MicroStrategy functions such asApply Simple, Apply Comparison in the metric calculations and used in different reports.
  • Used advanced sorting,smart totals, different types of prompts such as object, value, hierarchy etc.
  • AppliedOLAPand statistical functions to calculate metrics.
  • Extensively used MicroStrategy Desktopto enable users to run pre-defined sales and inventory reports.
  • Designed manyPromptswith different options like Filters, Objects and Value to facilitate ad hoc reporting.
  • Scheduled reports through the MicroStrategy Narrowcast server and created services to deliver a wide range of personalized information to users through email.
  • Dealt with users to gather document requirements and createdDocumentsas per the requirement.
  • Wrote simple and complex queries, stored procedures, views and joins using SQL Server and Oracle.

Confidential,Atlanta, GA Jan, 2005 – Mar, 2006
MicroStrategy Developer

Environment: MicroStrategy 7.5/7.2.3 (Administrator, Web, Desktop), Oracle 8i, SQL Server, Windows.
Responsibilities:

  • Analyzed the business requirements identifying the requirements reviewing and communicating with business and getting sign offs from business.
  • Created system delivery specification documents Technical Specification document and test plans.
  • Coordinated test plans and provided feature/functionality/usage scenarios for the Managers.
  • Used MicroStrategy Desktop to generate Advanced Reports.
  • Upgraded from MicroStrategy 7.2.3 to 7.5.
  • Designed and Developed Reports with challenging requirements which are used to dramatically improve Customer services.
  • Created MicroStrategy Schema objects and Application objects using MicroStrategy Desktop.
  • Created Metrics, Prompts, Filters, and Custom Groups for the report development.
  • Worked on the performance tuning of the MicroStrategy reports.
  • Analyze and develop the new objects in Dev environment and after testing the objects and reports migrated to Production Environment.
  • Created Logical views in MicroStrategy for complex report creation situations.
  • Used free form SQL editor for complex report creation.
  • Used apply functions like apply simple to meet the report requirements wherever necessary.
  • Created ad-hoc reports in grid, graph mode, consisting of data analysis by combining a template with filters, using MicroStrategy Desktop and Web.
  • Worked and coordinated with the QA team for UAT.
  • Used MicroStrategy Administrator for accurate information regarding system usage and performance.
  • Worked on the performance tuning of the MicroStrategy reports.
  • Employed MicroStrategy Desktop in designing the MicroStrategy projects.
  • The business rules of the data warehouse were implemented in MicroStrategy Architect.
  • Validated end user report requests using SQL and MicroStrategy tools.

Hire Now