SUMMARY

• Over 7+ years of Experience in Software Development life - cycle and implementing in Data Warehouse, Business Intelligence, Client/Server Technologies and E-Commerce Applications for Financial, Insurance, Banking, and Production systems.
• 4+ years of experience in Business Systems and Business Requirements Analysis & Documentation especially in the Ecommerce, Pharmaceutical Industry, Financial Industry, Insurance and Telecommunications Industry
• 5+ years of Micro Strategy in Analysis, design and Implementation of BI applications using Micro Strategy 8i/7.i
• Involved in analysis, design, development and implementation of Business Intelligence applications using Micro Strategy
• Installing, Configuring of all Micro Strategy activities including Micro Strategy Desktop, Administrator, Intelligence Server, Web, SDK and Micro Strategy Narrowcast Server on NT Servers and mapping to Client machines.
• Extensive Data warehousing experience in Data Extraction, Data Integration, and Data Mining for Decision Support System using ETL and OLAP tools.
• Strong knowledge of data warehouse concepts, design techniques such as Star, Snow Flake schemas, multi-dimensional data model analysis using OLAP, Physical and Logical data modeling.
• Experienced in creation of Fact and Dimension tables.
• Extensive experience working with End Users, Business System Analysts in understanding their requirements.
• Intensive experience and exposure to all aspects of Micro Strategy application such as Administration, Architecting and Development using modules comprising Administrator, Architect, Desktop, Enterprise Manager, Intelligence server and Narrowcast Server.
• Experienced in Full Life Cycle (SDLC) development of software applications. Good knowledge of understanding business logic and converting functional requirements to technical requirements. Thorough knowledge of multiple RDBMS & ODBC concepts, exceptional analytical and problem solving skills. Team Player with the ability to communicate effectively at all levels of the design through production process.
• Ability to work effectively while working as a team member as well as individually. Excellent communication and interpersonal skills.

TECHNICAL SKILLS

Operating System: DOS, UNIX (HP-Unix, Solaris 2.7/2.8, Linux 7.1), Windows 98/NT/2000/XP, Mac OSX .

ETL Tools: Informatica 7.1, AbInitio, BO Data Integrator 11.5.3.

Micro Strategy Suite: Micro Strategy Desktop, Micro Strategy Architect, Miscrostrategy Intelligence Server, Micro Strategy Web, Micro Strategy Narrowcast Server, Micro Strategy Administrator (Object Manager, Command Manager), Micro Strategy Enterprise Manager, Micro Strategy Office, Micro Strategy Report Services.

Other BI Tools: Crystal Reports XI / 10 / 9 / 8.5, Crystal Enterprise XI/10 /9 / 8.5, Crystal SDK, SSIS, SSRS.

Data Modeling: Erwin 3.5/4.0, Microsoft Visio.

Languages: Java, C++, C, C#, SQL, PL/SQL

Databases: Oracle 7.x/8i/9i/10g, MS-Access, SQLServer 2005, DB2, Sybase, Teradata, Netezza.

GUI Tools: VB.NET, ASP.NET, Visual Basics 5.x/6.0,Developer 2000 (Forms 4.5/5.0/6.0/9 i AS, Reports 2.5/3.0), MS word, MS Excel.

Rational Tools: Clear Case, Clear Quest, and Requisite Pro.

PROFESSIONAL EXPERIENCE

Confidential, Swift water, PA

Sr. Micro Strategy Consultant

Responsibilities:

• Used Micro Strategy 9.0.1, 9.0.2 M for the development.
• Worked with the senior management and the user in understanding the requirements.
• Worked with the ETL team in designing the data model.
• Created the DSN for the metadata and the data warehouse, Used DB2 as the database.
• Created Micro strategy schema and public objects for the generation of reports and used Micro strategy Desktop to build and generate the advanced reports in grid, graph mode.
• Presented a mockup of the dashboard to the high level management, created a complex flash dashboard based on the feedback from the users.
• Created Complex Transformations, Custom Groups and Complex Filters using pass through Expressions
• Created report builder for adhoc reporting.
• Used narrowcast services in creating the alerts to the end user.
• Worked with the Micro Strategy Mobile team in converting the dashboard to the IPAD, IPHONE version.
• Involved in giving demos and presentation to the end user.

