Chandra Vedantham

acux2y@r.postjobfree.com

561-***-****

SUMMARY OF QUALIFICATIONS:

Around 10 years of Experience in developing large scale information systems Applications related to Cognos Business Intelligence and Data Warehousing in Retail, Banking, Insurance, Health care, Food Chain and Higher Education.

Proficient with IBM Cognos, SAP Business Objects, Webfocus, Oracle Discoverer and other Industry Strength Reporting Tools.

IBM Cognos: Experience and knowledge in Cognos BI Server 8.2, 8.3, 8.4, 10.1,10.2, Cognos Report Net, Frame Work Manger, Report Authoring, Ad hoc Querying and Report Studio, Power-play Reports, Power-Play Enterprise Server, Data Manager, Access Manager, Transformer, Impromptu and Upfront.

Building Models and publishing Packages in FrameworkManager to the 8BI server.

Delivery of Solution-Oriented Complex Reports using Report Studio and Development of Ad-hoc Reporting Interfaces using Query Studio and Analysis of Reports from Cube Packages using Analysis Studio.

Extensive Experience working on Cognos Report Studio, Cognos Portal, Administration and Framework for Banner ODS Environment.

Liaison between Business groups and technical Teams.

Experience with Metadata modelling and developing Metadata Mapping Documents.

Extensively worked on understanding the Business Requirements and Designing Cognos Applications. Developed ODS Data Models and Cognos Packages to support Banner Modules like AR, Financial AID, HR and etc.

Involved in Design Sessions and provide Tool level architectural Inputs, prepare Report Design Specification documents.

Strong Enterprise Data Warehouse and OLAP Skills using COGNOS Tools PowerPlay, Transformer, ReportNet and COGNOS 8 and Cognos 10.2 Cube Designer.

Extensively worked on Performance tuning to Cognos and Oracle Reports.

Proficient in Teradata SQL scripts and Free Form SQL Queries on Oracle, Teradata and SQL Server Databases

Solid Back End Testing experience by writing and executing SQL Queries.

Experience in preparing Test strategy, Developing Test plan, Test cases, preparation of test data and Writing test Scripts by Decomposing business Requirements and Developing Test scenarios to support quality deliverables.

Experience in various features of Erwin like Forward Engineering and Reverse Engineering.

Persuasive verbal and written Communication Skills and Strong analytical Skills.

Experience of working on Agile and other Software engineering Methodologies.

TECHNICAL SKILLS:

Business Intelligence Tools

Cognos 10.2(All tools including Dynamic Cube designer), 10.1, Cognos 8.x(Framework manager, Data Manager, Report Studio, Analysis Studio, Query Studio, Event studio, Go-Dash Board, Go-Office), Business Objects 4/5.x/6.0 /XIR2(Reports, Designer, Web Intelligence, Info view, Xcelsius 2008 and Supervisor)Jaspersoft and Pentaho

Databases

Oracle 11i, MS Access, MS SQL Server 2K/2K5, DB2, Banner 6.x/7.x, DB2,Teradata 13 and Teradata 14.

Operating Systems

UNIX, LINUX, Windows95/98/NT/2000/XP/Vista/7 and MS DOS.

Web

HTML, XML, Java Script, VB Script, Asp.net and Front Page

Languages

Java, J2EE, VBA, .NET, SQL, MySQL, T-SQL, PL/SQL, UNIX Shell scripting

Servers

Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

ETL Tools

InformaticaPowerCenter 8.6X, Data Stage 7.5x,8.1

Data Modelling

Ralph Kimball Methodology, Bill Inmon Methodology, Physical Modelling, Logical Modelling, Relational Modelling, Metadata Modelling, Dimensional Modelling, Star Schema, Snow-Flake, FACT Tables, Dimension Tables, Normalization, De-Normalizations.

Other Tools

Modelling (Erwin 4.0), Toad, QTP, Toad, Workflow, MS Office, MS Visio, Enterprise Architect 6.1, Rational Rose, Rational Requisite Pro, ClearCase, ClearQuest, PVCS Dimensions.

Applications

MS Office, MS Word, Excel, Visio, PowerPoint

Professional Experience

Office Depot, Boca Raton, FL Jan 2016 – Present

Sr.BI Consultant

Office Depot, Inc. is a global supplier of office products and services. Formed by the merger of Office Depot and OfficeMax, Office Depot, Inc. is a leading global provider of products, services, and solutions for every workplace - whether your workplace is an office, home, school, or car.

