PROFESSIONAL SUMMARY:

• Over 7 years experience in deploying/implementing Business Intelligence solutions for various industries like Healthcare, Manufacturing, Bio and Technology using Cognos10 BI, 8 BI, Cognos Report Net 1.1, Cognos Impromptu and Cognos series 7suite of tools.
• Well - versed with different phases of BI life cycle.
• Extensive experience in gathering and documenting end-user business requirements.
• Experience in upgrading reports from Cognos 8.4.1 to Cognos 10.1
• Developed reports extensively in report studio by creating various Drill-Throughs, Cross-Tabs, Dashboards, and Summary reports.
• Extensive experience in creating Scorecards for performance evaluation.
• Expertise in designing and developing models using Framework Manager.
• Expertise in developing Multidimensional Cubes using PowerPlay Transformer, and Reports using Power Play for Windows.
• Proficient in Performance Optimization of reports and Multidimensional Cubes.
• Experience in migrating reports from Impromptu to ReportNet, and upgrading reports from Report Net to Cognos 8 BI.
• Good knowledge of ETL Processes.
• Involved in Installation and Configuration of Cognos 8 BI (All components including PowerPlay and Framework Manager) in Stand-alone and Distributed Environment.
• Strong Experience using PL/SQL and MDX in development and testing of reports, analyzing data in tables, Cardinalities between tables and joining tables.
• Strong understanding of Relational Database Design concepts and in depth knowledge of OLAP, OLTP Solutions.
• Strong understanding of Dimensional Modeling (Star and Snowflake Schemas)
• Knowledge in SAP BW, SAP BO, SAP HCM, OBIEE, SAS.
• Knowledge in Informatica and Datastage Workflow.
• Exudes energy, motivation and confidence. A good team player with excellent communication skills, ability to meet deadlines, multi-tasking and flexible in work schedules.
• Successful and highly experienced professional with the extremely valuable combination of technical knowledge, business acumen and interpersonal skills.

TECHNICAL SKILLS:

BI Tools: Cognos 10.1, Cognos 8: Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Framework Manager, Event Studio, PowerPlay Transformer.

Report Net 1.1: Cognos Connection. Cognos Query, Upfront, Crystal reports, and Jasper reports.

Cognos Series 7: Upfront, PowerPlay Transformer, Impromptu Web ReportsAccess Manager, Power Play Enterprise Server, Impromptu Administrator.

Methodologies: Star, Snowflake Schema.

Databases: MS SQL Server 2000/2005, Oracle 8i/9i/10g, DB2, MS Access, Sybase ASE/IQ.

ETL Tools: Data Manager/Decision Stream, Datastage, Informatica, Power Center, Ab Initio.

Web Servers: IIS, Apache Web Server.

Operating Systems: Windows 2000, 2003, NT, XP, vista, 7, Server 2000, 2003, 2008, UNIX, Ubuntu, Mandriva, Fedora, Open SUSE.

PROFESSIONAL EXPERIENCE:

Confidential, Malta, NY

Sr. Cognos Developer

Responsibilities:

• Understanding existing business model and user requirements.
• Involved in upgrading Cognos 8.2 BI reports to Cognos 10.1.1 BI and deployment.
• Implemented package level, object level and data level security in the reports.
• Fine-tuned the reports, underlying queries and tables using indexes.
• Worked on Data Analysis, Validate reports and troubleshoot the errors.
• Re-designed Impromptu Model & developed the model in Cognos 10 BI and published packages using Framework Manager (FM).
• Implemented the Snowflake/Star schema methodology for the design of the Model.
• Worked on Framework Manager to solve ambiguous relationships in metadata models, and published packages.
• Created and adopted multi layered approach to avoid data complexity for endusers in FM.
• Responsible for improving report response time by creating appropriate joins between Query Subjects.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection.
• Prepared Weekly Status Reports(PMO) and shared with the Managers.
• Deployed the Ad-hoc Model Reports from Dev. to Val. and to Prod. Environments.
• Production support and prepared documentation of each report created.

Environment: Cognos 10.1 - Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Map Manager, Cognos Configuration, XML, HTML, Oracle11g, Oracle 8i PL/SQL, SQL Developer, SQL Plus, Javascript, Visio.

Confidential, Calabasas, CA

Sr. Cognos Developer

Responsibilities:

• Created Star schema, dimensional models, Data Level Security in the Framework Manager Metadata model.
• Interact with Business Users in multiple locations to finalize or clarify Requirements and assist in creating the Dimensional data models.
• Worked on Cognos 10.1 Active reports and created dashboards in Business Insight.
• Enhance the existing metadata models with the required changes in Framework Manager and published them to the Cognos connection.
• Created Requirements and Technical design documents. Attend the project meetings, Reviews and Walk-throughs for requirements, design and test plans.
• Created reports in Report Studio and Analysis Studio with multiple queries and drill through capabilities.
• Created reports in Cognos 10.1 using embedded SQL.
• Customization of prompts and report pages functionality using JavaScript.
• Worked with Database Administrators, Security Teams, and IT Infrastructure teams to resolve technical issues and coordinate changes that impact user communities.
• Cognos Administration activities including Server configuration, Security, Upgrades, Patch Installations, Implementation of Change Requests.
• Coordinate with IBM on Issues, Upgrades and Installations.
• Process Improvements and Research on optimizing the Cognos Functionalities from the Application perspective.

Environment: Cognos 10.1 - Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio,Map Manager, CognosConfiguration, HTML, Oracle10g, PL/SQL,SQL Developer, SQL Plus, TOAD, Javascript, Visio, Windows Server 2003, LDAP.

