SUMMARY:

• Over Seven years of experience in Business Intelligence (Cognos) using wide range of tools.
• Expertise in Cognos 10.x/8.x BI suite, (Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection, Cognos Configuration), Framework Manager, PowerPlay Transformer, PowerPlay client.
• Good experience in reviewing Business Requirement Specifications, Software Requirement Specifications, unit test cases and system test cases.
• Experience in working in all the phases of Software Development Life Cycle (SDLC). Great skills of capturing data requirements through user interviews, JAD sessions, interviews etc.
• Experience in developing various reports like List reports, Crosstab reports, Charts, Dash Boards and Score cards.
• Experience in data stage and informatica.
• Experience in reports such as Management, Accounting and Sales Target, inventory, Finance, Tracking reports were developed for better business continuity.
• Adept at developing Cognos Drill through, multipage Reports with filters, conditional formats and prompts using prompt manager.
• Good experience in different databases like Oracle 11g/10g/9i, MS - Access, MS-SQL, Server 2005/2008/2012.
• Involved in entire development lifecycle process of data warehouse applications.
• Involved in modeling the data, data analysis, ETL development, and performance tuning of SQL scripts.
• Good knowledge of SQL, PL-SQL, QuickBooks Microsoft Suite Etc.
• Great understanding of ER and Dimensional modeling practices including Star schema, Snow Flake schema, Slowly Changing Dimesnions, Late Arriving Facts, conformed dimensions. In depth understanding of both Ralph Kimball and Bill Inmon schools of thought.
• Experience with creating Multi-dimensional Cubes for corporate data using PowerPlay Transformer.
• Developed PowerPlay Reports and published into the web for end users using Upfront.
• Experienced in assisting users in troubleshooting their reports, and overall concepts of Business Intelligence.
• Excellent problem solving and analytical skills.

TECHNICAL SKILLS:

Business Intelligence Tools: Cognos 8 MR2 (Report Studio, Query Studio, Event Studio, Metric Studio), Cognos PowerPlay, Power Play Transformer, Cognos Upfront, Power Play Reports, Cognos Query

Databases: Oracle 11g/10g/ 9i, SQL Server 2000/2005,Teradata 12, MS Access

Languages: SQL, PL SQL, C, C++, MATLAB

OS: UNIX, Linux, Windows, 95/98/2000/NTP/XP/2007

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Cognos BI Developer

Responsibilities:

• Created various types of Complex Reports based on user requirements.
• Developed all type of financial reports with conditional formatting and provided different types of Prompts for user selection.
• Generated various types of reports such as List, Crosstab and Chart using cognos 10.2.
• Involved in all phases of project development and testing and also provided the production support for the existing reports.
• Developed and published packages in Framework Manager, connected and tested the data source, created database layer and presentation layer, defined appropriate relationships between query subjects.
• Migrated reports from SSRS to Cognos BI environment.
• Involved in Creating Report specification for all Reports.
• Gathered all business requirement to solve a problem or issues and achieve the goal.
• Provided daily, weekly and monthly support to the business users for their reporting needs.
• Created Drill-through for detail reports.
• Development of filters, calculations, prompts, conditions, and created various reports, using Reports Studio.
• Worked on different user issues on Report studio and Analysis Studio and helped them in understanding the tools. worked with ETL team to define and understand the data stage.
• Using SQL server 2012 to write queries to validate data in Cognos reports vs Source Tables in database.
• By using Dev Track and Dev Test document all the phases of the project.
• Provided daily, weekly and monthly support to the business users for their reporting needs.

Environment: Cognos 10.2.2 (Cognos Connection, Cognos Administration Security for User Groups, Report Studio, Query Studio, Analysis Studio), SQL Server 2012.

Confidential

Cognos BI Developer

Responsibilities:

• Involved in creating complex reports with Provider, Recipient & Claim subject area.
• Migrate BO (Business Object) reports into Cognos BI environment.
• Created drill-through reports for detail reports.
• Generated Various Reports using Cognos 10.2 (List, Crosstab, Chart, Repeater)
• Involved with the end user to understand the Business Requirement.
• Created report Specifications for the GSD (General System Design), DSD (Detail System Design).
• Created Dashboards for a better understanding of the business performance metrics.
• Involved in Data profiling with the ETL team to assist them to fix the data anomalies to improve the Data Quality.
• Provided day-to-day support for all COGNOS Report studio and Query Studio.
• Communicate the report development progress and issues to management and team members.
• Involved in various trainings (Cognos Report Studio, Cognos Query Studio, Teradata SQL Assistant), to assist user to the new Data Warehouse Environment.

