SUMMARY

• 10 years of experience in design, development, testing Microstrategy and Java web application and MicroStrategy based business intelligence reporting systems for Banking, Financial Services, Healthcare providers and Payment Processing.
• Proficient in 10.X/9.X/8.X Product Suite (including OLAP Services, Administration, Web Universal, Dynamic Dashboards/Report Services).
• Experience in MicroStrategy Developer role functions such as developing Reports, Documents, Dashboards & other underlying Application objects (Filters, Prompts, Metrics, Custom Groups, Consolidations, Searches & Templates).
• Experience in developing Dashboards using multiple Layouts, Panel Stacks, wide variety of Selectors such as slider, button bar, drop - down, link-bar for tabbing, panel selector, selector-to-selector targeting,, Grid/Graphs panels and Widgets.
• Experience in setting up drill paths using Custom Drill Maps, Hierarchies path setup and managing Project Drill Map.
• Experience in MicroStrategy Administrator functions such as designing Security Roles, Security Filters, User Groups, setting up Custom Authentication for MicroStrategy Web.
• Experience in using advanced techniques such as URL API, AutoText, HTML Container along with Javascript coding, hidden selectors, etc.
• Experience in MicroStrategy Web Customization using Web Customization Editor for making layout changes and creating plug-in for Prompt Answers, External Security Module, Toolbar customization, Portal customization.
• Experience in determining system level parameters such as Governing Settings, User Session management, Job Management, MCM parameters, Cache management, Job Prioritization settings, Performance Tuning using VLDB settings
• Experience in using data warehouses hosted in DB2, Oracle 10g, Netezza, Teradata, SQL Server
• Managed and lead a team of DW&BI developers
• Mostly worked in Onsite and Offshore Model.
• Experience in handling BI projects involving high data volume & complexity.
• Expertise in Banking, Health Care and Telecom domain.
• Self-Motivated, innovative problem solver with a strong customer focus

TECHNICAL SKILLS

BI Tools: MicroStrategy 10.X/9.X/8.X (Admin, Architect, Developer tools and SDK), Webfocus

MicroStrategy Skills: Dashboards, VisualInsight, Reports, Filters, Metrics, Prompts, Hierarchies, Transformations, Facts, Attributes, Drill Maps, Autostyle, Report Templates, Document Templates, Narrowcast Services and Subscriptions, Command Manager scripting, User Groups, Security Filters, Integrity Manager, Object Manager

MicroStrategy SDK: Web SDK

Programming Languages: Java, JavaScript, SQL, HTML, CSS

Web Technologies: JSP, Servlet, Struts

IDEs: Eclipse

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Sr. MicroStrategy Developer

Responsibilities:

• Develop Schema work for different Reporting projects.
• Worked on Card, Settlement and Auth & Capture Projects and created traditional grid reports, freeform SQL reports.
• Created views, stored procedures and on top of that created freeform SQL reports.
• Worked on Gift Card Liability Dashboards
• Interact with ETL team and Architect teams to build schema based on requirements signed off by user.
• Create schema objects in MicroStrategy Developer tool for reports and dashboards in MicroStrategy Web.
• Coordinate, mentor and provide architectural guidance to other MicroStrategy Developers
• Provided production support for Polaris project.
• Involved in creating and maintaining user groups in MicroStrategy for different kinds of users.
• Migrating projects and objects between production and lower environments using Object Manager
• Involved in Performance tuning of the SQL queries.

Environment: MicroStrategy 10.1, Report Services document, Dashboards, Reports, Templates, Web SDK customization, Netezza, Eclipse, Rally, Confluence

Confidential, Plano, TX

Sr. MicroStrategy Developer

Responsibilities:

• Develop Facts, Attributes, Hierarchies, Dashboards, Reports, Metrics, Compound Metrics, Filter, Prompts, Consolidations and Custom Groups, Templates for Performance Management Reporting project
• Develop Metrics, Compound Metrics, Filters, Templates, Consolidations, Auto Prompt Filters and OLAP Reports
• Develop/enhance Report Service Documents such as Spend Overview, Tier Optimization, Market Share, Market Fragmentation, New Items.
• Develop/update Transaction Details template set for template drilling
• Interact with ETL team and Architect teams to build schema based on requirements signed off by user.
• Create schema objects in MicroStrategy Developer tool for reports and dashboards in MicroStrategy Web.
• Coordinate, mentor and provide architectural guidance to other MicroStrategy Developers
• Design, develop and maintain User Administration program and the Performance Analytics Web application
• Provide production support for spend Sourcing Analytics.
• Involved in creating and maintaining user groups in MicroStrategy for different kinds of users.
• Migrating projects and objects between production and lower environments using Object Manager

Environment: MicroStrategy 9.4.1, Report Services document, Dashboards, Reports, Templates, Web SDK, Prompt page customization, Teradata 13.10, Eclipse, Microsoft TFS for Agile Development

Confidential, Waltham, MA

Sr. MicroStrategy Developer

Responsibilities:

• Upgrade the environment to the latest hotfix. I was invovled in upgrading the whole platform (MicroStrategy Desktop, MicroStrategy Web, MicroStrategy IntelligenceServer) to MicroStrategy 9.0 Hotfix 4 and MicroStrategy 9.3
• Handling customization request such as changing MicroStrategy Web messages during data load and handling custom authentication requirements using MicroStrategy Web API
• Using Enterprise Manager project to report system statistics such as Usage Report, Long running reports, Highly used project / report, etc
• Coordinating with the project team to Tune the reports for best performance and minimum load to the system
• Coordinated with MicroStrategy Premium Support group to resolve server stability issues
• Migrating projects and objects between production and lower environments using Object Manager
• Reverse migration of objects from production environment to non production environments for user created objects using Object Manager and Project Merge Wizard
• Keeping the environment in compliance with the license using MicroStrategy License Manager

