SUMMARY:

• Project Development Manager (supervised Business Intelligence, Senior Web Developers, ETL developers) with 22 plus years of total IT experience in Analysis, Design, Development, Testing, Administration and Support of large databases/Data warehouses in financial environments.
• 20 years plus experience in Microstrategy Mobile/Administration/Architect/ Development/Narrowcast/Distribution Services/SDK customization/Command Manager automation/Enterprise Manager Statistics gathering and reporting/OLAP Cube based reporting/Cognos/Qlik/SSRS/Crystal Reports/Tableau/OBIEE/Hyperion
• Extensive Business Knowledge in Finance, Pharmaceutical, Sales and Marketing and Banking industry and has been involved in Business Analysis, requirement gathering, functional database design, and hardware and software assessment.
• SQL Server experience in Stored Procedures, Triggers, Materialized Views and Performance tuning of Netezza, Oracle, Sybase Databases, Applications and Queries.
• Strong Data Modeling experience using ERWIN 3.5.5/3.5.2.
• Strong understanding of Datawarehouse modeling tool such as Snowflake, Star Schema, slowly changing dimensions
• Proficient at Enterprise Database Integration and Management. Well versed in Web development
• Proven technical skills, good communication, and a corporate presence with high visibility across teams interacting in an Agile environment

TECHNICAL SKILLS:

Business Intelligence Tools: Micro Strategy 10.x, 9.x, 8.1.1, 8.0.2, 8i and older, Cognos, Qlik, SSRS, OBIEE, Hyperion, Tableau, Business Objects Workflow - Alteryx

Languages: Visual Basic V6.0/ V5.0, ActiveX, Cold Fusion V4.0, ASP, JavaScript, Java, J2EE, PL SQL, SQL Plus, K Shell

Databases: Netezza, NCR Teradata, Oracle 8.0, Oracle 9i, Oracle 10g, Retek, MS SQL Server 7.0, Sybase, MS Access

Tools: Visual Interdev, Visual SourceSafe, Rational Rose 98, Rational Robot, MS Transaction Server, Internet Information Server, Seagate Crystal ReportsV4.5/7.0 and Seagate Crystal Reports Web Server, TOAD, Informatica 7.1

Operating Systems: Unix, Windows NT 4.0, Windows 95

EXPERIENCE:

Confidential

MicroStrategy Architect

Responsibilities:

• Client owns 39 companies and consolidation of legacy data into enterprise warehouse and Reporting based off Oracle Autonomous (Cloud based)
• Upgrade Microstrategy Environment from V10.6 to 2019
• Model User Security for 2000 users at Organization (Region->Division -> Division Region -> Branch) level and Employee level
• Architect semantic layer for Gen 2 project for Sales, GL (Finance), Orders and Quotes
• Creation of System Manager workflows for automated cube executions
• Creation of dossiers, documents based upon requirements for Sales, GL, Orders and Quotes
• Administration of all users, Migrations, Solutions based upon tickets/issues
• SAML Integration of users with Microstrategy

Environment: MicroStrategy 2019, Microstrategy Administrator, Microstrategy Architect, Oracle Autonomous

Confidential

Sr. Business Intelligence Consultant

Responsibilities:

• Oracle Deprecation for Rolling Stone project for all BI Legacy reports to new Microstrategy BI platform
• Design and development of CARI Customer Service scorecards for Customer Service, CS Productivity and Tickets.
• Design and development of Financials Reporting C2P from Jasper to Microstrategy BI Platform using architected self-service approach and creation f dashboards/ dossiers/documents
• Optimized performance of dashboards/visual insight documents
• Creation of Customer Service Tableau dashboards only for operations team
• Migration of Legacy Analytics Hyperion Reports (approx. 200) to MicroStrategy Self Service model
• Migration of Legacy Analytics Business Object Reports (approx. 100) to MicroStrategy Self Service model and documents
• Migration of few hundred OIEE Reports to new Microstrategy BI Platform and productionalize successfully all few hundred users
• Conversion of 60 Cognos documents to Microstrategy documents by creation of schema and public objects (attributes, facts) and creation of prompts, filters, metrics
• Creation of Power BI dashboards, datasets. Scheduling daily of reports, Share dashboards to SharePoint for users’ access
• Lead projects and work with Stake holders for deliverables. Agile environment support with daily standups, BI scrum meetings and JIRA prioritization to meet users’ expectations
• Migration plan, work and testing from MSTR 10.4 to MSTR 10.11
• Creation of 12 dossiers for users in MSTR 10.11
• Work in a collaborative team environment of data engineers and business intelligent engineers

