PROFESSIONAL SUMMARY:

• Certified IBM Cognos (Report Designer & Metadata Models) Consultant with 10 years of IT experience in Analysis, Design, Development, Testing and production support with proficiency in Data warehousing environment with Business Intelligence systems (Cognos, Tableau, Power BI) and worked with multiple domains like Banking, Healthcare/Insurance, Pharma, Energy & Utility, Automotive Fleet, Manufacturing & Retailing, and Gas & Oil industries.
• Extensive experience in Business Intelligence systems with over 9 years of experience in Cognos BI suite and 2+ years of experience in Tableau and strong knowledge on other BI tools like Power BI.
• Certified in IBM Cognos 10 Report Designer and extensive experience in Cognos 10.x/8.x BI Suite (Report Studio, Analysis Studio, Query Studio, Cognos Connection, Cognos Workspace, Cognos Workspace Advanced, and Framework Manager), OLAP Cube development using Cognos Power play and Transformer, and implementing security using Cognos Access Manager.
• Certified in IBM Cognos 10 Metadata Models and expertise in developing Metadata Models using Cognos Framework Manager and applied industries best practices and corporate enterprise modeling standards.
• Proficient in implementing DMR (Dimensionally Modelled Relational Data) data using Cognos Framework Manager and excellent working knowledge and hands on experience in creating OLAP cubes.
• Strong experience on creating complex reports and Dashboards with Report Studio to customize the functionality by using Filters, Prompts, Master Detail Relational ships, Drill through definitions, report bursting and Conditional Formatting.
• Worked with business users on assisting Query Studio& Workspace Advanced and involved in multiple pilot projects in assisting business users.
• Experience in migration, deployment and job schedules of Cognos reports through Cognos connection and creation of trigger based reports job schedules through Control - M and having excellent knowledge on Cognos administration and security implementation like creating user roles and groups.
• Experience with Tableau Desktop and created multiple Tableau visualizations, Worksheets and Dashboards.
• Comprehensive involvement in all phases of application lifecycle development including analysis, design, testing, debugging, performance tuning and User Acceptance Testing (UAT) with QA/UAT teams and experience with both Agile and linear SDLC methodologies.
• Excellent knowledge of Data modeling concepts (RDBMS, Data warehousing, Star Schema, Snowflake Schema and Slowly Changing Dimensions) and ETL concepts.
• Expertise in understanding the Business needs and Customer requirements by participating in the Design Phase, business requirement gatherings and creating functional and technical specification documentation for report development.
• Working experience in multiple databases including Teradata, Oracle, MS SQL Server, Greenplum and DB2 and experience in writing SQL, PL/SQL queries for report validation phase.
• Strong troubleshooting and production support skills and coordination and interaction abilities with end users.
• Self-Motivated, energetic, self-starter with excellent analytical, organizational, communication, verbal and presentation skills.

TECHNICAL SKILLS:

Cognos 10.x/8.x: Report Studio Query Studio Analysis Studio Event Studio Workspace Advanced Business Insight Cognos Connection

Other BI tools: Tableau 8 Desktop Power BI

Data Modeling: Framework Manager Power Play Transformer Star/Snowflake Schema Teradata MS SQL Server Oracle DB2 MS Access Greenplum SQL PL/SQL XML HTML JavaScript Teradata SQL Assistant Oracle SQL Developer TOAD Aginity HP ALM ITSM MotioCI MotioPI Passport (Legal) Infor M3 MS Office Suite MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Senior Cognos Developer

• Worked with business users directly in creating customized reports against Oracle & DB2 data warehouses using Cognos BI tool.
• Worked closely with the business users and created report specification documents.
• Analyzed the business requirements and converted them to technical specification documents.
• Attended Cognos 11 training sessions and created some POC reports.
• Developed Cognos Framework Manager Package for relational models and published them to Cognos connections.
• Created industry standard 3 tier model and implemented the best practices.
• Created both stand alone and embedded filters in the packages to make the report development process much faster.
• Modified and maintained the existing models using Framework Manager.
• Developed complex customized List and Crosstab Cognos reports.
• Implemented multiple cascading prompts as per the user requirements.
• Created expand and collapse List report using JavaScript.
• Used layout component references, conditional formatting using variables, Cascading prompts and created multiple queries, calculated fields, parameters etc.
• Worked on performance tuning and issues of existing reports.
• Used database tools such as Oracle SQL Developer, Toad as needed and created test scripts and created unit test SQL’s and validated the data.

