Senior Cognos Developer

madhukar P

Ph: 469-***-****

Email: **************@*****.***

Cognos Developer/Administrator having around 9+ years of experience in Software Design, Development, administration, analysis, testing, Data Warehouse and Business Intelligence tools

Hands on experience in Cognos 11/10/8 series (Workspace,Workspace Advanced,Query Studio, Report Studio, Analysis Studio, Framework Manager, Cognos Connection) and Cognos Series 7.x (Cognos Report net 1.1, Cognos Impromptu, Cognos Power Play Transformer, Cognos Power Play, Cognos Scheduler, Cognos Access Manager, Upfront).

Very good Experience on Installation & Configuring the Cognos 11.0.x/10.x/8.x tools in distributed environments on Windows/Unix.

Very good knowledge on writing the Windows bat files and Perl scripts for building automatic cube builds.

Experienced with Metadata modeling using Framework Manager, creating Projects, Models, Packages, Security and Parameter mapping techniques.

Hands on experience in Report building (Crosstab, List, Dashboard reports) using Report Studio and Analysis Studio.

Very good experience in implementing advanced routing on Cognos servers based on licensing and server capacities,for efficient performance.

Experience developing complex reports using drill-through reports, prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos.

Experience with Transformer models and cubes that were used in Power play analysis and also these cubes were used in various Analysis Studio reports.

Extensive experience with Cognos security (LDAP, Active Directory, Access manager, object level security, and data security).

Sound Skills in developing SQL Scripts, PL/SQL Stored Procedures, Triggers, Functions and Packages.

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.

Hands on experience on ETL tools like Informatica & Data Stage.

Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.

TOOLS / METHODS

Cognos 11.0.x(COGNOS Analytics)/10.2.x/10.1.x/8.x, Cognos Administration, CognosImpromptu7x,Impromptu Web Reports (IWR), Power Play, Power Play Transformer 7x/6x,

Upfront, Power Play Enterprise Server,

ORACLE 8i/9i/10g/11g/12c,SQL Server 2012/2014 DB2, Teradata, Erwin, Microsoft Visio.

SQL Server Integration Services (SSIS), Informatica,Datastage.

HTML, XML, Flash, JAVASCRIPT, IIS, IE.Netscape Enterprise Server,

JAVASCRIPT,PERL SCRIPT.

PROFESSIONAL EXPERIENCE

North Dakota Information Technology (NDIT), Bismarck,ND Jan’16-Present

Role:Cognos Developer

Description:The North Dakota Information Technology Department (ITD) supports the IT needs of state government, DHS, DOT and higher education. Because of the diverse needs of state entities, ITD provides varied amounts of support to state government. Most of the state organizations utilize ITD for all of their IT needs. During this Project I have been primarily utilized in the STIP,PACER, RIMS projects for Department of Transportation(DOT) & SPACES,AFCARS,NYTD,NCAND for Deparment of Human Services ND(DHS).

Responsibilities:

Migrated the reports from Cognos10.2.2 to Cognos Analytics(11).

Created the Workspace and Workspace Advanced dashboards .

Created multiple layer reports providing a comprehensive and detailed report with drill-through capability.

Created multi-dimensional cubes using Transformerthe IQDs which is generated from Framework Manager by externalizing the query subjects.

Published and developed framework manager packages to the cognos portal.

Developed transformer models to create cubes and publish them into portal.

Created and set up the security for all Employer groups.

Security has been applied at transformer model level, dimension level, package level and object level.

Developed Dashboards, reports and book of business using cube source data.

Responsible to migrate developed Dashboards and reports between Cognos Environments.

Designed Framework Manager Model, created iqds for powerplay cubes.

Build the cubes using transformer model and set up the user security in the cubes.

Mentoring team members to help them gain an understanding of the technical features of Cognos software at ITD

Performed DATA Quality Check using TALEND.

Developed multi-dimensional cubes using PowerPlay Transformer and published to Cognos Connection for use with Analysis Studio.

Built Multi-Dimensional Power Cubes (DMR) using Power Play Transformer by using IQD as a Data Source based on Oracle, Teradata databases.

