SUMMARY:

• 8+ years’ IT Experience with well acquainted in performing as Micro Strategy Developer and Architect with strong domain knowledge of Communication, Financial, Pharmaceutical and Retail.
• Extensive experience as Micro Strategy Developer building projects and creating reports and dashboards using Micro Strategy 10.x/9.x, Micro Strategy Desktop, Micro Strategy Web, Micro Strategy Intelligence Server, Micro Strategy Architect, Distribution services and OLAP services.
• Extensively worked in creating and integrating Micro Strategy Reports and Objects (Attributes, Filters, Facts, Prompts, Templates, Consolidation and Custom Groups).
• Extensive knowledge on Metrics, Graphs, Data group, Explore the data, Visualize the data, Drill Through the data, Adhoc reports.
• Experience in Micro strategy schema & application layer, report analysis & report services (dynamic dashboards) design, development, implementation, migration and testing.
• Well versed in developing interactive Dashboards and Scorecards.
• Experience in Micro Strategy mobile supporting both Android and IOS platforms.
• Involved in Upgrades from Micro Strategy 9.x to 10.x on Windows platform.
• In - depth understanding of designing physical Data Models using Micro Strategy Architect.
• Hands-on experience working with VLDB and Optimization of query performance.
• Performance Optimization, performance monitoring, configuring and tuning experience in Micro Strategy Business Intelligence tool suite (Intelligence server, Web) and in database.
• Knowledge and understanding of Micro Strategy Software Development Kit (SDK).
• Interacted with Micro Strategy SDK Modules.
• Pro-active involvement in continuous performance improvements for existing OLAP systems.
• Working Experience in installing and Configuring Micro Strategy 10.x/9.x, Micro Strategy Desktop, Micro Strategy Web, Micro Strategy Mobile, Micro Strategy Intelligence Server.
• Experience includes implementing all phases of the System Development Life Cycle (SDLC), including Business Requirements Gathering, Design, Development, Testing, and Implementation of Client-Server, Multi-tier, Web, Data Modeling and Data Warehousing/OLAP/Business Intelligence Applications.
• Dedicated, detail oriented and extremely hard working with extensive technical skills.
• Well-Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.
• Created security role for every environment.
• Created security filters for the school users to view their respective reports.

TECHNICAL SKILLS:

BI Tools: MicroStrategy10/9.x/8.x (Administrator, Architect, Desktop, Web, Intelligence Server, Narrowcast Server, Report Services and OLAP Services)

Databases: Teradata 14.0,V2R4.1,Oracle 12c,11g,11i, SQL Server (2005/2008), IBM DB2, MS Access 2000 and V2R6.0, Informix

Data Modeling: Microsoft Visio, Erwin 4.5

ETL Tool: SSIS, Pentaho

Languages: C, SQL, PL/SQL, Transact SQL.

Web: HTML, DHTML, XML, XSL, JavaScript, MS Office.

OS: Windows7/ XP/2003/2000,UNIX and Linux

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Business Intelligence Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements and data specifications.
• Involved throughout the business Software Development Life Cycle (SDLC).
• Followed Agile with Scrum SDLC.
• Created and reviewed business requirements, functional specifications, project schedules, and documentation.
• Conducted meetings with business users and SMEs to identify and gather various functional and non-functional requirements.
• Design, develop and test various reports for Confidential Benefits commercial insurance.
• Debug, monitor and troubleshoot the BI solutions and reports.
• Write relational database queries to support the reporting requirements.
• Participated in daily status and monthly planning meetings.
• Migrate the production reports to Micro Strategy using Freeform SQL in MSTR.
• Create complex metrics and attributes per the requirements and create dashboards with multiple layouts and visualizations.
• Provide the users with opportunity to filter the reports using dynamic filters and prompts in Micro Strategy.
• Involved in optimization of code and tuning queries for performance.
• Extensively worked on resolving user issues.

Environment: DbVisualizer Pro 9.5.1, Apache Hive Data Lake, SQL, JIRA, SharePoint, Micro Strategy Desktop 10.4 HF4, Micro Strategy Web, Windows 7, Microsoft Office.