Environment: MicroStrategy 10.11, Microstrategy Administrator, Microstrategy Architect, Redshift, Oracle, OBIEE, Hyperion, Business Objects, Tableau

Confidential

Business Intelligence Analyst / Dashboard Developer/ Architect

Responsibilities:

• Creation of a complex document thinking out of the box with good visualizations (date/month time sliders, maximize windows, menu displaying thresholds) for users
• Creation of System Manager workflow using Command Manager to dynamically execute cubes post receive of daily trigger files
• Design and development of schema, few hundred metrics due to complex requirements, table driven transformations
• Successful migration of more than 300 Microstrategy objects to Production
• Collaborate with multiple Microstrategy internal teams to provide solutions for web interface and excel/pdf document.
• Provided clean solutions to the business users for Export complex document with multiple panels and info windows to Excel and PDF
• Managed offshore and onsite resources during project development and delivery phases for a successful and seamless delivery
• Integration of at scale platform with Microstrategy and delivered POC project to the business
• Conversion of OBIEE Reports for Customer Service into Microstrategy Dashboards/Reports using modelled approach
• Conversion of Hyperion Reports into Microstrategy Dashboards/Reports/Self Service Model

Environment: MicroStrategy 10.4, Microstrategy Administrator, Microstrategy Architect, Hadoop, SQL Server, at Scale, Tableau, OBIEE, Hyperion

Confidential

Business Intelligence Lead

Responsibilities:

• Support and build new dashboards using QlikView for few hundred users across the globe
• Link Microstrategy Dashboards with QlikView dashboards and pass security credentials automatically by settings up configuration scripts
• Understand of existing TM1 cubes, configurations in Cognos
• Support and administration of TM1 servers, apply patches
• Support and administration of security layer for TM1 cubes
• Migration of Cognos TM1 into Microstrategy Intelligent cubes
• Design, Development of Dashboards, Transaction Services Documents, Visual Insight dashboards
• Build MSTR Servers, configure EM, OM for all environments, configure Clustered Servers and Load Balancing across all environments
• Automation of cube refresh for incremental load Automation of Security implementation of 8000 users on daily basis for Web SSO and files receiveed
• MicroStrategy SDK implementation for user security implementations
• Starting point dynamic user selections of prompts for Dashboards
• Visual insight dashboard development and highly sophisticated dashboards using D3 visualizations
• IPad implementation of four dashboards for executive directors
• Mobile deployment of dashboards using Mobile application
• Data Blending implementation of complex calculations into Dashboards

Environment: Qlik, MicroStrategy 10.2, 10.3, 10.4, Microstrategy Administrator, Microstrategy Architect, Oracle, Cognos TM1, Qlik

Confidential

Microstrategy Consultant

Responsibilities:

• The Harmony Expansion project will transition Field Reporting capabilities from an external service provider (ASI) to the established and evolving Commercial Data Repository thereby leveraging the existing Confidential Commercial IT data and infrastructure assets while reducing year-over-year data cleansing and system support expenses. While key reporting capabilities are transitioned the project team will apply best practices in designing the reports with the goal of improving user experience and usability in the process without reducing functionality or mode of access (e.g. iPad, notebook) to the Field Sales Force team.
• Production, Test and Development environments (MSTR I-Server and Web Server per each environment on Windows R12 boxes)
• Metadata and SDR data sources resided on SQL servers, instances will be connected to each environment.
• Metadata DB was the placeholder for all MicroStrategy objects, reports, dashboards.
• Each of environments has its own metadata DB.
• SDR data source was used as production data source for each of Microstrategy environments.
• Mobile Server was in place with external https to allow Field users to log in to MicroStrategy on IPADs.
• Single sign on using LDAP groups was implemented for access to Microstrategy dashboards
• Dashboards build to navigate and pass selector values from one to the other dashboards, with I-cube underlying the datasets
• User Security implementation for all user levels (AM, DM, RM) for all reports/dashboards for Rexulti, Maintena and other products
• Automation of cube refereshes
• UAT user testing support during UAT cycle, and production rollouts