Responsibilities:

Worked on gathering Business Requirements and prepared BRDs and Technical Design Documents.

Designed and developed Critical Dashboards for SCM and Loss Prevention Teams.

Implemented Best practices in model design and administrative practices to perform effective functions pertaining to the development tasks & the Cognos roadmap.

Worked on Agile Methodology concepts in creating user stories,providing the Cognos iterative tasks and deliverables to the scrum master & notified the status to the team

Designed the SCM Framework model and primarily responsible to provide ABAP Functional module data for real time reporting.

Created ADHOC VIEWS in the Framework Model to facilitate Query Studio ADHOC Reporting for the Marketing Team Business Users.

Extensively Developed Reports Using Free Form SQL against Teradata Database for building complex reports.

Developed Dashboards, Complex and business Critical reports for SCM, Loss Prevention and Marketing Teams using Cognos and Tableau tools.

Created Complex Prompts in the Framework manager using Macros with the help of Parameter Maps.

Developed Complex Reports which involved Multiple Prompts, Filters, and complex Calculations and Disparate Data sources.

Developed Active Reports for Business Users.

Performed QA analysis and testing for the Cognos Reports utilizing Cognos Test cases and User stories.

Worked closely with the Business and created test cases for QA and UAT testing.

Environment: Cognos 10.2(Framework Manager, Dynamic Query integrator, Report Studio, Analysis Studio, Query Studio), Teradata 14, SQL Server 2012 and Tableau 9.1. HP ALM and JIRA Studio

TBC Corporation, Juno Beach, FL Jun 2012 – Jan 2016

Sr.Cognos Developer

TBC Corporation is one of the nation's largest vertically integrated marketers of tires for the automotive replacement market. The Company's retail operations include Company-operated tire and automotive service centers under the “Tire Kingdom", "Merchant's Tire & Auto Centers", and "National Tire & Battery" brands, and franchised stores under the "Big O Tires" brand.

Responsibilities:

Worked on gathering Business Requirements and prepared Functional Design Documents and Technical Design Documents.

Designed and developed the Implementation of Cognos Reports for CARS Project.

Co-ordinated with Teradata DBA, Teradata Database Development Team in the modification and implement reporting Requirements to the Cognos Meta data.

Implemented Best practices in model design and administrative practices to perform effective functions pertaining to the development tasks & the Cognos roadmap.

Designed the VVM Framework model and primarily responsible to provide ABAP Functional module data for real time reporting.

Created ADHOC VIEWS in the Framework Model to facilitate Query Studio ADHOC Reporting for the Business users.

Integrated Cognos Reports with CARS system coordinating with UI development Team.

Developed Dashboards, Complex and business Critical reports for Sales, Inventory, Pricing and Accounting Teams.

Created Complex Prompts in the Framework manager using Macros with the help of Parameter Maps.

Developed Complex Reports which involved Multiple Prompts, Filters, and Calculations.

Developed Active Reports for Business Users.

Developed Reports Using tableau for Marketing and Analytics Groups.

Performed QA analysis and testing for the Cognos reports utilizing Cognos Test cases and User stories.

Worked closely with the Business and created test cases for QA and UAT testing.

Environment: Cognos 10.1, 10.2(Framework Manager, Dynamic Query integrator, Report Studio, Analysis Studio, Query Studio), Teradata 13 and Teradata 14, SAP ECC, BW and SQL and Tableau.

JPMC, Dallas, TX Jan 2012 – Jun 2012

Sr.Cognos Consultant

JPMC (JP. Morgan Chase & Co.) is a leading global financial services firm operated in more than 50 Countries. JPMorgan provides a full range of investment banking and commercial banking products and services. The Global Collateral Engine (GCE) program is a comprehensive client-facing business initiative that will re-architect the collateral management platform and build out core capabilities and capacity, across the Collateral Management business within JPMorgan’s Worldwide Securities Services (WSS).GCE will provide the facility to schedule, generate, download and transfer reports to JPMC proprietary reporting application (VPR), using the Staged Reporting facility. As per the current scope of GCE Reporting, reports should be made available that replicates currently generated reports from CCMS in order for a seamless transition to be made between CCMS and GCE reports reporting services.

Responsibilities:

Co-ordinated with Captive Business Team and VPR teams in gathering Business Requirements and prepared a Functional Design Document and Technical Design Document.

Designed and developed the Implementation of Cognos Reports for GCE Reporting Project.

