SUMMARY:

• A dynamic business intelligence professional who help execute project plan, deliver projects on time, mentor team and train business end users and also who thrives to build strategic BI platforms to fulfill business needs.
• 12 + years of working experience in different domains like Retail, Financial services, Health Care and Insurance and media.
• An extensive experience in the field of Information Technology with a wide - spectrum of experience in Relational Database, OLAP, Design and Development.
• Good understanding and sound knowledge in the concepts of Data Modeling, Data Warehouse and Data Marts.
• Key areas of expertise are requirements gathering, and requirements analysis, converting business requirements to functional and technical specifications, designing ETL processes, and dimensional modeling (Star / Snowflake schema) Architect Role .
• Experience on Onsite, offshore model Management/Coordination
• Specialized in MicroStrategy tool Suite (Architect, Desktop, Web, Intelligence Server, Narrowcast Server, MicroStrategy Mobile).
• Proficiency in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Solid experience in developing Static and Dynamic interactive Dashboards and Scorecards in the Flash mode using different kinds of widgets.
• Worked on MicroStrategy Mobile for iPhone and iPad.
• Experience in installing and configuring MicroStrategy Desktop, Web, Intelligence Servers, Mobile Server and Web servers.
• Experience on working with Object Manager, Command Manager, Integrity Manager and Enterprise Manager.
• Exposure to ETL methodology for supporting Data Extraction, Transformations and Load processing in a corporate-wide-ETL solution using ETL tools.
• Experience in Clustering of I-servers, Schedule Management, Cache Management, User Security and Performance Tuning.
• Performed various MicroStrategy Administration tasks like Installing, configuring, Upgrading, monitoring and tuning the MicroStrategy components.
• Setting up of user accounts, building security models and privileges, migration of objects from different environments, and performance monitoring of the MicroStrategy tool.
• Strong experience in working with large databases Oracle, Teradata, Sybase IQ/ASE, SQL Server and MySQL.
• Good experience with big data environment Hadoop: HDFS, Hive, impala and Hbase.
• Created proactive delivery reports and implemented the business intelligence solutions on the web using MicroStrategy Narrowcast Subscription Portal
• Configuring the servers including LDAP, I servers.
• Created MicroStrategy Narrowcast Services to deliver scheduled reports using Static and Dynamic Subscriptions.
• Proficient in writing complex SQL Queries, Stored Procedures, Views, Joins to implement the business logic.
• Exposure in implementing SDK Flex.
• Familiar with MicroStrategy SDK (Java Web Customization SDK (MSTR 9.x), Web/Web-services API, Intelligence Server API and Portal integration for MicroStrategy Customizations.
• Worked closely with Database team in creating control-M jobs to address batch cycle issues.
• Executing stored procedures and ddl, dml commands to update the database tables.
• Hands on experience in writing Test Plans and Test Cases for testing team.
• Strong experience in client interaction and understanding business application, business data flow and data relations from them.
• Trained different types of end users on MicroStrategy desktop and Web; supported huge number of users.
• Ability to work in multiple projects simultaneously and independently as well as in a team environment.
• Implemented Organization sales analysis reports, trend charts and dashboards using MicroStrategy Analytics.

AREAS OF EXPERTISE:

Business Intelligence: MicroStrategy 10.4/9.X,8.X Architect, Desktop, Web, MobileVisual Insight, SDK, Narrowcast Server, Object ManagerCommand Manager, Integrity Manager and Enterprise ManagerOBIEE 11g, BO (Universe, WEBI) 4

ETL Tools: SQL*loader, Informatica, DataStage.

Data Modeling: Embarcadero, Toad for Oracle, Erwin, ER diagrams

Web Servers: IIS6/5 Internet Information Services, WebSphere.

RDBMS: Oracle, Teradata, Sybase IQ/ASE, DB2, SQL Server.

Languages: SQL, PL/SQL, C, C++, JavaScript, HTML, XML, Shell Scripting.

Operating Systems: MS Windows 7/XP/NT, UNIX/LINUX.

EXPERIENCE:

Confidential, Fairfax, VA

Sr. BI Architect/Developer

Responsibilities:

• Worked as a Senior BI Architect and developer for the Open Payments project for client CMS through Confidential Federal.
• Working closely with client to gather BI report requirements, and performed Confidential Analysis and translate them to technical requirements. Design to implement different reporting functionality for Business end users.
• Addressed DataModeling issues using different data warehouse concepts like logical views, table aliasing etc.
• Implemented Star and snow flake schemas for OP Datamart.
• Worked on business data analysis, reconciling the data, built different key performance indicators and dimensions for better analysis to support variety of business decisions.
• Implemented variety of reports and dashboards that cover different cycles of the Open Payments project such as Registrations, Recertifications, Submissions, Review & Dispute and Delay in Publication.
• Creation of entire metadata with all kinds of semantic layer objects and reporting layer objects to construct extensive number of advanced analytics reports, datasets, report service documents, dashboards and visual analysis (VI dashboards).
• Creating, publishing, scheduling and tweaking report queries using different vldb settings to improve performance of reports and dashboards.
• Logged 508 compliance issues with MicroStrategy tech support.
• Participated in Backlog priorities, brainstorm sessions, defect review and code drop planning meetings.
• Implemented good number of Change Requests during my tenure at Confidential and interacted with all levels of members in the project.
• Utilized features like prompts, pivot tables, column selector and hierarchy.
• Strong Knowledge of all phases of Software Development Life Cycle (SDLC) such as Requirement Analysis, Design, Development, Testing, UAT, Implementation and Post Production support.

Environment: MicroStrategy 10.4 Product Suite, Oracle 12c, Informatica, Windows 7, UNIX, Toad, SVN and JIRA.

Confidential, North Brunswick, NJ

Business Intelligence Lead

Responsibilities:

• Worked as a BI Architect and Project Lead for the projects SecFiananceAnalytics and Funding & Liquidity Management.
• Responsible for planning, design, development and writing the solution specifications for all phases project implementation.
• Collaborated with all levels of users from executives to business users in gathering information for full application life cycle engagement.
• Responsible in creating and maintaining data models, schema manager, user management, integration, scalability/tuning, quality assurance and configuration management.
• Created Custom reports, KPIs and Dashboards using MicroStrategy reporting.
• Familiarity with Big Data / Hadoop integration to MicroStrategy.
• Used Hive, Impala and HUE big data tools.
• Responsible for trouble shooting and data model design changes.
• Responsible for Project planning, execution and time lines.
• Leading the project and mentoring team of developers and users. Supporting DW/ETL team to address data load and schema issues.
• Translating Business requirements into Functional and Technical specifications to fulfill Securities Lending business needs.
• Wrote end user manuals and trained users on the new Securities Finance Analytics application.
• Testing the application for user acceptance.

Environment: MicroStrategy 10.3/9.5.1 Product Suite, Informatica v10, Hadoop 2.x, SQL Server 2012, SSIS, SSRS, SSAS, Windows 7.

Confidential, Bristol, CT

Business Intelligence Lead

Responsibilities:

• Integrated BI systems for Programming and Prod-ops (Travel) divisions. Managed and mentored a team of developers.
• Worked on different kinds of data related to subject areas like ad-sales, programming, prod ops, talent, invoice and travel.
• Working closely with stake holders and Business end users to discuss and understand project, reporting requirements, data models and its functionality.
• Extensive experience in Star and snow flake schemas.
• Worked on Confidential analysis, design and creation of extensive number of adhoc reports, datasets, documents, dashboards using Attributes, Facts, Metrics, Filters, Transformations, Consolidations, Custom groups, different kinds of Prompts.
• Creating, publishing and scheduling Intelligence Cubes to improve performance of reports and dashboards. Used them as datasets for documents and dashboards.
• Analyzing reports and documents on an iPad and also creating reports and documents for iPhone and iPad.
• Worked on new features like Visual Insight, mobile capabilities.
• Performed all kinds of admin tasks installation of MicroStrategy suite, setting up user security, managing projects, configuring and connecting to intelligence server, Object Manager, Enterprise Manager, web and distribution services.
• Involved in the creation of Logical views with complex Queries against Data Warehouse to address data modeling issues.
• Utilized all MicroStrategy tools like DBquery, connectivity wizard, ODBC administrator data sources etc.
• Worked extensively in maintaining development, QA, production environments and worked on creation of packages and Dev, QA, production migration activities using Object Manager.

Environment: MicroStrategy 9.4.1/9.3.1 Product Suite, BO (Universe, WEBI), Oracle 11g, BODI, Golden Gate, Windows 7, Linux and Toad.

Confidential, Merrimack, NH

Sr. BI Consultant

Responsibilities:

• Worked in complex environment where high volume, velocity, variety of data going exponentially, addressed grand analytics challenges.
• Working closely with clients and Business end users to discuss and understand project, reporting requirements, data models and its functionality.
• Extensive experience in Data Modeling.
• Designed and created extensive number of reports, documents, interactive dashboards using Schema and Application Objects.
• Creating Intelligence Cubes and publishing them for better performance. Also worked on Sql Certification, change logs. Attending object review/change log meetings.
• Worked on design and development of Scorecards to display graphical indicators like trends, indicators etc that visually convey the performance of business.
• Performed all kinds of admin tasks installation of MicroStrategy suite, setting up user security, managing projects, configuring and connecting to intelligence server, Object Manager, Enterprise Manager, web and Narrowcast server for report delivery.
• Worked on creation of DB instances, project configuration and multi sourcing etc.
• Worked report and document performance improvement techniques.
• Participated in discussions and training sessions with end users before and after release to UAT and implemented different enhancements, new changes and requirements.
• Performed Unit testing and regression testing of reports during development and also after migrations.

Environment: MicroStrategy 9.2.1/9.3.1 Product Suite (Architect, Desktop, Object Manager, Enterprise Manager, Narrowcast Server, Command Manager, Web), MicroStrategy Mobile (iphone, ipad), OBIEE 11g, Sybase IQ & ASE 15, Oracle 11g, Informatica 9.0.1, Windows 7, UNIX and Toad.

Confidential, San Francisco, CA

Sr. MicroStrategy Consultant

Responsibilities:

• Worked in Agile environment, involved in lot of brainstorming sessions and scrum meetings with the Product Managers, development and testing teams.
• Involved in the meetings with clients and Business Users to discuss and understand development, staging and production environment of the project.
• Extensive experience in dimensional modeling (Star / Snowflake schema).
• Designed and created Adhoc and report builders using Schema and Public Objects.
• Implemented sales related metrics like Revenue, Revenue (Previous Quarter), Revenue by Sales Representative, Revenue (Region filtered), lost opportunities, Wins vs competitor and % Contribution to Total Revenue metrics.
• Creating Intelligence Cubes and publishing them for better performance.
• Extensive knowledge in creating Dynamic Enterprise Dashboards using different controls, attribute selectors, metric selectors, panel selectors, sliders, widgets and utilized the new features to convert the Dashboards into Flash mode, and also incorporated Dashboards with linking (Hyperlinks, edit links), drilling capabilities, filtering, slicing.
• Worked on design, developing, maintaining and integrating wide variety of Scorecards to enable the associates to measure their monthly/annual performance.
• Analyzing reports and documents on an iPad and also creating reports and documents for iPhone and iPad
• Worked on creation of LDAP filters using LDAP attributes for different user logins like Regional Managers, Store Managers etc. using OPR NBR, Parent OPR NBRs based on locations like EU, USA, China.
• Involved in the creation of Logical views with complex Queries against Data Warehouse.
• Maintained report caches and access control lists.
• Participated in review sessions with Product Managers if there are any new or change of requirements, getting sign-off and communicating with the technical teams regarding all changes or modifications.
• Worked extensively in maintaining production and worked on production migration activities using Object Manager.
• Involved in MSTR upgrade process from 9.0.2 to 9.2.1.
• Involved in comparison of reports from 9.0.2 to 9.2.1 by using Integrity Manager.

Environment: MicroStrategy 9.2.1/9.0.2 Product Suite, TeradataV2R6, Oracle 10g, DB2, DataStage, Informatica 8.6.1, Windows NT, UNIX and Toad.

Confidential, Jersey City, NJ

Sr. MicroStrategy Consultant

Responsibilities:

• Gathering requirements from Business Users and product managers to design and translated those requirements into a technical solution to generate reports using Software Development Life Cycle.
• Good knowledge in data modeling, logical and physical models.
• Implemented MicroStrategy security/object sharing (Security Model).
• Excelled in setting up the whole MicroStrategy environment from the scratch Starting from the I-Server installation till the project roll-out to the users .
• Created all the Schema objects, Application objects and also defined the Attribute relationships.
• Designed and created Adhoc and canned reports using Attributes, Facts, Metrics, Filters, Transformations, Consolidations, Custom groups, Prompts and Cascaded Prompts.
• Used OLAP functions like Break by, Sort by, Running Sum etc. to implement Transformations and variances on Dashboards and used Apply Simple and Apply Comparison functions to develop Attributes, Advanced Filters and Transformations.
• Created different kinds of Dashboards and documents using different controls, selectors, sliders, and widgets to view in different kinds of modes like DHTML, Flash mode. Worked on different document modes like design, editable mode, and interactive modes.
• Design and development of Business Scorecards with different KPIs.
• Created projects, administered user accounts, managed privileges, ACLs and security roles.
• Involved in development of Freeform SQL report with SQL Queries in MicroStrategy desktop.
• Worked on SQL scripts against the different databases and used the Query tool to test the data of the reports.
• Responsible for Narrowcast service creation (static and dynamic subscription sets), schedules, and other tasks related to Narrowcast.
• Assisted the DBA’s and the ETL architects to design and create Tables in the SQL server database to improve the performance of reports.
• Participated in review, sign-off and communication of all changes or modifications to reports

Environment: MicroStrategy 9.0.2 Product Suite, Teradata, SQL Server 2008, Informatica, Windows NT, UNIX and Toad.

Confidential, Greenwood Village, CO

Sr. MicroStrategy Consultant

Responsibilities:

• Reviewing business and functional requirements for various modules so as to have better understanding of the overall application.
• Involved in Dimensional Data Modeling (Snow-Flake schema) Data Architecture, Business and Data Analysis.
• Involved in Configuration of intelligence server and Upgradation of Metadata using Configuration wizard.
• Involved creation new ODBC connection to Metadata base using Connectivity Wizard.
• Involved in designing of Schema Objects like Attributes, Facts, Hierarchies and Transformations from data warehouse.
• Implemented pipeline metrics like %Quota Achieved (Current), Opportunity Size (current), Projection vs Quota and %Quota Achieved vs Revenue Projection.
• Worked on the development of Public Objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Reports on top of the Schema Objects.
• Creating Dashboard Reports, RS Documents to view personalized reports based on user requirements.
• Involved in setting of VLDB properties at report and metric levels to define Outer joins between tables to get complete data from the required table and used different Query Optimization settings specific to database to improve performance of Query.
• Involved in creation of Services using Subscription sets, Schedules, Device, Locale and Information objects.
• Involved in creation of User/User groups and assigning Privileges them the User Manager using administration.
• Involved in development of Reports against Intelligent Cubes which involves faster execution of query compare to the data warehouse.
• Coordinate with DBAs and the ETL architects to design and create Tables in the SQL server database to improve the performance of reports.
• Provided post production support to end users.

Environment: MicroStrategy 9.0.1 Product Suite (Architect, Desktop, Object Manager, Enterprise Manager, Narrowcast Server, Web, Mobile), TeradataV2R5, Oracle 10GR2, DataStage, Toad.

Confidential, Silver Spring, MD

Sr. MicroStrategy Consultant

Responsibilities:

• Data requirements gathering, design, prioritized business goals and information needs.
• Sound experience in data modeling, logical data model, physical data model.
• Designed and created reports using Attributes, Facts, Metrics, Filters, Consolidations, Custom groups and Prompts.
• Worked on Advanced reporting objects creation Advanced metrics, Advanced filters .
• Create transformations to-do time series analysis and to compare the values at different times such as sales at this year versus last year, or month-to-date.
• Extended facts, to generate advanced reports as needed by the business user using the Level Extension option
• Worked closely with the MicroStrategy Admin teams during the project migrations and fixing the metadata issues and also in configuring the governing settings at the project level and on Intelligence server
• Created Static and Dynamic Enterprise Dashboards with wide variety of interactive features.
• Implemented wide variety of Dashboard data visualizations like Gauges, Funnels, and Graphs etc.
• Worked on customizing SQL by changing the VLDB properties, reducing the number of SQL passes to improve the report performance.
• Prepared personalized reports to end-users by including page-by and thresholds.
• Conducted Data validation testing to ensure data quality using Integrity Manager.
• Involved in preparing the Unit Test cases and Test Plans for the Reports Developed.
• Managed to be the point of contact for the whole MicroStrartegy setup during the Server upgrade process.
• Experience in migrating MSTR environments between DB platforms i.e., Oracle to SQL server.

Environment: MicroStrategy 9.0.1/8.1 Product Suite (Architect, Desktop, Object Manager, Enterprise Manager, Narrowcast Server, Web, Mobile), DB2, LDAP Server (Sun One Directory Server 5.2), Toad.

Confidential, Delray Beach, FL

MicroStrategy Architect/Developer

Responsibilities:

• Interacted with the business users to gather requirements and translated those requirements into a technical solution to generate reports.
• Developed logical models, building hierarchies, attributes and facts, extracting tables from warehouse.
• Architected and performed the report development for the MicroStrategy projects by creating the schema objects such as facts, attributes, hierarchies and public objects such as reports, filters, metrics and templates using Desktop to meet report requirements.
• Used analytical and governing settings in VLDB properties to tune the SQL and metrics involving nulls and zeroes.
• Used several new controls for Dashboards like time series slider, radio buttons, and drop down menus for the flash version of the dashboards in 8.1.
• Worked with DBA to identify and fine tune long running SQL.
• Extensive experienced in MicroStrategy report services Document.
• Used Advance Prompts, transformation metrics and level metrics for creating complex reports.
• Used MicroStrategy Office to connect Microsoft Excel through MicroStrategy Intelligence Server.
• Used the Enterprise Manager to create and produce statistic report to optimize the MicroStrategy system.
• Extensively used Object Manager to move objects from Development to Test & Production Environment.
• Compared and verified the consistency of reports as changes are made to the BI ecosystem using Integrity Manager.

Environment: MicroStrategy 8.1/8.0 (Architect, Desktop, Web, Dynamic Dashboards, MicroStrategy Intelligence Server, Narrowcast Server, Object Manager, Enterprise Manager), Netezza, Oracle, Windows XP/2000

Confidential, Charlotte, NC

MicroStrategy Consultant

Responsibilities:

• Worked closely with customers and other team members to understand and prioritize business goals and information needs
• Assisted Administration team during the project migrations to various environments using the MicroStrategy Object Manager.
• Designed and created reports using Attributes, Facts, Metrics, Filters, Consolidations, Custom groups and Prompts.
• Extensively worked in designing and developing Interactive Scorecards and Dashboards according to Business Requirements.(Developed over 80 RSD’s)
• Developed Freeform SQL repots with Prompts, Drill down and using stored procedures
• Use Drill maps in the project to allow the documents drilling from one level to another both drill up and drill down.
• Created Transformations (table based, formula based) for using in comparative reports to compare this year to last year performance
• Developed MicroStrategy metadata and metrics to support new reporting requirements.
• Created users, roles, privileges and groups and assigned access to the MicroStrategy projects
• Conducted Data validation testing to ensure data quality.
• Handled development of multiple projects at the same time.
• Prepared Unit Test cases and Test Plans for the Reports Developed.

Environment: MicroStrategy 8.0.2 Product Suite (Architect, Desktop, Object Manager, Enterprise Manager, Web), Oracle 9i, SQL Server 2005, Informatica, Toad, HTML & DHTML, Windows NT.