Sujala

iqjfnz@r.postjobfree.com

248-***-*********

Summary

 Over 7 years of Business Data warehousing experience in Data Modeling, Design, and Development mainly focusing on Implementing Business Intelligence.

 Proficient in Data Modeling using ER Model and Multidimensional Model, Good knowledge in Star Schema and Snowflake Schema.

 Experience in Object oriented analysis and design in Rational Rose, MS VISIO, and Erwin.

 Over 5 years of Experience in MicroStrategy tool Suite (Intelligence Server, Administrator, Architect, Agent, MDX Adapter/OLAP Provider, Web, and Narrowcast Server).

 Expert in Architecture like creating Schema objects with MicroStrategy Desktop like simple and compound Facts and Attributes, Fact extensions, Hierarchies, Transformations.

 Extensively worked in creating and integrating MicroStrategy Reports and objects (Attributes, Filters, Metrics, Facts, and Prompts) with the data warehouse.

 Created Data Mart Reports using Complex Filters and Compound Metrics.

 Extensively worked on MicroStrategy Administration that includes Intelligence Server Administration, configuration of Memory settings, Performance Monitoring, Assigning Privileges and Job Monitoring etc.

 Configured Enterprise Manager, Object Manager.

 Good knowledge of MicroStrategy Web and Web Administration.

 Adept in Dash Boarding and Documents, worked extensively on panel stacks, widgets, and customized the web.

 Delivered reports in Desktop, Web, and via Narrowcast Server.

 Familiar with Data Management Systems – SQL Server, Oracle, Terra Data, DB2 UDB.

 Extensive back ground and knowledge of Stored Procedures, Triggers, Functions, and Transact SQL.

 Experience in Project Life Cycles and worked on Windows and UNIX platforms.

 Self-starter and quick learner with proven analytical, technical, and communication skills. Very resourceful in problem solving.

Technical Skills

Business intelligence: MicroStrategy 8.1/ 8.0.2/ 7.5/ 7i/7.x (MicroStrategy Desktop/Web, Intelligence Server, Narrowcast Server) Business Objects, Decision Point/Cast.

Databases: DB2 UDB, Oracle 10g/8i/7.x, Teradata V2R4/5/6,

SQL Server 2000/2005

Utilities: Toad 7.5.2/7.3, DBARTISAN 8.0.1, RapidSQL 7.3.3, Queryman

Languages: SQL, PL/SQL, Teradata SQL, T-SQL, C

ETL Tools: Informatica 8.0/7.1, SQL* Loader, SSIS

OS: UNIX, Window XP/NT/2000.

Professional Experience

Conway Freight, Ann Arbor, MI Jul 07 – Present

MicroStrategy Consultant

Responsibilities:

 Performed Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects.

 Created technical and functional specifications, including relational database design, using business and system use cases and Visio diagrams.

 Developed Flash Dashboards in 8.1 using Widgets and Selectors for summary level reporting.

 Performed Administration tasks, like User Creation, Session Handling, Creating Security roles, Analyzing Report performance, administered all aspects of web and intelligence server and Narrowcast Server.

 Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basics using MicroStrategy Desktop and MicroStrategy Web. Involved in troubleshooting MicroStrategy prompt, Filter, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment.

 Revision/update of MicroStrategy reports that change as a result of Engineering release related changes to the data warehouse structure and functionality.

 Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.

 Automated and improved existing manual processes. Optimizing the server platforms using Caching, Scheduling, and Clustering.

 Worked with back end Database Administrators to provide requirements for necessary back end tables.

 Extensively worked in both Ad-hoc and Standard Reporting Environments and Involved in creating Reports scalable to large volumes of data. Managed projects through entire Systems Development Life Cycle, including creating timely/thorough status reports and leading status meetings.

 Involved in various back end ETL development tasks and Production Support.

Environment: MicroStrategy 8.1/8.0.2 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Office), Teradata, Oracle 9i, VBA, ASP, XSL, HTML & DHTML

Darden Restaurants, Orlando, FL Jun 06 – Jun 07

MicroStrategy Consultant

Responsibilities:

 Worked as a MicroStrategy analyst for the Merchandising Users to support various reporting needs for the business.

 Thorough Understanding of the Business Requirements via Reports creation.

 Performed Requirement Analysis to collect various business measures and attributes to develop a reliable Star Schema and required Facts and Attributes.

 Created various Projects and maintained different Project Sources.

 Created Relationship Filters based on Existing Model.

 Developed various Simple and Compound Metrics, Attributes, Facts, Hierarchies, Prompts, Filters etc.

 Created Dashboard and Scorecards, using Report Services Documents.

 Developed various Adhoc and Canned Reports.

 Prepared Documentation and User Guides to identify the various Attributes, Metrics and Reports needed from Business.

 Set up Metadata Repository in MS Access to develop a prototype, during Phase 1.

 Moved the Prototype Metadata Repository from MS Access to Oracle 10g production Datamart during Phase2.

 Installed and Maintained Narrowcast Server and all other MicroStrategy Components.

 Created Services, Schedules and Subscription Sets in Narrowcast Server.

 Collected PRDs from various departments and created reports and dashboards as per business requirements and analyzed users feedback to make enhancements to the newly created reports and documents, from time to time.

 Installed MicroStrategy 8.0.1 and upgraded it to the latest 8.0.2 version.

 Used MicroStrategy Agent (Templates, Filters, and Metrics) to generate advanced reports in grid, graph, and SQL mode, consisting of data analysis by combining a template with filters.

 Used Microsoft Live Meeting to interact with MicroStrategy technical help after raising case with MicroStrategy, regarding the problems faced during the project.

 Used Auto Prompts filter feature to give the end-user a choice of different filtering criteria each time they run the report

