SUMMARY

• Cognos Certified Professional with 8+ years of total IT industry experience in analysis, design, testing, development and implementation of client/server & Web applications.
• Highly Proficient with BI tools using Cognos 8 BI, 8.4, 8.3, 8.2, 8.1.2 (MR2) suite, Cognos ReportNet Report Studio 1.1 (MR3), ReportNet Query Studio 1.1 (MR3), ReportNet Framework Manager 1.1 (MR3), Cognos PowerPlay Transformer V7.x, 6.x, PowerPlay Web, Cognos Impromptu V7.x, 6.x, Impromptu Web Reports (IWR), Cognos Visualizer 1.5/7, Upfront and Access Manager.
• Extensively used Cognos 8 BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio, Metric Studio, Event Studio and Query Studio).
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Designed and developed Framework manager 8.x dimensional modeling which includes creating regular dimension, measure, resolving multi - grain multi-fact, loop joins and appropriate use of determinants.
• Experience in relational and dimensional (DMR) modeling.
• Hands on experience in Report building (Crosstab, List, Dashboard reports) using Report Studio and Analysis Studio.
• Experience in Transformer model design and PowerPlay cube building.
• Experienced in building scorecard reports and dashboard reports using metric studio.
• Excellent knowledge on data warehousing concepts - Star Schema, Snow-Flake Schema and worked on both OLAP and OLTP databases.
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.
• Experience with Cognos Java SDK in creating dynamic reports and producing automated batch report processing.
• Strong knowledge on ETL tools like Microsoft SSIS.
• Extensive Unix Shell Scripting knowledge.
• Experience in languages and Technologies such as C#.NET, ASP.NET, VB.NET, Web Services, ADO.NET.
• Experience in writing SQL, T-SQL, PL/SQL Packages, Stored procedures, Functions, Triggers, Cursors as per the business needs.
• Experience in databases such as Oracle 8i/9i/10g, SQL Server 2000/2005/2008 , DB2, Sybase.
• Experience working in insurance domain and certified on Property & Casualty Insurance from AICPCU.
• Dynamic team player, a self-starter with strong communication and leadership skills.
• Ability to handle multiple tasks and work independently as well as in a team environment.

TECHNICAL SKILLS

Reporting Tools: Cognos 8 - Report Studio, Analysis Studio, Metric Studio, Event Studio, and Query Studio, Cognos Impromptu, Cognos Series 7, SQL Server Reporting Services.

Modeling Tools: Cognos Framework Manager, Cognos Transformer, Cognos Metric Designer, ERWIN, Access Manager.

Markup Languages: XML, HTML.

Programming Languages: PL/SQL, T-SQL, Java, C#, ADO.Net, ASP.Net, JavaScript.

Operating Systems: Windows 98, NT, 2000, XP, 2003 Server, Knowledge of UNIX Basic commands.

Databases: Microsoft SQL Server, IBM DB2, MS Access, MS Excel.

ETL Tools: Microsoft SSIS. BIDS

Version Control: PVCS, Visual Source Safe.

Modeling Tools: Microsoft Visio, Rational Rose, Erwin

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior BIDW Lead/Architect

Responsibilities:

• Involved in the entire project life cycle from evaluation, design, development and deployment of end-user reports.
• Worked on creating functional architecture diagrams with technical & system process flow.
• Used ETL (Microsoft SSIS) to load data from source to ODS.
• Developed Framework Manager Models to import the data from multiple data sources, specified the overall relational data architecture (metadata) and generated packages of various subject areas, to be published onto ReportNet server.
• Created and maintained SSIS packages using Microsoft SQL server visual studio or Business Intelligence Development Studio (BIDS).
• Used Report Studio and Query Studio to develop various types of reports like list reports of customer and account information, cross-tab summary reports, charts/graphs to track the performance of geographical regions over various periods of time, and master-detail, drill-through reports.
• Created Cascading scorecards, child report, converted excel sheets to tab-delimited files using metrics manager.
• Expertise in Object level and Data level security
• Work on (SSAS) multi-dimensional data in SQL Server which can be gathered from different kinds of resources like flat files to relational databases.
• Created burst-reports using Report Studio to generate subsets of call/sample details and distributed the sub reports to specific regional heads over email.
• Created Multidimensional reports by implementing Multi Dimensional Cubes using Power Play and Transformer.
• Experience Decision Stream with OLAP analysis, scorecards and dashboards on one product and modern architecture.
• Created prompts, calculations, conditions, filters and other metadata objects using Framework Manager.
• Developed prompt pages and cascaded input prompts to filter reports on user specified criteria.
• Worked on creating Cognos SDK tool which interacts with Cognos connection to schedule automated generation of Cognos reports.
• Scheduled periodic refreshes of reports using Schedule Management in Cognos Connection.
• Create and modify parameter, modify existing reports and create new reports.
• Experience in financial planning and analysis.
• Experience in working with Microsoft SSIS ETL tool.
• Created all types of report by using report studio, query studio and analysis studio.
• Worked on documentation and end-user training on Query Studio for Ad hoc reporting.

