SUMMARY

• 7 years of IT experience includes functional and technical experience in Data warehousing, data modeling, Business Intelligence (BI), Decision Support System (DSS) and OLAP, Product development and report generation.
• Extensive exposure to various business sectors such as Finance, Insurance, and Retail.
• Strong working experience with IBM Cognos 10/8 BI, IBM Cognos Reportnet and IBM Cognos Series 7.
• Extensive experience in flat relational and multidimensional modeling using framework manager and transformer modeling tools.
• Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and object levels as part of setting up reporting infrastructure.
• Experience with Oracle, DB2 and SQL Server relational databases. Good programming experience in SQL, PL/SQL, T - SQL, Stored Procedures, Functions, DB Triggers, Stored Procedures, Functions and Packages.
• Excellentinterpersonal andcommunication skills,technically competent and strong problem solving skills.
• I have wide-ranging experience implementing enterprise scale BI projects in the Finance, Pharmaceutical, Marketing and Energy sector.
• Designed List, cross tab, drill through, chart and complex reports in Report Studio.
• Developed Relational and Dimensional models using Framework Manager and Transformer to facilitate self service reporting environment.
• Involved in training business users and stakeholder on Cognos Workspace and Cognos Workspace Advanced to utilize IBM Cognos Content.
• I have extensive experience with creating documentation for BI Projects including Request Requirement form (RRF), Request for Change (RRF), Installation Qualification (IQ) and Code Reviews.
• I have created and implemented security solutions and change management processes across all environments in compliance with the Sarbanes-Oxley (SOX) Act.
• I have given several presentations and demonstrations to clients providing them knowledge about the BI capabilities of the IBM Cognos.
• I have been involved in all the phases of a BI project life cycle starting from requirements gathering and development to testing and implementation of services.

TECHNICAL SKILLS

BI Tools: IBM Cognos Suite: Cognos 10/8 BI, Cognos ReportNet, Cognos 7 series, Framework Manager, Transformer, Report Studio, Analysis Studio, Query Studio, Cognos Administrator, Configuration Manager

Database: Oracle 9i/8i, SQL Server 2005/2000, IBM DB2

Languages: SQL, PL/SQL, T-SQL, C, C++

DBA Tools: SQL Navigator, SQL Plus, Toad, SQL Loader, IBM DB2 Control Center

Operating Systems: Windows Vista/Xp/2000, UNIX, LINUX

Other: Microsoft Excel, Visio, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, New York

Senior Cognos Developer

Responsibilities:

• Involved in business requirement gathering, understanding previous reports and merging them with new products.
• Designed reports and models to support both Health Insurance exchange Marketplace reporting and Medicaid Line of Business reporting.
• Created UAT scripts, tested the reports and model and put together testing results.
• Provided training to business users on Work Space Advanced.

Environment: Cognos 10.2.1, Workspace Advanced, Report Studio, Cognos 7(Impromptu), Oracle 9i

Confidential, Providence, RI

Senior Cognos Developer/Administrator

Responsibilities:

• Involved in business requirement gathering, administering cognos environment and designing BI roadmap, MDX functions.
• Designed Framework Manager and Transformer models to support both relational and OLAP reporting and designed reports and dashboards based on the requirement.
• Created UAT scripts, tested the reports and model and put together testing results.

Environment: Cognos 10.2.1, IBM DB2, DB2 Control Center, Toad, Hyperion, MS Visio.

Confidential, Juno Beach, Florida

Senior Cognos Developer

Responsibilities:

• Took the lead in the development and enhancement of reporting solutions in different phases of project and designing the functional and technical requirements.
• Managed upgrade from Cognos 8.3 to 8.4 using Upgrade Manager.
• Created data mapping using business rules and processes.
• Utilized Cognos Connection, Framework Manager, Transformer, Report Studio, Analysis Studio, Query Studio.
• Replaced current multidimensional cube with Dimensionally Modeled Relational (DMR) to facilitate live reporting and self service capability.
• Conducted training sessions for business users for self service reporting service.
• Migrated reports from Oracle Discoverer to Cognos Environment.
• Implemented security at the database level using Virtual Private Database (VPD).
• Created Views, Materialized Views, Triggers and functions in database to facilitate reporting requirements.
• Created templates and set standards for Development Unit Testing and User Acceptance Testing (UAT) for IBM Cognos Packages and Reports.

