We provide IT Staff Augmentation Services!

Senior Microstrategy Architect / Microstrategy Developer Resume

3.00/5 (Submit Your Rating)

Owings Mills, MD

PROFESSIONAL SUMMARY:

  • Over 8+ years of total IT with 7+ years of experience on MicroStrategy BI suite full life cycle implementation. Well - versed experience in Business Intelligence in Project Development, Implementation and administration using MicroStrategy 8.X/9.X/10.1 to 10.4 product suites including MicroStrategy Desktop, Web, Architect, Administrator, Intelligent Server, Metadata, Narrowcast Server, Enterprise Manager, etc.
  • Expertise in Project Planning, Resource Planning and presentation of Proof of Concepts (POC).
  • Experienced in various project management methodologies like Sprint, Agile, SCRUM and Water Fall based.
  • Expertise in Creation of Reports, Report Service Documents, Static and Dynamic Dashboards.
  • Expertise in creating interactive dashboard (Visualization) Reports and Scorecards to view personalized reports based on user requirements.
  • Implement agile management ideals by facilitating exercises such as sprint planning and team leading standups.
  • Manage project timelines and communicate with management staff and clients to ensure project progress satisfactorily.
  • Led sprint reviews and daily scrum meetings to touch base with whole team and ensure that all members were performing satisfactorily.
  • Ability to analyze existing reports & systems and strong experience in gathering reporting requirements.
  • Expertise in implementation of MicroStrategy OLAP services (including Intelligence Cubes, Dynamic souring reports).
  • Expertise in working closely with the MicroStrategy Tech Support team to implement the new features in the tool.
  • Expertise in Architecting MicroStrategy Schema (including Attributes, Facts, Hierarchies, Transformations).
  • Expertise in creation of Public Objects (Metrics, Filters, Prompts, Custom Groups, Consolidations).
  • Experience in optimization of code and tuning queries for performance.
  • Expertise in Security Implementation using LDAP authentication, Single Sign on.
  • Highly efficient in Problem solving and trouble shooting skills.
  • Expertise in creation of Dynamic and Multi panel dashboards using various Widgets and Selectors.
  • Created Dashboards in Flash and DHTML mode.
  • Very strong in developing Proactive Delivery Reports and implementing Business Intelligence Solutions on the web using MicroStrategy Narrowcast Server.
  • Expertise in Creating MicroStrategy Project Initiations process and implementing Architecture Solutions for development.
  • Expertise in Installations and Configurations of MicroStrategy tool.
  • Extensive work experience with Ad hoc Reporting and Standard Reporting Environment.
  • Experience in Business Functionality Implementations, Developing Data Models, Data Warehouses, and Data Marts from Logical Models as per specific business requirements.
  • Experience in Designing and Modeling the Data for Data Warehouse using the different Data Modeling Tools Erwin and worked using in freeform SQL.
  • Strong knowledge and understanding of SQL and ability to write SQL queries.
  • Proficient in Analysis, Design and Development of applications using ORACLE, Teradata, SQL Server and MS Access as Backend. Develop the reports against Star Schema and Snow-Flake Schema.
  • Expertise in creating complex reports like Drill down and Sub Reports and implementing Conditional Formatting, Interactive Sorting, Grouping and Filtering.
  • Expertise in handling the Datasets using complex queries and stored procedures for generating reports and deploying in various sources like Web browser, XML and PDF.
  • Expertise in Metrics, Graphs, Data group, Explore the data, Visualize the data, Drill Through the data, Adhoc reports.
  • Well-Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Initiation, Analysis, Design, Coding, Testing, Implementation and Support.
  • Worked on SDK for web Customization and integrating with the BI Platform.

SOFTWARE SKILLS:

Business Intelligence: MicroStrategy 10.1 to 10.4 /9.X/8.X (Architect, MicroStrategy Agent, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server)

Databases: Oracle 8.0/9.1/10g,11g MS SQL Server 2000/2005/2008 , DB2, Teradata, Hadoop.

ETL Tools: Informatica 8.x/7.x, Data stage 8, Business Objects Data Integrator, SSIS.

Operating Systems: Windows XP/ 2003/2000/98/ NT.

Programming Languages: SQL, PL/SQL, VB.NET and C #.NET, ASP.NET, JAVA Visual Basic 6.0/5.0, C and C++

Others: HTML 4.0, DHTML, XML, JavaScript, MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, Owings Mills, MD

