SUMMARY:

• Business knowledge of Insurance, Banking, Retail, Payroll Services and Advertisement domains.
• About 9 years of expertise in architect, design and implementing business intelligence solutions using, database modeling, ETL and front - end reporting tools.
• Expertise in using MicroStrategy product suites including MicroStrategy Desktop, MicroStrategy Web, Architect, Object Manager, Command manager, Administration.
• Microstrategy SME for end-to-end project deployment during tenure at prime software technologies.
• Experience in designing data visualizations using Tableau.
• Developing SQLs, stored procedures/functions, packages & database triggers using Teradata & SQL server.
• Worked on design and development using Informatica: - Power Center, Data Transformation.
• Working with Agile sprint teams utilizing Rally / Jira tools for tracking.

TECHNICAL SKILLS:

Reporting: MicroStrategy 9.x, Tableau Desktop. ETL / Database Teradata, SQL Server/Oracle, Informatica Currently learning: Ember JS and Android programming

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Senior BI/Data Analyst and Solution Architect

Responsibilities:

• Architecting, designing and enhancing new BI reports, dashboard and scorecards for pricing/sales team.
• BI Analytics reporting for various team sourcing from multiple source systems of advertisers & publishers.
• Helping to creating new emberjs interface that will replace and end-of-life product mostly used by management and sales team.
• Creating various KPIs, scorecards and dynamic dashboards to showcase trend and prediction analysis.

Environment: MicroStrategy 9.3, SQL server 2008, Ember JS.

Confidential, Sunnyvale, CA.

Microstrategy Professional (Contractor)

Responsibilities:

• Analysing legacy reporting systems and evaluating to create the requirement document that would create the corresponding report in Microstrategy environment.
• Designing and enhancing new reports & Dashboards for Ads and Data Reporting team.
• Supporting other bug tickets as a part of agile software development process.

Environment: MicroStrategy 9.2.1/3, Architect/Development, SQL server 2008.

Confidential

Dashboard Designer

Responsibilities:

• Reviewing and completing the architecture, setting up the security filter for child company groups.
• Creating reports & dynamic dashboards at corp level as well as child companies (specifically for bakers).
• Some Tableau reports as a POC for third party vendors.

Environment: MicroStrategy 9.2.1, Architect, SQL server 2008, Tableau.

Confidential

End to End MicroStrategy deployment

Responsibilities:

• Worked with client to gather requirements and establish the MicroStrategy architecture from scratch.
• Clustering Intelligence server, web IIS servers and the metadata failover architecture.
• Writing command manager scripts to dynamically change groups or create & remove the users (1000+) .
• Developed Intelligent Cubes to provide improved performance of key reports/documents.

Environment: MicroStrategy 9.2.1, Architect, SQL server 2008.

Confidential

MicroStrategy Architect/Designer and Informatica Designer

Responsibilities:

• Worked with various vendor & their feeds to prepare requirements & technical specifications Documents.
• Creating Schema (facts, attributes) and application objects (filters, prompts, metrics, reports, Documents).
• New reports tracking rules/errors and consolidation of financial amounts.
• Informatica services: - Data Quality (error tracking/correction), PowerCenter (transformations/workflow).

Environment: MicroStrategy 9i, Architect, SQL server 2005, Informatica 9.

Confidential, NJ

MicroStrategy Architect

Responsibilities:

• Meetings with Business team to discuss related issues and review of the Objects and reports.
• Creating advanced metrics, filters, consolidations, custom groups and reports with VLDB properties.
• Transformational metrics (Inventory, Sales Target & Growth) to compare monthly/quarterly/annual sales.
• Testing various other reports by executing them in MSI 8 and MSI9.
• Involved in developing and testing of some schema objects and Advanced Metrics for Ad-hoc reports.

Environment: MicroStrategy 8.1.1/9i, Architect, Teradata V2R6, Unix.

Confidential, Mumbai

Sr. MicroStrategy Developer/Consultant

Responsibilities:

• Involved in migration from legacy systems to Teradata-MicroStrategy environment.
• Detailing new process to replicate legacy process without any changes in the output feeds in consideration.
• Constructing 30 jobs & Components that include- 35 fast exports, 35 BTEQ and 15 MLOAD scripts written.
• Developing historical and on demand job runs for data migration.
• Working on architecture and various MicroStrategy objects.

Environment: MicroStrategy 9/8.0, Intelligence Server, Web, Teradata V2R6, Unix, IBM Mainframes.

Confidential

Developer

Responsibilities:

• Developing ad-hoc reports as per the user needs by creating user objects (filters/prompts/level metrics).
• Worked on transformations for YTD (year to date), MTD (month to date), and WTD (week to date) analysis.
• Developing & modifying scripts using BTEQ, MLOAD, EXPORT Utilities on UNIX and Mainframe servers.
• Performance tuning SQL Queries.

Environment: MicroStrategy, Teradata V2R5 and IBM Mainframes.