PROFESSIONAL SUMMARY:

• Microstrategy Certified Architect (MCA) with 7+ years of IT Experience and well acquainted as MicroStrategy Developer, Architect using MicroStrategy tool Suite 10.4/10.3/9.2.1 with Strong Domain Knowledge of Communication in Financial, Retail Services.
• Comprehensive working Knowledge with MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Mobile Development, MicroStrategy Administration, MicroStrategy Narrowcast Server, Transaction Services and OLAP Services Environment.
• Working familiarity with full Software Development Life Cycle (SDLC) of Data Warehousing and Business Intelligence projects using various development methodologies like Agile/ Scrum and Waterfall.
• Experience in Data Warehousing and Business Intelligence area in various domains.
• Hands on experience in implementing dashboards, data visualizations and analytics using Tableau Desktop and Server.
• Dedicated team player with strong analytical, presentation, training and project management skills along with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Business Intelligence Reporting Tools: MicroStrategy Intelligence Server 10.x/9.x, MicroStrategy Architect 10.x/9.x, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Report Services, MicroStrategy Distribution Services, MicroStrategy Mobile, MicroStrategy Transaction Services, MicroStrategy Visual Insight, MicroStrategy Office, Tableau Enterprise Desktop

Databases: Oracle, SQL Server 2014/2012/08 R2/05, Teradata, Netezza, DB2, MS Access, MS Access and Teradata V2R4.1, V2R6.0

Programming: SQL, PL/SQL, T: SQL

Data Modeling: Dimensional and Relational Modeling, Star and Snow - Flake Schemas, Slowly Changing Dimensions, Logical and Physical Modeling.

Web: HTML, JavaScript

Environment: s: Windows Server, Windows 7/8

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

MicroStrategy Developer

Responsibilities:

• Working with Confidential department to develop dashboards in a project, as a report developer created dynamic dashboards for patterned locations mapping and constituents.
• Responsible for the preparation and presentation of proto-type reports to end users and get acceptance to develop reports. Responsible for gathering requirements from Business User and creating mockups.
• Involved in the creation of intelligent cubes and aggregate tables to improve performance of enterprise reports with multiple hierarchies.
• Created advanced filters like Attribute-to-Attribute comparison filters, Joint element list filters and relationship filters.
• Worked closely with various teams across the organization to identify and solve business challenges utilizing large structured datasets.
• Created stored procedures to support reports.
• Created dashboards with multiple attribute element selectors, metric selectors and metric condition selectors.
• Was part of the mobile development team and worked on bubble chart derivation to the users.
• Developed dashboards on free form SQL reports in PL/SQL.
• Exhibited visual insights using dossiers.

Confidential, Wilmington, DE

MicroStrategy Developer

Responsibilities:

• Created and maintained dashboards for marketing and campaign.
• Worked on SQL Server, Teradata environment and MicroStrategy 10.4.
• 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
• Generated different kinds of Pass-through functions and used for time filters like current month and previous year etc.
• Designed developed tested and maintained Tableau functional reports based on user requirements.
• Created data mart reports, partition mappings and aggregate tables to improve performance of reports.
• Developed some free form SQL reports as a part of transaction services document development.
• Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and key performance Index corporate dashboards.
• Involved extensively in the overall lifecycle of the data warehouse integration project.
• Experienced in doing the quick POC's to satisfy business requests using Tableau.
• Involved in tuning of longer running queries by setting appropriate VLDB properties and by applying various design techniques to minimize the number of SQL passes generated by MicroStrategy.
• Customized and optimized reports for various users using MicroStrategy features like VLDB properties at project level and report level. Worked with end users along with Business Analysts to build reports and dynamic dashboards.
• Design and build pixel perfect report service documents and interactive Flash dashboards.
• Used intelligent cube reports in dashboard as datasets to achieve performance. Involved in moving the objects between two projects and two different environments by using Object manager.
• Provided production support to MSTR users and wrote SQL to support business requirements. collaborated with ETL team and scheduled automated cube refreshes using Jams.

Confidential, Camden, NJ

Software Applications Developer/ MicroStrategy

Responsibilities:

• Created and maintained dashboards for marketing and campaign.
• Worked on Oracle DB/ T-SQL Server environment and the latest MicroStrategy 10.3. Created and maintained reports for a portal and mobile environment.
• Involved in the meetings with business users to discuss and finalize the requirements and design of the reports .
• Migrated various reports and objects to MSTR 10.3 from SAP HANA. Worked with SAP HANA and Business objects consultant to acquire the form expressions and table names and column expressions to create the schema objects like attributes facts hierarchies and respective reports. During migration we had various changes to the database instances. According to the database instance variations with respect to HANA environment, I had to test all the reports master data tables in QA project source and Prod source as well.
• Built, mapped and deployed various objects like facts, metrics, filters, prompts and searches. Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drill down to claim (lowest) level.
• Worked on complex data models like Many to Many relationship mappings and maintaining Sparse data population as well.
• Managed projects through entire systems development life cycle, including creating timely thorough status reports and leading status meetings.
• Worked extensively with the users explaining them the mere differences between the web developed dashboards and mobile dashboards and acquiring the requirements accordingly with respect to the mobile development.
• Used Apply Simple and Apply Comparison functions to develop advanced filters and transformations. Worked on performance tuning and stress testing initiatives.
• Provided production support to MSTR users and wrote SQL to support business requirements.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production

Confidential, CA

MicroStrategy Consultant

Responsibilities:

• Responsible for the preparation and presentation of proto-type reports to end users and get acceptance to develop reports. Responsible for gathering requirements from Business User and creating mockups.
• Involved in the creation of Intelligent cubes and Aggregate tables to improve performance of Enterprise Reports with multiple hierarchies.
• Created Advanced Filters like Attribute-to-Attribute comparison filters, Joint Element List filters and Relationship filters.
• Worked closely with various teams across the organization to identify and solve business challenges utilizing large structured datasets. Created Stored Procedures to support reports.
• Created Dashboards with multiple attribute element selectors, metric selectors and metric condition selectors. Was part of the mobile development team and worked on Bubble Chart Derivation to the users.

Confidential

Business Data Analyst/ MicroStrategy Report Developer

Responsibilities:

• Analyzed the business requirements identifying the requirements reviewing and communicating with business.
• Highly involved in working with Multi-Dimensional Model, Star & Snowflake Schemas and other Data Modeling and Data Warehousing applications.
• Experience developing T-SQL/ Transaction Services Reports.
• Worked with Data Architect and Admin in Designing the Data Model. Installation of MicroStrategy Desktop and MicroStrategy Admin creating a MicroStrategy project.
• Designed MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and maintained data dictionary for the project.
• Created complex filters with advanced qualification involving 'Apply Simple' and 'Apply Comparison' functions.
• Dynamic Sourcing for specific cubes.

Confidential

Jr. Techno Functions Developer

Responsibilities:

• Accumulated data for the water conversation measures and rural water supply measures undertaken by the Central Government of India.
• Log Sheets preparation and Data analytics Module. Customer Client communication services. Preparation of Unit Test Plans.
• Maintain and followed established client Software Development Life Cycle (SDLC) methodologies on all projects.
• Setup the project sources, creating projects, duplicating projects, moving projects, deploying projects, mapping the warehouse catalog, creating metadata tables and statistics tables, creating necessary MicroStrategy objects.