• Over 15 years of IT experience in Cognos Architect, Cognos Developer, software analysis, design and development.
• Experience as Cognos architect , involving Installation , configure, design Datamarts, set up security, Create FM Models, Setup ETL Jobs, Automate ETL Jobs , Reporting and Powerplay Cubes.
• Area of expertise encompasses Database designing, ETL phases of Data Warehousing.
• Created Business User type reports and Dashboard using Cognos 10.Optimized the reports and the dashboard.
• Experience in Reporting tools like Cognos, Business Objects and trained in OBIEE.
• Extensive experience with administration maintenance of Cognos Tools Area of expertise encompasses Database designing, ETL phases of Data Warehousing.
• Experience in various kinds of reports Dashboard, List report, grouped list report, summary report, crosstab report, mailing report, form report, freestyle report .
• Experienced with working with users, collecting information and requirement from users, Analyzing, plan and create Reports.
• Involved in connecting to corporate database, to setting up effective catalogs, joins, folders, filters, ensuring that adequate security procedures.
• Tech lead on projects to Manage the tasks were done and achieved on time and deadlines met.
• Working knowledge of the Star Schema and Snow Flake Schema Design strategies.

SKILLS

• Languages SQL plus, PL/SQL, VisualBasic5, 6, JAVA, Sun Solaris Administration.
• ETL Cognos Decision Stream, Informatica Power Center 6.2/6.1/5.1. /4.7/3.8
• Cognos Cognos 10, 8.4,8.3,8.1, Reportnet, Query Studio, Report Studio, Event Studio, Analysis Studio, Cognos Viewer, Cognos TM1, Framework manager, Datamanager, Cognos BI, Cognos Impromptu 7.0/6.0, Cognos Transformer6.5/7.6, Cognos Powerplay 6.5/7.6, Cognos Decision Stream, Impromptu Web Reports IWR , Cognos Query, Cognos Scheduler 6.0 , Cognos Visualizer, Cognos Metrics Manager 2.0, Cognos ReportNet, Business Objects
• Databases Oracle 9i/8i/8/7.x, MS Access, SQL server, Teradata, SQL server, SSIS SSRS.
• GUI/Tools Toad, DB Artisan, ERWIN, PL/SQL, SQL Plus, Excel, Golden32 and PLSQL Developer.

EXPERIENCE

Confidential

Working as Architect at NationStar Mortgage. Installed and upgraded Cognos 10.1 to Cognos 10.2 BI. Installed TM1 10.2.Created datamart in Netezza Appliance and used available Staging tables to implement Daily Reports. Architected performance dashboard and Reports for Collection Center. These reports are bursted to the respective Managers. Implementing Best Practices on FM Design and redesigning the Framework Model. Implemented Single Sign ON for Cognos on Citrix and In Process of implementing Cognos Mobile. In process of reporting based off TM1 cubes in Cognos BI. Fine tuning netezza SQL for reporting purpose.

Environment: IBM Cognos 10.2.1, Netezza, SQL Server 2008 R2, TM1 10.2, IBM Cognos Mobile,SSIS and SSRS.

Confidential

• Medsynergies does billing handling for Doctors and Other Hospitals and organizations.
• Implemented Dynamic Cubes which is new Cognos Analytic tool. Implemented and completed a POC on 4 reporting Dynamic cubes.
• Analyzed the current ETL process for the current reporting system and documented my suggestion to the super users . Explained pros and cons and implemented the cubes based on views and tables.
• Successfully implemented the Dynamic cubes. Documented the whole process step by step for the developers so they can take over after I am done with the project.
• Implemented security on the cubes.

Environment: IBM Cognos Dynamic Cube 10.2, Cognos 10.2.1, SSIS, Oracle 11i, SQL Server 2012.

Confidential

This is a consulting firm which caters to Oil Companies, The clients are spread across NM, OK And TX. Did install and upgrade to IBM Cognos 10.2 at more than 12 clients. Analyzed the requirement and setup model to create reports in Report Studio. And day to day support to various client for creating and maintaining reports and their Servers.

Environment: IBM Cognos 10.2, SQL Server 2008 R2, Report Studio, Query Studio. Capitalized ERP System.

Confidential

• Omni Hotels is a four Diamond Hotels company, They are spread across the US and have partners all over the world. Implemented 10.1.1 from scratch And after couple of months upgraded from 10.1.1 to Cognos BI 10.2. Installed and configured TM1 from scratch, so it can talk to Cognos BI. Have created models in Framework manager Implemented Cognos BI 10.2 Mobile. So the Reports are available on IPAD live , which are accessible in house as well as remotely.
• Laid out plans to implement Cognos BI in the company. Co-Ordinate with various groups to Successfully implement Cognos BI in the company for the first time.
• Provided Recommendations and work around for specific needs of the users. Help Data base people understand the requirements and design the datamart based on it .
• Implemented DQM Dynamic Query Mode from Framework Manager.
• Created Dashboard and other financial reports for the Finance departments. The dashboard is used by all the RVPs , GM, Presidents and Directors of the company.
• Created some Active reports, Report Studio Report. Two Versions of Dashboard one in the Portal and other in Cognos Workspace.

