Manager Reports

Chaitanya Vadde

Sr.BI Developer

E-Mail: ***********@*****.***

Phone: 571-***-****

Summary:

10+ years of IT experience with IBM Cognos Business Intelligence Suit; including Report Studio, Query Studio, Analysis Studio, Event Studio, Workspace, Workspace Advanced, Framework Manager and TM1, Transformer and Cubes.

Hands on experience in Cognos 11,10.2.2, 8.4, 8.3 and 8.2., Dynamic Cubes, TM1 (9.5), Tableau and QlikView

Professional level skills in implementing and designing XML, CSS, HTML, JavaScript, DHTML, VSS, CSS, Bug Zilla, ERP client server applications, and web ERP applications.

Experience in creating Relational and Dimensional models using Framework manager, Power play transformer and Impromptu.

Experience in building of multi dimensional Cubes using Cognos Power Play Transformer, Dynamic Cubes.

Extensive experience in creating Dashboards and Reports using OLAP Package and DMR Package.

Experience in Installation and Creation of Content Store, Content Manager.

Experience in Installation & Configuring the Cognos 10/8/7i tools on distributed environment and Windows

Experience in Deploying models and reports from Development to Production and administering users/groups/roles

Experience in OLTP/OLAP/ROLAP/MOLAP System Study, Analysis and ER Modeling, Maintaining Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.

Have experience with Business Analysis, requirement gathering, Business Process reengineering. Interfaced extensively with Management, Users and technical teams. Liaison with other project teams and system owners to help define companywide reporting requirements.

Maintain deep understanding of the BI product (IBM Cognos and TM1) from a technical perspective.

Good exposure in Relational Databases (Oracle, MS SQL server, DB2 and MS Access) for modeling and for supporting analytical and reporting needs of Corporate Business needs.

Experience in Database optimization and SQL tuning in Oracle 9i /10g and SQL Server.

Experience with MDX Functions in Report Studio using Multi-Dimensional Source.

Experienced with trouble shooting and optimizing cube performance.

Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually.

Developed Tableau workbooks from multiple data sources using Data Blending.

Delivered advanced/complex reporting solutions such as Dashboards and Standardized reporting using Qlikview11.

Created Dashboards with different style using QlikView components like List Box, Slider, Buttons, charts and Bookmarks.

Self-motivated and possess excellent critical thinking ability, good interpersonal and communication skills.

Highly skilled and experienced in Agile, SDLC Development process for diverse requirements.

Technical Skills:

COGNOS BI: Cognos 11, 10.2,10 and 8.4 BI Series (Report Net, Framework manager, Power play,Go office), Cognos 7 BI Series (Dynamic Cubes, Report Net, Impromptu, Power play and Content Manager) and TM1 9.5: TM1 Perspective for MS excels, TM1 Web and Turbo Integrator

OPERATING SYSTEMS: Windows Family and Linux

LANGUAGES: ASP.Net, C#.Net and VB.Net

DATABASES: SQL Server 2000/2005/2008, Oracle 9i10g

WEB PRESENTATION: JavaScript, HTML, DHTML, CSS

Education:

M.C.A (Masters of Computer Applications) from Osmania University, India

B.Sc. (Bachelor of Computer Science) from Kakatiya University, India

Professional Experience

New York State of Health Albany (Accenture), Albany, NY Dec ’16 – Present

BI Specialist

Gathered Business requirements and designed functional and technical requirement and design documentation.

Created Enterprise-wide Framework Manager Models, Developed multi-dimensional and relational packages (ROLAP and MOLAP).

Created database layer, business layer and presentation layer, defining appropriate relationship between query subjects in Framework Manager.

Created Framework model for ad-hoc reporting needs of the business and training users to build and customize their ad-hoc reports in Query Studio.

Implemented Framework manager security for Data access, Object level access and Package level access based on different line business.

Design and Build of TM1 solution in an iterative fashion to incorporate user feedback early in the project.

Cognos TM1 model and application design.

