Himanshu Kumar
klk9ch@r.postjobfree.com
Summary:
• Over 7+ Yrs of extensive work experience in the field of Information Technology implementing Data warehousing, Decision Support Systems.
• Over 5+ years of extensive experience in using MicroStrategy Suite (Architect, Intelligence Server, Desktop, Web).
• Extensively worked in creating MicroStrategy reports, dashboards and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups).
• Proficient in designing reports through MicroStrategy Desktop, with optimal usage of key features like Advanced Filters, Prompts, Custom Groups, and Consolidations and extensively worked on Parent-Child relation for attributes.
• Created various Schema objects with MicroStrategy Desktop like simple and Compound Metrics, Hierarchies, etc.
• Extensive experience in using MicroStrategy Report Services for developing Corporate Dashboards and Scorecards, reflecting business performance.
• Proficient in setting up the Metadata Repository, creating user groups, security filters, roles and privileges.
• Knowledge of Data Modeling (Dimensional and Relational) concepts including Star Schema and Snowflake Schema modeling, Fact and Dimension tables and ETL.
• Extensively worked in developing DW applications using MicroStrategy Desktop, Web, Intelligence server.
• Very good experience in interacting with the clients and understanding business application, business data flow and data relations from them.
• Expertise in working with very large databases like Oracle, SQL Server, with MicroStrategy.
• Extensive work experience with Ad hoc reporting and standard reporting environment.
• Created complex Reports in MicroStrategy including data mart reports, etc.
• Exceptional analytical and problem solving skills. Self motivated team player with the ability to communicate effectively at all levels of the development process.
Technical Skills:
Business Intelligence
MicroStrategy 9.x/8.x/7.x (MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Agent, MicroStrategy Web, MicroStrategy Intelligence Server, , Microsoft OLAP Manager, Microsoft SQL Server Analysis Services, Microsoft Excel.
ETL DataStage 8.x/7.x/6.x,Informatica 7.x
Databases Oracle 10g/9i/8.x/7.x, DB2 , SQL Server 2000, Teradata, Sybase, MS Access 2000/97/7.0
Operating Systems Unix (Sun-Solaris, HP-UX), AIX 5.0, Windows 95/98/NT/2000/XP
Others HTML 4.0, DHTML, XML,LDAP, VB Script, JavaScript, VBA, MS Office, Macromedia Dreamweaver, Macromedia Fireworks, Macromedia Flash, Microsoft FrontPage, NS2, OPNET
Education:
Bachelor of Information Technology & Management, India.
Charming Shoppes Inc, Bensalem, PA Sep ’09 - Till Date
MicroStrategy Consultant
Responsibilities:
• Involved in Coordinating with business users to gather the new requirements and to solve the existing issues.
• Developed Metrics, filters, prompts to achieve the functionality of consistent reports for the Web.
• Generated MicroStrategy Reporting concepts by creating attributes, facts, Attribute Relationships and Hierarchies using MicroStrategy Architect.
• Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters.
• Created various reports, Data sets and then used those for building Dash Boards.
• Tuned the VLDB properties to enhance the performance of the reports at project level and report level.
• Involved in comparing the reports and Data marts across different environments and testing them using the MicroStrategy Integrity Manager.
• Involved in the design/development life cycle including gathering requirements, user interaction and report design and development.
• Created facts, dimensions, and attributes using Microstrategy Architect.
• Created metrics, filters, and templates for the reports.
• Developing Dashboards and scorecards reports in Enterprise manager for usage and capacity purpose.
• Created Derived metrics, Compound metrics and Filter in a metric for very complex reports.
• Created Consolidations, Custom Groups and Prompts for the reports.
• Created Transformations (table based, formula based) for using in comparative reports like sales this year to last year (year to date and month to date).
• Worked on the performance tuning of the MicroStrategy reports
• Involved in troubleshooting MicroStrategy Web Reports, and optimizing the SQL using the VLDB properties
Environment: MicroStrategy 9.x/8.0.2 (Desktop, Architect), Oracle 10g/9i, Dashboards, Windows XP/2000.
AstraZeneca Pharmaceuticals, Wilmington, DE Jan ‘08 - Sept ‘09
Microstrategy Consultant
Responsibilities
• Generated and implemented MicroStrategy reports by creating projects, Custom Groups, attributes, hierarchies, metrics, filters, and templates.
• Used the Object Manager to move the objects from Development to Production Environment in MicroStrategy.
• Generated and implemented MicroStrategy Schema Objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect.
• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidation and custom group objects in an enterprise data warehouse team environment.
• Designed Prompts and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Assisted in developing logical models, building hierarchies, attributes and facts, extracting tables from warehouse.
• Developed dashboards for quick and easy monitoring by higher level management.
• Managed projects through entire systems development life cycle, including creating timely and thorough status reports and leading status meetings..
• Assisted Business System Analysts in user training and creation of accurate documentation.
• Involved in troubleshooting MicroStrategy Web Reports, and optimizing the SQL using the VLDB properties.
• Worked with end users for one time data requests, issues with creation of adhoc reports etc.
• Developed Various Simple Metrics, Compound Metrics, Filters, Drill maps, Templates, Custom Groups, Consolidations.
Environment: MicroStrategy 8.0 (Desktop, Architect), Dashboards, Oracle 8i, Windows NT/2000/XP, Object Manager
Anthem Insurance INC, Cleveland, OH Mar ‘07 - Jan ‘08 MicroStrategy Developer
Responsibilities:
• Created and modified MicroStrategy Project Sources and Projects using MicroStrategy Architect, MicroStrategy Objects and reports using MicroStrategy Desktop in 2-tier/3-tier environment.
• Involved in the Architecture of the projects and created all the necessary schema, application and configuration objects.
• Coordinated with the DBA for Table creation, user creation and other administrative activities.
• Created Attributes, Facts, Custom groups, Prompts, Hierarchies, Compound metrics, advanced qualification filters, custom expression filters and object prompts according to business needs.
• Involved in designing custom hierarchies, security filter, views, and drill maps in MicroStrategy that meet the business specifications.
• Involved in MicroStrategy Intelligence Server performance monitoring and managing cache.
• Used to move the objects from one environment to other by using objects manager.
• Involved in quality assurance of developed reports.
• Developed various Prompts supporting end users to interactively choose different filtering criteria.
• All the reports & metrics have been formatted as per users request like displaying attribute display forms, subtotals, sorting, etc.
• Created Advanced Reports in grid mode and graph mode using Microstrategy Desktop.
• Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Generated custom groups and included consolidations in order to group attributes and customized the report.
• Developed Transformations to generate reports of type Sales this period to Sales this period Last Year and so on.
Environment: MicroStrategy 7.5/8.0, MicroStrategy Desktop, Intelligence Server, Architect, Web, OLAP Services, Dashboards, Oracle8i, SQL, PL/SQL
Nordea bank, NY Jul ‘05 – Mar ’07
MicroStrategy Developer
Responsibilities:
Created MicroStrategy Schema Objects and Application Objects such as Metrics, Filters, Filter Prompts, Object Prompts, Templates, and Reports for the generation of ad-hoc reports.
Gone through various levels of Dimensionalities to execute the reports with different result sets.
Created Transformations using transformations by tables for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.
Used Project Creation Wizard for creating Facts and Attributes.
Created Complex Metrics forcing Dimensionality and Conditionality.
Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters.
Created Transformations (table based, formula based) for using in comparative reports like sales this year to sales last year.
Created reports for sales and marketing with the drill down methodology in all options.
Developed 3-Tier Architecture involving MicroStrategy Intelligence Server where Projects Sources were connected to the Data warehouse and Metadata Repository.
Based on user requirements, Created interactive dashboard Reports to view personalized reports
Tested all the reports by running queries against the warehouse-using Queryman. Also compared those queries with the MicroStrategy SQL engine generated queries.
Reduced the time taken for the reports to run by taking advantages of VLDB properties.
Generated reports using Advanced Metrics, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
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.
Environment: MicroStrategy Desktop 7.2, MicroStrategy Web, MicroStrategy Intelligence Server, Dashboards, Oracle, MS Access 2003, Windows NT/2000.
Venus Business Solutions Pvt Ltd, Hyderabad Jul '03 – Jul ‘05
Database Consultant
Responsibilities:
• Designed screens and reports layouts
• Created screens, workflow and taken care of validations
• Online help documents were written using HTML, which are informative to user while using this application
• Included features using layers, Dynamic data stored in MS Access Database
• Member of a team that developed a complete user interactive web site with Administrative options to control the site
• Total Business Analysis of the application and implement using Oracle database and Visual Basic 5.0
• Developed the ActiveX component for the complex validation and the database query
• Used PL/SQL to write the Stored Procedures /triggers and data validation routines
Environment: Windows NT 4.0, Oracle 7.3,HTML.