Data Manager

Objective: To obtain a challenging role as Data Modeler, Data Architect,

Technical Analyst in Enterprise Data warehousing /BI Analytics and

applying creative problem solving with Best Practices, Lessons Learned,

Corporate processes for SDLC implementation.

Summary: Mr. Chittuluru has over thirteen years of experience in DW/BI

Solutions, Master Data Management (MDM), Data Migration, Data Architecture,

Data Modeling, Application Development, Production Support. Mr. Chittuluru

has experience with various technologies ranging from DW Solutions, BI

Analytics, MDM/CDI (Customer Data Integration), Multi-dimensional OLAP, SOA

using web services on IBM WebSphere, Enterprise Applications, 3-tier

Client/Server etc. Mr. Chittuluru has industry experience including over

1.5 yrs at a major Healthcare Insurance company, 1 year of Fortune 100

Life Insurance Company, 6 years in Fortune 100 Pharmaceutical Companies (AZ

Sales & Marketing, Pfizer Global Manufacturing, Corporate HR, Finance 6

years in Finance & Mutual Fund Industries primarily as Systems Analyst, ETL

Lead developer designing, developing Informatica mappings, workflows in

DW/Datamarts & deploying them across various environments; Developing and

maintaining Siperian Mappings using lookups, cleanse lists, Match & Merge

using Match Rules, Validtion Rules, Trust Settings in Siperian Hub Console;

BI Report Developer developing Cognos ReportNet reports, developing

Framework Models from Catalogs and ERWIN Models, Migrating BI reports from

Actuate, Impromptu to CRN; QA Tester for J2EE Websphere application on NT,

UNIX, Client/Server developer and Application DBA.

Summary of Roles: Various roles while working as a Systems Analyst

including

. Data Modeler, Technical Data Analyst: (i) for IBC Enterprise data

warehouse AEDW, which is HIPAA compliant for electronic security, privacy

for PHI, PII data elements. Knowledge & familiarity with HIPAA

Transaction and Code Sets requirements (e.g. X12N 4010A1 and 5010) & ICD-

10 Diagnoses and Procedure Codes.

. (ii) for AZ Cornerstone CRM Project - Data Modeling for Product Master

data using Siperian, Erwin 4.x, 7.x, Oracle 9i/10g PL/SQL, Toad.

Supported Business Users/SMEs, Data Custodians by using complex SQL

queries (using UNIONs, JOINs, SubQueries, Groupings, expressions etc) to

identify data discrepancies, exceptions from various master data tables,

Cross-reference tables, Hierarchy tables.

. (iii) Pfizer Pharmaceutical Center Source (PCS) DW: Analyze data about

Global Customers, Product Sales data in PCS DW to redesign Product

Dimension to new requirements for changing GAN to LAN, add new attributes

etc.

. ETL Technical Analyst/Team Lead using Informatica, Siperian - AstraZeneca

Pharmaceutical S&M Cornerstone CRM Project - Product Master System DW,

Pfizer PCS DW, Metlife IDW Retirement & Savings DW/DM, Pharmacia/Pfizer

CHR DW for Stock Optionee data

. Report Developer using Cognos ReportNet - Metlife Instituitional CRDM,

Pharmacia/Pfizer CHR reports using Impromptu & Cognos ReportNet POC

. Application Manager for PHA/PFE Stock Option Client Server system -

Responsible for Working with Vendor for App/DB Upgrades, Internal User

Training, Demo & Documentation, Working with Internal/External users

providing periodic standard/AdHoc Financial, Compensation Reports,

Working with PwC Auditors during Stock Splits and Mergers, Work with HR

Compensation to get data for Executive Grants, Sales Performance Grants,

Worked with IT Manager, Business Owner to create SLA for Stock option

System.

. Application Manager for PHA FASTRAK, multidimensional OLAP Global

Budgeting application using Applix TM1 - User security, access setup,

User Training and Documentation, Application Maintenance (Knowledge

Transfer from core developers), Y2K / IQOQ certification for FASTRAK,

Load budget data from excel sheets into FASTRAK etc.

Education & Certification:

August 1993 Master of Science in CIS (Computer & Information Sciences)

Temple University, Philadelphia

2004 Informatica Certified Designer

1998. Microsoft Certified Solution Developer in Visual Basic & SQL

Server

(In Progress) Wharton Business Essentials Certificate Program (Saturday)

Training:

IBM MDM/BI Learning Week: Annual premium event covering latest trends,

technologies in MDM, BI Analytics, case studies, best practices, key tasks

& deliverables in Client engagements.

IBM 3 day training in new features and Stored Procedures in DB2 UDB

Version 8

Informatica 5 day developer training in PowerCenter/PowerMart 7.1, Member

of Informatica

Developer Network.

Cognos Academy (i) 5 day FastTrack developer intensive training in

ReportNet, Framework Manager,

Report Studio, Query Studio, Architecture,

Installation/Configuration, Administration, Security, SDK

(2005)

(ii) Cognos 8 BI Modeler (2007)

(iii) Cognos 8 BI Author (2007)

Employer Experience:

. IBC Enterprise Data Modeler for AEDW including HIPAA related Privacy &

Security implementation of PHI (protected Health Information) & PII

(Personally Identifiable Information) June 08-Current

. IBM Global Business Services: Lead Consultant, Practitioner - DW/BI,

March 2006 - May 2008

. Pfizer Corporation: Consultant - ETL Analyst, August 2005 - February 2006

. MetLife: Consultant - ETL Analyst/ BI Developer, June 2004 - July 2005

. Pfizer/Pharmacia: Consultant - ETL Analyst, OLAP, Client/Sever, March

1999 - May 2004

. Merrill Lynch: Consultant - Client/Sever Developer, Application DBA,

January 1998 - February 1999

. FAL (Funds Associates Ltd.): Application Analyst, August 1993 - December

1997

Professional Experience:

IBC (Independence Blue Cross)

June 08 - Current

Informatics (Enterprise) Data Modeler

As part of IBC2010 initiative, IBC is building an Enterprise-wide Data

warehouse with a goal of delivering the right information to the right

people at the right time. Before the Informatics Division was created, data

from IBC's day-to-day operations was housed in multiple databases managed

by different IBC organizations using diverse, sometimes redundant,

technologies. Informatics' vision was to improve on the data and

information management at IBC by centralizing data into a single Active

Enterprise Data Warehouse (AEDW). AEDW implements HIPAA related regulatory

requirements for PHI (Protected Health Information); PII (Personally

Identifiable Information) like Member, Person related specifics; Secure

Business content like specific Pharmacy Amounts, units etc. PHI is

individually identifiable health information related to Health care, Health

Condition, Payment for care and Identity etc. Organization currently using

HIPAA 4010A1 transaction set for Healthcare transactions ( like Medical

Claims-Professional (837P) etc.) and company is getting ready for Jan1,

2012 mandated compliance with 5010, which includes 700+ modifications,

primarily technical changes (adds, changes, deletes). Initiative includes

Internal Gap Analysis, major Core System Release in 2010 and Trading

Partner Testing in early 2011etc.

Today, the AEDW is a dynamic and complex system that provides a single

source for accurate and up-to-date company data. Currently, the AEDW

consolidates information across all lines of business and integrates data

from more than 35 source systems. The AEDW has replaced older repositories

and as a result has realized administrative cost savings each year through

reduced license and data storage charges.

Much of the data in AEDW is updated more frequently than was previously

available, with many daily updates including medical claims, pharmacy

claims, enrollment, authorizations, and lab results. The resulting

efficiencies are tremendous. For example, Informatics processes more types

of data in six hours every night than were previously processed monthly

over the course of nine business days for one of our older data warehouses.

In addition to the centralization, the AEDW provides consistent definitions

of data fields as well as allows specialized data views by stakeholder.

Hundreds of IBC associates access the AEDW more than 8,500 times each month

to generate reports on a myriad of topics including member risk,

profitability, and medical costs.

The AEDW includes:

Data from 31 subject areas such as: Customer, Product, Group, Member and

Enrollment; and Provider

One billion unique records

More than four terabytes (four trillion KB) of raw and summarized data

250,000 claims records loaded daily

Data Modeling Activities: The Data Modeler is responsible for developing

data models and working closely with all development resources in regards

to creating an integrated model comprising multiple business/subject areas

of the data warehouse. Responsible for maintaining and distributing

Logical, Physical ERWIN data models for Medical Claims Subject Area and

Financial/Actuarial Profitability Subject Area(Capitation Pay, Premium Bill

Amount, Customer Facing Financial amounts for Medical, Pharmacy Claims,

CTHP Amounts, Disease Management, Wellness, QIPS, Broker Commission Amounts

etc.)

Overall responsibilities include extracting business rules (business

processes, business entities, etc.) from the customer, Analyzing data from

Source System, Data extracts/sample, Current warehouse using complex SQL

and designing the associated model, and create all required documentation

to support, communicate, and validate the data model. The Data Modeler

will leverage the current software utilized by the Informatics division.

All models created should conform to the strategic goals of the

Informatics division and should have appropriate supporting documentation

(entity relationship diagrams (ERDs), business process diagrams, and

process flow diagrams, metadata, etc.).

SQL Queries: 1) In AEDW, 'Capitation Pay' table contains cap data like

