SUMMARY:

• 14+ years of experience in Data warehousing and Business Intelligence.
• 2+ years of experience in working with Confidential Probation Department with Probation Data, Charge Codes, Minor Demographics,other legal aspects of County social Services & Operations.
• Strong knowledge and experience in Helathcare Systems, EHR, EPM, Claims, Payor/Provider etc.
• 2+ years of expertise in working with NextGen Clinical Reporting System (EMR).
• Expert in writing complex T - SQL and Stored Procedures in SQL Server, ORACLE. Pervasive, Postgres databases
• 12+ years of experience in Cognos, Informatica,Oracle,PL/SQL,SQL Server,J2EE etc.
• Almost 6+ years of experience in Informatica ETL and Cognos ETL (Cognos Data Manager,Cognos Adaptive Warehouse & Analytics)
• Implemented several Cognos migrations involving Impromptu to Cognos 8.x, Cognos 8.x to Cognos 10.x etc.
• Almost 4 years of expertise in building web applications using Oracle Forms, APEX and J2EE .
• 8+ years of experience in PL/SQL and T-SQL .
• Expertise includes Oracle Applications R12/11i, Forms 10g/6i, Reports 10g/6i, Oracle Workflow 2.6.3, Oracle 11g/10g, SQL, PL/SQL, XML Publisher 5.6.3 and Oracle Discoverer 10g/4i.
• Good working knowledge in Supply Chain Management (INV, PO and OM), Manufacturing (BOM and WIP), Financial (GL, AP and AR) modules, Order to Cash (OTC) and Procure to Pay (P2P).
• 10 + years of expertise in Cognos Framework Modelling.
• 3 + years of experience in GlobalShop ERP and GLOVIA ERP tools used for Manufacturing Companies.
• 4 + years of experience in SQL Server Server ( 2005/08/12/14 ),SSIS, SSRS and Stored Procedures.
• Almost 7 + years of experience in migrating Cognos 7 (Impromptu,Catalogs,Powerplay) into Web based Cognos such as Cognos Report Net,Cognos 8.x,Cognos 10.x
• Implemented and migrated Cognos Secuirity in various platforms such as Access Manger,LDAP,Cognos SDK Authentication Provider etc.
• Almost 4+ years of experience in Cognos Data Manager, Cognos 10.1 Adaptive Warehouse, Cognos 10.1 Adaptive Analytics and Cognos TM1.
• Proven experience in architecting various integrations in IBM Cognos BI using Cognos SDK libraries. Designed & Developed Custom authentication Provider with Single Sign On capability,Custom group/role creation in Cognos Namespace,Transformer automation using MDL scripts,report XML generation using SDK, integration of Cognos report engine with other applications etc using both Java and C#.NET libraries.
• Implemented ETL (Extraction, Transformation, Loading) jobs both in Informatica and Oracle PL/SQL Stored procedure.
• Expert level knowledge and experience in ORACLE PL/SQL, performance tuning, Indexing, EXPLAIN PLAN etc.
• Expert in Data Analysis,Automation Scripting,Integarting BI system with Applications in J2EE.
• Very strong with Microsoft technologies such MS Access,MS Office,VIcio etc.
• Expert knowledge in G/L,Account Recievable,Account Payable,Shop Floor,SO,PO,BOM etc.
• Expert knowledge in operations of Manufacturing domain.
• Proven expertise in architecting Enterprise Datawarehouse (EDW) from Operational Data Store (ODS ) using Kimbal Modelling.
• IBM Certified Cognos Administrator & Datwarehouse Professional.
• Expert in designing & developing Cognos Insight reports.
• Expert in giving suggestions on software and hardware requirements for implementing Enterprise BI System in Cognos based software, how to automate various jobs, how to archive historical and day to day data etc.
• In depth knowledge and experience in Data Modeling (Star Schema, Transactional Data modeling) using Framework Manager, Score Card Reporting using Report Studio and Metric Studio, OLAP cube developed and published in Analysis Studio, Adhoc reporting in Query Studio.
• Implemented several Accounting/Finance reports and performed Trial Balance, reports based on Shipment & Handling,Financial Returns,Sales,Sales Taxes,Domestic & Forign Currency conversions,Exchange Rate calculations,Data processing based on both Calander Year and Fiscal Year etc.
• Good knowledge in LA County Probation Business and County Legal Aspects especially those are related to Juveniles, Supply Chain Management Process in Manufacturing and Life Science sectors.
• Domain knowledge in Manufacturing and Logistics, Life Science, Healthcare Insurance sectors.
• Extensive knowledge in, end-to end Datawarehousing process and implementing full life cycle Datawarehousing projects using Oracle database, ETL tool, Reporting tool and Unix Shell scripts. This includes Development, Testing, User Acceptance Testing (UAT), Production and production support, defect handling etc.
• Expert in handling software projects in onsite/offshore methodology.
• Proficient in programming language such as VB/Java /Java scripts and Excel macros.
• In depth knowledge in Cognos Software, Licenses, Installation and administration in UNIX and Windows environment.
• Expert in writing SQL in DB2, ORACLE and SQL server. Extensive knowledge in Stored Procedure and Packages in PL/SQL.

TECHNICAL SKILLS:

Operating Systems: HP UNIX/Windows 95/98/XP/NT.

Databases: Oracle 9i/10g/11, MS SQL Server 2005/08/12/14, /IBM DB2

Languages: PL/SQL, C, C++, Java,VB,Cognos SDK,SSIS

OLAP Tools: Cognos Series (Transformer, Analytical studio, Report Studio, Query Studio, Metric Studio,Cube Designer),SSRS

ETL Tool: Informatica 8x,PL/SQL,SSIS,SQL Stored Procedures

Data modeling Tools: Cognos Cube Designer,Cognos Framework Manger, Ervine.

Security System: Cognos Series7 Namespace, DAP Directory Server.

PROFESSIONAL EXPERIENCE:

Confidential,CA

BI Architect

Responsibilities:

• Performed requirment analysis and identified prepared detail Analysis document which covers Healthcare Datawarehouse Requirment,Reporting Requirment,Data Refreshing requirments etc.
• Performed a detailes data analysis, metadata analysis on NextGen Healthcare System which covers both EHR and EPM modules.
• Identified variaous dimensional attributes such as Paerson,Patients,Claims,Demographics,Diagnosis, Charge Codes,Fedela Poverty line attributes,appointment attributes,Encounter attributes etc
• Identified measures and designed various Fact tables and Dimension tables.
• Designed Star Schema Model for APHCV Healthcare DataMart.
• Designed & Developed various SSIS ETL joabs for loading the data into Data Mart.
• Designed & Developed various SQL Stored Procedures for performing Data loading process.
• ETL mapping are created using various SSIS transformations.
• Designed and Developed various SSRS Reports (static & Dynamic) reports from Data Mart.
• Multidimensional Cubes are designed in SSAS software.
• Automated daily,weekly and monthly ETL jobs in SSIS.
• Executed the project in full SDLC phases.
• Prepared Design Document, Technical Documents,Test Cases etc.
• Performance tuning of the T-SQL procedures using various approaches including the analysis of execution PLAN,Link tables,Staging area approach etc

Confidential

BI Architect - ETL/Cognos

Responsibilities:

• Performed Intial Requirment Analysis and made detailed Project Plan covering all the models/subject areas.
• Studied the transactional system, PCMS and identified various data, source tables,attributes etc.
• Designed ETL Model using Star Schema methodology in which Dimensions,Attributes,Facts,Slowly Changing Dimensions etc identified.
• Designed Cognos Framework Managers in 10.x series with hierarchies & Levels. Both models (FM Models, DMR Models )are created and packages published.
• Several Reports are designed & developed in Cognos Report Studio & Work Space.
• Multidimensional Reports are developed using Cognos DMR models.
• Multidimensional cubes are developed in Cognos Transformer and published.
• Prepared Mapping documents which describes the Source to Target mapping .
• Designed ETL Agorithms in PL/SQL for Extracting the data from PCMS system, Loading into Staging Area, Tranforming & Cleaning the data to meet the requirments, and Loading the data into Datawarehouse.
• Developed ETL Stored Procedures in PL/SQL for various ETL processes such Extracting Dimensional Data, Facts/Measures,Slowly Changing Dimensions etc. Various functions are written for Cleaning and Transforming the data from Staging area and finaly loaded into Target Datawarehouse.
• Designed ETL audit table to track ETL Data loading process.This involves capturing time stamps of ETL Job start time,Job end time,Exceptional records logging,
• Designed & Developed ETL Process in PL/SQL fro incremental data loading.
• Automated the ETL Process using PL/SQL jobs. Also Email functioning is integrated so that Administaror get Email updates on the status of ETL process (such Success,Failure,Exceptions etc.)
• Trained the County developers on designing Star Schema Modeling, Identifying Dimensions & Facts, ETL functionalities in PL/SQL such BULK loading etc.
• Various models such as Arrests,Halls/Camps Petitions, Courts, Minor Demographics,Supervison,Investigations, Caseloads, Casenotes, Placements etc are developed.
• Using Cognos Framework Manager, Framework Model has been Designed and developed to meet all the reporting reuirments.
• Various reports, especially Residivism Reports, Demographics Reports,Populations in Halls/Camps Reports,Caseloads Assignments & transfers Reports are developed in Cognos Report Studio.

Technical Environment: Oracle PL/SQL,PCMS,Cognos BI,Microsoft Visio.

Confidential

Senior Developer/Lead

• Participated in and drived the analysis, design, development and customizations of the Oracle Applications eBusiness suite (Forms, Reports, PL/SQL queries) and deployed such modification/customization in Oracle eBusiness environment.
• Analyzed the user requirements and developed technical design documents for conversions, extensions, interfaces and reports.
• Created Forms Personalization on Purchase orders form.
• Developed Duty Drawback Report for Logistics to request a refund for the customs fees ICU paid on raw materials that were first imported to the USA and then shipped back out as a subassembly or finish good out of the country.
• Develop a report for Business Continuity Planning Project that lists all the multilevel exploded Bills of Material for a group of items loaded into a temporary table.
• Developed a report that gives all the WIP Component Issues for EAM spare parts against work order performed with cost and total value information for EAM organizations.
• Developed a report for work order status for maintenance group to keep track of individual and group performance.
• Developed Italy Critical Care Sales XML Report.
• Coded SQL* Loader programs to upload into temporary tables and developed PL/SQL procedures for validating and transferring the data in temporary table into Oracle Applications interface.
• Created test scripts, performed unit testing and documented unit test results. Provided support/issue resolution during user acceptance testing.

Technical Environment: Oracle Applications R12, Forms 10g, Reports 10g, Oracle Database 11g, SQL, PL/SQL, XML Publisher, Oracle Discoverer 10g, TOAD 9.6, SQL*Loader

Confidential

BI Data Securiy Architect

• Designed the Secuirty Model using the existing sources.
• Designed the CAP model
• Implemented the CAP and Single Sign On module.
• Designed and Developed Java Program with Cognos SDK libraries for CAP class.
• Designed and Developed MDL Automation scripts for automating secuirty(assigning users & groups on Dimension)on multi dimensional cubes.
• Disgned and Developed FM Model and published the package based reports specifications and data model.
• Involved in SDLC documentions and production support.
• Automated the over all processes/jobs using AutoSys

Technical Environment: Cognos 10.x, Oracle PL/SQL,Oracle 11,JDK 1.6

Confidential

BI Reporting Architect

