PROFESSIONAL SUMMARY:

• Over 8+ years of experience in Design, Development, Testing and Implementation of Business Intelligence, Database & Client/Server applications.
• 5+ years of experience with Cognos BI (Report Studio, Query Studio, Analysis Studio, Event Studio, Framework Manager, Power Play Transformer)
• 3+ years of experience in Micro Strategy tool Suite (Administration, Architect, Desktop, Web, Intelligence Server, Narrowcast Server, Micro Strategy Mobile).
• Good understanding of Data Modelling & Data Warehouse concepts with good experience in Dimensional Modelling (Star/Snow Flake schema).
• Good experience (5+) in Onsite - Offshore Model (Co-ordination & Management)
• Expertise in creating Relational, Dimensionally Modelled Relational (DMR) & Multi-Dimensional (Cubes) Models using Cognos Framework Manager & Power Play Transformer.
• Proficiency in creating and integrating Micro Strategy 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 in the Flash mode using different kinds of widgets.
• Experience on working with Object Manager, Command Manager, Integrity Manager and Enterprise Manager.
• Setting up of user accounts, building security models and privileges, migration of objects from different environments, and performance monitoring of the Micro Strategy tool.
• Expertise in creating complex reports like Executive Dashboards, KPI reports, Flash reports, Drill-through reports, Top ten reports and Score card reports using Cognos/Microstrategy.
• Performed various Micro Strategy Administration tasks like Intelligence Server Administration, Configuration of Memory settings, Performance Monitoring, Assigning Privileges and Job Monitoring etc.
• Good understanding with ETL (Data Extraction, Transformation and Loading) process.
• Extensively worked with multiple databases like Oracle, SQL Server, MS Access and Teradata.
• Performed Business Analysis in various aspects while initiating and developing the technical requirements.
• Efficient in Optimizing, Debugging and testing SQL queries.
• Trained Corporate and Divisional users on Cognos & Micro strategy Products.
• Strong knowledge of Software Development Life Cycle (SDLC) methodologies and standards.
• Ability to work on multiple projects simultaneously and independently as well as in a team environment and effectively meet project deliverables on time.
• Possess excellent Communication & Interpersonal skills. Technically sound, Result-Oriented with strong Problem Solving skills.

TECHNICAL SKILLS:

Business Intelligence Tools: Cognos Report Studio, Query Studio, Analysis Studio, Framework Manager), Cognos 7 Series Impromptu, Power Play, Transformer, Microstrategy 9.x/8.x (Desktop, Administrator, Architect, Narrowcast Server, Intelligence Server, Web and Enterprise Manager), Oracle 10g, Erwin, Windows, UNIX

Data Modelling: Erwin 4.0/3.5, Sybase Power Designer

Databases: Oracle 9i, 10g, MS SQL Server, Teradata, DB2, MS Access

Languages/Web Technologies: Java 2.0, J2EE, SQL, PL/SQL, UNIX Shell Script, HTML, JSP, XML

Tools: Toad, SQL* Loader, Serena Dimensions, VSS, Teradata SQL Assistant, Track-it, SQL Developer & HP Quality Centre, Jira, Remedy, HP Service manager, Service now.

Operating Systems: Windows 2003 Server, Windows NT, Sun Solaris and UNIX.

PROFESSIONAL EXPERIENCE

Confidential - San Francisco, CA

BI Consultant

Responsibilities:

• Day to day interaction with End users and gather the requirements based on their needs.
• Translating the requirements into Detailed Architecture and Design documents.
• Lead team of developers (onsite & offshore) in the delivery of technical systems and components.
• Performed Administration tasks, like User Creation, Session Handling, Creating Security roles, Analysing Report performance, administered all aspects of web and intelligence server and Narrowcast Server.
• 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 (MicroStrategy).
• Involved in creation of Compound metric, Derived Metric, Filter Metric and Transformation metric to generate more complex MicroStrategy reports in an efficient way.
• Involving the reporting analysis, design and development.
• Involved in design & development of Dimensionally Modelled Relational & Relational models using Cognos Framework Manager and published the packages for Adhoc reporting.
• Involved in creating multiple reports like: Executive Dashboard, Store Dashboard, Ranking reports, and Daily/Weekly Flash sales report using List, crosstab and chart report using Cognos & Micro strategy.
• Extensively worked with Micro Strategy Intelligence Server, Micro Strategy Web and Micro Strategy Administrator reporting basics using Micro Strategy Desktop and Micro Strategy Web.
• Extensively worked with Command Manager to execute user create/delete scripts.
• Expertise in creating dimensional cubes using Power Play Transformer.
• Maintained all Cognos reports in Serena Dimensions for version mechanism.
• Effectively involved in migrating the objects to different environments.
• Involved in Data Validation to ensure data quality.
• Provided extensive training to end users, how to use the Dashboard reports in Cognos & Microstrategy.

