Manager Sales

PAVAN KUMAR V

MOBILE: +1-574-***-****

Email ******.**@*****.***

Experience Summary

Cognos professional with over 7.5 years of experience in data warehousing and architecture level of experience in cognos.

Expert on cognos BI suite (Framework Manager and All studios).

Good knowledge on BI tools and visualization tools like SAP BO, SSRS, Tableau and Qlikview.

Lead the team in Application maintenance and support or enhance and in Cognos Development.

Rich experience in DMR and Multidimensional modeling.

Experience in Cognos 8, 10 installation and administration.

Installed cognos 10.1 and 10.2 in distributed environment.

Performed Cognos environment capacity planning and capacity utilization estimation.

Performed Cognos servers Performance Tuning and Cognos Query Tuning.

Monitoring Cognos System performance metrics such as Session Metrics, Queue Metrics, JVM Metrics and Request Metrics.

Experience in 24/7 monitoring of Cognos.

Solving PMR’s.

Raising PMR’s with IBM and coordinating to resolve issues.

Monitored multiple cognos environments.

Installed powerplay server.

Integrated cognos with Salesforce.

Used Mapinfo Professional 11.5 with cognos.

Integrated cognos 10 with SharePoint.

Good Knowledge of Dynamic Cubes and Cognos DQM.

Exposure to Cognos CAFÉ.

Experience with Cognos SDK.

Experience in developing dashboards viz sales, inventory and operational.

Sound Knowledge in Data Warehousing concepts, techniques and methodologies.

Strong understanding of Kimball & Inmon approaches.

Strong knowledge in Frame work manager for creating models, folders, filters and publishing packages of both relational and multidimensional types.

Experience in developing reports with html and JavaScript.

Experience in developing interactive repots.

Experience in TM1 prospective, server explorer, TM1 web, TM1 Executive Viewer, TM1 cubes, rules, turbo integrator, subsets and Excel/worksheets.

Worked with cubes in cube viewer, server explorer, Excel In-Spreadsheet browser and TM1 Web.

Experience in building cubes and cube groups through transformer along with security.

Extensive experience in TM1 Administration part like creating users, groups and assigning them permissions.

Experience in design and development of Cubes and dimensions in TM1 through TI process.

Built dimensions from SQL and built cubes.

Created TI process to replicate the data between different servers and automated data upload process.

Good Experience in understanding business applications, business dataflow and data Relation.

Experienced in Data Mart, Star Schema, Snowflake Schema, Data Requirement Analysis, Design, Development, Testing, Documenting and Implementation of Business Applications.

Knowledge of building of dimensions and cubes in TM1.

Experience with operational reporting, including KPIs, SLAs.

Experience in Agile development.

Good knowledge in data stage, informatica and pentaho kettle ETL tool.

Good team player with excellent interpersonal and communication skills.

Developed and submitted POC for Marketing Analytics.

Submitted a POC on connecting with salesforce through cognos DQM.

Experience in Supply Chain Analytics.

Developed cognos dynamic cubes.

Used dynamic query analyzer for analyzing dynamic cubes.

Worked on traditional databases like Oracle, SQL Server 2008 and 2012 and Sybase.

Hands on Tableau Desktop and Qlikview.

Certifications:

IBM certified metadata OLAP developer.

IBM Certified TM1 developer.

ITIL Foundation Certified.

Skills

Data warehouse: Cognos 8.3, 8.4, 10 versions BI (Frame Work Manager, Report Studio, Analysis Studio), Cognos TM1 9.4, Informatica, Tableau, Cognos Powerplay

Database : Sybase, Oracle 10g

Language : R, C, HTML, ASP 3.0, Java script

OS : Windows, UNIX

Other Tools : BMC Remedy, SnagIT, FileZilla

EXPERIENCE HIGHLIGHTS

Zimmer, Warsaw, IN Sept 2013 to till date

Role: Cognos Admin/Lead

Project: AMS (Application Maintenance and Support)

Environment : Cognos 10.2, Oracle11g, Sybase, Sybase Central, Windows 2000, Framework Manager, Transformer, TM1

Zimmer, world leader in muscular- skeletal health implants manufacturing. Creator of innovative and personalized joint replacements. Head quartered in USA. It is one of the world’s largest life science companies measured by revenues and has operations in different countries. The Purpose of the project was to maintain and support cognos environment. To implement enhancements in small projects and change requests.

Roles and Responsibilities:

Managing teams and deliverables.

Understanding the business requirements and designing applications to meet their needs.

Requirement gathering for new enhancements requests and projects.

Understanding of business flow and analysis of requirements.

Designing the high level and low level design documents.

Assigning the requirements to team members and closely working with team.

Handling multiple projects which include development and support activities.

Followed Agile development process.

Integrated cognos with SharePoint 2010.

