Etl Developer Associate

Surajit Dhar

Phone: +1-469-***-****

Email: **************@*****.***

Experience Summary

Having total 19+ years of experience in the full software development lifecycle. Worked as Cloud Integration architect (Boomi)/ETL Lead/ETL Solution Architect since last 7+ years in Could Integration Architecture/ ETL Architecture.

Proficiency in architecting/designing the Cloud technology(Boomi)/ETL environment. ETL tools, Data Ware Housing and their design & Development using Informatica.

Experienced in integrating enterprise applications using Dell Boomi for platforms like SAP/Oracle EBS.

Configured API’s, processes and jobs using Dell Boomi platform.

Experience in developing processes/frameworks as per requirement using different connectors, set properties, Decision shape, Branch, Try/catch shape, Data Process, Document cache, return document.

Experienced in directing client as a technology partner for implementing content management solutions for their needs.

Provided time and resource estimates for the client for the specific business requirements.

Ability to conceptualize, launch and deliver simultaneous complex technology projects in a variety of verticals.

Proven expertise on Systems architecture, analysis, technology evaluation, design, development, and deployment of strategic information systems / Client Server based systems for Manufacturing, Pharmaceutical, Finance and Government sectors.

Effective team player with excellent communication, team/individual management, leadership, project management, analysis, problem solving, presentation, interpersonal, organizational and client interface skills.

Hardworking, progressive, confident, and inspirative in attitude.

Technology

Platform

Software Products/ Tool

Languages & Databases

Windows XP/7/8,

Windows server 2003/2008

Boomi, Informatica, Oracle Ware House Builder, Oracle, Forms Reports, Tivoli Workload scheduler, IBM BlueMix

SQL, Pl/Sql, Python

Education

Degree

Institute

Specialization

Master In Technology

University Of Calcutta

Electrical Engineering.

Certification

Certification

Dell Boomi Professional Architect

Dell Boomi Professional Developer

Dell Boomi Associate Developer

IBM Certified Application Developer – Cloud Platform V2.

Oracle Certified Associate(Pl/Sql). Oracle Certified Associate( DBA).

Paper(IEE,UK)

“Transient performance analysis of a switched resistance compound wound DC motor” =>http://ieeexplore.ieee.org/search/searchresult.jsp?searchWithin=p_Authors:.QT.Dhar, S..QT.&searchWithin=p_Author_Ids:372********&newsearch=true

Assignments

The details of the various assignments that I have worked are listed here, in reverse chronological order.

Client

Texas Instruments

Period

Oct 2017 to till date

Role

Boomi Technical Architect

Project

B2B Migration project

Description

Texas Instruments current B2B integration landscape comprised of multiple B2B, middleware and gateway products – GXS AI, TLE, IBM MQ, OpenText Bizlink, Axway and Custom scripting (awk and shell script). Out which some of them are not supported now. TI moved to a single EDI tool, GXS OpenText Bizlink and migrated some of the B2B interfaces to Bizlink platform. However, the product didn’t meet some of the key requirements of TI B2B solution.

The objective is to provide TI with a modern, capable, highly available B2B platform for the next 7-10 years that can handle anticipated company growth and meet identified business requirements. Also, to provide Strategic World Wide solution to install new B2B Gateway/Platform with Development, Test, Production and DR environments for use by the World Wide B2B teams (US, EMEA, Asia, Japan) and migrate all B2B interfaces to the new B2B platform. Current B2B platform is running on unsupported software.

Responsibilities

• Developing appropriate strategies for the implementation of the project

• Requirement analysis of the application to be developed.

• Developing frameworks in Boomi.

Reviewing application specific test cases.

• Conducting performance tests on the developed /enhanced application.

• Interaction with clients regarding delivery procedures.

• Understanding the overall business knowledge and implementing then in the application.

• Reviewing deliverables

• Assigning the work from functional & technical perspectives.

• Studying the existing operational process.

Building framework to connect SAP ( ERP system) using RFC connection or using BAPI.

Management of projects with respect to resources and costs

Provide resolutions to issues/disputes and address escalated matters

Ensure Process Compliance and Quality Management

Schedule and Effort Estimation

Resource Allocation

Review overall Offshore Deliveries

Participation in executive review with client and TCS management.

Skills

Boomi, Oracle, Pl/Sql, connectivity with SAP from Boomi

Client

J C Penney

Period

Jun 2017 to Sep 2017

Role

ETL Technical Architect

Project

SPD project

Description

Dashboards allow users to gain unique insights into KPIs and critical metrics. Displayed in simple charts and easy to read graphs, dashboards allow users to discover trends otherwise unnoticed when seen in the traditional paper reports and cumbersome spread sheets.

Combining through paper reports is time consuming, exhausting and most of the data is already stale. Dashboards pull data from multiple data sources in real-time, as it happens. Key information is put at the forefront for at-a-glance insights, not buried in multipage reports. To get a true representation of store performance and customer loyalty. customer and store performance data needs to be viewed together.

Responsibilities

• Developing appropriate strategies for the implementation of the project

• System and Requirement analysis of the application to be developed.

• Building application specific test cases.

• Conducting performance tests on the developed /enhanced application.

• Interaction with clients regarding delivery procedures.

• Understanding the overall business knowledge and implementing then in the application.

