PROFESSIONAL SUMMARY:

• Over 13 plus years of professional experience in Information Technology with expertise as Business Intelligence Consultant using Cognos BI, Tableau, Tm1, SAP BO, (Cognos Framework Manager, Report Studio, Cognos Power Play, Cognos Impromptu,), Qlikview, PowerBI, SSRS.
• Certified Scrum Master with professional experience in the IT industry spread across Project Management, Architecting, Business Analysis, Data warehousing, Reporting Analytics and business consulting.
• Experience in working with ETL process using Informatica, Cognos Data Manager, Datastage and SSIS
• Worked on the complete Life Cycle Development process SDLC. Experience in gathering end - user business requirements, providing specific direction, and training the Business users.
• Extensive experience with Data warehousing implementations, OLAP, OLTP tools
• Extensive experience building dashboards visualizations using Cognos11.0.7, Cognos 10.2.2, Tableau10.3, Cognos Workspaces and Business Insight.
• Worked on Oracle, SQL Server for reports development. Worked on Project upgrades from previous versions to the Current Versions. Worked on Data Integration Implementations
• Quick Learner, Excellent analytical and logical programming skills with a good understanding of the conceptual level. Possesses excellent written and verbal communication skills.

TECHNICAL SKILLS:

BI Tools: Cognos11.0.7, Tableau10.3 Desktop and Server, Qlikview, Cognos 10.2.2 Report Studio, Cognos ReportNet, Cognos Business Insight, Cognos Analysis Studio, Cognos 8., Cognos TM1 10.2, Framework Manager, Power Play Transformer, Query Studio, Impromptu Web Reports, Turbo Integrator, Power BI,SSRS, SSAS, SSIS, SAP Business Objects

ETL Tools: Informatica Power Center/ Power Mart, SSIS, Cognos Data Manager, Datastage, Hyperion Essbase

OS: Windows, UNIX (Sun Solaris, AIX, HP-UX, Linux)

GUI: TOAD 8.0, Oracle Developer 2000 (Forms 5.0/4.5 & Reports 3.0/2.5), JBuilder

Tools: Erwin Data Modeler, Excel, PowerPoint, Visio, Rational Rose, SQL* Plus, SQL* Loader

RDBMS: Oracle 12/11/10g, 9i, 8i, DB2 UDB, MS Access, SQL Server 2005/2000, Teradata

Languages: Java, Servlets, EJB, JSP, .NET, C#, ASP, T-SQL, Java Script, HTML, XML, SQL, PL/SQLCGI-PERL

PROFESSIONAL EXPERIENCE:

Confidential - Indianapolis, IN

Sr Cognos Developer

Responsibilities:

• Work on support issues, minor/ major enhancements, and project assignments.
• Create new cognos reports and or modifying existing reports and Cognos Framework Models,
• Validate the Data, perform Data Analysis and fix report issues.
• Developed Reports using Cognos 11.0.7 BI
• Directly interact with business users on one on one basis understand the requirements and create Cognos reports. Participate in Client Meetings/JAD sessions/User Acceptance Testing /Project management /effort estimation and Project Tracking
• Written SQL Server queries for reports development. Create test case documents and queries and review the data requirements in different environments.
• Worked on deals tenant’s platforms leasing and accounts related data and reports
• Moving the Data in between various environments, doing Data / Gap analysis and suggest best approaches to team in resolving the data issues
• Create Design documents, participate in UAT and KT sessions

Environment: Cognos Analytics 11.0.7, Agile Methodology, Cognos Motio, DB2, Toad, SQL Server Management studio 2014, PowerPoint, Confidential Excel, Info Sphere Datastage, Confidential Word, Power BI,Erwin, Cognos Framework Manager

Confidential, Tampa Florida

Senior Cognos Consultant

Responsibilities:

• Develop Cognos Framework Models, Validate the Data, perform Data Analysis
• Developed Reports using Cognos 11.0.7 BI
• Installed/ Administered, created Data sources and Maintained Security in Cognos Servers and Portals
• Directly interact with business users on one on one basis understand the requirements and create Cognos reports. Participate in Client Meetings/JAD sessions/User Acceptance Testing /Project management /effort estimation and Project Tracking
• Incident Management, Problem Management, Defect log Handling
• Worked on Account, Billing Unit, Premium Payment, Claims, Provider Payment, Benefits, Loss Ratio type of Insurance Data to create Cognos Framework models and reports
• Worked on full lifecycle SDLC phases, including planning and estimation
• Written SQL Server queries for reports development. Create test case documents and queries and review the data requirements in different environments.
• Moving the Data in between various environments, doing Data / Gap analysis and suggest best approaches to team in resolving the data issues
• Create Design documents, RRDs, Reverse Engineering documents, Data Lineage documents, Data Model documents, UAT and participate in the KT sessions

Environment: Cognos11.0.7, Agile Methodology, SQL Server Management studio 2014, PowerPoint, Confidential Excel, Confidential Word, Erwin, Cognos Framework Manager, Cognos Analytics

Confidential, Weston, Florida