• Responsible to provide BI Roadmap for implementing Default Inventory DataMart.
• Responsible for developing Framework Manager Packages using SQL stored procedure as data source.
• Developed Dimensional Model Reporting (DMR) packages and created sever DMR reports.
• Developed and deployed Cognos Inight reports for executive users.
• Participate the Business Meeting at various level and perform the tasks such as preparing Meeting minitues,Effort Estimation etc
• Perform BI Software evaluation and prepare comparative study involving cost-benefit analysis.
• Prepare POC (Proof of Concept) in Cognos 10.1 for Multidimentional Cube and Dashboard reporting and BI automation.
• Responsible for Data Analysis and Designed Cognos Framework Manager Package and published.
• Involved ind designing Cognos Dashboard and Mulidimensional Cubes.
• Involved in preparing the Test Cases and Test Case queries in Oracle.

Technical Environment: SQL Server,Oracle,Cognos 10.1,Informatica Visual Basic, Windows XP, Microsoft Office, Microsoft Visual Studio 2008/05, Microsoft Access 2007.

Confidential

Project Lead/Architect

• Requirement gathering and architecture the system.This involves understanding of G|R Business,Direct Marketing,Call Center Mangement,Order & Fullfillment operations etc.
• Developed comples PL/SQL stored procedures and packages for ETL (Extraction,Transformation and Loading) processes.
• Developed triggers for automating ETL loading process and Reports/Cubes creation process.
• Identiefied the Business critical Cognos Impromtu reports and converted the Cognos Catalogs into Cognos Framework Manger Data Model and published the packages in Cognos BI Server.
• Complex impromptu reports are migrated into Cognos 8.x reports using Report Studio and lated migrated to Cognos 10.2.
• User/Groups/Roles are migrated to Cognos Namespace and implemented Single Sign-On.
• Powerplay Transformer Models are migrated to Cognos 10.2 in which IQDs are replaced by Cognos Framework Manager Packages in 10.2
• Design and Architecting EDW Database .
• Design & Architecting Frmaework Data Model to meet the reporting and multi dimensional analysis requirements.
• Designed various Business rules for extracting the data from ODS sources such as various files & ODS schema.
• Devloped TM1 cubes for Accounting Team.
• Developed Traininmg manual for train the users on Cognos BI System.
• Managed both ETL & Reporting Team.
• Involved in all stages including Reporting, Informatica Mapping & Cube Development,Testing etc.

Confidential

Project Lead (Onsite-Offshore Co ordinator)

• Requirement gathering and architecture the system.
• Design and Implement Security Groups creation, adding users into groups.
• Installed and configured Cognos BI 8.x BI Suit in both Unix/Linux and Windows.
• Migrated Cognos Impromtu Catalog into Framework Manger Models and published the packages.
• Migrated users/roles into Cognos Namespace using Cognos SDK.
• Impromptu reports are migrated into Cognos 8.x.
• Design and Implement Cube development and build in UNIX using shell scripts.
• Report Developments Analysis Studio/Report Studio
• Created customized security system and integrated into reporting system using Cognos SDK and MDL scripts.
• Unit Testing, System Integration Testing, User Acceptance Testing, Production Support.

Technical Environment: UNIX Shell scripts, Cognos 8.4 Transformer, Oracle 9i, Cognos SDK (Java).

Confidential

ETL/Report Developer

• Architect the Enterprise Reporting System in Cognos Report Net and later in Cognos 8 Series. Integrated it with VB based application.
• Migrated all the Cognos Impromtu Reports, Crystal Reports and and MS access reports into Cognos Report Net and later into Cognos 8.x
• Involved in the designing and development of procedures and packages in DB2 for ETL process
• Involved in Report Developing
• Created stored procedures
• Created several work flows for loading data from various sources.

Technical Environment: DB2, Cognos Report Net, VB6.

Confidential,New York

Cognos Reports Developer

• Created mappings for loading data from Oracle transaction system into data mart.
• Created Cognos cubes and Reports.
• Preparation of Technical Specifications.
• Integration of reports into IBM Websphere based system.

Technical Environment: Informatica, Cognos, Java, Oracle.

Confidential

Cognos Reports Developer

