EXPERIENCE SUMMARY:

• Overall 8 years of experience in IT with 5 years’ experience in MicroStrategy as a developer.
• Extensive experience on MicroStrategy BI suite. Expertise in building projects and creating reports using MicroStrategy 9 product suites including MicroStrategy Narrowcast Server, Tomcat Server, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server and MicroStrategy Architect
• Extensively worked in creating Microstrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and CustomGroups) with the data warehouse
• Involved in creating Report Services Documents, Dashboards with large number of data sets
• Optimized the SQL performance of the reports using the VLDB properties in Microstrategy Confidential different levels like report, metric, project and Database Instance.
• Expertise in Defining Microstrategy Narrow cast Server objects like Service, Schedule, Subscription set and Information Objects.
• Expertise in creating custom Dash Boards and Scorecards using Flash and DHTML
• Strong knowledge and understanding of SQL and ability to write SQL queries
• Excellent analytical, inter - personal and communication skills with clear understanding of business process flow.
• Ensure the team follows the change control process when there is any request to change the agreed scope.
• Perform scope verification by obtaining stakeholder's formal acceptance\sign-off on completed deliverables.
• Exceptional ability to quickly master new concepts and capable of working in group as well as independently with excellent communication skills.
• Experience working in a structured, multi-person development environment
• Experience in Black box Testing.
• Experience in deriving of test cases based on business requirements
• Experience in Functional Testing, Regression Testing and System Testing

TECHNICAL SKILLS:

Business intelligence: Microstrategy 9.x(Microstrategy desktop/Web)

Databases: Oracle and SQL Server.

OS: UNIX, Microsoft Windows

Other Tools: TOAD, SQL Developer, SOAP

Testing: Manual Testing

PROFESSIONAL EXPERIENCE:

Confidential, Dublin, OH

Sr Microstrategy Developer

Responsibilities:

• Involved in gathering of business requirements from end clients and translating them into report specifications for the Microstrategy platforms.
• Conducted meetings to gather user/business requirements and also carried out quality reviews with the Users and created documentation for the same.
• Identify and modified source tables and columns in the warehouse required to create the MicroStrategy project. Studied and modified the attributes, facts and hierarchies based on the requirement. Used MicroStrategy Desktop for creating various application objects.
• Developed and Analyzed Application Objects (Metrics, Reports, Filters, Documents, Prompts) using the Microstrategy Desktop and Microstrategy Web interfaces.
• Created advanced reports which include Advanced Prompts (Filter Definition Prompts, Hierarchy Prompts, Level Prompt, Object Prompt, Value Prompt) and Advanced Filters (Attribute Qualification, Set Qualification and Advanced Qualification Filters).
• Created complex filters with advanced qualification involving pass through functions like ‘ApplySimple’ and ‘ApplyComparison’ functions.Used Transformations for comparative reports like claims this year to last year (year to date and month to date).
• Proactively created report formats and delivered personalized messages from the BI platform through MicroStrategy Narrowcast Server to a wide range of users.
• Designed Templates and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Created MicroStrategy Reports and Dashboards
• Responsible for managing change requests in Maintenance releases and released to Production by adhering to timelines.
• Created several base formulas (mathematical expressions) using existing facts in Microstrategy Desktop that can be re-used to build any number of metrics
• Coordinated with business, data modeling and ETL team Confidential various levels for stabilization of reports.

Confidential, Hoffman Estates, IL

Microstrategy Developer

Responsibilities:

• Involved in gathering of business requirements from end clients and translating them into report specifications for the Microstrategy platforms.
• Extensive Microstrategy development hands on experience with Desktop, Architect, Intelligence Server, Report Services, Enterprise Reporting, OLAP provider, Data Mart and Web components
• Experience working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models
• Developed and Analyzed Application Objects (Metrics, Reports, Filters, Documents, Prompts) using the Microstrategy Desktop and Microstrategy Web interfaces.
• Created advanced reports which include Advanced Prompts (Filter Definition Prompts, Hierarchy Prompts, Level Prompt, Object Prompt, Value Prompt) and Advanced Filters (Attribute Qualification, Set Qualification and Advanced Qualification Filters).
• Created complex filters with advanced qualification involving pass through functions like ‘ApplySimple’ and ‘ApplyComparison’ functions.
• Created MicroStrategy Reports and Dashboards
• Implements Drill functionality on the reports using Drill Maps
• Designed report templates to generate reports in Grid and Graph mode.
• Responsible for managing change requests in Maintenance releases and released to Production by adhering to timelines.

Confidential, San Ramon, CA

Microstrategy Developer

Responsibilities:

• Involved in gathering of business requirements from end clients and translating them into report specifications for the Microstrategy platforms.
• Developed and Analyzed Application Objects (Metrics, Reports, Filters, Documents, Prompts) using the Microstrategy Desktop and Microstrategy Web interfaces.
• Created advanced reports which include Advanced Prompts (Filter Definition Prompts, Hierarchy Prompts, Level Prompt, Object Prompt, Value Prompt) and Advanced Filters (Attribute Qualification, Set Qualification and Advanced Qualification Filters).
• Created complex filters with advanced qualification involving pass through functions like ‘ApplySimple’ and ‘ApplyComparison’ functions.
• Created MicroStrategy Reports and Dashboards
• Responsible for managing change requests in Maintenance releases and released to Production by adhering to timelines
• Developed Reports enabling Data Drilling across multiple Dimensions using Desktop and Web. Graphs and Alerts were used to support the Reporting process.
• Actively participated in developing the work flow for creation of report and report services by using the logical model built in consideration with the business requirement.
• Provided level of effort estimates for new project work, enhancements and fixes
• Allocation of work assignments to the offshore team and getting status on daily basis
• Created reports with various object prompts to generate various Ad hoc reports.

Confidential, East Hanover, NJ

Microstrategy Developer

Responsibilities:

• Involved in gathering of business requirements from end clients and translating them into report specifications for the Microstrategy platforms.
• Developed and Analyzed Application Objects (Metrics, Reports, Filters, Documents, Prompts) using the Microstrategy Desktop and Microstrategy Web interfaces.
• Created advanced reports which include Advanced Prompts (Filter Definition Prompts, Hierarchy Prompts, Level Prompt, Object Prompt, Value Prompt) and Advanced Filters (Attribute Qualification, Set Qualification and Advanced Qualification Filters).
• Created complex filters with advanced qualification involving pass through functions like ‘ApplySimple’ and ‘ApplyComparison’ functions.
• Used pass-through functions (applysimple and applycomp) in attributes and filters definitions.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Extensively used OLAP cubes functionality in Query performance.
• Created MicroStrategy Reports Dashboards
• Worked as on-site coordinatior
• Allocation of work assignments to the offshore team and getting status on daily basis and reporting management

Confidential

Technical Associate

Responsibilities:

• Creating Test Cases as per the SFD, Business Requirements and Test Plan
• Execution of Test Cases
• Involved in Peer review
• Defect Tracking
• ERF Testing
• Preparing the Status Report on daily basis
• Involved in System Testing
• On call Support
• Maintaining the servers