SUMMARY

• 8+ Years of professional IT experience in data modeling, designing and architecting data warehouses and Business applications in Retail, Chemical, Media and Telecommunication industries.
• 6+ years of experience in MicroStrategy 9.x/8.x.x using MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Architect, Microstrategy Web, MicroStrategy Administrator, MicroStrategy Report Services, MicroStrategy Dashboards and MicroStrategy Narrowcast Server.
• In - depth knowledge of fundamental Data warehousing concepts such as entity relational modeling, dimensional modeling, star and snowflake schemas, modeling data marts.
• Strong knowledge of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Solid Experience in generating complex reports using Microstrategy.
• Strong troubleshooting capabilities in Microstrategy Desktop.
• Expertise in working with Schema Objects like Attributes, Facts, Tables, Transformations, Hierarchies, Functions and operators
• Extensively worked in creating and integrating Public Objects (Filters, Metrics, Prompts, Reports, Templates, Documents, Custom groups and Consolidations )
• Implemented proactive delivery reports and implemented the business intelligence solutions using MicroStrategy Narrowcast Server.
• Extensive experience in development of SQL Queries, Stored Procedures and Triggers.
• Experience in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Involved at all stages of the data warehousing project; setting up the schema and architecture, developing reports, security and deploying to end users. Strong familiarity with the Extraction Transformation and Loading (ETL) process.
• System Optimization, performance monitoring and tuning experience in Multiple BI applications.
• Expertise in using the Erwin and ER Studio data modeling tool.
• Exposure to client interaction, user-requirement analysis and User support.
• Exceptional analytical and problem solving skills. Self motivated team player with the ability to communicate effectively at all levels of the development process.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.
• Good leadership qualities with experience in training developers, advising technical groups on coding best practices.

TECHNICAL SKILLS

BI Tools: MicroStrategy Desktop 9.x/8.x.x, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligent Server, MicroStrategy OLAP Services, MicroStrategy DSS Suite

Data Modeling: ER Studio 8/7.x, Erwin Data Modeler 4.0/3.5.2, MS Visio Tools

ETL Tools: Informatica Power Mart 7.1/6.0, Ab Initio 1.1/1.0, Ascential DataStage 7.0/6.0

Databases: ORACLE 10g/9i/8i, Teradata V2R4.1, Netezza, SQL Server 6.5/7/ 2000, IBM DB2,MS Access 2000

Programming Languages: Visual Basic 6.0, SQL, PL/SQL, T-SQL, Shell Scripting, Fortran, Pascal

Web Language: HTML, DHTML, XML, XSL, Microsoft Front Page, HomeSite 4.0, Javaand tools VB Script, ASP, JSP, Script

Operating Systems: MAC OS/OS X, MS-DOS, UNIX, WinNT, Window XP/ 2003/2000/98 and Linux

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, RI

MicroStrategy Architect

Responsibilities:

• Involved in collecting and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Was in retail team, extensively worked on creating weekly, monthly and yearly sales reports.
• Involved in Dimensional Modeling by selecting the business process, declaring the grain, and choosing the dimensions and facts.
• Developed Schema Objects (Facts, Attributes, Hierarchies and Transformations) using MicroStrategy Architect.
• Analyzed and developed Application Objects (Metrics, Reports, Documents, filters, prompts) using MicroStrategy Desktop and MicroStrategy web interfaces.
• Created metrics (simple, nested & compound), advanced filters, advanced prompts, advanced report designs and drill maps.
• Involved in migration of Business Objects documents to Micro Strategy documents.
• Delivered personalized reports from MicroStrategy project to subscribers using MicroStrategy Narrowcast Server.
• Developed Intelligent Cubes in version 9.x to slice and dice the data.
• Tuning MicroStrategy Intelligence Server for better performance
• Worked as backup administrator in charge of adding new users to groups and assigning them security privileges.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Involved in defining and designing the Report Templates.
• Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.
• Created three types of reports to show the users - Enterprise reports, Dashboard analysis reports, Ad-hoc reports.
• Implemented OLAP Functions like Apply Simple, Apply Comparison for the complicated filters, attributes and metrics.
• Understand the type of schemas that best support MicroStrategy in different scenarios
• Analysis and Troubleshooting of the SQL generated by Microstrategy
• Developed dashboards/ scorecards for quick and easy visualization.

Environment: MicroStrategy Architect, MicroStrategy Desktop 9.X, MicroStrategy Web, Narrowcast Server, MicroStrategy Intelligence Server, Teradata V2, Erwin Data Modeler 4.1, Windows 2000/NT and UNIX

Confidential, San Antonio, TX

Sr.MicroStrategy Developer

Responsibilities:

• Designed, developed and architected a MicroStrategy project that accesses item, store and sales rep information and generates reports for the Sales operations department.
• Gathered requirements, created mockups and developed an extensive collection of interactive dashboards using MicroStrategy Report Services for distribution to executives, VPs and field sales teams.
• Created a complete replacement for the existing Excel based reporting and distribution system using MicroStrategy Office.
• Developed schema objects (facts, attributes, hierarchies, transformations) using MicroStrategy Architect.
• Extensively used filters, templates, consolidations, transformations and custom groups to generate reports for business analysis using MicroStrategy 8i.
• Developed metrics, derived metrics, compound metrics and level metrics for complex reports.
• Created transformations for rolling time period reporting and trending of prescription counts. Created advanced filters, advanced prompts, advanced report designs and drill maps.
• Used SQL Developer extensively to test and debug MicroStrategy reports as a key step in data validation.
• Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.
• Analyzed and developed partitioning and indexing strategies for performance improvement.
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters and compound Metrics and Prompts.
• Design, Development, testing and implementation of projects in Microstrategy
• Designed and developed various database objects like tables, views, snapshots, procedures, SQL queries etc., in Oracle, SQL server and Teradata.
• Created Database Instances and connection mapping for access to proper warehouses and users
• Used pass-through database authentication to link Microstrategy user to database users.
• Involved in Customer Support and Maintenance & Performance Tuning of reports

Environment: Microstrategy 9 (Desktop, Architect, Report Services Document, Web, Narrowcast Server), DTS, SQL Server 2000, Teradata, Windows

Confidential, Irving, TX

MicroStrategy Developer

Responsibilities:

• Served as Microstrategy developer for the full lifecycle of the data-warehousing project from requirement gathering from business to rollout.
• Involved in Analyzing existing reports in different ordering and billing systems, created the design and development of the reports.
• Analyzed and consolidated similar reports developed using stored procedure, shell script and created design and developed Microstrategy reports
• Involved in creating Dimensional Model using Erwin
• Created Attributes, Metrics, security filters and other report objects, drilling, defined hierarchies using Microstrategy Agent (Desktop).
• Communicated with the business, Data Modeling team and ETL team in various levels for the stabilization of the reports.
• Involved in UAT and stabilize the reports after report demonstration to the business.
• Involved to move the report objects from UAT to Production using Object Manager, created security privileges to users.
• Creation of Project Design and Schema Objects in Microstrategy Architect
• Designed and Developed Complex and large Microstrategy Reports in Microstrategy Desktop.
• Designed and developed Dashboards using Microstrategy Report Service Documents for various products and services
• Provided training to the users, created documents for the users, involved in customer support and stabilize the report in production environment.
• Writing complex SQL queries in Teradata to meet reporting requirements.
• Creating views and Teradata database using base tables.
• Development of dashboards and scorecards for management reporting using Report Services.
• Monitoring and ensuring of project progress and preparation of Status reports.
• Design and developed Narrowcast Services
• Created HTML and Excel formatted documents.

Environment: Microstrategy 8.1 (Administrator, Desktop, Architect, Intelligence Server, Narrowcast Server, Web), Oracle, Toad, Erwin, Informatica 6.2, MS SQL Server, DTS, DB2, Terada, Windows, UNIX.

Confidential, Florida

Microstrategy Developer

Responsibilities:

• Involved in gathering of business requirements.
• Architected schema objects such as attributes, facts and transformations.
• Created various Microstrategy objects such as Metrics (simple and compound), Filters, Prompts, Custom Groups, Consolidations, etc.
• Created a DB instance for Microstrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Worked with Microstrategy Object Manager to move objects among the Development, Testing and Production environments.
• Set Up Microstrategy and Windows Performance Counters and Log them to Text or CSV for Performance Tracking.
• Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
• Micro strategy IServer Tuning for performance.
• Created various event based Schedules.
• Deploying Flash Widgets on Servers and Uploading the New ones from Support site.
• Created reports with various object prompts to generate various Ad hoc reports.
• Worked with Erwin in designing the schema for database views.
• Created many Materialized views in Oracle, which act as Mart tables.
• Created various Report Services Documents for SPG and SVO Activity with various transformation metrics to report on Monthly, YTD and Trailing 12 month’s period.
• Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.
• Created various Narrowcast reports, subscriptions and schedules.
• Created Informatica Mappings for Monthly data load from FTP site to the Data warehouse.

Environment: Microstrategy 8.0.1 (Desktop, Administrator, Web), Microstrategy Intelligence Server 8.0.1, Microstrategy Narrowcast Server 8.0.1, Oracle 9i, Erwin 4.0, Visio 5.0, Windows NT/2000

Confidential

Oracle Developer

Responsibilities:

• SDLC using SSAD Methodologies of the application including the study, design, development, implementation and maintenance.
• Developing PL/SQL Procedures
• Responsible for the Layout Design of the forms and reports.
• Involved in the Front-end Design using Forms 4.5 and Reports
• Oracle 8i was used as the back-end.
• Estimated storage requirements of an application
• Informed database administrator about the changes required
• Performed application tuning and performance monitoring
• Setup and maintained documentation and standards
• Involved in Testing and Documentation

Environment: Developer/2000 and Oracle 8i in Novell NetWare 3.12 & Windows