• Understanding of all the reports and Catalogs.
• Involved in the installation of Cognos 8 tools in multi user environment.
• Configured Report Net in Apache server environment.
• Involved in the report validation process
• Created and published packages in Framework Manager and created metric package in Metric Studio from various sources.
• Tested the XML data from Cognos 7 and Report Net and are imported into Cognos 8 and validated the data source and security information.
• Involved in the training session for the Business users.

Technical Environment: Cognos, Oracle.

Confidential

Analyst

• Created and Developed ETL mappings.
• Designed the workflows for ETL loading.
• Used Data Flux tool for cleaning the data
• Developed and improved full client reports using Business Objects XI R2
• Involved in the Effort Estimation process and Reporting Resource allocation phase.
• Designed and Developed the POC (Proof Of Concept) for the project.
• Requirement gathering from the Business People and transform those into Design of Data mart
• Involved in the installation of Cognos Report Net tools in multi user environment.
• Configured the Cognos Report Net for ORACLE database as Content store and Reporting Database and created the user classes according to Business group.
• Configured Report Net in Apache server environment.
• Integrated Cognos Reporting system into Enterprise portal through NTLM security protocol.
• Involved in the data validation process and reported the data discrepancies to the data vendors
• Created and published packages in Framework Manager from various sources.
• Generated various kinds of reports (List, Cross tab, Drill Through, Master Detail) in Report Net
• Using Report Studio and Query Studio.
• Bursted the reports and distributed to field sales people in every Tuesday

Technical Environment: Informatica, Cognos, Oracle, Data Flux.

Confidential

Analyst

• Involved in the Development of ETL mappings and workflows.
• Requirement gathering from the Business People and transform those into Design of Data mart
• Technical Lead for reporting module which involved 4 persons in onsite.
• Involved in installing and exploring ReportNet tools such as Report Studio and Query Studio and Frame work Manager.
• Developed Custom Authentication Provider using Cognos SDK in Java.
• Configured the Cognos Report Net for SQL Server database as Content store and Reporting Database.
• Configured Report Net in Apache server environment.
• Set up Cognos Connectivity in a J2EE environment.
• Imported packages from offshore team into Report Net server at client site and integrated these packages into J2EE environment.
• Created and published packages in Framework Manager from various sources.
• Generated various kinds of reports (List, Cross tab, Drill Through, Master Detail) in ReportNet
• Using Report Studio and Query Studio.
• Created Customized Authentication Provider in Java using Report Net SDK.

Technical Environment: Informatica, Cognos, IBM Web sphere.

Confidential

Analyst

• Involved in the Development of ETL mappings and workflows.
• Created Transformer Models as per the Business requirements using Power play Transformer
• Cubes are developed for the analysis.
• Various Power play reports are created using Power play.
• Financial reports are developed in Impromptu and published into Upfront Server
• Security is implemented using Cognos access manager.
• Reports (list reports, Ad hoc reports, cross tab reports drill down reports etc) are created in Impromptu.
• Created batch file for creating the Cubes at the schedules time.
• Upfront is integrated into J2EE portal using java script.

Technical Environment: Informatica, Cognos, Oracle.

Confidential

Analyst

• Involved in the Development of ETL mappings and workflows.
• Installed the Cognos Impromptu, Power play, Transformer and Access Manager.
• Designed a solution for Reporting.
• Catalogs are created in Impromptu.
• Different Models for Multidimensional analysis are created in Transformer.
• Impromptu and Power play reports are created.
• Informatica mapping are created using Designer for loading the data into Reporting Database.
• Reports, Cubes are tested and prepared test case documents.
• Changing filters, layers and measures.
• Created Multi-Dimensional reports using PowerPlay.
• Created top ten reports & sort data on percentage growth.
• Generated Trend over Time, Variance Reports.
• Created Catalogs and assigned joins as per the requirements.
• Applied Governor Settings to the appropriate users, table weighting to improve the performance.
• Customized the reports by adding calculations, conditions and functions.