Summary

• Over 11years of strong technical exposure and competence in handling Client server, Data Warehousing and Business Intelligence applications.
• Arun is an IBM Certified Administrator, IBM Certified Specialist, and an IBM Certified Developer Please refer to the attached IBM Cognos Transcripts Confident and comfortable enough to contribute in any kind of IBM Cognos related position or role.
• Technical specialist with the necessary domain, people - project management skills and customer management skills. Developed, deployed Consumer Centric Dashboards, Production, Drill through reports, and Ad-hoc packages using IBM Cognos Suite of products.
• Extensive 9 years of hands on experience with IBM Cognos Suite of Products Cognos Impromptu, Powerplay, Cognos 7 EP Series, Cognos ReportNet, Cognos 8.4.1, 10.1, 10.2.1 Cognos TM1 version 9.5, 10.1,10.2 , Cognos 10.2.1
• Practical Knowledge of DQM-Dynamic Query Mode, implementation expertise with Cognos 10.2 Dynamic Cubes and deployed Cognos 10.2.1 Dynamic Cube applications.
• Automated the enterprise Reports and Dashboards scheduling process using Cognos Event Studio and by creating the required Stored Procedures, Packages and Triggers.
• Performed all configurations related to the Cognos configurations window that includes, but is not limited to, editing services, logging, security authentication providers, cryptographic features, content manager data stores, and so on.
• Hands on experience in configuring gateway to communicate with the application components dispatcher in a distributed environment. To make a failover cluster, configured more than one BI Server.
• Managed the IBM Cognos 10.2 Administrative Content, Report Content, Server Environments, and Security Environments. Defined steps and options to deploy content from one Cognos 10.2 environment to another.
• Implemented baseline configuration and performance tuning in Cognos 10.2 . Worked with enterprise networking, enterprise system-security teams to implement the effective enterprise Cognos Load Balancing options.
• Managed groups, roles, and users using the built-in Cognos namespace which contains predefined roles and groups for convenience. Whenever a user wanted access to Report Studio, I have added him to the built-in Authors group.
• Added users to the required roles and groups from some external, third-party security namespace, for example, LDAP, Active directory, or Custom Java Security Namespace. Experience in creating custom folders, groups, and roles.
• Managed the Cognos Administration portal content in terms of backups, content maintenance, and index updates. Created the deployment archives export and migrated the content across different environments DEV , UAT and Production environments .
• Experience and expertise in using the Cognos BI Administration portal for implementing the enterprise security architecture, Managing authentication providers, Overcoming the initial security, Permissions management, ensuring Secured features, functionalities, capabilities and to enable Cognos firewall , logging and Single Sign-on SSO .
• Configured different options of all the dispatchers running in the environment and changed the configuration of an individual service for any dispatcher by selecting the required category as Logging, Environment, or Tuning.
• Secured the IBM Cognos BI environment, by ensuring the enterprise security policies, and by defining the required authentication and authorization in Cognos, based on the enterprise Cognos BI security model.
• Participated in Cognos architecture, query tuning, capacity planning initiatives and efforts
• Worked closely with architects and infrastructure groups to ensure system stability -longevity and contributed for production support duties during off-hours / weekends.

Employment History

• Confidential Senior Associate DWBI - Business Intelligence
• Confidential Senior Specialist Business Analytics Intelligence
• Confidential Report Developer - Supply chain management company with 313 offices and 245 logistics centers in 59 countries.
• Confidential -Senior Cognos Consultant - Headquartered in Houston, Texas, is a leading multinational organization

Confidential

Technical Skills

• Databases : Oracle 8i, 9i, 10, 11, SQL Server 2000, 2005, 2008 and DB2
• OLAP Tools : IBM Cognos 6, 7, 8.1, 8.2, 8.3, 8.4,10.1 and 10.2 , Microstrategy
• 8.0.2 and 9.0.1 Desktop, Web, Mobile, OLAP and Architect
• Data Modeling : Cognos Framework Manager, Dynamic Cube Designer, TM1 Peformance Modeler, Cognos Insight, TM1 Architect
• Languages : SQL, Java, Visual Basic 5.0
• Administration : Cognos 7, 8.3,8.4, Cognos 10.1,10.2

Confidential

Sample Assignments

Consultant

Confidential

Roles Responsibilities:

Played a major role From Requirement gathering until Deployment- Full life cycle development in building the following Cognos DMR-Dimensionally Modeled Relational -DMR FM Packages and Relational Reports. Managed both onsite and offshore teams.

Accomplishments