Created dimension views and User views to implement the data security in the Powerplay Transformer Model. Defined Cube groups to implement security based on dimension level values.

Producing technical documentation in a professional manner that is sufficient for the team to understand our Cognos installation.

Supporting role in Cognos tools and Analysis Studio cube creation for all data marts, including metadata modeling in Framework Manager.

Environment: Cognos Suite 11.0.x/10.2.x (Workspace,Workspace Advanced,Report Studio, Active reports, Query Studio, Analysis Studio, Cognos Connection, Active reports, Framework Manager, PowerPlay Transformer), SQL Server,ORACLE PL SQL, TALEND,Power Designer .

Department Of Social Services Richmond,VA March’15-Jan’16

Role: Cognos Developer/Administrator

Description: Department of Social service deals with the reports Cash Assitance,Child Care Assitance(DCSE),Child Support,Food Assitance(SNAP),Medial Assitance and Energy Assitance Reports. During this Project I have been primarily utilized in the Data Warehouse team to administer, install, upgrade, and configure the COGNOS software used in the organizations data warehouse.

Responsibilities:

COGNOS Administration for: the Data Warehouse Portal, Group Security, Reports, Cube definition, Cognos Workspace, Cognos Workspace Advanced, Cognos Insight, and Cognos for MS Office.

Installing, configuring, and upgrading Cognos software, including setting up load balancing for Cognos Environment FROM 10.2.1 to 10.2.2 FP3

Upgrading the audit database tables using the SQL Scripts

Updating the Perl Scripts for automatic cube builds

Responsible for working with IBM for incidents rose during developmet and productions migrations

Involved in managing an enterprise-wide effort of identifying the Key Performance Indicators(KPIs)acroos all the domains of the organization.These KPIs will be used to develop a corporate dashboard to facilitate fact based decision making.

Trouble shooting when problems occur, and helping to resolve performance and configuration problems

Migration between our test and production environments

Developing packages in Framework Manager when necessary

COGNOS development of Reports and Analysis Studio cubes as needed and as work schedule permits, including sophisticated reports and dashboards

Work as a team member for the completion of Data Warehouse Projects

Mentoring team members to help them gain an understanding of the technical features of Cognos software at DSS

Producing technical documentation in a professional manner that is sufficient for the team to understand our Cognos installation.

Mentoring and knowledge transfer to full time Cognos Senior Developer Analyst once hired.

Supporting role in Cognos tools and Analysis Studio cube creation for all data marts, including metadata modeling in Framework Manager.

Environment: Cognos Suite 10.2.2/10.2.1 (Report Studio, Active reports, Query Studio, Analysis Studio, Cognos Connection, Business Insight,Framework Manager, PowerPlay Transformer, PowerPlay Web), Oracle10g/12c,SQL Server,,Informatica Power Center.

SEABOARD FOODS, KansasCity, KS Jan’15-Mar’15

Role:Cognos BI Developer/Informatica Developer

Description:Seaboard foods is an integrated food company producing Prairie Fresh Premium Pork and Daily’s Premium Meat.Seaboard Corporation operates three core businesses pork production and processing, ocean transportationand grain processing and trading. Subsidiaries also engage in sugar and citrus fruit production and processing as well as electric power generation.The project was developed for ERM(Environmental Resource Management).

Responsibilities:

Created the transformations using Informatica Power Center and created the views in the Management Studio

Gathered all the end user requirements and developed reports accordingly.

Created dashboard reports for the management to give multidimensional view of the business.

Developed very complex Active reports in a multidimensional environment using Transformer Cubes.

Developed ETL mappings and workflows to facilitate dimension and fact data loads in the datawarehouse

Saved and distributed the active report (.mht) through emails.

Created transformer models and built cubes based on the requirements and also created drill through reports for the cubes.

Altered calculations in the Report studio for the Active report and Making enhancements of the reports based upon the requirements of the user.

Created the calculations, filters and prompts in framework manager and user defined functions, procedures and packages at the database level as per the requirements.

Designed standard reports in report studio and also developed ad-hoc reports in query studio