SENIOR MicroStrategy Architect / MicroStrategy Developer

Responsibilities:

  • Performed Customer Requirements Gathering, Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and post production support of BI projects.
  • Implement agile management ideals by facilitating exercises such as sprint planning and team leading standups.
  • Manage project timelines and communicate with management staff and clients to ensure project progress satisfactorily.
  • Led sprint reviews and daily scrum meetings to touch base with whole team and ensure that all members were performing satisfactorily.
  • Operational and Maintenance (O&M) Responsibilities include: Planning and managing the development related activities.
  • Upgraded Micro strategy environments from v 9.3 to 9.4, 10.1, 10.2 and 10.4 versions.
  • Extensively worked on Project Planning, Resource Planning and presentation of Proof of Concepts (POC) which has been selected, implemented and given the Award fee for the projects from CMS.
  • Work with development manager to support various functions including Code review Audits, System Architecture and Analysis, Design, and coding.
  • Worked on the D3 Widgets and implemented the D3 Widgets in to the MicroStrategy.
  • Conduct Periodic development meetings with project teams in an agile environment. Supported various small and large projects in the program.
  • Created technical documentation, conduct technical and development related brainstorming sessions with various project teams.
  • Developed Reports by using Free form SQL Queries in MicroStrategy Desktop.
  • Adoption of Agile integrated with CMS mandated XLC project management methodology. Ensure project teams use and apply standard operating procedures devised by the core team.
  • Consistently provide production support on various project for the CMS users through End User Notifications (EUN) requests.
  • Given the new thoughts of the rebranding the existing projects with a new look and feel of the reports in by using MicroStrategy Visual insight.
  • Improved Report performance using VLDB properties, Caching.
  • Worked on Web customization, added Web custom log and Web custom text on login page.
  • WAR files deployment on Web Application Server.
  • Extensively worked in both Ad-hoc and standard reporting environments and involved in creating reports scalable to large volumes of data. Managed projects through entire system development life cycle, including creating timely/through status reports and leading status meetings.
  • Worked on Transactional Database on incorporating with MicroStrategy and deployment C on Web Application Server.
  • Worked on Intelligence Server Clustering, Configured Enterprise Manger reports.
  • Involved in monitor the statistics about objects, reports and user sessions by using Enterprise Manager.
  • Worked on creating OLTP Reports according to the business requirements.
  • Loaded the data warehouse tables with the OLTP files for reporting on MicroStrategy.
  • Created Services using Subscription sets, Schedules and Unit tested the reports developed by the other developers.
  • Created metrics, advanced metrics (level metrics, transformation metrics and conditional metrics).

Environment: MicroStrategy 10.4/10.2/10.1/9.4/9.3/ 9.0.2/9.2.1/9.3 , Distribution Services, MicroStrategy SDK, Administration, Enterprise Manager, MS SQL Server 2000, Linux, Oracle 11g, Informatica 7, Web Application Server.

Confidential, St Louis, MO

MicroStrategy Architect / MicroStrategy Developer

Responsibilities:

  • Developed Flash Dashboards in 9.0.2 using Widgets and Selectors for summary level reporting.
  • Extensively worked with MicroStrategy Intelligence Servers, MicroStrategy Web and MicroStrategy Administrator reporting basics using MicroStrategy Desktop and MicroStrategy Web.
  • Revision/update of MicroStrategy reports that change as a result of Engineering release related changes to the data warehouse structure and functionality.
  • Involved creating Cubes and data Marts.
  • Upgraded Micro strategy environments from v 9.0.2 to 9.3, 10.1, 10.2 and 10.4 versions.
  • Worked on Project Consolidation using project Duplicator and Intelligence Server Clustering.
  • Worked on Mobile device and security like device control and data protection for IOS.
  • Worked on Mobile IOS native protection for applications and Configured Enterprise Manger and worked on reports.
  • Worked on Web customization, added Web custom log and Web custom text on login page.
  • Worked on Transactional Database on incorporating with MicroStrategy and deployment WAR files on Web Application Server.
  • Supported on the Operation and Maintenance (O&M) on the existing projects.
  • Involved in monitor the statistics about objects, reports and user sessions by using Enterprise Manager.
  • Worked on creating OLTP Reports according to the business requirements.
  • Used MicroStrategy Web to offer interactive reporting to the end users through a web browser.
  • Did Web customization, added Web custom log and Web custom text on login page.
  • WAR files deployment on Web Application Server.
  • Upgraded Micro strategy v 9.2.1 to Micro strategy v 9.3.
  • Loaded the data warehouse tables with the OLTP files for reporting on MicroStrategy.
  • Created Services using Subscription sets, Schedules and Unit tested the reports developed by the other developers.
  • Involved in creation of schema objects Attributes, facts, hierarchies and transformations for development of application objects on of it.
  • Created metrics, advanced metrics (level metrics, transformation metrics and conditional metrics).
  • Created Multi layout and multi panel documents and dashboards with the widgets.
  • Created filters, prompts (Object prompt, Level prompt, filter definition prompt) for creation of MicroStrategy reports.
  • Worked on Object Manager, Command Manager.
  • Optimized query performance by updating VLDB (very large database) properties and by modifying cache behavior.

