SUMMARY

• 8+ years of strong experience in Business Intelligence in designing and implementing Web based and Standalone software application with major focus on Data Warehousing and Database Applications.
• Extensive experience as MicroStrategy Developer, Architect & Administrator building projects and creating reports and Dashboards using MicroStrategy 7.i/ 7.5/8.0/8.1/9.0/9.0.1/10.0/10.4/10.8 , Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.
• Involved in training Business Users on MicroStrategy OLAP Services (such as view filter and derived metrics, Adhoc reports).
• Used MicroStrategy tools like Object Manager to migrate the objects/projects between MicroStrategy environments. Strong data modeling (Logical and Physical) experience with high proficiency in using Erwin for Dimensional Modeling (Star, Snowflake schemas) and Entity - Relationship Modeling.
• Experience in creating Report Service Documents, pixel perfect Dashboards and Visual Insight analytics templates.
• Installing and Configuring of MicroStrategy suite including MicroStrategy Desktop, Administrator, Intelligence Server, Web, and Narrowcast Server on NT Servers and Sun Solaris Environments.
• Experience in developing Interactive Flash Dashboards using D3 Widgets and Dynamic HTML.
• Experience in developing Widgets using jQuery and Javascripts in D3 Widgets.
• Advanced extensible reporting skills using MS BI, SQL Server Analysis Service (SSAS), and DAX. Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
• Expert in creating List Reports, Crosstab Reports, Drill through Reports and Multidimensional Reports with cascading prompts, Macros, filters, calculations using Cognos.
• Creating users, user Groups and assigning security roles for the project.
• Monitoring user connections, caches and jobs.
• Developed basic and user-specified Metrics (level and conditional).
• Created drill maps for end users to drill down and recover data.
• Worked with Logical and physical modeling along with design and implementation.
• Involved in job scheduling, monitoring and production support in a 24/7 environment.
• Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.
• SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Extensive knowledge of SQL, PL/SQL and worked on very large databases in Teradata V2R5/V2R4, Oracle 10g/9i/8i/7.x, and SQL Server 2005/2008.
• Excellent analytical and communication skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS

BI TOOLS: MICRO STRATEGY DESKTOP 7X/ 8X/ 9.X/ 10.X (MICROSTRATEGY DESKTOP, MICROSTRATEGY WEB AND WEB UNIVERSAL, MICROSTRATEGY INTELLIGENCE SERVER, REPORT SERVICES, DOCUMENTS, DYNAMIC DASHBOARDS, NARROWCAST SERVER & ENTERPRISE MANAGER.

DATABASE: ORACLE 8I/9I/10G/11G, TERADATA, MY SQL, MS SQL SERVER 2008/2005/2000 , MS ACCESS.ETL TOOLS INFORMATICA POWER CENTER 9.X/8.X, SQL SERVER SSIS SERVICES.

OTHER TOOLS: TOAD, SQL ASSISTANT, PL/SQL DEVELOPER, MS OFFICE, MICROSOFT VISIO, ERWIN, DB VISIO.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Sr. Micro Strategy Developer

Responsibilities:

• Worked with business users to gather requirements and prepare technical specification Documents.
• Understanding the reporting requirements, developed the reports and redesigned the legacy reports in MicroStrategy.
• Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters and metrics using MicroStrategy Desktop.
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics.
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.
• Extensively created MicroStrategy Report Services Documents, Dashboards for Web & Mobile (iPad) users.
• Created Report Builder, Visual Insight screens for power users to help them create their own reports, dashboards.
• Depending on the requirement, used database specific MicroStrategy OLAP pass through functions like Apply Simple, Apply Comparison to overcome complex logic in creating objects.
• Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls, and worked extensively on D3 Widgets, Dynamic HTML & jQuery.
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, and access controls Lists.
• Worked on Narrowcast Server Application environment creating services using subscription sets, schedules, and Information objects.
• Tuned ODBC driver to improve data transfer rates between database and MicroStrategy servers located at different physical locations.
• Involved in MicroStrategy Upgrade from 10.3 to 10.10 and then to version 10.3. Used MicroStrategy Integrity Manager for regression testing during upgrade.

Environment: MicroStrategy 10.3/10.10 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Teradata, SQL Server.

Confidential, Owings Mills, MD

Sr. Micro Strategy Developer

Responsibilities:

• Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters and metrics using MicroStrategy Desktop.
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics.
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.
• Extensively created MicroStrategy Report Services Documents, Dashboards for Web & Mobile (iPad) users.
• Created Report Builder, Visual Insight screens for power users to help them create their own reports, dashboards.
• Depending on the requirement, used database specific MicroStrategy OLAP pass-through functions like Apply Simple, Apply Comparison to overcome complex logic in creating objects.
• Widely used VLDB properties to set default criteria at project level and at individual report levels to overcome performance issues.
• Created Intelligence Cubes in MicroStrategy to overcome performance issues related to Report Service Documents using high volume datasets. Using Intelligent cubes improved performance of the RS documents significantly.
• Analyzed existing SAP Business Objects reports, documented the Technical specifications and converted SAP Business Objects reports to MicroStrategy for CRES Workplace Utilization project.
• Used the Object Manager to migrate the objects from Development to UAT environment in MicroStrategy.
• Involved in MicroStrategy Upgrade to 9.4.1 and then to version 10.4. Used MicroStrategy Integrity Manager for regression testing during upgrade.
• Used Narrowcast Server to automate FX TCA Order Completion reports, Aggregate reports to internal and external clients.
• Involved in MicroStrategy migration from Solaris to Linux, also database migration from Physical Oracle database to DHS Virtual hosts.

Environment: MicroStrategy 10/9.4.1 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Oracle 11g, DB2.

Confidential, Pittsburgh, PA

Sr. Micro Strategy Developer

Responsibilities:

• Involved in the documentation of technical specifications of the Sales and Inventory Project.
• Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
• Created different Project Sources for different environments like production, testing and development.
• Created different schema objects like Attributes, facts by using Micro-Strategy Architect of the Micro-Strategy BI Suite.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards).
• Generated reports using Advanced Metric objects, Filters and Prompts. Also created Customized Templates to facilitate End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Using Informatica Power Center Designer and analyzed the source data to Extract & Transform from various source systems.
• Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, and access controls Lists.
• Worked on Narrowcast Server Application environment creating services using subscription sets, schedules, and Information objects.
• Tuned ODBC driver to improve data transfer rates between database and MicroStrategy servers located at different physical locations.
• Used database specific MicroStrategy OLAP pass through functions like Apply Simple.
• Involved in production support (24/7).
• Maintained a stable platform by proactively identifying and resolving any issues or bugs.

