­

SUMMARY

­­­­­­­­­­­­­­­­­­­­­­­­

• Total of 13+ years’ experience in Functional & Technical Consulting of Microstrategy solutions, Business Analysis, software testing, with major focus on Business Intelligence tools.
• Created and integrated MicroStrategy Dashboards, Reports and Objects like Attributes, Facts, Filters, Metrics, Prompts, Custom Groups, Consolidations, and Transformations with data warehouse to enable clients to assess their services against data assets to increase profitability and manage risks by reducing the operational costs.
• Successfully upgraded all MicroStrategy Intelligence Server 7 projects to MicroStrategy 8 Intelligence Server projects using the MicroStrategy 8 Project Upgrade Wizard. Excellent at translating business objectives and strategies into innovative, interactive design
• Deep dive knowledge in different types of data modeling, like - star schema modeling, snowflake modeling
• Participated as a team member in ETL functions and supported data extraction, transformations, dashboards, and loading processing in a corporate-wide-ETL solution using INFORMATICA
• Worked on Sql Server v12, Oracle 8i/9i, Teradata 7.1 databases Installed and Configured Intelligent Server and Narrowcast Server to schedule execute and deliver reports using various delivery methods

TECHNICAL SKILLS

Professional Expertise: Project Coordinator, BI Solution Architect, MicroStrategy Architect & Developer, Business Analyst, Logical Data Modeller, Data Analyst, Report SQL Tester

BI Tools: MicroStrategy 7.5.x,8.0.1,8.1.1,9.x.x,10.x.x, Cognos 8.0, Tableau 10.4 v

Scrum Tools: JIRA 5.0Database Languages: SQL Server 2012,2008, Oracle 10x,9x, Teradata 10x, Access, Excel

Database Tools: TOAD 6.5, Teradata SQL Assistant 7.1, SQL Plus Loader, ORACLE 9i, 10g, MS ACCESS, TERADATA v12

Desktop Tools: Microsoft office Tools, Flash

Programming Languages: JavaScript, SQL, HTML, XML, .NET

Operating Systems: Windows 200x/9x/NT, Unix

Verticals-Domain: Retail, Insurance, Automobile, Banking, Healthcare

Testing Tools: Win runner 8.1, Load Runner 6.5, Quality Center 9.1, QTP 8.1

PROFESSIONAL EXPERIENCE

MicroStrategy Solution Architect

Confidential

Responsibilities:

• Worked closely with clients to understand the dashboard requirements.
• Created Logical data model based on the Mockups sent by the client
• Developed Attributes, Facts, Tables, Hierarchies as an Architect
• Created complex Metrics, Advanced Filters and other public objects as required.
• Successfully created user friendly Dashboards prototypes as per their requirement
• Helped team members in creating dashboards assigned to them
• Provided unique ideas for creating performance based dashboards.
• Unit tested dashboards and datasets
• Created tables in SQL server 2008 to make loading of data easy
• Created complex queries to automate load into critical tables
• Unit tested data as once load was complete
• Discussion on critical issues and complexities in daily meetings on enhancements and upgrades

Microstrategy Architect

Confidential

Responsibilities:

• Architect developer
• Created Star and Snowflake schema/Logical Model as per BRD.
• Developed derived, implicit Attributes, Facts, Tables, Hierarchies as an Architect
• Developed prototype dashboards for IRI and IRO team as per business requirements
• Helped team Members in creating dashboards assigned to them
• Successfully created Complex Dashboards with smart controls which enabled user to easily view data at various levels and enabled complex URL API functionality
• Provided unique ideas for creating performance based dashboards.
• Created estimation document to help business know the duration for creating schema and public objects.
• Created Metrics, Filters and other public objects as required.
• Unit tested dashboards and datasets
• Guided a of team of 5 members to Load, Map, cleanse data from text and excel files in critical tables
• Worked closely with clients to understand the data load requirements.
• Created a DFD diagram to better understand the flow from File capture to loading the data in the data warehouse
• Created complex queries in SQL server 2008 to make loading of data easy
• Created complex queries to automate load into critical tables
• Unit tested data as once load was complete
• Discussion on critical issues and complexities if any in team meetings

Project Lead

Confidential, Nashville, Tennessee

Responsibilities:

• Data Analyst & Tech Lead
• Created & Published huge Intelligent Cubes and unit tested all column data through subscriptions
• Created reports and dashboards from SSAS MDX cubes and I cube and provided statistics information regarding performance.
• Imported SSAS cubes into Microstrategy as MDX cubes and created reports. Established Connection to SSAS environment through XMLA configured msmdpump.dll file which acts as a interface to SSAS.
• Developed prototype dashboards for sales and marketing division as per business requirements
• Created Complex Dashboards with smart controls which enabled user to easily view data at various levels
• Integrated Command manager utility with C#.NET to create a user-friendly windows application for Microstrategy administration purpose
• Resolved Defects tickets as per the priority and severity.
• Provided unique ideas for creating performance based dashboards.
• Created Metrics, Filters and other public objects as required.
• Unit tested dashboards and datasets
• Guided a of team of 6 members to Load, Map, cleanse data from text and excel files in critical tables
• Worked closely with clients to understand the data load requirements.
• Created a DFD diagram to better understand the flow from File capture to loading the data in the data warehouse
• Created complex queries in SQL server 2008 to make loading of data easy
• Created procedures to automate load into critical tables
• Unit tested data as once load was complete
• Created a initial score card to let stake holders know about the initial status before file load
• Created final scorecards to let stakes know regarding the final out come after the load
• Discussion on critical issues and complexities if any in team meetings

Project Lead

Confidential

Responsibilities:

• Project Architect
• Worked closely at client location with DM & PM to understand the project requirements and meet activity timelines.
• Initiated discussions with assigned leads to understand the overall progress of the project and resolve any technical issues.
• Worked as a pyramid lead for the project.
• Initiated team meetings whenever required to resolve any discrepancies between team members
• Interacted with stakeholders to understand the requirement documents.
• Interacted with database designers to help them create logical views
• Participated & created HLD document as per my role.
• Created Microstrategy Schema Detail design document
• Created Attributes, Facts as required in Microstrategy Architect
• Provided guidance to report designers to create report Mockups
• Involved in discussions to resolve complex infrastructure issues
• Worked extensively to provide valuable inputs to ease out tricky OLTP issues related to the project
• Instrumental in creating security groups for the project as required.
• Worked with developers as a mentor to help them create reports.
• Smoke tested entire schema objects to check the application Flow.
• Initial level UAT testing with BA to understand the report flow.