SUMMARY:

• 10+ Years of professional IT experience in data modeling, designing and architecting data warehouses and Business applications in Retail, Chemical, Media and Telecommunication industries.
• 9 years of experience in MicroStrategy 9.x/8.x.x using MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Administrator, MicroStrategy Report Services, MicroStrategy Object Manager, MicroStrategy Command Manager, MicroStrategy Integrity Manger, MicroStrategy Dashboards and MicroStrategy Narrowcast Server.
• In - depth knowledge of fundamental Data warehousing concepts such as entity relational modeling, dimensional modeling, star and snowflake schemas, modeling data marts.
• Strong knowledge of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Solid Experience in generating complex reports using MicroStrategy.
• Strong troubleshooting capabilities in MicroStrategy Desktop.
• Expertise in working with Schema Objects like Attributes, Facts, Tables, Transformations, Hierarchies, Functions and operators
• Extensively worked in creating and integrating Public Objects (Filters, Metrics, Prompts, Reports, Templates, Documents, Custom groups and Consolidations)
• Implemented proactive delivery reports and implemented the business intelligence solutions using MicroStrategy Narrowcast Server.
• Extensive experience in development of SQL Queries, Stored Procedures and Triggers.
• Experience in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Involved at all stages of the data warehousing project; setting up the schema and architecture, developing reports, security and deploying to end users. Strong familiarity with the Extraction Transformation and Loading (ETL) process.
• System Optimization, performance monitoring and tuning experience in Multiple BI applications.
• Expertise in using the Erwin and ER Studio data modeling tool.
• Exposure to client interaction, user-requirement analysis and User support.
• Exceptional analytical and problem solving skills. Self motivated team player with the ability to communicate effectively at all levels of the development process.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.
• Good leadership qualities with experience in training developers, advising technical groups on coding best practices.

TECHNICAL SKILLS:

BI Tools: MicroStrategy Desktop 10.x/9.x, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligent Server, MicroStrategy Integrity manger, MicroStrategy Command manager, MicroStrategy Object Manager, MicroStrategy Enterprise Manager

Data Modeling: ER Studio 8/7.x, Erwin Data Modeler 4.0/3.5.2, MS Visio

Tools: ETL Tools Informatica Power Mart 7.1/6.0, Ab Initio 1.1/1.0, Ascential DataStage 7.0/6.0

Databases: ORACLE 10g/9i/8i, Teradata V2R4.1, Netezza, SQL Server 6.5/7/2000, IBM DB2, MS Access 2000

Programming: Visual Basic 6.0, SQL, PL/SQL, T-SQL, Shell Scripting, FORTRAN, Pascal

Web Language: HTML, DHTML, XML, XSL, Microsoft Front Page, Home Site 4.0, JavaAnd tools VB Script, ASP, JSP, ScriptOperating Systems MAC OS/OS X, MS-DOS, UNIX, WinNT, Window XP/ 2003/2000/98 and Linux

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

BI Admin/Architect

Responsibilities:

• Responsible for the design, implementation, management, administration and support of the MicroStrategy reporting environment.
• Manage the standardization of existing reporting efforts, including data-gathering processes, implementing stronger data quality standards, tools and training.
• Developed and delivered scorecards, dashboards, and trend data in partnership with the BI and Enterprise Architects. Strong analytical and problem-solving skills.
• Demonstrated knowledge of data warehousing, dimensional data modeling, OLAP, report and dashboard development, data mining, visualization, and data integration/transformation concepts.
• Document and deliver clear and concise communications to both technical and business leaders and the client on topics ranging from solution architecture, system performance, risks and issue mitigation strategies, and project status.
• Lead facilitated sessions with business and technology executives to select and define actionable metrics, KPIs, and visualization to support their performance management needs.
• Created Predictive Model Reports and Dashboards in MicroStrategy.
• Worked well with others on the team to design and maintain corporate data solutions, meet project milestones, manage client satisfaction and mentor others on the team.
• Created dashboards with drill downs, link to templates, info windows, bubble graphs and Pdf links.
• Experience in building custom Java/SDK solutions, consume web services, Xquery, jSON, subscriptions/schedules to interact with MicroStrategy reports/report service documents.
• Installed and configured MSTR 10.4 and 10.6 Versions.
• Configured and connected intelligent server, Connected to data warehouse and other repositories.
• Created DSNs for specified data sources, Created Database connections to web, Configured ODBC parameters.
• Upgraded MicroStrategy Intelligent Server, Webserver and Mobile Server from 10.4 to 10.6.
• Implemented admin functionalities of MSTR such as User creation, ACL, Movement of objects using Object manager, setting up of Enterprise Manager, security filters, subscriptions.
• Performed Functional, Integrity and Performance Testing after upgrade, Verified Licenses, activated installation and assigned privileges.

