Summary of Professional Experience

• 6 years of strong experience in Data/Requirement Analysis, Design, Modeling, Development, Testing and Documentation of Database/Datawarehouse/Business Intelligence applications for various industries including Medicare, Insurance, Educational, Retail, and Shipping.
• Strong experience in providing Data Warehousing and Business Intelligence Tool solutions for developing various reports using Cognos Series 8 (8.1, 8.2, 8.3, 8.4), Cognos Reportnet 1.X suite, Cognos Series 7.X suite and Micro strategy 9.1,Oracle Forms Reports D2K, BI Publisher Oracle 11G.
• Strong hands-on experience in designing and developing Packages using Cognos Framework Manager, Develop Cognos Cubes, complex reports (List Reports, Cross Tab Reports, Charts, Maps, Drill Through, Dashboard Reports, Master Detail Reports & Canned Reports) using Report Studio.
• Certified Oracle Developer (OCA/OCP) with extensive experience in Relational Database Systems Oracle, Teradata, DB2, MS-SQL Server, and database development experience with SQL, PL/SQL, Stored procedures, Packages, Forms, Reports Triggers and Materialized Views
• Strong analytical and communication skills (written and verbal) and ability to work independently or on a team environment, handle multiple tasks concurrently.

Technical Skills

• Domains: Medicare, Insurance, Educational, Retail, and Shipping.
• OLAP Tools: Cognos 8.X BI (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, PowerPlay Transformer)
• Cognos ReportNet 1.X (Framework Manager, Report Studio, Query Studio and Cognos Configuration), Cognos 7.X(Impromptu, Impromptu Web Reports (IWR),Oracle BI Publisher
• Database: Teradata 6, Teradata 12, SQL Server 2000/2005, Oracle 10g/9i/8i/8.0/7.3/7.1, DB2,
• Data Warehousing: Entity-Relation modeling, Object Oriented Design, Star and snow flake Dimensional modeling
• Languages SQL, Java, VBScript, PL/SQL
• Web Technologies: HTML, XML
• Operating systems: MS Windows, Windows 95/98/00/NT 4.0, Unix(Solaris, HP, AIX)

Work Experience

Confidential, Elkridge, Maryland June 2011 -Till Date

Federal Client: - Centers for Medicare & Medicaid Services - DECC (ESRD)
BI Lead
Currently working on the End Stage Renal Disease line of the Development Effort Consolidation Contract Project with Cognos BI Tools & Oracle BI Enterprise Edition OBIEE 11G

• Talked to the Business Users and gathered the Business Requirements and thereby analyzed the requirements
• Studied functional specifications and created Mockup Reports
• Assisted the Admins to identify and create the users in Access Manager and assign them respective roles
• Followed sessions with the data modeler and data owners to decide the required data model for particular Cognos projects
• Analyzed the data and database from Oracle 11g databases by querying from SQL developer
• Created various joins, cardinalities, filters, calculations and followed the aesthetics of package development
• Created datasources in Cognos Connection and imported the tables, columns and OLAP cubes to create heterogeneous package in Framework Manager from deriving data from various relational and multidimensional datasources
• Wrote reports using Report Studio for creating dashboards by using specific color coding schemes for Charts, Trend Lines, Bar graphs
• Created complex reports with List, Crosstabs, cascading prompts with simple to very complex calculations
• Exclusively used the Conditional Layout, Conditional Formatting, Conditional blocks and Report variables for dynamic rendering of the reports as per the selection
• Created the Technical Design documentation specifying all the required facts, filters, prompts, attributes, and metrics and their respective mapping to the database for the BI Publisher reports
• Created the BI Publisher Data model(Metadata model) layer
• Constructed the underlying Database Views (Standard views and Materialized views)
• Developed the reports using BI Publisher Template Builder and Microsoft Word BI Publisher RTF template builder.
• Created unit test scripts and performed the unit tests for these reports.
• Conducted the peer review sessions.
• Conducted training sessions for the new developers to give an overall view about the project functionally and technically.
• Worked with new developers to get them to speed with the current state of project.

Confidential, Maryland Nov 09 - June 11

Federal Client: - Centers for Medicare & Medicaid Services - Part D Drug Data
BI Lead Consultant
Numerous projects at General Dynamics Information Technology using Cognos and Microstrategy as BI toolsets for data and business analysis

Cognos to Microstrategy Transition Project - Converted the existing cognos reports to Microstrategy

• Studied the existing cognos reports functionality and created the requirements specifying the elements to be displayed in the form of mock-up MSTR reports
• Created the Technical Design documentation specifying all the required facts, filters, prompts, attributes, and metrics responsible for the new MSTR report
• Assisted the MSTR Architect to design the project
• Developed the reports with most performance efficient SQL
• Performed the Unit Testing by matching the outputs with existing cognos reports and verified the data by actually querying data from source database

Error Strategy Reporting Project - Client requirement was to perform analysis of the Rejected PDE data using Cognos reporting tool.

• Conducted JAD sessions with the users and thereby collected & analyzed their requests
• Designed the concise requirements within the score of the Business Requests and limitations/advanced functions of cognos
• Designed new Target tables in the Datawarehouse for accommodating the rejected data
• Created V2 views for cognos ad-hoc reporting and standard canned reporting
• Designed the ad-hoc Framework Manager Model for the client to create their own custom reports
• Designed the Framework Manager Model for Canned Reporting

Special Analysis and Reporting Project - Special Analysis and ad-hoc Reporting was done for the client by documenting their concerns and performing data analysis to track the irregularities to trace any Medicare misuse

• Identified the various sources to gather the data as per the requirements and thereby documented them
• Wrote complex SQL queries as per the functional requirements to facilitate the data extraction for analysis
• Consolidated the data sourcing from various subject areas writing DDL statements which required high frequency of analysis
• Delivered different list crosstab excel reports to the users as per their requirement

The Database Merge Project - IDR and ODR were 2 different data warehouses with few differences which were merged for reporting purposes so as to have one source of information

• Prepared Mapping documents for different objects from the Framework Manager Model and Canned Reports (based on tabular SQL) to the existing IDR database elements
• Identified the Database objects which underwent changes due to the merger
• Modified the tabular SQL's of the Canned Reports, Objects of Framework Manager Model and V2 views by replacing the existing elements with the newly changed database elements
• Conducted unit testing by writing SQL's and comparing the outputs with the data from existing reports
• Completed design & unit test documentations and conducted the related walkthroughs
• Performed user training sessions to explain the associated changes
• Controlled and maintained the code history using Visual SourceSafe

Generating SQL Reports for complex Client Business Requests

• Analyzed and documented various client business requirements for ad-hoc reports generation
• Complied various Complex SQL scripts in the Production environment so as to produce desired results
• Created query template to generate similar reports by the Data Analyst team
• Conducted walkthroughs and user training sessions for clients
• Documented the Technical design and the results

Regression Testing Project of Cognos Reports for Teradata 6.0 to 12.0 Upgrade

• Scheduled the jobs for running various cognos reports against Teradata 6.0/Teradata 12.0 and collected the statistics related to reports' performance
• Documented the comparison performance statistics of reports against the 2 different Teradata versions
• Analyzed the performance issues and accordingly worked with the Teradata DBA's to resolve these performance related issues
• Created new templates for the Regression Testing documents
• Documented the results using Excel spreadsheets

The Cognos 8.4 Upgrade

• Used the Cognos Upgrade Manager on 8.4 to upgrade 8.2 Canned Reports/Framework Manager Model
• Resolved various issues on reports and framework manager models pertaining to the 8.4 upgrade
• Used the standard templates for documenting the technical issues occurred and their resolutions
• Logged defects, experienced in Cognos 8.4 with Cognos support
• Conducted the user training sessions & walkthroughs explaining the changes associated with the upgrade
• Consequently upgraded Test and Production environments with the proper documentation and CMMI standards
• Uploaded the code to the VSS repository

Confidential, San Francisco, California
Sr. BI Analyst/Developer Apr 09 - Oct 09
Wested is a semi-government organization dealing with educational programs for different schools. Therefore they contain a huge database dealing with this business. They already have over 300 reports developed in cognos8.3 for different departments like contracts, funding accounting etc.

Responsibilities

• Created packages having proper business names and joins for performance enhancement
• Created various Cubes from various data sources and flat files
• Deployed the packages and reports on various environments
• Created Dashboards which involved extensive use of Different charts, Complex joins
• Developed numerous HR Demographic Reports depicting the Hires, terms, rehires
• Implemented various Payroll reports for Payroll reporting for Earnings, Overtime etc
• Created complex reports showing multiple measures coming from different star-schemas. Development of these required extensive use of conditional color formatting and conditional diagram display depending upon very complex business calculations
• Used HTML in cognos for additional enhancement features like tooltips in report studio
• Conducted the testing and analysis of the reports for consistency
• Actively participated in gathering reviews and enhance the Business requirements
• Solved functional as well as technical issues hindering the development
• Worked exclusively for the performance enhancement of the reports with DBA's

Responsibilities

• Worked with business analysts to understand and document business needs
• Involved in Creating Framework manager models by importing metadata from Oracle data warehouse
• Used the Star Schema grouping with the Common/Confirmed dimensions across multiple fact tables
• Involved in the Business Data Analysis, Design, Development of Multidimensional OLAP Cubes, deployment and provided drill-through targets to another Cube and ReportNet reports
• Created relational and multidimensional packages with proper business names and created joins for performance enhancement
• Developed Standard Reports, Master Detail Reports and Drill-Through Reports to provide users with more detailed information
• Developed filters, calculations, dial gauges, prompts, conditions and created various reports, using Cognos Report Studio
• Worked extensively on performance tuning of the reporting structure
• Developed various dashboard involving extensive use of different charts, gauges, complex joins
• Used conditional formatting, conditional layouts and conditional blocks to display different sets of data based on different conditions.
• Created complex Drill thru reports showing multiple measures coming from different star-schemas. This report had extensive use of conditional color formatting and conditional diagram display depending upon a very complex business calculation
• Created complex Search and Drill thru reports for these search showing multiple measures coming from different star-schemas
• Worked on Union /Subtract queries
• Conducted presentations for the Client meetings to represent the project status with its functional and technical capabilities.
• Developed ad-hoc reports using Cognos Query Studio
• Was responsible for the initial kickoff of the logic development and basic structure for all the Dashboards
• Coordinated with Testing team for UAT & BCT and assisted developing the Test scripts and Test plans
• Scheduled reports to run on a monthly, weekly, and daily basis, as per the end user requirement

Confidential, Walnut Creek, California
Cognos Consultant Jan 08 - Aug 08
Safeway, the most profit making retail chain of the west used Cognos products extensively to create the reports from various databases. The effort was to centralize the reporting system using Cognos. Safeway's requirement was to replace all the previously existing reporting systems with Cognos

Responsibilities

• Interacted with Business Users and SMEs by conducting JAD sessions to gather Business requirements
• Created Business Requirement documents according to standard formats
• Studied the reports and analyzed the logic required to recreate same reports in Cognos
• Identified various data sources as per the requirements and consequently Imported various databases into Cognos Connection
• Created various packages in Framework Manager and used the best practices for package development
• Used the structured approach and created various folders for Business Users, Cognos Developers and Database view
• Used segmenting and linking to club multiple packages for requirements where report needed to fetch data from different data sources
• Involved in the Business Data Analysis, Design, Development of Multidimensional OLAP Cubes, deployment and provided drill-through targets to another Cube, Power Play Portable Reports, Impromptu reports and Report Net reports.
• Developed IQD's in Framework Manager of Cognos 8 BI for building the PowerPlay cubes in series 7.x
• Designed the standard template for creating reports in Report Studio
• Created model query subjects and analyzed the cardinalities and joins between query subjects
• Involved in Creating Meta Data Models and Publishing packages to Cognos connection
• Developed Standard Reports, Master Detail Reports and Drill-Through Reports to provide users with more detailed information
• Created Complex reports with conditional formatting that drills through to the lower level detailed reports
• Worked with Dashboard and Chart reports, Worked with various prompts in the report studio
• Created complex reports to show data from multiple data sources using extensive color formatting and complex join calculations
• Wrote SQL's extensively to verify the data against the database for comparing the report data
• Scheduled reports to run on a monthly, weekly, and daily basis using Report Net, as per the end user requirement.
• Provided documentation and support functionality for the Production Support and End Users.

Responsibilities

• Developed and maintained custom business workflows, modules specific enhancements, Application Program Interfaces (APIs) in e-Business suite using PL\\SQL, conducted programmatic analysis of integrated modules in manufacturing package and provided functional expertise to clients
• Worked on creating and Modifying Oracle Forms and Reports in Developer 2000
• Wrote complex SQL queries. PL/SQL Procedures, Triggers, Functions, Packages
• Trained the senior business management for creating ad-hoc reports using Business Objects
• Performed the initial configuration, testing, provided post Implementation Support

Educational Qualifications

• Masters in Computer Science
• Bachelors in Mechanical Engineering

Certifications

• Oracle Certified Programmer (OCP) - Oracle 9i Forms and Reports
• Oracle Certified Associate (OCA) - Oracle 9i SQL - PL/SQL