SUMMARY

• 7+ years of experience in Data Warehouse and MicroStrategy Specialist in E Commerce and other verticals.
• Expertise in building projects and creating reports using MicroStrategy Business Intelligence Product Suite such as MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Mobile, MicroStrategy Intelligence Server, MicroStrategy Architect.
• Expertise in Dimensional data modeling, identification of fact and dimension tables,Denormalization, Normalization, Star schema modeling, Snow - Flake modeling, Physical and Logical data Modeling.
• Extensively worked on designing schema and creating Facts, Attributes, Hierarchies and Transformations.
• Extensively worked on development of public objects such metrics (simple, compound, derived and level metrics), prompts, filters, reports and dashboards.
• Worked on VLDB Properties such as metric join type, evaluation ordering etc.,
• Extensive work experience with Ad hoc reporting, report testing, report tuning, scheduling reporting delivery and subscriptions.
• Worked on building widget based dashboards for Mobile deployment on iPad.
• Experience installing and configuring of MicroStrategy Product Suite including MicroStrategy Intelligent Server, Web Server, Mobile Server and Desktop on Windows servers.
• Performed various MSTR Administrator duties including creating users, groups, security roles and assigning security filters to various users/groups. Also created schedules and email subscriptions.
• Performed Report tuning and improved performance by tweaking the sql. Also improved user experience by enabling caching and creating Intelligence Cubes where applicable.
• Worked on requirement gathering and participated in the development of data model.
• Well accustomed to quickly master new concepts coupled with excellent analytical and interpersonal skills.
• Capable of working as an individual as well as a team-player in assisting the Business System Analysts while handling technical solutions.
• Good experience in various databases like SQL Server, Oracle, Netezza and Teradata.
• Experience working on Windows (2003/2008) OS and Linux OS (CentOS and Redhat).
• Worked in Agile and Waterfall models of software development.
• Excellent SQL skills.

TECHNICAL SKILLS

MicroStrategy Suite: MicroStrategy 10x/9x/8x, Desktop, Architect, Web Server, Mobile Server, Intelligence Server, Narrowcast Server

ETL Tool: Informatica (Designer, Repository Manager, Server Manager), SQL Server Integration Services (2005), Data Transformation Services, Informatica (Designer, Repository Manager, Server Manager)

Data Warehousing: Data marts, OLAP, Denormalization, Normalization, Dimensional Modeling, Facts, Dimensions, Star schema, Snow Flake schema, Slowly changing dimensions

Database Systems: Teradata, MS SQL Server, Oracle9i/8i/8.0, MS Access

Data Modeling tools: Erwin, Microsoft Visio.

Programming Languages: Teradata SQL, T-SQL, PL/SQL, XML, HTML, DHTML, Javascript, UNIX Shell Scripting

Servers: Apache, Redhat Linux, CentOS, Microsoft IIS, Windows 2003/2008

Other Tools: SQL* Plus, SQL Loader, PL/SQL Developer, TOAD, MS-Office Suite, SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

MicroStrategy Developer

Environment: SQL Server (2014), MicroStrategy 10.4.x(I-Server, Web Server, Mobile Server), CentOS Linux, Windows 2013 Server, MS Excel, Windows 7, Impala Hadoop, Snowflake.

Responsibilities:

• Primary responsibility includes migrating projects from Impala DB to Snowflake DB.
• Modify the existing Configuration Objects like DB instances, ODBC DSN for various projects to re-point the projects to Snowflake DB and perform smoke testing.
• Modifying the existing Pass Thru expressions of Schema Objects and Application Objects to supporting migrating the project from Impala to Snowflake.
• Update the FreeForm SQL reports to support the DB migration.
• Update all the existing Logical views to support the DB migration.

Confidential

MicroStrategy Sr. Developer

Environment: Teradata, MicroStrategy 10.4(I-Server, Web Server, Mobile Server), Linux, Windows 2008 Server, MS Excel, Windows 10.

Responsibilities:

• Created Dashboards with self-explaining pie-charts and graphs for the end-users to understand the sales-trends of their product.
• Worked extensively as MicroStrategy Report Developer and Architect to build various Schema Objects and Application objects to support project requirements.
• Greatly enhanced the existing reports to include Object and Element prompts along with a summary report.
• Created simple Freeform SQL reports which were used by the OLTP team to analyze the Production data instantly.
• Converted the requirements being gathered from the Business Analysts to channel them into proper Technical Requirements for the IT Team and created some Technical Documents along the way.
• Worked on VLDB properties such as Metric join type and Evaluation ordering to implement smart metric calculation.
• Developed reports with drilling up, down, and across various dimensions and also drill to a template.
• Extensively used pass-thru functions.
• Created the Test Cases for the UAT to test and approve the reports prior to each release developed various transformations to analyze existing metrics at different timelines.
• Involved in bug fixing and migration of the various MicroStrategy Objects to Testing and Production environments.
• Created intelligent cubes, published it and defined refresh strategies.

Confidential

MicroStrategy Developer

Environment: Netezza, MicroStrategy 9.x/10.x(I-Server, Web Server, Mobile Server), Linux, Windows 2008 Server, MS Excel, Windows 7.

Responsibilities:

• Involved in data model design review with various stakeholders of the project.
• Participated in dashboard design reviews with business customers.
• Designed and developed dashboard wireframes based on the business user inputs.
• Architected schema objects like Attributes, Facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Generated reports using advanced metrics, filters, prompts and custom groups.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards)
• Designed and created multi-panel visual insight dashboard.
• Created intelligent cube and published it.
• Worked on VLDB properties such as Metric join type and Evaluation ordering to implement smart metric calculation.
• Done performance tuning on reports by replacing apply simple function with MicroStrategy dynamic dates.
• Involved in unit and integration testing of the developed reports and dashboards in Dev and UAT level.
• Provided support for all the components of the project for business users.
• Involved in debugging, bug fixing and promotion of the objects to Testing and Production environments.

Confidential

MicroStrategy Developer

Environment: SQL Server (2008), Netezza, MicroStrategy 9x(I-Server, Web Server, Mobile Server), CentOS Linux, Windows 2008 Server, MS Excel, Windows 7, Hadoop.

Responsibilities:

• Designed and developed dashboard wireframes based on the business user inputs.
• Architected schema objects like Attributes, Facts by using MicroStrategy Architect of the MicroStrategy BI Suite based on the data model.
• Extensively worked on Desktop to create Applications Objects like Reports and Dashboards (Documents & Scorecards), metrics, filters, prompts and custom groups.
• Designed and created multi-panel visual insight dashboard.
• Designed, built and deployed dashboards for mobile viewing on iPad.
• Created intelligent cube, published it.
• Worked on VLDB properties such as Metric join type and Evaluation ordering to implement smart metric calculation.
• Done performance tuning on reports by replacing apply simple function with MicroStrategy dynamic dates.
• Migration of objects from one environment to another using object manager.
• Provided support for all the components of the project for business users.
• Involved in debugging, bug fixing and promotion of the objects to Testing and Production environments.
• Monitored and modified the properties of the objects using Command Manager
• Involved in the understanding and approval of the suggested Star Schema/Snow-Flaked schema
• Carried out the Object Migrations to move the reports and the relevant objects between the Development, the Test and the Production environments
• Created and modified the ODBC connections to change the Database instances for different projects