Environment: Cognos 10.2, Cognos 10.1.1 , Cognos Mobile, Framework manager, Cognos Bi Administrator, DQM, Dynamic Query Analyzer, Dynamic Cube Designer,TM110.2, SQL Server R2, IIS 7.2, Oracle EBS, Oracle 11g,

Confidential

• The client was a health care client and the project was to replace older reporting system with Cognos Reporting System, and also upgrade from Cognos 8.4 to Cognos 10.1.1.
• Analyze and create ETL Process for Reporting Datamart, Create DMR Model, Designed Cubes.
• Create report based of Olap Model and Cubes. Co-Ordinate with Off shore team.
• Maintain FM Models.

Environment: Oracle 11, Cognos 8.4.1, Cognos10.1.1, Cognos FM, Datastage, SSIS, Daptiv, Quality Center.

Confidential

• Install Cognos10.1 on Dev and production in a distributed environment, and at the same time do the migration from Cognos 8.3 to Cognos 10.1 environment.
• Initiated Database design and extracted data using SSIS.
• Created content store , Install Cognos on 3 tier in a distributed environment on development environment as well as Production environment.

Environment: Sql server 2008, Sql Server 2008R2, SSIS,IIS7.1, IIS7.5, Cognos10.1, Cognos FM, Cognos SDK.

Confidential

• This was a migration project where Datamarts had to be recreated based on the new Oracle EBS System which was replacing the old JDE system for the Cognos reporting environment. Perform ETL work using Datamanager.
• Analysis done on the old source system and documented the mapping on spreadsheet.
• Successfully Identify the mappings of the columns in the new datawarehouse.
• Setup Staging database from the EBS System.
• Setup new dev environment on SQL Server.Installed and did POC on TM1 10.1
• Setup ETL jobs in the new Dev environments, and based on the requirements the new jobs were also setup to build Dimensions and Facts. Having various other data sources like Kronos, Gilda, Tango etc.
• Perform Unit testing and get the user acceptance on the quality of data.
• Change the design in FM and make the model ready for reporting purpose.
• Create Dashboard in Cognos Report Studio.
• Manage the project ,Assigned the report development work to developer off shore.

Environment: Cognos 10 and Cognos 8.4 Report Studio, Datamanager 8.4,Cognos TM1 10.1, SQL Server2005, Oracle EBS, Oracle 10g, Oracle 9i,SQl Developer, JDE, Documentation.

Confidential

• This was a Datawarehouse project for the Cognos reporting environment. Performed ETL work using SSIS tool.
• This Project was about identifying the ways the customers who could save money on their utility bill by proposing them various steps as to how to save on the bills if their bill was High. Based on the demographics of the house or the Business and how much was their expenses every month on their utility bill.

Environment: Cognos 8.4, SSIS, Oracle 10g, SQL Developer, SQL Server 2005, Unix.

Confidential

• This project was about Supporting Migration of Cubes from Cognos Series7 to Cognos 8.4 environment. Debugging and redesigning the cubes and reports moved to the new Cognos 8.4 version.
• Migrating the reports from Reportnet to Cognos 8.4 And the same time supporting the production environment. Helping Team members with debugging the issues while building cubes and trouble shooting the issues during migration of the reports.
• Serving as the portal/dashboard designer utilizing Cognos 8.4. Managing new operational/finance report requests, leading creation of an internal ad-hoc reporting area to promote the concept of self-service reporting, serving as the BI Analytic technical resource, serving as Internal reporting expert.
• Develop standard reporting Templates, Perform gap analysis for new and conversion reports as well as working closely with architects and data modelers to address data gaps
• Help team to troubleshoot issues in creation of cubes and Migration of reports.

Environment: Cognos 8.4 Report Studio, Query Studio, Cognos Datamanager, Framework Manager 8.4, Powerplay Transformer, Oracle 10g, SQL Developer.

Confidential

• Working on ETL and Vibes reporting Project. Design and develop reports on Vibes Non Confirm database. Studied and understand the Non-Confirm system and also the data entered on Lims and Vibes system. Familiar with events which leads to non-confirm status. Familiar with FPR, FOQ statuses, Scrap and Sterilization. I was a integral part of the team on the reporting for Jacksonville and Ireland.
• Created Reports as we are still in the process of getting the database built.
• Involved in gathering requirement and doing analysis on it to lay out the foundation for reporting.
• Analyze the data source namely ETQ, Lims, Vibes and Staged Database.
• Actively working with the team on providing valuable information to designing the database.
• Recommended designs of Tables . These Tables were created in database and were populated using Cognos Datamanager.
• Created Sophisticated Dashboards and Template for reporting purpose in Report Studio.
• Supported and provided valuable tips while creating Powercubes.
• Provided support and fixed reports already in production.
• Created reports with drill down capability, Control charts and reports in Analysis Studio as required by the users.
• Work on the validation and user acceptance of the reports based on the data.
• Perform Upgrade from Cognos 8.3 to Cognos 8.4.

Environment: Cognos 8.3 Report Studio, Query Studio, Cognos Datamanager, Connection, Framework Manager , Powerplay, Oracle 10g, Oracle 9, 8, TOAD 9.1 .