• Got customer appreciation for the rapid development and deployment of these objects. ACME APS BHP Finance Analysis BHP Finance Reporting Broker Commission Current Business Demand Planning KPIs Demand Planning SnOP Scorecard Historical Inventory Activity Inventory Trends Inventory Trends DFC PPV Production Planning Promo Tracker PTM OTC Reporting Reporting Package Tonnage Total Business Management TBM Fill Rate Transportation Logistics
• Reports DMS Brk Summary Rpt AO DMS Deduction Aging Report ATB AO Executive Summary Report -PET FY15 Marketing DMS Brk Summary Rpt RT Marketing DMS Deduction Aging Rpt ATB AO Operating Hot Sheet - Pet - FY15 Supply / Demand Trending Analysis for All Facilities PHYS,STAT,COST

Confidential

Report Developer

Enterprise Bank

• Build a centralized repository Confidentialand set of services to house bankable items. The Bank will using modern technologies deployed in a highly redundant manner it will consist of a data store and several highly specialized programs that segment regulated and non-regulated activities, and programs will be easily accessible using our existing integration architecture.
• New User Interface a new user interface will be developed to enable centralized viewing of all fund type balances and transactions across the enterprise, with various sorts and filters. Note: we'll still have the existing CMS screens which will not change, but will be modified to retrieve from/deposit to the Bank.
• Reporting - new enterprise level reports will be developed. New accounting reports will be developed for 3rd party POS, leased tenants, etc.
• Analytics More detailed data available for analytical reporting, i.e. Earned vs. Promo, Gaming vs. Hospitality, etc.

Roles Responsibilities:

• Developed and delivered EB-3659-Promotional Reward Credit Posting Report
• Working on the following action items which will completed in two weeks.
• EB-3657-Gaming Reward Credits Awarded By Game/Denomination-ECGDRCLR
• EB-667-Reporting includes statements, reports, etc. generated from the bank
• EB-3923-Link Bank UI to Cognos Reporting Portal
• EB-4079- EB-4076 Men highlighting and EB-4084 -EB-4076 Parent Men Item names

Confidential

Sales Reporting

• Phase 1 Strategy: Build the Tradelane Activity component of the Sales Data Mart with the ability to drill to the shipment details. The drill across capability is very critical in the Tradelane Activity report in Cognos Analysis Studio. Enable end users/ consumers to perform analytics using Cognos Analysis Studio, export them to Excel or PDF format and distribute the reports to the sales team. In addition, provide the business user access to some key Operations reports such as the FF0047 Intercompany, Top 100 Client Comparison Report and Trade Lane Report.
• Phase 2 Strategy: Build the Client Activity component of the Sales Data Mart with the ability to drill to the invoice and charge code level. Convert the Cognos Analysis Studio reports, graphs, charts and dashboards created in Phase 1 to Cognos Report Studio reports static reports meant for distribution to a larger audience for automated support to the Sales Team and others through the BI Portal or other automated distribution methods. Enable few Cognos Analysis Studio users from the sales team to continue with Cognos analytics.

Roles Responsibilities:

• Prepared an overall design. Performed hardware assessments.
• Performed middleware installation and maintenance.
• Gathered business requirements. Designed the logical model.
• Designed the database physical model. Designed the multi-dimensional model.
• Prepared the security definition. Defined security rules and views.

Microstrategy To Cognos - Report Conversion

• Arizona Public Service APS , generates sells and delivers electricity and energy-related products and services. APS serves more than a million customers in 11 of Arizona's 15 counties, and is the operator and co-owner of the Palo Verde Nuclear Generating Station a primary source of electricity for the Southwest.
• At APS there were about 840 Reports both Operational and Business Intelligence, of which 800 MicroStrategy v9i reports and 40 Business Objects XIr2 reports. APS wanted to convert all the above mentioned reports to the corporate BI tool Cognos 10.1. As part of the conversion process APS was interested to analyze the existing reports and develop a strategy to consolidate the existing BI Reports to a reasonable number where feasible.
• The total composition of the reports are: - 20 complex, 50 medium and 30 simple.

Confidential

Roles Responsibilities:

• Migrated 31 very complex reports long running, Multi fact and Multi-grain and 24 reports of medium complexity Conditional formatting and exception handling from Microstrategy to IBM Cognos
• Ensured environment security comply with best practices /Enterprise security standards in setting up new database connections/Data sources and security procedures
• Reviewed, validated and helped other developers to fix at least 20 migrated reports.
• Created IBM Cognos Event studio Monthly and Daily Agents and Event conditions and scheduled multiple reports for different schedules.
• Created multiple Stored Procedures , to work with the Cognos Event studio - Agents and Jobs for Scheduling multiple Cognos reports in replacement of the Microstrategy Narrowcast Scheduled Reports.
• Administered Cognos application support which includes data loads, validation, structural updates and troubleshooting.
• Worked directly with IBM/Cognos support team on debugging efforts and resolving trouble tickets.
• Performed quality testing prior to UAT and for reporting components progress throughout the project and enhancement life cycle.
• Administered reporting environments , including security, patches, upgrades, etc.
• Developed and maintained accurate system documentation including information about attributes and business rules. Assists with the maintenance of data directories.

Confidential

GTM Sales BI - Asia RDM Support

• Asia Regional Data Mart is a for the greater Global Sales Reporting Consolidation initiative which will:
• Support the corporate strategic direction to adopt EIS and consolidate geography data marts
• Transition geography sales reporting onto one platform, and divest of all geography sales data marts
• Replace Asia RDM functionality to the global platform EIS/Teradata to increase stability and supportability
• Leverage the global platform to create integrated reports ex: sell thr billings for JP/CN that have future compatibility w/other Geographies value added process improvement
• Leverage the Cognos reporting tool to produce more timely reports reduce, possibly eliminate, manual effort in report creation .

Roles Responsibilities:

• To support Business users for the IBM Cognos reports, dashboards and applications.
• To clarify Business users with respect to documented features.
• To troubleshoot issues when Business users are experiencing unexpected results.
• To participate and contribute in EBI change control meetings on daily basis.
• To monitor IBM Cognos reports, dashboards and application performance and to apply optimization techniques.
• To improve report performance of all reports dashboards and Cognos applications.
• To manage both the onsite and offshore BI Cognos production team members to fix issues.
• To update the client managers with the daily issue status and resolution methodology.
• To support the transition to a managed ad-hoc model using the Cognos Connection portal as an access point for reporting.

Onsite Dev Lead

Confidential

IDN B2B WS2 - Work stream 2 Exposures

This project built a global capability that had

• Aggregated dispersed information into one single warehouse
• Improved the accuracy of exposure and collateral information
• Report exposure and collateral information on a daily basis
• Provided a single interface for Risk Officers to take risk mitigating actions hold funds, change payment plans on merchants in a timely fashion
• Provided users the ability to manage the Risk-related functionalities like Non-Delivery Factors, Non-Cash Collateral, Post Liquidation Inputs

Roles Responsibilities:

• Worked with client to gather requirements and prepared technical specifications Documents.
• Involved in design of proto type of reports based on requirements.
• Communicate offshore working team to explain client requirements and develop reports.
• Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports.
• Responsible for keeping team members on track toward completing the terms of goals.
• Communicated detailed requirements and concepts to developers
• Ensured requirements are understood and implemented.
• Trained developers to understand IDN standards and capabilities.
• Consulted with DBA's as needed during design and development
• Responsible for Code review and Code migration to UAT and Production environment

Confidential

BI Technical Consultant

BI Dashboard Development

• This initiative for ALFA was aimed at providing the executive management 'One Single Screen' insight. This one consolidated screen answered all the informational needs of an ALFA executive for the organization's daily performance with the following components.
• Visual Status of key performance areas and display of critical indicators
• Infinite drill-down to any level of information from one common place
• With a dashboard in place, the unnecessary circulation of stacks of reports to get an overall perspective was eliminated. It captured real-time information for monitoring key metrics, generating alerts whenever the metrics went below the defined threshold values, thus empowering the decision makers to take corrective measures quickly.

Roles Responsibilities:

• Interacted with the ALFA business users to get the reporting requirements
• Worked as a Cognos BI - Subject Matter Expert to refine the requirements
• Worked collaboratively with Development managers to provide work estimates for executing designs.
• Secured the Cognos 8 BI Environment Defined authentication and authorization
• Administered the Cognos 8 BI Server Environment Dispatchers and services using Cognos Administration
• Developed and maintained a set of product standards that ensure consistent usability and high performance that result in a satisfying customer experience.

Confidential

QA-DW Testing Team Lead

EDW - Data Warehouse Phase I II

The EDW Enterprise Data Warehouse provided a consolidated data environment for the client. The primary goal was to provide a data storage, delivery and reporting environment that allowed business user, easy access to the client's data assets. The approach was to implement small manageable pieces or data marts that could return benefit to the user community. This program, driven by information system focused on producing integrated data, business intelligence and reporting capabilities to the client.

Roles Responsibilities:

• Developed desired test cases for functional, system, integration and regression testing for the various environments Source, DW Stage, Data Warehouse, Data Mart Stage, Data Mart, Cognos Reports and Epiphany Reports
• Validated change data capture in stage and data warehouse tables for different transactions in the business scenarios Renewal, Add associate, Cancellation, Upgrade, Downgrade, Reinstatement, Address change and Locked Transactions .
• Created test scenarios and test cases based on the test plan, executed the test cases in Mercury Quality Center 9.2.
• Reviewed the test cases and their associated results / defects with respect to the requirement to enhance defect tracking system.

Confidential

Application Architect DW BI Tech Lead

FFRF Flight Finder Room Finder REPORTING

This reporting layer will provide the MR business insight into what redemption activity is being completed through the FFRF Flight Finder Room Finder application. Since FFRF covers MR and partner redemptions, the scope of this reporting will cover all point/mile activity whereby the customer was able to book a flight or room through FFRF. The purpose of this reporting is not to provide a complete view of activity within FFRF, only the redemption based activity. Thus activity around user navigation around the site, partner searches or adding partner accounts to the MR accounts is not included.

Roles Responsibilities:

• Worked with client to gather requirements and prepared technical specifications Documents.
• Communicate offshore working team to explain client requirements and develop reports.
• Responsible for keeping team members on track toward completing the terms of goals.
• Involved in installation and configuration of Micro strategy 8.1.1.
• Creating Schema Objects facts, attributes, hierarchies, Transformations and application objects filters, prompts, metrics, reports needed to create the micro strategy objects necessary for the deliverable.
• Architected the project and created all the necessary schema, application and configuration objects.
• Creating advanced metrics level, conditional , filters, consolidations, custom groups and reports with VLDB properties.
• Involved in partitioning the tables, indexes and management of the schema objects.
• Involved in optimization of code and tuning queries for performance.
• Involved in tuning the application Queries using Explain Plan.

Confidential

Onsite Project Lead

CLORDS Operational Reporting

This project was to construct an Operational Data Store CLODRS and to populate it with data from various source systems using Informatica. Customer wanted to develop Hyperion Brio reports as similar to the existing mainframe reports whose source was one of the legacy systems.

Roles Responsibilities:

• Coordinated with offshore team of 5 members to create mappings and to move data from Various Systems to Operational Data Store CLORDS.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Managed offshore team of 4 members to create Hyperion Brio Reports from the CLORDS to support client's enterprise reporting strategy.

Confidential

Onsite Project Lead

This project was to convert three enterprise VB applications into Cognos ReportNet. To design, build and to deploy the Group Annuity Reporting application, I provided expert advice and coordinated the entire process right from requirement analysis till deployment. Within a very short period of time, I designed a data model to meet its completeness with the help of my CRN experience and expertise. I delivered this end to end solution in time and I got commendable appreciations from the client.

Roles Responsibilities:

• Defined users, groups, and roles to maintain security and made reports available to business users
• Data modeled the new Cognos FM model with reference to the existing VB application based on reporting requirement.
• Managed the offshore team to make the VB to ReportNet migration process effective in support of client's enterprise reporting strategy.
• Configured the complex security authentication provider when the custom namespace was shared by multiple user groups
• Secured the Cognos 8 BI Environment Defined authentication and authorization
• Deployed the application in the ReportNet Server both in UAT and Production environments.

Cognos Developer

Confidential

LTC - Account Status - Enhancement

This assignment was to enhance LTC - Long Term Care Data mart based Cognos OLAP Power cubes and to solve the inability of the cube for Drill-Through and to increase its functionality. I redesigned the model to use a single source for the cube and for the ReportNet report by generating the IQD from Framework Manager and by eliminating the Impromptu. I resolved the issues with the Drill-through reports from PowerPlay Cube to ReportNet.

Roles Responsibilities:

• Requirement Analysis, preparation of functional and technical specification documents with respect to the Cognos ReportNet and PowerPlay environments.
• Data modeled to redesign the existing imprompt based drill-through to ReportNet to support client's enterprise reporting strategy.
• Automation of the whole PowerPlay Cube creation, publishing processes with batch script in the windows server environment
• Deployed the enhanced LTC Account Status cube in the ReportNet Server UAT and Production environment

Confidential

Cognos Developer

Activity Reporting Data Mart provided an analytical and transactional reporting environment for Sales and Marketing. There were multiple sales and activity reporting data sources currently in use. This project has enhanced the situation by: Standardizing report measures and templates across business units, substantially reducing the number of reports generated on a regular basis, thereby minimizing the associated operational labor, Standardizing the reporting delivery methods.

Roles Responsibilities:

• Created Reports using Cognos Imprompt as per reporting requirements
• Created Multi-Dimensional Cubes using Transformer for reporting in PowerPlay.
• Created documentation using MS Excel and tested the report against data base

Confidential

Cognos Developer

SMART Data warehouse has been providing an analytical and transactional reporting environment for Sales and Marketing. Minimizing the required number of Cognos Cubes and optimize the Cube dimensional model, thereby simplifying the data analysis process for business users. This project ensured reporting consistency across all business units.

Roles Responsibilities:

• Created and maintained catalogs using Cognos Imprompt 7 EP Series MR 2
• Created Reports using Cognos Imprompt as per reporting requirements.
• Delivered various management levels with reports, time series, graphs and charts.
• Distributed different types of reports crosstab, free-form, Powerplay and sub reports to the different hierarchy of consumers.