Environment: Micro Strategy 9.0.1, 9.0.2 M,MicroStrategy Desktop 9.0.1, Web 9.0.1, Micro Strategy Narrowcast, Abnitio, Windows xp, Mac OSX, DB2, Rational Clear case .

Confidential, Hoffman Estates, IL

Sr.MicroStrategy Consultant

Responsibilities:

• Worked on Micro Strategy 9.0.1. for report development.
• Worked with the Client in understanding the business requirements.
• Created around 40 grid report and three dashboards for the top level management, these dashboards are used in the survey and analysis of the products at the store level.
• Used Advanced Prompts, Non-Aggregately Metrics, Conditional, Transformation metrics and Level Metrics for creating complex 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).
• Used Micro Strategy Narrowcast server for the distribution of the report at the store level.
• Create both Static subscription and dynamic subscription set for the narrowcast server.
• Created Complex custom Groups, Filters and Prompts for creating the grid reports.
• Created the requirements Documentation for the Micro Strategy projects and also documented the Micro Strategy Environment.
• Involved in giving Demos to the end user.

Environment: Micro Strategy Desktop 9.0.1, Micro Strategy Intelligence Server 9.0.1, Micro Strategy Web 9.0.1, MicroStrategy Narrowcast Server 9.0.1, Netezza 4.6, MS Office, Excel Macros, and Windows XP .

Confidential, Round Rock, TX

Micro Strategy Consultant

Responsibilities:

• Worked on the Micro Strategy 9.0 for the report development.
• Worked with the Business analyst from the payroll department on the report requirements and the business needs.
• Designed various templates for the report services document.
• Created both schema objects and the application objects.
• Used Custom free form SQL for creating the reports.
• Created various grid reports for the salesmen
• Created complex report filters, security filters and prompts for the reports.
• Created the logical tables to make the data model flexible as per the report requirements, which reduced the time of the report development.
• Created the report services documents for the top level management.
• Used complex report filters and also the view filters to work on the date dimension of the users.
• Trouble shooted the reports for the variations of data and by working on the definition of the report objects.
• Involved in testing the complex filters, prompts and metrics.
• Helped administrator in the daily migration to the SIT and Production environments.
• Used VLDB properties to optimize the SQL generation of the Micro Strategy reports for performance.
• Involved in giving Demos/Presentations to end-users and training other developers in Micro Strategy Desktop and Web.

Environment: Micro Strategy Desktop 9.0, Intelligence Server9.0, Web Professional, Administration, Oracle 10g, MS SQL Server 2005, Windows XP, Windows 2003 Server, Windows SharePoint, TOAD, Business Objects XI R2 .

Confidential, Charlotte, NC

Micro Strategy Consultant

Responsibilities:

• Understood the source system and interacted with users to get the elaborate report requirements and to gather business requirements.
• Installed Micro Strategy web universal, Micro Strategy Intelligent server in AIX environment.
• Created Metrics, Drill Maps, Filters, Templates, Hierarchies and Prompts to enable decision-makers to choose the condition for reports in Micro Strategy Desktop.
• Created Transformations (YTD, MTD, QTD) for comparative reports to measure and extrapolate campaign results in real-time of previous similar campaigns & similar target market.
• Created consolidations and custom groups for reporting summarized values.
• Created Reports in Micro Strategy Desktop and Web according the business requirements.
• Involved in creation of Dashboards for top level management to view overall business performance and find tremendous value in viewing timely, visually intuitive snapshots of strategic financial and operational data.
• Administered Narrowcast server, intelligent server, Web server on which Micro Strategy components were installed.
• Created Narrowcast server to deliver dashboards to more than 40 plus users.
• Performance testing is performed every month for the analysis of the business usage every month.
• Identified the Source Tables and Columns required to create the Micro Strategy Project, thereby achieving a Logical Data Modeling of the physical data warehouse in the Metadata Repository.
• Developed documentation for the objects and reports that are created.
• Worked with the team to troubleshoot any Reporting issues in the production environment.
• Involved in testing of Micro Strategy prompt, filter, template, reports, consolidations, and custom group objects in an enterprise data warehouse team environment.

