SUMMARY

• Framework Manager Cognos BI and Created, modeled and published packages in Framework Manager from multiple databases for use with Report Studio, Query Studio and Analysis Studios.
• Report Authoring using Cognos 11, 10.2.2 10.1 8.4 8.3 , 8.2 Suite, Cognos Series 8.0 and Cognos Report Studio, Query Studio and Analysis Studio.
• Cognos Analyst Developer gathers requirements, design, develop.
• Good exposure in Interacting with Business users to get requirements, to fix issues or train users on ad - hoc reporting. Tableau Developer, Power Bi Desktop Data Visualization.
• Design, develop, and test Tableau scripts to import data from source systems and test Tableau dashboards to meet customer requirements.
• Expert creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.
• Experience working with dataset ingestion, data model creation, reports, dashboards, KPIs, Power BI Pro features, Cloud, direct queries, and dax expressions.
• Experience with Tableau, Hana, Power-BI, SQL Server Reporting Services, and/or other reporting and analytical tools
• . Cognos Transformer Cubes using Transformer
• Experience in working with various databases that include Oracle, SQL Server Databases.
• Strong knowledge on Data Warehousing concepts - Star schema, Snow-flake Schema and worked on both OLAP and OLTP databases.
• Thorough understanding of System Development Life Cycle (SDLC) experience from requirement analysis through Design & Development.
• Versatile industry experience in Finance, Marketing, Retail, Chemical, Insurance and Sales.
• Strong Analytical skills, Details - Oriented and ability to multi-task.
• Self-motivated, creative, work with minimal supervision, debugging and crisis management.
• Excellent interpersonal and oral and verbal communication skill.

TECHNICAL SKILLS

BI Tools: Cognos 8.1/8.2/8.3/8.4/8.4.1 10.1 10.2.1 10.2.2 11. BI (Report Studio, Query Studio, Analysis Studio, Frame Manager, Metric manager, Cognos Connection),Cognos Series 8 (Impromptu, Power Play, Transformer Upfront).

Migration Tools: MigS7, Mig Deploy

Operating Systems: Windows 2000/2003/ Vista/ 2008, Windows 7

Software Packages: MS- Office, Microsoft Word, Excel and Power Point vision

Databases: MS SQL Server 2005/ 2008, Oracle 11g/12c, 10g/ 9i/ 8i

Database tools: SQL*Plus 3.3/8.0,PL/SQL Developer Load

Data Modeling: Physical and logical, Star schema, snowflake schema, Normalization.

PROFESSIONAL EXPERIENCE

Confidential, ST PAUL MN

Cognos Developer

Responsibilities:

• Modify Report Studio Involved in designing and creating various reports in Report Studio.
• Customized data by adding filters at Report level. Worked a team towards finishing the tasks and achieving project deadlines Report. Experience in Design, Development & Build activitie in Cognos Suite of Products. Hands-on development mentality, with a willingness to troubleshoot and solve complex problems, across teams, functions and regions leading to increased efficiency and accuracy in reporting and data.

Environment: Cognos 11.01

Confidential, Dallas TX

Cognos Developer/Tableau Developer/Power BI

Responsibilities:

• Tableau Developer, Power Bi Desktop Data Visualization, Working with various databases that include Oracle, SQL Server Databases. Microsoft Azure Data Explorer Power bi Cloud direct queries, and dax expressions.
• Worked on Framework manager
• Expert creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.
• In-depth experience with Microsoft Business Intelligence Suite maintenance and support Framework Manager Cognos BI and Created, modeled and published packages in Framework Manager. Report Studio Involved in designing and creating various reports in Report Studio.
• Cognos Report Studio using prompts and parameters in Report, Microsoft Word, Excel.

Environment: Microsoft SQL Server 2005, Oracle 10g, Oracle 11g/12c, Cognos 11, 10.2.

Confidential, New Orleans, LA

Sr. Cognos Report Developer

Responsibilities:

• Report Studio Involved in designing and creating various reports in Report Studio.
• Cognos 10.1
• Creating/updating Relational Model and publishing packages using Framework Manager
• Created reports like List, Cross tab and Dashboards.
• Created, modeled and published packages in Framework Manager from Report Studio, Query Studio and Analysis Studios.
• Developed, maintained and supported Cognos Reports, Data Visualization.

Environment: Cognos 10.1 Oracle 10g.

Confidential, New Orleans, LA

Cognos Report Developer

Responsibilities:

• Report Studio Involved in designing and creating various reports in Report Studio.
• Cognos Report Studio, Query Studio and Analysis Studio.
• Cognos experts in the upgrade of Datanet, Confidential Cognos 10.0
• Experience in Design, Development & Build activitie in Cognos Suite of Products. Hands-on development mentality, with a willingness to troubleshoot and solve complex problems, across teams, functions and regions leading to increased efficiency and accuracy in reporting and data.
• Customized data by adding Calculations filters at Report level.
• Create a security filter and apply it to a specific query subject.

Environment: Microsoft SQL Server 2005, Oracle 10g/12c, Cognos 10.1

Confidential, Fort Worth, TX

Cognos Developer/Business Analyst

Responsibilities:

• Modify Report Studio Involved in designing and creating various reports in Report Studio.
• Customized data by adding filters at Report level. Worked a team towards finishing the tasks and achieving project deadlines Report.
• Worked on Cognos 10 to build confidence to the users on the cognos features.
• Design and implementation of BI reports and dashboards using Cognos.
• Frame Work Manager and created daily, weekly and monthly reports using those packages
• Experience in building Complex Reports using prompts and parameters in Report
• Conditional Formatting by using Report Studio Created Drill Through reports.
• Development and maintenance projects.

Environment: Seed, UAT, Cognos 10.1, Oracle 10g/12c.

Confidential, Monroeville, PA

Cognos Report Developer

Responsibilities:

• Administrators with the Modify All Users and Modify All Resources rights can also change any Cognos domain user password, where as non-admin Cognos.
• Report Studio conditional prompts. Developed Customized data by adding Calculations filters at Report level.
• Report. Conditional Formatting by using Report Studio, Data Visualization.
• Created reports like List, Cross tab and Dashboards.

Environment: Cognos 10.1 SQL Server 2008, DB2, Oracle 10g/12c.

Confidential

Cognos Developer/Admin

Responsibilities:

• Transformer build cube for Report Analysis Studio and Report Studio
• Created Drill Through reports and Conditional Formatting by using Report Studio
• Created reports like List, Cross tab and Dashboards by using Report Studio
• Extensively worked on complex reports, drill through reports, master detail reports, conditional prompts.
• Developed Multi Page Reports. Keeping it hidden from all users, who has access to that package.

Environment: COGNOS 10.1 SQL Server 2008, DB2, Oracle 10g.