Prepared POC’s for advanced business analytics such as CRM analytics, predictive analytics.

24/7 monitoring of cognos.

Solving PMR’s.

Designed cubes and cube groups with security.

SPOC and COE for cognos in Zimmer.

24/7 monitoring of Cognos.

Monitoring multiple cognos environments.

Built a cube monitoring system in Java which monitors when and triggers the cube building based on database updates.

Installing new versions of cognos and patches in sandbox server.

Installed cognos powerplay server.

Co- coordinating with database and ETL team to design the tables required for reporting.

Showcase the capabilities of cognos to leverage in different departments like operations, Finance, Quality and Audit teams.

Design and suggest requirements for the clients.

Created an optimized process for field inventory optimization which saved 1 million dollars for the company.

Installing and testing new cognos versions or fix packs or functionalities in sandbox server.

Designing and creating Complex dashboards.

Design of Active reports.

Designed and developed DMR models.

Created summary tables and procedures in oracle.

Created dashboards in cognos and published to SharePoint using Queryvision and created cognos webparts for the same.

Review and approve offshore code changes that are implemented as a part of releases or support activities.

Provide training to users on workspace and workspace advanced.

Design and build successful technical solutions that involve TM1 cubes, dimensions, TI processes, rules, and executing the completion of the TM1 architecture per project.

Edit/create rules while utilizing Turbo Integrator.

Involved in updating the Line items in the dimensions, deleting any unnecessary items.

Maintenance and support of TM1 global and regional servers.

Installed cognos office and CAFÉ.

Designed and created a dashboard for TIBCO logs data which shows real time transactions.

Involved in design and development of TM1 cubes.

Wrote rules for calculating KPI’s such as margin, COGs and Sales.

Created TI process to import data monthly from Sybase and Oracle to build dimensions and cubes.

Used TM1 Perspectives to make changes in dimensions with XDI files.

Used Perspectives to insert and retrieve data.

Used Perspectives to prepare reports from cubes.

Used TM1 Architect for checking message, Transaction and audit logs.

Submitted a POC on connecting with salesforce through cognos DQM.

Developed cognos dynamic cubes.

Used dynamic query analyzer for analyzing dynamic cubes.

Zimmer, Gurgaon, India Jan 2013 to Sept 2013

Role: Cognos Lead Developer

Project: OLAP Cube Migration

Environment : Oracle 11g, Sybase, Sybase Central, Windows, Framework Manager, Transformer, TM1

The Purpose of the project was to upgrade cubes which are building in cognos 7 to cognos 10. Zimmer has several cubes for sales admin, distributors and managers. Each group uses these cubes for daily sales reporting and tracking. These are mission critical cubes. This project includes migration of cubes and automation cube building process. The cubes are daily, weekly and monthly cubes for all segments of zimmer.

Roles and Responsibilities:

Understanding the business requirements and designing applications to meet their needs.

Interacting with customer for requirement gathering.

Understanding business flow and analysis of requirements.

Co-ordinated with ETL team to design sales and inventory datamarts on Ralph Kimball’s bottom up approach.

Built and migrated cubes from cognos 7 to 10.

Built complex cubes and cube groups with transformer.

Created custom views in cubes to implement security.

Created a cube building and monitoring process with the help of Java.

Automate bulk cube posting process to Livelink and shared drive with the help of Autosys.

Developed dashboards based on Cognos OLAP cubes.

Tuned performance of the SQL queries to optimize cube building process.

Wrote SQL procedures to create summary tables.

Handled Security issues including providing authentication and granting users access to data and permission to perform activities on the data based on their sign on identity.

Working with the users, Analyzing, design and plan Reports.

Involved in development and maintenance of cubes in TM1.

Performed Admin tasks like Creating Users and assigning Permissions.

Process the Turbo Integrator by manipulating cubes, views, dimensions, elements, and other TM1 objects while importing data.

Created new Cubes and Dimensions manually, using dimension worksheets and also using Turbo Integrator.

Involved in the Cognos administration like creating new data source connections, handling the deployment of reports from development to production server and responsible for troubleshooting Cognos BI Server issues.

Wrote procedures and created summary tables.

Created Active Reports which provide an interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.

Creating TM1 Turbo Loader processes for populating TM1 cubes from source data.

Used TM1 architect to grant/revoke access.

Handled security from TM1 Architect.

Handled global and regional servers from TM1 Architect.

Edited dimensions with dimension editor in TM1 architect.

Zimmer, Gurgaon, India Jul 2012 to Dec 2012

Role: Cognos Lead Developer

Project: Cognos Migration, Installation and Up gradation

Environment : Cognos 8.4, Oracle11g, Sybase, Sybase Central, Windows, Framework Manager, Transformer, SnagIt, Impromptu

