Informatica B2B consultant

aRESUME

Name : Aswini Barik.

Mob : 864-***-****

EDUCATION

Title of the Degree with Branch College/University Marks

[ % ]

M.E. in Electronics & Telecommunication Bengal Engg & Science Univ, West Bengal 72.4

B. E. in Electronics & Telecommunication Utkal Univ, Orissa 62

XII Nimapara College 68

X Kakatput Highschool 73

TECHNICAL SKILLS

Operating System Unix, Windows 95/98/NT/2000/XP

Programming Languages SQL,

Databases & Tools Oracle 8i,DB2, Toad

Other Utilities Informatica 7 & 8, Informatica B2B DT , BPEL, Websphere MQ

Location Kolkata (India)

SUMMARY:

I have experience of 68 months in the software industry (as of Feb 2011). I have extensive experience in leading, mentoring design and development team of data warehousing project. His main expertise had been ETL . I was involved in Analysis, Design, Coding and Testing (Both Unit and Regression Testing) for Various Enhancement tasks and Bug-fix of Programs in the current application. Currently he is working as Data warehouse ETL lead in MetLife MCOMP project from July, 2010. He has played role of Onsite co-ordinator in his previous projects.He also has expertise in Informatica B2B, DB2 etc.

He has a very good experience in client handling. He is a strong team player with excellent inter-personal and client interfacing skills and the ability to quickly understand technical scenarios and formulate efficient solutions to meet complex technology needs.

EMPLOYMENT HISTORY :

Name of the Company Designation Address of the employer From To Duration(Years)

Cognizant Technology Solutions Associate USA Dec 14 2009 Till Date 1.3 years

Tata Consultancy Services Asst. Systems Engineer Kolkata July 2005 Dec 12 2009 4.5 yrs

PROJECT PROFILE:

Project Title Customer File Processing

Client MetLife

Duration Dec 2010 – Till Date

Location Metlife, Greenville, USA

Operating Systems Windows XP, UNIX.

Programming Languages B2B DX, B2B DT, Informatica 8.5.1, SQL.

Databases DB2 UDB

PROJECT DESCRIPTION:

CFP project’s objective is to automate Customer file processing. The speciality of this project is it is a product development to be used by Business analysts who themselves can do a lot of customization. File processing life cycle is going to be customization. Customer can create new file structures to be published. User can modify existing file structure and process a modified structure file without involvement of IT. This objective is being achieved by using un-orthodox Informatica tools like B2B. The technical aspect of the project involves lot of complexity from the angle of integrating multiple tools and technologies.

CLIENT DESCRIPTION:

MetLife (Metropolitan Life Insurance Company) based in US is a 140-year-old company and has its presence in 12 countries across the globe. It is the nation’s largest life insurance company with approximately $1.7 trillion of life insurance in force. MetLife provides individual insurance, annuities and investment products to approximately nine million households, or one of every 11 U.S. households. MetLife looks forward in increasing its policyholders from the current 43 million to 100 million in 10 years and to expand the individual channels through Banks, Brokers and to reduce the non-agent workforce by 5%. In order to achieve this goal and to serve its customers better and grow its business, MetLife has outsourced number of its application systems to Cognizant for better management and maintenance of the systems.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Working as a technology consultant in this project.

• Involved in the Requirement gathering and high level design.

• Handling the client calls, status meetings etc.

• Provide training to other offshore members

• Creating and maintaining project plans [Microsoft project Plan].

• Prepared Functional & Technical Specification Document.

EXPERIENCE IN THE TECHNOLOGIES USED:

Technology Experience (in month)

Informatica B2B DX, DT, DTA 6

Informatica 8.5.1 4

DB2 0

Unix 0

PROJECT PROFILE:

Project Title Business Planning & Manager compensation

Client MetLife

Duration July 2010 – Till Date

Location Cognizant, Kolkata, India

Operating Systems Windows XP, UNIX.

Programming Languages Informatica 8.5.1, SQL.

Databases DB2 UDB

PROJECT DESCRIPTION:

MetLife MCOMP project is a Data Warehousing Project. In Metlife Manager’s compensation is projected and planned basing on previous revenue & expense statistics. Data warehousing part of this project is about generating reports with dashboard view presenting lots of statistics related to Manager compensation. Data is being pulled from multiple heavy weight source systems on to datamart through staging layer. Various types of sources like files, database and mainframe are involved.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Worked as ETL lead in this project.

• Involved in the Requirement gathering and ETL end to end design.

• Handling the client calls, status meetings etc.