Capitation Amount, surcharge contains data by member, by PCP provider, by

product/package coverage by fund type. Supported business data needs, by

running various complex SQLs using UNION, multiple INNER JOINs and some

Left Outer Joins (where appropriate),derived date calcs in the SELECT,

filters, GROUP BYs and HAVING as needed.

2) Cap_Pay table is joined to Grp_Mbr table which is joined to Grp table

and also joined to Grp_Mbr_Enrol_Sum table, Grp_Prod_Pkg_Cvg table.

Environment: TeraData v12.0 DB; IBM DataStage for ETL

O/S: Windows XP Professional, TeraData DB on NCR Server

Tools: MS Office2007, Excel, ERwin 4.3, 7.3, MS Project, Visio, TeraData

SQLAssistant, AQT (Query Tool)

AZ Global Pharmaceutical Company (through IBM Global): Next generation CRM

Project - Core Master Systems (MDM) - Product Master System

March 06 - May 08

Project Description: AZ is embarking on a multi-year program to

significantly upgrade, re-architect and integrate its information

management capabilities. The AZ vision for a new Commercial Architecture

includes Core Information Management which will be significantly enhanced,

with the introduction of formal customer, product and territory masters to

augment the existing PeopleSoft DB (which serves as the Employee master).

Customer Core Master system implements a robust and scalable Customer