Environment: Micro Strategy Desktop 8.1.1, Intelligence Server8.1.1, Narrowcast Server 8.1.1,MicroStrategy SDK, Web Professional, Administration,AIX, Teradata V2R6,XML,XSL,Oracle 10g, MS SQL Server 2005, Windows 2003 Server.

Confidential, Reston, VA

Micro Strategy Consultant

Responsibilities:

• Involved in collecting the business requirements from users by understanding the Source System (OLTP) and interacting with the users.
• Created Complex Metrics forcing Dimensionality and Conditionality embedded with prompts.
• Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters using pass through Expressions.
• Created Reports using complex Filters and Compound Metrics, Prompts, relationship filters, Transformation metrics and Metric Dimensionality.
• Created reusable Transformation objects that enabled time-series analysis for comparative analysis.
• Created views, triggers, stored procedures in SQL Server.
• Tuning of SQL Scripts and also was involved in Data cleansing.
• Took regular back-ups of the Production Metadata in SQL Server Database.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for oracle10g and SQL hints.
• Analyzed reusables actuate code to help convert the reports into Micro Strategy canned reports.
• Converted and re-designed existing Actuate Enterprise Reporting into Micro Strategy Environment.

Environment: Micro strategy Desktop 8.1.1, Micro strategy Intelligence Server 8.1.1, Micro strategy Web 8.1.1, Actuate e.Report Designer Professional 7 SP2, Oracle10g, MS SQL Server, MS Office, Excel Macros, and Windows 2000.

Confidential, Grand Rapids, MI

Jr.MicroStrategy Developer

Responsibilities:

• Create a single repository with consistent, accurate and timely data and a single set of business rules.
• Provide a more scalable architecture giving users a common, scalable platform and reporting tools that provide growth and flexibility.
• Reconcile purchase data daily so customers could run reports daily instead of at month end.
• Understanding of source system and interacting with users to get the report requirements.
• Enhance operational excellence by significantly reducing the monthly financial close process to three business days.
• Worked with the source systems to have a clear understanding of the data flow and interacted with the users to collect the business requirements.
• Created the requirements Documentation for the Micro Strategy projects and also documented the Micro Strategy Environment.
• Designed the Micro Strategy Architectural Documents for the Projects.
• Created Reports using complex Filters and Compound Metrics and Prompts.
• Used Advanced Prompts, Non-Aggregatable Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Used Customer, Product, Payment, Geographic and Time dimensions and generated reports like forecasting.
• Created several base formulas (mathematical expressions) using existing facts in Micro Strategy Agent that can be re-used to build any number of metrics.
• Customized reports, Documents and deployed them to Micro Strategy web.
• Modified the ASP code in the Micro Strategy WEB pages for Customization purposes.
• Database design employed highly complex data transformations including Slowly Changing Dimensions and a series of Stored Procedures, which made performance tuning and efficient mapping highly critical.
• Generated advanced reports in grid, graph and SQL mode, consisting of data analysis by combining a template with filters, using Micro Strategy Desktop and Web.
• Created Data Mart Tables using Complex Filters and Compound Metrics.
• Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters.
• 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).
• Administrating Micro Strategy Intelligence Server and Web.
• Used Informatica 5.0 as an ETL tool to extract data from source systems to Target system.
• Have good experience in Repositories, like maintaining versions of repositories, managing users and upgrading repositories.
• Have good experience in understanding & creating source and target definitions, Mappings, Transformations and working with Sessions.

Environment: Micro Strategy 7.2.3- Desktop, Administrator, Intelligence Server, Web, Micro Strategy Object Manager, Informatica 5.0, DB2, Windows 2000.