Environment: MicroStrategy 8.0.1/8.0/7.5.2, MicroStrategy Desktop, MicroStrategy Report Services, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Informatica Power Center 6.0, IBM DB2, Oracle 10g,IBM i-Series, Windows XP/2000.

AstraZeneca Pharmaceuticals, Wilmington, DE Jun 05 – May 06

MicroStrategy Developer

Responsibilities:

 Created the Report Specification document and had it signed of, after suggesting some useful alterations.

 Involved in and provided solutions for complex Time Dimension related issues and analysis.

 Generated and implemented Microstrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using Microstrategy Desktop and Architect.

 Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.

 Created Complex filters with advanced qualifications involving the ‘Apply’ functions.

 Created Customized Hierarchy for Drill Maps.

 Used the Object Manager to move the objects from Development to Production Environment in Microstrategy.

 Worked along with Microstrategy Knowledge Base to troubleshoot some Report related issues.

 Played a key role in User Acceptance Testing of the reports.

Environment: MicroStrategy 7.5.2 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter) Oracle, SQL Server, Informatica, IBM DB2, ASP, XSL, HTML

Temple Inland, Austin, TX Aug 04 –May 05

MicroStrategy Developer

Responsibilities:

 Understanding the Historical Data and Analyzing User requirements. Worked with user groups and business users in defining their requirements.

 Developed Customized and Ad-hoc reports using Templates, Metrics, Filters, Auto Prompts, Custom Groups, and Transformations.

 Maintenance of Metadata using MicroStrategy DSS Architect.

 Created Customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web to apply customized formats.

 Configured Metrics, Attributes and Filters for each Report.

 Actively used Data Modeling & Technical Diagramming Tools Erwin & Visio. Relationships were figured out and mapping was done accordingly. Conceptual Data Modeling, analysis etc. were made.

 Used MicroStrategy Desktop (Templates, Filters, and Metrics) to generate advanced reports in grid, graph, and SQL mode, consisting of data analysis by combining a template with filters.

 Created MicroStrategy Filters, Documents, Facts, Attributes, Hierarchies etc.

 Various queries were written for optimization, exploited the indexing at the back-end.

 Created Complex Filters (Relationship Filters, Dynamic Filters, Embedded Filters, Custom Filters), Compound Metrics with dimensionality.

 Involved in Testing and Tuning of Reports and Objects.

 Created all possible Metrics for users to build their own reports on Web by creating their own Templates and filters using the available Metrics.

 Used Auto Prompts filter feature to give the end-user a choice of different filtering criteria each time they run the report.

 Documentation of MicroStrategy Objects Process flow.

 Maintenance and Support for the project and end users.

Environment: MicroStrategy 7.5.2/7.2.3/7.x (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter) SQL Server, Informatica, Teradata V2R5, IBM DB2, ASP, XSL, HTML & DHTML.

Freddie Mac, Mc Lean, VA June 03- July 04

Microstrategy Developer

Responsibilities:

 Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Agent that can be re-used to build any number of metrics.

 Worked with the source systems to have a clear understanding of the data flow and interacted with the users to collect the business requirements.

 Designed the MicroStrategy Architectural Documents for the Projects.

 Created Reports using complex Filters and Compound Metrics and Prompts.

 Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.

 Used Customer, Product, Payment, Geographic and Time dimensions and generated reports like forecasting.

 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.

 Designed Metadata Structure using MicroStrategy Configuration Wizard.

 Developed customized and Ad-hoc reports using Templates, Metrics and Filters for Business analysis using MicroStrategy Agent with features of Drilling options [drill up, drill down and drill anywhere].

 Developed Auto prompts to give end users a choice of different filtering criteria each time they run the report.

 Performed testing of all reports for the final deployment.

Environment: MicroStrategy 7.5(Architect, Agent, Object Manager, WEB, Administrator, Enterprise Manager, Narrowcast), IBM DB2, DataStage, ERwin, Windows NT, Windows 2000 Professional

BFL Software Ltd, Bangalore, India Jul 01– May 03

Database Developer

Responsibilities:

 Actively participated in the requirement analysis, database design and modeling.

 Participated in the implementation of a payroll system using SQL, Oracle forms & triggers.

 Involved in the design of the overall database using Entity Relationship diagrams.

 Created indexes, sequences, constraints and snapshots.

 Wrote stored procedures and functions in PL/SQL.

 Helped in writing proposals, documentation and training.

 Involved in Data loading and Extracting functions using SQL*Loader.

Environment: Oracle 7i, SQL, PL/SQL, SQL*PLUS, Oracle Developer 6i, WinNT4.0.

Contact this candidate