Environment: Cognos 10.2.2 (Report Studio, Framework Manager), Cognos 11.0.2, Oracle, DB2, Oracle SQL Developer, HP ALM.

Confidential, Columbus, OH

Senior BI Application Developer

• I’ve involved in multiple projects under multiple line of businesses and delivered many customized reports & dashboards to the users using Cognos and Tableau BI tools against Integrated Consumer Data Warehouse.
• Extensively interacted with Business Users to understand their reporting needs and created Business Requirements Documents/CapMats, conducted reviews of the requirements with Business Users and worked with the other team members to analyze the data coming from multiple source systems and build the reporting solutions as per requirements.
• Analyzed the business needs and created complex Cognos reports and created visualizations and dashboards using Tableau for multiple LOB’s such as Business Banking, Consumer Banking, and CWM.
• Interacted with business user group and provided Technical Assistance for business driven sustainable reports using both Cognos and Tableau reporting tools.
• Participated in data modeling, business process analysis and developed Cognos Framework Manager Packages and published to use for report development.
• Created many financial reports such as Delinquency Trends, Credit Loss Trends, C&C and NPL, Scored Strategies, Portfolio reports (Scored & Graded), Credit KRI, National and Regional trends, Weekly and Monthly reports etc. against Integrated Consumer Data Warehouse.
• Developed Complex Reports with multiple graphs and crosstabs, List reports and customized the reports output with multiple prompt pages.
• Applied multiple Cognos report functionalities such as Master Detail relationships, Report bursting, Drill up/down reports, Cascading prompts, Conditional formatting etc.
• Modified the existing report template and used Layout component reference objects to use across multiple LOB report development and documented.
• Developed Tableau Dashboards and Worksheets using calculated fields, Parameters, Quick Filters, Groups, Sets, Bins and custom hierarchies.
• Developed Tableau data visualization using Bar charts, Line charts, Heat maps, Scatter Plots, Geo Maps, Crosstabs, Bubble charts, Area charts, Donut charts etc.
• Mastered in different formatting techniques in Tableau using Annotation, Mark labels, Tool tips etc.
• Applied different Actions (filter, highlight & URL) in a Tableau Dashboard for user customizations.
• Connected to Tableau server to publish dashboards to a central location for portal integration.
• Involved in Scheduling and distributing reports through Schedule Management in Cognos Connection and helped in setting up the jobs in Control-M.
• Helped admin team in migrating the reports to multiple environments.
• Created report wireframes/prototypes using data generator tool, Unit test documents, Report design and FM Model design documents, Run books for report auditing purpose.
• Assisted QA team in creating report test cases and extensively wrote SQL queries for report validation.
• Monitored assigned reports delivery from the design phase to delivery phase using HP ALM tool.
• Extensively involved in report performance tuning and fixes deployment issues.

Environment: Cognos 10.2.1 (Framework Manager, Report Studio, Query Studio, Workspace Advanced), Tableau 8.2.7, Teradata, Teradata SQL Assistant, Informatica, HP ALM, ITSM, Contorl-M, Data Generator tool.

Confidential, Tampa, FL

Senior Cognos Consultant

• I’ve involved in multiple projects which includes building Framework Manager model, business requirement documents for report development, modifying existing reports based on intake requests and performance tuning.
• Analyzing the specifications provided by the business users and Developing specification documents for reports as per client requirements.
• Created Technical Specification Documentation for the reports.
• Worked on Remediation ICD9 Reports in which I’ve modified the reports to include the future Diagnosis version ICD10 along with the ICD9 and other conditional formatting as per the new business requirement.
• Modified the existing Relational Model for Memberships and Claims in Framework Manager as part of the report remediation.
• Developed reports for Memberships and Claims, which includes Lists, Complex Crosstabs, Charts, and Drill through Reports, Conditional Blocks, Master-detail & conditional formatting reports using Report Studio.
• Worked in an Agile environment on a project called HIX and developed the Framework Manager model to build the reports.
• Created stand-alone filters and embedded filters while creating a model by using Cognos Framework Manager.
• Created Dashboards for Cognos portal for everyday access and easy identify of history and projections
• Standardized prompt pages for consistent user experience and to let users choose between different filters.
• Used PL/SQL Developer for writing SQLs against Oracle, Aginity tool to connect to the Greenplum database for data validation and testing.
• Tested and validated the Report output against database to measure performance of reports.
• Created Unit Test Plan documents and Tested result documents.
• Used Service Manager to close the tickets that were opened by the users and other teams.
• Involved in scheduling and bursting of reports and actively involved in report testing and production support.