Environment: MicroStrategy 10.1, Microstrategy Administrator, Microstrategy Architect, Microstrategy Mobile SQL Server

Confidential

BI Manager

Responsibilities:

• Microstrategy Project Manager for all Global Market Risk projects representing LOB’s for Equities, Credit, Mortgage, Issuer Risk, Rates and Currencies, CCAR, Fed Reporting in Microstrategy, interacted with warehouse and production teams.
• Built innovative solutions for complex Value at Risk calculations on a multi-billion row tables in a high performance Netezza environment. Automation of report jobs using autosys and Command Manager for Daily Reporting to Risk Managers
• Development and support of approx 50,000 MSTR reports currently and 200 users
• User Authentication setup using LDAP and SSO
• Portal deployment of reports using SDK API customization
• Writeback functionality implementation for daily and Ad-hoc processes
• Created LMS job processing using datamarts in Microstrategy
• Event based and time-based automation implementation
• Enhancement of complex queries from 10 minutes to few seconds using Netezza and MSTR best practices.
• Implementation of reports and dashboards to Mobile for all licensed users
• SSIS Cubes conversion and implementation in Microstrategy with drag and drop reporting.
• Interactive Dashboards, Visual Insight analysis using cubes and MDX reports
• Upgraded all reports/processes in Microstrategy from version 8.x to 9.x to 10.x
• Work Management and support of Microstrategy Administration and Development activities

Environment: Micro Strategy 10.x, 9.4.1, Microstrategy Administrator, Microstrategy Architect, Netezza, SSRS, Unix

Confidential

Microstrategy Consultant

Responsibilities:

• Administration and Development - Created customized enterprise manager reports for metadata cleanup, narrowcast subscriptions, personalization’s cleanup
• Advanced User modification implementation using Command Manager scripting.
• Architecture of 3 Confidential projects per requirements, dashboard development
• Narrowcast implementation of Confidential projects for user email subscriptions
• Guide junior MSTR developers for best practices in project and administrative work.

Environment: Micro Strategy 9.0.1, Microstrategy Administrator, Microstrategy ArchitectSQL Server, Teradata, Unix

Confidential

MicroStrategy Specialist

Responsibilities:

• Administration and Development - Command Manager script for provisioning users, use of SDK code - creation, modification, updates user, user groups, security filters.
• Implementation of security filters to existing SAP users using roles.
• Implementation of security filters to existing Reports and Dashboards, Testing.
• MSTR Migration of code from DEV to QA to PROD.

Environment: Micro Strategy 9.0.1, Microstrategy Administrator, Microstrategy Architect, Teradata, Windows XP

Confidential, New Jersey

Microstrategy Architect

Responsibilities:

• Design, development of metadata for Dashboards, Reports by conversion of SSRS Reports into Microstrategy Dashboards and Reports.
• Design of Db tables for Microstrategy schema objects.
• Architect - Design and development of 30 Reports (includes Dynamic dashboards and Reports) using V9.0.1
• Testing of Dashboards using Panel stacks, graphs, dynamic dashboard functionality implementation and Reports as per Requirements.
• Administration - Migration of Microstrategy project from DEV to QA to PRODUCTION
• Production support of MSTR Projects and user support for MSTR Reports and Narrowcast issues.
• Administration - Installation of MSTR 9.0.1 on Unix environment in a clustered environment.

Environment: MicroStrategy 9.0.1, Micro Strategy Narrowcast 9.0.1, Microstrategy Administrator, Microstrategy Integrity Manager, Microstrategy Architect, SQL Server, Unix

Confidential

Microstrategy Architect/Sr. Developer

Responsibilities:

• Creation of Microstrategy metadata for ad hoc reporting, dashboards to measure HH TV Viewing (hours per day/week of aggregated tv viewing), HH TV Viewing of specific Channels/Networks, Programs
• Analysis - Involved in Business requirement gathering of projects from Sales and Marketing users, provide project estimates.
• Involved in the Data modeling phase for the logical data model of the database. Design of Dimension, fact, transformation tables using star schema.
• Team Lead Role - Team supervision and performance management, monitoring and advising on operational costs, Implementing management policies and directives. Working with user interface development, DBAs and Support team. Mentoring junior microstrategy developers and full-time manager using market standards and best practices in order to provide product.
• Architect Tasks - Preparation of Microstrategy Report Metadata and Schema Design document,
• Architect Tasks - Designed and developed Schema objects (attributes, facts, Transformations, User hierarchies). Creation of schema objects (attributes, facts, transformations) to support Ad-Hoc Reporting.
• Development - Designed project from scratch creating a clean metadata, hierarchies, relationships between attributes in order to handle Ad-Hoc reporting. Creation of public objects - Dashboards using v9.x, creation of complex metrics, reports, Report Services documents working on several complex datasets along with XSL changes.
• Designed metrics to handle drill downs to different hierarchies.
• VLDB properties - handle outer joins, global optimizations, optimize SQL statements using Oracle hints, performance tuning SQL statements for good performance.
• Organize, test and adjust metrics and attributes. Create standard report templates for ad hoc reporting.
• Design and development of dynamic Dashboards using MSTR v9.x using panel stacks, element selectors, metric selector. Narrowcast Weekly Dashboards to end user community.
• Administration - Implemented Integrity Manager, Enterprise Manager usage for performance. Microstrategy Object Manager to migrate between projects and environments and Report Tuning for performance. Creation of Enterprise Manager custom reports for email delivery of Weekly User Activity reports of Microstrategy project and report usage.
• Production Support - Narrowcast - Implemented service weekly and monthly jobs using static subscriptions.
• Production support - Support of Microstrategy project for marketing and sales user group, resolve helpdesk tickets.
• End User - Creation of End user document. End user and production support for user build reports, canned reports and narrowcast reports for Sales and Marketing group.

Environment: MicroStrategy 9.x, MicroStrategy NarrowCast 9.x, Microstrategy Administrator, Microstrategy Integrity Manager, Microstrategy Architect, Oracle 10g, Windows 2000

Confidential, New Jersey

Microstrategy Architect

Responsibilities:

• Worked on multiple projects including global item view of Sales, Forecast, Budget, Inventory data across the various locations (Market, DC) throughout the network including visibility to market, plant level and replenishment planning data.
• Analysis - Involved in Business requirement gathering of projects from end client, provide project estimates. Involved in the Data modeling phase for the logical data model of the database. Design of Dimension, fact, transformation tables using star schema. Preparation of Reporting Design document, Test Cases. Review and Signoff from Business users.
• Architect Tasks - Designed and developed Schema objects (attributes, facts, Transformations, User hierarchies).
• Development - Creation of schema objects (attributes, facts, transformations) to support of Ad-Hoc Reporting. Creation of public objects - Reports (Grid, graphs), Report Services documents working on several complex datasets along with XSL changes, filters, prompts, metrics, complex metrics, report filters. Design and development of dynamic Dashboards using MSTR v8.1.1 using panel stacks, element selectors, metric selector. Narrowcast dashboards to end user community.
• Creation of events, schedules to plan caching of reports with respect to data load.
• Administration - Implemented Integrity Manager, Enterprise Manager usage for performance. MicroStrategy Project and Report Tuning for performance. Perform cleanup of objects using Scan MD. Upgrade to 8.1.1 from 8.0.2. Designed and development of the Security filter implementation using Command Manager scripts. Creation of users, user groups, object migration.
• Cognos reports and cubes migration to Microstrategy Desk Reporting
• ETL Support: Support helpdesk tickets for Informatica ETL objects and enhancements.
• Production support - Performance tuning, resolve helpdesk tickets.

Environment: MicroStrategy 8.1.1, MicroStrategy NarrowCast 8.1.1, Microstrategy Administrator, Microstrategy Integrity Manager, Microstrategy Architect, Microstrategy Office, TABLEAU, COGNOS, Oracle 9i, Informatica, Windows 2000