Environment: MicroStrategy 9.0.2/9.2.1/9.3 , Distribution Services, MicroStrategy SDK, Administration, Enterprise Manager, MS SQL Server 2000, Linux, Oracle 11g, Informatica 7, Web Application Server.

Confidential, Atlanta, GA

MicroStrategy Developer/ Mobile Web Analyst/ MicroStrategy Architect

Responsibilities:

  • Created Star schema to develop the data mart in the data warehouse.
  • Involved in creation of schema objects Attributes, facts, hierarchies and transformations for development of application objects on of it.
  • Created hierarchies metrics, advanced metrics (level metrics, non-aggregate metrics, transformation metrics and conditional metrics).
  • Created Dashboards using MicroStrategy 9x using OLAP / OLTP Data.
  • Worked on configuring Mobile server and created reports using it.
  • Created filters, prompts (Object prompt, Value prompt, Level prompt, filter definition prompt) for creation of MicroStrategy reports.
  • Applied My Preferences to make changes at Project Level and Desktop Preferences to make changes for all Projects of Desktop.
  • Optimized query performance by updating VLDB (very large database) properties and by modifying cache behavior.
  • Used Explain plans to analyze the Queries generated by Microstrategy to identify the areas for Performance improvement and worked with the DBA teams in finding solution and used freeform SQL for writing queries.
  • Involved in trouble shooting report results and monitor the statistics about objects, reports and user sessions by using Enterprise Manager.
  • Used MicroStrategy Web to offer interactive reporting to the end users through a web browser.
  • Involved in upgrading Micro strategy v 8.0.2 to Micro strategy v 9.0.1.
  • Created Services using Subscription sets, Schedules, Information objects.
  • Unit tested the reports developed by the other developers.

Environment: MicroStrategy 9.0.1, Narrowcast Server, MicroStrategy SDK, Administration, Enterprise Manager, MS SQL Server 2000,T-SQL, Access 2000, Teradata, Linux, Informatica 7.

Confidential, Charlotte, NC

MicroStrategy Developer/ MicroStrategy Architect

Responsibilities:

  • Involved in design of proto type of reports based on requirements.
  • Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis.
  • Used Mobile SDK for Web Based customization.
  • Used MicroStrategy Web for the deployment of reports and Dynamic dashboards.
  • Responsible for keeping team members on track toward completing the terms of goals.
  • Involved in installation and configuration of MicroStrategy 8.1.1v.
  • Deployed reports using MicroStrategy web in the OLTP environment.
  • Creating Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, reports) needed to create the MicroStrategy objects necessary for the deliverable.
  • 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.
  • Created ad-hoc reports by drilling up, down, within and across Hierarchies.
  • Involved in creating Security filters to end users to access data Based on their privileges.
  • Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
  • Involved in creation of Datamart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
  • Set-up the narrowcast environment and created services using subscription sets, schedules, Information objects.
  • Creating Dash Board Reports to view personalized reports based on user requirements.
  • Involved in the Creation Document from multiple Datasets like Map Application Diagram, Grid and graph.
  • Involved in Developing Reports by using Free Hand SQL Queries in MicroStrategy Desktop.
  • Involved in customization of Grids and Graphs by using SDK.
  • Involved in migration of Schema Objects (facts, attributes, hierarchies, Transformations), Application Objects (filters, prompts, metrics, consolidation, custom groups), user groups from 8.0.2 to 8.1.1v.
  • Involved in partitioning the tables, indexes and management of the schema objects.
  • Involved in optimization of code and tuning queries for performance.
  • Involved in tuning the application Queries using Explain Plan.
  • Create a test plan, perform unit test and send the test plan along with the files generated for QA.
  • Provided post production support to end-users.