Environment: Cognos 8.X/10.x (Framework Manager, Report Studio, Query Studio), Transformer 7.4, Serena Dimensions, Micro strategy 9.X.1(Desktop, Web, Administrator, Command Manager), ORACLE 9i/10g, Teradata, Teradata SQL Assistant 7.2, IBM AIX.

Confidential, Irving, TX

MicrostrategyConsultant

Responsibilities:

• Upgraded the environment from 9.2.1m to 9.3 and to 9.4.1 (Clustered Intelligent Servers, Narrowcast server, Web Server, Mobile Server and EM Console) in multiple environments.
• Setting up the Security at iServer (Roles, Users, Groups, Folders, MD filters), Narrowcast server, History list database,
• Configuring iServers in clusters, metadata upgrade, backup and restoration
• Creation of project source, projects, loading and unloading of projects,
• Creation and maintenance of Control-M jobs and scripts and batch monitoring
• Migration of objects between the environments using Object Manager using packages
• Integrity testing using Integrity Manager between projects and objects.
• Interacting with Microstrategy support team for licensing the products, log analysis, case management, Diagnostics tool etc.
• Hands on knowledge on performance counters and monitors on the iServer using the diagnostic and Performance monitor.
• Setting up events, schedules, subscriptions for users and between users using Command Manager Scripts and Procedures
• Business requirement gathering and participating in the integrity review meetings with the users,
• Working with offshore team to get the development work done during offshore timings
• Creating multiple schema objects like logical tables, Attributes, Prompts, Hierarchies and Facts,
• Creation of intelligent cubes and generating schedules,
• Setting up mobile server connections and working with mobile developers,
• Worked in converting the existing reports to mobile platform,
• Developing Application Objects (filters, metrics, prompts, Custom Groups, Consolidations, Templates, Drill Maps) to Build Documents and reports,
• VLDB settings to modify data returned from the report like NULL value display, modifying join types, Cross Join Warning and optimizing SQL Queries etc,
• Creation of Advanced filters using Apply (passthrough) functions. (Apply Simple and Apply Comparison),
• Creation of cubes and scheduling the refreshes and generating reports based on cubes,
• Worked extensively in the creation of documents and dashboards using Visual Insights and widgets.

Environment:MicroStrategy9.2.1m/9.3/9.4.1 Desktop, Web,MicroStrategyClustered Intelligence Server, Narrowcast and Distribution Services, Netezza, Datastage, Oracle, WinSql, SQL Developer

Confidential, New York City, NY

MicrostrategyConsultant

Responsibilities:

• 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 (MicroStrategy).
• Involved in creation of Compound metric, Derived Metric, Filter Metric and Transformation metric to generate more complex MicroStrategy reports in an efficient way.
• Involving the reporting analysis, design and development.
• Setting up events, schedules, subscriptions for users and between users using Command Manager Scripts and Procedures
• Developing Application Objects (filters, metrics, prompts, Custom Groups, Consolidations, Templates, Drill Maps) to Build Documents and reports,
• VLDB settings to modify data returned from the report like NULL value display, modifying join types, Cross Join Warning and optimizing SQL Queries etc,
• Extensively worked with Micro Strategy Intelligence Server, Micro Strategy Web and Micro Strategy Administrator reporting basics using Micro Strategy Desktop and Micro Strategy Web
• Created logical views in MicroStrategy for complex report creations situations.
• Designed and developed several Intelligent Cubes and its incremental refresh design, defining incremental refresh rules, Cube maintenance and support etc.
• Creation of Advanced filters using Apply (pass through) functions.
• Tested and validated all the reports by running queries against the warehouse. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Worked no mobile BI platform