Environment: MicroStrategy 10/9.4.1 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Oracle 11g, Sybase.

Confidential, Newark, NJ

Sr. Micro Strategy Developer

Responsibilities:

• Worked with business users to gather requirements and prepared technical specification Documents.
• Understanding the reporting requirements, developing the reports and redesigning the legacy reports in MicroStrategy.
• Involved in Dimensional Data Modeling, Data Architecture, Business and Data Analysis.
• Developed MicroStrategy Schema objects and Application objects like Metrics, Filters, Prompts, Consolidations, Custom Groups, and Project objects like Subtotals.
• Designed Reports, Documents and Dashboards using Desktop.
• Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies.
• Created Transformations to calculate YTD (Year to date), MTD (Month to date) metrics.
• Implemented Report Data Options, Formatting, Dynamic Dates, Advanced Sorting, Prompt Ordering, and Totals, Outline Mode based upon the business user change request during UAT Testing.
• Validated end user report requests using SQL queries and MicroStrategy tools.
• Used Object Manager to move the reports from Development Project to QA/Production Project.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Executed data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in optimization of code and tuning queries for performance.
• Provided production support for ongoing issues.

Environment: MicroStrategy 9.4.1/9.3 (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), UNIX, Windows Server, SQL server.

Confidential, Boston, MA

Microstrategy Developer

Responsibilities:

• Used Object Manager to move the reports from Development Project to QA/Production Project.
• Involved in providing solutions for Complex Time Dimension related issues.
• Designed MicroStrategy Schema objects and Application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy Desktop and Architect.
• Worked extensively on Complex reporting needs, which involved creating Consolidations and Custom Groups.
• Enabled the Advanced Qualification option for the Filter Editor, and created Custom Expressions to build Relationship filters according to the Business logic.
• Created the Analytical engine bypass functions like Apply Simple & Apply Comparison whenever necessary.
• Created different Transformations to get the last year actual transactions, Month to Date (MTD), Quarter to Date (QTD), Year to date (YTD) calculations and effectively used them with the metrics.
• Implemented Drill Maps functionality in various reports.
• Used the Object Manager to migrate objects between DEV, UAT and Production environments.
• Optimized Query Performance using VLDB settings.
• Created and configured the Narrowcast Server to execute and deliver reports to your emails using dynamic subscriptions.
• Worked as MicroStrategy support admin to handle some of the administrative tasks