Environment: MicroStrategy 9.3, Oracle 10g, Tomcat, Linux, Rally for Agile

Confidential, Phoenix, AZ

Sr. MicroStrategy Developer

Responsibilities:

• Responsibility for creating the new reports, metrics with the other public and schema objects
• Use Warehouse Catalog to bring in new Lookup and Fact tables
• Develop new Attributes, Facts and Hierarchies
• Update table mappings, relationships for existing Attributes and Fact mappings
• Setup test accounts with various roles and access levels to be used in Integrity Manager
• Develop Dashboards, Reports, Metrics, Filters, Prompts and other supporting application objects
• Code development & Unit Testing. Responsibility for creating the new reports, metrics with the other public and schema objects
• Creation of interactive dashboards on the reports
• Involved in Microstrategy Administration
• PMR Production activates - Change requests, impact analysis and issue fixes.
• Involved in creating user stories

Environment: MicroStrategy 9.0.2, MicroStrategy Architect, Dashboards, Reports, Metrics, Filters, Prompts, Attributes, Facts, Object Manager, Integrity Manager, Narrowcast. DB2

Confidential, Phoenix, AZ

MicroStrategy Developer

Responsibilities:

• Gather merchant reporting requirements and Architect new Lookup and Fact tables to bring in new Attributes and Facts into the project
• Use Warehouse Catalog to bring in new Lookup and Fact tables
• Develop new Attributes, Facts and Hierarchies
• Update table mappings, relationships for existing Attributes and Fact mappings
• Setup test accounts with various roles and access levels to be used in Integrity Manager
• Use Integrity Manager for any regression testing by SQL and Data comparison of existing reports after schema/table/relationship mappings changes
• Develop Dashboards, Reports, Metrics, Filters, Prompts and other supporting application objects
• Design new Security Roles and User Groups
• Work with Portal team for integration and develop new Addons using MicroStrategy SDK for landing page Dashboard display requirements and Dashboard export requirements

Environment: MicroStrategy 9.0.2, MicroStrategy Architect, Dashboards, Reports, Metrics, Filters, Prompts, Attributes, Facts, Object Manager.

Confidential, Phoenix, AZ

MicroStrategy Developer

Responsibilities:

• Responsibility for creating the new reports, metrics with the other public and schema objects
• Code development & Unit Testing. Responsibility for creating the new reports, metrics with the other public and schema objects
• Creation of interactive dashboards on the reports
• Involved in Microstrategy Administration
• Involved in creating user stories
• Deploying the changes using the object manager
• Sharing Support Responsibility for Estimation, IT, UAT & Deployment

Environment: MicroStrategy 9/8.1, Desktop, Architect, IntelligenceServer, MicroStrategy Web, Command Manager, Object Manager, Configuration Wizard, Project Mover, Scan MD, MD Doctor, MicroStrategy SDK for customization)

Confidential, Phoenix, AZ

MicroStrategy Developer

Responsibilities:

• Responsibility for creating the new reports, metrics with the other public and schema objects
• Code development & Unit Testing. Responsibility for creating the new reports, metrics with the other public and schema objects
• Creation of interactive dashboards on the reports
• Involved in Microstrategy Administration

Environment: MicroStrategy 9.0, Report Services document, Dashboards, Reports, Templates.

Confidential, Detroit, MI

MicroStrategy Developer

Responsibilities:

• Understanding the user requirements and develop the reports and its corresponding Narrowcast services.
• Involved in Microstrategy schema object, public objects creation and Narrowcast service creation
• Creating the users, Monitoring jobs, deploying the changes using Object manager.
• Upgrade the Microstrategy 8.0.1 to Microstrategy 8.0.3
• Responsibility for creating the new reports, metrics with the other public and schema objects
• Creation of interactive dashboards on the reports.
• Code development & Unit Testing.
• Responsibility in Executing System Test Cases
• Sharing Support Responsibility for Estimation, IT, UAT & Deployment

Environment: MicroStrategy 8.0.1, Report Services document, Dashboards, Reports, Oracle

Confidential

MicroStrategy Developer

Responsibilities:

• Involved in creating Datamarts.
• Understanding the user requirements and develop the reports and its corresponding Narrowcast services.
• Involved in Microstrategy schema object, public objects creation and Narrowcast service creation
• Responsibility for creating the new reports, metrics with the other public and schema objects
• Creation of interactive dashboards on the reports.
• Code development & Unit Testing.
• Responsibility in Executing System Test Cases
• Sharing Support Responsibility for Estimation, IT, UAT & Deployment

Confidential

Java Developer

Responsibilities:

• Understanding business requirements drafted by the requirement analysts and translating such requirements to technical system specifications.
• Performing a system study of the existing Utility application, holding key meetings with various points of contacts for the new application, to understand the existing functionalities.
• Developed web tier by using Struts Framework, JSPs.
• Adopted J2EE Best Practices, using J2EE Design Patterns. Utilized Front Controller, Business Objects, Transfer Objects, and Data Access Objects.
• Involved in writing the test cases.
• Used JUnit to write repeatable tests mainly for unit testing

Environment: Java, JSP, Servlet, Struts, HTML, JavaScript, CSS, NetBeans, Apache Tomcat, Apache Ant