SUMMARY

• 10+ years of experience in Data Warehouse reporting with Technical expertise in designing and developing Business Intelligence applications using OLAP & Reporting tools, Cognos Suite/ Business Objects/SAS
• Experienced managing technical teams and providing leadership using a standardized SDLC
• Strong understanding business requirements and supporting technical functional requirements
• Demonstrated ability to create project plans and manage project tasks to the plan
• Good organizational skills and ability to prioritize multiple projects and objectives in a rapidly changing environment, and delivered quality results
• Developed Technical Architecture and designed options.
• Installed and configured Cognos 8/10 BI products, tuning and testing.
• Collaborated with Cognos defined best practices for reporting architecture to evolve enterprise products
• Developed and Published Packages using Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Experience in Deployment (Export, Import) using Framework Manager into Cognos Connection and Implemented security Confidential different levels in Framework manager and Cognos Connection to restrict access.
• Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting (including the bursting of reports globally) using Cognos. Created complex Dashboards withArea charts, Pie charts, Cross tabs and Multi prompts in Report Studio.
• Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Experience in Migrating reports from different tools to Cognos Suite and from Previous versions to Cognos 8 Version
• Experience using SAS v8e and SAS 9 (Information Maps and Web Report Studio under windows environment.

TECHNICAL SKILLS

BI Tools: Business Objects 4.1 X, REPORTNET 1.1,Congnos 10,Cognos 7.3 -Impromptu, Transformer, Powerplay and IWR), Cognos 8.3 - Query Studio, Report Studio, Analysis Studio and Framework Manager, SAS 8Ve, SAS 9

Database: Teradata, Oracle 9i/8i, SQL Server 2000/, MS Access

Oracle Tools: SQL, PL/SQL

Web Tools: HTML, JSP - Basic Level

MS & Other Tools: MS Excel, Word and PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Middletown, NJ

Cognos Tech. Lead

Responsibilities:

• Working as a Onsite Lead for Confidential & Confidential applications (FMO, INR, ARS, DSS)
• Involved in working closely with Business Analyst to understand the business requirements and report specifications.
• Created reports using List, Cross tab, Drill-through functionality and Chart templates in Report Studio.
• Developed standard reports, Charts, Drill-through Reports and Master Detail Reports
• Created query prompts, calculations, conditions and Filters.
• Created Bursting Reports and Multilingual Report bases Using Report Studio.
• Involved in scheduling Report Studio and Query Studio reports and sending reports via email to several business users Developed List reports, crosstab, Dashboard reports.
• Created Business Insights in Cognos 10
• Developed Relational and Dimensionally Modelled Relational Models in Framework Manager.
• Created Ad hoc reports like Grouped List Reports, List Reports and Cross-Tab reports using Query Studio.
• Create packages to suit the business needs and to improve the performance of the reports by defining filters, adding calculations and performing SQL tuning on the model and report level using Oracle database.
• Load balanced the Cognos 10 BI Multi server environment for performance issues.
• Proactively managed multiple environments to ensure high availability, high performance, and minimization of risk.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables using Oracle DB
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Migrated all the cubes and reports from Cognos 8.4 to Cognos 10.
• Also created documentation for all the processes involved like applying security for reports, deployment, portal customization etc.
• Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT.
• Worked extensively on EDW and Facets databases.
• Perform impact analysis on core business, systems and financial plans including a return on investment analysis.
• Experienced in full life cycle implementation including Design of universe and Report Development.
• Involved in installation, configuration and maintenance of Cognos environment
• Prepare and maintain complicated reports and documentation through the use of Cognos tools.
• Installed & Configured the Cognos 10 BI environment, administering the servers, Troubleshooting and Performance Tuning
• Understand the current flow and see how to make this new requirement to fit in that
• Work with web service /ETL/DBA team from other application to understand the data flow and how current existing functionality works
• Ensure new, changed and test only interfaces are understood by the applications.

Confidential

Senior Cognos Develeoper

Environment: Cognos 8.3 (Report Studio, Framework Manager, Oracle and Teradata)

Responsibilities:

• Involved in working closely with Business Analyst to understand the business requirements and report specifications.
• Involved in developing Business Test cases for Cognos.
• Involved in developing Design and Functional requirement documents.
• Developed several different kinds of reports with Report Studio.
• Involved in updating FM model
• Involved in Functionality and data testing

Confidential, Camp Hill, PA

Cognos Lead and SAS Programmer

Environment: Cognos 8.2 & 8.3 (Report studio, Analysis Studio, Query Studio, Event Studio) SAS Information Map, SAS Web Report Studio, SAS Enterprise Guide and Teradata

Responsibilities:

• Involved in working closely with Business Analyst to understand the business requirements and report specifications.
• Involved in Cognos Setup, Cognos Connection, created user groups and roles for them.
• Involved in Dimensional Modeling and Mapped the same to Framework Manager
• Developed several different kinds of reports with Query, Analysis and Report Studio.
• Involved in creating Agent through Event Studio .
• Implemented alternate drill down to achieve two different drill down paths. Created reports using Drill-through and drill down functionalities.
• Customized reports with Conditional Formatting in Report Studio
• Trained users in various Cognos Tools as part of the Power User Training Program

Confidential, Parsippany, NJ

Cognos Lead

Environment: Cognos 8.x (Report studio, Analysis Studio, Query Studio, Event Studio) Cognos Suite 7 (Impromptu, Transformer, Access Manager), SAS Web Report Studio, SAS Enterprise Guide and SAS OLAP cubes, SAS Information Maps and SQL Server 2005

Responsibilities:

• Involved in working closely with Business Analyst to understand the business requirements and report specifications.
• Involved in Cognos Setup, Cognos Connection, created user groups and roles for them.
• Involved in developing Business Test cases for Cognos.
• Involved in developing the documents for Cognos functionalities.
• Developed several different kinds of reports with Query, Report and Analysis Studio.
• Designed models using IQD, created Dimension Map and developed Cubes in Transformer, and analyzed the data using Cognos 8.

Confidential

Cognos Developer

Environment: Cognos 8.x (Report studio, Analysis Studio, Query Studio) Report Net 1.1, Cognos Suite 7 (Impromptu, Transformer, Power Play, Upfront, Access Manager) Oracle 9i and SQL Server 2000

Responsibilities:

• Involved in working closely with Business Analyst to understand the business requirements and report specifications.
• As a Senior Developer I Involved in preparing Functional Specifications, Technical Specifications, Testing Plans and other documentation as required by SDLC.
• Involved in Transformation using Informatica and used various types of transformation
• Impromptu, Directory Server, Access Manager, Upfront.
• Developed several different kinds of reports with Query, Report and Analysis Studio.
• Designed models using IQD, created Dimension Map and developed Cubes in Transformer, and analyzed the data using Power Play.
• Involved in UAT plan and deployment between different environments. (Development, Staging and Production).
• Trained users in various Cognos Tools as part of the Power User Training Program

Confidential

Cognos ReportNet Developer

Responsibilities:

• Migrated Brio, Business Objects, Actuate Reports to the Report Net environment.
• Built models using query subjects, query items and namespaces from the imported metadata.
• Updated Framework Manager Models and projects to add the new query subjects as per requirements.
• Models were used to create packages and publish the packages to the Report Net server.
• Prompt pages were developed based on the built framework models to select data in specific groups.
• Created user groups in Cognos Connection and applied data level and group level security for various entries.
• Created templates, standard reports, and Adhoc reports using Query Studio and Report Studio.
• Scheduled and distributed reports to the end users by schedule management in Cognos connection

Confidential

Database Developer (Oracle PL/SQL)

Responsibilities:

• Vendor Management which includes creating, updating of Vendors and related information
• Reporting requirements that will be addressed in a separate BRD to be prepared by the Domestic Claims Executive Information Systems Group
• Creation of Online Help documents and User Guide, VARS will provide links to the training website that will have these pages.
• Supporting browsers other than Internet Explorer
• Explorer Role based access to parts and functions of the system are deferred to the host Claims Applications that launch VARS.