Master solution that will link together information about all of its

customer segments (including physician / HCP profiles, managed markets,

payers, hospitals, outlets, federal accounts, and consumers / patients) and

provide a trusted, comprehensive view of customers to AZ in support of CRM

activities. The Customer Master solution will be integrated with syndicated

and proprietary data sources for each of the major customer types including

prescribers, payers, and hospital accounts. The Customer master solution

uses Informatica for source system data transformation, loading into

landing tables, Siperian MRM (Master Reference Manager) as the customer

master data management tool and Trillium software as the cleansing and

standardization tool.

Currently working as a Data Modeler/Technical Analyst in the next

generation CRM project for Product Master Core System. Product Master will

serve as an authoritative source for all AZ trade, Sample and competitor

products and AZ market definitions and will provide cross-referencing

information between various channels and external sources for the CRM

initiative of the CA project. The Product master solution uses Informatica

for IMS, internal systems data (flat files, .csv etc.) transformation,

staging and loading into landing tables, Siperian MRM (Master Reference

Manager) as the product master data management tool 1) for deduping,

matching and merging same product attributes from IMS (National,

Subnational) data, NDC11 data from internal SAP, Contract systems etc using

trust setting and match rules. 2) for maintaining relationships and

hierarchies between products at different levels 3) Product Master cross-

reference to source system identifiers and core attributes for Products &

Markets. Data is consolidated to Final Subject area and fed to ODS

(Operational Data Store) and to ADS (Analytical Data Store) for BI

Reporting.

Data Modeling Activities: Worked with Lead Data architect, Business users

to finalize data model for Product Master data with core attributes from

six primary sources, three secondary sources, Relationships between various

products at different levels, multiple hierarchies between them. Models are

maintained, enhanced and shared according to DM best practices, naming

standards with various DW/BI teams using various ERWIN 7.2 features like

