SUMMARY:

• Over 10 years’ experience in Administration, analysis, design, development, Testing and implementation of business intelligence solutions using COGNOS. And Microsoft Power Bi
• Hands on experience in Cognos 10.1/Cognos 10.2.1Cognos 11.1.7(Active Reports, Report Studio, Analysis Studio, Framework Manager, Cognos Connection) Migration Cognos 8.4 to Cognos 10, Cognos11 and MS Power BI
• Performed source code management and application build and deployment using tools like Service Now, TFS (Team Foundation Server) and Jira
• Hands on experience in Cognos8 (Query Studio, Report Studio, Analysis Studio, Framework Manager, Cognos Connection) and Cognos Series 7.x (Cognos ReportNet 1.1, Cognos Impromptu, Cognos PowerPlay).
• Strong experience in creating and publishing packages in Framework Manager.
• Strong complex reporting skills - complex Drill-Through, Crosstabs, Summary Reports, Bursting Reports
• Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.
• Interacted with User for requirement gathering, effective analysis and to provide end-user training.
• Created the User Case, BRD, FRD, Flow Chart and UML
• Experienced in developing Dashboards Reports in Cognos 8, Cognos 10.1 and Cognos 10.2.1 and Cognos 11.0.13
• Experienced in White Box Testing / Unit Testing / System Integration Testing / UAT
• Expertise in Oracle 10G, 9i and MS SQL Server 2000, 2005, 2008, 2012 and 2017
• Involved in OLTP/OLAP system study, analysis and E-R modeling, developing database schemas including Star and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Proficient in all phases of Data warehousing concepts, and experience in dimensional modeling using Star Schema and Snow-flake Schemas.
• Excellent communication and interpersonal skills.
• Good work ethics, detail oriented, fast learner, team oriented, flexible, and adaptable to all kinds of stressful environments. Possess excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Reporting &Analysis: Microsoft Power BI (DAX), Cognos 8i (8.1-8.4-10.1-10.2.1-10.2.2-11.0.5-11.1.7 ) Active Reports, Cognos Framework Manager, Report Studio, Query Studio, Analysis Studio, Power Play transformer, Impromptu web reports, Cognos Query, Planning, VBA, Excel.

Admin/Security: Created and update the user security via cognos Admin, MotioCI (3.1.0)

Methodologies: Star and Snowflake Schema

QA Testing: MTM, Microsoft Visual Studio (Unit/ Integration Testing/SAT/UAT)

RDBMS (databases): MS SQL Server 2000, 2005, 2008, 2012 and 2017 Teradata, Oracle 10G (PL/SQL), MS Access

Scripting Languages: Java script, VB script, Dhtml, Html

Operating Systems: Windows 10/ 7/XP/NT/2000/98/95, MS DOS, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Cognos Developer

Responsibilities:

• Created the new reports and Dashboard in Report Studio
• Update and created the new packages in Framework Manager.
• Solved complex requirements in report studio.
• Tune the reports.
• Worked on Data warehouse Agile projects.
• Used Jira as project Management tool.
• Gathered the Business requirement from users.
• Created the User case.
• Created the functional requirement.
• Follow up the UAT.
• Updated the framework manager as needed.
• Created the reports in Query Studio.
• Tunes and modified the ad-hoc reports as requirements.
• Modified the prompts pages.
• Setup the report for Excel and PDF pages.
• Created the Dashboard.
• Worked on Canned and Ad-hoc reports.
• Used ICS for Report Impact Analysis
• Worked on the Data Warehouse, Finance, Sales, and marketing reports.
• Update the package in framework manager and publish the package.
• Created the new join and union in Ad-Hoc reports
• Changed the SQL and created the new SQL queries.

Confidential

Cognos Developer

Responsibilities:

• Created the dashboard in MS Power BI
• Updated and created Cube.
• Migrated reports Cognos 10.2.2 to Cognos 11.0.13
• Created the user access and security in cognos 10 and cognos 11
• Created the new reports and Dashboard in Report Studio
• Update and created the new packages in Framework Manager
• Solved complex requirements in report studio
• Tune the reports
• Worked on Data warehouse Agile projects
• Gathered the Business requirement from users
• Created the User case
• Created the functional requirement
• Created reports for bursting using CAMID
• Created the burst query for report bursting
• Created the reports in Query Studio
• Tunes and modified the ad-hoc reports as requirements
• Modified the prompts pages
• Update the report libraries
• Setup the report for Excel and PDF pages
• Created the Dashboard
• Worked on Canned and Ad-hoc reports
• Worked on Oracle (Financial) Database
• Updated the dashboard macros
• Created the new parameters for ad hoc reports
• Used Motio-CI for Report Impact Analysis
• Worked on the Data Warehouse, Finance, Sales and marketing reports
• Update the package in framework manager and publish the package
• Created the new join and union in Ad-Hoc reports
• Changed the SQL and created the new SQL queries
• Worked on SQL server 2008,2012 and 2017
• Promoted the reports Developments to QC and Production
• Used the Service now, TFS and Jira

Confidential

BI - PM - Cognos Developer

Responsibilities:

• Created the business reports in Cognos Report Studio
• Created the Sales and Marketing Dashboards
• Created the drill through reports
• Created the reports from Pass through SQL
• Migrate the reports from Development to Testing and Production
• Worked with Project Documents (BRD)
• Setting up different environments (development and production)
• Created the Ad-hoc reports in Report Studio
• Used Teradata as Data base

Confidential

Cognos Developer

Responsibilities:

• Worked on project for Department of Public Welfare State of PA (healthcare)
• Created the business reports in Cognos (10.1) Report Studio
• Worked on MS SQL server 2008
• Closed worked with ETL Developer (Informatica)
• Created the System Usability Documents (BRD)
• Setting up different environments (development, testing and production)
• Worked on PDM for created the DSD Reports
• Created the Dash Boards in Report Studio
• Created the Ad-hoc reports in Report Studio
• Testing (Unit/ Integration Testing, SAT/ UAT) in MTM and Created and resolve the Bug
• Administration/Security
• Developed SQL Driven reports.

Confidential

BI Developer/Cognos Administrator

Responsibilities:

• Migrate the reports from series 8.1 to series 8.4 and 10
• Worked on the migration of reports to test to Production Environment.
• Created Active reports in Cognos 10
• Created various portals involving Cognos 8 portlets.
• Used Data Access Layer to maintain keys, joins, SQL queries,
• Experience in developing models using prompts and filters.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL Driven reports.
• Worked on MS SQL server 2008 (SSIS)
• Closed worked with ETL Developer
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments (development, testing and production)
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Converted Complex Power-Prompt Reports into Cognos 8 Reports.

Environment: - Cognos 8, Cognos 10 Active Reports BI, Cognos Connection, Report Studio, Analysis studio, Framework Manager, Oracle 10g, PL/SQL, XML, Windows NT/4.0 and Teradata

Confidential

BI Developer/Security Administrator

Responsibilities:

• Used Framework Manager to created models, packages and publish packages to the Cognos 8 and Cognos10 Server.
• Used Data Access Layer to maintain keys, joins, SQL queries,
• Created Active report in Cognos 10
• Upgrade the reports from series 8.1 to series 8.4 and 10
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL in TOAD and exported results to Access Database.
• Developed SQL Driven reports.
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments (development, testing and production)
• Deployed the reports from development to testing and from Q.A. to production through deployment tool.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Administer user access protocols and created user accounts and access privileges

Environment: - Cognos 8, Cognos 10 Active Reports BI, Cognos Connection, Report Studio, Query Studio, Analysis studio, Frame Work Manager, Oracle 10g, PL/SQL, XML and Windows NT/4.0

Confidential Chicago, IL

Cognos 8.4 BI Developer

Responsibilities:

• Created the models, and published the packages in Framework Manager to the Cognos 8 Server.
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL in TOAD and exported results to Access Database.
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments (development, testing and production)
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various portals involving Cognos 8 portlets.
• Administer user access protocols and created user accounts and access privileges

Environment: Cognos8, Cognos10, Cognos Connection, Report Studio, Query Studio, Analysis studio, Frame Work Manager, Oracle 10g, SQL, Scheduler, XML and Windows NT/4.0

Confidential, NJ

Cognos Consultant

Responsibilities:

• Analyzed the existing Oracle Form based Client server System.
• Analyzed the DataMart.
• 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
• Migrates the reports to Test Environment. Ensured that it works fine when migrated to Test and good to go for Production.
• Working 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.4(Framework Manager, Report Studio, Query Studio), Oracle 10 and Windows Server 2003.

Page 6 of 6