We provide IT Staff Augmentation Services!

Sr. Microstrategy Architect/ Developer Resume

Herndon, VA

SUMMARY:

  • 10+ years of IT experience in Software Application Design, Build, Testing and Documentation.
  • 7 years of extensive experience working with all aspects of MicroStrategy suite.
  • Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
  • Well versed with the various databases like SQL Server, Oracle, Teradata, DB2
  • Created Active Reports which made offline analytics easy to get truly portable business intelligence.
  • Written SQL queries to conduct unit testing for various reports
  • Interacted with Business Users for Requirements gathering and coordinated on UAT efforts
  • Strong hands - on experience on advanced report development.
  • Extensively worked on schema objects such as Facts, Attributes and Hierarchies.
  • Strong knowledge in creating application objects such as Metrics, Filters, Reports and Templates.
  • Implemented parameterized URL’s for one-click operation from any Oracle interface
  • Designed and created KPI Dashboards for the Manufacturing cost analysis
  • Developed and maintained a high level of Active Decision Engine dashboards and reports.

TECHNICAL SKILLS:

Reporting Tools: MicroStrategy 10.7/10.4/10.2/9.0/8.1.2/8.1/8.0 (MicroStrategy Architect, MicroStrategy Desktop), Cognos 8.1, 8.2, 8.3, 8.4, 10.1.1, 10.2.1, Report Studio, Query Studio, Analysis Studio, Event Studio, Framework Manager, Tableau 7.x/8.x

Databases: Teradata, SQL Server 2000/2005/2008/2012 , MS Access, DB2, and Oracle 10g/9i/8

Web Servers: IIS, Apache

Microsoft Office: MS Access, MS Word, MS Excel and PowerPoint

Operating Systems: Windows 9x/NT/2000/2003/XP/Vista/7

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

Sr. Microstrategy Architect/ Developer

Responsibilities:

  • Worked on the Treasury MSTR Reporting for the CMDM project.
  • Helped enhance the reporting structure to better suit the treasury reporting business model.
  • Supported the day to day business activity.
  • Worked in a fast paced agile environment with 2 week delivery cycle.
  • Performed data analysis and validations using complex SQL queries
  • Generated Freeform SQL reports writing SQL queries against different databases.
  • Created cubes and dashboards using multiple sources
  • Handled the creation and migration of packages to higher environments.
  • Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
  • Responsible for production support activities.

Environment: MicroStrategy 10.7, Oracle 11g, Netezza, Windows 10, Sql Server

Confidential, Owings Mills, MD

Sr. Microstrategy Architect/ Developer

Responsibilities:

  • Worked on the complete life cycle of the FADS project for the GBS-IO team.
  • Developed the model from scratch based of the functional and technical specs provided.
  • Worked on end-to-end implementation of the model and reports.
  • Created several documents and dashboards based on the requirements.
  • Created mapping document for the master schematic table
  • Performed data analysis and validations using complex SQL queries
  • Generated Freeform SQL reports writing SQL queries against different databases.
  • Worked with the users to create reports based on the requirements.
  • Worked extensively on creating Compound metrics, Filters, and Custom Groups for complex reports
  • Good understanding of views, Synonyms, Indexes, Joins and Partitioning.

Environment: MicroStrategy 10.4, Oracle 11g, Windows 7

Confidential, Baltimore, MD

Microstrategy Architect/ Developer

Responsibilities:

  • Worked on reports/documents/Icubes for the BO Sunsetting project team.
  • Worked extensively on creating Application Objects like Metrics and Compound metrics, filters and Custom Groups for complex reports.
  • Created mapping document for the master schematic table
  • Performed data analysis and validations using complex SQL queries
  • Generated Freeform SQL reports writing SQL queries against different databases.
  • 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 Compound metrics, Filters, and Custom Groups for complex reports.

Environment: MicroStrategy 10.2, Oracle 11g, Windows 7

Confidential, Wilmington, DE.

Microstrategy Architect/ Developer/ Analyst

Responsibilities:

  • Working on reports for the CCB Complaints/ Voice of Customer (VOC) team.
  • Developed Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships like one-to-one, one-to-many and many-to-many between different attributes.
  • Gathered requirements for the Customer Complaints dashboard.
  • Developed functional requirements documents by interacting with the IT personnel and the Business users
  • Performed analysis on views and documented the findings.
  • Modified VLDB Settings to tune the reports for faster execution.
  • Created Ad-hoc Reports by drilling up, down, with across hierarchies.
  • Assisted in mining data from the SQL database that was used in several significant presentations.
  • Created mapping document for the master schematic table
  • Performed data analysis and validations using complex SQL queries
  • Interacted with DBA and Data Modeler to build Dimensional Data Models (Star Schema, Snow-Flake Schema)
  • Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
  • Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
  • Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP and OLAP
  • Good understanding of views, Synonyms, Indexes, Joins and Partitioning.

Environment: MicroStrategy 9.0/8.1.2, Tableau 8.1/8/2, Teradata, Oracle 11g, Windows 7

Confidential, Charlotte, NC

Microstrategy Developer/ Analyst

