SUMMARY:

• Business Intelligence /Data Warehouse specialist with over 6 years of IT experience, about 5 years of developing business intelligence solutions Extensively involved in complete life cycle of Data Warehouse implementations from data modeling, data analysis, Business Analysis, application architecture, design and implementations of reports, dashboards and production rollout. Extensively worked using MicroStrategy Reporting suite with Schema Architect experience, Dashboard, MicroStrategy Administration and enabling Self Service BI. Great team player and self - learner who can independently conduct research and propose innovative solutions. Well respected for analytical, project management, problem solving, team building and leadership skills, as well as for commitment and work ethics.
• 6+ years of industry experience in 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 Applications.
• Experience in planning, analysis, design, testing and integration of reporting solutions in Agile and Waterfall environments.
• Exclusive knowledge in the concept of Data warehouse, Star and snow flake schema, Facts and Dimensional tables
• Highly proficient in writing optimized SQL queries.
• Strong knowledge of the MicroStrategy Business Intelligence product Suite; including Desktop, Web, Architect, Visual Insight, Documents, Dashboards, Distribution services, Object Manager, Integrity Manager, Enterprise Manager,
• Experience as a MicroStrategy Administrator in creating Users, security roles and tuning the VLDB Properties for better performance.Experience in creating Schema Objects (Attributes, Facts, Tables, transformation)
• Strong understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC). Developed test strategy, test plans, test cases and performed test execution/validation, defect tracking, test deliverables and production support.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 9.4/9.3/9.0.2, MicroStrategy Architect, MicroStrategy WebMicroStrategy NarrowCast Server, MicroStrategy Mobile, Tableau, SSRS

ETL Tools: DataStage, Informatica

Operating Systems: UNIX-Linux, Windows7, Windows XP, Windows NT, Windows 2005/2008, Windows2012

DBMS: PostgreSQL, DB2, SQL Server, Oracle, Netezza. Vertica

Methodologies: Agile, SCRUM, Waterfall, SDLC, Project Management

Web Design: HTML, XML, SOAP, FIXML

Scripting: UNIX shell scripting, Ruby Scripting, Java Script, SQL Script, VB Script

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, MN

MicroStrategy Architect/Developer

Responsibilities:

• Collaborate with data modelers and ETL developers to aid in the design of efficient data model for building MicroStrategy reporting suite
• Involved in design, development and implementation of financial stress testing, planning reporting application using MicroStrategy for Capital Analysis and Credit Services analytics.
• Interface directly with business customers to understand their process and information needs. Designed prototype dashboards and reports before starting development
• Designed and developed MicroStrategy Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Created MicroStrategy Free Form SQL reports for certain reports that could not be built by traditional schema architecture
• Designed and built pixel perfect MicroStrategy report service documents and interactive dashboards using widgets like google map widgets, heat maps and bubble grid.
• Build the report builder interface for the Adhoc Analysis.
• Involved in MicroStrategy administration like object migration, creating users, setting up security filter
• Create Intelligent cubes to optimize performance for dashboards
• Improved the performance of the reports by using different VLDB settings as part of performance tuning.
• Assisted in code Optimization and Query Tuning to improve performance of Dashboard.
• Created MicroStrategy Mobile dashboards that enabled field reporting

Environment: MicroStrategy 9.4.1/9.4/9.3.1 (Architect, Desktop, Web, Administrator, Distribution Services), DataStage, Netezza, Oracle 11g

Confidential, Louisville, KY

Microstrategy Architect

Responsibilities:

• Worked with Data Warehouse Architect in the development of the dimensional and logical data models.
• Involved in logical and physical database schema design, SQL tuning
• Involved in preparing MicroStrategy development estimation for schema and application objects.
• Architected full Microstrategy projects by building Facts, Attributes, Metrics, Prompts, Filters, Consolidations, Derived Elements and Icubes
• Created store reports that supported daily reporting for around 6500 stores in the US. Used aggregate tables, Intelligent cube to improve performance
• Created and redesigned metrics and aggregates according to the data changes.
• Designed dynamic Dashboards using MicroStrategy Report services according to support field reporting.
• Customized new and existing reports, Documents and deployed them to MicroStrategy web.
• Created reporting templates and dashboard templates to compile with mobile application reporting needs.
• Involved in complete SDLC of new enhancements and source releases from gathering requirements through creating reports.
• Worked with ETL team and Design team to understand the schema and warehouse changes for new releases and come up with design solutions.

Environment: MicroStrategy 9.0.2/9.3, Netezza, MS Office 2010, Windows XP Professional, Vista Professional

Confidential

MicroStrategy Consultant

Responsibilities:

• Extensively worked and developed Metrics, filters and prompts to enable decision-makers to choose the condition for reports as well as to view reports in different perspectives.
• Generated status reports after performing thorough research in order to discuss the issues related to Warehouse tables, Zeroes/Nulls, missing columns and naming conventions etc.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and Zeroes in data.
• Used project merge wizard and user merge wizard to merge projects and merging users & groups in Object Manager.
• Created Transformations (table based, formula based) for using in comparative reports like sales of various pharmaceutical products this year to last year (year to date and month to date).
• Worked with MicroStrategy Architect to build Attributes, Facts and Dimensions and developed perfect logical models for reporting environment

Environment: MicroStrategy 9.0.1, Vertica, Teradata, Oracle 11g, MS Office 2010, Windows XP Professional

Confidential, Richmond, VA

MicroStrategy Consultant

Responsibilities:

• Helped gather business requirements for dashboard design.
• Created facts, dimensions, and attributes using MicroStrategy Architect.
• Created metrics, filters, and templates for the reports.
• Designed Dashboards in 8.1 using the new selectors radio buttons, check boxes, panels, slider and button bar etc summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Implemented Nested Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.