Created functions and procedures at the database level to simplify complex business logic in reports.

Scheduled the reports to run monthly based on the updates of the cube using schedule management tool in Cognos connection.

Designed required Packages in Framework manager using database tables, views and stored procedures.

Organized metadata into star schema groups to best suit the business model.

Documented all the processes and created data dictionary.

Generated stored procedures to use in the framework manager to create the required packages.

Created burst reports to distribute reports to different end users.

Modified the existing report based upon the change request by the user.

Environment: Cognos Suite 10.2/10/8.4 (Report Studio, Active reports, Query Studio, Analysis Studio, Cognos Connection, Business Insight,Framework Manager, PowerPlay Transformer, PowerPlay Web), SQL Server,,Informatica Power Center .

MALLINCKRODT PHARMACEUTICALS, St.louis, MO Sep’13-Dec’14

Role: Cognos BI Developer/Administrator

Description:Mallinckrodt Pharmaceuticals is a leader in controlled substance generic pharmaceuticals and all it’s generic’s are made in United states. It’s top eight products are top three in US market share. The project was developed for Sales Analystation System which was undertaken to manage information about the Actual Budget,Compensable Sales,Products,customers of Mallinckrodt Pharmaceuticals

Responsibilities:

Install, configure and administer the departmental Cognos 10.2.2 multi-level virtual server operating environment under the Windows platform.

Coordinate with user departments on any system fine tuning or enhancementrequired.

Install quick fixes and patches update users accordingly.

Maintain the Cognos metadata layer in its Framework manager system.

Set the operating guidelines and standards for system development.

Tested reports in different environments like Dev, UAT, and Prod.

Validated the data to support the business requirements which is accurately reflected in an implemented solution.

Performed advanced editing of the reports Using IBM Cognos Work Space

Upgraded the Reports from Cognos 8.4 to Cognos 10.2.2

Created Bat files to build the cubes automatically and automated the backups,installs using Cognos SDK

Developed very complex Active reports in a multidimensional environment using Transformer Cubes

Used Framework Manager to build models, packages, Query Subjects, Query items, Relationships, Calculations, Filters, Functions, Folders, data Sources and publish packages.

Created and maintained Cognos packages in Framework Manager.

Applied the Conditional Formatting using the conditional variables to highlight the data and rendering the objects.

Developed the complex reports using Query Calculation and Layout Calculation.

Validated the Reports with database and review the Reports and test cases.

Exported reports into various Formats like PDF, HTML, Excel and Word for the Users.

Developed dashboards for accurate on-time representation of financial data and cash flow analysis.

Deployed Packages and Reports from DEV Environment to UAT and PROD Environments.

Created Dimensionally Modeled relational data (DMR) in Framework Manager.

Created Scheduled Jobs by scheduling multiple reports in a job.

Applied Security in Cognos Connection by controlling privileges for users, groups and roles to the various packages, reports & dashboards.

Created Security at Object Level, Data Level and Package Level.

Environment: Cognos 10.2.2/8.4(Report Studio, Query Studio, Analysis Studio, Cognos Work Space,Cognos Connection, Powerplay Transformer, Framework Manager),Active reports(Mobility), Cognos SDK,Cognos Access Manager,Cognos Go Office, Oracle 10g, TOAD, PL/SQL Server 2005,DB2, infoAdvantage, JAVA Scripts,XML and Windows NT/4.0.

MAYO CLINIC, Rochester, MN Aug’ 11 – Aug’ 13

Role:Sr.CognosBI Developer/Administrator

Description: This project was developed based on total automation of hospital management. It was a comprehensive package, which dealt with inpatient, outpatient, laboratory, pharmacy, operation theatre and administration modules. My job was to work on outpatient, inpatient modules and reports related to above. I was responsible for creation of Impromptu reports, which provided users the ability to access, analyze, and share information in the company’s database.

Responsibilities:

Gathered Business Requirements to develop reports using IBM Cognos 10.1

Analyzed, designed, built and tested reporting solutions based on business requirements.

Ensured the quality of the data and reviewed it periodically.

