SUMMARY:

• Over 2+ years of IT experience, leveraging expertise in Data Warehousing, Data Modeling, ETL and BI (MicroStrategy) tools.
• Strong experience with full Software Development Life Cycle(SDLC) which includes Requirement Analysis, Design, Development, Implementation, Testing, Deployment, production Support and Maintenance, Built and Release management.
• Expertise in using MicroStrategy product suite which includes MicroStrategy Intelligence Server, MicroStrategy Desktop/Developer, Narrowcast Server, MicroStrategy Architect, Administrator, MicroStrategy Office, Web, Visual Insight, MicroStrategy Object Manager
• Experience in creating Report Service Documents, pixel perfect Dashboards and Visual Insight analytics templates
• Involved in training Business Users on MicroStrategy OLAP Services (such as view filter and derived metrics, Adhoc reports)
• Used MicroStrategy tools like Object Manager to migrate the objects/projects between MicroStrategy environments
• Used MicroStrategy Command Manager to run the automated scripts.
• Created MicroStrategy User Accounts and User Groups with different Security Roles and assigned various Security Filters.
• Extensively used MicroStrategy Narrowcast Server for delivering reports (Static & Dynamic Subscription Sets)
• In depth technical background working with Databases like Oracle, SQL Server, Sybase, DB2
• Experience in Data modeling techniques like star and snowflake schemas using Erwin tool.
• Experience in Converting Legacy reports into MicroStrategy reports and working in offshore - onsite environment.
• Worked with Logical and physical modeling along with design and implementation.
• Involved in job scheduling, monitoring and production support in a 24/7 environment.
• Experience in coordinating with Database Management team, End users, Business Analysts in understanding their requirements, assisting and providing technical solution and knowledge.
• Excellent analytical and communication skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 10/9.x/8.1.x (Intelligence Server, Administrator, Desktop/Developer, Architect, Web, Distribution Services, Visual Insight,, Narrowcast Server, Mobile, Integrity Manager, OLAP), Cognos 10 (Report Studio, Workspace Advanced)

ETL Tools: Informatica Power Center 9.x/8.x, SQL Server SSIS services.

Databases: Oracle 11g/10g/9i, Teradata 13.x/V2R6, MS SQL Server, Sybase, Netezza

Programming: T SQL, PL/SQL, SQL Loader, SQL Plus, TSQL, C, C++, HTML

Operating Systems: Windows Servers, UNIX (Solaris, Linux)

Other Tools: Toad, SQL Assistant, PL/SQL Developer, MS Office, Microsoft Visio, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, DE

MICROSTRATEGY CONSULTANT

RESPONSIBILITIES:

• Involved in implementing the Full Life Cycle of the project starting with gathering requirements from the business users and documenting the specifications to delivering the end reporting solutions
• Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary
• Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters and metrics using MicroStrategy Desktop
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations
• Developed Dynamic Dashboards both in interactive & flash mode using various Widgets and Selectors, documents for summary level reporting with large datasets
• Hands on experience on SDK and D3 Visualization
• Used the Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy
• Used MicroStrategy Command Manager to create scripts for creating users, groups, setting user options and authentication modes, clearing caches, dropping connections, generating user lists etc
• Invoved in drill down reports and Interactive Dashboards.
• Experience on UI and UX skills
• Used MicroStrategy Distribution Manager, Narrowcast Server for automation of reports
• Worked with Database teams to create the database tables, materialized views required for reporting
• Involved in UAT Testing to validate the data using SQL queries against the data warehouse.
• Widely used VLDB properties at project level and also at individual report levels to overcome performance issues
• Used database specific MicroStrategy OLAP pass through functions like ApplySimple, Apply Comparison to overcome complex logic in creating objects
• Involved in production support (24/7)
• Hands on Experience on JAVA script.
• Maintained a stable platform by proactively identifying and resolving any issues or bugs.
• Experience on visualization with cutting Edge java script and frame works including D3.
• Works on React and redux commanding grasp of HTML,CSS.

ENVIRONMENT:: MicroStrategy 10/9.4.1 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Oracle 11g, Sybase.

Confidential, OWINGS MILLS, MD

MICROSTRATEGY CONSULTANT

RESPONSIBILITIES:

• Worked with end users to gather requirements and prepared technical specification Documents.
• Understanding the reporting requirements and developed the reports and redesigned the legacy reports in MicroStrategy
• Involved in Dimensional Data Modeling, Data Architecture, Business and Data Analysis
• Developed MicroStrategy Schema objects and Application objects like Metrics, Filters, Prompts, Consolidations, Custom Groups and Project objects like Subtotals
• Designed Reports, Documents and Dashboards using Desktop
• Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Designed Reports, Documents and Dashboards using Desktop
• Hands on experience Microstrategy transaction services.
• Experience in DEVE
• Experience on UI and UX skills
• Created ad-hoc reports by drilling up, down, within and across Hierarchies.
• Created Transformations to calculate YTD (Year to date), MTD (Month to date) metrics
• Implemented Report Data Options, Formatting, Dynamic Dates, Advanced Sorting, Prompt Ordering, Totals, Outline Mode based upon the business user change request during UAT Testing.
• Validated end user report requests using SQL queries and MicroStrategy tools.
• Hands on Experience on JAVA script.
• Knowledge on visualization best practices
• Solid UI and UX skills, with experience building web and/or mobile interfaces for displaying interactive visual insights
• Experience with cutting-edge JavaScript libraries and frameworks including d3, React, and redux
• Commanding grasp of HTML, CSS.
• Using Object Manager to move the reports from Development Project to QA/Production Project.
• Works on React and redux commanding grasp of HTML,CSS.
• Involved in optimization of code and tuning queries for performance.
• Production Support has been provided for ongoing issues.

ENVIRONMENT:: MicroStrategy 9.4.1/9.3 (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), UNIX, Windows Server, SQL server.