The Purpose of the project was to upgrade impromptu reports to cognos 10. Install cognos 10.1 and upgrade from cognos 8.4 to 10.1 in zimmer. To apply fix packs if needed. Validate all reports and catalogs in cognos after upgrade.

Roles and Responsibilities:

Installed Cognos Migration Utility.

Migrated Cognos Impromptu imr reports, catalogs to cognos 8.4.

Performed Cognos Capacity Planning estimation.

Installed Cognos 10.1.1 in distributed environment.

Upgraded from Cognos 8.4 to 10.1

Migrated entire content store from 8.4 to 10.1

Tested 10.1.1 reports using Cognos Life Cycle Manager.

Deployed reports directly to user’s My Folder.

Installed cognos virtual view manager to connect SFDC with cognos.

Connected SFDC with Cognos 10.2.1

Configured Audit reports and created new reports based out of audit package.

Created new data source connections to different databases.

Integrated cognos with Active Directory.

Configured content manager server, backup content manager, dispatcher servers and web servers on windows 2008 R2.

Installed cognos 10 mobile on the top of existing cognos 10.2 environments.

Configured cognos servers with Active Directory.

Configured data warehouse connections with cognos and configured content manager data source connections.

Configured SMTP server with cognos.

24/7 monitoring of cognos.

Solving PMR’s.

Configured webservers on IIS 7 with application pools and isapi configuration.

Configured cognos webservers on different ports, one with single sign on and other without.

Created cognos mobile URL, a URL for intranet users and internet users.

Migrated imr reports and impromptu catalog files with UNIX scripts thereafter imported them to cognos 8.4.

Tested and applied fix packs in cognos 10.2 environment.

Created installation and configuration procedure documents.

Co-ordinated with end users after migrating from cognos 8.4 to 10.2 regarding reports in their My Folders.

Monitoring and restarting cognos servers and services.

Installed and configured cognos Framework manager, Transformer and Powerplay.

Developed load balancing technique for dispatcher servers.

Created capacity utilization and load estimation on cognos environment documents before installing cognos.

Configured cognos archiving process.

Used Autosys to automate cube building process.

Zimmer, Gurgaon, India Nov 2011 to Jun 2012

Role: Cognos Lead Developer

Project: Cognos BI Dashboard Reporting

Environment : Cognos 8.4, Oracle9i, Sybase, Sybase Central, Windows 2000, Framework Manager, Transformer.

Zimmer sales teams need to have sales intelligence dashboard based on cube. This dashboard is shared across Vice Presidents, distributors and manager. These dashboards allows user to see their performance against quota. Sales teams need to have customized map dashboard to track the performance. Zimmer leadership need to track the ROI on trainings conducted for surgeons. This project involves development of active reports for ipad.

Roles and Responsibilities:

Understanding the business requirements and designing applications to meet their needs.

Interacting with customer for requirement gathering.

Understanding of business flow and analysis of requirements.

Designing the high level and low level design documents.

Handled small project solely which needed development of reports from scratch.

Developed dashboards on Sales, Inventory and Forecasting.

Administered cognos and TM1.

Monitoring multiple cognos environments.

Implemented security in cubes and cube groups based on custom views.

Developed Cognos reports and implementing security in Framework Manager.

Used Mapinfo professional for creating customized maps.

Created heatmap dashboard with customized maps.

Created cubes on different databases.

Created Indexes and Views using SQL to enhance the performance of the reports.

Developed sales intelligence dashboard on cubes which shows actual sales versus quota and budget.

Created inventory distribution dashboards which show last 13 months and last 30 days inventory trends.

Automated sales and inventory cube building process with batch scripts.

Scheduled batch scripts to trigger when the summary tables get updated in the early morning.

Created dashboards for supplier team to track delivery performance of the material suppliers to Zimmer.

Created dashboards for Sourcing team in Zimmer on top of Multidimensional data sources.

Created report studio reports with sql queries from multiple databases.

Created reports on Analysis studio.

Created Analytic user group for allowing BA’s to create reports with workspace and workspace advanced.

Provided training to users on cognos workspace and workspace advanced.

Created reports with procedures to write back comments to the database on oracle database.

Posted cognos reports to Livelink after cognos archiving with the help of Autosys.

Many of the cognos reports were developed using highly beneficial features of Cognos such as Drill Through, Conditional Rendering, Style Formatting, Component Reference components.

24/7 monitoring of cognos.

Designed and developed DMR models.

Zimmer, Gurgaon, India Dec 2010 to Oct 2011

Role: Cognos Senior Developer

Project: AMS (Application Maintenance and Support)

Environment : Cognos 8.4, Cognos 10, Oracle9i, Sybase, Sybase Central, Windows 2000, Framework Manager, Transformer, Autosys.

The Purpose of the project was to maintain and support cognos environment. To implement enhancements in small projects and change requests. To resolve production related issues in specified SLA’s. To co-ordinate with finance, operations and sales teams for reporting requirements. Create dashboards for leadership and training teams.