Confidential, Cypress, CA

Sr. Cognos Developer

Responsibilities:

• Interacted with the Business to draft Business Requirements which includes sources, granularity of data, fields in the tables, and business rules.
• Created various Report Technical Specification (RTS) documents to define detailed user requirements.
• Defined various Functional Specification document to outline various reporting standards, Business rules and Data Mapping.
• Worked with the BI team to develop a versatile Framework Manager Model using the MDDW data warehouse data model in Oracle 8i Database which follows the Functional Specifications document.
• Created Business Views, Namespaces, Model query subjects in Framework Manager for easier report development and to enhance multi-user environment.
• Implemented model level security leveraging the same security levels as implemented at the back end Sales application.
• Built Multidimensional Cubes using PowerPlay Transformer and published them to Cognos connection using Framework Manager.
• We were able to complete around 200 reports successfully before the deadlines.
• Ensured that developed reports meet specifications, run efficiently and are error free through Data validation and performance testing.
• Developed various reports using Pass-Through SQL as required to improve performance.
• Actively involved in Data Warehouse design.
• Involved in administration of Cognos 8 BI environments.
• Involved in deployment (import /export) of reports and packages in different environments.
• Used SQL in TOAD for Oracle to test and validate data in reports.
• Conducted various training sessions on basic/advanced report authoring to familiarize end users to the new reporting environment.
• Created various user guides, report technical specifications as required.

Environment: Cognos 8.x BI Suite (Cognos Connection, Framework Manger, Query StudioReport Studio, Cognos SDK), Oracle 9i, Windows Server 2003, Datastage 7.0.

Confidential, Nashville, TN

Cognos Developer

Responsibilities:

• Very Strong in Interacting with the Business Users and Supervisors to get a better understanding of Client Business Processes and gather Business Requirements and converting them into Business Requirement Documents, Use Case Document, test methodology, designing test plan, preparing documentation, standardizing procedures.
• Extensively worked with Business users and the Board of Directors to understand their needs and generated various reports using Impromptu, Power Play, and Report studio.
• Worked with the data center closely for various automation processes and managed distribution lists.
• Published OLAP Cubes and Reports on the Cognos Sever Administration Portal.
• Installed Cognos 8.3 on a test server for migrating the cubes from 7.1/7.3
• Analyzed the Business needs and proposed models to consolidate the framework projects.
• Designed Framework models to explain the capability of Cognos 8 and the advanced features such as Dashboards/ Scorecards.
• Trained Business users to use Query Studio and Cognos Connection using Cognos 8.3
• Worked on Cognos Security Administration to restrict the Users.
• Created UAT plan documents for the managed reports.
• Created and Managed Catalog’s in Impromptu Administrator by adding tables and creating new joins, and created distributed catalogs when required.
• Tested and validated reports based on source system data.
• Provided training to end users on Cognos Impromptu, and Power play
• Worked on migrating the reports from the Legacy systems (Mainframe) to Cognos.
• Used Macros for automation of reports.
• Created portfolio’s for various Retail & Wholesale divisions
• Represented the Cognos Team at the Cognos User Group Meeting’s of Middle Tennessee.

Environment: Cognos 8.3, Cognos ReportNet, Cognos Impromptu 7.1/7.4, Impromptu Web Reports 7.1(IWR), Cognos Power Play 7.1/7.3, Cognos Power Play Transformer 7.3, Cognos Upfront 7.1, Portfolio, Access Manager 7.1, Configuration Manager 7.1, SQL Server, SQL Tools, Toad, Oracle, Ms-Excel, Windows NT, Citrix Client tools.

Confidential, Tempe, AZ

Cognos Developer

Responsibilities:

• Interacted with business users for requirement gathering.
• Modeled metadata with Framework Manager to provide efficient Model and packages for Sales and Finance departments.
• Customized metadata to dynamically control the data returned, using Session Parameters, Parameter Maps, and Macros.
• Implemented security using Views.
• Involved in administration of Cognos 8 BI environment.
• Developed reports envisioning those created in Access.
• Developed reports using dynamic Pass-Through SQL when required.
• Involved in importing and exporting of data between all three environments.
• We were able to complete around 50 reports successfully before the deadlines.
• Conducted user training to familiarize end users to the new reporting environment

Environment: Cognos 8.2 BI Suite (Cognos Connection, Framework Manger, Query Studio, ReportStudio, Analysis Studio), MS SQL Server 2000, Windows Server 2003 Enterprise SP2

Confidential

Cognos Developer

Responsibilities:

• Analyzed the existing Oracle Form based Client server System.
• Analyzed the Data-mart.
• Created the Design Specifications for the Requirement Specification
• Worked on Data Mapping for the models.
• Created the Framework Manager Models.
• Provided the prompts in Query Studio
• Created predefined Filters for the Ad-hoc users.
• Applied three levels of security to the model (Data, Object and Package)
• Published the models in Development Environment and applied the Folder security and access capabilities for the users
• Migrated the reports to Test Environment. Ensured that it works fine when migrated to Test and good to go for Production.
• Worked on the migration of reports to Test to Production Environment.
• Converted Complex Power-Prompt Reports into Cognos 8 Reports.
• Implemented prompt skipping in Cognos 8 Reports.
• Worked on Access Manager for administration purpose.

Environment: Cognos 8 MR2 (Framework Manager, Report Studio, Query Studio, SDK), Cognos 7.3Power prompts Oracle 9i and Windows Server 2003.