Environment: Cognos 10.2 (Report Studio, Query Studio, Analysis Studio, Workspace Advanced), Framework Manager, MS SQL Server 2008, PL/SQL Developer, Aginity, Oracle 11g and Greenplum.

Confidential, Houston, TX

Senior BI Consultant

• Worked on a Passport Report development project where I developed complex reports and modified existing reports for a legal department.
• Worked directly with users for business requirements and created functional and technical documents for report development.
• Primarily worked in a Cognos integration project with client Legal department for report development.
• Also worked with Finance department and developed sample reports using Cognos 10.1 Report Studio.
• Created and modified List & Crosstab reports for client Matter management system.
• Developed Prompt Pages, Cascaded Prompts and also worked on the customization of prompt parameters.
• Developed multi query and multi prompt reports using conditional blocks and various filters.
• Implemented advanced features such as Master detail relationship, Conditional formatting, Page set, report bursting using Cognos Report Studio.
• Created Drill-up/down and Drill through reports for detail reporting.
• Modified the existing Framework Manager Model for report development.
• Performed Cognos administration and security tasks.

Environment: Cognos 10 (Report Studio, Query Studio, Framework Manager, Cognos Connection) MS SQL Server, T-SQL, Passport and Windows 7.

Confidential, Fairhaven, MA

Senior Cognos Developer

• Actively involved in AGS project where I developed many reports for multiple divisions of the client. Developed reports for different functional areas such as Finance, Sales, Marketing, Distribution, etc.
• Worked closely with different business teams to gather requirements, prepared functional and technical documents and UAT process.
• Created List, Crosstab, and Chart reports using Report Studio to support Finance, Sales and Marketing functional areas.
• Developed complex reports using different features like slice & dice, Drill capabilities, queries, Master detail and Multilingual reports.
• Created query prompts, calculations, conditions and Filters.
• Implemented report bursting to distribute reports effectively.
• Involved in scheduling Report Studio and sending reports via email to several business users.
• Created ad-hoc reports like Grouped List reports and Cross-Tab reports using Query Studio.
• Also created documentation for all the processes involved like applying security for reports, deployment, portal customization etc.
• Created multiple Layout Component Objects and incorporated into the reports.
• Created jobs to schedule reports in Cognos connection.
• Experience in writing HTML/Java script in Cognos Report Studio reports as per the requirements.
• Added Data security, Object and Row level Security according to the requirements.
• Created database layer, physical layer and presentation layer, defining appropriate relationships between the tables.

Environment: Cognos 10/8 (Report Studio, Query Studio, Framework Manager, Cognos Connection) MS SQL Server, Oracle, T-SQL, PL/SQL, Infor M3, Windows 7.

Confidential, Cincinnati, OH

Senior Cognos Report Developer

• Extensively worked on existing report errors and performance tuning, coordinated with web development team for portal integration, created customized Cognos reports along with the functional and technical specification docs.
• Involved in mostly troubleshooting existing issues related to different types of reports such as Fleet Expenses, Orders, Contracts, and Inventory.
• Involved in creating new reports for customers to analyze their business to increase the profits.
• Analyzed and reviewed business requirements and technical specification documents for report development.
• Extensively involved in troubleshooting of complex reports.
• Modified the existing report designing according to the new business requirements.
• Created List, Crosstab and various graphical presentation of reports.
• Incorporated different reporting functionalities such as Master Detail, Cascading prompts, Drill down and Drill-Through into multiple reports.
• Created multiple prompt pages using Java scripts to validate the data on each report for narrowing the report output.
• Extensively implemented complex reporting functionalities using Conditional formatting, Conditional blocks using multiple variables and parameters.
• Created multiple report templates which help developers to create new reports according to the company standards and created ‘Read Me’ documents.
• Created multiple UTP documents for report testing.
• Involved in performance tuning of complex reports and analyzed Cognos SQL with native SQL.
• Participated in building customer portal site with web development team.
• Worked on third party tool Motio to control different versions of the Cognos reports and used to migrate the reports to different environments.
• Involved in automated testing of Cognos reports using Motio.