Co-ordinated with DBA, Database Development Team in the modification of Stored Procedures, Packages and created Reporting tables to capture Business Logic and implement Reporting Requirements to the Cognos Meta data.

Made Architectural changes to the Cognos Reporting Metadata Source Environment to suit the Business needs.

Implemented Best practices in model design and administrative practices to perform effective functions pertaining to the development tasks & the Cognos roadmap.

Designed the GCE Framework model primarily responsible to provide Adhoc and Canned Reports for SCM and Service Group Business units for the GCE Project.

Created ADHOC VIEWS in the Framework Model to facilitate Query Studio ADHOC Reporting for the Business users.

Integrated Cognos Reports with JMPC Proprietary Software VPR to support Enterprise reporting needs of JMPC.

Created reports Using Free Form SQL feature in Micro Strategy for Adhoc Reports.

Developed Free Form SQL Reports for Exceptions and Adhoc Reporting.

Performed QA analysis and testing for the Cognos reports utilizing Cognos Test cases and User stories.

Worked closely with the Business and created test cases for QA and UAT testing.

Environment: Cognos 8.4(Framework Manager, Powerplay Transformer, Report Studio, Analysis Studio, Query Studio), DB2, Oracle11g,PL/SQL and SQL.Micro Strategy Reports.

UBS Financial Services Inc, Weehawken, NJ May 2011 – Dec 2011

Sr.Cognos Consultant

UBS serves private, institutional and corporate clients worldwide, as well as retail clients in Switzerland. They combine their wealth management, investment banking and asset management businesses with their Swiss operations to deliver superior financial solutions across Worldwide.PCR project aimed to upgrade PeopleSoft CRM 8.8 Application to PeopleSoft CRM 9.1 Application including Database upgrade from Oracle 9i to Oracle 11g. My primarily role was to migrate PeopleSoft CRM 8.8 enterprise Cognos Reports to PeopleSoft CRM 9.1 and develop canned and ADHOC Reports.

Responsibilities:

Co-ordinated with Investment Centre Business Team and Service Group teams in gathering Business Requirements and prepared a Metadata Document and a Technical Design Document.

Handled the Cognos Reports migration Project End to End.

Designed and developed the migration of Cognos Reports for PeopleSoft Upgrade Project.

Co-ordinated with DBA, Oracle Developer and PeopleSoft Team in the modification of Stored Procedures, Packages and created Reporting tables to capture Business Logic and implement PeopleSoft 9.1 changes to the Cognos Meta data.

Made Architectural changes to the Cognos Reporting Metadata Source Environment to suit the Business needs.

Implemented Best practices in model design and administrative practices to perform effective functions pertaining to the development tasks & the Cognos roadmap.

Designed the PCRFramework model primarily responsible to provide Adhoc and Canned Reports for Investment Centre and Service Group Business units for the Upgrade Project.

Created ADHOC VIEWS in the Framework Model to facilitate Query Studio ADHOC Reporting for the Business users.

Created Complex Prompts in the Framework manager using Macros with the help of Parameter Maps.

Developed Complex Reports which involved Multiple Prompts, Filters, and Calculations.

Worked on Performance tuning of Reports.

Performed QA analysis and testing for the Cognos reports utilizing Cognos Test cases and User stories.

Worked closely with the Business and created test cases for QA and UAT testing.

Documented Tasks Defects and Reports in JIRA Studioduring QA and UAT testing.

Created user manuals and conducted Knowledge transfer sessions.

Environment:Cognos 8.4, 10.1(Framework Manager, Powerplay Transformer, Report Studio, Analysis Studio, Query Studio), JIRA STUDIO, T- SQL, Oracle9i, 10g, 11g,PL/SQL, SQL and JAVASCRIPT

SONIC Corporation, Oklahoma City, OK Nov 2010 – Apr 2011

Cognos Consultant

SONIC Corp. is an Oklahoma City-based, publicly held company that owns, operates and franchises SONIC Drive-Ins (NASDAQ: SONC). My primarily role was to foresee Cognos enterprise development efforts in re-designing the foundation framework model, Cognos cubes and design franchisee report sets to support their business needs.

Responsibilities:

Co-ordinated with SVP, Franchisee Groups, Market Leaders in gathering Business Requirements and translated the requirements into Wireframe Report Specifications.

Worked closely with DBA’s & ETL Architects in sourcing the data from SQL SERVER 2008 database engine in sourcing the metadata for redesigning the schema in Cognos Framework Manager

Implemented Best practices in model design and administrative practices to perform effective functions pertaining to the development tasks & the Cognos roadmap

