Senior Epic Clarity Reporting and Data

Analyst

Sayan Chatterjee

Email : abmq46@r.postjobfree.com

Mobile : 925-***-****

Summary:

v Over 7 years of extensive experience in Information Technology with

special emphasis on Design and Development of Data Warehousing in various

domains such as Healthcare, Insurance and Telecom.

v Total US experience of more than 3.5 years with Fortune 500 corporations

like Kaiser Permanente, AIG. Also worked with UK's leading telecom

provider BT.

v Over 6 years of extensive experience in using Abinitio, Epic Clarity

reporting, Teradata, Oracle. Was involved in Design, Development,

Implementation, and Production support of ETL processes for large scale

Data Warehouses and complex applications.

v Over 3 years of experience in creating and modifying user reports using

Epic's Reporting workbench utility and scheduling them through Epic

Hyperspace.

v Experienced with Epic crystal clarity report and MyEpic application.

Successfully implemented Epic Spring 07 & Summer 09 production upgrades.

v Extensive experience in performance tuning techniques using Abinitio,

Epic Clarity, Oracle, Teradata.

v Over 3 years of experience working with InterSystems Cach environment.

v Over 3 years of experience in Oracle 10g/9i/8i with proficiency in

PL/SQL.

Over 3 years of experience in Teradata RDBMS and SQL 13.2 assistant tool.

Over 4 years of experience in managing SR/RFCs using Remedy tool.

Extensive experience in Tuning SQL queries and Table Partitioning.

v Strong knowledge in OLAP Systems, Dimensional modeling using Star schema

and Snowflake schema.

v 3 years of experience in writing Unix shell scripts to support ETL loads.

v 3 years of experience in Health Care domain, 2 years in Telecom domain,

1 year in Insurance domain.

v Skilled in interacting with business users to analyze current business

process and identify business requirements.

v Successfully performed roles of Epic clarity reporting lead, Senior Data

warehouse /Abinitio/ Oracle / Epic clarity ETL developer.

v Employed with one of world's largest software corporation for last 5

years.

Technical Skills:

Operating Windows 98/2000/NT/XP, UNIX ( HP-UX 11.0 )

Systems

Languages PL/SQL, Unix scripting

ETL Tools Ab Initio 1.14.20, Epic Clarity ETL

DBMS Oracle 10g/9i/8i, SQL Server, IBM DB2, Teradata,

InterSystems Cach , Epic Chronicles

Version Control Systems Microsoft Visual Source Safe (V.S.S), AbInitio EME

Data Modeling Dimensional modeling

Tools Toad for Oracle, Squirrel for DB2, SQL 13.2

assistant for Teradata, Remedy tool for change

management

Project Experience:

Project Title KP Healthconnect Reporting

Client Kaiser Permanente

Period June-2007 to till date

Position Epic reporting analyst

The Project Kaiser Permanente health connect (KPHC) project deals

with Electronic Medical Record (EMR) of patient related

information. They are divided across regions which are

based on separate time zones. This is a comprehensive

health information system that includes one of the most

advanced electronic health records available. This

connects millions of people securely to their health care

teams, their personal health information, and the latest

medical knowledge - taking advantage of Kaiser

Permanente's integrated approach to health care.

Role and As a reporting analyst, I have following

Responsibility responsibilities:

Responsible for creating and modifying user reports using

Epic's Reporting workbench utility and scheduling them

through Hyperspace.

Responsible for gathering requirements from clients about

tables required for reporting and load them on demand

Responsible for installation, maintenance and up

gradation of the EPIC Clarity data model

Creating and modifying Crystal Reports using MyEpic.

Working with EPIC for custom reporting requirements

ETL Administrator for the project, responsible for

modifying and scheduling Epic clarity ETL jobs.

Monitor, investigate and troubleshoot errors that caused

extract or load failures

Analyze, maintain and resolve Data Integrity issues

Primary liaison between reporting team, application team,

DBA team, Business and EPIC TS for specific problems

Provide project management, particularly focused around

meeting critical timelines, project communication and

hands-on implementation for assigned projects

Work with ETL developers and QA analysts to create

reliable and dependable reporting processes.

Research and resolve issues with Business Object

reporting processes or the resulting data.

Responsible for designing, developing and supporting the

Extraction Transformation Load processes for the Data

Warehouse and the Landing/Staging Database. Act as an

escalation point to resolve production issues on 24*7

mode.

Application configuration using Epic Chronicles.

Responsible for setting up new Epic clarity data marts.

Managing SR/RFC using Remedy change management tool.

Troubleshooting errors in InterSystems Cach

environment.

Timely documentation of the production changes performed.

Mentoring junior ETL analysts

Operating System Windows 2000/2003/XP, Unix

Technology Epic Clarity, Teradata RDBMS, Remedy, Unix

Location Pleasanton, CA

Project Title TPAIR Phase III Data warehouse

Client American International Group (AIG)

Period Dec-2006 to June-2007