Environment: MicroStrategy 10.4/10.6 (Desktop, Administrator, Web, Visual Insight), SQL Server 2014/2016, Windows 7, Visual Studio 2015.

Confidential, Irving, TX

Sr. MicroStrategy Architect

Responsibilities:

• Performed Customer requirements gathering, Analysis, Design, Development, Testing, End User Acceptance presentations and Implementation for Forecast and Client Insights Projects.
• Took part in full data warehousing application lifecycle and converted requirements into logical data model.
• Created schema objects like Attributes, Facts, hierarchies, logical tables and created the required application objects such as Metrics, Consolidations, Custom Groups, Filters, Prompts and templates.
• Developed Transformations (table based, formula based) to be used for comparative analysis like claims this year to last year (year to date and month to date)
• Hands on experience in Performance Tuning of reports and Dashboards and optimizing VLDB properties to achieve maximum performance.
• Worked on complex metrics like Compound Metrics, Level Metrics, Transformation Metrics, Nested Metrics and Relationship filters for Forecast Project.
• Worked mainly on creating the Report services document with multi-layouts and designed to support all the export versions (Excel, PDF and Flash).
• Extensively used report services for creating summary level Enterprise Dashboards using Grid/Graphs, Gauges, Dials and Advanced Visualizations.
• Created and Deployed Multi Panel Dashboards, Multiple Images, Hyperlinks and edit links to navigate the documents between the hierarchy elements of Forecast project.
• Successfully completed different dashboard projects (web and mobile-IPAD) to provide users the convenience of doing data analysis in a better way.
• Experience with revamping existing dashboards to Mobile and creating new Mobile dashboards.
• Used Object manager to move objects between Dev, QA and Prod Environments.
• Converted SAS Code to SQL for comparing the source data used for populating Claims table as well as claims Dashboard.
• Provided training to the users, created documents for the users, involved in customer support and stabilize the report in production environment.
• Used Teradata SQL assistant extensively to test and debug MicroStrategy reports as a key step in data validation
• Managed users, privileges, access requests, security roles, security filters and ACL’s.
• Loading test data from source systems to target tables in Production environment.
• Performed tuning and optimization of complex SQL queries using Teradata.
• Using Teradata DDLs created Tables, Views, Macros, Triggers and Stored Procedures.
• Involved in Create / Modify / Drop Teradata objects like Tables, Views, Join Indexes, Triggers, Macros and Procedures.
• Conducted MicroStrategy technical interviews for prospective new consultants.
• Used Enterprise manager for Operation/Performance/Project/User and Real-time Analysis, created customized reports for our needs.

Environment: MicroStrategy 10.4.1/10.3.0 (Desktop, Administrator, Web, Visual Insight), Teradata, Windows, Teradata SQL assistant 14.10.

Confidential, Foster City, CA

Sr. MicroStrategy Architect/Developer

Responsibilities:

• Created MicroStrategy Preliminary and Detail design documents based on the business requirements.
• Document designs, specifications and flow diagrams to assist in efficient development, support and problem analysis.
• Created/Updated MicroStrategy schemas as per the requirements. Worked on Slowly Changing Dimensions and Many to Many relationships.
• Created/Updated reports, dynamic dashboards as per the requirements.
• Supported Deployment; Created documents, Integrity Manager test cases, and product support hand over documents.
• Created Compound Metrics forcing dimensionality and conditionality Built Complex level metrics to achieve the required results intended by business.
• Validate reporting results against requirements, troubleshoot and analyze data issues within reports.
• Implemented Type 2 slowly changing dimensions using logical views by creating compound keys and surrogate keys.
• Multi-panel Dashboards with information about Transactions, Offers and Events, Attributes, Links to detail report was Designed and Implemented using 13 datasets.
• Development experience with visual insight, dashboards, and mobile.
• Visual Insight - Created analysis and added visualizations using the data from existing reports and Intelligent Cubes (I-cube).
• MicroStrategy Mobile - Created Dashboards for Business Leaders, Business Managers to access on IPhone and IPad.
• Developed mobile dashboards for the IPAD application for landing page dashboard.
• Created Landing Page Dashboard on Product and Usage Type for VisaNet and DPS Users. This Dashboard includes Micro chart Ticker Widget and Links to Other Dashboards.
• Implemented best practices like choosing right visualizations, planning outline and creating right datasets to enhance Dashboard performance.
• Administered the object change management process: Object migration across the various environments using Object Manager.
• Handled all aspects of user security, including creation of new profiles, user change management, Security roles, and user group management.
• Created Time Triggered and Event Triggered Schedules, Events and Subscriptions for the Intelligent Cubes reports. Created batch files using command manager script to trigger events.
• Extensively worked on Intelligent Cube Reports for Creating Dashboards. Monitored and Governed Intelligent Cube for better Performance.
• Created Logical Tables in MicroStrategy to meet the Complex end user requirements.
• Involved in development and integration including setting up configuration management, developing components, peer review, creating unit test plans, and performing unit and regression testing, used Integrity manager.
• Supporting and managing special projects, ad-hoc management reporting requests, testing, and issue resolution

Environment: MicroStrategy 9.4.1 (Desktop, Administrator, Web, Visual Insight) DB2, Oracle, Windows, TOAD for DB2 4.7

Confidential, Houston, TX

Sr. MicroStrategy Architect

Responsibilities:

• Architect and develop Business Intelligence applications utilizing all possible information delivery channels.
• Worked directly with various Stake holders in gathering new report requirements and implementing them.
• Created Report Services Documents for Service Quality Exception reporting and myMaintenance projects which includes Invoices, Balance Sheets and Score Cards.
• Defined definitions and created metrics, attributes, filters, prompts, Custom Groups and consolidation objects in MicroStrategy.
• Worked extensively on Dynamic dashboards with MicroStrategy Web Professional and deployed the enterprise reports using MicroStrategy web Interface.
• Work closely with Product Management to layout the project timelines and deliverables
• Worked on the Visual Insight analysis and Transaction Services dashboards for the Operations teams with data from different source systems.
• Worked closely with data architects, application development, ETL development team to design and implement BI applications using shared architecture and Enterprise Data Warehouse.
• Developed scripts to automate many day to day project maintenance related tasks using command manager.
• Troubleshooting existing productivity issues and develops the areas and systems to improve performance.
• Handled administrative console for reports publishing, scheduling, user security.
• Created static subscriptions for the users stored in subscription book and created Dynamic subscriptions for external users by executing information object.
• Perform release management and object migrations for the upcoming and existing applications.
• Collaborate with Project Manager, Developers, QA teams and Business SMEs to ensure delivered solutions optimally support the achievement of business outcomes.
• Trouble shooting ETL process using Oracle SQL Server.
• Worked closely with Source Systems in identifying data quality issues.
• Solved MicroStrategy tool issues with the help of Technical Support.

Environment: MicroStrategy 9.4.1 (Desktop, Web, Administration), Integrity Manager, Command Manager, User Manager, Oracle 11g, Linux, Oracle SQL developer, Windows.

Confidential, Smithfield, RI

Sr. MicroStrategy Lead/Architect

Responsibilities:

• Evaluated functional and technical business requirements for Incident Reporting Project in Rx Data Warehouse Management Team.
• Provided leadership and direction for MicroStrategy portion of project using MicroStrategy, Teradata and Oracle.
• Teradata is being used as data warehouse with a variety of databases, applications and flat files as data sources.
• Primary responsibility is to review, update and maintain MicroStrategy related system architecture to build a MicroStrategy suite of applications.
• Transformed requirements into MicroStrategy solutions that efficiently enable expected application, reporting, and analytic capabilities to support the business and strategic initiatives of the enterprise
• Provided development of integrated MicroStrategy solutions, review and validation of existing reporting and new solutions to ensure continuous accuracy and front end ease-of-use
• Founded opportunities in the areas of user experience as well as innovative ways (R&D) to deliver powerful analytical insight.
• Contributed to the review of test plans, test cases to ensure all requirements are covered and documents are thorough.
• Worked with team lead and business analyst to provide support and contribution in preparing critical User Acceptance scenarios.
• Deployed/migrated product in QA and production environment using Object Manager; served as the subject matter expert for systems in production - helping to ensure a stable, robust production environment
• Trained QA Teams on work and usage of Integrity Manager and effective uses of Baselines for comparison.
• Communicated across a diverse workforce to ensure work transitions effectively without interruption or incident.
• Designed and developed database objects like tables, views and procedures in Oracle and Teradata environments.
• Performed Import and export of data across DEV and QA environments from PROD.
• Created Database Instances and connection mapping for access to proper warehouses and users
• Involved in Customer Support, Maintenance & Performance tuning of the project.
• Demonstrated Complete MicroStrategy Suite (Reports, Dashboards and Report Builder) for end users.
• Interacted with business users on regular basis to know requirements and provide technical assistance regarding problems and help with the tool.

Environment: MicroStrategy 9.4.1/9.3 (Desktop, Web, Administration), Integrity Manager, Command Manager, User Manager, Teradata 14, Teradata Studio Express, Teradata Client 13.10, Oracle 11g, Linux, Oracle SQL developer, Windows.

Confidential, Foster City, CA

MicroStrategy Admin/Architect

Responsibilities:

• Worked with the ETL team and business operational teams to understand data sources and implement new requirements for DPS-Portfolio Optimization Project.
• Created MSTR Prelim and Detail design documents based on the business requirements.
• Developed and implemented complex MicroStrategy reports, Dashboards and Visualizations for VDM Fraud Dashboard Reports &KPIs Project.
• Created/Updated MicroStrategy schemas, reports, dynamic dashboards as per the requirements.
• Involved in the lifecycle of VDM Fraud Dashboard Reports &KPIs Project, DPS-Portfolio Optimization Project and VDM Prepaid Cardholder Data Integration.
• Provided Support for QA, UAT Environments and DR fixes.
• Administered the object change management process: Object migration across the various environments using Object Manager or Project Merge.
• Handled all aspects of user security, including creation of new profiles, user change management, Security roles, and user group management
• Worked the Production issues queue, provided full support to our business intelligence community
• Created Schema Objects and Public Objects with Command Manager.
• Created Time Triggered and Event Triggered Schedules, Events and Subscriptions for the Intelligent Cubes reports. Created batch files using command manager script to Trigger events.
• Added Nodes to VLDB XML file for creating new VLDB Options
• Created a Database Instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Extensively worked on Intelligent Cube Reports for Creating Dashboards. Monitored and Governed Intelligent Cube for better Performance.
• Created Logical Tables in MicroStrategy to meet the Complex end user requirements.
• Extensively used Pass through Functions.
• Designed and Worked on Current and historical data implementation in MicroStrategy.
• Validate reporting results against requirements. Troubleshoot and analyze data issues within reports
• Extensive Experience in MicroStrategy Mobile platform
• Expertise in Integrity Manger. Trained QA Team on Integrity manager Usage. Compared report and I-Server performances in DB2 and Oracle Databases.
• Prioritize and multi-task concurrent projects; Effective in resolving all clients and development issues
• Coordinated the Onsite and Offshore team to resolve issues.
• Created manual test cases and Performed Integrity Testing for all the reports.
• Performed backend testing by executing SQL Queries.

