SUMMARY

• Over 6 years of IT experience with main focus on development, testing and implementing Database and Data warehousing solutions.
• 5+ years of experience using MSTR product suite.
• Excellent understanding and experience in all phases of SDLC and various methodologies like Agile and Waterfall.
• Strong knowledge of data warehouse concepts, design techniques such asStar, Snow Flake schemas, multi - dimensional data model analysis using OLAP, Physical and Logical data modeling.
• Worked extensively onSQL Server, Oracle, Teradata, IBM DB2 and NetezzaDatabase Environments.
• Experienced in understanding and writing complex SQL queries.
• Have working knowledge of the Extraction Transformation and Loading (ETL)process.
• Extensive experience and exposure to all aspects of Microstrategy application such as Administration, Architecting and Development.
• Implementedvarious Microstrategy Objectssuch as attributes, facts, hierarchies and complex metrics that conform to the dimensional and De-normalized data models.
• Strong Knowledge ofData Extraction, Data Integration, and Data Mining for Decision Support System using ETL and OLAP tools.
• Experienced in using database & logical views.
• Experience inData Modelingand BI implementation withDatabase tuning.
• Expertise in Installing and Configuring MicroStrategy product suite.
• Worked closely with the business toGather, Review, ValidateandDocumenttheBusiness Requirements
• Sound knowledge ofMSTR Architecture.
• Experienced on various domains like Healthcare, Retail Industry, Pharmaceutical Industry, Financial Industry, Insurance and Telecommunications Industry.
• Strong understanding ofData warehouse concepts, dimensional modelingusing various Schemas andMulti-Dimensional Modelwith respect to query and analysis requirements.
• Quick learner,ability to work in groups or alone, ability to work on tight schedules.
• Team playerwith good interpersonal and communication skills and the ability to work in a team environment.

TECHNICAL SKILLS

OLAP/ BI/ Reporting Tools: MicroStrategy Developer 9.4.1,Desktop 9.3.1/9.2.1/9.0.2/9.0.1/8. x.x/7.x, Microstrategy Architect, Microstrategy Narrowcast Server, Microstrategy OLAP Services, Microstrategy Object Manager, MicroStrategy Web, Microstrategy Mobile.

ETL Tools: Informatica, SSIS, Data Stage

Databases: Oracle 11g/10g/9i/8i/8.0/7.0, MS SQL Server 2012/2008 R2, Teradata, DB2, and MS Access.

Data Modeling: Erwin, Microsoft Visio, MySQL

OS: Windows XP/NT/ 2007/2003/2000/98 , Unix/Linux

Utilities: Toad, SQL Assistant

Languages: Java, C++, C, T-SQL, PL/SQL, HTML, DHTML, MS Office

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

MicroStrategy BI Developer

Responsibilities:

• Interacted with the Business Users and Business Analyst to understand the requirements and translate them in to technical specifications.
• Attended meetings with the data modeling team for theLogicalandPhysical modeldesign.
• Involved in creating theAggregate tablesconsidering both the Technical Feasibility and Business Feasibility to improve reports performance.
• Designed and created various schema objects like Facts, Attributes and Hierarchies in both Developer/Desktop and Architect.
• Created multiple public objects like Grids, Metrics, Consolidations, prompts and filters.
• Extensively used createdHierarchical prompts & object prompts.
• Restricted access to users by implementing Security Filters & Security Roles.
• Extensively used Enterprise Manager to monitor the Environment by running various reports.
• Used Object Manager to migrate objects between various environments.
• Used Integrity Manager during the upgrade from 9.3.0 to 9.4.1.
• Used theVLDBproperties forperformance tuningandSQL optimization.
• Created Transformations like Last Month to This Month and also created the required transformation tables.
• Worked withDBA team to improve the report performance.
• Performed the ETL, UAT and System tests on the warehouse tables and the reports.
• Involved in the End User training.

Environment: MicroStrategy 9.4.1/9.3.0 (Desktop/Developer, Administrator, Architect, Intelligence Server, Web, Agent, Object Manager, Enterprise Manager, Integrity Manager), Informatica, Oracle, Teradata, SQL Server, Linux.

Confidential, Minneapolis, MN

MicroStrategy Developer

Responsibilities:

• Involved in the complete Life cycle of the Project, starting from end user meetings to obtain the business requirements for creating reports, data analysis and MicroStrategy implementation.
• Worked closely with ETL Team to assist them in resolving the data issues.
• Involved in Data Modeling and Data Warehousing Using Multi-Dimensional Model, Star and Snow Flake Schemas.
• Created logical data models, recognize source tables and columns, to build MicroStrategy schema objects including Attributes, Facts, Hierarchies and Relationships.
• Extensively worked in developing Reports with Metrics, Level metrics, Compound metrics, Filters, Custom Groups and Consolidations for complex reports.
• Developed Auto Prompt Filters that gave user a choice of different filtering criteria each time they run the filter
• Used Thresholds to format the Reports with different colors and values for Business analysis.
• Created Complex Filters such as Relationship Filters, Dynamic Filters, Embedded Filters, Custom Expression Filters and Joint Element List Filters.
• Modified various VLDB settings at the report level to tweak MSTR report SQL to improve performance and also to achieve various reporting requirements.
• Created advanced Links and Drill Maps (Drill UP, Drill Down, Drill to Template, Drill Across, Link to Report) depending on hierarchy and user requirement to drill the reports on different levels.
• Resolved Many to Many relationships between the attributes and identified the one to one and one to many relationships between the attributes.
• Created mockup versions of dashboards and presented to the stake holders to make sure it was effective on usability perspective.
• Created multilayered Dynamic Enterprise Dashboards using panels, panel selectors, widgets and grids using multiple datasets.
• Used different types of widgets and controls like Micro charts, Gauges, Time Series Slider, Fish Eye and Radio Buttons for the dashboards in MicroStrategy.
• Used Narrowcast Server to schedule reports and documents.
• Used VLDB properties to enhance the performance of the reports at project level as well as report level.
• Identify data issues and need for data cleanup in the various source system databases. Work with the source system support team to correct data irregularities.

Environment: MicroStrategy 9.2.1 (Architect, Agent, Intelligent Server, Web, Object Manager, Desktop, Narrowcast Server), SSIS, SQL Server 2008 R2, Windows.

Confidential, Phoenix, AZ

MicroStrategy Consultant

Responsibilities:

• Worked closely with ETL team and Business Analyst and performed fit gap analysis and involved in data modeling meetings.
• Developed the logical and physical data models, created data definition language statements and worked with database administrators to transition these models to database administrators for successful physical implementation.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Created ad-hoc reports in grid and graph mode consisting of data analysis by combining a template with filters using Microstrategy Desktop and web.
• Created reports using complex Filters, Compound Metrics and Advanced Prompts.
• Created transformations (Table Based and Formula Based) for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.
• Developed different Dynamic Dashboards and Scorecards and using Microstrategy best practices as recommended by visual design experts, using selectors, widgets and multi-panels.
• Have used several new controls for Dash boards like time series slider, radio buttons, RSS widgets, Drop down menus, Panels for the flash version.
• Installed and configured Narrowcast server to deliver several reports daily, weekly and monthly reports as required by users.
• Created Subscription Sets, Schedules and Services in Narrowcast application to distribute reports.
• Tested all the reports by running queries against the warehouse. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Supported business users with technical requirements and issues with tool.

Environment: Microstrategy 9.0.2/9.2.1 , Desktop, Microstrategy Intelligence Server, Narrowcast Server, Report Editor, Configuration Wizard, Warehouse Catalog, Oracle 10g, Teradata, Windows XP, TOAD 8.6, SQL assistant, Microsoft Visio.

Confidential, Roanoke, VA

MicroStrategy Developer

Responsibilities:

• Responsible to create Project Source in 2 tier and 3 tier.
• Created database instances and configured projects to use the database instance.
• Responsible to monitor and kill the long running jobs.
• Maintained User groups and Users by using Security filters and security role.
• Responsible to setup Enterprise Manager project and configure the data load process.
• Maintained licenses using License Manager.
• Was responsible for setting up the Narrowcast Server environment by configuring Execution Engine and Distribution Manager.
• Was responsible to work with DBA to improve the performance of the reports.

Environment: MicroStrategy 9.0.1/9.0.2 (Administrator, Architect, Desktop, Narrowcast Server, Enterprise Manager), Oracle 10g, Windows Server 2003.

Confidential

Database Developer

Responsibilities:

• Involved in information gathering from end user and analyzing the data to developed ER diagram, data dictionaries, and flow charts.
• Created number of Normalized database tables with different constraints to maintain integrity.
• Triggers were implemented on the tables to maintain validity check on the data.
• Worked on different aggregate functions and scalar functions.
• Involved in the logical and physical design of the database tables.
• Tested and implemented the system and Trained end users.
• Contact with user groups for development, mentoring, training, support and performance monitoring.
• Constructed several forms in Visual Basic to make it user friendly for the users to add, delete or update information.
• Monitoring disk space and database space usage to ensure proper functioning of production databases.

Environment: Visual Basic 6, Oracle 9i and SQL Server 2005.