SUMMARY:

• 7+ years of IT experience in Business Intelligence systems such as Analysis, Design, Development, Deployment, Testing, and Dimension Modeling. Extensively worked on various versions of COGNOS and involved in implementation of complete life cycle of BI systems.
• On IBM Cognos Tools - IBM Cognos 10.2,10.1,8.2/8.3/8.4 Suite (Report Studio, Analysis Studio, Query Studio, Event studio and IBM Cognos Connection), IBM Cognos Report net 1.1 MR3, IBM Cognos EP Series 7.3(Impromptu, IWR, Power Play Transformer and Power Play Windows/Web, upfront).
• Create Framework Manager Package, based on IBM Cognos Planning package.
• Proficient in meta data modeling with Framework Manager and experienced in layered approach such as Physical Layer and Business Layer, Presentation Layer...etc.
• Experience in DMR modeling with Framework Manager.
• Outstanding experience in creating report layout as List, Cross Tab, Chart, Active Report.
• Created complex reports with advanced features such Master detailed sections, Conditional formatting, Render variables, Drill-through, Page Set and Bursting using Report Studio.
• Experience in Reports Deployment and Reports scheduling.
• Hands-on experience in Design and Develop the Transformer model and Power play cube.
• Extensive experience in Migrating reports from Cognos EP Series 8/CRN to Cognos10.
• Used Analysis studio for multi dimensional analysis and created context filters for better performance.
• Create complex reports using Report Studio Create Events & Schedule to run reports, Set Security.
• Implemented security at various levels such as Package, Object and Data level using FM.
• Generate complex Dashboards, which include Reports/Graphs/Maps set drilldown/up.
• Worked with the database and ETL developers to find the data appropriate to develop Framework manager models and publish packages.
• Developed dashboards and reports by gathering requirements, used event studio to send out alert mails, Analysis studio for trends & comparisons.
• Hands-on experience in creating Catalogs and reports using Impromptu Administrator.
• Involved in creating Technical Design documents.
• Experience in Production/Customer Support, Deployment, Development and Integration.
• Proficient in using best practices to support the reporting activities.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules.
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills

TECHNICAL SKILLS:

BI Tools: Cognos Business Intelligence 10.2, 10.1.1, 8.4.1, 8.3, 8.1 (Report Studio, Query Studio, Analysis Studio, Metrics Studio, Event Studio, Framework Manager),,ReportNet & Impromptu.

ETL Tools: Informatica PowerCenter

Databases: Oracle, SQL Server, DB2, MS Access

Modeling: Erwin, SQL*PLUS

Languages: C, C++, SQL, PL/SQL, Java

Operating Systems: Windows 95/98/2000/XP/NT, UNIX

Web Server: Java Web Server, Apache Web Server, VBScript, HTML, DHTML

PROFESSIONAL EXPERIENCE:

Confidential,Columbus,Ohio

Sr. IBM Cognos Developer

Responsibilities:

• Implemented data level, object level and package level security in Framework Manager.
• Review and understand the Application Team’s work plan.
• Created list, crosstab and drill through reports for departments like claims, billing, and members/subscribers in Report Studio.
• Provide status of work to team lead.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Develop contingency plans and necessary.
• Created Drill Through Reports & Master Detail Reports for Accounts Department.
• Engage in ongoing process improvement.
• Created dashboards, port lets for various HR and payroll related reports. E.g. showing dashboards of their investments, returns, losses, dividends earned, etc.
• Detailed functional and process knowledge.
• Developed the Framework Manager model by pulling the data from multiple data sources like Oracle, SQL Server and published packages to the Cognos Connection.
• Resolved different ambiguous relationships between query subjects while creating Framework manager model.
• Created Database Layer and Business Layer, defining appropriate relationship between query subjects in Framework Manager.
• Created Dimensions, Levels, Calculated Measures, Special Categories with relative time period and Cube groups
• Developed various HR reports - MTD, QTD, YTD, last fiscal year, current fiscal year reports, employee taxable, paid time offs, holidays, sick leaves, workers compensation report (WCR) etc..
• Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs, etc.
• Customized map container in Report Studio.
• Applied various kinds of prompts such as Value prompt, Date prompt, Textbox Prompt, Select & Search Prompt for report's better performance
• Created report links and parameters outside IBM Cognos and connected to IBM Cognos using IBM Cognos.
• Wrote and executed the test cases for various reports that were developed in IBM Cognos.
• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports.
• Created models in Transformer, built cubes and published cubes to Analysis Studio.
• Used Analysis Studio for multidimensional analysis and slice & dice the cube data.
• Interacted with ETL team to gather the requirements for the reporting.
• Exceptionally good and experienced in handling the problem and troubleshooting.
• Trained End users to operate the reports.
• Scheduled the reports according to user requirements in Cognos Connection and sent the reports through E-mail feature

Environment: IBM COGNOS 10.1/ 8.4/8.4.1/8.3 (Report Studio, Query Studio, Analysis Studio), IBM Cognos 8 .4 Go-Office, Microsoft SQL Server 2005 database, Informatica 8,IBM Cognos, LDAP, Access Manager, IIS, XSLT, HTML, Windows XP/2003.

Confidential,San Francisco

Cognos Developer

Responsibilities:

• Developed Technical Design Specifications for reports and also recommended preferred solution for report development.
• Developed logical & physical modeling as per business requirements using ERWIN.
• Designed and developed snow flake /star schemas for better understanding of models using ERWIN.
• Designed DMR models in Framework Manager.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Applied best practices on the Framework Manger models to refine and fine tune the models and provide best practices for day to day operations, performance analysis, tuning and capacity planning.
• Understand the customer business requirements and analyze these for design and implementation
• Customized map container in Report Studio.
• Created Regular dimensions, Fact dimensions Levels and Hierarchies.
• Created score cards with multiple formats using metric studio.
• Created reports with detailed and summary filters, provided various kinds of prompts such as Value, Date, Textbox…etc.
• Created portal pages/Dashboards by including business critical reports to monitor the business in a single glance.
• Wrote and executed the test cases for various reports that were developed in Cognos.
• Extensively used Query Studio for developing Ad hoc reports.
• Created models in Transformer, built cubes and published cubes to Analysis Studio
• Interacted with ETL team to gather the requirements for the reporting.
• Involved in Report testing and UAT.
• Trained End users to operate the reports.

Environment: COGNOS 8.4/8.4.1/8.3 (Report Studio, Query Studio, Analysis Studio), Cognos 8 .4 Go-Office, Microsoft SQL Server 2005 database, Informatica 8, Cognos, LDAP, Access Manager, IIS, XSLT, HTML, Windows XP/2003.

Confidential,Santa Ana,CA

IBM Cognos Developer

Responsibilities:

• Loaded data into the BIS system from multiple data sources including Oracle and SQL Servers.
• Build and scheduled the DTS jobs in order to bring in the data on a daily basis into BIS.
• Created tables, index and views in order to do reporting off the BIS data sources.
• Produced and enhanced stored procedures and ad hoc queries in SQL.
• Bursting the reports in various formats, such as html, PDF and excel.
• Deployed reports from development environment to production environment
• Optimized and modified the triggers, complex store functions, procedures, user base data type
• Extensively used loops, conditions, functions and store procedures in producing monthly process data.
• Created a data models in Framework Manager with data level security.
• Worked with the finance and Treasury departments in order to provide them with the Journal Entry and Other Financial reports
• Created reports that contain monthly and cumulative amortization for loan discounts and originations fees.
• Created reports for analysis and auditing purpose, including reports at the student detail level.
• Help the business get the reports by providing different delivery methods including Bursting to public mail Box / Common Shared Drive.
• Perform add hock data extracts and reporting on the fly when requested by business users.
• Worked with the INSIGHT data warehouse in building and bring in Data from different Student Systems.

Environment: IBM Cognos 8.3/8.2,8.1 Framework manager, UNIX, Windows NT, PL/SQL, Informatica Power center, Oracle 9i (SQL Plus).

Confidential,Cheshire,CT

Report Developer

Responsibilities:

• Worked on creating list reports, cross-tab reports and chart reports using multiple queries in a single report by using filters, calculations, etc.
• Created Dashboards, which lead to detailed reports with different parameters in Report studio.
• Created a company dashboard with six divisions, which updated every hour to show Profit, Margin, Inventory, sell by cost, Profit by dept., Margin by dept.
• Involved in the entire project life cycle from Analyze, Design and Development of reports
• Created scorecards for different departments, like grocery, produce, stationary, perishables using. Also created bookmarked reports for faster access to pre run detail reports. Monitoring of margin, sales, out of stock are a few to name.
• Installation and troubleshooting of Framework Manager Client tools.
• Setting up security for roles and groups in IBM Cognos connection.
• Worked on Framework manager to import METADATA from data sources (DB2 (AS/400) & SQL Server) to create Models for reports and published packages to IBM Cognos server.
• Worked on Event Studio to publish news items, and sending out event mails on a daily basis.
• Involved in design and development of Joins, filters, calculations, prompts and conditional variables in Packages in Framework Manager.
• Maintained packages and updated them by adding tables, as and when required by other report writers. Prepared and maintained (project/package) Framework Manager and Reports detail design documents.
• Mentored novice IBM Cognos Developers in Report Studio, Query Studio and framework Manager modeling.
• Performance testing the reports to ensure that no long running reports are exported to Production environment.
• Dispatched weekly departmental reports using report bursting to concerned department managers about weekly performing sections of the warehouse.
• Converted legacy Excel reports to IBM Cognos Report Studio and Query studio reports for the retail section of the company.
• Developed reports on fleet logistics and delay profiles for each section of the warehouse.

Environment: IBM Cognos 8.2/8.1, Impromptu, Cognos Server Administration, Cognos Upfront, Impromptu Web Reports (IWR) Framework Manager, Query Studio, Report Studio, Enterprise Planning, Informatica 6.2, Adobe Flex 2.0, SQL 2000, Event Studio.