SUMMARY

• Over 10 Yearsof total IT industry experience analysis, design, testing, development and implementation of client/server applications
• Expertise in Cognos 10 BI including Framework Manager, Transformer, Business Insightand Business Advance Insight, Report Studio, Query Studio, HTML, Java Scripts, Dashboards.
• Expertise in SAP BO Universe creation and report development.
• Hands on Experience in Informatica 9x
• 8+ years of experience with Cognos Tools such as Cognos 10 and 8 BI Suite(Framework Manager, Cognos connection, Report Studio, analysis Studio, Query Studio, Metric Studio, Event Studio) Cognos Report net 1.1.MR3, Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, Analysis Tools such as Cognos Transformer & Power Play 7.x/6.x
• Extensive experience on Cognos Development in various modules
• Expertise in Framework Manager Modeling (Database Layer, Intermediate Layer, Presentation Layer, Packages) and Complex Report building with Report Studio.
• Has knowledge on using Cognos SDK to automate processes in server.
• Experience in developing multi - dimensional model design and Power play cube building, security using power play Transformer.
• Created complex statistical and financial reports, trend over time reports, ranking, and forecast reports, Executive Dashboards using Report Studio.
• Developed and supported operational and ad-hoc reports using the COGNOS Express tools which include Framework Manager, Query Studio, Reporting Studio and COGNOS Script for automation.
• Utilized knowledge of data and data manipulation techniques to implement functional requirements into reports.
• Interfaces with the corporate and divisional departments to gather requirements, conduct business process mapping discussions and develop Business Intelligence solutions
• Proficient in PL/SQL
• Experience using Dimensional Modeling and creating Cube Based Reports
• Conduct training to end users for the continued utilization and expansion of Cognos Express
• Sound Skills in developing custom prompt pages using HTML and JavaScript.
• Experience in databases like Oracle 10g/9i/8i, MS SQL Server 2005/2000 and DB2.
• Strong knowledge in data warehousing concepts (Star schema, Snow Flake Schema, Fact Analysis).
• Designed, Extracted and Loaded Data into Data Marts Using ETL tool Informatica.
• Competent in all aspect of SAP Business Objects Development, Deployment, and Migration including assessment, implementation and testing.
• Worked TEMPeffectively on Change Management, Problem Management, Configuration Management and Release Management Processes and developed reports to see the performance of those processes under Business perspective.

TECHNICAL SKILLS

Reporting Tools: Cognos 10, 8.1, 8.2, 8.3 & 8.4 BI Suite (Framework Manager, Cognos connection, Query Studio, Report Studio and Analysis Studio, Business Insight and Business insight Advanced), CRN 1.1 MR3, Cognos EP Series 7.x (Power play Transformer, Power play Windows/Web, Impromptu, Upfront) SAP Business Objects -Business Objects Designer (Universe) and Web Intelligence

ETL Tool: Informatica 9x

Operating Systems: Windows 2003 Enterprise Server, XP, 2000 and Sun Solaris 10

Databases: MS SQL Server 2000/2005, Oracle 8i/ 9i, 10g/11g And DB2

Modeling Tool: Erwin

Cognos Supporting Tools: BSP Meta manager and Spot-OnNamespaceMigration

PROFESSIONAL EXPERIENCE

Confidential

Senior Cognos Developer

Environment: Cognos 10, & 8.4 Bi Suite(Frame work Manager, Transformer, Report Studio, Query Studio, Business Advanced Insight), Oracle 10g and Solaris

Responsibilities:

• Created Framework Manager Model for applications(MAPS and EAMS) and Complex Report building with Report Studio
• Interacted with the Users for collecting their requirements for developing metadata models.
• The Meta data was standardized for easy writing of the reports by the users.
• Prepared User Manuals for training the users.
• Trained users on adhoc reporting and report studio.
• Administered tasks such as Scheduling, Deployment, and Dispatchers.
• Involved in Migration of Cognos 8.4 to Cognos 10.1.1
• Created adhoc reports Using Query studio in Cognos 10.1.1
• Created different Standard reports using prompts, filters, query calculations, cascading prompts and conditional Formatting of measures using variables in Report Studio, Analysis studio
• Created dashboard reports using report studio.
• Created balanced scorecards using metric studio.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design.
• Created logical & physical data models and Meta Data to support the requirements.
• Developed complex reports which involved Multiple Prompts in Report Studio.
• Adding business rules by defining different kinds of calculations and filter.
• Creating the Bar charts and list reports using Cognos Report Studio and Analysis studio.
• Created reports using Business Insight and Business Advanced Insight.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos
• Worked in database AS400/DB2 connect using framework manger.
• Providing support for all Business Objects reports for various applications
• Solved all the tickets/issues raised by the user. Created many test cases in TOAD to validate the solution implemented at the Cognos level which involved many complex queries.
• TEMPEffectively handled all the Change requests by clearing all my assumptions with the user directly then and there.
• Discovered some critical flaws in the then existed database model and came up with an TEMPeffective solution.
• Always gets to the core of the issue thereby understanding the ETL involvement of the issue, facilitating faster resolutions.

