SUMMARY:

• 12+ years of experience in IT industry specializing in design and application development of Business Intelligence solutions including:
• OLAP tools MicroStrategy,
• QlikView,
• SAP Business Objects,
• Crystal Reports,
• ETL tool Informatica,
• Data base Oracle, Postgre SQL, SQL Server.11 years of experience in MicroStrategy tool Suite:
• MicroStrategy Intelligence Server,
• MicroStrategy Administrator,
• MicroStrategy Architect,
• MicroStrategy Desktop,
• MicroStrategy Mobile
• MicroStrategy Web,
• MicroStrategy Narrowcast Server
• Expertise in application and reporting development, including supporting processes and activities; project management, solution architecture and design, software development, testing,, and all associated documentation.
• Experience in complex data model like Slowly Changing Dimension, Ragged Hierarchy, Cycle Hierarchy etc and worked with Multi Dimensional Data.
• Preparing the Technical Specification documents, Developing, Testing and Production Support.
• Experience in user facing roles (Gathering Requirement, establishing project objective, leading meetings).
• Experienced in managing engagements with onsite and offshore model.
• Vertical expertise including Investment Banking, Beverage products, Retail, Healthcare, Insurance, IT Product and Telecommunication.
• Expert in Desiging and Building Storyboard for MicroStrategy iPad App solutions.
• Headed MicroStrategy - Mobile Technology for iPad projects for clients.
• Experience with Intelleigence Cube, Visual Insight and other advance feaute OLAP techniques
• Expert in creating Report Service Documents and DASHBOARDS.
• Developed and managed 13 medium to high size BI projects simultaneously with team size of 4-6 people.
• Strong SQL Skills related to information retrieval and analysis.
• Expert in Creating MicroStrategy Freeform SQL reports implementing MicroStrategy projects.
• Good understanding different database management systems including Oracle11i TOAD 8.6.1 SQLServer, DB2, Netezza with respect to Enterprise Data Warehouses.
• Develope Star and Snow-flake dimensional models for complex systems Investment Banking, Sales an Product Measurements Systems.
• Ability to translate business requirements into Business Intelligence solutions employing the best dimensional modeling techniques, advising clients best practices in the BI space.
• Experience in modeling dimensional models for advanced reporting and adhoc business needs.
• Metrics Facts Prompts Templates Consolidation and Custom Groups) with the data warehouse.
• Worked in co-ordination with data modelers, ETL development team and end users.

TECHNICAL SKILLS:

Strategic: Data Warehouse, Business Intelligence, Business Analysis, Project Mgmt and

Technical: Analytics, Architecture, Configuration Management, Data Analysis, Data Modeling, Programming and Requirements

OLAP/Reporting/ETL: MicroStrategy, QlikView, Crystal Report and Business Object Infoview, Informatica

Data Base/Tools: Oracle, Postgre SQL, MS-Access, Toad, MS-Visio

Operating System: Windows 7/XP/NT, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Senior MicroStrategy Consultant

Responsibilities:

• Designed Storyboard for MicroStrategy Mobile for iPad.
• Involve with the user’s representative to finalize storyboard.
• Table design, attributes, fact, hierarchy, transformation creation for APEX project.
• Creation of metrics, filters, prompts, consolidation and reports for APEX project.
• Development of Landing page, Region page, Disease State page, and Combination of both pages.
• Creation of Heat Map, Map Widget, Time Series Slider, and Microcharts Widget for APEX project.
• Fixed bugs found in QA and Deployment of APEX in Production.
• Lead role in delivering MicroStrategy Reporting platform working closely with Oracle Application developer and DataStage ETL team.
• Create customized sales and marketing MicroStrategy reports and dashboards capturing performance and Inventory of worldwide.
• Deliver user friendly reports allowing line of business users to have more control of their production & sales units and forecasting.
• Performed as MicroStrategy Architect to understand the requirements for business users directly.
• Identified existing BI User problems and designed, architected, and developed new requirements.
• Performed functional analysis and created Functional and Technical Specification Document.
• Designed Schema Objects including Attributes, Facts, Hierarchies and Transformations from data warehouse.
• Created customized MicroStrategy reports and dashboards development.
• Created Critical Reports in World Wide Inventory project of MicroStrategy.
• Maintenance and development of more than three projects on MicroStrategy.
• Modified VLDB properties to optimize performance of reports and force variation in default behavior of SQL engine.
• Troubleshooting Micro Strategy report data issues and performance issues.