Confidential, New Jersey

Lead Microstrategy Architect

Responsibilities:

• A single reporting application having policy details information for the years 2004,2005,2006 thereby eliminating the present cross reporting process. The new reporting applications will provide all the necessary information about Leads and Sales required by Marketing Home Office and Field Management.
• Worked with Business Analyst to identify Microstrategy Security related Requirements in Requirements Document.
• Preparation of Technical Specifications of Microstrategy Schema objects. Architect: Involved in the Data modeling phase for the logical data model of the database.
• Team Lead tasks - Supervised two juniors offshore MicroStrategy developers and one onsite developer to deliver end client product using best practices.
• Faced many challenges involving but certainly not limited to MSI tool limitations, altering dimensional models to suit the business reporting, proper metrics calculations, and especially justifying the causes for having other teams to build the Aggregates
• Review of Microstrategy objects and hands-on development of complex Microstrategy metrics and schema objects.
• Creation of several report services documents having several datasets, complex format changes to combine reports to look like one report.
• Designed and development of the Security filter implementation using Microstrategy SDK and Command Manager scripts.
• Migration to Security SDK implementation to Production.
• Architect Tasks - Designed and developed Schema objects (attributes, facts, Transformations, User hierarchies).
• Administration Tasks - Migration from Development to UAT PRODUCTION using Object Manager. Enterprise Manager usage for performance. Micro Strategy Project and Report Tuning for performance.
• Applied Microstrategy ODBC patch for DB2 supported database drivers.

Environment: MicroStrategy 8.0.1, MicroStrategy NarrowCast 8.0.1, Microstrategy Administrator, Microstrategy Architect, Microstrategy SDK, Microstrategy Office, DB2, SQL Server, Informatica, Windows 2000, SiteMinder

Confidential, NJ

Sr. Microstrategy Developer

Responsibilities:

• Design, development, implementation of vendor Microstrategy reports for Web users.
• Business Analysis - Analyze merchandise retail microstrategy requirements into reporting requirements.
• Creation of database views for building attributes.
• Architect: Microstrategy development - Build schema objects, prompts, filters, metrics. Build Reports - Delivery Variability, Item Performance by Location, Market Basket, ASN Compliance & Week to Date Sales.
• Development of reports, report services documents (dashboards)
• Performance tuning using VLDB properties.
• Administration - Migration of Reports to UAT for user sign-off.

Environment: Micro Strategy 8.0.2, Microstrategy Architect, Teradata

Confidential, New York City

Microstrategy Architect/ Administrator / Narrowcast Specialist

Responsibilities:

• Gathering user requirements from Asia users.
• Team Lead tasks - Supervised two juniors onsite MicroStrategy developers. Supervised Microstrategy offshore developers in India. Was a liaison between offshore team and onshore team for Microstrategy product delivery to the client.
• Deployed and managed 3 Projects to PRODUCTION.
• Design of MicroStrategy Project from scratch and designed and developed schema and public objects.
• Learning of PhoeniX equities and FX functionalities
• Architect: Complete design and development of 40 MicroStrategy reports. These reports replace existing old legacy system reports.
• Microstrategy Desktop tasks - Complete design, development and deployment of 200 Reports for FX Desk, Portfolio Desk and Canada Desk.
• Designed and developed HTML Document. Developed XSL files for formatting of reports on HTML Document.
• Microstrategy Desktop tasks - Designed and created Report Services Document.
• Administration Tasks - Migration from Development to UAT to PRODUCTION using Object Manager.
• Web and Desktop administration for the Project. Administration for performance using Enterprise Manager. Performed Administrative tasks in a Project life cycle.
• Trouble shooting and fine-tuning reports in PRODUCTION.
• Designed NarrowCast reports for the project. Configuration of Narrowcast Server for file transmission and e-mail transmission. E-mailed users Excel Workbook with formatted excel worksheets. Email reports to different email distribution list depending upon the users that need to see the reports using dynamic subscription sets.
• File delivery of NarrowCast Reports to different file servers and archiving of old Excel reports using Schedule and dynamic subscriptions.
• Writing BAT file to call Command manager to execute Service. Web customization using XSL for formatting of reports
• Web customization using Java 1.2.X, J2EE and XML.
• Trouble shooting and fine-tuning reports using VLDB properties in PRODUCTION.

