CHANDU

Email: acql2q@r.postjobfree.com

Phone: 630-***-****

Overview

Highly Skilled Professional with over 15 years of IT industry of Software Development experience in the analysis, design, development, testing, documentation and implementation of Business Intelligence solutions.

Extensive experience in developing Cognos 10.x/8.x Framework Manager (DMR, Relational) Models, Report Studio Reports, Query Studio Reports, Analysis Studio Reports, Event Studio Reports, Cognos Connection, Portlets, Cognos EP Series 7, Impromptu Reports, Catalogs, Powerplay Transformer Cubes, Cognos Configurations, Cognos Powerplay Web, Pwerplay Enterprise Server, Impromptu Web Reports, Upfront, Macros and Architect.

Hands-on experience in Dimensional Modeling Framework Manager and also experienced in working with different data sources including Oracle, DB2, MS SQL Server, flat files, Excel and Access

Excellent communication and interpersonal skills.

Expertise in managing projects, clients and supporting projects.

Expertise in Providing Best Practices and Debugging Issues.

Expertise in interaction with the Users and as per the user requirements, analyzed, designed and generated the Business Reports.

Expertise in system study, analysis, design, development, testing, implementation and documentation

Strong experience in coding using SQL, SQL*Plus, PL/SQL Procedures/Functions,

Obtained Achievement Award of Excellence for outstanding performance.

Technical Competencies

BI/ETL TOOLS:Cognos 10.x/8.x/1.x (Framework Manager,Report Studio,Event Studio,Metric Studio,Query Studio,Analysis Studio,Cognos Connection), TM1, TM1 Turbo Integrator, TM1 Architect, TM1 Perspecitve, TM1 Server, Cognos Series Suite 7.x/6.x/5.x (Impromptu,PowerPlay Transformer,PowerPlay Enterprise Server,Cognos Up Front Server),SAP BW,Access Manger,Informatica,Data Manager, Stored Procedures,SQL*Plus,TOAD, SQL Loader,MS Excel.

RDBMS: Oracle 11g/10g/9i/8i/ EXADATA, MYSQL, SQL Server, DB2, UDB, TeraData, TeraData SQL Assistant

SERVERS: PowerPlay Enterprise Server, MS IIS, Netscape Directory Server, Active Directory Server, WebLogic, iPlanet, Apache.

LANGUAGES: Java Script, VBScript, HTML, DHTML, XML, Java, Servlets, EJB, JSP, J2EE, C, C++, SQL, PL/SQL, Visual Basic 5.0/ 6.0, ASP.

OPERATING SYSTEMS: Windows XP, Windows NT,Windows 2000 and Unix (Sun, HP, AIX), OS39 and, AS400.

Education:

Masters in Hyderabad, India

A Cognos Certified ReportNet Product Professional in Advanced Report Authoring.

A Cognos Certified ReportNet Product User.

A Cognos Certified Series 7 Products Authors.

A Cognos BI Certified.

A Microsoft Certified Professional (MCP)

PROFESSIONAL EXPERIENCE

Cleint: Ceasars Entertainment, Las Vegas, NV

Sr Cognos Consultant: Nov 14 – Till Date

Requirement analysis with End Users and BA’s for Enterprise Bank System

Creating Cognos Complex Reports and Performance Tuning of Reports.

Providing Cognos Solutions for End Users as well as Business Owners.

Debugging Reports and validating the data in the database.

ETL Mapping, Data Validations and Data Integration from various properties in to EBS.

Creating FM Models Complex Reports using Packages and custom SQLs using the Best Practices.

Recommendations including Security, Deployment Process, Folder Structure, Tips and Techniques and implemented Processes and Procedures for Cognos Implementation.

Environment: Cognos 10.2, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Framework Manager, Teradata, Informix and LDAP

Client: University of Southern California, (USC), Los Angeles, CA

Sr. Cognos Consultant Jan 13 – Oct 14

Requirement analysis with End Users and BAs for TARA Project.

Provided Cognos Solutions to TARA Users and Best practices to the Team.

Designed EDW in MYSQL, creating Tables and ETL mappings for Research Reporting and GL/Financial reporting.

Created Technical documents ETL and Reports.

Implemented Cognos Architecture for production.

Worked on Data Cleansing and Data Mappings from Legacy systems to new KC/EDW system.

Technical lead handling the TARA and KFS Projects, and responsible for team and their day to day activities.

Provided Cognos Solutions for Users as well as Business Owners.

Created FM Models Complex Reports using Packages and custom SQLs using the Best Practices.

Recommendations including Security, Deployment Process, Folder Structure, Tips and Techniques and implemented Processes and Procedures for Cognos Implementation.

Debugging Reports and validating the data in the database.

Recommendations to DW Team for designing ETL, Data Marts and Tables.

Provided Adhoc solutions for End Users.

Performance Tuning of Cognos Complex Reports.

Environment: Cognos Series 10.2/10.1, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Framework Manager, Powerplay Transformer, MYSQL, Security, Kuali Coeus (KC), Kuali Financial System and HR Workday.

Client: Saxon, (India )

Cognos Architect Sep 12 – Dec 12

Requirement analysis with End Users & gathering Business Requirements.

Involved in Presales and Sales for BI.

