SUMMARY:

• Over 5+ years of IT experience in Business Intelligence(BI) Project Development and Implementation
• Using MicroStrategy 9/8.x Product Suites including Microstrategy Desktop, Web, and Architect.
• Experience working with the full life cycle development process, which includes analysis, design, development and testing.
• Extensive use of Rally as SDLC Agile management tool.
• Extensively worked on designing schema and creating Facts, Attributes, Hierarchies and Transformations
• Excellent experience in Microstrategy Report development, Report testing, Report tuning, Ad - hoc and scheduling report delivery.
• Extensive experience on all types of Microstrategy Filters, Prompts, Templates, Metrics, Consolidation and Custom Groups.
• Worked extensively on VLDB Properties for performance tuning.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XSL, HTML, and DHTML.
• Extensive experience in creating Transaction service documents.
• Proficient in various Relational Databases like Oracle, DB2, SQL Server, Toad.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling and Dimensional Modeling.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Strong Data modeling (Logical and Physical) experience with high proficiency in using ERwin for Dimensional Modeling (Star, Snowflake schemas) and Entity-Relationship Modeling.
• Extensive experience in writing complex SQL Queries.
• Extensive experience in Microsoft Office tools like Excel, Word and Visio
• Exceptional analytical and problem solving skills, communication skills, strong decision making skills and organization skills.
• Excellent Team player with good communication skills and coordination in team meetings.

TECHNICAL SKILLS:

Reporting Tools: Microstrategy 9.4.1/9.2.1/9.02/8. x.

ETL Tools: Informatica Power center 9.1/8.1.

Databases: DB2 9/8, Sybase, Oracle 11g/10g/9i/8i, Toad, Exadata, SQL Server 2005/2008 and MS- Access.

Bug Reporting: HP Quality Center11.00.

Programming Skills: SQL, PL/SQL.

Scripting Languages: Unix Shell Scripting.

GUI: Toad 7.4, Squirrel, Oracle designer.

Operating Systems: UNIX Aix 5.3, Win 95/NT/98/2000/XP/7.

Utilities: Excel 2003/3007, SQL* PLUS, Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Microstrategy Tech Lead

Responsibilities:

• Work as part of an agile team and participate in backlog grooming and sprint planning sessions.
• Extensive use of Rally as SDLC Agile management tool.
• Create technical user stories based on the business requirements and acceptance criteria.
• Develop technical design based on business requirement documents which include module definition and mapping documents.
• Played an important role in coordination with the entire team and managing the time estimates for the project.
• Mentor the team by providing technical solutions.
• Develop data mapping documents of reports to gain better idea of business requirements.
• Responsible for setting up the Microstrategy project and database instance configurations.
• Create transaction services documents to enable write back functionality to the tables.
• Create business process approval using transaction services to push data to upstream applications.
• Write stored procedures for the write back functionality of reports from Microstrategy.
• Create Schema objects, Public objects, and Configuration objects.
• Build objects like Attributes, facts, hierarchies, Drill maps, Reports, filters, metrics, prompts, consolidations, custom groups and Documents based on schema objects.
• Develop dashboards that use selectors and panel stacks.
• Develop reports and trained users on how to use them with Visual Insight.
• Design and develop complex filters for various complex reports with advanced qualifications involving pass-through functions.
• Create Ad Hoc reports using object prompts.
• Train users on the various analytical features in Microstrategy.
• Create Freeform SQL reports.
• Create trending reports with Month over Month and Quarter over Quarter data.
• Used several Microstrategy features to fine tune the reports. Worked with Very Large Database (VLDB) Properties at different levels like report and metric to tune the report to get desired results.
• Created reports using Intelligent Cubes.
• Extensively involved in troubleshooting the Microstrategy Objects like Reports, filters, metrics, consolidations, custom groups, prompts and templates.
• Responsible for object migration across environments.
• Responsible for creation of user groups and users.
• Estimate and coordinate the testing efforts for version/server upgrade.
• Impact analysis and assessment for all the downstream reporting applications.
• Provided continuous support for the project team.
• Involved extensively in troubleshooting and resolving all outstanding issues.

Environment: Microstrategy 9.4.1, Oracle 10g, Oracle Exadata, Windows 7

Confidential

Microstrategy Tech Lead

Responsibilities:

• Work as part of an agile team and participate in backlog grooming and sprint planning sessions.
• Extensive use of Rally as SDLC Agile management tool.
• Create technical user stories based on the business requirements and acceptance criteria.
• Worked on agile collaboration room to brain storm logics, resolve issues and too follow the quality and deadline of delivery.
• Develop technical design based on business requirement documents which include module definition and mapping documents.
• Create Schema objects, Public objects, and Configuration objects.
• Build objects like Attributes, facts, hierarchies, Drill maps, Reports, filters, metrics, prompts, consolidations, custom groups and Documents based on schema objects.
• Develop dashboards that use selectors and panel stacks.
• Develop reports and trained users on how to use them with Visual Insight.
• Create Freeform SQL reports.
• Create trending reports with Month over Month and Quarter over Quarter data.
• Extensively involved in troubleshooting the Microstrategy Objects like Reports, filters, metrics, consolidations, custom groups, prompts and templates.
• Used several Microstrategy features to fine tune the reports. Worked with Very Large Database (VLDB) Properties at different levels like report and metric to tune the report to get desired results.
• Responsible for object migration across environments.
• Responsible for creation of user groups and users.
• Estimate and coordinate the testing efforts for version/server upgrade.
• Impact analysis and assessment for all the downstream reporting applications.
• Used SQL tools like TOAD and SQL Developer.

Environment: Microstrategy 9.4.1, Oracle 10g, ODA, Oracle Exadata, Windows 7

Confidential, Glendale, CA

Microstrategy Developer

Responsibilities:

• Involved in Requirements gathering by interacting with the Business Users.
• Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards)
• Very good in using the Analytical engine bypass functions like Apply Simple & Apply Comparison whenever necessary
• Implemented drill functionality on the reports using Drill Maps
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Created Transformations for comparative reports like sales this year-to-date, Month- to-date, Quarter-to-date etc
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Tested and validated Microstrategy objects across Database with Report data.
• Involved in using the Object Manager to move the objects across different environments in MicroStrategy.
• Environment: Microstrategy 9.x, DB2 9, Informatica 9.1, HP Quality Center11.00, Unix AIX 5.3, Erwin 7.3

Confidential

Microstrategy Developer

Responsibilities:

• Performed Requirement Analysis to collect various business measures and attributes to develop a reliable Star Schema and required Facts and Attributes.
• 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.
• Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation Metrics, Conditional Metrics, Relationship filter, pass through functions
• Created different Transformations to get the last year actual transactions, week to day, week to period, week to quarter, week to year and effectively used them with the metrics.
• Created Dashboards, static and dynamic and scoreboard reports for effective web based report solutions.
• Worked with Narrowcast server for sending reports via email to a large executive distribution group.
• Developed the free form SQL reports and standard reports
• Tested and validated Microstrategy objects across Database with Report data.

Environment: Microstrategy 9.x, DB2 9, Oracle 10g, Informatica 9.1, HP Quality Center11.00, Unix AIX 5.3Erwin 7.3 3/28/18 AXP Internal