Environment: Cognos 8.4/8.3, Oracle 9i, SQL Navigator 5.5, SQL Plus, Oracle Discoverer, Transformer

Confidential, Marlborough, MA

Senior Cognos Consultant

Responsibilities:

• Closely Involved in Requirement gathering and Analysis with the Business Users.
• Installed and configuredCognos 8.3 in Multi server Distributed Environment.
• MigratedReports from Cognos 8.2 to 8.3.
• Designed and Created Metadata models using Framework manager and Transformer and created various custom reports.
• Implemented Security for Data access, Object level access and Package access.
• Created complexDashboardsto provide single page view to Business Managers using multiple reports.
• CreatedTransformer Cube and developed Analysis Studioreports for weekly reports requirements.
• Provided trainingto the Business Users to do Self-reporting usingQuery Studio.
• UsedSSISfor data migration tasks.
• Designed and prepared atraining materialfor the Users.
• Used CognosAdministrative toolto provideuser access, security, deployment and report scheduling.

Environment: Cognos 8.3/8.2, Oracle 9i, SQL Server 2005, SQL Server Integration Services (SSIS), SQL Plus, SQL Navigator 4.4.

Confidential, Phoenix, AZ

Cognos Consultant

Responsibilities:

• Involved in providing both business and technical expertise in therequirements gathering, report design, report development, and support of all client/server layers and components of the data warehouse.
• Designed and developedFramework modelto better suit complex and simple report development using Oracle as backend.
• Involved in creating anad-hoc query modelfor query studio users. Created and published variouspackagesto meet different requirements.
• Created different types of reports likeList, Cross-tab, Chart, Drill-Thru andMaster-Detail Reports.
• Worked on Dashboard reports.
• DevelopedPrompt Pages, Cascaded input Promptsto display only the selected entries in the report and also worked on the customization of prompt parameters.
• Built reports with focus onoptimization, usedindexeson tables and made recommendations for summary tables where needed.
• Experiences in managing and coordinating data marts to provide conformed dimensions and facts that are shared across subjects areas.
• Provides support for slowly changing dimensions in data marts
• Implementeddata profiling and quality checkin data in Data Warehouse
• Worked as a team towards finishing the tasks and achieving project deadlines.
• Responsible for writing various documentations like technical specifications document, report specifications document and user manual.

Environment: Cognos 8 BI (Framework Manager, Report Studio, Query Studio, Analysis studio, Event Studio, Cognos Connection), SQL Server 2005, Toad.

Confidential, Horsham, PA

Cognos Developer

Responsibilities:

• Involved intuningthe existing reports for performance.
• Analyzed thebusiness specificationand the prototypes.
• Evaluated the user’s expectation and the accessibility of the data in the database.
• Involved inSecurity settings and Administrationof Cognos.
• Theflat relationalmodel for the reports was created in theFramework manager.
• Model query subjects were necessary and hence created for the ease of use and created joins, built standalone filters, prompts, merge query subjects into new query subject, determine hierarchy and dimension information in Framework Manager in order to reclaim the constructive package.
• Involved inimplementationof Cognos 8
• Appliedsecurityon data level and in thepackage levelin a manner that only the relevant users were able to see those packages and reports created.
• Supplemented regularprompts, cascading prompts, filters, Conditional style, static headers, Drill Through, sub queriesto add interactivity for users in Report Studio.
• Heavily involved in creatingTechnical Design documentto describe the detailed architectural design for the system, which is based on input from the Infrastructure and Design requirements.

Environment: Report Net, Framework Manager, Cognos Connection, Power Play, Oracle 9i, SQL Plus.