Involved in BI Marketing Strategy.

Built and Lead the Cognos team successfully.

Created Content and PowerPoint Presentations for Sales and Presales Teams.

Created BI Strategy and Roadmap

Created FM Models using FM and Cubes using Transformer for various Analytics.

Environment: Cognos Series 10.1/ 8.4, Cognos Connection, Report Studio, Query Studio, Framework Manager, Splunk, Powerplay Transformer.

Client: Alliant Energy, WI

Sr Cognos Consultant / BI Tech Lead Nov 10 – Jun 12

Participated in project scope identification, data architecture development and project planning in coordination with other team leads of data warehousing project.

Requirement analysis with End Users & gathering Business Requirements and design of HR, Supply Chain and Financial Analytics.

Providing Standards and Best Practices and Mentoring the Team to the team.

Coordinating with End Users for UAT.

Created FM Models using FM for Analytics.

Created Transformer Models and various Cognos Reports for new Analytics.

Developed various dashboard & Score Card Reports using Report Studio.

Setting Up Drill Thru Reports for Powerplay Studio Cubes in 8.4 environment.

Converting IQD based Cubes in to Framework Manager/ Transformer Models.

On Call Production Support and Maintenance.

Identified LDAP Security Groups/ Roles for each Analytics.

Working on Project Deliverables.

Environment: Cognos Series 8.4, Cognos Connection, Report Studio, Query Studio, Framework Manager, Analysis Studio, Powerplay Studio, Powerplay Transformer, Powerplay Client, DMR, Informatica, HTML, Java Scripts, LDAP, Oracle, People Soft, Macros.

Client: Sig Sauer, NH May 11 – Jul 11

Sr Cognos Consultant (Remote Project)

Designed Forecast Snapshot data model for Forecast and Inventory Analytics using Adaptive Warehouse.

Created source to target mappings in Adaptive Warehouse.

Extracted and Loaded data using Adaptive Warehouse.

Created/updated DMR and Relational FM Models and Packages using Adaptive Warehouse.

Created Complex Report Studio Reports in Forecast, Inventory and WIP using Report Studio.

Created Sig Sauer Manufacturing, Inventory and sales reports in Report Studio.

Environment: Cognos Series 8.4.x, Cognos Connection, Report Studio, Query Studio, Framework Manager, Adaptive Warehouse 8.4.x, DMR, HTML, Java Scripts, Oracle.

Client: Shopbop, Amazon, WI

Sr Cognos Consultant Jul 10 – Nov 10

Participated in project scope identification, data architecture development and project planning in coordination with other teams of data warehousing.

Gathered business requirements from End Users.

Created FM Models using FM.

Created Dashboard Reports for Forecasting, Planning and Analysis.

Created Complex Report Studio Reports for various business areas Sales, Finance and HR.

Environment: Cognos Series 8.4, Cognos Connection, Report Studio, Query Studio, Framework Manager, Analysis Studio, Powerplay Transformer, Powerplay Client, DMR, Informatica, Tomcat, HTML, Java Scripts, LDAP, Oracle.

Client: Medco, NJ

Sr Architect/ Tech Lead Mar 09 – Jul 10

Interacting with Metric Managers and End Users to Gather Requirements.

Preparing Cognos Report Technical Documents.

Created DMR/ OLAP Models using FM. Also created FM Models/Packages.

Created SOP for Deployment, Security, Migration, and Requesting Access.

Created Development Standards and Best Practices.

Developed various Dash Board Reports using Report Studio

Implemented Best Practices, Performance Tips in FM Models, Packages and Transformer Cubes.

Expert in Debugging issues in Cognos 8.4/8.x.

Created Various Portlets in Cognos Connection.

Maintained Security throughout the company using LDAP.

Production Support and maintainace(Cognos daily activities support).

Migrated from Clipper application and Medco Legacy Systems to Cognos 8.4.

Some of my main Administration roles Security setup for all users, Deployment activities against Dev/QA/Prod environments, Scheduling, Monitoring servers, schedule jobs.

Implemented Java Script in Report Studio.

Tested reports with Manual SQL.

Environment: Cognos Series 8.4, Cognos Connection, Report Studio, Query Studio, Framework Manager, Analysis Studio, Powerplay Transformer, Powerplay Client, DMR, Abinitio, Tomcat, HTML, JAVA, JSP, Java Scripts, LDAP, ETL, Oracle, Teradata, AIX, XP and XML.

Client: Thomson LLC. / Solucient LLC, IL May 06 – Feb 09

Sr Cognos Consultant

Client: Blue Cross Blue Shield, IL Oct’ 05 – Apr’ 06

Sr System Analyst / Cognos Lead & Modeler & Administrator

Client: Hewitt Associates, IL Feb’ 02 - Oct’ 05

Sr System Analyst/ Sr Software Eng to serve as a Lead/ Cognos Tech Lead & Modeler

Client: Cyborg Systems (A Hewitt’s Company)., IL May’ 01 - Jan’ 02

Cognos Administrator and Sr. Developer to server as a Lead Role

Informatica

Client: Ethicon Inc. (Johnson & Johnson), NJ Jul ’00 - May’ 01

Sr. Cognos Developer

Contact this candidate