SUMMARY:

• 8+ years of experience in Information Technology that includes Design, Development, Implementation and Support.
• More than seven years of experience with Microstrategy working with Desktop, Architect and Web.
• Microstrategy Certified Project Designer/Report Developer.
• Working experience in many industrial sectors like Financial, Retail.
• Strong troubleshooting capabilities in Microstrategy Desktop.
• Extensively worked on Schema Design creating Attributes, Facts, Hierarchies and Transformations.
• Experience in developing public objects like Metrics, Advanced Metrics, Filters, Advanced Filters, Prompts, Custom Groups, and Consolidations as per the user requirements.
• Strong skills with various Microstrategy administration tools (Narrowcast Manager, Command Manager and Systems Manager)
• Experience in full Software Development Life Cycle (SDLC).
• Experience in working with various type of SCDs.
• Involved in dimensional modeling of Databases for data warehouse using Erwin and desiging different schema models(Star & Snow Flake).
• Very good knowledge in Informatica.
• Strong skills of working with databases like Oracle, SQL Server and Teradata
• Extensive experience in development of SQL Queries, Stored Procedures and Triggers.
• Excellent analytical, communication and problem solving skills.

TECHNICAL SKILLS:

Operating Systems: Windows 7, Windows Server 2012, MS - DOS and UNIX.

OLAP: Micro Strategy 10.4.0 (Intelligence Server, Desktop, Web, NarrowCast Server), Business Objects 5.1.4 (Designer, Business Object, Supervisor, Web Intelligence).

Tools: Computer Associate’s ERWIN 3.5.2/4.1,MS Project, MS Excel, MS Word, MS PowerPoint, Visio, SQL*Loader, SharePoint, Documentum.

ETL Informatica: Power Center and Accentual Data Stage

Languages: PL/SQL, SQL and Visual Basic

RDBMS: Oracle 12g, Teradata, MS SQL Server and MS Access

PROFESSIONAL EXPERIENCE:

Confidential, Tampa

Microstrategy Developer

Responsibilities:

• Analyzed the reporting requirements and created various mockup dashboards.
• Created various report services and Dashboard documents using freeform SQL to achieve the desired output.
• Involved in migrating objects across different environments.
• Created cases and scenarios based on business and functional requirements.
• Performed thorough testing of Microstrategy Reports against the Database using manual.

Confidential, New York

Microstrategy Developer

Responsibilities:

• Performed Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects.
• Built and Demonstrated various visualizations via mockup walk through sessions.
• Trained business users on self-service reporting capabilities that helps to leverage existing datasets for regional or department or team specific reporting needs.
• Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.
• Analyzed various existing Business Objects reports and replicated the same in MicroStrategy.
• Created various report services and Dashboard documents.
• Designed and developed Dashboards for interactive analyses using widgets and selectors.
• Extensively worked on the intelligent cubes.
• Involved in migrating objects across different environments.
• Created cases and scenarios based on business and functional requirements.
• Performed thorough testing of MicroStrategy Reports against the Database using manual and Integrity Manager.

Confidential, Tampa, Florida.

Microstrategy Developer.

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.
• 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.
• Worked with Microstrategy Object Manager to move objects among the Development, Testing and Production environments
• Customized Microstrategy web using SDK.
• 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 and Scheduling.
• Involved in Microstrategy Production upgrade activities.
• 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.

Environment: Microstrategy 9.4.0/ (Desktop, Administrator, Web), Microstrategy Intelligence Server 9.4.0, Microstrategy Narrowcast Server 9.2/8.1.2, Oracle 11g, Windows 7.

Confidential, White Plains, New York.

Microstrategy Architect/Developer.

Responsibilities:

• Involved in gathering of business requirements.
• Involved in design of the project logical model.
• 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.
• Writing BAT file to call Command manager to execute Service.
• 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.
• Involved in Microstrategy version 9.0 product evaluation.

Environment: Microstrategy 9.0/8.1.2 (Desktop, Administrator, Web), Microstrategy Intelligence Server 8.1.2, Microstrategy Narrowcast Server 8.1.2, Oracle 10g, Windows XP.