Confidential, NY

Senior MicroStrategy Consultant

Environment: MicroStrategy 9.3.1, Informatica, Oracle, Control-M, Toad, MS-Visio, UNIX, Window XP.

Responsibilities:

• Worked as a MicroStrategy Architect to understand the requirements for business users from business analyst.
• Performed functional analysis and created Functional Specification Document.
• Designed Schema objects like Attributes, Facts, Hierarchies and Transformations from data warehouse.
• Reports and dashboards development.
• Involved in creation of logical views and Freeform SQL Reports in MicroStrategy.
• Modified VLDB properties to optimize performance of reports and force variation in default behavior of SQL engine.
• Troubleshooting Micro Strategy report data issues and performance issues.
• Participated in ETL mapping, database and system design.
• Working as Owner of Control-M Enterprise for developing and supporting automation of Informatica jobs.
• Deployment of MicroStrategy Objects, Oracle database, Informatica jobs to UAT. And creation of GCM to support Production deployment.

Confidential, Atlanta, GA

Team Lead - MicroStrategy Architect/Administrator

Environment: MicroStrategy 9.2.1, SQL Server, Window XP.

Responsibilities:

• Designed the apps for iPad, Created landing page and five pages on WUSCY project and nine pages for OC Scorecard project.
• Worked with Business Analyst/Users to understand the Business Processes and Project Design. Designed Architect Data Model using MSTR Architect.
• Created drill down and Information Window to show details of products, region, and time dimensions.
• Created different widgets like Heat Map, Microcharts, Time Series Slider, and Interactive Grid etc. for iPad.
• Designed and created dashboard with different Panel Stack, Panel, Selector (Panel/Metric/Attribute), and various Dataset.
• Configured LDAP authentication for Project.
• Deployment of DEV, UAT and PROD environment including MicroStrategy Installation & Upgrade.
• Modified VLDB properties to optimize performance of reports.
• Attended meetings with business users and project team, including daily call with manager and team members about project status and test finding on iPad.

Confidential, Dallas, TX

Senior MicroStrategy Architect

Environment: MicroStrategy 9.0.1, Oracle, Toad, Window XP.

Responsibilities:

• Requirement gathering from business users for Schema design and project design.
• Design architect data model using MSTR architect. Creating attribute, facts, hierarchy, transformation. Design various object such as filter, prompt, metrics and template.
• Design and create of dashboard with different panel stack, panel, selector (panel/metric/attribute), and various dataset.
• Created dashboard design using flash on different widget.
• Worked with ETL team for performance improvement suggestion and implementation.
• Attended the meeting business user and project team.

Confidential, Phoenix, AZ

Senior MicroStrategy Consultant

Environment: MicroStrategy 8.5, QlikView 8, Oracle, Toad, Window XP.

Responsibilities:

• Understood business processes, new reporting requirements, designed and created new reports.
• Created logical data model, recognized source tables and columns, to build Attributes, Facts, Transformations, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created MTD (Month to Date) and YTD (Year to Date) reports as per the user requirement.
• Created reports, Ad-hoc reports, and documents in MicroStrategy.
• Worked with database team to tune performance of existing reports.
• Planned and created dashboards in QlikView BI tool.

Confidential, Scottsdale, AZ

Senior BI Lead

Environment: MicroStrategy 8.5, Crystal Report, PostgreSQL, Window XP/2000 Server.

Responsibilities:

• Worked with business requirements analyst’s subject matter experts to identify and understand requirements and produce the report design specification and estimates the project.
• Created the Detail design documents and Technical Specification Documents based on Business requirement documents.
• As per business requirement, Designed developed and maintained MicroStrategy based reports.
• Design and development of MicroStrategy Schema objects like Attributes, Facts and Hierarchies using MicroStrategy Architect.
• Created complex metrics with different level dimensionality condition and transformations for user and business specific reporting needs.
• Extensively used filters, prompts, custom groups, consolidations and transformations to generate reports for business analysis.
• Involved in Performance tuning of SQL for long running reports. Converted all the existing MSTR reports to Crystal Reports.