Summary

• Over 8 years of experience in the Business Intelligence field, of which over 5 years are in Data Warehouse Management Systems.
• Have been involved in creating reports using Cognos BI series 8.1, 8.3, 8.4, 10.1.1 and 10.1.2
• Good communication skills and ability to implement projects with demanding objectives.
• Data Warehouse experience includes:
• Worked extensively with Cognos Business Intelligence Tools.
• Experience in generating various complex reports using Cognos 10, Cognos8, Report Net, Cognos PowerPlay, Impromptu, and Cognos Transformer.
• Over 6 months of experience in Cognos 10.1 Report Studio, Business Insight, Business Insight Advance .
• Over 2 years of experience in Cognos 10 Transformer, Report Studio, Query Studio, Analysis Studio and over 3 years of experience in Cognos 8 Transformer, Report Studio, Query Studio, Analysis Studio .Involved in the installation and configuration of Cognos8 and 10.
• Created and published packages in Framework Manager from various sources. Generated different kinds of reports such as templates, multilingual reports in ReportNet using Report Studio. Created an ad-hoc reporting environment for end users using Query Studio.
• Developed business mix reports like variance reports, Top ten reports, Ad-hoc reports and exception reports using Cognos.
• Experience in designing models, creating packages, catalogs and Multidimensional Cubes.
• Created list, cross tab, chart and Drill-through reports and created the reports in different formats like pdf, XML, HTML and CSV. Applied conditional formatting, calculation, Prompts on the reports.
• Various transformations such as aggregator, rank, filter and more.
• Worked extensively with all the databases like Oracle, SQLServer, MS access, DB2 etc.
• Excellent Communication skills and a self-motivated team player.

Technical Skills

• Business Intelligence Tools: Cognos 8.1, 8.3, 8.4 Report Studio, Query Studio, Analysis Studio, and Framework Manager, Transformer , 10.1/10.2, Report Studio, Business Insight, Business Insight Advance and ReportNet 1.1, Cognos Impromptu, PowerPlay, Access Manager, Impromptu Web Reports IWR , Power Play Web, Cognos Upfront, Cognos Architect, Access Manager, Cognos query Cognos Go Office, MicroStradegy.
• Databases: Microsoft SQL Server 2000 and 2005,Microsoft SQL server 2008 r2, Oracle 11g,10g, 9i, 8i, 7.x, MS Excel, MS Access, Dbase
• Modeling: ERWIN 4.1, UML Rational Rose
• ETL: Oracle Data Integrator, Informatica
• Operating System: UNIX, Windows NT, 2000, XP, 95, 98, Vista, Windows 7 , Windows Server 2003 and 2008, MS-DOS
• Programming Languages: C, C , SQL, PL/SQL, VBA, HTML and Java-Scripts
• MS Office Package: MS Office 2003, 2007 and 2010 Excel, Word, PowerPoint, Outlook .

Professional Experience

Confidential

Cognos Developer

Responsibilities:

• Maintain MCCS Retail Management System using several different Cognos environment.
• Monitor and manage multiple Cognos environments
• Migrated packages and reports from one environment to another environment
• Migrated report using clipboard. Exported Cognos content for back up.
• Update package and report permissions based on set policy.
• Create list, cross tab and chart reports in different formats like pdf, XML, HTML, Excel.
• Create models, packages, and published in Cognos connection using Cognos Framework Manager
• Create reports in Query Studio, Report Studio, Business Insight Advanced. Used Java-Scripts and Macro.
• Created pass-through SQL and package based report. Used package and Excel combined as a data source in Business Insight Advanced.
• Explored MicroStradegy dashboards and reports. Explored ODI Oracle Data Integrator .
• Created report using various prompts, and transformations such as aggregator, rank, filter and more.
• Created report using drill-through, drill down, master detail, conditional block and more.
• Validate report for accuracy using SQL before releasing to users.
• Work on report requirements with Business Analyst

Environment: Cognos 10.2/10.1.1 and Cognos 8.4 Framework Manager, Query Studio, Report Studio, Analysis Studio, Transformer, Event Studio, Business Insight Advanced ,Cognos Lifecycle Manager, MS SQL server 2005, Microsoft SQL server 2008 r2, Oracle 10g,11g UNIX, Perl, SharePoint 2010, Windows Server 2003, 2008 R2 , Internet Information Server v7.x, SMTP service hosted in Microsoft IIS 7.x, Windows 7, MS Office 2007,2010 Word, PowerPoint, Outlook, Excel . Micro Strategy, Oracle Data Integrator, Oracle SQL Developer, TOAD

Confidential

Cognos Administrator

Responsibilities:

• Maintain The BOEING Company Financial Information Management System using several different Cognos environment.
• Monitor and manage multiple Cognos environments
• Updated password for database, cube, and DSN using SQL Plus, XML, and Cognos Configuration.
• Migrated package from one environment to another environment
• Check environments to make sure all environments are up and running fine.
• Created Roles in Cognos Namespace and imported Access Manger roles as a member of Cognos Roles
• Exported Cognos content for back up.
• Update database password based on set policy.
• Setup new database connections and security procedures
• Set routing policy. Start and Stop Content Manager and dispatcher using Cognos Configuration and Scheduled Task.
• Monitor and maintain jobs in Auto Visn Administrator. Check and kill Zombies using Process Explorer.
• Updated portal label in different environment using XML. Configure Cognos using XML and Cognos Configuration.
• Monitor and Clean RAM Disk for Cube build. Monitor cube build and cube host process in AutoVisn and ensure cube built and hosted successfully.
• Create list, cross tab and chart reports in different formats like pdf, XML, HTML, Excel.
• Create packages from models and published in Cognos connection using Cognos Framework Manager
• Create reports in Query Studio, Report Studio and Analysis Studio

Environment: Cognos 10.1.1, Cognos8.4 Framework Manager, Query Studio, Report Studio, Analysis Studio, Transformer, Event Studio , MS SQL server 2005, Microsoft SQL server 2008 r2, Oracle10G, Teradata, UNIX, SharePoint 2010, Windows Server 2003, 2008 R2 , Access Manager, Meta Manager, Internet Information Server v7.x, SMTP service hosted in Microsoft IIS 7.x, Windows 7, Autosys, AutoVisn, MS Office 2007, 2010 Word, PowerPoint, Outlook, Excel .

Confidential

Business Intelligence Specialist

Responsibilities:

• Maintain Department of the Navy workforce analysis dashboard and Human Resources strategic dashboard.
• Created Data source connection and imported the data into the Framework manager and created metadata models, packages and published in the Cognos connection.
• Update monthly reports for the dashboard to analyze the gains and losses trend of the workforce.
• Update retirement eligibility and retirement forecast trending reports yearly for the dashboard that are pre-run.
• Create reports using Report Studio, Query Studio, and Analysis Studio. Continuing to respond to Quality Assurance review requests.
• Create training documentation for training the technical staff and produce documentation for knowledge base.
• Developing Standard Reports, Charts, Drill Through Reports Using Report Studio and Query Studio.
• Created the list, cross tab, chart and Drill-through reports and created the reports in different formats like pdf, XML, HTML, Excel and CSV
• Created packages from models and published in Cognos connection using Cognos Framework Manager
• Created cubes from models and published in Cognos connection using Cognos Transformer.
• Create reports in Report Studio and Analysis Studio using multidimensional Cubes.
• Created report using various prompts and transformations such as aggregator, rank, filter and more

Environment: Cognos 10.1, Cognos 8.3, 8.4 Framework Manager, Query Studio, Report Studio, Analysis Studio, Transformer, Event Studio , Cognos Data Manager 8.4, MS SQL server 2005, Microsoft SQL server 2008 r2, Oracle 8.X/9.i/10G, UNIX, SharePoint 2010, Windows Server 2003, 2008 R2 , Microsoft Active Directory, Internet Information Server v7.x, SMTP service hosted in Microsoft IIS 7.x, Windows 7, MS Office 2007, 2010 Word, PowerPoint, Outlook, Excel .

Confidential

Cognos Consultant

Responsibilities:

• Created Data source connection and imported the data into the Framework manager and created metadata models, packages and published in the Cognos connection.
• Created Business view using the Namespaces, Folders and segments in the project.
• Established and ensured joints between query subjects.
• Created complex reports using conditional formatting, calculations, search prompts, and value prompts, hyperlink on the reports.
• Created add-haq reports using packages from Cognos connection, reports with filter in Query Studio.
• Created the list, cross tab, chart, drill-through reports and created reports in different formats like pdf, XML, HTML and CSV using Report Studio.
• Applied the conditional formatting, calculations, Search Prompts, and Value Prompts on the reports
• Added users in the group such consumer applied permission such as read, write and execute.
• Set dashboard reports as home page for consumers.
• Imported Cognos report into Microsoft PowerPoint using Cognos Go Office.
• Created Simple and Complex Reports using Query Studio and Report Studio for training purpose

Environment: Cognos 8.3, Cognos Go Office, Framework Manager, Cognos Access manager, Cognos Query, Oracle 8.X/9.i, MS SQL Server 2005, IIS 6,MS Access, VBA, MS PowerPoint, MS Outlook, MS Excel, Windows.