SUMMARY

• Over 8 years of experience in IT Industry with experience in BI data warehouse reporting, data analysis following SDLC methodology.
• 7 years of in - depth experience with Data warehouse and Business Intelligence tools like Cognos10, 8 with Oracle, DB2 and SQL Server Databases.
• Proficient with Cognos 10,8 Framework Manager creating and publishing packages, Metadata Modeling and creating Dimensionally modeled Relational model (DMR)
• Experienced in Cognos 10, Query Studio, Report Studio, Cognos 8 Report Net 1.0/1.1 creating reports including Drill through, Master Detail, Cross tabs, charts
• Experience working with Cognos 10 Analysis Studio, Event Studio, Business Insight, Business Insight Advanced
• Knowledge in creating Multi-dimensional Power play cubes using Power Play Transformer
• Knowledge in Publishing cubes and OLAP reports to Upfront using Power play Enterprise Server (PPES)
• Extensive experience in SQL in multiple database platforms such as Oracle, DB2, SQL Server.
• Well versed in Data warehouse concepts like Snow flake Schema, Star Schema and involved in Data Modeling Using Erwin Modeling Tool.
• Experience with Dimensional modeling including facts and dimensions, star and snowflake schemas and OLAP tools and techniques
• Experienced in creating, enhancing and maintaining Framework Manager Models to support business requirements.
• Setup security for role based access to various reports and dashboards in Cognos
• Scheduled reports using Cognos Connection for automatic delivery of reports to business users
• Experienced in training the users making then familiar with the Adhoc Reporting
• Experienced in Data analysis and data mapping experience between multiple systems
• Developed Queries and used in developing Crystal reports
• Experience working on complex reporting and dashboard work in Retail and Healthcare industries
• Team player and experienced in work with business users in understanding their requirements and delivering as per their needs

TECHNICAL SKILLS

Cognos 8 & 10 tools: Report studio, Query Studio, Analysis studio, Business Insight, Business Insight Advanced, Report Net Cognos Connection

Databases: Oracle 9i/10g/11g, DB2 6.0/, SQL Plus, Toad for Data Analysts, MS SQL Server, MS Access, MySQL

Scripting: SQL, T-SQL, PL/SQL

Operating Systems: Red Hat Linux, IBM AIX, Windows NT, 2000, 2003

Microsoft Tools: MS Office 2007/2010, MS Project, MS Outlook

Data Modeling & Tool: Dimensional Data Modeling, Star Schema Modeling, Snow- Flake Modeling, Fact and Dimension Tables, Physical And Logical Data Modeling, Framework Manager, OLAP, MS Visio, ERWIN

PROFESSIONAL EXPERIENCE

Cognos Consultant

Confidential, Pittsburgh, PA

Responsibilities:

• Worked with business users in understanding, analyzing the business requirements to develop analytical reports and integrating data from multiple systems
• Created DMR Meta data models in Framework Manager and built packages with query model objects for building reports and dashboards. The objects created were from multiple data sources.
• Created complex reports analyzing the order data, delivery scheduling with optimized distribution routes and cost of ad-hoc route changes
• Created dashboards using the Business Insight showing the daily orders, cost of distribution and cost of warehousing perishable goods.
• Created dashboards analyzing the order to cash process for showing the order, fulfillment, payment and account receivables.
• Created custom prompted reports in Report Studio and bursting reports to different user groups.
• Implemented Drill through, Conditional formatting for customizing the reports.
• Scheduled reports in Cognos Connection based on the reports to run Daily, Weekly or Monthly basis.
• Created trend and Ranking reports which help in monitoring the performance of the individual vendors and suppliers aiding critical business assessments.
• Created ad-hoc reports using prompts, cascaded input prompts and parameters.
• Deployed reports from development to QA and then Production servers.

Environment: Cognos 10.1 (Query Studio, Report Studio, Analysis Studio, Event Studio Business Insight, Business Insight Advanced ) Oracle 10g, TOAD10.0, Redhat Linux 6.0

Cognos Consultant

Confidential, Vernon Hills, IL

Responsibilities:

• Worked with business users in understanding, analyzing the business requirements to develop a true analytical reports and while drawing the data from multiple systems
• Created DMR meta data models in Framework Manager and built packages with query model objects for building reports and dashboards
• Created complex reports analyzing the claims billed to payer by service code and payment, denials ratio by service code
• Built a dashboards for Account receivables with a nightly update, also showing the drill down on the details of individual transactions\
• Built a dashboard on claim billing (837), acceptance (277CA), denial and payments (835)
• Validated multiple FM packages (Accounts Receivable, Drug rebate, Claims, Prior auth-Pro cert, Reference & Participant packages) & ETL Business rules (Age calculation, status code generation, Claim Type code etc.)
• Developed the List Reports, Charts, Drill Through Reports, Master Detail Reports Using Report Studio and Query Studio.
• Scheduled reports using Cognos Connection for automatic delivery of reports to various business users
• Created trend and Ranking reports to help in monitoring the usage of dialysis consumables.