Senior Cognos Consultant

Responsibilities:

• Develop and Reverse Engineer Dashboards, Visualizations and Reports using Cognos 11.0.7 BI, Cognos 10.2.2 BI, Tableau 10.3
• Created Data modules in Cognos 11. Installed/ Administered and Maintained Security in Cognos Servers and Portals
• Directly interact with business users on one on one basis understand the requirements and create Cognos reports. Participate in Client Meetings/JAD sessions/User Acceptance Testing /Project management /effort estimation and Project Tracking
• Incident Management, Problem Management, Defect log Handling
• Worked on Migration/Enhancement of existing OLTP ETL/Reports. Worked on Cognos Upgrade from 10 to 11.0.7. Integration of BI and ETLs and Front end. Configured Gateway and Dispatcher services
• Identify the Data Sources, Data Cleansing, Analytics on large datasets using SQL Queries
• Conduct business analysis, requirements gathering and develop new Supply Chain and financial daily consumption Reports in Cognos report studio, adhoc reports in Query studio
• Understand the Pharmacy Domain Manufacture of Drug/patients/referrals/orders/dispatch/Sales Analysis workflow working with Business to develop the SSIS ETL Jobs
• Develop Cognos Framework Model and Validate the Data, perform Data Analysis in the migrated environment
• Worked on Supply Chain, Pricing Modules, Sales and Financial data
• Fixed any Data issues by writing /validating using SQL Queries, worked with Cross functional teams on Daily basis to develop and resolve the data related issues
• Also fixed Reports/Dashboards display issues
• Worked on full lifecycle SDLC phases, including planning and estimation
• Written SQL Server queries for reports development. Create test case documents and queries, and review the data requirements in different environments.
• Worked on Data models, Data / Gap analysis in various environments and suggest best approaches to team in resolving the data issues
• Create Design documents, BRDs, Reverse Engineering documents, Data Lineage documents, Data Model documents, UAT and participate in the KT sessions

Environment: Cognos11.0.7, Cognos 10.2.2, Tableau 10.3, Agile Methodology, SQL Server, Cognos Data Manager, OLTP Databases, OLAP, LDAP, AD, SQL Server Management Studio 2012, Report Studio, Query Studio, Cube Designer 10.2.2, Confidential Excel, HP ALM, Power BI,JIRA, Visio, SSAS, SSIS 2012, PowerPoint, Erwin, Cognos Framework Manager, Transformer 10, workspace, Active Directory

Confidential, Deerfield, Illinois

Senior Cognos Consultant

Responsibilities:

• Conduct Business analysis, Requirements gathering to develop new Reports and Dashboard and create high level design documents and technical specifications.
• Used SQL queries for requirements, Data validations, reports development, testing of Cognos Reports
• Understand the Pharmacy Domain i.e. Specialty medicine manufacturing of Drug/ patients/ referrals /orders/dispatch workflow working with Business
• Logical and Physical data modeling, OLAP Data analysis and cube development with congas Dynamic cubes. Data Validation Analysis, Reverse engineer data sets, reports
• Develop Cognos Dashboards and Reports and Visualizations, Create Data Models for Reports using OLTP databases
• Incident Management, Problem Management, Defect log Handling. Install Cognos and Configure Gateway and Dispatcher services
• Worked on Cognos Upgrade from 8 to 10
• Worked on Cognos Application support and development
• Worked on Tableau reports development and Testing
• Deployment of Packages, Reports between various environments DEV/ UAT/PREPROD/PROD
• Design, develop complex reports, dashboards, and scorecards and schedule reports in IBM Cognos 10.2.2. used Java Scripts in Cognos reports
• Design and review Technical Design Documents and queries through onsite/offshore mail coordination.
• Participate in daily /weekly status calls and meetings to discuss the project issues and work with all the teams to close the issues.
• Written Oracle and SQL server SQL queries for reports. Reverse Engineer OLAP Cubes and Queries for migration of the code
• Used HPALM to log the defects and fix them as part of Quality Assurance
• Connect to Cloud and Big Data Environments to create Dashboards reports visualizations
• Performed analytics using Active reports, rave visualizations. worked in resolve data, system issues and performance issues

Environment: Cognos 10.2.2, Tableau 9.3 Desktop, Tableau Server, LDAP, AD, Big Data, Hive, HealthCare Payer Claims Environment, Specialty Pharmacy Reporting, Oracle, SQL server, Talend, Event studio, Agile Methodology, Oracle SQL Developer, Remedy Db, Metric Studio, SAP Hana, Business Objects Universe, DB2, Report Studio, Query Studio, Analysis studio, SAS

Confidential, Austin, Texas

Cognos Consultant

Responsibilities:

• Developed Dashboards Visualizations using Cognos, worked on Cognos Advanced and Workspace Advanced Business Insight to create Executive Dashboards and Active Reports.
• Upgraded/Migration environment from 8.2 to 10.2 and tested the reports.
• Worked on Life Cycle Manager in upgrading the Report Studio and Query Studio Reports.
• Connect to Cloud and Big Data Environments to create Dashboards reports visualizations
• Performed requirements gathering and developed new Reports and Dashboards.
• Written SQL for report development and testing. Worked with IBM Cognos support as part of logging bugs and enhancements.
• Created reporting template to be used by Report Studio developers. Created custom portlets and deployed them. Modified system configuration files and customized Cognos 10 portal and added enterprise logos.
• Worked on Cognos DQM model enhancements and changes to framework model.

Environment: Cognos10.2, Cognos Data Manager, Motio, SAPBO, SQL Server 2008, Salesforce, Cognos Tm1 10.2, Report Studio, DB2, SSRS, SSAS, SSIS, Linux, Cognos JavaScript

Confidential, Indianapolis, Indiana

Cognos Consultant

Responsibilities:

• Worked on Cognos Application support and development
• Performed source to target data mappings for the SSIS ETL and Cognos Reporting teams. Designed and managed physical and logical data models of enterprise data warehouses, data marts and operational data stores.
• Used SQL queries for reports development, validation and testing
• Involved in daily meetings and calls with various teams for the project development status and issues.
• Conducted performance tuning of the reports based on the report queries generated Confidential the database level.
• Analyzed and debugged the data issues with the SSIS/Informatica ETL jobs.
• Monitored data quality, resolving problem data issues with SSIS ETL jobs and ensuring timely updates.
• Improved cube build time and access time by consolidating data and incrementally updating the cube.
• Monitored SSIS /Informatica ETL jobs and packages. Installed and configured Cognos 10, Oracle and Apache on a distributed environment Administered the Reporting environment
• Scheduled and refreshed reports and Burst Reports according to user requirements in Cognos Connection and sent the reports through email feature.
• Worked on Motio Persona Installations and Configurations and CI deployments
• Worked with architecture and configuration options for Cognos Gateway, Dispatchers, Content Manager and Audit Stores.

Environment: Cognos 10.2, SQL Server 2008, Motio, Report Studio, Linux, Cognos JavaScript, Cognos SDK API, COGNOS 10.2 framework manager, DB2, COGNOS Data Manager Designer, Informatica, Query Studio, SSRS, SSIS, SSAS, Analysis Studio

Confidential, New York, New York

Cognos Consultant

Responsibilities:

• Created around 50 Cognos Dashboard Reports for the Vice President level managers to understand the system based on different KPIs for finance.
• Designed, developed and maintained relational data models, metadata models, reporting and metrics using Cognos 10.1.
• Worked on creating Cognos reports on HR and Payroll related data of Ultipro HCM. Conducted performance tuning and query optimization in SQL Server environment.
• Created data sources and deployed the contents from QA to Production environments.
• Created a JavaScript to execute a report with multiple parameters and to submit a job and pass parameters to the reports in the job using Cognos 10.
• Worked on migrating Crystal reports to Cognos
• Worked on Cognos Application support and development
• Deployed the Informatica/Cognos packages and reports from Development to QA and Prod
• Worked on architecture and configuration options for Cognos Gateway, Dispatchers, Content Manager and Audit Stores.

Environment: Cognos 10.1.1 (Report Studio, Query Studio, Analysis Studio), HCM Ultipro, HR and Payroll Data, Power Play Transformer, Cognos 10.1.1 Framework Manager, Cognos SDK 10.1.1, Unix, Cognos Data Manager, Informatica, Oracle

Confidential

Cognos Consultant

Responsibilities:

• Created Data Manager Catalogs, defined Source to Target mappings and accessed the Data using SQL.
• Worked closely with the administrator to modify the appearance of the Cognos portal 8.1.2 and Report viewer with Java scripting.
• Updated cubes using macros built with Cognos Script Editor.
• Coordinated with the database administrator in creating aggregate / summary tables.
• Ensured data accuracy and quality of the report result by running queries against the database. Created Stored procedures, views and triggers
• Performed all the tasks from deployment, installation, configuration, development and some administration.
• Created user accounts using Cognos Connection and then determined capabilities.

Environment: Cognos 8 (Framework Manager, Analysis Studio, Query Studio, Report Studio, Cognos Connection), Cognos Data Manager Cognos Series 7 Version 3 (Impromptu Administrator, Access Manager, Power Play Transformer for Windows, Cognos Tm 1 9.5, Power Play client for Windows, Cognos Script Editor, Scheduler), SQL Server 2008, SSIS, SSRS, Windows 2003 Server

Confidential

Cognos Consultant

Responsibilities:

• Ensured data accuracy and quality of the report result by running queries against the database.
• Created user accounts using Cognos Connection and then determined capabilities.
• Written SQL Queries for report development
• Maintained/updated report and framework documentation as needed.
• Helped users understand the uses of the Cognos BI tool and trained them to create their own day-to-day reports.
• Trained users on the framework front. Helped them manipulate relationships and create work-arounds in order to get their work done efficiently and effectively.

Environment: Cognos 8 (Framework Manager, Analysis Studio, Query Studio, Report Studio, Cognos Connection), Cognos Data Manager Cognos Series 7, SQL server, Power Play Transformer for Windows