Roles and Responsibilities:

Understanding the business requirements and designing applications to meet their needs.

Interacting with customer for requirement gathering.

Understanding of business flow and analysis of requirements.

Designing the high level and low level design documents.

Implemented Kimball methodologies while designing.

Developed reports on top of DMR models and multidimensional cubes.

Generated different types of reports like list, crosstab, charts using filters, calculations and master detail relationships.

Created model query subject, data source query subject and procedure query subject in Framework Model.

Developed the Framework Manager model by pulling the data from multiple data sources like Oracle, SQL Server 2005, Sybase and published packages to the Cognos Connection.

Developed cubes using Cognos Transformer and published to Cognos connection.

Developed reports using Cognos OLAP cubes.

Monitoring multiple cognos environments.

Handled Security issues including providing authentication and granting users access to data and permission to perform activities on the data based on their sign on identity.

Dealing with development and maintenance of cubes in TM1.

Performed Admin tasks like Creating Users assigning permissions.

Process the Turbo Integrator by manipulating cubes, views, dimensions, elements, and other TM1 objects while importing data.

Resolving tickets within SLA agreements.

Astrazeneca, Bangalore, India Nov 2009 to Nov 2010

Role: Cognos Developer

Project: Brand Performance Analysis

Environment : Cognos 8.3, Framework Manager, Oracle9i, Toad, Windows 2000.

AstraZeneca plc is a British multinational pharmaceutical and biologics company. It is one of the largest pharmaceutical companies measured by revenues and has operations in over 100 countries. The Purpose of the project was to track the Inventory and performance of the company's major brands and products. This project includes design and development of sales and inventory dashboards in cognos which are used by sales team and inventory teams respectively. These dashboards allowed them to identify the brands which are lagging behind the projections.

Roles and Responsibilities:

Design, Development and Maintenance of Report Studio reports.

Managed Scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection.

Involved in generating various types of reports like List reports, Cross tab Reports, Drill-Through Reports, Combination Chart Reports.

Worked with page breaks and static prompts.

Worked with conditional formatting, conditional block, and Master-detail relationships based on requirement.

Used render variable and conditional variable functionality.

Developed Master-Detail, Drill-Through reports to provide summary-Detail information using with pass data item Value, pass parameter value.

Imported metadata from various data sources such as Oracle, SQL server, Sybase into Framework Manager.

Implemented security at Package level, Object level, Data level using Frame work manager.

Handled Security issues including providing authentication and granting users access to data and permission to perform activities on the data based on their sign on identity.

Created business views, namespaces and model query subjects in Framework Manager for multi user environment.

Involved in developing, support, unit test and deployment of the reports.

Hyundai USA, Bangalore, India August 2008 to Sept 2009

Role: Cognos Developer

Project: Sales Analysis

Environment : Cognos 8.3, Oracle 9i, SQL developer, Windows.

Description:

Hyundai Motors America (HMA) is the one of the leading Auto mobile companies in the USA. Hyundai Motors America Executives need to know the sales performance of the company at any given point of time. The executives need to know what has been the retail sale, the wholesales, which region is doing better and which regions are falling below their target, performance of models and tracking of inventory, how the dealers performing are compared to last year etc. The dashboard which is the graphical representation of such measurable parameters would give immediate access to all key information on the current as well as the past performance.

Roles and Responsibilities:

Understanding the business requirements and designing applications to meet their needs.

Involved in Designing the Model by Using Framework manager.

Generated different types of reports like list, crosstab, charts using filters, calculations and master detail relationships and drill through.

Bursting reports to all the potential recipients on user requirements.

Implemented data level security in Framework Manager while developing model.

Used Drill through reports to link two or more reports.

Developed reports using Bookmarks.

Involved in the unit testing of the reports.

IIIT Hyderabad, India September 2007 to August 2008

Role: Intern

Project: Customer behavior Analytics

Environment : Cognos 8.3, Oracle 9i, SQL developer, Windows.

At IIIT this is an in house project on analytics. Customer behavior dashboard shows the sales made by hospitals in last one year, how many customers are lost since past six months, what is the sales trend before discontinuing. Top ten and bottom ten customers by region, sales team. This dashboard allows the marketing team to find the loyal customers and focus on losing customers.

Roles and Responsibilities:

Understanding the business requirements and designing applications to meet their needs.

Involved in Designing the Model by Using Framework manager.

Developed reports using report studio.

Wrote sql queries to validate the dashboards.

Created trend charts and maps.

Used Drill through reports to link two or more reports.

Involved in the unit testing of the reports.

Education:

Bachelor of Technology from Jawaharlal Nehru Technological University, Hyderabad in Electrical and Electronics Engineering.

Contact this candidate