SUMMARY

• Certified Cognos professional with 8+ years of experience with Business Intelligence (BI) and Data warehousing tools, with experience in complete project life cycle from initiation to deployment
• Over 8+ years of experience in requirement analysis, design, development, writing test plan/test cases, testing, capturing test results in three tier business applications and web - based applications.
• Over 7+ years of experience in development and implementation of Data Warehousing applications using Cognos Business Intelligence- Cognos 10.1.1 & 10.2.1, Cognos 8.x, ReportNet, Impromptu, Impromptu Web Reports (IWR), Cognos Power Play Enterprise Server, Cognos Transformer, Cognos Upfront, Access Manager, Mash Up, Informatica power Center 8.x/7.x/6.x and SQL Server.
• Well-versed in developing reporting applications using Cognos Business Intelligence (BI) components like Framework Manager, Query Studio, Report Studio, Analysis Studio, Metrics Studio and Cognos Connection.
• Strong experience in Installation, Configuration, Monitoring and Management of Cognos on both UNIX and Windows platforms. Expertise in defining the multi-tiered Cognos Architecture, Performance tuning, Security infrastructure and Deployment work flows from Prod, Dev and Test environments.
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle and SQL Server.
• Excellent understanding and hands-on experience of Extraction, Transformation and Loading (ETL) of data into Data warehouse/Data Marts/ Online Data Stores using tools like Informatica, Data Manager and Data stage.
• Good working and practical knowledge in all aspects of SDLC such as requirement analysis, design, development, testing, implementation & maintenance of Projects.
• Strong understanding of Dimensional Modeling concepts and have Experience in dimensional modeling using Star Schema and Snow-Flake Schema.
• Proficient in using best practices to support the reporting activities. Adept in using performance tuning and optimization techniques such as load balancing, table weighing and partitioning.
• Knowledge on Cognos Software Development Kit (SDK).
• Expertise in Migrating Catalogs and reports from cognos series 7 - Impromptu 7.3 to Cognos Reportnet1.1MR2 and Cognos 8 and upgrades from Cognos 8.4 to Cognos 10.1.
• Experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7 and Tableau 8.
• Experienced with multiple relational databases including MS SQL Server, Oracle 10g/9i/8i, UDB and DB2.
• Good knowledge and experience with financial, HR and Actuarial IT Audit data.
• Knowledge on IBM Optim for Data Archive (Performance Archive, Retirement Archive) and Data Purge
• Provided production support by checking the integrity of the reports in the production environment.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS

Business Intelligence Tools: Cognos 10.1/10.2.1, Cognos workspace, Cognos 8,8.2/8.4, Cognos ReportNet, Cognos Series 7 - Active reports, Business Insight Advanced, Report Studio, Query Studio, Analysis Studio, Metrics Studio, Framework Manager, Event Studio, Map Manager, Cognos Impromptu 7.x/6.x, Impromptu Web Reports (IWR), PowerPlay Transformer 7.x/6.0, PowerPlay Enterprise Server, Actuate Reporting 7.x/8.0, Tableau 7/8

ETL Tools: Decision Stream, Data Manager, Informatica PS 8.x/7.x/6.x,DTS,SSISRDBMS Oracle 10g/9i/8.x, SQL Server7/2000/2005, DB2 and MS Access.

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

Design Tools: Erwin, VSD (Visio soft diagram)

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

Web Servers: IIS 4.x/5.x

Web Technologies: Java Script, XML, HTML 4.0, ASP, VBScript

ERP: JD Edwards, Oracle Financials, SAP R/3, SIEBEL

PROFESSIONAL EXPERIENCE

Confidential, Secaucus, NJ

Tech Lead/Sr. Cognos Analyst /BI

Responsibilities:

• Assisting the client, through analysis of their existing system, challenges, and business needs. Documented the reporting requirements and interacted with Business users and collected business information and their requirements for developing the project.
• Analyzed the data needs and accuracy of the data for the report purposes.
• Acted as a bridge between the business users and technical users, translating the technical terms to business users and vice versa.
• Developed and maintained the technical design specifications of Meta Data Layer presentation and Report specifications documents with best practices
• Scaled the production environment from a single server to a multi-tiered architecture that included 4 application servers and 1 web gateway server to allow more concurrent users
• Install Multi-server Dispatcher Cognos installations for Dev/QA/Pseudo Prod/Prod Environments. Crete/Maintain Cognos User classes and groups with Windows Role Based Structure and user account provisioning. Created the Data source connections, maintained the migration of the content from DEV to TEST to PROD
• Install/setup Cognos 10.1 software. Upgraded the Models, Reports and cognos 8.4 content from Cognos 8.4 to Cognos 10.1 Troubleshoot upgrade problems/fix issues
• Designed SDK solutions such as Code to migrate My folder reports from one environment to another, Change data sources of queries in multiple reports
• Built Framework Manager Models (Relational, DMR) for Standard Reporting and Adhoc Analysis.
• Published IQD’s which are used as Datasources in Cognos Transformer to build a cube, by prepraring the Meta data in Frame work manager and externalizing the query subjects.
• Implemented Cognos independent row level security based on the Geography and Business units, from the database security tables.
• Implemented the Data level, row level and object level security and also administred the permissions given to the packages, Cubes, folders and reports.
• Enhanced the Framework Models and Transformer Model to suit the user requirements.
• Validated the Data Loads in the Cube using Analysis Studio
• Developed numerous multi tab, multi page, Mulit-Query, dashboard reports and regular reports based on the existing remedy database incident management system, with drill through functionality to the detail reports.
• Developed the dashboard reports and active reports with aggregate data metrics utilizing the 2D and 3D graphical UI.
• Added the Dashboard reports to the portal page and specified the order of the tabs that appear in the dashboard report portal. Converted the dashboards to Active reports in Cognos 10.2.
• Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail.
• Designed and Developed Advanced Prompt Pages using various varieties of Prompts and Java scipts for the custom functionality.
• Created and managed agents, events and tasks using Event studio, which monitors the CMB data and performs the task when an event occur.
• Generated SQL/MDX and analyzed Native SQL to trouble shoot the report issues and performance issues.
• Performed Unit testing on Dev and supported the users on UAT and Production
• Developed and Maintained technical documentation of the implementation.
• Assisted the users on Production for the latest enhancements and production fixes.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups.
• Data blending implemented on databases and generated interactive dashboards in Tableau.
• Published Workbooks by creating user filters so that only appropriate teams can view it using Tableau.

Environment: Cognos 10.1 & 10.2.1 (Framework Manger, Report Studio, Active Reports, Event Studio, Dashboard reports, Business Insight, Business Insight Advanced),Cognos SDK, Oracle 10g, Sybase IQ, Abinitio, Tableau.

Confidential, New York, NY

Sr. Cognos developer /BI

Responsibilities:

• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document.
• Involved in the installation of various Cognos tools in distributed environment (Development, Test and Production).
• Customized Cognos Connection portal with appropriate requests and security measures.
• Configured the Cognos server, Scheduled and monitored the reports and jobs schedules, Created Data source connections, administered the report, package, cube and folder permissions, created the user groups and roles based on the security requirements, migrated/deployed the cognos content from Development to test to Production environment.
• Involved in Design and Development of Security Architecture to meet the Business needs.
• Implemented Single sign on Security with LDAP and Group level security in Cognos Connection Portal.
• Built Relational Models for Reporting and DMR for OLAP Style Analysis and Reporting using multi layer Approach and Modeling best Practices to meet the reporting requirements.
• Develop/Implement/Deploy new projects using SQL Server 2008 R2, Stored

  Procedures, SSIS, Cognos