Confidential, Remote/ Minnetonka, Minnesota, MN

MicroStrategy Developer/Architect

Responsibilities:

• Responsible for gathering and refining business requirements from the business users.
• Extensively worked on multiple projects including Client Journey, Reconciliation, Transactions Support etc.
• Involved in meetings to discuss and suggest on the data model to be created in the DB to support reporting in MicroStrategy.
• Migrated reporting from SSRS to MicroStrategy with a source system change from DB2 to Teradata.
• Created views in SQL Server and also logical views in MicroStrategy to support varying requirements from the business users.
• Developing Multidimensional Model (Logical Model) by studying the source systems and business requirements.
• Created the Metadata and Statistic tables for the project on SQL Server database.
• Architecting the MicroStrategy Projects which involved in creating the Attributes, Facts and Hierarchies.
• Responsible for creating Metrics, Filters, Custom Groups, Prompts using MicroStrategy Desktop and Web.
• Created interactive dashboards and Visual Insights that the users can use and analyze various claims that are processed or being processed.
• Involved in troubleshooting MicroStrategy prompts, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Exploited the use of Analytical Engine bypass functions like Apply Simple & Apply Comparison effectively whenever necessary.
• Worked on MicroStrategy Transaction services to allow the users update fields.
• Created different Transformations to get the last year actual transactions, week to day, week to period, week to quarter, and week to year and effectively used them with the metrics.
• Optimized Query Performance by using VLDB settings.
• Modeling and populating the business rules using mappings into the Repository for Metadata management.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Resolved issues that the users encounter and submit through Ticketing system ServiceNow.
• Worked in an onsite-offshore model with developers working from US, Canada and India.

Environment: MicroStrategy 10.4.1/9.4.1, Desktop, Web, Object Manager, Intelligence Server, Enterprise Manager, SQL Server, Teradata, SSIS, Windows 7, Microsoft Office.

Confidential, Wilton, CT

BI Developer/Architect - Micro Strategy

Responsibilities:

• Gather report requirements from users.
• Created Application Design Documents.
• Collaborate with database architect and ETL developers to aid in the design of efficient and robust data structures for reporting and analysis.
• Created Application Objects like Metrics, Filters, Prompts and Reports using Micro strategy Desktop.
• Created Schema Objects like Facts, Attributes and User Hierarchies in Micro strategy Architect. Also used Table Aliases in Architect to define different roles for an AT&T Employee.
• Created heterogeneous and homogeneous attributes.
• Defined relationships between attributes in System Hierarchy. Also created User Hierarchies to suffice drilling & browsing needs.
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics and Transformation Metrics.
• Created Dashboards with multiple attribute element selectors, metric selectors and metric condition selectors.
• Created Summary Dashboards and linked it to Drill-down dashboards using Edit Links and also Hyperlinks. Also used HTML code on Dashboard and created links.
• Used various selector styles like Button Bar, Radio button, Check Box, Drop Down, List Box and Link Bar. Also used Analytic-Based selectors in Dashboards.
• Created various graphs like Pie Charts, Vertical Clustered Bar charts and Bar-Line charts.
• Optimized report SQL using VLDB properties.
• Used the Object Manager to move the objects from Development to Staging and Staging to Production Environment.
• Created Object Prompts & Value Prompts and used them in Unit/Revenue Dashboards.
• Involved in upgrading the MSTR environment from 9.4.1 to 10.3
• Tested the functionality in 10.3 in comparison to 9.x. Made use of new HTML5 widgets in 10.3 to design dashboards.
• Worked with Offshore Testing team and assisted them with creating test cases.

Provided post production support for users & resolved defects during the QA and UAT process.

Environment: MicroStrategy 10.3/9.4.1x, Desktop, Web, Object Manager, Intelligence Server, Enterprise Manager, SQL Server, Windows 7, Microsoft Office.

Confidential, Commerce, CA

MicroStrategy Developer

Responsibilities:

• Involved in business requirements gathering for Supply Chain, Store Ops, Customer/Marketing, Finance/Sales Audit, Loss Prevention, Human Resources departments.
• Integrated various client specific reports into MicroStrategy by combining data coming various data sources.
• Involved in all phases of the Project from requirement gathering to Production release.
• Involved in resolving the issues on some of the ad hoc reports by implementing a data validation.
• Built reports that helped the users in prioritizing their orders which helped in improving their service level.
• Built service level scorecards at various levels in Business (Buyer, Category Manager and Vendor).
• Developed useful existing reports and created dashboards with Key Performance Indicators.
• Created Customer behavior dynamic Dashboards and Spending pattern Scorecards involving graphs and statistical calculations
• Migrated the MicroStrategy objects from Development to Test system for user testing and to Production system
• Configured the Enterprise Manager to analyze the user traffic and the projects/reports that are being used.
• Worked with users to determine which projects are required moving forward
• Interacted with DBA team in tuning queries by collecting statistics, creating indexes
• Followed best practices and created standards document for MicroStrategy project development

Environment: MicroStrategy 10/9.3.1, Desktop, Web, Intelligence Server, Narrowcast Server, DB2, Informix, Visio 2013, Windows 7, Microsoft Office.

Confidential, Orlando FL

Sr. MicroStrategy Developer

Responsibilities:

• Interacted with the Business Analysts and Enterprise users.
• Involved in the development of Data Models (physical/logical) using Erwin tool as KBB data and reporting requirements are completely different from the existing scenario.
• Involved in architecting the schema objects Attributes, Facts, Hierarchies.
• Designed the configuration objects Filters, Base Metrics, Derived Metrics, Templates and Reports.
• Customized the drilling options specific to the reports using drill map editor to give access to more detailed and supplemental information.
• Customized reports using Custom Groups and Consolidations.
• Designed Compound metrics and Complex filters and Time filters.
• Developed various Prompts supporting end users to interactively choose different filtering criterion.
• Optimized query performance by updating VLDB properties at project level and report level.
• Performed optimizations using Report Data Options.
• Involved in development of interactive dashboards and scorecards for high level management.
• Extensively giving mock-ups to the Enterprise user to better understand the reporting analysis and also making their life easier.
• Used Micro strategy Web to offer interactive reporting to the end users through a web browser
• Extensively used Micro strategy Web to enable users to run-predefined sales and inventory reports for building their own customized reports.
• Analyzed the best way of approaching towards the reporting with minimum amount of maintenance effort, QA work and also giving the flexibility to the users to pick and choose whatever data they like from different key tables.
• Involved in changing the existing Sales Organization Hierarchy, which is required to be modified as underlying data were reorganized.
• Unit tested the reports developed by the other developers.
• Assisted the team in integrating the current project with new Enterprise analytics.
• Assisted the team in identifying the errors in the underlying data.
• Created security role for every environment.
• Created security filters for the school users to view their respective reports.