Design and development the required report – selected by the user in the TM1 active forms.

We developed the solution in TM1 which they can use to load the data into TM1 model using TI processes from different sources then they used the Active sheets reports to do their analysis in MS Excel sheets.

Involved in the Installation and Configuration of Cognos 10 BI tools and Framework Manager

Created reports for Eligibility, Enrollment, Effectuation and Application line of business.

Created Enrollment, Coverage, Assistor, Individual New Enrollment and Comparison reports to Identity the change of activity (Cancellation, Termination, Open/Close and Aid Categories) based selected Dimensional values.

Developed dashboards for Qualified Health Plan, Essential Plan, Medicaid and Child Health Plus.

Developed Operational and Executive Dashboard for senior executive management which gives an overview of the number of enrollments counts as-off point in time.

Created test plan SQL scripts for validating data coming from Framework model and reports

Developed Reports with Multiple Cognos Viewers and with multiple Cognos Reports Integrated into a Single Page Report.

Created Active Reports, List, Crosstab, Dashboard Reports and Drill-Through Reports using advanced reporting techniques in Cognos.

Customized data by adding advanced prompts, Filters, Calculations, Summaries and Functions.

Created Dynamic and multilevel grouping reporting where user as flexibility to slice and dice the data. Provided end users with an easy-to-consume interface.

Worked on the complex prompt page design of various reports.

Used JavaScript for certain validations to overcome the limitations in Cognos report studio.

Created Active Reports to provided ideal solution for remote users. Leveraged existing reports and converted them to Active Reports by adding interactive behavior, provided end users with an easy-to-consume interface.

Uploaded and Created RAVE Visualization Charts and Customized color palette and Style as per DOH standards.

Built variety of Executive Visualization Dashboards for a quick glance of various attributes/KPIs for Executive management using JavaScript in order to Extend and Customize the reporting functionality and Advance data visualization for presentation experience.

Provided daily ERP support to all end users for health operations.

Assisted consultants implementing Cost point ERP on an acquired program.

Conducted Training sessions to the User groups on Report Views, Scheduling, Query Studio, Business Insight, and Business Insight Advanced.

Assisted the users on Production for the latest enhancements and Perform troubleshoot on all Cognos helpdesk tickets and resolve all queries for content; prepare standard reports and ensure accuracy of the same.

Created Test Plan and involved in test cases preparation and execution of the test plan

Responsible to Manage/track/production issues/document defects and retest defects as needed.

Environment: Cognos 10.2 Series [Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Power Play, Work Space, Cognos Connection], Cognos Analytics V11, TM1, SQL-Server2005/2008.

Laureate Education Inc., Baltimore, MD Dec ’11 – Dec’16

BI Specialist

Design & development of the reports and Dashboards using Cognos11, Cognos10.2, Cognos10 and Cognos8.4.

Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports.

Installed Cognos and Created Content store, Content Store Manager.

I have also knowledge in Cognos Installation, Cognos Workspace, Ldap Active Directory Installation and configuration.

Defining appropriate relationships between query subjects and Fact Table Framework Manager.

Understanding of Cognos BI security model and implement. The security according to the requirements.

Designed reports for HRIS system for global companies with in the business.

Designed reports for Compensation, Benefits, Payroll, Tax and Treasury departments.

Designed different form reports for daily business use like Compensation Profile, Employee Data Auditing Profile, and Employee Data Change Forms etc.

Created multiple Dashboards like Human Capital, Executive, and Performance Rating.

Created Reports and Dashboards to Identity the change of activity (New Hire, Termination, Promotion’s, suspension, Performance Rating and Turnover)

Designed Home Page as a report library to view all the reports and dashboards in one view based on the Employee security.

Integrated Cognos TM1 with Cognos BI and performed BI Reporting.

Increased Performance by Monitoring Stats by Cube and TM1 Top Utility.

Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).

Design and Developing the EIS Dashboard Reports for Key Performance Metrics.

Design and Developed Dashboard Reports with Cognos Analytics.