• Prepared System Understanding & Process Handbook Document which contains the detail description of Project, Process, Data warehousing applications etc.

• Provide training to other project members

• Creating and maintaining project plans [Microsoft project Plan].

• Prepared Functional & Technical Specification Document.

• Prepared ETL Design & Development approach document.

• Reviewed the code to maintain proper logic implementation/quality standard.

• Created unit test case documents and performed unit testing & resolved issues.

• Support the System Testing and Defect fixing.

• Implementation in the Production Rollout.

EXPERIENCE IN THE TECHNOLOGIES USED:

Technology Experience (in month)

Informatica 8.5.1 6

DB2 6

Unix 9

PROJECT PROFILE:

Project Title MetLife Fidelity UDX

Client MetLife

Duration January 2010 – July 2010

Location Cognizant, Kolkata, India

Hardware Dell Desktop.

Operating Systems Windows XP, UNIX.

Programming Languages Informatica 8.6.1, Informatica B2B DT , SQL.

Databases DB2 UDB

PROJECT DESCRIPTION:

MetLife Fidelity UDX project is an ETL Project. Fidelity is a third party organization through which MetLife sells some of its products. As a result, to move the data between Fidelity to MetLife (and vice versa) this project is implemented.

For this Informatica DT/DXX new tool is required. Everyday Fidelity will send some ACCORD XML files and the from the ACCORD XML files, some cobol copybook files need to be created. Informatica DT/DX is required to create the flat files. Apart from that some information need to be entered into the DB2 databases. It is completely new technology and it is Cognizant’s first of this kind project.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Worked as Module lead in this project.

• Creating and maintaining project plans [Microsoft project Plan].

• Handling the client calls, status meetings etc.

• Prepared Functional & Technical Specification Document.

• Worked in Informatica B2B Data Transformation.

• Worked in Informatica 8.1 – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.

• Created unit test case documents and performed unit testing & resolved issues.

• Created Unix shell scripts for Informatica Mapping run, FTP, archival etc.

• Support the System Testing and Defect fixing.

• Implementation in the Production Rollout.

• Production Handover Training.

EXPERIENCE IN THE TECHNOLOGIES USED:

Technology Experience (in month)

Informatica 8.6.1 12

DB2 6

Informatica B2B DT 12

Unix 9

PROJECT PROFILE:

Project Title Scottish Water Integration support

Client Scottish Water

Duration March 2009 – Dec 2009

Location TCS, Kolkata, India

Operating Systems Windows XP, UNIX.

Programming Languages Informatica 8, SQL.

Databases DB2 UDB

PROJECT DESCRIPTION:

Scottish Water has many IT applications. All systems are integrated for data inter dependency . All systems transfer data via integration layer which is built using Informatica. Integration is very vital for Scottish water in meeting dead lines and achieving good KPI. Many day to day activity are dependant on continuous integration. All the interfaces need to be up and running all the time for all Scottish water internal and external operations.

As this is an integration project slippage or delay of one particular transaction from one system to another system delays the whole workflow and may warrant financial repercussions. This is why maintaining SLA for all calls were an absolute necessity.

Besides maintaining SLA communication had been an important part of this project where as continuous discussion with end user and business analyst is required in order to resolve the issues.

CLIENT DESCRIPTION:

Scottish Water is a big player in Scotland’s IT market. It has a vast IT system where most of the work is automated. Scottish Water is implementing many measures to increase customer satisfaction. Scottish Water IT system plays an important role in striving towards this goal. Scottish water does control water supply throughout Scotland both for domestic and commercial purpose. Along with water supply control it also controls sludge management both for domestic and commercial purpose.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Worked as Module lead in this project.

• Communicating with client on regular basis for understanding the problem and letting know the present status.

• Communicating with various system business analyst to understand the system and integration mechanism.

• Proposing modifications and enhancements to the interface for reducing production defects which in turn creates new enhancement projects

• Maintaining informatica, BPEL and MQ servers

• Delivering minor enhancements.

• Analyzing the problem tickets.

• Assign the problem ticket to one of the team member and mentoring throughout resolution

EXPERIENCE IN THE TECHNOLOGIES USED:

Technology Experience (in month)

Informatica 8.6.0 8

Oracle 4

Unix 8

BPEL 8

PROJECT PROFILE:

Project Title Scottish Water Integration Development

Client Scottish Water

Duration July 2008 – March 2009

Location TCS, Sterling , UK

Operating Systems Windows XP, UNIX.

