•Delivered self-service reporting solutions and capabilities to end users via Cognos Framework Manager and Cognos Cube in the Kaiser Permanente Colorado Agile environment.External Encounter Data Mart Self-Service Layer,  IBNR Cube - Self-Service LayerCase Cube - Self-Service Layer, EEDM - Reports & DashboardsSupply and Demand Self-Service Layer•Work with different functional groups to translate business requirements into Business Intelligence solutions•Worked with executives & customers to define requirements and implement Cognos Dashboard•Developed and delivered training to executives & end users.•Assisted with remediation and testing activities for the Oracle/Informatica Upgrade project •Established best practices to ensure data quality and perform quality review of Cognos Framework Manager and data modeling.•Cross-trained & provided technical direction and support for the business intelligence architecture, environment, development staff, and tool sets •Created multiple Cognos support/training Documentations – Process guide, Technical report design, Prod Support Process, report spec template & Project charter for Cognos Operational governance.•Assisted with Business Object Upgrade project; migrated Webi reports & universes from 2.1 to 4.1 Env.•Analysis of QlikView tool: Tool complexity, Hardware requirements and high level resource capacity to maintain QlikView environment. Provided the proof of concept demo to our management team including pros and cons of the software analysis.•Assisted SA team on COGNOS upgrade by testing KPCO Cognos environment and reports migration from version 8.4 to Cognos 10.2 Env including testing, roll out plan and communicating with KPCO Cognos users.•Introduce to Cognos tools such as Cognos Env, Reports, Cube, and FM to the multiple KPCO analytic community.•Effectively coordinate project teams at offshore (India) through various projects and ensure that the milestones are met.

Responsible for the design and development of complex reporting and data analysis for this global leader in business process and information technology services specializing in government healthcare solutions. Converted all business object reports into Cognos 8; created new Cognos reports, dashboards OLAP cube. Assisted in the resolution of reports performance and data quality issues.Analyzed, defined, and documented system requirements for data, workflow, and business processes. Created and executed test plans to ensure all components of system meet specifications.Worked with other Cognos developers regarding best practices and development standards for report development. Led and cross-trained ACS team members and Colorado Department of Health Care Policy & Financing Cognos Users.

Database Programmer:•Reviewed, analyzed, and modified SQL Programs, applications, and extract transform load processes including encoding, testing, debugging, and documenting. •Wrote SQL programs and scripts as required for small and large-scale data updates.•Implement data models and database designs, data access and table maintenance codes.Responsible for development and operational support on business databases.Database Operations:•Assist DBA in the resolution of database capacity issues. •Assist with administrative maintenance of relational databases including backup/recovery, scheduling, problem diagnosis and performance tuning. •Provide technical consulting and respond to error reports, problems or questions. •Provide technical support for third party systems integrated with the ICAT website applications. •Perform scheduled job monitoring.Cognos:•Installed and configured Cognos 8 suits. Upgraded Congnos Env version 8.1 to 8.3•Created Complex report and Dashboards•Modified Metadata Modeling by using Framework Manager•Created complex Cognos Reports using drill through reports, multiple prompts and filters •Developed reports based on user requirements from Business Support users - both for standard reporting and ad hoc requests using Cognos Report Studio.•Solving Cognos 8 connectivity problems with various data sources.•Created and designed Framework Manager Projects against SQL data sources.•Gathered requirements from various clients according to different lines of businesses and developed various kinds of reports.•Created Various Cognos Documentations and Template.•IT Platform Environment: Cognos 8.1/8.3, Power Play Transformer 8.3, MS SQL Server, Oracle 9i, TOAD, Windows 2003 Server, and MS Excel

•Planned, designed, and implemented the change process for reports conversions.•Trained four Report authors to write complex reports using Report Studio. •Created various jobs and schedules for Reports to run after completing ETL process. •Converted and consolidated Crystal and MS Excel reports in Cognos 8.1•Created various Drill-through reports for Summary Reports.IT Platform Environment: Cognos 8/ReportNet (Report Studio, Query Studio, Framework Manager, Server Administration, Cognos Connection, (SQL Server 2000, Oracle 9i, Crystal Reports, Access Manager, IIS Web-Server, PL/SQL, Windows Server 2003.)