Environment: Cognos 8.4.3 (Report Studio, Analysis Studio, Query Studio, Event Studio, and Cognos Administration), Power play Transformer 8.3, Oracle 10g.,windows XP, TSQL, PL/SQL.

Cognos Consultant

Confidential, Kansas, MO

Responsibilities:

• Worked with business users in understanding, analyzing the business requirements to develop a true analytical reports and while drawing the data from multiple systems
• Created DMR meta data models in Framework Manager and built packages with query model objects for building reports and dashboards
• Built OLAP Cubes for creating a multi-dimensional data model for transportation routes, pricing, products and modes of transportation to facilitate data analysis for multiple combinations of the transportation with a drilldown, slide & dice and roll up of the data
• Published cubes and OLAP reports to Upfront using Power play Enterprise Server (PPES)
• Created complex reports with summarization using the cubes to analyze the cost and margins on load factor for a route
• Built dashboards showing a cost breakdown and sales to analyze the profitability of long haul routes.
• Setup security for role based access to various reports and dashboards
• Scheduled reports using Cognos Scheduler for automatic delivery of reports to various business users

Environment: Cognos 8.4 BI Report Studio, Cognos 8.4 BI Query Studio, Cognos 8.4 BI Suite, Cognos Connection, Cognos 8.4 BI Framework Manager, Cognos Scheduler, Access Manager, Configuration Manager, Windows XP, MS SQLServer 2005/2008

Cognos Consultant

Confidential, Oakland, CA

Responsibilities:

• Worked with business users in understanding, analyzing the signed-off business requirements to develop a comprehensive data ware house to collect the provider services and claim data for further analysis
• Created DMR meta data models in Framework Manager and built packages with query model objects for building reports and dashboards
• Created complex reports to analyze the timely and untimely provider claim submissions and appeals ratio for un-timely submissions, and corresponding payments
• Created analysis List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports reports for analyzing the cost of services by region by provider and corresponding to similar services provided in Kaiser’s own medical centers
• Created executive dashboards showing the claims aging trending and reasons to analyze claims processing and payment times along with a Drill through capability
• Built multiple compliance encounter reports for state Medicare and Medicaid filings and analysis of compliance standards for delegated providers.
• Helped users in development of ad-hoc reports using Query Studio.
• Implemented Security and Cognos Connection extensively for organizing, security, scheduling and distributing reports.

Environment: Oracle 10g, Cognos 8.2, Data Manager, Power Play Transformer 7.3, Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection

Cognos Consultant

Confidential, NY, NY

Responsibilities:

• Involved in business gathering and analyzing the data received from multiple systems and work with business in finalizing the requirements for a sign-off process.
• Worked with data architects in creating a data models and building data warehouse to house the credit card transactions
• Did meta-modeling (DMR) and developed multiple packages in Framework model to support the creation of reports and dashboards.
• Created cross tab and master detail reports for analyzing credit card transactions by consumer age group.
• Created ad-hoc queries for business users to validate report results
• Built complex analysis reports for payment to debt ratio of a section of credit card consumers and risk analysis
• Built complex dashboards showing the card usage trend by consumer age group and by month to analyze buying pattern.

Environment: Cognos 8 BI (Framework Manager, Report Studio, Query Studio, Analysis studio, Event Studio, Cognos Connection), Data stage, Oracle 9i, Windows

Cognos Developer

Confidential, Beaverton, OR

Responsibilities:

• Worked with business in collecting business requirements and working with various departments for sign-off as a part of SDLC process
• Mapped the business transactions with the database stored data models.
• Created Crosstab reports for displaying the sales data by region and Charts comparing this data among the regions
• Developed ad-hoc Queries for each dept needs on the sales data by month and week
• Developed sales dashboards and Drill through sales detail reports with Conditional formatting and Dynamic parameters for customizing the reports.
• Developed Complex Executive Dashboards with multiple charts and cross tab reports and drilling down from the graphs for analysis of the sales vs pricing performance by region.
• Trained users to effectively use the reporting tool to build and customize their ad-hoc reports using Query Studio.
• Developed packages from multiple data sources in Framework Manager and published them for generating several Order to Cash Reports such as sales order reports by channel partner, payment analysis by channel partner etc

Environment: Cognos 8.2 - Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Report Net 1.1, DB2, Excel, Windows XP

Data Analyst

Confidential, Portland, OR

Responsibilities:

• Working with users in analyzing the data transactions and mapping data points from multiple systems
• Created several queries to extract the data based on the business needs
• Created several crystal reports that is integrated with PeopleSoft ERP, displaying the financial data from ERP tables
• Used PeopleSoft’s Query tool to generate ad-hoc queries for user with role based security.

Environment: Crystal Reports, DB2, SQLServer 2000, SQL Queries, DB2 Command Center, MVS