Programming Languages Informatica8, SQL.

Databases Oracle

PROJECT DESCRIPTION:

Water supply and sludge release control across Scotland is controlled by Scottish Water. Central Marketing authority is the regulatory body for water supply and sludge management. Because of modified guidelines issued by CMA Scottish water had to rebuilt a big part of it’s data integration set up. This project involved end to end design of complex interfaces involving multiple technologies like Informatica, BPEL and websphere MQ. Many new interfaces were built as part of this exercise.

CLIENT DESCRIPTION:

Scottish Water is a big player in Scotland’s IT market. It has a vast IT system where most of the work is automated. Scottish Water is implementing many measures to increase customer satisfaction. Scottish Water IT system plays an important role in striving towards this goal. Scottish water does control water supply throughout Scotland both for domestic and commercial purpose. Along with water supply control it also controls sludge management both for domestic and commercial purpose.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Worked as Onsite co-ordinator and technical designer in this project.

• Participating in meetings, workshops to understand and document requirements

• Participate in regular calls with offshore for sharing the requirement understanding .

• Taking up and resolving queries from offshore by discussion with Business users , business analysts and other stake holders like QA team etc.

• Creating and maintaining project plans [Microsoft project Plan].

• Project estimation, impact analysis laying out end to end high level design.

• Preparing high level design ,

• Provide UAT support of the newly built interface.

• Provide production warranty support

EXPERIENCE IN THE TECHNOLOGIES USED:

Technology Experience (in month)

Informatica 8.6.0 9

BPEL 3

Websphere MQ 5

Oracle 9

Unix 9

PROJECT PROFILE:

Project Title 21CN KPI

Client British Telecom

Duration Nov 2006 – July 2008

Location TCS, Kolkata, India

Operating Systems Windows XP, UNIX.

Programming Languages Informatica8, SQL.

Databases Oracle

PROJECT DESCRIPTION:

The project is to measure the effectiveness of Operational processes in both Lead to Cash and Trouble to Resolve business functions by measuring and reporting upon key steps or stages in the end to end process. These measures will then feed into operational process improvements. Regulatory reports, billing reports, network infrastructure reports, wBC order and fault tracking, inventory reports, metrics that monitor the health of the network and reports upon the performance of a customer’s services have been designed.

CLIENT DESCRIPTION:

BT is one of Europe’s leading providers of telecommunications services. Its principal activities include local, national and international telecommunications services, higher-value broadband and internet products and services, and IT solutions. In the UK, BT serves over 20 million business and residential customers with more than 29 million exchange lines, as well as providing network services to other licensed operators.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Worked as Tech Lead in this project.

• Analyzing the Business requirements.

• Creating and maintaining project plans [Microsoft project Plan].

• Prepared Functional & Technical Specification Document.

• Prepared ETL Design & Development approach document.

• Reviewed the code to maintain proper logic implementation/quality standard.

• Worked in Informatica 8.1 – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.

• Reviewed the code to maintain proper logic implementation/quality standard.

• Created unit test case documents and performed unit testing & resolved issues.

• Support the System Testing and Defect fixing.

• Implementation in the Production Rollout.

EXPERIENCE IN THE TECHNOLOGIES USED:

Technology Experience (in month)

Informatica 7.1.2 21

Oracle 21

Unix 10

PROJECT PROFILE:

Project Title BBCR Terms & Conditions Reporting

Client British Telecom

Duration June 2005 – November,2006

Location TCS, Kolkata, India

Operating Systems Windows

Programming Languages & Tools Informatica8, SQL.

Databases Oracle

PROJECT DESCRIPTION:

BT’s Terms and Conditions include requirements to give visibility to Service Providers of the SLA related information they need to manage their business. In addition, SPs have requested access to a range of data that is not currently available to them. It reports near real time Order and Fault progress (based on the Broadband Customer Reporting model) to Service Providers and generate reports of new MIS/KPI Measures both internally and externally for Service Providers, Operational Users, BT Wholesale and BT Group. BIP development is being carried out in an onsite-offshore model.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Analyzing the Business requirements.

• Worked as developer in this project

• Worked in Informatica 8.1 – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.

• Involved in the development of Source to Target Mappings.

• Used most of the Transformations such as Source Qualifier, Aggregator, Lookups, Filters, Sequence generator, Joiner etc.

• Prepared Functional & Technical Specification Document.

EXPERIENCE IN THE TECHNOLOGIES USED:

Technology Experience (in month)

Informatica 7 16

Oracle 16

Contact this candidate