Complete Compare, Name Hardening, Action Log, Forward/Reverse Engineering,

Report Template builder etc. Performed as-is and to-be analysis, Source-

system driven analysis, by studying data file layout etc. Data modeling

performed using ER Modeling, 3NF normalization rules, Dimensional Modeling

using Facts, Dimensions (Star Schema), multi-level dimensions (snow-flake).

Staging area contains Normalized/Denormalized ER Model, EDW/ODS contains

normalized ER Model and data mart with dimensional model.

Responsibilities:

. Technical analysis and specification, ETL development and implementation,

System test scripts and testing, fixing bugs and technical documentation

and other necessary assistance in deploying the project

. Lead efforts to develop and implement ETL code for Product Master System

(PMS), in addition to ongoing maintenance and enhancements of ETL

deliverables once in production

. Develop and maintain all PL/SQL, Informatica code within the Product

Master System.

. Provides guidance to external ETL resources during PMS Development,

system testing, implementation and maintenance. Works closely and

communicating with Offshore (India) development team

. Ensures all ETL related documentation is accurate, comprehensive, and

current.

. Work with Core Master Lead & with the data stewards to deliver timely and

accurate information to business users and exception reporting.

. Runs Product Master load and publish processes as part of future AZ DW

Center Of Excellence

. Perform Product Master Siperian exception reports, support activities,

one-time activities

. Transition Support: Lead and conduct Knowledge transfer sessions to

client's OSP partner with demos, shadow sessions, overview and technical

deep dive sessions.

. Worked on flat file loading into oracle using Sql Loader; ORACLE 10g Data

Pump for unloading oracle data to an external table (direct access flat

file) to be consumed by target system ETL processes.

Environment: Siperian XT Hub SP1, Informatica - PowerCenter/PowerMart

7.1.x, Oracle 9i/10g, PL/SQL, SQL*Loader, UNIX ShellScript, BEA Weblogic

8.1SP2, Trillium 6.2

O/S Windows XP Professional, HP UNIX

Tools: MS Access, Excel, ERWIN 7.2, 4.x, MS Project, Visio, Toad, AQT

(Query Tool)

Pfizer Corporation Aug 05 - Feb

06

PfizerCenterSource(PCS) Data warehouse: ETL Analyst using Informatica 7.x,

Oracle 9i, TOAD, UNIX, Data Model maintenance using ERWIN 4.x

Worked on PCS enhancements project involving web application in .NET, data

warehouse ETL, Microstrategy BI reports. ETL responsibilities include

modifying existing interfaces, mappings which load global customers, sales

data from flat files into staging tables to include new data created by

users in web application; Create new & Update existing informatica

mappings, UNIX shell scripts, Oracle SQL scripts to support new business

requirements.

Change Request, Data Model maintenance using Erwin 4.1: Worked with key

developers, business users to identify data model enhancements for PCS

application using Corporate Standards, Naming Conventions, Alter scripts

for DBA during development & application deployment. Distributed the

updated data model for the team as PDF and by published to Intranet as

HTML. Collected data model change requests from various groups and

maintained the versions of data model in Model Mart.

Project Description: PCS Data Warehouse application provides information

about product sales to various customers throughout the world. The Daughter

application provides a customer hierarchy to relate the sales data to

global customers. This enables the business to track and take necessary

actions regarding the business. The purpose of the PCS 2005 Enhancements

project is to re-write the Main PCS using the .net framework, re-design the

current product dimension to support the new business requirements for

products management changing from Global Article Number to Local Item

Number.

PCS application involves 3 oracle schemas PCSAPPS (15 tables), PCSDW (28

tables), PCSFE (14 tables). PCS Enhancement effort includes adding 5 new

tables, 1 updated table to PCSAPPS; Adding 2 new tables, 8 updated tables

to PCSDW; Modifying or maintaining 14 sql scripts, 4 shell scripts, 26

mappings, 5 workflows.

Responsibilities: 1. Responsible for the design and development of

Database applications using Informatica PowerCenter, Oracle, Pl/Sql and

UNIX shell scripts. Work with the user community and reporting team to

understand the requirements. Work with the data owners to resolve any

issues, which involve the direct interaction with the business. Responsible

for communicating with other IT groups in collecting the requirements and

also implementing the applications. Manages the integrity and reliability

of the data in the various data warehouse databases. Ensures consistency

and integrity in the various Data Marts. Develop and maintain the detailed

project documentation. Production Support as needed

METLIFE June 04 - July 05

Institutional Datawarehouse IDW/BI.

ETL developer using Informatica 6.2.2, IBM DB2 8 on AIX 5.1. Creation of

R&S (Retirement & Savings) DataWarehouse(Staging, ODS, IDW Dimensions,

Facts), Datamart (Dimensions & Facts). R&S initiative involves creating a

brand-new datamart and central repository of data supporting reporting

needs of R&S business. It consists of multiple components including 1)

Contract level Reporting - Collect and organize contract level data such as

deposits, withdrawals, expenses, transfers, Separate Account (SA) balances,

unit values and rate of return. Provide roll-up of SA data to the contract

level reporting. All contract level info. will be linked to Dun &

Bradstreet info. about the companies. 2) SA related reporting: Collect &

organize info. About SA such as daily unit pricing & Asset Listings 3)

Annuitant Level Reporting.

Project Description: Data feeds come from 4 different systems and a total

of 32 files. 16 files from FMS an internal mainframe based system and

loaded using COBOL Copybooks, 3 files from Avenue System, 2 files from

SSKC, 9 RS Coordinator files as .txt and .csv. RS IDW includes 9

Dimensions, 12 Facts, RS mart includes 15 Dimensions and 14 Facts. Datamart

Volumes for History Accounting Transaction Fact are 47 million,

TRSGEN_ACCT_MO_ROLL_VAL_PRFRM SNAPSHOT are 1305723 etc. Team of 3

developers and 1 Team Lead designed and developed all the mappings, using

Metlife ETL design guidelines, necessary to load 32 files to Staging Tables

with data conversion, Staging to ODS using Reject/Error processing,

NetChange logic, Current Record timestamp logic using complex UNION SQLs,

Left Joins, reading tables with Uncommitted read (-UR). Data is then loaded

into RSMart. ETL development includes Functional Spec. review, Creating

Mapping Design VISIOs, Test Cases and reviewing them, coding and unit

testing. After initial development mappings, workflows are migrated to

SYSTEST by creating UNIX directories for Source, Target, Cache, parameter

file folders, using various UNIX scripts to move files from landing area to

source folders, Shell scripts for Daily, weekly, monthly processing, Script

for verification of rejects, Creating Default rows, Setting connections for

RSIDW and RS_MART, creating email list and environment variables.

Role in the Project: Worked on mappings and workflows for 6 Staging, 6 ODS,

4 dimensions, 3 facts and RSMart mappings for 10 dimensions. Worked as a

backup for technical lead and working with Proj. Manager and coordinating

Migration activities with UNIX developers.

Tools: Datawarehousing is housed on IBM DB2 UDB 8.1 on AIX 5.2, Informatica

6.2.2, PowerBuilder, Quest Central for DB2, SYNCSORT for netchange

processing of very large history file load.

BI Developer using Cognos ReportNET 1.1MR2 for 1) Migration of Company

Lookup Actuate report to CRN to be called from J2EE application(CRDM) using

web services and SDK 2) Extending original POC done by Cognos and creating

Best Practices document 3) Worked as a backup for technical lead for

setting up user security, development servers for Reportnet Gateway,

Server, Content Manager etc.

The CRDM application is based on SOA (Service Oriented Architecture) and

will use webservices on WebSphere (CRN SDK call using java) to execute and

display the reports. The Customer Relationship DataMart (CRDM) is a

repository that provides comprehensive, complete and validated information

about our clients, former clients, and prospects, and the relationships

they have with MetLife. It serves Institutional Business and other MetLife

departments as the "one-stop" source of information about client

relationships, and has over 1,500 registered users across Institutional

Business and other Company Departments.

Company Lookup CRN: Current CoLkp report is an Actuate 5.x report with 19

sub sections (Active Products, Co Details, Financial Details, Financial

Scope - SBR, Financial Summary, Met Contact etc.) using various complex DB2

SQL. These sections were based on catalogs created using Impromptu 6.x. CRN

effort involved in migrating the catalog to Framework model using migration

tools from cognos. Project aimed at preserving the testing effort and perf.

tuning done on existing SQLs and hence executed in the model as pass-

through queries. Alternative approach (followed in a different project)

would be to create the FW model from ERWIN data model and create query

subjects for custom queries. 3 developers worked on various sections using

company template with headers, footers etc. and later consolidated into a

massive report of 19 sections to be called from J2EE CRDM application.

Role in the Project: Worked on cloning/creating 6 FINANCE sections from

Actuate to CRN using DB2 pass-through queries in CRDM Model. Worked as a

backup for technical lead and working with Proj. Manager, Business Analyst

and coordinating documentation for BestPractices/CRN Findings, Technology

Assessment of current and future ReportNET environment etc. Assisted users

and other Cognos administrator to resolve issues with existing cubes in the

ereporting application. Worked on moving the PPES gateway from NT to UNIX

using Cognos Configuration Manager. Worked on setting up security access to

the existing business cubes currently published to PPES TOC.

Tools & Current development environment includes RN Gateway, Server,

Content Store on Windows 2003 server (UAT/PROD planned to be on AIX 5.1),

data source is DB2 UDB 8.1, Client is DB2 v7.1 client, Actuate 6.x, Quest

Central for DB2 or PowerBuilder for checking DB2 SQLs, ERWIN

QA Tester, Stress and Performance Testing of CRDM J2EE webshere app on NT &

UNIX:

CRDM is a new J2EE application using SOA(Service Oriented Architecture) and

Web Services, and hosted as a WebSphere application. The application uses

the new BI Tool Cognos ReportNet to develop user reports which connect to

CRDM datamart on DB2 UDB Server.

Worked on QA testing of CRDM J2EE/Webshere application on NT & UNIX and

verify results and response times using different input vales for various

function points like Log In/Authentication (using SiteMinder, LDAP);

Company Search ( by Co Name, D&B number, Metlife Customer No), Match Method

(Begins with, Contains); Metlife Status ( Parent, Current or former client,

Prospect); Intermediary Lookup; Various Institutional Client Reports (Co

with D&B Indicator, Clients by NAICs, MSA Codes, Line Of Business - Dental,

Vendor Spend report); Intermediary reports; Sales Reports.

Role in the Project: S&P Testing involved creating test cases and test

scripts and simulating required number of virtual users for testing

application scalability, response time & Architectural shakedown (test new

architecture or component)

Pfizer Corporation March 1999 - May

2004

Senior Analyst in EOWIN & ETL Developer for GRW

July 2002 - May 2004

Corporate StockOption Office. Technical Analyst in supporting & accessing

various SO systems EOWIN(Express Options for Windows), Global Peoplesoft

HRMS, GRW. ETL/BI developer supporting and maintaining

GlobalReportingWarehouse data loads for Stock Options using Informatica

6.x, Trillium AEPs (ITDC external Module), PowerConnect for Peoplesoft.

Provided support for Legacy PHA SO system EOWIN (which has 27,000 global

optionees with around 70,000 grants in about 65 countries), Data interfaces

with Global Peoplesoft & EOWIN like weekly address changes from PS and

update optionee list monthly to PS for tracking address & status changes;

GRW (Global Reporting warehouse): Create custom reports as needed to access

Pfizer SO data using Cognos Impromptu Client/ReportNET and using Pfizer's

Global_DSS_Catalog & ERP Reports Catatlog etc. GRW is populated with

Merrill Lynch optionee data masterfile (flat file) weekly. Flat file and

data feeds from Internal systems like Optionee Data from Peoplesoft, feeds

from Legacy Systems like Legacy PHA & Legacy WL are loaded using

Informatica sessions, mappings & transformations like Sequence, Filter,

Expression, Sort, Aggregate, Lookup, Joiner etc. Worked with team creating

data cleansing mappings using TrilliumEP transformation developed in

Transformation Developer by selecting various I/O ports from 200+ available

ports like InputAddressLine1-10, Pr_gout_PostalCode (ZIP+4), delivery

Point, delivery address etc.

ETL - Informatica 6.x, SQL*Loader, PL/SQL, ShellScripts, Trillium AEPs for

