SR.COGNOS DEVELOPER

EXPERIENCE SUMMARY:

Over all * years * months of experience in Programming, Analyzing, Designing, Testing, integration and deployment of enterprise architecture based components and business applications.

Have 7 years 8 months of experience in Design, Development, Maintenance and Production Support of Business Intelligence Applications.

Strong Experience in Financial, Insurance and Health Care Domains.

Strong work experience of Agile and Waterfall methodologies.

Extensively worked with Business Team and Functional Team to review business requirements, and Functional clarifications.

Worked on multiple projects and delivered in time.

Conducted multiple sessions with management, end users for open and pending issues and for customizing reports, fixing the errors in the data as a part of production support.

Excellent experience in working with Business team by reviewing the requirements and developing Poof of Concepts using different set of BI tools and explain business team the usability, ability and functionality of the these BI tools.

Good Experience on BI Tools (Framework Manager, Transformer Cubes, Report Studio, Query Studio, Analysis Studio, Dashboard)

Good Knowledge on other BI Tools(QlikView, Tableau, SSIS, SSAS, SSRS)

Good Experience in Created DMR and Relational Model in Framework Manager.

Good Experience in creating plans and models to fit the business needs using Cognos Planning.

Well-versed in developing multi-dimensional cubes and analyzing Power play Transformer.

Experience with Data Warehouse Concepts, Methodologies, ODS, Data Warehouse, Datamarts, Star and Snow Flake Schemas.

Database Programming experience using Oracle 10g/9.x/8.x/7.x/, MS SQL Server, DB2, PL/SQL, SQL, SQL Loader, TOAD, PL/SQL Developer and Benthic Golden.

Expertise in preparing Test Plans, Cases & Scripts based on system specifications and A&D documents.

Expertise in Regression, System, Integration, Functional and Performance Testing.

Participated in various meetings between Offshore and Functional Team to review business requirements, and Functional clarifications.

Provided key project inputs by working with users and developers in defining several functional and technical issues of project and system requirements.

Work independently with business analysts to gather the requirements.

Excellent communication and administration skills, highly motivated and with an aptitude for success and able to work in a team environment with minimum supervising.

Certifications:

Oracle Database 10g Administrator Certified Associate.

Cognos 8 BI Technical Specialist

TECHNICAL SKILLS

Technology

Tools

BI Tools

Cognos BI 10.x, 8.x (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio PowerPlay Transformer,/Data Manager), QlikView, Tableau, SSIS, SSAS, SSRS

OLAP Tools

Cognos Transformer

ETL Tools

Informatica Power center 9.1, 7.1.

Languages

SQL, PL/SQL, Java Script.

Web Technologies:

Microsoft.NET Framework,, HTML, DHTML, XML, CSS, Java Script, VBScript.

Databases

Oracle 11g/10g/9i/8.x/7.x/, DB2, Sybase, MS SQL Server and MS Access.

Other Tools

Microsoft Project, Microsoft Visio. Peregrine,

HP Service Manager. MS VISIO 2010

Operating Systems

MS DOS, WinNT/2000/7, and UNIX

PROFESSIONAL EXPERIENCE:

State Farm Insurance, Bloomington. IL Mar 13 – Till Date

Sr.Cognos Developer.

Responsibilities:

Worked and involved on multiple projects and delivered in time.

Designed wireframes and developed component specs for details design document.

Provided key project inputs by working with Business/Functional Team and developers in defining several functional and technical issues of project and system requirements.

Worked with Business team in developing POCs based on business requirements

Prepared Technical Documents by reviewing BRDs.

Worked in Framework Manager to create Models using different data sources, and publishing packages to Cognos connections as per reporting requirements.

Created DMR and Relational Model in Framework Manager.

Modeled STAR schema in Framework Manager for better performance.

Applied AD Securities on Object level, Folder level, Package level and Report level.

Developed Dynamic Cubes and DR Models using Transformer OLAP Cubes considering source as Framework Manager package and Relational Reports.

Created Parameter mappings for Row level Securities using Macros.

Applied Bridge Tables and Determinants on Queries to get accurate data

Designed and implemented Cognos Cubes using Microsoft OLAP services, Cognos Transformer, and Power Play to facilitate executive, management and end user Ad hock reporting.

Created multidimensional cubes using Framework manager Packages as data sources in Transformer

Created highly Complex Reports using OLAP CUBES as Data Source for Multi-Dimensional Analysis.