Position Senior Data warehouse developer

The Project AIG provides commercial insurance to large corporations.

To

handle claims submitted by claimants, the client enlists

the services of Third Party Administrators (TPA).The TPA

validates, processes and pays the claimants on behalf of

AIG. The TPA then sends the claims to AIG for billing,

booking, reimbursement and reporting. The claim data from

all TPAs are validated for data quality and populated in

the TPAIR database by coverage validation. The TPAIR

database and its associated processes apportion the losses

between the insured layer and excess layer on a claim. The

system then bills the deductibles to the Insured and books

the losses to Corporate Reporting System (CRS).

Role and As a Senior Data warehouse developer, I had following

Responsibility responsibilities:

Responsible for business analysis and design of various

Abintio graphs as per business requirement

Responsible for development and maintenance of various

graphs using Abintio as ETL and DB2 as database as per

business requirements

Was involved with integration testing

Created test data for testing the graphs

Production implementation of the graphs which were tested

successfully during unit testing as well as user

acceptance testing processes

Fixing any kind of errors in Production schema that caused

failure in ETL process

Responsible for performance monitoring and tuning of the

applications involved

Primary contact between reporting team and DBA team for

fixing specific problems

Coordinate migration efforts to different environments.

Support UAT/regression testing efforts.

Operating System Windows 2000/XP, Unix

Technology IBM DB2 as RDBMS, AbInitio 1.14.20 as ETL

Location Jersey City, NJ

Project Title Enterprise Data Warehouse-EDW

Client British Telecommunications (BT)

Period May-2006 to Dec-2006

Position Data warehouse developer

The Project The Enterprise Data Warehouse (EDW) supports the CRM

(Customer Relationship Management) stream of the Retail

Consumer business. It works simultaneously with a tool

known as Next Best Activity (NBA). NBA tool harnesses BT's

Consumer Data using business rules to interrogate such

data and provide automatic prompts in the customer

interaction of call center application. EDW provides a

single end-to-end view of customer, service, network and

infrastructure element inventories for BT's broadband

technologies.

Role and As Abinitio and Oracle developer, I had following

Responsibility responsibilities:

Design and implement ETL Load strategy using AbInitio as

per client requirements and existing database model.

Interact with Business Analyst, Review functional

specification document and develop technical specification

for load.

Code Review

Unit & Integration Testing

Test data preparation

Implementation

Bug Fixing

Performance Tuning

Review individual Modules

Integrate all the individual AbInitio graphs

Support UAT/regression testing efforts and distribute

defects and review.

Coordinating with other team members

Developed reusable functionality to standardize the

development approach for ETL development, using Abinitio

and Oracle Stored procedures which can be used as a

reference for next phase of developers.

Managing SR/RFC using Remedy change management tool

Operating System HP-UX 11.0, Windows 2000/XP.

Technology ORACLE 8i as RDBMS, AbInitio 1.14.20 as ETL.

Location Kolkata, India

Broadband Customer Reporting (BBCR)

Project Title

Client British Telecommunications (BT)

Period May-2005 to May-2006

Position ETL developer

The Project This project provides BT Global Services with a data

model, ETL platform (AbInitio), data mart, reporting

portal, product reports and an ad-hoc reporting

capability. It works directly under BT Exact, which in

turn works with BT Wholesale to look after requirements of

BT's Broadband customers and give the best sort of

services required by them.

Role and As a developer, I had the following responsibilities:

Responsibility

Schema modification of the live databases

Handling production deployment

Implementation of various graphs

Database performance tuning

Environment preparation with maintenance

Provide on call support as and when needed

Managing incidents using Remedy tool

Operating System HP-UX 11.0, Windows 2000/XP

Technology Unix, SQL*Plus, ORACLE 8i/9i/10g

Location Kolkata, India

Mastek Oracle COE

Project Title

Client Mastek Ltd

Period Mar-2005 to May-2005

Position Software Engineer

Role and

Responsibility Database performance tuning

Database back up technology

SQL methodologies

Operating System Windows 2000/XP

Technology SQL*Plus, ORACLE 8i/9i/10g

Location Mumbai, India

Complain Lodging And Retrieving Software

Project Title

Client Indian Oil Corporation Limited

Period Mar-2003 to Mar-2005

Position Web page developer

The Project The system was designed in such a way that an employee of

an organization can lodge a complain online and can

retrieve the status of the same problem online itself.

Maintenance engineers can see the problems and resolve it

within themselves. Hence employees can solve their

hardware problems sitting at their desk only.

Role and

Responsibility As a developer, I had the following responsibilities:

Requirement analysis

Web page designing

Schema changes of the databases

Implementation of various web pages

Database performance tuning

Environment maintenance

Operating System HP-UX 11.0, Windows 2000/XP

Technology ORACLE 8i, HTML, ASP

Location Kolkata, India

Educational background Major and Specialization

Bachelor of Technology ( B.TECH ) Computer Science & Engg

Contact this candidate