• Ensured Ambiguous Relationships are resolved and implemented Model enhancement techniques to improve Model Performance.
• Created Model Query Subjects, Data Source Query Subjects, Stand alone and Embedded Filters to implement the Complex business Logic.
• Implemented internal Cognos Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.
• Developed Hierarchies and Measures to support Adhoc Reporting, Multi Dimensional Reporting.
• Published Packages to Cognos Connection and implemented Package Level Security.
• Managing User ID’s and User groups like Providing Privileges to the users and User Groups in Access Manager.
• Used Event Studio to create agents and monitor the data.
• Using Transformer cubes as data source import into Framework Manager, and created Models, packages for Analysis Studio.
• Created highly Complex Reports using OLAP Cubes as Data Source for Multi Dimensional Analysis.
• Automated the Monthly cube refresh Process using Command Line options and scheduled it using Windows Scheduler.
• Developed Report Templates for Standard and Adhoc reporting to make the Reports look Consistent.
• Developed List, Cross Tab and Chart Reports for different Views of Data.
• Implemented various reporting Techniques like Drill up, Drill down and Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail and secured the Reports and Folders to specific user groups.
• Deployed Packages, Reports to Test Environment using Content Administration.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user group

Environment: Cognos 10.1 & 8.3 (Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio),Transformer, Oracle 10g,Informatica8.1,Oracle Streams, Active Directory, Oracle Access Manager, OID, Solaris,Sql Server, Sun One I Planet, Web Logic 10.2,Erwin, PVCS.

Confidential, Chicago, IL

Sr Cognos Developer/BI

Responsibilities:

• Analyzed business requirements and transforms the Functional Design Document into Technical Design Document.
• Involve in Modeling and Reporting against a Warehouse (OLAP) which is in the form of a Star Schema
• Develop dimensionally model relational for Standard Reporting, Ad-hoc reporting and for Multi-Dimensional Analysis using multi-layer Approach and Modeling best Practices to meet the reporting requirements
• Developed and worked with design, development, implementation and support of ETL process using SSIS Packages in SQL Server 2008
• Ensure ambiguous relationships are resolved and implement model enhancement techniques to improve model performance
• Involve in design and development of security architecture to meet the business needs.
• Migrated reports from Cognos EP Series 7 (7.3 and 7.4) to Cognos 8.3 BI
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio
• Designed and Developed Advanced Prompt Pages using various varieties of Prompts and validated the Prompts using Java Script.
• Created highly Complex Reports using OLAP Cubes as Data Source for Multi-Dimensional Analysis.
• Automated the Monthly cube refresh Process using Command Line options and scheduled it using Windows Scheduler.
• Used Union, Union all, Intersection for creating queries.
• Involve with Scheduling and Distributing reports through Schedule Management in Cognos Connection and Burst reports to different user groups
• Trained End users to operate the reports and Cognos Query Studio
• Production Support by involving in change requests of old reports
• Collaborate with business, functional and testing teams

Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection, Transformer), Impromptu Administrator, Transformer and Upfront, Architect, PPES, Access Manager, Cognos Query, Visualizer, Notice Cast, IWR SQL Server, Quality Center, Rational Clear Quest, UNIX.

Confidential, Clinton, MA

DW / BI (Cognos, Informatica) Developer

Responsibilities:

• Involved in all phases including Analysis, Design, Coding, Testing and Documentation.
• Suggested changes to the physical Data Warehouse Model based on the ETL and Referential Integrity gap requirements.
• Development of Informatica mappings, created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Extensively used Source Qualifier, Aggregator, Connected and Unconnected lookups, Filters and Sequence Generator Transformations.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Created multiple Dashboard reports for multiple packages.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Install Cognos 8 on Solaris operating system.
• Migrated Cognos series 7 Impormptu reports, catalogues and cubes into cognos 8, by utilizing the migration utility tool.
• Initiated for the users to do ad-hoc reporting using Query Studio.
• Extensive experience on Structuring Metadata and Cognos Models using Framework Manager.
• Provided support for slowly changing dimensions in data marts.
• Designed and Prepared a Material for the Users.
• Created List Reports, Cross tab Reports and Control Charts.
• Thorough knowledge of Cognos 8 architecture and administration functions including Content store, Framework Manager, and Report studio/Analysis/Query Studios /Metric Studio reports development.
• Implemented Security for Data access, Object level access and Package access.
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.

Environment: Informatica Power Center 6.x (Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet), Oracle 10g, SQL Server 2005, Cognos 8, Sun Solaris, Data Manage, Power Play Transformer 7.3, Cognos 8 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection).