Profile:

• An experienced IT professional specializing in business intelligence Solutions, data warehouse architecture, data integration techniques, design, Implementation and production support of business intelligence/reporting initiatives.
• Proficient in all phases of the data warehouse and BI reporting project lifecycle, including business requirements gathering, data analysis, data modeling/development, database design, data transformation, data integration techniques, ETL/BI architectures, performance tuning and data delivery mechanisms.
• Working experience with Public Sector Health, Medicare Medicaid, Health care, Finance, Transportation and Insurance sectors.
• Systems integration experience of Cognos 10/8 BI Server with multi server load balancing and high availability configurations.
• Experience with requirement analysis, design and implementation of OLAP solutions.

Professional Summary

• Over Twelve plus years of extensive experience in all phases of Software Development life Cycle SDLC including System Analysis, Requirement Analysis, Data Modeling, Design, Development, Testing, Implementation and Production Support of Applications on Multi-Tier Architecture.
• Implementation Experience of Cognos 10/841 installation with multiple server configuration on VM Ware, Solaris 10, Linux Windows server 2008/2003 OS with load balancing options to support 500 users Trusted Sign on implementation using Cognos SDK and integrating with web applications and Sun one LDAP Server for user security, Data modeling and publishing of Cognos Framework Models for Report Development using Report Studio, Query Studio, Analysis Studio, Event Studio.
• Extensive experience in design, development and implementation of applications in client/server environment using Cognos Impromptu, Transformer, PowerPlay, Impromptu Web Reports IWR , Cognos Upfront , Cognos Query CQ , Cognos ReportNet Framework Manager, Query Studio, Report Studio .
• Strong experience in analysis of business requirements, creating technical specifications, data mapping, creating reports, portal customization, unit testing, deployment, and maintaining of complex reports /cubes with very high volumes 10 tera bytes of data sources .
• Strong Technical Skills in Database Design, Data Modeling, Application Development, query tuning.
• Extensive experience in Data Warehousing, ETL Programming, Cognos, Oracle 9i/8i RDBMS, Oracle 9iAS, Jdeveloper, Oracle Enterprise Manager OEM , Data loading using SQL Loader, Export/Import Utilities, Erwin/Designer, Developer 2000 Release 4.5/5.0/6.0/6i, Programming in PL/SQL applications viz. Java stored Procedures, Loading extraction of data in oracle, Data migration, Database Administration functions of Objects storage management, SQL /Memory Tuning, Users Security Management.
• Implemented object Oriented approach with Oracle PL/SQL Programming logic for building the customized Loading, Transformation and Loading ETL Scripts for the Data warehouse.
• Implemented the Oracle Database ETL Features of Upsert, External Tables, Multi table Inserts, Table/ pipelined Functions, Materialized Views, bulk loading features, object Types for DML and querying requirements of the applications.
• Working knowledge of operating system internals, file system structures, and machine architectures in Solaris/HP UNIX / Linux operating system environments and UNIX shell scripts.

Technical Skills:

BI Tools: Cognos Business Intelligence 10.1.1/8.4.1, Cognos Connection, Framework Manager, Report Studio, Query Studio, Event Studio, Cognos SDK 841, Power Play Transformer 10.1.1 841, Power Play Enterprise Server 10.1.1/841, Impromptu 7.4, Impromptu Web Reports 7.4, Upfront 7.4, Cognos Query, Access Manager, Microsoft SQL Server 2005 2008, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, IBM InfoSphere Data Stage 75

Databases: Oracle 11g/10g/9i/8i, SQL Server 2005/2008, MS Access

OS Platforms: HP UNIX, Sun Solaris, Linux, Windows 2000, Windows NT, MSDOS

Programming Languages: Java, C, C , Pro C, PL/SQL, Perl

Oracle Tools: Jdeveloper, Oracle Enterprise Manager OEM , Oracle Forms/Reports/Graphics, Oracle Web server, Designer, SQL Loader, Export/ Import Utilities, RMAN, DBMS Packages, SQL PLUS.

Other Tools: ERWIN Data Modeling tool, Visio, Microsoft Project, Eclipse IDE, TOAD, SQL Navigator

Internet / Web Technologies: IIS, Apache, IBM HTTP Server, IBM Web Sphere, Tomcat, Struts, JSP, Servlets, Java, XML, Java Script, HTML

Work Experience:

Confidential

Senior BI Consultant

Accomplishments and Roles/Responsibilities:

• Work closely with functional and technical teams DBA's, VMware Administrators, MITS Security teams, Web SSO teams, Load Balancer Teams etc. to implement and maintain optimal reporting environment.
• Create system level process documentation on windows patch maintenance of Cognos servers at WMATA, BI Security Training Guide, SharePoint Integration, Code promotion/deployments to support the ongoing project documentation library initiatives.
• Work with report developers on Cognos Audit package/report deployments and customization to support the MITS Security team's custom reporting needs.
• Perform periodic backups of all IBM Cognos environments.
• Code promotion/deployment and support change control processes of all reporting from development to QA environments and QA to Production environments as needed to support various projects.
• Develop and implement skinning/ customization of IBM Cognos development portal at WMATA with the look and feel of WMATA metro web logos and color schemes.
• Create and manage data source connections across all IBM Cognos environments at WMATA for various data sources of SQL Server databases, MSAS Cubes, Oracle 11g/10g databases, AS-400 data.
• Implemented the slider bar for the quarterly data grain of time dimension and check boxes for individual check boxes that allows the dashboards to adjust prompt filters within the dashboard.
• Development of Operational UWS and Departmental UWS dashboards/Universal Work Spaces for the OMBS and Finance Departments using Cognos Business Insight Advanced tool.
• Create Framework models from PeopleSoft EPM and peoples tables and create new finance reports Accounting, OMBS and Payroll departments to support the development of reports and dashboards.
• Design and implement security roles for all Cognos BI environments at WMATA for enterprise wide adoption with capabilities and content access roles of various reporting initiatives with Finance, Safety, Metro Access, Bus, Fare Collection teams.
• Successful resolution of configuration and installation issues with IBM Cognos Portlets/widgets on SharePoint portal implementation across all environments.
• Implementation of SSL with WMATA IBM Cognos environment components of Web SSO infrastructure, F5 Load balancer and ensuring IBM Cognos Configuration changes with all of the Cognos servers.
• Plan, organize, test and successful issue resolution of disaster recovery configuration of the IBM Cognos production environment and resolution as part of production readiness.
• Configure and manage the WMATA Enterprise Cognos BI environments on VMware infrastructure to support the system life cycle development of WMATA enterprise wide reporting requirements.
• Consult with business areas on matters relating to system connections, security, user accounts, and creation of data models.

Software Environment: Cognos Business Intelligence 10.1.1, Cognos Frame Work Manager, Business Insight, Cognos Report Studio, Cognos Transformer, Cognos Power Play, Cognos Query Studio, Cognos Analysis Studio, Cognos Event Studio, , Oracle11g/10g, SQL Server 2008, TOAD, VM Ware, PeopleSoft EPM, VMware vSphere client, Windows Server 2008 R2, IIS Web Server 7.5

Confidential

Senior BI Consultant /Lead Developer

Role and Responsibilities:

• Architect, Identify and define various Cognos components of gateway, dispatcher, content manager, content store, authentication provider for implementation as Server templates. Develop Scripts for installation and configuration of Cognos BI Server components of gateway, dispatcher and content manager.
• Summary of technical accomplishments and contributions on the project:
• Design, define key performance indicators and business metrics then translate these into operational reports, charts and dashboards that provide visibility and insight into customer's business operations.
• Designing and deploying Cognos-based BI solutions for salesforce.com customers using cloud-based analytics technology stack.
• Build a Smart Analytics Cloud infrastructure for data analytics initiative of Sales Force Application that can be deployed in a consistent manner.
• Develop and implement the Cognos SDK for custom java authentication provider CJAP for the authentication provider using the data from user data users, roles groups from sales force application.
• Design and implementation of scripts for customization of Cognos connection portal as the customer needs with custom cascading style sheets CSS Organization logos. This is to ensure that Cloud Analytics Solution blends with the organizational branding and ease of organizational adoptability, when deployed.
• Model the data structures to support various initiatives around building analytic solutions, dashboards, reporting and adhoc data querying needs.
• Design and development of Cognos power cubes using Cognos Transformer for supporting the analytical solution needs of Sales Force Application.
• Design and development of FM Models for analysis/reporting initiatives on Sales, Opportunities, Revenue, Pipeline etc.
• Development of dash boards/reports/queries using the Cognos tools of report studio, Analysis Studio, Query Studio, Business Insight.

Software Environment: SUSE Linux 11, DB2 9.7, Oracle11g/10g, Cognos Business Intelligence 10.1.0, Cognos SDK Custom Java Authentication Provider CJAP, Cognos Frame Work Manager, Business Insight, Cognos Report Studio, Cognos Query Studio, Cognos Analysis Studio, Cognos Event Studio, Cognos Scheduler, Cognos Transformer, Cognos Power Play, Apache Web Server, Jira, SVN, Putty, Cygwin Xming Server /X Server, Oracle PL/SQL, Java, Java Script, CSS, IBM Data Studio, Eclipse IDE, TOAD.