Environment: Cognos 8.4 Suite (Cognos Connection, Framework Manager, Report Studio), Cognos SDK, SQL server 2005, Windows XP, IIS, Microsoft Visio, Eclipse, Apache, VSS 6.0, Visual Studio .Net 2005, Rational Rose, MS-Office, SharePoint, C#, Core Java, Visual Basic, VBScript and Java Script, Sybase.

Confidential, NJ

Senior Cognos Lead, Onsite Coordinator

Responsibilities:

• Analyzing and developing specification documents for reports as per the requirements.
• Involved in the brainstorming for creation of the report and the report templates.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models.
• Customizing Cognos Connection Portal based on user specifications.
• Creating the different types of Chart, List, Cross tab reports using Report Studio.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Developing the Dashboard reports using Cognos Report Studio.
• Used the IBM Cognos 8 SDK to get Report specification from content store and save the report locally.
• Used XSLT, XML, Java SDK to add columns dynamically.
• Analyzed XML Report Specification documents for creating the report dynamically using XML Editors.
• Installed & Configured the Cognos 8.4 on Windows Environment.
• Manage and support internal web development using HTML, CSS and Java scripts.
• Resolved issues resulting from User Acceptance Testing.
• Designed and implemented performance improvement changes to nightly ETL processes using Microsoft SSIS.
• Developed builds in Microsoft SSIS to transfer data from source to target.
• Worked with ETL team to get the real time data for the reports.
• Created mappings with SSIS on ETL side to extract data from source and to load into targets to get historical data and real time data.

Environment: Cognos 8.4 Suite (Cognos Connection, Framework Manager, Report Studio), Cognos SDK, SQL server 2005, Windows XP, IIS, Microsoft Visio, Eclipse, Apache, VSS 6.0.

Confidential, NJ

Senior Cognos Lead, Onsite Coordinator

Responsibilities:

• Gathered the Business Requirements from the end Users.
• Used Framework Manager to build metadata model, which could be used by Report Developers in the group.
• Modified, Created, published, and modified several packages in Framework manager according to the business needs.
• Developed Standard Templates, which laid a foundation for all reporting needs.
• Developed Dashboard Reports, Standard Reports, Charts, and Drill through Reports, using Report Studio and Query Studio in Cognos 8.4.
• Creating Query Prompts, calculations, Conditions & Filters for the users.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Creating user groups in Cognos Connection from Active Directory groups.
• Involved in Documentation for User training.
• Worked on Cognos Servers issues
• Supported the Cognos Development and Production environment

Environment: Cognos 8.4 Suite (Cognos Connection, Framework Manager, Report Studio), Cognos SDK, SQL server 2005, Windows XP, IIS, Microsoft Visio, Eclipse, Apache, VSS 6.0.

Confidential, NJ

Senior Cognos developer, Onsite Coordinator

Responsibilities:

• Involved in gathering Business Requirements from Business Analysts and Users.
• Interacting with Development and Management Teams, providing Technical Assistance to Developers.
• Used Framework Manager to build metadata model, which could be used by Report Developers in the group.
• Created, published, and modified several packages in Framework manager according to the business needs.
• Developed Standard Templates, which laid a foundation for all reporting needs.
• Developed Standard Reports, Dashboard Reports, Charts, Drill through Reports, Master Detail Reports, Bursting Reports using Report Studio and Query Studio.
• Creating Query Prompts, calculations, Conditions & Filters.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Query Optimization, Performance Tuning of reports and model.
• Creating user classes and profiles in Cognos Connection.
• Testing and improving Report Performance.
• Training Users on Query Studio for Ad-Hoc Reporting.
• Involved in Documentation for User training.
• Maintained the cubes on the series 7 environment
• Deployed Cubes and Reports on PowerPlay Enterprise Server and also Published to Upfront.
• Implemented security and granted privileges according to user classes using Access Manager (Used LDAP Directory Server).

