SUMMARY

• Cognos Professional with 7+ years of experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, and Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems in the Healthcare, Banking, Insurance, and Pharmaceutical industries.
• Having 7 years experience on Cognos Tools - Cognos 10.1,Cognos 8.2/8.3/8.4 Suite (Framework Manager, Report Studio, Analysis Studio, Query Studio, Metric Studio and Cognos Connection), Cognos Reportnet 1.1 Mr3, Cognos EP Series 7.3 (Impromptu, IWR, Power Play Transformer and Power Play Windows/Web, upfront).
• Experience in handling completes range of BI capabilities: reporting, analysis, score carding, dashboards and business event management.
• Developed Active reports, Bullet Charts, Micro Charts and Heat maps with Cognos 10.1.1.
• Developed Dashboards using Cognos 10 Business Insight.
• Upgraded Cognos Reports & Packages from 8.4 to Cognos 10.1.
• Extensively worked on Active Reports Objects (Deck, Data Tab controls, Data Controls, Connections and Variables).
• Designed & developed Cognos Go Mobile 8.4 and 10. Configured Go Mobile with IPad Reporting.
• Strong complex reporting skills-Complex Drill-Through, Cascading Prompts, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
• Strong knowledge with Power Play Transformer model design and Power Play cube building.
• Experience in designing and developing Score cards using Metric studio.
• Expertise in version up gradations of Cognos suite such as Cognos 7.3 and Migrating Report Net reports and Impromptu intoCognos8 BI.
• Publication of reporting via Office using Cognos office Connection (IBM Cognos 8 Go Office) and ad-hoc querying via Cognos BI Analysis for Excel, Word, Power point.
• Integrated Third Party Portals using Cognos JAVA SDK.
• Good experience in Production Support and Troubleshoot/Test issues with existing reports and cubes.
• Good knowledge in Data Warehousing tools including Informatica, Data modeling Tools like Erwin using Oracle, DB2, MSSQL Server databases.
• Developed DMR Models & IQD’s in Framework Manager.
• Experience in OLTP/OLAP System Study, Analysis and ER Modeling, Maintaining Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.
• Extensive work on Data Extraction with Oracle 11g, SQL Server & MS-Access.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and Involved in providing knowledge transfer with respectiveCognos to the associates.
• Strong experience of using SQL for various data sources (like Oracle, SQL server) in development of reports, analyzing data in tables, cardinality between tables and joining tables.
• Involved in creating and working with PL/SQL Stored Procedures, Functions, Cursors and Triggers.
• Worked with the business users and provide expertise in problem definition, requirements analysis and the general design of the BI System.Provided support to multiple concurrent projects.
• Excellent written and verbal communication skills and expertise in working with clients and functional teams.
• Participated in design discussion and review session with client solution architect team.

TECHNICAL SKILLS

Reporting Tools: Cognos 10.1, Cognos 8.4 BI Suite (Framework Manager, Cognos connection, Query Studio, Report Studio and Analysis Studio), CRN 1.1 MR3, Cognos EP Series 7.x (Power play Transformer, Power play Windows/Web, Impromptu, Upfront), SSRS.

ETL tools: Informatica, Data stage.

Operating Systems: Windows 2003 Enterprise Server, 2000, Windows XP Professional, UNIX.

Web Servers: IIS, Tomcat and Apache

LDAP Servers: Active Directory, Sun One Directory, Apache Directory.

Databases: Oracle 10g/11gR2, MS SQL Server 2008/2005 and Teradata.

Programming skills: C, C++, HTML, JavaScript, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Boston MA

Sr. Cognos Developer

Responsibilities:

• Developed Cognos 10.1.1 Reports using Active Reports in Report Studio.
• Developed Business Requirement Documents based on Client’s Requirements.
• Developed Framework Manager Models, Implemented Layer’s Architecture, Security, and Best Practices in FM.
• Created Database Layer, Intermediate layer and Presentation Layer defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Created Packages with various security settings and published them ontoCognosConnection.
• Upgraded Cognos Reports & Packages from 8.4 to Cognos 10.1
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Developed Active Reports and Heat Maps using Cognos 10.1.1.
• Created reports with custom prompt pages (using HTML and JavaScript) in Report Studio.
• Developed Quarter End Financial Reports to define total Assets, Liabilities, Balance sheet and P&L.
• CreatedPower Play cubes in Transformer 8.4 based on business requirements.
• Move the Cognos Framework Manager model from development, test environment to production environment.
• Testing the developed reports for final deployment.
• The work related to finalizing and testing/debugging IQDs, appropriate documentation and functional training in designing, building, and maintaining cubes in Cognos 8 BI v8.4.
• Created simple and ad-hoc reports using Query studio.
• Scheduled the reports in Cognos connection and distributed them via mail.
• Worked on enhancements to existing Cognos reports in Report Studio & models in Framework Manger
• Create SQL queries using Oracle SQL Developer to verify accuracy of Cognos reports.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Involved in performance tuning of the reports in Report Studio.
• Involved in implementing security in FM and Cognos Connection Portal.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.

Environment: Cognos 10.1, Cognos 8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Office Connection),Java script, XML, HTML, Transformer 8.4, Oracle 10g, SQL server 2005, Informatica, MS Project, MS Visio.

Confidential, Stamford CT

Sr. Cognos Developer

Responsibilities:

• Gathered & analyzed the end-user business requirements.
• Provide best practices for day to day operations, performance analysis, tuning and capacity planning.
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
• Implemented Framework manager security for row level access and Package access based on the Department and region Level.
• Creating star schema grouping for better understanding of the model.
• Develop framework model to perform most of the calculations and give power to user to create Ad-hoc reports with ease.
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Ensuring clear query paths by resolving ambiguous relationships (loops, reflexive and recursive).
• Setting up cardinality (minimum, maximum & optional), Determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Created ad-hoc packages for the query users with pre defined filter conditions prompt customization.
• Created Filters, Prompts, Calculations both at package level and report level.
• Designed various kinds of Reports in Report studio (Conditional Formatting, Conditional Blocks, Sections, page Breaks, Master-detail, and Drill through).
• Implemented dynamic measures, dynamic column selection in Report Studio.
• Used Cognos Transformer to build multidimensional cubes.
• Developing Analysis Studio views of analysis from dimensional modeled packages.
• Scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports.
• Designed & developed Reports using Cognos Go Mobile 10.
• Designed Data marts for creation of reporting database using Data Manager
• Created multiple star schemas using Cognos Data Manager.
• Involved in migrating reports from Development to Testing and from Testing to Production Environments.
• Worked on conducting User Interviews and documented their query, business analysis and reporting needs, Understood data and business logic with reporting viewpoint.
• Developed technical specifications and deployed efficient Business Intelligence solutions.
• Provide training, support and guide for best practices for Adhoc Query Users and Report Authors.
• Interaction with the business users at various stages of the project through demos.

Environment: Cognos 8.4& 8.2 Report Studio, Framework Manager, Query studio, Analysis studio, Cognos Connection, Cognos Transformer 8.3/8.4, Data Manager, Oracle 10g, DB2, SQL Server 2005, MS Office Tools, MS access, Java Script, Unix.

Confidential, NJ

Cognos Developer

Responsibilities:

• Developed models in Cognos 8.2 Data modeling tool Framework manager and 8.2 Transformer.
• Modeled metadata from SQL Server data source for use in Report studio and Query Studio using Framework Manager.
• Customized Cognos Connection with appropriate reports and security measures.
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• 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 migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
• Created Dash board reports to get all the information from other reports.
• Involved in access and analyze large data sets for completeness and quality.
• Built Power Play Reports based on the cubes.
• Prepare deployment specifications and work with system administrators to move reports into QA and Production.
• Analyzed the Explain Plan to check how the queries are performing scans.

Environment: Cognos 8.2/ 8.3 BI Suite (Report Studio, Query Studio, Cognos Connection, Framework Manager, Event Studio, Metric Studio, Analysis Studio, Metrics Manager), Transformer 7.4, Content Manager, Oracle 10g, SQL Server 2005, SQL, PL/SQL, JavaScript, HTML, MS- Excel, Data manager.

Confidential, Raleigh NC

Cognos Developer

Responsibilities:

• Developed Data models in Framework Manager.
• Implemented different types of securities in Framework Manager.
• Developed parameter map in Framework Manager for dynamic date selection in Cognos report level.
• Developed advanced reports using Report Studio and ad hoc reports using Query Studio.
• Created various reports like List, Cross tab, Drill Through, Summary Details, link, Charts etc.
• Scheduled various reports using the Schedule Management feature within Cognos Connection.
• Data validation of reports using query studio, framework manager and report studio.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Designed models & OLAP cubes in Cognos 7.2 Transformer using existing IQD’s from Framework Manager.
• Created Multi-Dimensional reports using Power Play.
• Worked on drill down, slice and dice and change displays.
• Performance tuning of Cognos Reports and FM model.
• Implemented numerous Cognos report view to display as single report using java script.
• Used DDL, DML scripts for modifying database objects required for reporting.
• Documented the process of for deployment from development to production.

Environment: Cognos 8.0/8.1 BI Suite (Framework Manager, Cognos Connection, Report Studio, Query Studio, Event Studio), Oracle 9i, Impromptu 7.4, HTML.

Confidential

SQL Developer

Responsibilities:

• Installation and configuration of SQL Server 2000/7.0 on Window 2000/NT OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Written complex stored procedures and functions according to business requirements.
• Implementing Backups and restoring when necessary.
• Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Extensively Developed SQL scripts for maintaining administration tasks.

Environment: SQL Server7.0/2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Crystal Reports, T -SQL.