Environment: MicroStrategy 8.0.2, MicroStrategy 8.0.1, MicroStrategy NarrowCast, Microstrategy Administrator, Microstrategy Architect, Sybase

Confidential, NYC

Microstrategy Architect/ Administrator

Responsibilities:

• MicroStrategy reporting for Credit Dashboard - Credit Dashboard is an application for viewing and comparing the credit worthiness of companies/clients and examining the market spreads for bonds and CDS relevant to these companies. It is rich in fundamental data and market data.
• Creation of MicroStrategy reports for the Proof of Concept for Credit Dashboard and successful presentation of POC to the user.
• Microstrategy Project Design of schema, tables
• Creation of Schema object, metric, prompts, filters, templates, drill maps, page by, document object using Report Services.
• Created complicated graphs - bar, stacked, line and consolidated graphs, reports, metrics as document using Report Services, OLAP Services.
• Created Query page, Search page with graphs and grid results on the same report.
• Designed reports for efficient SQL generation and good performance (VLDB properties) using moderate normalization.
• Designed Ad Hoc Reports
• Administrative tasks - Moved Microstrategy objects using Object Manager.

Environment: MicroStrategy 8.0.1, SQL Server, Windows 2000

Confidential, NYC

Microstrategy Administrator/ Sr. Microstrategy Developer

Responsibilities:

• MicroStrategy reporting for multiple datawarehousing projects - Market Research, Weekly Data and Forest Sales Datawarehouse projects
• Interact with the users to gather requirements for reporting (Microstrategy) and data structure to load data using Informatica.
• Loading Weekly, Daily, and Monthly Data into fact tables for Market Research Team using macros and procedures. Loads used K Shells, PL SQL and Informatica
• Designed datawarehouse tables for efficient SQL generation and good performance using moderate normalization.
• Created Microstrategy hierarchies, metrics, advanced metrics (level metrics, non-aggregatable metrics, transformation metrics, conditional metrics, count metrics).
• Design and implement Microstrategy Schema objects. Created Microstrategy report objects.
• Created Microstrategy document objects, custom groups, filters etc. for reports.
• Creation of graph reports for different markets (AD, ARB, SSRI, Pain, Cold Cough etc) that contain Sales, Prescription data that are scheduled to execute weekly every Monday.
• Implemented Intelligence Server administration including backups of metadata.
• Moved Microstrategy objects using Object Manager within different iServers.
• Administration of performance using Microstrategy Enterprise Manager.
• Created Excel macro to process data files to required format. r
• Creation of Presentation Decks for Brand Team by updating the slides that contain Microstrategy report graphs and Microstrategy documents. These reports are presented to the CEO every Monday morning. Production support for these Presentation Decks.
• Analysis of Data when new products or families are introduced in the market.
• Performed Administrative tasks like Cache and Job monitoring, Database instance creation, user creation.
• Used Narrowcast Server to schedule reports, which have Excel information objects. Used Excel macros to "format" some of the data to meet user requirements.
• Trouble shooting (looking at the SQL generated for reports) and performance tuning using VLDB properties.
• Weekly Data project - Maintenance of reports and user group. Creation of Prescriber reports, Top 100 Prescribers, CP/ALC TRX, Mkt Shr by Decile LTD when new products are launched in market after getting user requirements every alternate month
• Forest Sales Datawarehouse - Maintenance of reports and user groups. Schedule Monthly Reports to be delivered to the user community.

Environment: MicroStrategy 7.5.3, NarrowCast Server, Oracle 9i, TOAD, PL SQL, MS - Excel, K Shell, Informatica 7.1, UNIX

Confidential, NJ

Microstrategy Administrator/ Sr. Microstrategy Developer

Responsibilities:

• The release includes IMS Monthly Xponent Rx data and Pharmagistics Call Activity data.
• Creation of users, user groups, security roles and object access. Created users (Home Office Analysts in Sales and Marketing Services) and Regional Managers.
• Created security filters for delivering reports to Region Name.
• Administrative tasks - Performed schedules to generate reports, idle and resume projects.
• Created hierarchies, metrics, advanced metrics (level metrics, non-aggregatable metrics, transformation metrics, conditional metrics, count metrics).
• Used Narrowcast Server to schedule reports, which have Excel information objects. Used Excel macros to "format" some of the data to meet user requirements.
• Created schema objects
• Created reports for Rx, Call Sample Detail, Alignment, Professionals. Reports such as Rx Trend Summary (Territory), Effort vs Result, Impact Report, Physician Profile Report, Sample Distribution Report, Target Physician Listing, Regional Call Activity Report and Activity Threshold Report.
• Trouble shooting and bug fixing of Phase I project.
• Loading data, created mappings and transformed data into fact tables using Informatica PowerCentre 7.1
• Data modelling of Phase II project for design of the project.
• Testing Phase II project

Environment: MicroStrategy 7.5, NarrowCast Server, SQL Server 2000, Informatica 7.1

Confidential, NJ

Microstrategy Administrator/ Sr. Microstrategy Developer

Responsibilities:

• Involved in designing the architecture of the application with other members of the team.
• Transferred business knowledge to teammates and trained teammates on Microstrategy.
• Installation of Intelligent Server, NarrowCast Server. Configuration of Web Server.
• Performed administrative tasks such as creation of metadata connectivity and database connectivity, security, Caching and Datamarts. Used MSTR Object Manager, Merge Manager, Project Merge, Web administration and VLDB Properties.
• Created security filters for delivering reports to US users and Puerto Rico users.
• Creation of users, user groups, security roles and object access.
• Performed schedules to generate reports, idle and resume projects.
• Migrated project from the Development to Staging to Production using Object Manager.
• Migrated reports built in MSTR 7.2.3 to MSTR 7.5
• Troubleshooting database errors in Microstrategy reports.
• Fine-tuned reports for faster performance using VLDB Properties and Report Data Options
• Created schema objects (attributes - for Time, Sales Organization, Reporting Division and Associate), facts related to Call Sample Detail and Sales reports.
• Created hierarchies, metrics, advanced metrics (level metrics, non-aggregatable metrics, transformation metrics, conditional metrics, count metrics).
• Created filters, prompts (Object prompt, Value prompt, Level prompt, filter definition prompt) for creation of microstrategy reports. Created drill to templates using template editor. Embedded templates in reports.
• Created reports for Call Sample Detail and Sales for all levels of Sales Team in AT, PC and Endo.
• Created documents containing reports and sub reports. Customized XSL to format sub reports to hide report links, page-by, metric headers and align all reports in the document.
• Created Custom Groups, Sub-totals based on metrics, used Pass-through functions like ApplySimple, ApplyComparison
• Designed reports using the schema and public objects.
• Created Intelligent cubes and Published reports on Microstrategy Web.
• Used Narrowcast Server to schedule reports, which have Excel information objects. Used Excel macros to "format" some of the data to meet user requirements.
• Provided users with the ability to subscribe to each report and specify the report frequency.
• Created reports with the ability to sort in ascending/descending order by all columns.
• Created reports with monthly, weekly and yearly frequency.
• Troubleshooting and fine-tuning.

Environment: MicroStrategy 7.5, MicroStrategy 7.2.3, NarrowCast Server, Oracle 9i, Informatica

Confidential, CA

MicroStrategy Administrator/ Sr. Microstrategy Developer

Responsibilities:

• Involved in designing the architecture of the application with other members of the team.
• Involved in evaluating guidelines and establishing the prescribed standards.
• Collating user requirements, business analysis, creating functional specs and delegating appropriate tasks to team members.
• Transferred business knowledge to teammates and rained team mates on Microstrategy.
• Configuration of MicroStrategy Intelligence Server and administration of the Intelligence Server (Start and Stop).
• Creation of Project Source, Projects under the Project Source.
• Establishment of Metadata and Warehouse connection
• Creation of Database Instance, Database Connection, Database Login and user connection mappings.
• Creation of users, user groups, security roles and object access.
• Administration of MicroStrategy Intelligence Server.
• Monitored Caching (object, element)
• Performed project duplication into two-tier using Project Duplication Wizard.
• Used Microstrategy Object Manager to move objects, copy objects, delete and rename objects.
• Administration of web users using MicroStrategy Web Administration.
• Created attributes, hierarchies, metrics, advanced metrics (level metrics, non-aggregatable metrics, transformation metrics, conditional metrics, count metrics).
• Created filters, prompts (Object prompt, Value prompt, Level prompt, filter definition prompt) for creation of microstrategy reports. Created drill down maps for reports.
• Fine-tuned reports for faster performance using VLDB Properties and Report Data Options
• Created Custom Groups, Sub-totals based on metrics, used Pass-through functions like ApplySimple, ApplyComparison
• Designed reports using the schema and public objects.
• Created Intelligent cubes and Published reports on Microstrategy Web.
• Used Narrowcast Server to schedule reports, which have Excel information objects. Used Excel macros to "format" some of the data to meet user requirements.
• Migrated from Microstrategy 7.2.1 to 7.2.3
• Provided users with the ability to subscribe to each report and specify the report frequency.
• Created reports with the ability to sort in ascending/descending order by all columns.
• Created reports with monthly, quarterly and yearly frequency.
• Create daily and monthly data loads, which also back tracks previous failed data loads.
• User and documentation.
• Troubleshooting and fine-tuning.

Environment: MicroStrategy Desktop 7.2.2, NarrowCast Server, Informatica

Confidential, CA

Sr. Web Developer

Responsibilities:

• Involved in evaluation of available reporting tools and selecting Microstrategy as the standard reporting tool for all Data warehousing projects.
• Involved in logical database design.
• Conducted for teammates on Microstrategy and Data warehousing concepts.
• Initial point of user contact for the implementation of Data Warehouse.
• Created System Design Document SDD from Business Requirement Document BRS.
• Translated business requirements into further development.
• Created Microstrategy data warehouse, fact tables and schema objects like attributes and hierarchies, metrics, advanced metrics, Create drill maps and drill paths for reports
• Created filters, prompts (Object / Value / Level prompt, filter definition prompt).
• Designed reports using the schema and public objects.
• Fine-tuned reports for faster performance using VLDB Properties and Report Data Options.
• Fine-tuned reports for faster performance.
• Published reports on Microstrategy Web.
• Used Narrowcast Server to run reports, which have Excel information objects.
• Used Administration tools like Object Manager, Cache Monitor.
• Create daily and monthly data loads, which also back tracks previous failed data loads.
• Extensive user interaction and, Fine Tuning and troubleshooting.

Environment: MicroStrategy Desktop 7.2.2, NarrowCast Server

Confidential, CA

Sr. Web Developer

Responsibilities:

• Involved in gathering business requirements., design document and Business Req. Specification.
• Involved in logical and physical design of the database using ERWin.
• Created ASP Pages for Admin - Threshold, Exception Analysis, BIN, MCC and State Maintenance.
• Implemented table driven security for Team Manager and team Members using ASP Pages.
• Generated ASP Pages to manage new requests, send Email notification to team members who were assigned requests. Reassign requests also notifies the new assignees.
• This Application uses Crystal to generate reports like Summary Reports, Team Member Load Reports, Open Requests, Closed Requests and various on the fly reports.
• Fully tested and implemented the website on Confidential intranet.
• Improved the performance of all stored procedures.
• Added new functionality using ASP Pages to search by Date Range
• ASP Pages that performs user login validation, ASP pages that perform search results for search criteria range for a Bid Name, Merchant Name, Industry type etc. parameters.
• Created ASP Pages to implement the Lookup for MCC, BIN, Merchant Category, and Fraud.
• Created ASP Page to manage security to access the Oasisweb website.
• Build ActiveX COM Objects for Database Access and Stored Procedure execution

Environment: Active Server Pages 2, Visual Basic V6.0, MS SQL Server V7.0, MS Access, Seagate Crystal Reports V7.0, Crystal Reports Web Server, and Windows NT 4