Environment: Cognos 10 (Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos Power Play Transformer, Cognos Connection, Cognos 10 Go Office) Oracle SQL Developer, TOAD, MS SQL Server, PL/SQL, Oracle 10/11g, MotioCI, MotioPI and Windows 7/2003 server.

Confidential, Corning, NY

Cognos Developer

• Involved in multiple projects largely dealing with creating and modifying reports for Inventory, Shipment, Sales, Client, Products, Business Units, Customers and Order Details. The project also involved migration of Cognos applications from C 7 to C 8 version.
• Analyzed Business requirements from the analysts.
• Created and modified various List Reports, Grouped Reports, Crosstab Reports and Drill-Through Reports.
• Developed reports using various functionalities like Master Detail, Conditional Formatting, Conditional Blocks and Multiple Prompts.
• Working closely with ETL developers in building data marts as per the requirements.
• Created Global Graphical reports to view and analyze company’s corporate performance.
• Implemented various Prompts, Parameters, Filters, calculated measures, aggregations, conditions and created reports using sub-queries and multiple queries.
• Testing and improving report performance, performance tuning of complex reports on report level.
• Customized Cognos Connection with appropriate reports and security measures.
• Developed relational and dimensional models in Framework Manager by defining the relationships between query subjects maintaining the data integrity.
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports.
• Involved in Migration of Cognos BI applications from version 7.x to 8.4.
• Migrated Cubes from Cognos 7.4 version to Cognos 8.4.
• Resolved the issues occurred when migration of reports from previous versions to the Cognos 8.4.
• Used Framework Manager to build Models, Packages and publish packages to the Cognos Server.
• Scheduled Reports and Power Play Cubes to run on Daily, Weekly and Monthly basis.
• Handled Security and Administration in Cognos connection portal.

Environment: Cognos 8.4.1 (Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos Power Play Transformer, Cognos Connection), Cognos Impromptu 7.4, Oracle SQL Developer, MS SQL Server, SSIS, PL/SQL, Oracle 10g and Windows NT/4.0.

Confidential, Dorchester, MA

Cognos Report Developer

• Worked in a project called PCAS is a transaction system which provides all the Confidential card related information data. The project is to use the data for the development and marketing purposes.
• Developed reports to keep track of performance of different credit cards offered by the bank.
• Interacted with business users to gather business requirements and designed functional and technical documentation.
• Designed and developed the Framework Manager Models and Published into server for further use in the report authoring process.
• Built models containing namespaces, level hierarchies, query subjects, query items and members from scratch as well as from imported metadata.
• Created Stored Procedure query subject with a prompt value into the model while creating a package in Framework Manager.
• Developed Multidimensional Models (Cubes) using Cognos Power Play Transformer.
• Designed & developed reports using Report Studio, created ad-hoc reports using Query Studio and helped business user in creating Analysis reports using Analysis Studio.
• Developed Simple List, Nested Crosstab, Chart, and Drill through reports.
• Created complex reports with advanced features such as Master detailed sections, Conditional formatting, Page Set, bursting, Render & Boolean variables using Report Studio.
• Used Drill-up/down and Drill through functionalities to give a detailed and analytical report.
• Applied Cascading Prompts functionality in runtime for narrowing the final results for better understanding of the requirement.
• Created Dashboard Reports using Report Studio MDX functions and added to the portal page.
• Scheduled and distributed reports to the end users by schedule management in Cognos Connection.
• Developed Stored Procedures and Database Triggers in PL/SQL.
• Generated SQL/MDX & analyzed Cognos SQL, Native SQL to troubleshoot the report issues.

Environment: Cognos 8.4 (Report Studio, Query Studio, Analysis Studio, Metric Studio, Framework Manager, Power Play Transformer) MS SQL Server 2008, SSIS, Oracle 9i, PL/SQL, Windows XP.