Involved in upgrading existing reports in cognos 8.4 to cognos 10.1.

Involved in the production support working with various mitigation tickets and user requests.

Developed,managed and monitored testing and production environment.

Applied Security and User Authentication to the various User Groups.

Created Framework Manager models including relationships, filters, aggregations, rollup processing, calculations, organized folders, merged query subjects, aliases, shortcuts, database layer, business layer, presentation layer, and have setup data/object security and successfully published the packages.

Applied the security and User Authenication to the various User Groups.

Created different reports using Query Studio and Report Studio.

Developed very complex Active reports in a multidimensional environment using Transformer Cubes

Developed various reports like List reports, Cross Tab reports and Drill through Reports using Report studio.

Developed several complex reports using cascaded prompts, Drill Through, master-detail relationships, Page sets, Joins, Unions using report studio.

Worked extensively on conditional variables utilizing conditional explorer in report studio.

Created, organized and formatted reports, folders and other contents on Cognos Connection portal.

Created joins with queries in Report Studio to generate the required Report queries.

Extensively worked on Dashboards using report studio including render variables, master-detail relationships, singletons, prompts, filters, Conditional variables, HTML items, layout component reference and formatting the objects within report design.

Tested reports for uniqueness of data using Toad.

Also performed unit/system testing of the reporting application including analysis of the data and wrote a number of SQL queries against Oracle database using Toad 10.6.

Resolved technically complex assignments and mentored junior staff.

Worked on Toad 10.6 for writing, updating and modifying the SQL Queries.

Developed very complex Active reports in a multidimensional environment using Transformer Cubes

Developed very complex Active reports in a multidimensional environment using Transformer Cubes

Environment: IBM CognosBI 10.2/10.1/8.4, Cognos 10-Business Insight, Framework Manager, Report Studio, Query Studio,Cognos Work Space,Cognos SDK,Cognos Connection,Active Reports(Mobility),GO-OFFICE,SQL, Informatica Power center 11.0,IBM Http Servers, Web Sphere 6.1, Oracle 10g, Toad 10.6,JAVA Scripts,Unix.

La-Z-Boy, Monroe, MI Jan 2011 – Jul 2011

Role:Cognos Developer

Description: La-Z-Boy is the world’s leading manufacturer of reclining chairs and one of the nation’s largest producers of upholstered sofas, loveseats, chairs, and ottomans that are marketed through a large proprietary distribution network and through independent retail stores. The project was developed as a Warehouse Management System which was undertaken to manage information about the products, customers, suppliers, purchase orders, receipts, sales orders, work orders, and bills of materials for La-Z-Boy

Responsibilities:

Worked closely with Client Resources and Business Analysts to analyze and understand Business Requirements

Customized data by adding Filters Calculations, Prompts, Summaries, and Functions.

Generated various reports such as: List Reports, Grouped Reports, Cross-Tab Reports, Chart Reports, and Drill-Through Reports.

Added prompts and filters to modify existing reports to accommodate change in User Requirements.

Used Analysis Studio to create Analysis from Power Play Cubes

Created complex multipage reports using multiple list reports and multiple queries to associate each of the list reports

Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, master-detail, charts, various calculations and joins using tabular sets and tabular models

Created Prompts with static choices and conditional variables for rendering the multipage reports

Used Filters for efficient retrieval of data and conditional variables for hiding summary totals for report

Created professional reports in Report Studio and Ad Hoc Reports in Query Studio

Implemented Data Level Security, Object Level Security and Package Level Security

Modified existing Cubes to comply with changes in the Requirements

Performed scheduling and maintenance of reports using Cognos Connection and Microsoft SharePoint based support portals

Involved in Installation of Cognos 8.4 Frame Work Manager, Report Studio, Query Studio, Cognos Connection

Performed Unit Testing for all developed reports

Involved in deployment process of all the reports and packages from Development to production server.

Environment: Cognos BI 8.4, Framework Manager, Connection, Report Studio, Query Studio, Analysis Studio, PowerPlay Transformer, MS Excel, Oracle 10g, Adobe Acrobat, Informatica power center, UNIX

Contact this candidate