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