Address Cleaning

. Extracted data from various disparate sources across the Corp HR

organization (Oracle, SQL Server, Flat files) and loaded to staging

area on Oracle in order to remove inconsistent and redundant data

. Maintained and modified mappings as per changing user requirements

. Used VELOCITY BestPractices like Parameter file for dynamically

changing DB Connections, File Locations (Input, Session Log), Mapping

variables etc. for Informatica sessions.

. Used PowerConnect for Peoplesoft to access XLATTABLE data, core data

using ERP SourceQualifier.

. Designed complex mappings to implement the technical specifications

for the data transformation and load processes. Tested mappings,

identified bottlenecks and used best practices for tuning mapping

logic.

. Tuned session performance through use of cache memory, index cache and

session partitions.

. Automated scheduling of sessions and batches shell scripts using pmcmd

command.

Environment: Informatica - PowerCenter/PowerMart 6.2, Oracle 9i/8i, SQL

Server 2000, PL/SQL, SQL*Loader, UNIX ShellScript, Cognos BI 6.x, 7.x -

Impromptu, IWR, PowerPlay, ReportNET.

DataCleansing: Trillium ITDC External module with Parser, Postal/Census

Geocoder.

O/S Windows 2000/NT, Sun Solaris

January 2002 - June 2002

Worked on SalesForceAutomation system loading data from external systems

like CSD details from Dendrite into ODS and IDS using Informatica, UNIX

Shell Scripts, PL/SQL, SQL Loader etc.

USMC Sales Force Systems: Worked in a team designing, developing, migrating

& upgrading legacy ETL routines (using PL/SQL & SAS data step and MACRO

etc.) used in PHARMACIA SMIS (Sales & Marketing systems). SMIS system

performs the following main functions: Sales Force & its alignment; Input

data from various sales related information such as Rx info. from external

vendors (IMS Health), process the info. and make it available to BAs;

Gather and process Call, Sample and Detail info entered by Sales Rep in

Dendrite SFA system; Support the sampling activities. SMIS system gets

marketing data (Rx info from various products by physician, Target

physicians for a product etc.) from the vendors, performs data

manipulations & generates meaningful info. for the marketing group & sales

reps. Data is sourced from vendors like IMS Health, AMA, AOA. The data

comes via VPN established between IMS Health & PHA. Data is then formatted

with the help of COBOL II programs on IBM DB2. Flat files are created and

are loaded into ORACLE on UNIX Sales DW using Informatica ETL. The

targeting data reaches sales rep's laptop so that they get a list of

physicians in their area that they should target.

Environment: Informatica - PowerCenter/PowerMart 6.x, Oracle 8i,

PL/SQL, SQL*Loader, UNIX ShellScripting;

O/S: Windows 2000/NT, Sun Solaris

March 2000 - December 2001

Global Compensation & Benefits, StockOption Office: Worked as Senior

Analyst in Global HR systems like EOWIN for SO; Global Peoplesoft;

MercerPRISM for Global Compensation; MGDS for Global Benefits; Business

Objects Report Developer using Personal Universe, Benefits Universe etc.,

for Global Comp & Benefits

. Maintained Stock Option system, with 27,000 optionees across 65 countries

(Around 20,000 optionees with outstanding options) and 65,000 grants,

during various mergers and system migrations involving various grant

types - ISO,NQ, RESTRICTED, SARs, RELOADs etc., and various exercise

types - CASH, CASHLESS, STOCK SWAP, RESTRICTED LAPSE, SARs etc. Performed

various complicated System Migrations like data merging, data translation

& clean up, data separation between ExPNU EOWIN, ExMON EOWIN, SSB System,

Peoplesoft System during the course of company's Mergers. Loading various

Annual grants - Management Grants, NewHire/Performance Sales Grants, and

off cycle/ ad-hoc grants like New Hire/Restricted Management Grants etc.,

Provide ad-hoc reports from EOWIN & related systems, for various requests

received from Upper Mgmt, Country HR/Finance contacts, Corp.

Legal/Finance/ Accounting depts.; Provide periodic reports - Monthly,

Quarterly, Annual, Ad hoc, to Finance/Accounting /Auditors.

. Worked in Corporate Comp & Ben as an analyst working on TC2000,