Environment: Micro Strategy v8.0, Micro Strategy v9.0 Desktop Reports, Web Reports, Architect, Narrowcast Server, Administration, Dash Boards, Unix, Toad, SDK, Oracle 10g, Oracle10g r2, PL/SQL, Oracle.

Confidential, SFO, CA

MicroStrategy Developer

Responsibilities:

  • Worked with client to gather requirements and prepared technical specifications.
  • Created Star schema to develop the data mart in the data warehouse.
  • Communicate offshore working team to explain client requirements and develop reports.
  • Involved in creation of schema objects Attributes, facts, hierarchies and transformations for development of application objects on top of it.
  • Involved in creation of Advanced Metrics like Conditional, Level, Non-Aggregation, Rank and Transformation Metrics.
  • Created three types of reports to show the users - Enterprise reports, Dashboard analysis reports, Ad-hoc reports.
  • Created filters, prompts for creation of MicroStrategy reports.
  • Involved in development interactive dashboards and scorecards for High level Management.
  • Optimized query performance by updating VLDB (very large database) properties and by modifying cache behavior.
  • Involved in importing LADP Users and user groups into MicroStrategy metadata.
  • Customized the drilling options specific to the reports using drill map editor to give access to more detailed and supplemental information.
  • Involved in trouble shooting report results by using administration.
  • Involved in customization of web pages and home pages by Java.
  • Involved in monitor the statistics about objects, reports, and user sessions by using Enterprise Manager.
  • Extensively used OLAP services to Optimized Memory Use and Improve performance of the query.
  • Used Micro Strategy Web to offer interactive reporting to the end users through a web browser
  • Created services using subscription sets, schedules, Information objects.
  • Responsible for writing procedures drop and create partitions of large volume tables for the archival process.

Environment: MicroStrategy 8.x, Oracle 8, PL/SQL, IBM-AIX, Sybase, sql server 2005

Confidential

MicroStrategy Developer / Database Developer

Responsibilities:

  • Created database for production environment In Oracle.
  • Created users, roles and privileges on the Oracle databases.
  • Created user groups, roles, privileges using Business Objects Supervisor.
  • Created and configured database for development and production environments in SQL Server.
  • Created tables in SQL Server 6.5.
  • Developed stored procedures and database triggers using PL/SQL.
  • Database and log backups & restoration, backup strategies, scheduling the backups, backing up System & User Databases and restoring them when necessary.
  • Monitor & tune SQL scripts, creating upgrade scripts for production Database and supporting it.
  • Performance monitoring and tuning of SQL servers and Data transfers using BCP.
  • Setting up the monitoring triggers on NT for SQL Server Databases.
  • Exhibited extensive interaction with end users in finding their needs.
  • Involved in architecting Fact columns and development of Hierarchies with related Attributes required for reporting.
  • Generated and implemented Micro Strategy reports by creating projects, attributes, hierarchies, metrics, filters, and templates using Micro Strategy Desktop and Micro Strategy Web.
  • Worked extensively in developing Metrics, Compound Metrics and Filters for complex reports.
  • Involved in troubleshooting prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
  • Automated and improved existing manual processes. Optimized the server platforms using caching, scheduling, and clustering.
  • Created Transformations for comparative reports like sales this year to date, Month to date, Quarter to date etc.
  • Provided access to Micro Strategy platform from a Microsoft Excel 2000 (Non- Micro Strategy Interface) by using OLAP Provider.
  • Created aggregate tables, controls tables, staging tables in Teradata.
  • Designed ETL process to extract data from SQL server2000 and SAS to Teradata and performing data scrubbing, restructuring and consolidation for Web reporting.
  • Performed bulk data load from multiple data source (ORACLE 8i, legacy systems) to Teradata using BTEQ, Fast Load, MultiLoad, TPump, and Fast Export.
  • Used Informatica 5.0 as an ETL tool to extract data from source systems to Target system. Have good experience in Repositories, like maintaining versions of repositories, managing users and upgrading repositories.

Environment: NCR Teradata V2R3, Fast Load, MultiLoad, Fast Export, BTEQ, TPump, MicroStrategy 8.x, SQL* Plus, PL/SQL Oracle7.i, Oracle8.0/8i, Informatica (Designer5.1, RepositoryManger5.1, ServerManager5.1), Windows NT.

We'd love your feedback!