Environment:MicroStrategy9.2.1m/9.3 Desktop, Web,MicroStrategyClustered Intelligence Server, Narrowcast and Distribution Services, Teradata, Datastage, Oracle, Toad, SQL Developer

Confidential

Micro StrategyConsultant

Responsibilities:

• Created Complex reports and dashboards for Pricing Analytics Team with the drill down methodology in all options.
• Involved in developing MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and widgets like micro charts, time series slider, fish eye, radio boxes, Gauges.
• Enhanced existing dashboards and scorecards using KPIs and enabling drill functionality.
• Implement OLAP functionality within report service documents to enhance performance.
• Created mockup versions of dashboards and presented to the stake holders to make sure it was effective on usability perspective.
• Tested and validated all the reports by running queries against the warehouse. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Built and optimized intelligent cubes for the Visual Insights Tool in MSTR 9.2.1 by configuring working memory set, working memory and VLDB properties.
• Created customized Custom Groups with complex filters and Relationship filters.
• Created Metrics, Prompts, Filters, Custom Groups and Transformations for the report development.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations.
• Fixed Defects and performed upgrades for existing projects.
• Ensured proper relationships were established between the attributes to avoid any improper SQL query joins.
• Worked extensively with the compliance officer to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Created logical views in MicroStrategy for complex report creations situations.
• Designed and developed several Intelligent Cubes and its incremental refresh design, defining incremental refresh rules, Cube maintenance and support etc.
• Planning and Design Narrowcast development
• Service development Debugging service failure
• Automation of event based service execution
• Narrowcast Design and test case document

Environment:MicroStrategySuit 9.2.1, Narrowcast Server, Teradata V2R12/13, Teradata SQL Assistant 12, Windows 8.

Confidential

Sr. Cognos BI Consultant

Responsibilities:

• Interacted with Business Users to gather Business Process Requirements.
• Effectively involved in Enterprise reporting design, estimation and development.
• Designed and Implemented data cubes using Cognos Power Play Transformer for end user reporting.
• Designed Framework Manager Projects, Model (DMR, Relational) & Packages, Importing the metadata from the Data Source tables, Views, Data Marts and Macros.
• Created different kind of reports like: Executive Dashboard, Store Dashboard, Ranking reports, and Daily/ Weekly Flash sales report using List, crosstab and chart report.
• Designed and created reports using Attributes, Facts, Metrics, Filters, Consolidations, Custom groups and Prompts (Micro Strategy).
• 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 (Micro Strategy).
• worked closely with the Micro Strategy 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
• Involved in moving the objects between two projects and two different environments by using Object Manager and merging the projects by using Project Merge Wizard.
• Tested all the reports with Cognos Generated SQL and manual SQL using SQL Assistant.
• Tracking of defects and Quality Centre and reassigning back to Quality Analyst.
• Provided extensive training to end users, how to use the Dashboard reports in Cognos 8.

Environment: Cognos 8.2/8.4 (Framework Manager, Report Studio, Query Studio,), Transformer 7.4,Microstrategy (Desktop & Web), ORACLE 9i/10g, Teradata, Teradata SQL Assistant 7.2, IBM AIX.

Confidential

Cognos BI Consultant

Responsibilities:

• Participated in Enterprise reporting Project Design, Estimation and development.
• Installed, Configured and Deployed Report Net &Cognos 8 on NT and Unix (AIX) environments.
• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogues into the Framework Manager.
• Designed and Developed Projects, Packages, Reports using Framework Manager and Report Studio.
• Created Dashboards and Scorecards using Metric Studio.
• Setting up of the Audit logs for monitoring the usage of reports.
• Created and Manipulated Impromptu catalogues and Created reports for Corridor Application.
• Designed and developed multi-dimensional cubes and implemented security in cubes.
• Published Power play cubes to PPES.
• Enhanced existing power cubes to add dimensions, measures as per the user requirements.
• Maintained Security at Query Subject as well as Query Item level for labour cost views.
• Worked with Cognos Customer Support to address problems and resolve problems.

Environment: Cognos 8, ORACLE 9i/10g, SQL Server 2000, TOAD 7.2, Windows 2003Server, Power Play Transformer, Power Play, Power Play Enterprise Server.