collecting AIP target info. from various countries and process and load

them into Mercer Prism database. Worked on Global Benefit's benefit

policy collection & cost analysis project, collecting country level

details on benefit policies like Retirement Plans, Plan Financing/FAS87

figures, Term/severance etc., and loading them into MGDS. Worked on

Global Comp & Ben BI system as report developer using MSAccess, Excel, BO

Personal Data Universe, Benefits Universe etc., with data populated from

extracts from Global Peoplesoft. Created various Global comp & Ben

reports using various features of Business Objects Report Building like

Using Objects, Classes, Universes; Using query conditions; combining data

from multiple sources, multiple blocks in a document; Using functions &

drill techniques etc.,

March 1999 - February 2000

Worked as Application Manager responsible for setting up security for

various countries & various Market Companies (responsibility),Application

Maintainence, User Training/Documentation etc. Developed Impromptu reports

accessing Fastrak data for US Users.

FASTRAK is a global budget collection tool, based on multi-dimensional OLAP

technology, to collect detailed budget line items for all business units in

about 60 countries around the globe. Part of the development team during

Kick-Off meeting presentation; developing cubes, dimensions, elements &

deploying them to production; developing front-end app in VBA & Excel

connecting to & report from FASTRAK MDDB, End User training for various

world regions US/EUR/AP/LA.

Fastrak app. consists of Applix TM1 MDDB & Excel. TM1 interface is an excel

add-in. App will reside on client server in Kalamazoo & accessed through

Citrix Metaframe. Data input occurs in excel & stored directly into a

central MDDB and instantly accessed by all users at both low & higher

consolidated levels. All inputs are stored in a log file for instant

recovery. Fastrak budgeting system is used for Account (Hyperion) level

budgeting. Input to new budget system will be at RESPONSIBILITY (MarketCo)

level rather than at Legal Entity level as in Hyperion. As a result input

is not required for inactive Reporting Units or LEs which only have inter-

company transactions. Fastrak data was fed to Cognos reporting system for

US Finance Users using PowerPlay 6 & Impromptu 5.

Merrill Lynch January 1998 - February 1999

Application DBA/Developer

Project: Data Mart Creation and System Migration from a huge GoldMine

database (dBase) to Oracle based App. for ML Investor Services for about

100,000 customer records.

. Worked as Application DBA supporting Oracle DB on Unix for this high

visibility, mission critical graphical application using cutting edge

technology for ML Investor Services Dept. State of the art application

was built using n-tier architecture in MS technology (VB/MTS, Voice

etc.,) with GUI and eventually with a web interface. All the tables are

in Oracle 8 DB on Unix in Production & Oracle/NT for local development.

. Responsible for migration of huge amounts of data from legacy Customer

system in Goldmine into Oracle DB using the ETL tool DataJunction for

Cleaning, Transforming & Loading with complex business rules for

transforming data. Provided daily support of Oracle DB during development

phase of application, tuning the application SQL & improving the

Performance of SQL. At a later stage, transactional data from MERLYN

Oracle DB was transformed and loaded into a MERLYN datamart star schema

using Informatica.

FAL (Funds Associates Ltd.) August 1993 - December

1997

Application Developer using VB, Access, Crystal Reports

The company's flagship product SuRPAS is rated as one of the best in the

country in Mutual Funds Magazines. The company provides software services

to Mutual Funds Transfer Agencies, Brokerage Firms, Banks etc. SuRPAS

(Shareholder Retirement Planning and Accounting System) running on Digital

VMS on VAX and Alpha provides industrial strength processing and

functionality (Also available on SQL Server & Oracle) and the software can

be customized to fit in to client's business. Current clients include

Charles Schwab, Dean Witter, Wells Fargo, American Express etc.

Project: Sales Tracking System:

. Lead developer for company's first Client/Server graphical windows

application developed using Visual Basic, Access and Crystal Reports.

This provides the reporting capabilities depending on the Dealer, Branch,

Representative and other selections made by the user. Designed and

developed canned business reports and provided the capabilities for ad-

hoc reporting.

. Lead developer for the entire project and worked closely with project

manager about design and implementation and Marketing Manager for user

requirements

Contact this candidate