Environment: MicroStrategy 9.3.1 (MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Teradata 14.0, Oracle 12c/11g, UNIX, Windows 7.

Confidential, Atlanta GA

MicroStrategy Developer/ Architect

Responsibilities:

• Involved in collecting and documenting business requirements from end clients and translating them into report specifications for the Micro Strategy platform.
• Involved in Dimensional Modeling by selecting the business process and choosing the dimensions and facts.
• Took part in full data warehousing application lifecycle starting from creating logical and physical data model.
• Identifying and modifying source tables and columns in the warehouse required creating the Micro Strategy project. Studied and modified the attributes, facts and hierarchies based on the requirement. Used MicroStrategy Desktop for creating various application objects.
• Created logical data models to recognize source tables and columns, to build Micro Strategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create Micro Strategy project.
• Extensively worked in developing Metrics (Dimensional metrics, Compound metrics), Filters, Custom groups and Consolidations for complex reports. Worked on Teradata.
• Used Transformations for comparative reports like claims this year to last year (year to date and month to date).
• Generated Key Performance Indicators (KPI) metrics and other metrics.
• Generated reports for the cooperation for Assets period to period.
• Tested report layouts, validated the SQL query, prompt ordering prompt defaults, security filters, export / print functionality and drilling options like simple and advanced.
• Delivered documents for Financial Analysis, Statements and Summary, Customer lifetime value and Customer loyalty.
• Developed Flash Dashboards & Scorecards in Micro Strategy 9 using Widgets and Selectors for summary level reporting.
• Managed projects through entire Systems Development Life Cycle, including creating timely thorough status reports and leading status meetings.
• Added new users to groups and assigning them security privileges.
• Proactively created report formats and delivered personalized messages from the BI platform through Micro Strategy Narrowcast Server to a wide range of users.

Environment: MicroStrategy 9/9.3.1/9.2x, ERWIN 4.0, TOAD 7.0, Informatics Power Center, Oracle 11i, Windows XP.

Confidential, San Diego CA

MicroStrategy Developer

Responsibilities:

• Co-ordinated meetings with clients and business users to discuss and understand requirements.
• Involved in discussion with data modelers to understand data modeling of existing schema.
• Worked with client to gather requirements and prepared technical specifications documents.
• Responsible for the preparation and presentation of proto-type reports to end users and get acceptance to develop reports.
• Involved in JAD (Joint Application and Design) sessions and GAP analysis sessions to understand existing reports and convert Congas reports into Micro strategy by creating corresponding Attributes, Metrics, Filters and Prompts.
• Involved in migration of Cognos reports into Micro strategy Reports.
• Involved in designing of schema objects like Attributes, Facts, Hierarchies and Transformations from data warehouse.
• Expertise in using Apply simple Function in Attributes and Metrics to make manipulations to values.
• Responsible in developing of public objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Reports) on top of Schema Objects.
• Responsible for the creation of metrics like Compound metric, Derived Metric, Filter Metric and Transformation metric to generate more complex Micro strategy reports in an efficient way.
• Involved in creation of logical views and Freeform Sql Reports to translate Freeform Sql Cognos Reports into Micro strategy Reports.
• Expertise in developing Micro strategy reports by combining multiple Cognos reports based on functionality and usability of reports.
• Used Apply Simple and Apply Comparison functions to develop Advanced Filters and Transformations.
• Involved in creation of reports at Aggregate Level as well as Detail Level Tables to retrieve data in an efficient way.
• Involved in setting of VLDB Properties to improve performance of reports as well as passing hints to the SQL queries.
• Expertise in developing dashboard reports in Micro strategy by combining multiple reports in Cognos by using selectors.
• Involved in development of reports on Sap Cubes.
• Involved in moving the objects between two projects and two different environments by using Object Manager and resolve conflicts between environments by using conflicts resolution window.
• Involved in creation of Users/User Groups and assigning appropriate privileges through User Manager in Administration.
• Involved preparing Test Plans, Test Conditions for developed reports and uploaded test conditions into the Quality Center and Pass those conditions into the Test Lab.

Environment: Micro strategy 9.0.2,Architect,Web Intelligence, Object Manager, Cognos 8.4.1,Framework Manager, Query Studio, Report Studio, Informatics 8.6.1, Teradata 12, DB2 8.x/9.1, Oracle 10GR2,SAP, SQL, PL/SQL, Windows NT and UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyzed business requirements from BRD document and worked closely with end Users to get exact business requirements.
• Designed and Developed Interfaces using Interface Manager and creating procedures, functions, packages.
• Synchronizing data between Cashin and IM/RM system. Integration testing for complete flow.
• Comfortably worked in a production environment with change management, defect tracking and status reporting processes.
• Played an important role in Analysis, Design, Development, Testing, Documentation, Implementation, Maintenance and Performance tuning of the project.
• Participated in daily status and monthly planning meetings.
• Involved in deployment of product, 8 months on-site support, Production support and client Interactions.

Environment: CMS Tools, Oracle 10g (PL/SQL), Power Builder, Oracle 10G reports, Report 6i