Confidential

Role and Responsibilities:

• As Cognos Architect and Lead Developer accomplishments included installation/maintenance of Cognos BI Software to support various environments of project life cycle and develop reporting solutions as per the needs of the ProviderOne Project, a medic aid claims processing system for the state of Washington. As a Cognos Administrator lead the team with hands on implementation of reporting solutions for complex reporting requirements of CMS and Medic aid claims processing system. Also, hands on working experience in building the Operational/Management Reporting Solutions, Steering Committee, MSIS, CMS 416, CMS 21 CMS reports, Operational Data Store databases, Decision Support System Data Warehouse Components of the providerOne Claims Management System.
• Below is the summary of technical accomplishments and contributions on the project:
• Environment Set-up and Administration:
• Set up of BI infrastructure to support all phases of SDLC/project life cycle viz. Development/ System Test/ UAT/Pre-production and Production environments on Solaris 10/Windows Server 2003/2008 Operating Systems.
• Installation and configuration of Cognos BI Software and SunOne LDAP Software for Security needs for each of the environments.
• Cognos infrastructure capacity planning set up Cognos servers 3 Solaris OS and 2 Windows Server 2003 OS for load balancing to support 500 users.
• Performance tuning of the Cognos servers for optimum threads to support the adhoc query and scheduling needs of the report/query execution threads on the Cognos servers.
• Standardization and implementation of release process to support the Cognos Package deployments across the various environments from development thru system test, UAT, Pre-Production and Production phases.
• Gather/Evaluate reporting requirements, analyze solution alternatives, design solutions, and develop implement the report development.
• Building up the intelligence to create the URL calls from the reports access portal pages of the ProviderOne application portal and Implementation of Trusted Sign on with Cognos SDK for seamless user authentication when navigating from the ProviderOne application portal.
• Implemented Cognos Auditing feature for the production environment to monitor usage and fine tuning of resources and optimum performance of the environment.
• Designed and implemented a frame work to monitor the daily, weekly, monthly, quarterly and annual report generation utilizing the event studio/scheduling features of the Cognos connection.

Security and LDAP:

• Installation and Configuration of SunOne LDAP server with various Cognos BI environments of development/System Test/ UAT/Pre-Production/ Production environments on Solaris 10 OS.
• Designed and implemented the security on SunOne LDAP server with OU, Groups, and roles for the Cognos BI environment to support the access to the Cognos tools of Report Studio, Query Studio, Analysis Studio, Event Studio and Administration on Cognos Connection.
• Implemented a proto type for configuration of Cognos BI server with MS Active directory for user authentication.
• Also, designed and implemented security of BI infrastructure for data access, object level access and package level with roles/groups.

Modeling:

• Implemented a three layer approach of physical database layer, business model layer and presentation layer for developing the Framework models for both dimensional and relational data sources from multiple source systems. Also, standardized naming conventions to be used across the Framework Models.
• Created metadata models for various subsystems of Claims, Member, Provider, Prior Authorization, Managed Care, Reference, TPL, DRB, Financials, Payroll, Work Management, Pharmacy and Steering Committee under individual namespaces in the presentation layer of the model. Further, ensured the cardinality and published as packages to Cognos connection for report/query development.
• Created model level measures, filters for dimensionally model data of star /snow flake schema sources as needed for report development.
• Implemented dimensionally Modeled Relational DMR techniques to relational databases to quickly prototype and implement work management of suspended claims data mart.

Report Development:

• Designed and developed the interactive Steering Committee dash board reports as part of executive reporting initiative towards the initiatives of Access to Care , Emergency Room , Licensed Health Care Professionals , Inpatient and Outpatient Facilities , Durable Medical Equipments and Pharmacy . Created and utilized confirmed dimensions and KPI of per member per month PMPM , per user per month PUPM costs across all of these initiatives. Also, designed the data structures for the data marts to source the data from the operational data store data warehouse and developed the data integration processes using the oracle pl/sql processes. Worked with business users for successful implementation from design thru development, system test, user acceptance testing and production, stabilization phases of the project.
• Further, designed and developed complex and critical CMS reports of Medicaid and CHIP Statistical Information System MSIS and Early and Periodic Screening Diagnostic and Treatment Participation Report CMS416 and other critical CMS reporting on CHIP/Cost avoidance reports.
• Created Cognos Power Cubes in Transformer from Star/Snow Flake Schema models to support the data analyst's requirements with Cognos Analysis Studio. As part of the processes created the dimensions and calculated measures as defined in the requirements and other calculated measures. Imported metadata from various sources such as Relational Databases, XML Sources, Report Net models, Impromptu Catalogs and Architect models into the Framework Manager.
• Created List, Complex Cross tab and Master Detail reports and also implemented various prompts including cascading prompts on the report prompt pages.
• Extensively used java script to enhance the user experience with report studio for accomplishing passing multiple values to an IBM Cognos 8 Report Studio textbox prompt, date validation where the start date prompt always needs to be less than the end date, achieving expand collapse functionality which is similar to outlines groups function of Excel on report page to name a few of them.
• Implemented Oracle PL/SQL object Oriented approach for the Programming logic for building the customized Loading, Transformation and Loading ETL Scripts for the Data marts/warehouse.
• Implemented the Oracle Database ETL Features of Upsert, External Tables, Multi table Inserts, Table/ pipelined Functions, Materialized Views, bulk loading features, object Types for DML and querying requirements.
• Used the IBM InfoSphere Datastage Designer to develop processes for extracting, cleansing, transforming and loading data into the data marts from ODS Operational Data Store and also file extract as per the EDI format layout for external agencies.
• With IBM InfoSphere Data Stage Designer, worked with different Stages, which includes Sequential File, Dataset, XML Input, XML Output, Copy, Lookup, Join, Transformer, Sort, Aggregator, Remove Duplicate, Filter, Column Export, SCD, CDC, Funnel, Oracle OCI, and RDBMS Stages.
• With IBM InfoSphere Data Stage Designer, designed jobs to populate tables using column generator, surrogate key, join, Oracle enterprise stage and Peek Stage for debugging purpose.
• With IBM InfoSphere Data Stage Designer, creation of Shared containers so that it can be used by other modules of the plan.
• With IBM Info Sphere Designer, designed jobs to populate tables using column generator, surrogate key, join, Oracle enterprise stage and Peek Stage for debugging purpose.
• Extensively used IBM InfoSphere Director for scheduling jobs to run in batch, emailing and online production support for troubleshooting from log files.

Software Environment: Solaris 10, Oracle11g/10g, Cognos Business Intelligence 841, IBM InfoSphere Data Stage 75, SunOne LDAP Server 6, Active Directory, Cognos SDK, Cognos Frame Work Manager, Cognos Report Studio, Cognos Query Studio, Cognos Analysis Studio, Cognos Event Studio, Cognos Scheduler, Cognos Transformer, Cognos Power Play, IBM InfoSphere Data Stage Designer 75, IBM InfoSphere Data Stage Director 75, IBM HTTP Server, IBM WebSphere, Apache Web Server, TOAD, Oracle PL/SQL, IBM Clear Case, IBM Clear Quest, Putty, Cygwin Xming Server /X Server, SQL Server 2005/2008, Oracle PL/SQL, Java, Eclipse IDE, TOAD.

Confidential

Software Environment: HP UNIX, Oracle9i, Erwin, Cognos Impromptu, IWR, Access Manager, Power Prompts, Cognos Query, Cognos Power Play, Cognos Transformer, Oracle Enterprise Manger, TOAD, pdf-tools, Visio, Microsoft Visual Source safe.

Role and Responsibilities:

As Reports team lead assignments included the Management Reporting Solutions, Decision Support System Data Warehouse , and Surveillance and Utilization Review System SURS Components of the Maine Claims Management System.

Management Reporting Solutions:

• Installation of ReportNet portal with Report Studio and Query Studio.
• ReportNet Installation and Configuration Tasks:
• Installation of Sun One Directory Server and created users/roles with users for authentication on the Cognos Connection Portal.
• Cognos Configuration with LDAP server for User/Role authentication and authorization of LDAP Users with cognos security with respect to various functions like view and run reports, Query Studio, Report Studio, Administration.
• Built Framework Manager Model, and established the cardinalities to suit the business needs. Implemented security for Data access, Object level access and Package access.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Gather/Evaluate reporting requirements, analyze solution alternatives, design solutions, and develop implement the management and CMS reports into production.
• Contributed to the identification of bottlenecks on Cognos software versions that is instrumental in our ability to scale to high volume report generation which is a core of the MECMS solution.
• Ensured the smooth operation of the solution on integrating MECMS application with the Cognos Portal Framework for on demand letter/report invocation from the MECMS OLTP application.
• Ensured the production support with timely deliverables on high volume and complex reporting requirements on remittance advice/ cost settlement reports to the providers.
• Provide both technical and functional Cognos product support for Cognos Upfront Portal, Impromptu Web Reports, Impromptu, Transformer and Power Play and Access Manager.
• Develop SQL and stored procedure programs to build and maintain in-house applications according to requirements documents and technical specifications.
• Perform detailed business analyses to gather and document client requirements.
• Support and maintain the technical side of a Cognos reporting environment on a HP UNIX and Oracle database platforms.
• Implemented Scheduled PL/SQL procedures to support the Management, Federal Reporting requirements.
• Implemented User Defined Functions, report development using the cognos Impromptu Tool.
• Develop and maintain UNIX shell scripts to accomplish merging of final PDF report outputs using third party software.
• Actively worked towards the process improvement for delivering reports to end users.