Confidential, Pittsburgh, PA

Cognos Report Developer

• The project involved group of professionals in the IT department need to reserve the test sites for testing the prototypes and should be able to log the test results in a centralized location. The test results will be analyzed using the existing data in the legacy systems and reports are generated by using the Cognos Report Studio.
• Constantly interacted with the business users, attended several meetings in understanding the requirements better for development of application.
• Designed Metadata Models using Framework manager and published packages in to the Cognos Content Store.
• Analyzed existing Reports, created new and enhanced .cpf files for Framework Manager to accommodate future growth in reporting requirements.
• Performed interactive and batch operations and also involved in developing custom portal tabs.
• Created standard Calculations, Filters, Data Source Query subjects, Model Query subjects in Framework Manager as per the Business Requirements, which minimize the report complexity.
• Generated OLAP Cubes in Cognos Transformer and analyzed the data using Cognos Power Play.
• Developed complex reports using Cognos Report Studio.
• Created Query calculations, Layout calculations, Filters and Prompts for usage in various reports.
• Generated multi object reports such as Lists, Crosstabs, Charts, Images and HTML applications using Report Studio and ad-hoc report using Query Studio.
• Extensively worked with different kind of prompts like Select and Search Prompt, Cascading Prompt, Date Prompt and Values Prompt.
• Created Templates, Dashboards, standard reports, and ad-hoc reports using Query Studio and Report Studio.
• Created Master Detail Reports, Drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
• Provided solutions and implemented efficient ways to improve the performance of the reports.

Environment: Cognos 8.2 (Report Studio, Query Studio, Analysis Studio, Framework Manager, Power Play Transformer) MS SQL Server 2005, T-SQL, Informatica Power Center, Windows XP.

Confidential, Bethesda, MD

Cognos Developer

• The project designed to replace the existing MAQ’s (Marriott Automated Query) which were stored in Oracle Database into Cognos Reports using Cognos 8 BI Suite.
• Analyzed Business System requirements and prepared the documentation for the Project Plan and the Scope of the Project.
• Developed Several Reports using Report Studio, Query Studio and Analysis Studio.
• Created complex reports in Report Studio such as list reports, crosstab reports.
• Created various reports using Cognos functionalities like Sub-Queries, Slice and Dice, Drill Down, Functions, Master Detail.
• Created reports in Report Studio using Prompts, Filters, Calculations, Summaries, Functions and Conditional formatting.
• Customized reports by applying Sections, converted a List report to a Crosstab report by using pivot function, and reused the objects within the same or another report to save the time.
• Developed complex reports having many Calculations, Variables, Prompts etc. in Report Studio.
• Scheduled the reports in Cognos Connection and distributed them via mail.
• Responsible for creating test plan documents and documented the test results.
• Co-facilitated client workshops and training, typically small to medium group of clients.
• Involved in the performance tuning of SQL queries.
• Involved in investigating, modifying code modifying using Oracle PL/SQL and code review.

Environment: Cognos 8.2 (Report Studio, Query Studio, Analysis Studio, Framework Manager), Oracle 8i, PL/SQL, Windows XP.

Confidential

Report writer

• As a Report writer, worked with Clinical and IT team in CDMS (Clinical Data Management System). This project keeps track of the clinical trials conducted for the drugs to analyze the performance.
• Analyzing the specifications provided by the client and developed the specification document for the reports as per the client requirements.
• Developed professional reports in Report Studio and ad hoc reports in Query Studio.
• Created list reports, Crosstab reports, chart reports and reports with features like conditional formatting, Page break, Master Detail, drill through, drill up, drill down and have extensively used the other features in Cognos 8.
• Generated customized reports by using Filters, Prompts, Calculations and Functions.
• Created standard ad-hoc reports using Cognos Query studio.
• Tested the Joins, inbuilt filters and calculations are working correctly and documented all of the work for submitting it to the users for verification.
• Created some complex reports using master-detail relationship.
• Worked with system analyst to understand the flow of data and developed Framework Manager Models.

Environment: Cognos 8.2 (Report Studio, Query Studio, Analysis Studio), DB2 and Windows 2003.