Environment: Cognos 10.2 (Framework Manager, Report Studio, Query Studio, Teradata 14.0) and Windows Server 2008.

Confidential, Portland, OR

Cognos Consultant

Responsibilities:

• Developed List, Crosstab and Dash Board reports in Cognos 8.4
• Involved in converting the functional specifications to technical documents.
• Involved in the development of Month end reports
• Worked with KPI to measure success at reaching targets.
• Supporting the business users with their adhoc requests and delivering them on timely basis
• Activating and deactivating filters according to the prompt selection
• Worked on complex drill through reports.
• Involved in building the reports with conditional formatting and conditional blocking for different kinds of business requirements
• Worked with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Responsible for the delivery of solution-oriented complex reports using Cognos 8.4.
• Development of ad-hoc reporting interfaces using Cognos Query Studio.
• Published Cubes and Reports to Upfront through PowerPlay Enterprise Server Administration and integrated access to information using Cognos Connection.
• Used Transformer with a variety of sources and combines them into Multi-Dimensional Cubes.

Environment: Cognos 8.4/10 (Cognos Connection, Cognos Administration Security for User Groups, Report Studio, Query Studio, Analysis Studio), Oracle 11g, SQL Developer

Confidential, St Cloud, MN

Cognos Consultant

Responsibilities:

• Developed List, Crosstab and Dash Board reports using Cognos.
• Interacting with Business Users for gathering Business Requirements to develop the report mockups.
• Imported Meta data from different data sources, Developed Framework Manager Model to meet reporting requirements.
• Created database layer and business layer, defining appropriate relationship between query subjects based on the user requirements.
• Customize the Cognos connection portal using existing port lets and customized tabs.
• Developed Accounting, Finance, and Sales Target Tracking reports
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query reports, Burst Reports against database.
• Creating cross-tab reports and chart reports using multiple queries and drill down capabilities in a single report to meet the business needs.
• Built Power Play Reports in Report Studio by replicating the power play functionality in Report Studio using dynamic Measure selection, Dynamic Sorting, ranking.
• Added Package level security to the packages and Object level security to the Query Subjects.
• Having good experience on Portal Administration in Cognos Connection.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Developed and published packages in Framework Manager, connected and tested the data source, created database layer and presentation layer, defined appropriate relationships between query subjects.
• Created Model Filters, Query filters, and User access filters in Framework Manager.
• Developed Framework Manager Model to meet reporting requirements.
• Worked extensively on report studio to create list reports, multi prompts and crosstab reports based on the user specifications.
• Created transformer models and built power cubes using PPT (Power play Transformer) and published them onto Cognos Server.
• Maintained different levels of cube security.
• Performed multidimensional analysis of the cubes created.
• Designed and developed time-based partitioned cubes using IQD data sources and applied security.
• Worked on different levels of security and even with the permissions of various users and user classes.

Environment: Cognos /8.4 (Cognos Connection, Cognos Administration Security for User Groups, Framework Manager, Report Studio, Query Studio, Analysis Studio), Oracle 11g, SQL Developer

Confidential, Santamonica, CA

Cognos Reports Developer

Responsibilities:

• Gathered the requirements from Business Users and created the reports based on those requirements in Analysis Studio as well as in Report Studio.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Created burst table in the database according to the market and bursted the reports.
• Involved in peer review process to review the reports created by different peer developers.
• Worked closely with Business analysts and Data Warehouse team to design the best BI models for reporting and analysis.
• Worked on security of the reports according to the user groups
• Created Adhoc reports of OFF Teradata Tables for satisfying end user’s needs
• Migrated Reports from Development to Test and Test to Production

Environment: Cognos 8.3, Framework Manager, Report Studio, Query Studio, Analysis Studio, Toad, Event Studio, Teradata 12, SQL Assistant, .