Creating the List Reports, Charts, Drill Through Reports and Multilingual Reports Using Report Studio and Query Studio.

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio, Burst Reports against database.

Schedule the reports based on business requirements with security settings.

Administered by setting up the Cognos security settings at package, report level using the Cognos connection administration portal with restricted features depending on the class of user.

Creating prompts with query macros by including references to parameter maps.

Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.

Creating the Cognos Report studio reports for EIS model.

Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.

Involved into move to Deployment to UAT and Production.

Created Transformer cubes for Ad Hoc Reporting.

Involved in production support and troubleshoot/test issues with existing reports and cubes.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

Developed Tableau visualizations and dashboards using Tableau Desktop.

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Developed Tableau workbooks from multiple data sources using Data Blending.

Restricted data for particular users using Row level security and User filters in Tableau.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Delivered advanced/complex reporting solutions such as Dashboards and Standardized reporting using Qlikview11.

Created Dashboards with different style using QlikView components like List Box, Slider, Buttons, charts and Bookmarks.

Assisted the users on Production for the latest enhancements and Perform troubleshoot on all Cognos helpdesk tickets and resolve all queries for content; prepare standard reports and ensure accuracy of the same.

Provided Cognos On-Call Technical support for international users (Mexico, Brazil, Chile, Peru, Panama, Australia, India, Turkey, Chania, Saudi Arabia).

Environment: Cognos 10.2, Cognos 10, Cognos BI 8.4 Series [Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Power Play, Work Space, Cognos Connection, Transformer, Dynamic Cubes], TM1, Tableau, QlikView, SQL-Server2005/2008.

Upani Consultants Ltd, Phoenixville, PA Sep ’10 – Nov ’11

Cognos Developer

Design & development of the reports and Dashboards using Cognos10 and Cognos8.4.

Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports.

Installed Cognos and Created Content store, Content Store Manager.

Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).

Design and Developing the EIS Dashboard Reports for Key Performance Metrics.

Creating the List Reports, Charts, Drill Through Reports and Multilingual Reports Using Report Studio and Query Studio.

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio, Burst Reports against database.

Schedule the reports based on business requirements with security settings.

Creating prompts with query macros by including references to parameter maps.

Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.

Design and Developed the Framework Manager models using Stored Procedures, Relational tables and Published into server.

Defining appropriate relationships between query subjects and Fact Table Framework Manager.

Understanding of Cognos BI security model and implement. The security according to the requirements.

Creating the Cognos Report studio reports for EIS model.

Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.

Involved into move to Deployment to UAT and Production.

Involved in production support and troubleshoot/test issues with existing reports and cubes.

Environment: Cognos BI 8.4 Series [Report Studio, Framework Manager, Query Studio, Event Studio, Cognos Connection], SQL-Server2005.

Nete Soft India Ltd, India Feb ’07 – Aug ’10

Junior Cognos Developer

Created List Reports, Crosstab Reports, Chart Reports, Drill-Down and Drill-Through Reports.

Gathered and analyzed business requirements from business users.

Organized, applied security, Scheduled and Distributed reports via Cognos Connection.

Developed reports using prompts, filters, query calculations, cascading prompts and conditional formatting using Report Studio.

Metadata Modeling using Framework Manager; created relational and dimensional models, query subjects, filters and packages.

Applied Data level security, Object level security prior to Publishing packages to Cognos Connection.

Developed complex reports using drill-through and Master Detail functionalities in Report Studio.

Actively involved in fixing issues, and defects in the reports, FM Models, or any environment related items.

Created the Cognos Report Studio reports for EIS model.

Unit testing, integration testing and system testing of the reports in development, performance and production environments.

Trained users on Query Studio for Ad-Hoc reporting.

Moved to deployment to UAT and production.

Involved in production support and troubleshoot/test issues with existing reports and cubes.

Worked with users directly upon their tickets and helping them

Environment: Cognos BI 8.4 Series [Report Studio, Framework Manager, Query Studio, Event Studio, Cognos Connection, Oracle 10g.

Contact this candidate