Decision Support System Data Warehouse :

• Analysis of data warehouse requirements with respect to the ETL infrastructure and architect/design the ETL solution frame work for development and implementation using Oracle PL/SQL batch processes.
• Initiated, developed and implemented the ETL solution for the Reference/Claims subsystems of the MECMS Solution. The same framework could be implemented by the team members to provide the ETL requirements of the Warehouse.
• Implemented the Oracle Database ETL Features of Upsert, External Tables, Multi table Inserts, Table Functions etc
• Developed the PL/SQL interfaces for streaming of data using pipelined Functions, moving Windows Features of the Complex Analytical SQL Implementation for the data transformation prior to the Loading into the Data Marts with the special needs for addressing the critical specific issues pertaining to the Slowly Changing Dimensions, Capturing of the Historical data with no delete restrictions imposed on the Operational Data source MECMS OLTP System
• Implemented object Oriented approach for the Programming logic for building the customized Loading, Transformation and Loading ETL Scripts for the Data Warehouse.
• Implemented PDML, bulk loading features, object Types for DML and querying requirements of the system.

Surveillance and Utilization Review System SURS :

Overview of the SURS:

• Surveillance Utilization Review System is a critical application component of the MECMS Solution that resides on top of the Decision Support System Data warehouse and has data structures that hold the business information, which is essentially the metadata of the Decision Support System Data warehouse data structures. The prime objective of the SURS application is identify the fraud abuse of the Maine care by all the participating entities e.g. Providers, recipients, Hospitals and other service providers of the Health care circle.
• SURS implements the predetermined approaches where in the matrix items, atomic level attributes of the profiling, for the each Category of Service viz. General inpatient, Physicians, Recipients etc. are defined. The results of these matrix items on certain logical arithmetic computations, called as Report Items can potentially lead pointers to the fraud abuse of the Maine Care programs under different Category Of service. These report items are further grouped into logical data sets called as class grouping to enable similar comparisons to flag off the potential cases for further investigations, which fall outside the acceptable range for that dataset.
• Analyze and capture the SURS business requirements and develop the data structures to hold the data centric applications requirements.
• Design and implement the SURS data processing engine. Also, developed supported the complex reporting needs of the SURS application in Cognos.
• Contributed towards the requirement analysis and technical design plan for the application. This is basically a data driven application where in the Data Structures has to hold the business information. This information is further used by the SURS application engine built in PL / SQL to dynamically create SQL execute them to populate the results into respective entities.
• Design and development of data model for the SURS application for capturing the business requirements.
• Developed, unit tested the SURS application engine created in PL/SQL to generate the final output of the Report Items that can be further analyzed by the SURS business users.
• Requirements gathering, development of the cognos reports using the final data generated by the SURS engine for various category of Services.

Confidential

Software Environment: Oracle 9i, Struts, Apache, Tomcat, JSP, Java, Servlets, XML, Java, Script, HTML

Overview of the EFTS:

• This is a customized web based solution for the Department of Interior with key features including seamless Chain of Command' assignments which vary the information views depending on the privilege of the user, extensive multiple secured layers, and streamlined report generation.
• The purpose of the application is web enable FOIA Request Tracking system and system control of the request and response for the Department of Interior.

Role and Responsibilities:

• Requirement analysis for the development of data structures to support the application needs.
• Design and development of the data model to capture all business work flows with the required entities, attributes and relationships.
• Data transformation, validation and migration of the legacy data in access database to the newly created data structures as per the captured application requirements in Oracle.
• Installation, Configuration, deployment of the data structures in Oracle on Windows 2000 Server O/S platforms.
• Development, unit testing of stored procedures database triggers required for application development. Implemented object types and their DML operations, Java Stored procedures as per the application requirements.