Confidential

Senior Cognos Developer

Environment: Cognos 8.4 Bi Suite(Frame work Manager, Report Studio, Query Studio), Oracle 10g and Windows

Responsibilities:

• Gathered requirements from end users.
• Involved in the development of the Metadata Model using Framework Manager and created query subjects, filters and packages from the framework manger in Cognos 8.3.
• The Meta data was standardized for easy writing of the reports by the users.
• Used Power Designer for Data modeling.
• Used Third Normal Form in building Data Models.
• Published packages with appropriate security settings to Cognos connection
• Created List Reports, Crosstab Reports, Drill through Reports and Multidimensional Reports with cascading prompts using Cognos 8.3 Report Studio
• Administered the Reporting Environment.
• Developed Scorecards, Dashboards reports Using Cognos8 BI Metric studio/Report Studio.
• Developed complex reports using drill-through options and Master-detail relationships in Report Studio.
• Created different Standard reports using prompts, filters, query calculations, cascading prompts and conditional Formatting of measures using variables in Report Studio
• Scheduled the batch scripts to stop and start the services in Dev environment.
• Utilized the internal Bug tracker to monitor, update, track, resolve and close cases/tickets raised to request support
• Created Repository in Frame work manager to Perform Backup and Recovery of Metadata, Made the changes in Tuning settings for better performance tuning

Confidential

Senior Cognos Developer

Environment: Cognos 8.4 Bi Suite(Frame work Manager, Report Studio, Query Studio), Informatica, Oracle 10g and Windows

Responsibilities:

• Analyzed the existing XML and DTD files which are loaded through Informatica into Oracle.
• Analyzed and altered the XML Files to load into Oracle database.
• Extracted and loaded the XML files into different tables into Oracle through Informatica 5.1.
• FTP job is created to move dis source file from local windows source directory to a specified Unix Location and a batch file is created to make dis FTP process more efficient.
• A new Informatica Job is created to load dis extracted data from temporary staging files in to QDSS staging and UNIX script was created to archive the file. dis archive script file path will be defined in the post session properties of to automate the process
• Altered and defined necessary primary and secondary keys for all tables.
• Analyzed and designed the data model in Visio diagram which needs to be implemented in Framework Manager
• Reduced the no of tables count by merging different tables based on cardinality.
• Designing the logical model that conforms to star schema concepts, different views (import, business, external) as per Business requirement.
• Working with the confirmed dimensions.
• Creating the Determinants for the imported materialized views.
• Import the database objects to the Framework manager model and set the cardinality between them as per the business requirements.
• Created Business layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developing the List Reports, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.

Confidential

Informatica/Cognos Senior Developer

Environment: Cognos 8.4 Bi Suite(Frame work Manager, Report Studio, Query Studio), Oracle 10g and Windows

Responsibilities:

• Designed XML Schema in Informatica DT
• Created Parser and Mapper to Convert text file to XML and Unstructured XML to ACORD XML
• Working to deblcok single XML files into different XML files and Updating high level information to SQL Server Database
• Created Parser and Mapper to Convert text file to XML and Unstructured XML to ACORD XML
• Designing the Error XML schema
• Created mappings using Informatica Power center
• Involved in installation and upgrading of existing Cognos 7.3 Transformer application, automation, and applicable configuration files to Cognos 8.4 Transformer.
• Customized Cognos Connection with appropriate reports and security measures
• Worked on Analysis Studio to develop multi dimensional reporting
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP - ROLAP)
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Involved in Designing models using Framework Manager and deployed packages to the Report Net Servers
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Built Power Play Reports based on the cubes and published to Report Net Server
• Trained the end users to TEMPeffectively use the reporting tool to build and customize their ad-hoc reports
• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various businesses needs (Folders, Filters, and Macros)
• Production Support which involves solving user problems.
• Publishing cubes and created Power play Reports for the web users.