Responsibilities:

  • Analyzed and converted Business Requirements to Technical Specifications
  • Performed weekly and monthly documentation tasks of all the updates in the reports.
  • Developed functional requirements documents by interacting with the IT personnel and the Business
  • Presented analysis in both Numerical and Graphical methods for better visualization of data.
  • Performed analysis on views, stored procedures and documented the findings..
  • Coordinated with the DBA for table creation, loading data and other administrative activities.
  • Designed and developed logical data model for MicroStrategy reporting environment.
  • Worked extensively on developing Metrics and Compound Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports using MicroStrategy 9.0.
  • Implemented Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports. .
  • Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets.
  • Generated Freeform SQL reports writing SQL queries against different databases.

Environment: MicroStrategy 9.0, Desktop, Architect, Web, Integrity Manager, Object Manager Oracle, SQL Server 2012, SVN Tortoise

Confidential, El Segundo CA

MicroStrategy Developer/ Analyst

Responsibilities:

  • Worked on the Data modeling for Business Process specific Data Mart provided solutions for complex Time Dimension related issues and analysis.
  • Worked extensively on creating schema objects like Attributes, Facts and Hierarchies.
  • Generated reports using Advanced Metric Objects, Dynamic Filters, Custom Groups and Consolidations and thus provided users with the facility to create customized reports by creating their own filters and templates.
  • Created Transformations (table based, expression based) for using in comparative reports like claims this year to last year (year to date and month to date).
  • Extensively worked on dashboards using KPI’s displaying advanced graphic options and widgets and performing OLAP analysis directly on dashboards.
  • Worked on tasks like Caching, Report Optimization, Tuning, and Specifying Query Governing Optimization.
  • Used Pass-Through Functions in Attributes, Metrics, and Filters.
  • Used Integrity Manager to test the individual reports and whole project required after the migrations from one environment to other.
  • Intensively performed Unit Testing and data validation (QA) of the reports.
  • Assisted Business Analysts and interacted with business users extensively in gathering information about the deliverables and identifying the reporting needs of the end user.
  • Created the requirements documentation for the project.

Environment: MicroStrategy 9.0, DB2, Teradata, SQLServer 2012

Confidential, Scottsdale, AZ

Cognos BI Developer

Responsibilities:

  • Analyzed the actuate requirements and converted them to Cognos reporting specs.
  • Created conditional formatted reports using tokens and conditional blocks.
  • Created reports for dynamically sorted columns
  • Created customized reports to meet the business requirements CSV, TAB, XML, PDF, and HTML.
  • Created reports with special characters based on the sample report outputs for the smooth transition to XSLT processing and post java processing.
  • Created test cases for each of the reports developed.
  • Conducted extensive testing and followed specific test procedure based on Report output

Environment: Cognos 10 (Framework Manager, Report Studio), Oracle 10g, SQL Developer, Windows 7.

Confidential, Thousand Oaks, CA

Sr. Cognos Developer

Responsibilities:

  • Worked closely with the business to understand the reporting needs and built a suitable FM model.
  • Enhanced the existing FM model and optimized the performance
  • Built flexible Framework Models to handle current and proposed future reporting requirements.
  • Used SQL to create the query subjects in Framework Manager.
  • Optimized the model using less number of joins in the SQL.
  • Developed various complex reports in Report Studio.
  • Created reports using conditional blocks, multiple prompts, dynamic sorting.
  • Documented all the development and enhancement carried out on the reports and models.
  • Created mapping documents to identify the source data that is being reported.
  • In charge of the weekly deployments of Reports and Packages to production
  • Created data source connections, applied package level security in cognos connection
  • Migrated packages and reports from Cognos 8.4 to Cognos 10 versions.
  • Conducted end to end testing during the migration in each environment
  • Maintained a document database for all the migrations and deployments.

Environment: Cognos 8.2/8.3/8.4/10 (Framework Manager, Analysis Studio, Report Studio, Query Studio), Oracle 10g, PL/SQL Developer, Windows Vista, Cognos Data Manager

Confidential, Charlotte, NC

Cognos BI Developer/ Analyst

Responsibilities:

  • Used Framework Manager to model metadata from different Oracle sources for use in Report Studio
  • Responsible for migrating packages (deployment archives) from Dev to QA and QA to Prod
  • In charge of the weekly deployments of Reports and Packages to production
  • Created reports based on user requirements using conditional formatting, conditional blocks, page breaks
  • Used standard Noetix views to create custom reports for the various business areas
  • Supported the report requests from business to modify and enhance the reports
  • Created forecast reports using List, Crosstab and Charts for better visualization both numerically and graphically
  • Creating dashboard reports with drill through capability for the higher management
  • Implemented parameterized URL’s for single click operation from Oracle standard reports
  • Was part of development and support team for 2 entire Go-Live cycles
  • Unit testing, Integration testing and Performance testing of reports after development
  • Performance optimization of Framework Manager models

Environment: Cognos 8.2/8.3/8.4, Oracle 10g, Noetix, Windows XP, Confidential AIX

Hire Now