Developed many Complex Reports as List, Cross tab, Drill up, Drill down, Drill through, Master-Detail, Chart using Report Studio.

Developed Gage charts, bar chats and micro chats to display value ranges

Developed complex prompt pages for multiple user groups.

Worked on HTML code using JavaScript coding for Prompt validations and Image controls.

Created Dash board portal Reports and published to Cognos Portal.

Developed Technical Specification documents for all newly developed and modified processes.

Coordination for Integration testing, UAT, UTC and smoke tests and resolving the support issues.

Write SQL script to extract problem data and implement corrections

Verified and reviewed the code, test results and test plans and provided inputs to the team.

Fixed many Production issues, and Bugs using CMRs (Change Management Request) and coordinated with Admin team in migrations.

Worked 24/7 as on call support.

Environment:

Cognos 10.2/10.1 /8.4/7.4, Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, Cognos Power Play Transformer, LDAP, Cristal Reports, Informatica,UltiPro HCM, DB2,Oracle, Windows 7/2003 server, VISIO 2010 and UNIX.

Genentech. SFO, CA July 08 – Feb 13

Cognos Developer

Responsibilities:

Prepared Technical Documents by reviewing BRDs.

Responsible for creating and maintaining all testing documentation including test cases, test scripts, and test task lists

Trained and provided KT to users on modified and existing system flow and to log the issues to correct support groups.

Responsible for the daily, weekly, monthly, Quarterly and Year End Reports for business needs.

Created customized, Complex reports in Cognos Report Studio and Ad-hoc reports in Query Studio.

Worked in Framework Manager to create Models using different data sources, and publishing packages to Cognos connections as per reporting requirements.

Created DMR and Relational Model in Framework Manager.

Created plans and models to fit as per business needs using Cognos Planning.

Designed and implemented Data Cubes using Microsoft OLAP services, Cognos Impromptu, and Power Play to facilitate executive, management and end user reporting.

Created multidimensional cubes using Impromptu’s Query Definition in PowerPlay Transformer

Developed Power Play cubes which involved model definition in Transformer, used multiple queries, Calculated Measures, Customized cube and Optimized Cube creation time.

Created Dashboards in Report Studio involving a mixture of data coming from both the database and Power play cubes.

Developed many Complex Reports as List, cross tab, drill through, master-detail, chart using Report Studio.

Designed reports with Cascading Prompts, Filters, and Calculations.

Created complex package reports using conditional blocking / conditional formatting / conditional layouts as per business requirements.

Implemented Security filters at Package level, Object level, Data level.

Developed Master detail reports, Multi query and Multi page master reports as per BRD.

Analyzed and validated the report and performing data analysis by writing complex SQLs

Monitored data quality, resolving problem data issues, and ensuring timely updates

Involved in deployments of Packages and Reports to different environments.

Developed Batch process for Report automation process in Unix.

Coordination for Integration testing, UAT, UTC and smoke tests and resolving the support issues.

Working with different client teams to support Reporting issues and enhancing the existing reports.

Fixed many Production issues, and Bugs using RMT's (Request Management Tool) and coordinated with Admin team in migrations.

Worked 24/7 as on call support.

Environment: Cognos 8.4/8.3, Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, Cognos Planning, Cognos Power Play Transformer, LDAP, XML, Informatica, MS SQL Server 2005, Oracle, DB2, JAVA/J2EE, Windows 2003 server and Unix.

Karnataka State Financial Corporation, Bangalore, India Oct 07 – June 08

Programmer Analyst

Responsibilities:

Involved in Business Analysis, Design and Development

Performed Normalization and Logical Database Design

Created Stored Procedures, Functions, and Packages to manipulate the database and to apply the business logic according to the user specifications.

Involved in hard coding of SQL & PL/SQL scripts.

I did Performance tuning for rapid execution of SQL & PL/SQL Scripts.

Developed GUI interface in Java using Applets, HTML, JDBC and JavaScript.

Created Stored Procedures, Functions, Packages, Triggers, Tables, Views and Synonyms

Accessed data from the database using RDO Controls and Remote Data objects

Created the VB Forms for Data Capturing using Active X Data Objects.

Created Active X DLL's using Class Builder Utility and generated different Crystal Reports.

Generated lot of Crystal Reports.

Environment: Oracle 7.3/8.0, PL/SQL 8.0, SQL Server, Sybase, Visual Basic 5.0/ 6.0, JAVA, JSP, Crystal Reports and Windows NT.

Contact this candidate