Confidential

Senior Cognos consultant

Environment: Cognos 8.3 Bi Suite(Frame work Manager, Report Studio, Query Studio), SQL Server and Windows

Responsibilities:

• Developed Technical specifications, data identification and also recommendations on the preferred solution for development and deploy efficient BI solutions.
• Developed Report specifications based on Siebel Analytics Reports.
• Installing and configuring the Cognos 8.3 on Windows Environment.
• Creating the DMR (dimensional model) using the Frame Work Manager.
• Analyzed and defined joins to build Framework Manager Models and Packages.
• Added Business rules and Security to the package and Published the package to the Cognos ReportNet server
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Modeled metadata from Oracle data source for use in Report studio and Query Studiousing Framework Manager.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart andcomplex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio
• Involved in access and analyze large data sets for completeness and quality
• Leading the Team in both Technically and functionally
• Established all network connectivity’s between offshore and onshore
• Managing the entire Team activities independently
• Working in all Quality activities independently
• Prepared Test Plan Document for Project.

Confidential

Senior Cognos Consultant

Environment: Cognos Report net(Frame work Manager, Report Studio, Query Studio), Oracle 9i and Windows

Responsibilities:

• Worked closely with Clients and Business users to understand and analyze business requirements and participated in requirements gathering.
• Developed Technical specifications, data identification and also recommendations on the preferred solution for development and deploy efficient BI solutions.
• Creating the Model using the Frame Work Manager.
• Ensuring clear query paths by resolving ambiguous relationships.
• Analyzed and defined joins to build Framework Manager Models and Packages.
• Developed Dash Board reports in Report Studio.
• Administer Security in Reports based on the user role.
• Performance Tuning and load balancing of complex reports.
• Created the SQL scripts as per the business requirements.
• Created the PL/SQL Procedures as per the requirements.
• Creation of OLAP Transformer Cubes from IQD’s /Cognos Connection Package.
• Customizing user class security views in Cube by user classes / Roles.
• Batch script automation for Power Cube refresh.
• Reporting Powerplay cubes in Analysis Studio and Conditional formatting of Cube Reports in Report Studio 8.
• Writing the test cases for SIT (System Integration testing) and UAT (User Acceptance testing).
• Testing the reports in SIT (System Integration testing) and UAT (User Acceptance testing).
• Trained the end users to TEMPeffectively use the reporting tool to build and customize their ad-hoc reports

Confidential

Cognos Consultant

Responsibilities:

• Supported all the queries of the clients in the project
• Daily On call support for data loads and Cube builds.
• Identify and resolve data issues
• Created Multi-Dimensional reports using Power Play.
• Created Business Mix reports and Top ten reports.
• Designed and developed multi dimensional cubes, Visualizations.
• Cognos Impromptu Reports.
• Queried data from different database tables as per the requirement.
• Joined the different table as per the requirements.
• Created reports in HTML format for easy navigating of data from web browser.
• Customized data by adding calculations, summaries and functions.
• Generated List Reports, Cross Tab Reports and Drill Through reports.
• Developed reports using Cognos Impromptu tools querying database.
• Created Filters, Conditions and Prompts in Catalog.
• Developed Impromptu Web Reports (IWR) and published them into Upfront.
• Presenting complex data summary report.
• Exception highlighting.
• Reconcile data between Source and targets.
• Support users on interpreting data, features and tool.
• New user setup and password resets.
• Provide support and halp to site services on client setup and issues.
• Minor enhancements and alteration of reports.

Confidential

Cognos Consultant

Environment: Cognos 7 EP Series(Powerplay, Impromptu, Transformer, Upfront

Responsibilities:

• Daily On call support for data loads and Cube builds.
• Data retrieval, Multidimensional analysis, Power Play structure.
• Designed and developed multi dimensional cubes, Visualizations.
• Created Cognos Impromptu Reports.
• Queried data from different database tables as per the requirement.
• Joined the different table as per the requirements.
• Customized data by adding calculations, summaries and functions.
• Created List Reports, Cross Tab Reports and Drill Through reports.
• Generated reports using Cognos Impromptu tools querying database.
• Created Filters, Conditions and Prompts in Catalog.
• Developed Impromptu Web Reports (IWR) and published them into Upfront.
• Presenting complex data summary report.
• Created summary and detailed filters
• Support users on interpreting data, features and tool.