Environment: Cognos ReportNet 1.1, Powerplay Transformer 7.3, Cognos PowerPlay, Access Manager, SQL, PL/SQL, Oracle 9i, SQL Server, Windows 2000, Windows 2003 Server.

Confidential, NJ

Cognos Developer

Responsibilities:

• Designed, Developed and Implemented an Enterprise Wide Reporting system using Cognos ReportNet.
• Installed and configured various components, such as the Framework Manager and Content Manager (Database).
• Maintained projects using VSS as the version control mechanism
• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into the Framework Manager
• Used Framework Manager to build models, packages and publish packages to the ReportNet Server.
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
• Created Filters, Calculations, Conditions, Graphs, and Prompts.
• Created several List, Crosstab, Chart, Repeater reports using Report Studio.
• Developed Prompt Pages and used Conditional Formatting.
• Created adhoc reports using Query Studio.
• Developed Multidimensional Models in PowerPlay Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures.
• Created Alternate Drill-Down Path, Special Categories & Currency Conversion set up to better suit different user groups.
• Published reports and cubes to Upfront using PowerPlay Enterprise Server (PPES) and Impromptu Web Reports (IWR).
• Implemented security by creating Namespaces and User Classes using Access Manager.
• Performed proof-of-concept projects in ReportNet (Framework Manager, Report Studio, Query Studio, and Cognos Connection).
• Tested all the reports with Generated SQL and Manual SQL data. creating reports based on the developed catalogs.

Environment: Cognos ReportNet 1.1, Powerplay Transformer 7.3, Cognos PowerPlay, Access Manager, SQL, PL/SQL, Oracle 9i, SQL Server, Windows 2000, Windows 2003 Server.

Confidential, NJ

Sr .Net Developer

Responsibilities:

• Analyzing and developing specification documents for VB6 to .Net Migration project.
• Used Microsoft assessment tool to analyze the effort estimates for this project.
• Migrated to required code into .Net 1.1 framework successfully.
• Unit tested the applications and documented the results based on the designs.
• Co-ordinated with other team members and consolidated the deliverables and created the final build.
• Resolved issues resulting from User Acceptance Testing.

Environment: .NET Framework 2.0, ADO.Net, C#.Net, ASP.Net, IIS, Microsoft Visio, Windows 2003 Server, VSS 6.0, Microsoft Visual Basic 6.0.

Confidential, NJ

.Net Developer

Responsibilities:

• Analyzing and developing specification documents for ScheduleF system as per the requirements.
• Developed web pages in ASP.NET and coded the application logic in C# as code behind.
• Worked with ADO.NET data objects like Data Set, Data Reader and Data Adapter for retrieval and updating data to SQL Server 2008.
• JavaScript for complex validation, navigation, communication and format customization.
• Manage and support internal web development using HTML, CSS and Java scripts.
• Co-ordinated with other team members and consolidated the deliverables and created the final build.
• Resolved issues resulting from User Acceptance Testing.

Environment: .NET Framework 2.0, ADO.Net, C#.Net, Microsoft Visio, VSS 6.0.

Confidential

.NET Developer

Responsibilities:

• Participated in the whole life cycle of the project including design phase of the project, which was designed using ASP, VB and ADO.
• Developed the application using ASP, VB with SQL Server as the backend.
• Used Microsoft FrontPage in creating html pages.
• Designed web forms using ASP and used VB as code behind.
• Used ADO for Data Grid and Data list controls.
• Validation was done using validation control in ASP.
• Coded stored procedures, functions for the improved performance.
• Involved in creating .NET Reports to present the data in different views.
• Developed the front-end screens using Web forms.

Environment: Visual Studio .NET 2003, ASP.NET, ADO, VB, Oracle 8i, IIS, Visual Source Safe, and Windows 2000.