PABITRA MOHAN BEHERA

Cell # 571-***-****

E-Mail:acpcv6@r.postjobfree.com

Summary

> Overall 8+ years of professional experience in IT industry, with in-

depth knowledge and exposure in Design, Development, Enhancement

Cycles with Maintenance/Production Support, of Data warehousing and

Business Intelligence Applications based on Financial and

Statistical Data.

> Over 8 years of specific, current experience in Data Extraction,

Data Migration, Data warehousing and report generation using Ab

Initio

> Hands on experience on UNIX.

> Vastly experienced with various Databases like IBM DB2, Oracle

9.x/8.x, and SQL Server.

> Developed strategies for Extraction, Transformation, Loading (ETL)

processes using Ab Initio.

> Knowledge in IBM Rational ClearQuest ClearCase.

> Experience in designing and implementing complex Data warehousing

projects.

> Specific Areas of expertise in Business Intelligence & OLAP

Technology includes rich experience in providing ETL solution using

Ab initio 1.1x,3.1x, Co-ops 2.1x

> Worked on all components of Ab initio and developed complex graphs

and designs.

> Worked with Ab initio major components like partition, departition

and all multistage components.

> Experience working with SQL, PL/SQL, SQL*Plus, SQL*Loader, IBM DB2.

> Involved in 24*7 production support for ETL job runs and reporting.

> Worked on custom components to extract data from DB2 tables on

mainframe using BMC Unload process.

> Data warehousing Conceptual Expertise includes knowledge in building

and enhancing Data Marts and Warehouses, Data Modeling through Entity-

Relationship Model & Dimensional Modeling and Logical & Physical

Database Designing along with a Good overall Knowledge on the basics

of other Data warehousing Concepts.

> Experience in validation of Data warehouse and ETL process.

> Experience working with project analyst(s) to accurately interpret

requirements and develop solutions to meet specific deliverables

> Proficient with Tools/Utilities such as TOAD, Advance Query Tool.

> Have excellent analytical, problem solving, communication and

interpersonal skills, with ability to interact with individuals at

all levels and work as a part of a team as well as independently.

TECHNICAL SKILLS

ETL Tools: Ab Initio (GDE 3.15,3.13,3.0.3/ 1.13, 1.14.4), EME

Reporting Tools: Business Objects

Operating Systems: Windows NT 4.0, MS-DOS, UNIX (Sun Solaris, IBM

Aix).

Databases: Oracle 9i/8i/7.x, MS SQL Server 7.0/2000, MS Access

7.0/2000, SQL*Loader, SQL*Plus, Toad

Scheduling Tool: Autosys,Control -M

CLIENTS & WORK EXPERIENCES

VISA Inc., Foster City, CA

MARCH'14-Present Ab initio Developer

Perform DQ TOH balancing between datasets across environments and

between related load ready files. Generate alerts, score based on

severity and send in DQ Standard Interface File (DQSIF) to the Data

Quality Warehouse (DQW).The results will be reflected on DQ dashboards.

Based on results of POC, approach to be changed to DQ generating counts

vs using using in line operational audits.DQ balancing involves these

types:

Sanity Checks. The purpose of these checks is to identify issues for the

Hadoop datasets such as missing partitions. TOH (top of house)

Balancing. Balancing will be performed between datasets on TOH count and

amounts.

Roles and Responsibilities

. Implementing business logic in Ab Initio

. Review of Ab Initio Code with SME.

. Running graphs, Data matching and testing.

. Documenting the technical manuals.

. Developed various Ab Initio graphs every Business or Non-Business

releases.

. Consolidated graphs to have better control on the process using sub

graphs.

. Using partition component for partition the data and load it different

targets.

. Using Rollup, Sort, De dup sort, Join, Scan component to base on

requirement.

. Coordinating offshore-onshore model for requirement

Environment: Ab initio 3.1.3, Coops 2.14/2.15, IBM DB2,Unix Scripting

1

Mar'14

VISA Inc., Foster City, CA

GMR has established communication channels with D&B for daily Merchant

request- response, Monthly updates on DUNS, Monthly Corporate and Green

Files and Annual Baseline file as part of GMR- D&B Service. The service

also has the ability to create D&B requests on behalf of other Visa

applications/users and receive a consolidate response which can then be

passed on to the respective source system/ user. This process for VMPD

to initiate the D&B request, route it via GMR to D&B. messages &

delivery of them to VMPD.It consists of two parts i.e Intraday and End

of the day which comes under message type 900 series. We have used the

Abinitio continuous flow graph concept in our developments.

Roles and Responsibilities

. Implementing business logic in Ab Initio

. Peer review of Ab Initio Code.

. Running graphs, Data matching and testing.

. Documenting the technical manuals.

. Developed various Ab Initio graphs using continuous flow components.

. Consolidated graphs to have better control on the process using sub

graphs.

. Using partition component for partition the data and load it different

targets.

. Using Rollup, Sort, Dedupsort, Join, Scan component to based on

requirement.

Environment: Ab initio 3.1.3, Coops 2.14/2.15, IBM DB2,Unix Scripting

2

Dec'13 - Mar'14

VISA Inc., Foster City, CA

3 CMS- AMMF files are the key to the evolution of Merchant

identification and enrichment. Using the AMMF information, the

Merchant hierarchy can be extended to a higher degree of

accuracy. Merchant Attribute Table (MAT) is the key table to

store the AMMF information. MAT is going to house a variety

of Merchant attributes data from a multiple sources. Common

Merchant Services (CMS) initiative's objective is to create a

Global Merchant Data Store Merchant Attribute Table.To

accommodate all the information we have created processes

which need to generate VMSG information back to the acquirer

BIN/processor. This driver is to consolidate all the VMSG

information to generate one output file back to member once a

day/or week.

Roles and Responsibilities

. Interacted with business users at various levels and converted their

business requirements into technical specifications.

. Analyze and identify the Merchant information on the AMMF file and

MAT Table.

. Prepared Preliminary and Detail Design doc for VMSG Process.

. New Abinitio graph Developed of VMSG Driver with these vital

parameters values which will keep track of the graph start timestamp

as {CURRENT_VMSG_RUN_TS}. Graph will store ${LAST_VMSG_RUN_TS} and

${CURRENT_VMSG_RUN_TS} for each run cycle. Where It retrieve all

messages occurred between the ${LAST_VMSG_RUN_TS} and

${CURRENT_VMSG_RUN_TS}.

. Prepared the graph/job Migration documentation for QA and Prod

Implementation with the extended support for the Post Production

Release of the project as per the organization standards.

. Created one Unix job for this with with Abinitio Plan as per CMLS

Standard.

. Developed Unit test cases and created sample input data to test the

VMSG Ab Initio graphs and also provided QA support for the same.

. Involved in End-to-End testing of the process for verifying the

impacts caused due to the enhancements.

Environment: Ab initio 3.1.3, Coops 2.14/2.15, IBM DB2,Unix Scripting

VISA Inc., Foster City, CA

May'13 - Nov'13

Ab Initio

For this implementation, QMart will provide the DQ data to VISA Fleet

Business by the following metrics: L2/L3 data quality for weekly, quarterly

& monthly in CSV or MSExcel Format)

Currently QMart has L2/L3 data quality process and L2/L3 data quality

indicators are passed to the downstream applications, such as VISS, VMPD

and OTF etc. This project will not change the existing production

processing logic and new data quality indicator will not be passed to the

downstream applications. In the POC phase, process will use QMart C&S data,

instead of EDW data, for a 1 to 2 weeks period. The new data quality

indicators will be kept and aggregated in files, no impact to the

production processes and tables.

Responsibilities:

. Identifying Existing QMart L2/L3 Fleet Card from TC05 to TC50

Table and impact analysis done the graphs as per the updated

Data model.

. Prepared detail design doc for the L2/L3 Fleet DQ

. Involved in development of the new graphs which will generate

Weekly. Quarterly & Monthly Report Data from the Existing QMart

L2/L3 Fleet Card TC05 to TC50 Table (PURCHA & PURCHL).

. Generated DQ data from L2L3 Fleet Card DQ graphs accommodate in

MS Excel Format as Initial Report.

. Provide DQ Reports to VISA DQ Commercial Manager and VISA Fleet

Business Projects Manager(PMO)

. Involved in Unit testing of the new graphs.

. Involved in the documentation of the project as per the

organization standards.

Environment: Abinitio GDE-3.1.3, UNIX, IBM-DB2, IBM-Clear Case/Clear

Quest

VISA Inc., Foster City, CA

Dec'12 - April'13

Ab Initio

The project objective is to provide commercial issuers that utilize Visa

commercial information services a multifaceted view of the data being

processed at Visa. Qmart's implementation is to provide Visa commercial

portfolio metrics, i.e. data volume portfolio, for MSTR usage.

For this implementation, Qmart will provide the VCF data portfolio by the

following metrics:

. Transaction Volume Statistics (daily, month-to-date,

monthly, quarterly, yearly CSV)

. Program Spend Statistics (monthly, quarterly, yearly CSV by

card types)

. Top 10 MCC/MCG by Spend ( monthly, quarterly, yearly CSV by

MCC/MCG)

. Ticket Size Profile ( monthly, quarterly, yearly CSV by

transaction ticket size)

Responsibilities:

. Identifying downstream applications to MSTR and impact analysis

done for all the graphs as per the updated Data model.

. Prepared detail design doc for the VCD portfolio metrics

. Involved in development of the new graphs which will support VCD

portfolio Daily/Monthly data.

. Created new Unix Jobs for the VCD graphs.

. Created Implement/Turnover request and Turnover doc to QA and

Production in Clear Quest.

. Involved in Unit testing of the new graphs.

. Involved in check- in and check-out of the code using EME.

. Involved in designing the QA test approach.

. Involved in the documentation of the project as per the

organization standards.

. Involved in Unit and Integration and User Acceptance testing.

Environment: Abinitio GDE-3.0.3, UNIX, IBM-DB2, IBM-Clear Case/Clear

Quest

VISA Inc., Foster City, CA

Mar'11 - Nov'1

Ab Initio

This project preparing data files in Visa Commercial Format. For use by

data processing analysts and other individuals who are responsible for

sending or receiving Visa commercial information. Visa Commercial Format

supports Level 1, 2, and 3 transaction data. It can be used for Point of

Sale transaction data as well as data that have been enriched by matching

to other sources.

Responsibilities:

. Identifying downstream applications to MSTR and impact analysis

done for all the graphs

as per the updated Data model.

. Prepared detail design doc for the VCF 4.4 ETL upgrade

. Involved in development of the graphs which are all undergone

for change/Modify.

. Involved in Unit testing of the modified graphs.

. Created Implement/Turnover request and Turnover doc to QA and

Production in Clear Quest.

. Involved in check- in and check-out of the code using EME.

. Involved in designing the QA test approach.

. Involved in the documentation of the project as per the

organization standards.

Environment: Abinitio GDE-3.1.3, UNIX, IBM-DB2, IBM-Clear Case/Clear

Quest

TCS, India

Aug'10 to Jan'11

Abinitio

The implementation of the Merchandising System Remodel - Vendor /

SKU Simplification Project (VSS) will eliminate the D-type Vendor

by improving visibility to source of supply, the distribution

channel and the replenishment method. It will also eliminate the

redundant data setup required to support product moving through THD

distribution centers. This project will provide the capability to

group stores to support DC replenishment by eliminating the DC

Market constraint. Additionally, this project will decouple SKU

status from distribution and replenishment thereby redefining SKU

status assortment only. Finally, the project will utilize a

services-oriented approach to technology that will move the IT

organization to a more flexible architecture. Due to above changes

to the MSR some of the base tables undergone for change. Due to

this downstream applications of MSR got effected.

Responsibilities:

. Identifying downstream applications to MSR and impact analysis

done for all the graphs as per the updated Data model.

. Involved in development of the graphs which are all undergone

for change.

. Involved in Unit testing of the modified graphs.

. Involved in check- in and check-out of the code using EME.

. Involved in designing the QA test approach.

. Involved in the documentation of the project as per the

organization standards.

Environment:

Abinitio1.13, Oracle9i, UNIX, Control-M Scheduler, TOAD 8.5,Citrix

Client Machine.

TCS, India Nov'09 to July'10

Abinitio

The objective of the project is to provide Application Maintenance

and Support to J.P. Morgan Chase & Co (Bank One) Brokerage Dealer

Support Services (BDSS) for all of its applications. The scope of

the project will be determined by the JPMC team as the project

commences. The requirement is to carry out PSR-DSR development of

BDSS Applications. This project will be executed on a T&M basis and

the actual work to be carried out will be provided by the JPMC

project manager.

Responsibilities:

. Identifying downstream applications to MSR and impact analysis

done for all the graphs as per the updated Data model.

. Involved in development of the graphs which are all undergone

for change.

. Involved in Unit testing of the modified graphs.

. Involved in check- in and check-out of the code using EME.

. Involved in designing the QA test approach.

. Involved in the documentation of the project as per the

organization standards.

Environment:

Abinitio1.13, Oracle9i, UNIX, Control-M Scheduler, TOAD 8.5,Citrix

Client Machine.

Polaris, India June'09 to

Sept'09

Abinitio

Generate a statement that enables customers to access charges applied by

their Regional billing on a consolidated industry used format.

This statement is to be generated using the TWIST Bank Services

Billing (BSB) Standard format. Clients want their cash management

providers to report their activity in the standard industry format

globally, where their billing systems exist. The BSB is an electronic

statement, produced typically on a calendar month end basis that lists all

individual chargeable events that occurred during the month along with

summary totals.

Responsibilities:

. Analysis of the specifications provided by the clients. Graph development

using Ab Initio and Unix Shell scripts

. Automation of Abinitio graph using Autosys jobs.

. Testing unit testing & integration testing. Responsible for overseeing

the Quality procedures related to the project.

Environment:

Abinitio1.14, Oracle9i, UNIX, Autosys Scheduler, TOAD 8.5

Satyam Computer, India Dec'07 to

Oct'08

Abinitio

The Scope of this Project includes storing data in a new warehouse at

account level.

At present we store data in CDCI, CDCI Canada, Commercial and CDCIP4 at

transaction level i.e. for each transaction there will be one record

each, but this warehouse would store data on Account level i.e.

summarized transaction for each account. The Summarized information will

be coming in two feed files from an external source. The external source

for this warehouse is Argus. FDR will send the details to Argus which

will in turn apply some business transformation and send two set of

files as Fiscal and cycle feeds.

Responsibilities:

. Analysis of the specifications provided by the clients. Graph development

using Ab Initio and Unix Shell scripts.

. Automation of Ab initio graphs using Autosys Jobs. Testing unit testing

& integration testing.

. Responsible for overseeing the Quality procedures related to the Project.

Environment:

Abinitio1.14, Oracle9i, UNIX, Autosys Scheduler, TOAD 8.5

Satyam Computer, India July'07 to

Nov'07

Business Objects

The objective of this project is to describe the MARS Dashboard analysis

universe. This is the new universe which has been developed under the

scope of this project. MARS Project technology stack (MARS) supports the

GE Corporate Financial Consolidation and Reporting process. The primary

function of MARS is to receive and consolidate financial data from the

GE businesses and to provide highly controlled financial processing of

data and real-time visibility into financial results.

Responsibilities:

. Creating Universe.

. Create WEBI Reports.

. Create Dashboard Reports.

. Provide Daily/Weekly status updates to the Client.

Environment:

Business Objects 6.5, Application foundation 6.5,Toad 5,Oracle10g

Satyam Computer, India Sept'05 to

June'07

Business Objects

The project deals with Credit cards of the customers who have account

with the various clients like wall mart, JCP etc. The clients offer

different types of Cards to the customers e.g. Credit Cards, Gas cards

(used at gas stations), Shopping cards. GE Cards Maintains the data for

all the transactions by the cardholder for their clients. The

Transactional data from the OLTP systems is loaded into the data

warehouse every day. It provides a single view of Commercial, Operations

data and allows new applications to be added in a timely fashion with

reduced cost.

Responsibilities:

. Running of Daily, Weekly, Monthly Data Loads Ticket Solving at a regular

basis.

. Identify Root Causes of issues that arise and provide improvements to

remedy them.

. Provide daily status updated to the Onsite Co-Ordinatator.

Environment:

Abinitio1.14, Oracle9i, UNIX (Putty), Autosys Scheduler, TOAD 8.5

Employment History:

Organization Duration Role

RS Software India Ltd. 15/02/2011 to Till Date Senior Software

Engineer

US Duration: Mar 2014

to Till date

TATA Consultancy 09/11/2009 to Senior Software

Services(Teamware Soln) 20/01/2011 Engineer,Bangalore,India

Polaris Software Lab Ltd 01/06/2009 to Consultant

Mumbai, India 30/09/2009

Satyam Computer Services Ltd, 22/07/2005 to Sub Band S2

Bhubaneswar, India 24/10/2008

Contact this candidate