Environment: MicroStrategy 9.0.2/9.2.1 (Desktop, Administrator, Web), MicroStrategy Architect, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy Command Manager, MicroStrategy Integrity Manager, DB2, Oracle, Windows, TOAD for DB2 4.7

Confidential, San Jose, CA

Sr. MicroStrategy Architect

Responsibilities :

• Worked with business requirements analysts / subject matter experts to identify and understand the requirements and produce the report design specifications and estimates of the project.
• Worked for the lifecycle of GBSC (Global Balance Score Cards) for all the three Releases for the finance team.
• Created Front End STM for the Reports for acceptance.
• Architected schema objects such as attributes, facts and transformations.
• Created various MicroStrategy objects such as Metrics (simple, compound, Nested and rolling), Filters, Prompts, Custom Groups, Consolidations, etc.
• Created a DB instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Worked with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.
• Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
• Worked on Root Cause and Fix for various dashboards raised by users and testers as Jira bugs for CS Reporting.
• Micro strategy I-Server Tuning for performance.
• Performance tuning of SQL for long running reports.
• Created various event based Schedules.
• Deploying Flash Widgets on Servers and Uploading the New ones from Support site.
• Created reports with various object prompts to generate various Ad hoc reports.
• Worked with Erwin in designing the schema for database views.
• Created various Report Services Documents with various transformation metrics to report on CSF Month, CSF Quarter, CSF Year, Prev Month, Prev Quarter, SMLY, and SQLY.
• Created various Monthly, Quarterly and Yearly Dynamic Dashboard documents for Finance people with multiple panel stacks, selectors and customized widgets.
• Created various Narrowcast reports, subscriptions and schedules, created both static and dynamic subscription sets using Narrowcast server.
• Developed Freeform SQL Reports, Standard Reports and Dashboard Reports.
• Analysis and Troubleshooting of the SQL generated by MicroStrategy.
• Implemented OLAP Functions like Apply Simple, Apply Comparison for the complicated filters, attributes and metrics.
• Worked on the issues caused by the dashboards after migrating to version 9.3

Environment: MicroStrategy 9.3/ 9.2.1 (Desktop, Administrator, Web), MicroStrategy Architect, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Teradata 13, Oracle, Windows, MAC OS X

Confidential, Hoffman Estates, IL

MicroStrategy Architect / Lead

Responsibilities:

• Involved in the complete life cycle of the project from gathering business requirements, creating architecture for the business for Canned Reporting and Ad-Hoc reporting for Price Analysis reports.
• Involved in Establishing ODBC connections to multiple DBs.
• Created new Project and project sources and worked on getting tables from the Data Mart into the MicroStrategy environment using the Warehouse catalog.
• Worked extensively on creating Metrics, Prompts, Filters, Custom Groups and Consolidations for complex reports.
• Configured Very Large Database (VLDB) Properties at different levels (report, metric, project and database Instance)
• Involved in troubleshooting MicroStrategy Web Reports, and optimizing the SQL using the VLDB properties
• Extensively built Flash Dashboards for multiple Business Clients; the dashboards used custom widgets, panels, selectors and flash visualizations.
• Extensively used MicroStrategy Desktop and Web to enable users to run pre-defined sales and inventory reports, build their own customized reports and download information into Excel spreadsheets.
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services involving multiple datasets.
• Extensively worked on various formatting issues in MicroStrategy Web and Excel
• Created personalized reports for end-users by creating various templates, filters and trained for the efficient use of MicroStrategy Web interface.
• Created reports using Intelligent Cubes.
• Created new user group and added new users to the group and assigned security privileges
• Performed Administration tasks (User Management, Cache Management, Schedule Management, etc.)
• Participate in daily status and monthly planning meetings
• Train and mentor Offshore Team in the use of MicroStrategy software and techniques.

Environment: MicroStrategy Architect, MicroStrategy Desktop 9.2.1, MicroStrategy Web, MicroStrategy Intelligence Server, Integrity Manager, Object Manager, Teradata, Erwin Data Modeler, Windows XP professional and Windows NT.