Project Data
Resume:
PABITRA MOHAN BEHERA
Cell # 571-***-****
E-Mail:**********@*****.**.**
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