Manager Reports
Resume:
Vikram Mandhala
**********@*****.***
Professional Summary:
Around 9 years of experience in the Information Technology industry and wide range of progressive experience in providing product specifications, requirement assessment, design, analysis, development, documentation, coding, enhancement, testing and implementation of the business technology solutions. Extensive experience in developing scalable enterprise applications to the user needs which serves for Financial, Auto Insurance, Health Insurance, and Automobile Industries. Worked in Data modeling, OLTP/OLAP, Business Intelligence (BI), Client-Server, 3-Tier technologies, ORACLE /11g/10g/ 9i, PL/SQL, SQL*Plus. Over 8 years of BI experience using Cognos 10.2.2.10.2.1,10.1.1,10.2,10.1, Cognos 8.3 and 8.4, Cognos Impromptu, Framework Manager, Report Studio, Analysis Studio, Metrics Studio, Metrics Manager, Workspace, Query Studio, Power Play, Transformer, Impromptu Web Reports, Upfront, Scripting, ODI and Microsoft SQL Server 2008/2012 and Informatica.
Experience Highlights:
Around 9 years of total IT Experience.
Developed and Optimized models with Database Interaction, Client/Server balancing, Database functions, Table Weighting, Qualification and Governors Settings.
Installed, Upgraded and configured Multiple Cognos environments.
Experience in full life cycle of Software Development such as Analysis, Design, Development, Customization and Testing.
Experienced in design and development of Cognos BI Suite (Transformer, Cube designer, Framework Manager, Report Studio, Metric studio, Query Studio, Workspace, Workspace Advanced and Event Studio).
Hands on experience in Report building (Crosstab, List, Dashboard reports) using Report Studio and Analysis Studio.
Build Cube models and maintained cubes.
Expertise in creating complex reports using Cognos Report Studio such as List reports, complex hierarchical list reports, Cross-tab reports, Prompts, Dynamic filtering, Conditional formatting, Drill through reports, Master-Detail Reports, Burst-reports and Cascading Reports and involved in reports performance tuning and Troubleshooting.
Expertise in creating Dashboard reports using Java Script in Report studio.
Implemented Data Security, Object Security, Package Security in Framework Manager and created user classes, roles or groups as per the requirement.
Manages day-to-day administration of Cognos infrastructure.
Trained users in using the Business Insight for dash boarding and the Business Insight Advanced for Ad-hoc reporting.
Experience in Reports Migration such as from one environment to another and from Cognos 8 to Cognos 10.
Designed Dashboards using Active Reports V10.1.
Experience with MDX Functions in Report Studio using Multi-dimensional Sources.
Involved in database design for DW, following WH Inmon and Kimball model.
Good understanding of business process in Sales, Financial, Insurance and Healthcare areas.
Involved in OLTP/OLAP system study, analysis and E-R modeling, developing database schemas including Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
Extensive experience on production support and Troubleshoot/Test issues with existing reports and cubes.
Experience with Microsoft Windows OS (10, 8, 7, Vista, XP, 2000, and Win NT) and MS Office (Access, Excel, Outlook, Word, PowerPoint, and Visio)
Having good exposure on Cognos 11.
Worked with business owners to gather requirements.
Participated in data model and data mart design reviews.
Estimated project durations and time lines.
In-depth knowledge of Oracle database internals i.e. physical/logical design, tables, indexes, tablespaces, segments, extents, backup/recovery, data dictionary etc.
Hands on experience in Unit testing.
Experience in working with V-Model, Agile and Waterfall development methodologies.
Expert in Writing, Executing, and Maintaining Test Plans, Test Procedures, Test Cases and Test Scenarios.
Hands on experience in Tracking and Reporting of defects using Defect Tracking Tools such as TFS/HP Quality Center/ALM.
Highly motivated, self-starting, team player, with a strong desire to learn and excel.
Certifications:
IBM Certified Developer Cognos 8 BI Author.
IBM Certified Developer Cognos 8 BI Meta data Model.
Technical Skills:
BI Tools
Cognos 10/Cognos8: COGNOS connection, Framework Manager, Cognos Workspace, Query studio, Report studio, Analysis studio, Cognos 8.i: COGNOS connection, Metric Studio.
REPORT NET 1.1/1.0 (MR1/MR2/MR3).
Cognos 8: Cognos connection, Framework Manager, Query studio, Report studio, Management Tools, Server Administration Tools, Configuration Manager, Scheduler.
Cognos Series 7.x: Cognos Impromptu Administrator, Impromptu User, Impromptu Web Reports, Cognos Power Play Transformer, Power Play User, Power Play Web Reports.
Operating Systems
Windows 95/98/2000/XP/NT, Linux, Unix.
QA Tools
HP ALM, TFS.
RDBMS
MS SQL Server 2000/2005/2008/2012, MS Access, Oracle 8i/9i/10g/11g, Vertica, DB2, TOAD, Tera Data.
Languages
C, Java, SQL, PL/SQL.
Professional Experience:
BEREAU OF WORKERS COMPENSATION (BWC), Columbus, OH (June 2015 – Present)
Senior Cognos Developer/Admin
BWC – Bureau of Worker’s Compensation is a state affiliated insurance company. It aims to protect Ohio’s workers and employers through the prevention, care and management of workplace injuries and illnesses at fair rates. I was working on the CORE Project. The project involves replacing BWC’s outdated Claims, Policy and Employer Billing systems with a commercial product called power suite. I was involved in the end to end implementation of rebuilding the legacy reports which were built using Hyperion reporting tool and DB2 database using the Cognos tool and Oracle and Vertica databases. We created a new data warehouse with different data marts for Claims, policies etc. and built these reports.
Responsibilities:
Gathered and analyzed functional requirements from the Business Users.
Worked with the Business users to understand what reports were critical, non-critical and not needed. Eliminated the ones that were no longer being used by business.
Directly interacted with client technical team and understand /propose the best solutions on Cognos.
Extracted the queries from the legacy reports and documented it in the cognos specs.
Building Cognos Framework models and Reports to support Production Environment.
Designed & Developed Models & Packages by following firm and product standards.
Developed List Reports, Cross Tab Reports, KPI Scorecards, Scoreboards, Charts and Maps.
Created Dashboards using Cognos workspace, cognos workspace advanced and Cognos report studio reports.
Created Reports using own SQL.
Used Tabular SQL for some of the Complex Reports In Report Studio.
Worked closely with the ETL and QA teams and involved in meetings to discuss test case documents and resolve any kind of issues reported during the testing process.
Successfully managed and trouble shoot numerous complex issues in the Cognos environments.
Proficient in deploying Reports and Packages from one environment to other environments.
New Rule development for BWC project.
Worked closely with the migration team to deploy the reports and packages from Development to QA, UAT and Production environments.
AGILE process has been followed for development.
Involved in creating security and deployment (exports and imports).
Followed Kimball model methodologies in database design for DW.
Trained the end users effectively to use Business Insight, Business Insight Advanced and new features in Cognos.
Writing SQLs to implement report specific queries in reporting.
Involved in Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational and multidimensional modeling.
Scheduled (Daily, weekly, Monthly and Quarterly) and distributed reports using Schedule Management in Cognos Connection.
Tuned performance of reports and models by following database and design standards.
Created user Notification reports and created agents using Event Studio.
Performed Unit testing of reports writing SQL statement at backend/DB and validating against Cognos report studio reports.
Extracted data from different Sources (EXCEL, FLAT FILES).
Built new packages using Cognos Framework Manager and converted the existing reports from Excel to Cognos reports using Cognos Report Studio.
Implemented Securities for reports in report level (Cognos Connection) and Model level (Row level and Object level Securities).
Worked on Power play transformer to build cubes.
Tuned performance of reports and cubes by avoiding loops in Catalogs and models.
Work with business owners to develop new summarized subject areas and reports.
Effectively involved in defect tracking, reviewing and analyzing test results using ALM (HP Quality Center).
Conducted the KT to new joiners.
Responsible for knowledge transfer, training and communication with the vendor, end users and team members.
Environment: Cognos 10.2.1/10.2.2/11 Suite (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection, Cognos Workspace Advanced, Cognos Workspace, Cognos GO Mobile, Cognos SDK, Active Reports), Power play transformer, Informatica, JSP, HTML, Java, Shell Script, DB2, Microsoft SQL Server2012, Vertica, SQL Developer,Win2008, HP ALM 12.0/12.1 and SharePoint.
Nationwide Insurance, Columbus, OH (Oct 2013 – May 2015)
Senior Cognos Developer/Admin
Nationwide, a Fortune 100 company based in Columbus, Ohio, is one of the largest and strongest diversified insurance and financial services organizations in the U.S. and is rated A+ by both A.M. Best and Standard & Poor’s. The company provides a full range of insurance and financial services, including auto, commercial, homeowners, farm and life insurance, public and private sector Retirement plans annuities and mutual funds, banking and mortgages, motorcycle and boat insurance.
Responsibilities:
Implemented Data Analytics using Cognos BI Suite v10.2 to support Claims and Reimbursement Dept.
Directly interacted with client and understand their requirements and implement the same.
Worked efficiently as a team player and interacted well with the ETL Architects and Database Architects in challenging and solving the issues.
Developed Model and Packages using Framework Manager for both Report Studio and Query Studio.
Extensively worked on understanding the business requirements and Involved in performance tuning for Models.
Developed List Reports, Cross Tab Reports and Drill Through reports Using Report Studio, Query studio for adhoc reports and Report Studio reports.
Experience in developing complex reports using Drill-through reports, Prompts, Master-detail, Burst reports, Conditional formatting, complex hierarchical list reports, Dynamic filtering calculated columns and conditional formatting in Cognos.
Implemented Cognos SDK code for extracting the report schedules defined by power users.
Worked on Java Script to perform Prompt page validations.
Created reports using MDX function in Cognos report studio.
Developed complex multi-page list reports with multiple report outputs (PDF, HTML and CSV), Used all type of variables (Render, Style, and Text Source), Page Set and advanced sorting options.
Used Cognos Transformer to build multidimensional cubes and used it in Cognos Power Play to build graphs and charts.
Worked with cognos support team and Involved in production support by resolving users problems.
Tuned performance of reports and models by following database and design standards.
Successfully managed and trouble shoot numerous complex issues in the Cognos environments.
Created User Groups and Roles by creating permissions in Cognos portal.
Wring SQLs to implement report specific queries in reporting.
Migrated Power play studio reports to Analysis studio reports, assisted user in understanding analysis studio features.
Created and maintained LDAP, Users, Groups and Roles to implement securities on models, Packages and reports
Extensive knowledge in writing complex SQL and Stored procedures.
Involved in Cognos administration, deployment (DEV, UAT, PROD environment) and production support.
Scheduled and distributed reports using Schedule Management in Cognos connection.
Supported the reports in Production environment and transferred knowledge on maintaining/modifying reports in the future to the support team.
Trained end users effectively to use reporting tool, to build and customize their ad-hoc reports.
Environment: Cognos 10.2 Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, Cognos Power Play Transformer, Workspace, Workspace Advanced, Active Reports, SSIS, SSRS, Informatics Power Center 9.0, Oracle, DB2, MS SQL Server, Toad, IBM Optim, Win SQL, SQL Server Management Studio, HP Service Manager, Lotus Notes, Share Point, MS. Word, MS. Excel, Windows 2007/XP and UNIX.
GM HOLDEN - Daily Management Report (DMR), Austin, TX (Apr 2011 - Sep 2013)
Senior Cognos Developer/Admin
The GM Holden Sales Reporting application is providing a Sales Data Mart solution, Daily Performance Reporting (DPR), which will provide the Holden Australia Sales and Marketing department with the necessary reporting and querying capabilities against all the vehicle distribution data that they need to be able to support the business.
Responsibilities:
Involved in requirements gathering from business users and prepared functional and technical design documents for further development.
Identified Reporting elements from the data sources and developed the model for reporting.
Developed Model and Packages using Framework Manager for both Report Studio and Query Studio.
Building Cognos Framework models and Reports to support Production Environment.
Developed List, Crosstab, Charts, Master Detail, Burst and Drill through reports Adhoc reports and Top ten reports for departments like Retail Sales, Dealer Stock, Wholesale Sales, Plant Stock and Customer Orders in Report Studio.
Created Active reports with the offline interactive behavior with tabbed functionality, offline data filtering & On Click chart highlighting.
Created Burst Reports and Multilingual Reports based on groups of users and Preferences for our Australia, New Zealand and China partners.
Created Drill Through Reports and Master Detail Reports for Marketing Department.
Created dashboards, port lets for various Sales and Cost Group reports. E.g. Sales by region were displayed as dashboards.
Giving Access to different folders, Packages, Reports based on the users request.
Used Cognos Transformer to build multidimensional cubes and used it in Cognos Power Play to build graphs and charts of sales data.
Tuned performance of reports and cubes by avoiding loops in Catalogs.
Wrote Macros and scheduled macros to run Reports and refresh Cubes.
Implementing security using macros, session parameters & parameter maps.
Tuned performance of reports and models by following database and design standards.
Interacted with ETL team to gather the requirements for the reporting.
Exceptionally good and experienced in handling the problem and troubleshooting.
Knowledge in publishing Cognos reports to SharePoint site using Core publisher.
Implemented Securities on cubes and reports in report level, Model level, and catalog level.
Updated Stored procedures, Database views as per user requirements.
Performed Unit testing of reports writing SQL statement at backend/DB and validating against Cognos report studio reports.
Environment: Cognos 10.2 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection, Cognos GO Mobile, Cognos SDK, Active Reports), Cognos 7 Power play Transformer, JSP,HTML, Java, Schell Script, Cognos Data manager, Informatica, Tera data, Oracle 11g, DB2, Linux 5.4.2, Win2008.
Bank of America, Pennington, NJ (Apr 2009 - Mar 2011)
Cognos Developer/Admin
Supported Cognos 8/10 environments for multiple internal projects like Loan Track, Risk Reporting within Bank of America. This included day to day support as well as Migration & Upgradation.
Responsibilities:
Involved in Analysis of the specification provided by the clients.
Installed and configured Cognos 8.4 and 10.1 in Dev Environment.
Created Report specs for Cognos 8.4/10.1 BI.
Identified equivalent Functions in Impromptu and Cognos 8.4/10.1BI.
Analyzed provided Functional Documents and Technical Specifications, Understood the requirement and JSP integration concepts.
Developed Reports in Cognos 8.4/10.1 BI.
Developed list reports with multiple queries, Joins, Unions and complex formatting using Repeaters, Singletons, Layout Component Reference
Developed complex multi-page list reports with multiple report outputs (PDF, HTML and CSV), Used all type of variables (Render, Style, and Text Source), Page Set and advanced sorting options.
Supported the reports in Production environment and transferred knowledge on maintaining/modifying reports in the future to the support team.
Wrote Macros and scheduled macros to run Reports and refresh Cubes.
Installation, Configuration and Maintenance of Cognos Application on Development and UAT Environments.
Involved in Server Validation Test when Server moved from one environment to other.
Managed distributed servers (BI and Cognos dispatchers).
Perform day-to-day support activities & work in the Cognos Support team and development project teams to understand business requirements, models and reports design. Transition the same knowledge to the team for full support.
Involved in performing Administrative tasks like user authentication, creating new users for the cube.
Define the security structure for the complete user community, by adding roles and groups to the Cognos Connection directory and mapping all the users to one or more of these roles/groups.
Created and maintained LDAP, Users, Groups and Roles to implement securities on models, Packages and reports.
Managed Data Sources,user accounts and permissions.
Scheduled reports using Cognos scheduler and emailed to various recipients as required.
Responsible for creating the Cubes and Reports and scheduling them accordingly.
Deployed the Cognos Content from Development environment to UAT/Production environments.
Deployment of reports, packages, users and sometimes the complete content store from one environment to the other.
Resolved the errors in operator and Designer (Dead Lock, Data Issue, Data base down, Unique Primary Key Error, Delimiter Issues).
Created the ODI repository.
Involved in unit testing of all the reports and documented all the test cases worked on.
Performed Verification of Impromptu and Cognos 8.4/10.1BI Joins using Win SQL.
Upgraded/Migrated Reports Cognos 8.4 to Cognos 10.1.
Verified of Impromptu and Cognos 8.4/10.1 BI Joins using Toad.
Environment: Cognos 8.4/10.1 BI (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection), Cognos 7.4 Impromptu reports, Cognos Transformer v7.4, People Soft ELM v 9.1, SQR, PL/SQL, Web Sphere application server, Java, Shell Script, Oracle 10g, Teradata, Sybase/IQ v12, Teradata v13, Win 2K, HP-UNIX, Tivoli, ODI11g, FileZilla.
IGATE Corporations, Mumbai, India. (Sept 2007- Mar 2009)
Cognos Developer/Admin
The customer, BUPA, UK is Private health insurance organization involved in individual, group, family healthcare insurance assistance and provider. BUPA has a wide range of applications running on various databases like Oracle and Teradata. The key objective of Project BUPA was to extract these various data feeds and load them into a unified database for PeopleSoft, SWIFT, Healthcare application and make available reporting environment to end user using Cognos 8.
Responsibilities:
Involved in the Documentation process.
Interacted with Onsite team/client for better understanding of the requirements.
Understanding existing business model and customer requirements.
Involved in creating and maintaining warehouse and mapping to those business entities to Data Mart.
Assisted in creation of Packages using Framework Manager.
Designed and developed packages on user level security for the reports.
Developed Models based on the dimensions, levels and measures required for the analysis.
Developed List Reports, Cross Tab Reports and Drill Through reports Using Report Net 1.1 Report Studio, Query studio for adhoc reports and Report Studio reports.
Involved in performing Administrative tasks like user authentication, creating new users for the cube.
Involved in design and creation of Fact tables and CUBES (Dimensions and Measures).
Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
Created customized BI reports linking various databases, to meet the user requirements.
Applying Security in Cognos Connection by controlling privileges for users, groups and roles to the various packages, reports and dashboards.
Monitored the jobs in Tivoli.
Analysed the user tickets, Resolving and Closing the User Tickets.
Prepared the MOI and HR Dash boards on daily Weekly basis and sending to users.
Created multi-page reports based on multiple master queries to show the data on different pages when the master record changes in a report using Report Studio.
Created Applets and used them in different Mappings.
Supported for User on the Requests.
Restarted the Cognos Services in Cognos Production.
Set up required permissions in the Cognos Portals for the User group for security purposes.
Managed Reports, Folder and Package Deployments from one Environment to another.
Administered Cognos BI Server Environment.
Involved in unit testing of the reports and verifying the correctness of report data with the data from the back end.
Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio), Access Manager, Windows XP, Report Net 1.1, ORACLE 9i (SQL, PL/SQL), Power Play Transformer7.0, Windows NT, UNIX, Informatica Power Center 6.1, DB2, SQL Server.
Contact this candidate