SUMMARY:

• 7+ years of IT experience in all phases of Full Software Development Life Cycle (SDLC) Initiation, Planning, Analysis, Design, Construction, Documentation, Testing, Implementation and Maintenance in data warehousing environment.
• 6+ years of extensive experience working with all aspects of MicroStrategy 9.0/8.1.2/8.1/8.0.3/8.0/7.5.2/7.5.1 tool suite (MicroStrategy Intelligence Server, MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Narrowcast Server, MicroStrategy OLAP Services and MicroStrategy Distribution Services).
• Installed and Configured Intelligent Server and Narrowcast Server to schedule; execute and deliver reports directly to business users using various delivery methods.
• Significant experience in the Banking, Wireless, Healthcare, Insurance, Retail and Manufacturing domains.
• Good experience in upgrading MicroStrategy project from one version to another version and making use of improved performance and new features. Involved in upgrading MicroStrategy version 8.1.2 to version 9.0, version 8.0.3 to version 8.1 and version 7.5.2 to version 8.0.
• Extensive experience in developing Schema Objects (Facts, Attributes, Hierarchies, and Transformations) and Public Objects (Filters, Prompts, Metrics, Custom Groups, Consolidations, Searches and Templates) to develop reports.
• Proficient with Data modeling using Erwin and Toad for dimensional data modeling techniques such as Star schema and Snowflake schema, which includes Logical and Physical data modeling.
• Well - Organized, Quick learner, Self-motivated and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design and Coding.
• Good knowledge in Micro Strategy Object Manager
• Good Experience in RDBMS like Teradata, DB2, Oracle, SQL Server and DBMS like MS Access.
• Extensive experience creating Reports, Documents, Dashboards and Scorecards according to client/business user requirements.
• Extensive experience performing Administration tasks like Intelligence Server Administration, Configuring Memory Settings, Performance Monitoring, Scheduling, Creating New Users, Security Roles, Object Manger, Project Manager, Integrity Manager, Command Manager and Narrowcast Server Administration.
• Communicated, Managed and Mentored a team of offshore resources on a day to day basis to ensure productivity.
• Experienced with the concepts of Data Warehousing, Data Marts, Logical and Physical data modeling,ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Optimized report generation with respect to Very Large Databases (VLDB) to make absolute use of Database Flexibility, Caching, Security and Scalability Issues suited for Oracle, Teradata, DB2 and SQL Server and involved in troubleshooting MicroStrategy reports.
• Expert in Database development skills using SQL, PL/SQL, Stored Procedures, Stored Functions, Packages, and Triggers.
• Experience in full software development life cycle (SDLC) analysis, Design, Development, Configuration, Documentation, Testing, Implementation and Maintenance in data warehousing environment.
• Self-initiative, excellent analytical and Communication skills and ability to work independently and as good team player.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 9.0/8.1.2/8.1/8.0.3/8.0/7.5.2/7.5.1 (MicroStrategy Administrator, MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, MicroStrategy OLAP Services, MicroStrategy Architect, MicroStrategy Distribution Services, MicroStrategy Office, MicroStrategy Command Manager).

Database Tools: SQL Loader, SQL *Plus, Query man, Db Visualizer 7.0.7.

Databases: Twin Fin 5.0.8, Oracle 11g/10g/9i/8i, Teradata12/ V2R 6.1.1/6.0.2/6.0 , DB2 9.5/9.1/8,SQL Server 2008/2005/2000 , MS Access, My SQL.

Languages: C, C++, SQL, PL/SQL, T-SQL, UNIX Shell Scripting

Web Technologies: HTML, XML, PHP, JavaScript, Ajax.

Operating Systems: Windows 7/Vista/XP/NT/2000, MS-DOS, UNIX, Linux, Macintosh.

Data Modeling: ER Studio 8.5, Toad Data Modeler, Erwin.

GUI: Visual Basic 6.0.

Packages: MS Office Suite (2010/2007/2003 ), Adobe Dreamweaver (CS4/CS3).

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Sr MicroStrategy Architect/ Developer

Responsibilities:

• Responsible for requirement gatherings and make necessary changes to the design documents.
• Followed Full Software Development Life Cycle Process (SDLC) of Initiation, Planning, Analysis, Design, Construction, System Testing and Implementation.
• Extensively used Command Manager to create schema objects in bulk.
• Proposed naming standards for Attributes, Metrics and Filters to make easy for Business users.
• Prepared documentations related to the MicroStrategy project implementation.
• Created Various Hierarchies which allows users to drill on reports.
• Generated Grid and Graph reports.
• Developed Public objects like Metrics, Custom Groups, Consolidations, Prompts, Templates and Filters.
• Coordinated with Database Architect and ETL developers for data availability and data model related issues by providing solutions that support MicroStrategy application.
• Documented the MicroStrategy Data Dictionary.
• Working on creating Dashboards for Senior VPs
• Used auto prompts filter feature to give the end-user a choice of different filtering criteria each time they run the report.
• Used Enterprise Manager to check the performance of the reports and usage of objects.
• Created static and dynamic dashboards using various widgets according to the requirement.

Environment: MicroStrategy 9.0 (Desktop, Architect, Web, Object Manager, Command Manager, Integrity ManagerEnterprise Manager), Netezza TwinFin 5.0.8, ER Studio 8.5, Db Visualizer 7.0.7, HP Quality Center 10.0, MS Access (2007).

Confidential, Oklahoma city, Oklahoma.

Sr MicroStrategy Architect/ Developer

Responsibilities:

• Involved in meetings with business users to discuss and finalize the requirements and design of the reports.
• Developed different reports according to the requirements.
• Developed Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships like one-to-one, one-to-many and many-to-many between different attributes.
• Designed various Dashboards/Scorecards reports, which provide practical ability for business user to design and refine their own reports without programming.
• Managed, Trained and guided junior MicroStrategy Developers of team size 5.
• Created Security roles, Security Filters and assigned them to groups and users to meet the corporate requirements.
• Worked extensively on developing Metrics and Compound Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports using MicroStrategy 9.0.
• Performed routine administrator tasks during absence of MicroStrategy administrator.
• Extensively worked with Object Manager to migrate the MicroStrategy Objects from development to QA and then to production environment.
• Used several new controls for Dash boards like time series slider, radio buttons, and drop down menus for the flash version of the dashboards in 9.0
• Tested all the reports by running queries against the warehouse using Query man. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Created Ad-hoc Reports by drilling up, down, with across hierarchies.
• Involved in upgrading MicroStrategy 8.1.2 to MicroStrategy 9.0.
• Developed Auto Prompt Filters that gave user a choice of different filtering criteria each time they run the reports.
• Extensively used Integrity Manager to test reports when upgraded from MicroStrategy 8.1.2 to MicroStrategy 9.0.
• Used MicroStrategy Narrowcast server to deliver reports directly to business users by various delivery methods.
• Generated Freeform SQL reports writing SQL queries against different databases.
• Provided Business user for the MicroStrategy Desktop/Web.
• Created the Metadata & Statistic tables for the MicroStrategy projects on an Oracle database.

Environment: MicroStrategy 9.0/8.1.2 (MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Teradata 12.0, Oracle 11g, UNIX, Windows XP

Confidential, Dallas, TX

Sr MicroStrategy Architect/Developer

Responsibilities:

• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
• Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
• Reduced intelligence server pressure by increasing number of Database connection threads in optimal way.
• Extensively worked and developed Metrics, filters and prompts to enable decision-makers to view reports in different perspectives.
• Assisted in Project setup (Installing, Configuring, Managing and controlling) and Project Lifecycle management.
• Managed and guided junior MicroStrategy Developers of team size 5.
• Developed reports and dynamic dashboards for daily, weekly and periodic sales analysis.
• Developed a 3-tier client/server product in the corporation for use by the merchandising department to access a relational DB2 database using MicroStrategy tool suite.
• Extensively used Command Manager to create schema objects in bulk.
• Worked on advanced features like heterogonous column mapping, relationship filters and parent-child relationship.
• Periodic maintenance of Intelligence server and Narrowcast server installation in all environments to determine the current state of server parameters, performance, as well as identify potential issues and limitations.
• Coordinated with ETL and DBA teams for data availability and data model related issues and problems and provided solutions that support MicroStrategy application.
• Configured, Managed clustering of Multiple Intelligence server nodes and web server nodes to implement automatic failover, load balancing and boost the performance and scalability.
• Created Advanced Reports in grid mode and graph mode using Micro Strategy Desktop.
• Responsible for Installation and Configuration of Intelligence server, Web Server and Enterprise Manager.
• Best Practices using standardized methodology for coding, development, test and implementation processes.
• Involved in managing objects between different environments by using object manager.
• Created and managed MicroStrategy application objects, schema objects and configuration objects.
• Created various Narrowcast Services to deliver reports to users by various delivery methods.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts.
• Provide optimum performance and scalability through Multi-pass SQL and VLDB settings.
• Used MicroStrategy Enterprise Manager to see the usage of reports and their performance.

Environment: MicroStrategy 8.1.2(MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Administrator, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Narrowcast Server), DB2 9.5, Windows 2003 Server, Windows XP, Teradata 12.0.

Confidential, Grand rapids, MI

Sr MicroStrategy Architect/Developer

Responsibilities:

• Identified source tables and columns required in creating MicroStrategy project.
• Upgraded the environment from MicroStrategy 8.0.3 to 8.1 to take advantage of the performance gains, cart-style prompts, reporting services & interactive dashboards.
• Involved in analysis, design and construction of the Metadata.
• Coordinated with the DBA for table creation, loading data and other administrative activities.
• Designed and developed logical data model for MicroStrategy reporting environment.
• Designed Dashboards in 8.1 using the new selectors radio buttons, check boxes, panels, slider and button bar etc summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Created a Database instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Extensively used Command Manager to create schema objects in bulk.
• Extensively used Integrity Manager to test reports when upgraded from MicroStrategy 8.0.3 to MicroStrategy 8.1.
• Generated the technical Documentation for the MicroStrategy projects and also documented the MicroStrategy Environment.
• Implemented the MicroStrategy projects by creating Public & Schema objects like facts, attributes, hierarchies, reports, filters, metrics and templates in MicroStrategy Desktop.
• Improved the performance of the reports by changing VLDB properties.
• Developed different transformations which help business users to compare present data with previous year’s data in reports.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Implemented Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Applied best customization practices which can improve system performance and make application easier to maintain and upgrade to later versions of MicroStrategy Web.
• Modified the information displayed on the Prompt Question page by changing the layout definition file used by the prompt style that is applied.
• Performed Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
• Created of Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.
• Actively participated in developing Report Delivery Schedules.
• Created various Monthly Dynamic Dashboard documents for field marketing people with multiple panel stacks, selectors and customized widgets.

Environment: MicroStrategy 8.1/8.0.3 (MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Teradata V2R6.1.1, SQL Server 2005, Windows XP, Erwin.

Confidential, Chicago, IL

MicroStrategy Developer

Responsibilities:

• Involved in full life cycle development of Business Intelligence System.
• Designed, developed and maintained logical and physical enterprise data warehouse schemas using Erwin.
• Created Attributes, Facts, Advanced qualification Filters, Custom groups, Prompts, Hierarchies, compound metrics, filters, object prompts, custom expression filters according to the business needs.
• Communicated with the business, Data Modeling team and ETL team in various levels for the stabilization of the reports.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Implemented drill functionality on the reports using Drill Maps.
• Implemented Report Services and generated the documents to be distributed to end users using Narrowcast Subscription.
• Created dynamic dashboards to improve marketing by product, customer, geographic and promotion analysis.
• Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Desktop that can be re-used to build any number of metrics.
• Extensively used OLAP cubes functionality in Query performance.
• Provided access to MicroStrategy platform from Microsoft Excel (Non-MicroStrategy Interface) by using MicroStrategy Office.
• Defined/Created system hierarchy/user-defined hierarchy and controlling (lock, limit and filter out) the attribute elements in hierarchy.
• Used Command Manager to create attributes and facts in bulk.
• Developed Reports enabling Data Drilling across multiple Dimensions using MicroStrategy Desktop and MicroStrategy Web. Graphs and Alerts were used to support the Reporting process.
• Provided level of effort estimates for new project work, enhancements and fixes.
• Modified the information displayed on the Prompt Question page by changing the layout definition file used by the prompt style that is applied.
• Performed the administration tasks like tuning, Caching, specifying Query Governing Thresholds, and Report optimization.

Environment: MicroStrategy 8.0 (MicroStrategy Administrator, MicroStrategy Web, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Erwin, DB2 9.1, Oracle 10g, Teradata V2R6.1.1, Windows XP

Confidential

MicroStrategy Developer

Responsibilities:

• Involved in the Analysis, Design, Development and Implementation of Business Intelligence and maintaining applications using MicroStrategy Tool suite
• Interacted with business users extensively in gathering the requirements and translated them into report specifications for the MicroStrategy platform
• Implemented advanced MicroStrategy Reports concepts by creating projects, attributes, hierarchies, facts, metrics, filters, Custom groups and templates using MicroStrategy Desktop, MicroStrategy Web.
• Extensively used report services for creating Enterprise Dashboards summary level documents with grids & graph combinations.
• Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters.
• Provided access to the Data-warehouse to a much larger audience by using Narrowcast Server. The report delivery has been personalized as per user requirements
• Used MicroStrategy Narrowcast Server to monitor the business data and alert the users to unexpected exceptions and trends.
• Developed different prompts to give business users a choice to filter the data each time they run the reports.
• Renamed the metrics, reports and deleted the unused objects using the MicroStrategy Command Manager.
• Extensively used Integrity Manager to test reports when upgraded from MicroStrategy 7.5.2 to MicroStrategy 8.0.
• Involved in upgrading MicroStrategy 7.5.2 to MicroStrategy 8.0.
• Involved in troubleshooting MicroStrategy Web Reports, and optimizing the SQL using the VLDB properties

Environment: MicroStrategy 8.0/7.5.2(MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Web, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Oracle 10g, Teradata V2R6.0.2, Windows XP.

Confidential

Oracle Developer/ DBA

Responsibilities:

• Planned, Installed, Configured and Upgraded of Oracle Databases (9i-10g).
• Coordinated Backup and Recovery operations over all databases, ensuring 100% recoverability.
• Performed Daily, Weekly and Monthly Oracle monitoring and maintenance tasks
• Wrote Stored Procedures according to specs and control files for input to SQL Loader utilities for loading data from external files into the Oracle database.
• Created Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Created of Users and granted privileges and roles.
• Performed Database Tuning, Database Security and Integrity.
• Used extensive Sub Queries, PL/SQL procedure, DDL functions, database triggers and packages.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL
• Designed and created schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle and also monitored the data loading jobs and tuning the SQL queries.
• Created Indexes, Views, Alerts, Triggers, Procedures, Stored Procedures, Functions and packages in PL/SQL. Writing shell scripts to automate the data loading. .

Environment: Oracle 10g/9i, SQL Server 2000, UNIX, Windows (NT/2000), TOAD, SQL *PLUS, UNIX Shell Scripting, PL/SQL.