SUMMARY:

• 8+ years of experience in Information Technology, with major focus on Business Intelligence.
• Extensive experience with MicroStrategy 9, 9.2, 9.2.1, 8.0, 8.1, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy OLAP, MicroStrategy Architect.
• Strong experience with full Software Development Life Cycle(SDLC) which includes Requirement Analysis, Design, Development, Implementation, Testing, Deployment, Production Support, Maintenance, Built and Release management.
• Worked with business subject matter experts, gathered requirements, performed data analysis on operational systems to verify business assumptions.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, etc.) with the data warehouse.
• Expertise in creating Hyper Links in Documents and Drill Reports.
• Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of database flexibility, caching, security and scalability issues suited for Oracle, Teradata, DB2 and SQL Server.
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Drill maps, Custom Groups and Consolidations.
• Worked with Logical and physical modeling along with design and implementation.
• Experience in Micro Strategy mobile supporting both Android and IOS platforms.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Created MicroStrategy User Accounts and User Groups with different Security Roles and assigned various Security Filters.
• Used MicroStrategy tools like Object Manager to migrate the objects/projects between MicroStrategy environments and MicroStrategy Command Manager to run the automated scripts.
• Experience in designing mock up reports for client demos.
• Hands on experience on Microstrategy.
• Created different kind of Dashboards like traditional performance summery, traditional metric, dynamic content in both the interactive & flash mode.
• Demonstrable ability to translate business requirements into technical requirements.
• Experience in Sending Weekly and Monthly Status Reports to Client/Higher Management.
• Well - Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.
• Strong organizational / communication skills.
• Good leadership qualities with experience in training developers, advising technical groups on coding best practices.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 10/9.x/8.1.x (Intelligence Server, Administrator, Desktop/Developer, Architect, Web, Distribution Services, Visual Insight, Narrowcast Server, Mobile, Integrity Manager, OLAP), Cognos 10.

ETL Tools: Informatica Power Center 9.x/8.x, SQL Server SSIS services.

Databases: Oracle11g/10g/9i, Teradata 13.x/V2R6, Sybase, Netezza, MS SQL Server

Programming: PL/SQL, SQL Loader, SQL Plus, TSQL, C, C++, HTML, CSS, JavaScript

Operating Systems: Windows Servers, UNIX, Linux

Other Tools: Toad, PL/SQL Developer, SQL Assistant, MS Office, Microsoft Visio, Erwin

WORK EXPERIENCE:

MicroStrategy Developer

Confidential, Dallas, TX

Responsibilities:

• Interacted with Business Analysts, Business Users and Product Managers for gathering, Analyzing, Documenting Business Requirements, Functional Requirements and Data Specifications.
• Performed Customer Requirements Gathering, Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post Production support.
• Took part in full data warehousing application lifecycle starting from creating logical and physical data model, to implement and test ETL processes in Netezza environment.
• Created Schema Objects using MicroStrategy Desktop and Architect.
• Extensive Experience on creating all types of Filters, Prompts, Templates, Metrics, Consolidation and Custom Groups.
• Designed and Developed Reports and Report Service Documents with challenging requirements.
• Created dashboards in Interactive/Flash Mode by using multiple Panels, Selectors and dynamically passed multiple values from the selectors to the reports linked in Dashboard.
• Used Pass through Functions like Apply Simple & Apply Comparison to meet the report requirements wherever necessary.
• Used several Widgets and controls to Design and Develop Dashboards in Flash like all graph types, Heat maps, Gauge, Time slider, Fish Eye etc.
• Used different types of selectors/controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Worked extensively with the End Users to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Created logical views in MicroStrategy for complex report creations situations.
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Developed Schema Objects including attributes, facts, Hierarchies, Transformations.
• Experienced in doing the quick POC's to satisfy business requests.
• Excellent experience configuring VLDB properties to fine-tune reports.
• Extensively involved in troubleshooting support and resolving all outstanding issues.
• Involved in managing Migration of MicroStrategy projects and objects from Dev to Testing and to prod.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Conducted meetings to gather user/business requirements and also carried out quality reviews with the Users and created documentation for the same.
• Extensively involved in troubleshooting support and resolving all outstanding issues.
• Efficiently handle and Manage production support activities through Incident Management.
• Exceptional ability to quickly master new concepts and capable of working in group as well as independently with excellent communication skills.
• Troubleshoot and tune MicroStrategy reports by analyzing the generated SQL to determine data issues such as double counting, hitting incorrect fact tables, joins and insufficient data.
• Unit tested report layouts, validated the SQL query, prompt ordering & defaults, security filters, export/print functionality and drilling options.
• Experienced in giving the training for non-technical users and providing customer support.

Environment: MicroStrategy 9.4.1/9.2.1 , Desktop, Web MicroStrategy, Intelligence Server, Object Manager, Erwin, Windows, Netezza.

MicroStrategy Developer

Confidential, Syracuse, NY

Responsibilities:

• Involved in gathering business requirements and documenting specifications.
• Creating Views in the database and Logical Views in the MicroStrategy.
• Extensively worked with MicroStrategy Desktop. Extensive experience in building filters, consolidations, transformations and custom groups, attributes, hierarchy, metrics, schema objects and prompts to generated reports meeting the Business Analyst needs.
• Worked on creating MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.
• Developed, implemented and maintained unit tests for applications.
• Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
• Tuning of the MicroStrategy Reports using Data Mart Reports, Aggregate Tables and Intelligent Cubes.
• Strong knowledge in creating Intelligent Cubes which will give the performance when executing the reports and also enabling Dynamic Sourcing for specific cubes.
• Created Executive Dashboard that covers different subject areas for TSV, Inventory and sales analysis on Mobile Platform.
• Involved in creating Panel Stacks, Window Panels and widgets for different Mobile Display.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Expertise on Partition Mapping concept in MicroStrategy which will improve the performance.
• Took part in design and development of Data marts and integrating them with Data warehouse.
• Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions.
• Expertise in developing the dashboards and having good knowledge in using widgets and all components of dashboards.
• Expertise in using the Architect in desktop.
• Proficient in creating the Drill and User Hierarchies.
• Having knowledge in developing the Expression and Table based Transformations.
• Applied Teradata Application Utilities and Teradata SQL. Also Fine tune SQL using Teradata.
• Decode JavaScript used in Hyperion Reports, achieve the logic using workaround like URL API & Web SDK.
• Having good Knowledge in creating Security Filters.
• Expertise in creating Security Roles, MicroStrategy User Groups and Users, assigning security roles to Users and Groups.
• Expertise in Monitoring the Jobs, Caches and Intelligent Cube.
• Having good knowledge in Creating Database Instances.

Environment: MicroStrategy 9.4.1/9.3 (Desktop, Web, Mobile, SDK) Object Manager, SQL Server 2008, MS Management Studio, Microsoft Excel, One Notes, Outlook 2012, MicroStrategy Visual Insight.

MicroStrategy Developer

Confidential, Teaneck, NJ

Responsibilities:

• Performed requirements analysis to collect various business measures and attributes to develop a reliable start schema and required facts and attributes.
• Created attributes, consolidations and derived metrics on the reports from intelligent cubes.
• Developed customized and ad-hoc reports using templates, metrics and filters for business analysis using MicroStrategy agent with features of drilling options drill up, drill down and drill anywhere .
• Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets.
• Created Transformations (table based, formula based) for using in comparative reports like sales this year to last year (year to date and month to date).
• Used pass-through functions (apply simple and apply comp) in attributes and filters definitions.
• Created Dynamic sourcing reports using intelligent cubes to boost the Performance.
• Developed prompts to give end users a choice of different filtering criteria each time they run the report.
• Creating and modifying Schema Objects and Public Objects to enable reporting on new and changed data elements.
• Configured MicroStrategy mobile and modified existing dashboards to work on iPad and iPhones.
• Documented entire work accomplished for future reference and maintenance purposes.
• Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.
• Build and thoroughly test reporting changes and enhancements, understand data validation requirements as appropriate.
• Write and execute queries using SQL to identify data of interest to drive Testing scenarios.
• Work closely with DBA and ETL developers to in corporate additional business data to data warehouse for BI reporting and make changes to the views in the database to correct the reports. Troubleshoot and resolved high-priority and critical defect issues in production and put reports back to production within the deadline.
• Communicates effectively with technical and non-technical audiences, both written and verbally. Able to present and discuss information at the appropriate level of detail and drive towards a consensus of opinion.

Environment: MicroStrategy 9.4.1 Administrator, Desktop, Architect, Web, Intelligence Server, Teradata, ETL, OLAP, Windows Server 2003, MicroStrategy Dashboards.

MicroStrategy Developer

Confidential

Responsibilities:

• Worked with the source systems to have a clear understanding of the data flow and interacted with the users to collect business requirements.
• Created the requirements Documentation for the MicroStrategy projects and also documented the MicroStrategy Environment and DW environment.
• Created semantic layers for understanding the data and generated reports.
• Created Reports using Complex Filters, Compound Metrics and Prompts.
• Used Advanced Prompts, Non Aggregatable Metrics, Conditional Metrics, Transformation Metrics and Level Metrics for creating complex reports.
• Used Customer, Product, Payment, Geographic and Time dimensions and generated complex reports.
• Created several base formulas (mathematical expressions) using existing facts that can be re-used to build any number of metrics, KPI's in reports.
• Tuned reports performance as per the requirement.
• Customized reports, Documents and deployed them to MicroStrategy web.
• Developed customized and Ad-hoc reports using Templates, Metrics and Filters for Business analysis using MicroStrategy Agent with features of Drilling options drill up, drill down and drill anywhere .
• Developed prompts to give end users a choice of different filtering criteria each time they run the report.
• Configured MicroStrategy Mobile and modified existing dashboards to work on iPad and iPhones.
• Performed testing of all reports for the final deployment.
• Imparted user training towards the implementation phase of the project and performed knowledge transfer.
• Documented entire work accomplished for future reference and maintenance purposes.

Environment: MicroStrategy 8.X, Intelligent Server, Narrowcast Server, OLAP Services, MicroStrategy Desktop, Architect, Administrator, Mobile, MicroStrategy Web, SQL Server 2005/2008, Teradata, Oracle 8i, Windows 2008 Server.