Designed the Ideal Food Cost (IFC) Framework model primarily responsible to improve the cost-efficiency of a Store’s Food and Paper Inventory.

Developed Weekly Opportunity Store Tracking, System Variance& Ranking of Stores by Percentage food cost of Sales report sets in Cognos report studio using advanced reporting capabilities.

Developed Detail and Summary Reports based on management hierarchy with Drill Down and Drill Through capability.

Developed Complex Reports which involved Multiple Prompts, Filters, Calculations, multi-Page, multi-Query Reports.

IFC Cognos reports help in determining actual & theoretical costs calculated based on business rules& displayed with conditional formatting to highlight the data & add business value in tracking store performance using Variance as a KPI.

Worked on Agile Methodology concepts in creating user stories,providing the Cognos iterative tasks and deliverables to the scrum master & notified the status to the team

Performed QA analysis and testing for the Cognos reports utilizing Cognos Test cases and User stories

Documented reports in JIRA Studio& wire framed the guidelines for business user understanding

Environment:Cognos 8.4(Framework Manager, Powerplay Transformer, Report Studio, Analysis Studio, Query Studio), JIRA STUDIO, T- SQL, SQL SERVER 2008,PL/SQL

Client : Virginia State University, Petersburg, VA. Sep 2010 – Nov 2010

Webfocus Developer

Responsibilities:

Developed reports for Admissions, Academic History, Financial Aid and HR Reporting using Webfocus Developer Studio

Created and developed Reports for information like Grade distribution, students with repeat courses, Alpha grades list, Graduate students list etc.

Developed ad-hoc reports using Webfocus Report Assistant.

Developed Complex reports using Webfocus Developer Studio.

Created charts and drill through reports to analyse the student’s grades.

Environment:SunGard ERP Banner 7, Banner ODS, Webfocus 7.1.3, Developer Studio, MRE, HTML, Oracle 10g, PL/SQL,T-SQL, SQL Server 2005

Client: North eastern Ohio Universities Colleges of Medicine and Pharmacy,OH Jun 2010 – Aug 2010

Argos Reports Developer and Datablock Designer

Responsibilities:

Work with Business Units to define Business strategy and create a centralized Reporting capability for users to perform analytical, and ad-hoc Reporting for Business Applications and provide accurate information available to Decision Makers.

Gathered and analyzed user Requirements and Prepared Project Plan.

Conducted WebEx Sessions with users to gather Business Requirements and prepare Functional Specification.

Prepared Report Specification to Gather User Reporting Requirements.

Developed Metadata Mapping Document for Reporting needs.

Designed and Built Complex Datablocks for Dashboard and Other Complex Reports.

Designed Datablocks for Student, Advancement, Finance, Financial Aid and Accounts Receivable modules.

Developed Quick Views, Banded Reports, OLAP Cubes and Dashboards.

Environment: SunGard Banner 8x, Windows XP, Oracle 10g, Argos 3.5

Client: Murray State University, Murray, KY Jan 2010 – May 2010

Cognos Developer

Responsibilities:

Involved in the Architecture of Business Models and Data Models to implement BI for this Project

Prepared Reporting Specifications from High level Business Requirements.

Involved in Requirements, Specifications gathering and creating task plans.

Conducted online meeting with different Business Groups to gather User Requirements and Document them and Prepare Reports Specifications for Reporting needs.

Worked with Technical Team to developFramework Models to create Custom Packages to Support Reporting for AR, Financial Aid, HR and Student Modules.

Generating various List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.

Developed Detail and Summary Reports based on management hierarchy with Drill Down and Drill Through capability.

Developed Complex Reports which involved Multiple Prompts, Filters, Calculations, multi-Page, multi-Query Reports.

Developed Dashboard reports for Top Level management and Institutional Research.

Develop Test Cases, Unit Testing and Integration Testing of Cubes and Reports.

Scheduled Reports to run on a monthly, weekly and daily basis using Cognos Scheduler.

Documented entire SDLC of a Project and Prepared User Manuals and Documentation for end Users.

Environment: SunGard Banner, ODS, EDW, Oracle9i and 10g, DB2, Cognos 8BI, Frame Work Manger 8.4. Query Studio 8.4 and Report Studio 8.4, Transformer, T-SQL, Toad and SQL Server 2005.

Client: North Carolina Central University, Durham NC Aug 2009 – Dec 2009

Banner Programmer and Webfocus Developer

Responsibilities:

Consult with the functional staff on the institution's policies and procedures and gathered User Requirements.

Provide support for Student, AR and Financial Aid conversion.

Develop Business Models and Specifications required by the university to implement RMS Project.

Created Meta Data Mapping for RMS to GOLD and Banner to Gold Interfaces

Design and develop Interfaces for RMS to GOLD and Banner to Gold.

Works with the Business areas to develop Report Requirements.

Creates Business and Data Requirements for new Reports which were developed Using Webfocus

Building the primary and foreign keys across the tables based on entity-relationship diagram

Build the Complex Reports using Webfocus Tools like Developer Studio.

Generate Reports based on User Requirements on RMS to Gold and Banner to Gold Interfaces.

Creates and executes test plans/scripts to test/QA Reports and programs.

Maintain Complex Webfocus Reports for Student and Housing.

Design and Develop Reports for Registrar on CAPP and Repeat Grade Process Using Webfocus Tools.

Trained Business users to develop/use Reports using Webfocus Developer Studio.

Environment: Banner 8.X, Windows XP, Oracle 10g, SQL, PL/SQL, Toad and Webfocus 7.X

Client:North-eastern University, BostonMA Aug 2008 -July 2009

Reports Developer

Responsibilities:

Involved in the Architecture of Business Models and Data Models to implement BI for this Project

Designed several Reports using Oracle Discoverer on ODS and EDW Environment.

Tuned Performance of the Oracle Reports in Oracle Discoverer.

Participated in the detailed requirement Analysis for the Design of Materialized views to meet end user Requirements.

Designed CognosQuery Studio framework for Finance, Financial Aid and Accounts Receivable modules and Built Custom Packages.

Supported Student, Accounts Receivable, Financial Aid, Advancement and Finance report writers with their needs for CognosFramework and objects.

Administered Cognos by creating various Roles, Groups and provided Access to various users according to the Client needs. Designed several reports using CognosReport Studio on ODS and EDW environment.

Design and develop materialized views for Capturing Catalog and Schedule Data based on User Requirements.

Built Custom ODS for Catalog and Schedule Data for Users to generate Reports.

Environment: Banner 8.X, Windows XP, Erwin, Oracle 10g, SQL, PL/SQL, Oracle Discoverer, Cognos 8BI, Frame Work Manger 8.3. Query Studio 8.3 and Report Studio 8.3, Power Play Transformer PLSQL Developer.

Client: University of California, Los Angeles, CA Jan 2008 – Aug 2008

Cognos Consultant

Responsibilities:

Requirement gathering from the Customers and documenting the High Level Requirements.

Prepare Reports Specifications from High level Business Requirements.

Worked with Functional and Technical Teams to develop Reports for Advancement, Finance, HR and Student Modules.

Developed Meta Data Mapping Document ODS to Banner Mapping.

Created OLAP Cubes using Transformer.

Cube with alternate hierarchies and sub Dimensions.

Partitioning of Cube and optimization of Cube to enable performance improvement.

Design document and unit test case creation and execution.

Created Dashboard Reports from the OLAP source.

Implemented the Dashboard Reports with the various Cognos Dimensional Functions.

Involved in Documentation and Training Users and Business Partners on Query and Report Studio for Ad Hoc Reporting.

Environment: Cognos BI 8, Frame Work Manger, Transformer, Analysis Studio, Report Studio, Toad and MS SQL Server 2005.

Client: Galada Power, Hyderabad Jun 2005 – Dec 2006

Programmer Analyst

Responsibilities:

Involved in the Requirement Analysis and Preparation of System Requirement Specification Document.

Involved in the Database Design Preparing the Codification Schemes. Preparing the Data Dictionary.

Designing the Screen, Report and Query layouts. Involved in Coding Using Developer/2000 (Forms 6.5 and Reports 6.5), PL/SQL Stored Procedures and Database Triggers.

Involved in Unit Testing and Integration Testing.

Involved in Acceptance Test by the Customer.

Designed screens for billing module.

Extensively involved in creating database packages, procedures, functions, cursors and triggers using PL/SQL.

Developed Oracle Forms and Reports.

Generated reports from the sales and distribution package such as sales analysis report, profile wise reports etc.

Written Procedures and Functions of calculation of Receipts.

Environment: Oracle 8i, PL/SQL, Oracle Forms 6i, Reports 6i, Windows NT

Education:

Master of Science in Information Technology

Master of Computer Applications

Bachelor of Commerce

References are available upon Request

Contact this candidate