• Reviewing deliverables

• Assigning the work from functional & technical perspectives.

• Studying the existing operational process.

Skills

Informatica 9.6, Oracle, Pl/Sql

Client

Canon Europe BV.

Period

Aug-2014 to Jun 2017

Role

ETL Technical Lead

Project

ICC Project.

Description

At the moment Canon Europe is re-implementing Enterprise Resource Planning (ERP) system Oracle Applications. Canon Europe has outsourced her warehouse function to third party logistics. Within Oracle Applications Canon will administer all the stock movements done by the third party logistics To manage and administer the physical stock movements; set of interfaces is needed between the third party logistics system and Oracle Applications.

Responsibilities

• Developing appropriate strategies for the implementation of the project

• System and Requirement analysis of the application to be developed.

• Building application specific test cases.

• Conducting performance tests on the developed /enhanced application.

• Interaction with clients regarding delivery procedures.

• Understanding the overall business knowledge and implementing then in the application.

• Reviewing deliverables

• Assigning the work from functional & technical perspectives.

• Studying the existing operational process.

Skills

Informatica, Tivoli Workload Scheduler, Oracle

Client

McGraw-Hill

Period

Oct’2011 - Jul’2014

Role

ETL Technical Lead.

Project

Oracle Apps Implementations (Oracle R12)

Description

The Lawson Financials Replacement Project (also called Project 1) is focused on replacing the capabilities and functionality supported by the core Lawson applications and any extensions or customizations that have added to support the business requirements with an Oracle EBS solution. The objective is to leverage the leading practices that are embedded in the Oracle products and to deploy an “out of the box” solution minimizing the need for any customizations or product extensions. Scale the business to support global reach and international growth. Provide timely information and better business intelligence capabilities to manage the business. Improve data integrity and governance.

Responsibilities

• Developing appropriate strategies for the implementation of the project

• System and Requirement analysis of the application to be developed.

• Building application specific test cases.

• Conducting performance tests on the developed /enhanced application.

• Interaction with clients regarding delivery procedures.

• Understanding the overall business knowledge and implementing then in the application.

• Reviewing deliverables

• Assigning the work from functional & technical perspectives.

• Studying the existing operational process.

Skills

Informatica 9.6, Oracle, Pl/Sql, TWS

Client

KPMG

Period

April 2010 to Oct 2011

Role

Senior ETL Developer.

Project

Engagement Reporting & TIMEnX

Description

The Engagement Reporting (ER) application is a web site having 13,000 users which

provides T&E (Time & Expense), Payment and Revenue information for firm's

engagements in two different formats – Excel Workbooks and Business Objects. T&E

comments information is extracted from TIMEnX twice a month.

Receivables and Cash Payment information is extracted from the Peat (People soft

Finance) twice a month and processed in the ER application. There are 3 kinds of

users of this system – Engagement Partners, Managers& EMCs. Major functionalities

are as below:

1)Creation of Excel Workbooks

2)Business Objects Reporting

3)Delegation

KPMG uses the TIMEnX suite of applications which provides means to collect time

And expense data for its employees. It allows the review, update and approval of

data and ultimately provides that data to the financial systems for payment or

reimbursement. The application is available in both offline and online mode, so that

time entry can be carried out even while working disconnected.

Responsibilities

Requirement analysis

Design and Development of mapping

Design of relational database.

Creation of function, procedure and views in database

Build & Deployment

Unit Testing & Bug Fixing

Skills

Informatica, Oracle, Pl/Sql

Client

Sunlife Financial

Period

Sep’2008 - Apr’2010

Role

Sr. ETL Developer

Project

MCCSR Development Project

Description

The Current process of MCCSR OSFI reporting is implemented and maintained on excel sheets. The main excel sheets include MCCSR Part 1, Part 2 and the Capital Metric files. Present system provides very less flexibility to accommodate any change in MCCSR guidelines. Any addition of new company to be reported upon will need another 32 pages to be added for final printing. Objectives of new system is to support streamlined process and maintain uniformity in the received data.

Responsibilities

Gathering Requirements.

Analysis and evaluation of the requirements.

Design and development of Mapping based on the gathered requirement.

Carried out Unit testing.

Carried out performance testing.

Skills

Oracle Warehouse Builder, Oracle, Pl/Sql

Client

AIG

Period

Dec’2006 - Aug’2008

Role

Developer

Project

Personal Lines Claims System

Description

Personal Lines Claims System, PLCS, is a web-based system with a lot of business and technical enhancements over the existing client server application, to provide better solution and higher level of automation to its customers. The major business drivers for this system development are: - To reduce the over claim adjudication time, - To guide the customer in reporting the claim quickly and accurately, - To reduce the customer’s time on phone, - To provide better flexibility and convenience for claims reporting, - To achieve better productivity and - To maintain better data integrity and timeliness. PLCS system provides the necessary integration to improve accuracy, timeliness of data, productivity, cost-efficiency, effective management reviews, excellent collection of metrics involved in claims processing and better decision making. It has enhanced the claim service and reporting capability that is necessary to support the claim managers’ needs and also to efficiently / effectively service the clients.

Responsibilities

Requirement Analysis

Design and development.

Unit Testing & Bug Fixing

Skills

Oracle, Pl/SQL

Contact this candidate