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