**** ********* ******** ** **, Apt#***

Atlanta, Georgia, USA, 30328

Email id : ac6x0e@r.postjobfree.com

Cell: +1-404-***-****

Subhajit Basu

Profile

13+ years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.

Extensive experience with analysis, design, development, customizations and implementation of software applications including ETL Abinitio application in Big Data/Hadoop platform.

Proficient in analyzing and translating business requirements to technical requirements and architecture.

Very strong ETL skills in Abinitio, database skills, Unix Shell Programming, DW concepts and development knowledge

Currently working as a Technical Project Manager/ SME/Lead to handle multiple complex projects in ETL Abinitio,Hadoop/Big Data Unix and SQL

Experience in leading and managing teams. Handled multiple roles – Application Architect, Technical Project Manager,Team Lead, Technical Lead, Senior Designer, Developer, Project Lead etc.

Executed software projects for Banking, Telecommunication, Healthcare industry

Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Skill Set

ETL Tools: Abinitio GDE 3.1/Co-op 3

RDBMS: IBM DB2, Oracle 8.1, MS-SQL Server 6.5/7.0, HIVE DB

Languages: Unix Shell Scripting, HDFS commands, Hadoop

O/S: Windows NT/2000 Server, HP-UX 11.1, SCO UNIX

Processes: IBM’s QMS (Quality Management System)

Other Tools: HP Quality Centre, HP ALM, WinSQL,JIRA

Education:

Bachelor’s in Mechanical Engineering - 2004, Jadavpur University, India,

Canadian Permanent Resident Visa holder and eligible to work anywhere in Canada.

Professional Experience

March 2016 – Till date Technical Project Manager/Senior Technical Lead/Project Lead/ETL Abinitio Consultant for Suntrust Bank, Atlanta, Georgia

As a Senior Technical Lead/Project Lead(Technical) responsible for source analysis,Hadoop file system analysis, create Abinitio framework and deliver high quality Abinitio ETL code on HDFS file system, support production implementation etc. Here are the primary duties that I am carrying out in the current project:

Work on bringing new projects, do the feasibility analysis, POC of the projects.

Work with source system SME/owners to understand the source data and how that can be sourced into the Data Lake for the bank.

Provide Abinitio consulting services and support design of ETL data load from operational and external environments to the business intelligent environment using Abinitio software on Hadoop HDFS filesystem.

Conduct business and technical studies, design, develop, integrate and implement, support business software

Perform software development activities on operating systems such as UNIX, Windows, Sun Solaris,HP unix and on HDFS file system

Work with Production Support Team to support production implementation of projects.

Utilize relational database servers such as MS SQL Server, DB2 family, Oracle for the smooth execution of the operation.

Provide advice on information systems strategy, security and service delivery

Adhering to best practices for project support and documentation.

Performing operational Project Management activities like forecasting, invoicing, audit, accrual, billing, PCR etc.

June 2014 – Mar 2016 Senior Technical Lead/Project Lead/ETL Abinitio Consultant IBM India Pvt. Ltd.,Kolkata, india

July 2012 – May 2014, Project Lead/ETL Abinitio Consultant IBM Canada. Ltd. Toronto, Canada

May 2011 - July 2012 ETL Tech Lead IBM India Pvt. Ltd.,Kolkata, india

As a Senior Technical Lead/Project Lead(Technical) responsible for Analysis, mapping, design, development, testing and implementation of ETL Datawarehouse solutions for new implementations and upgrades for our TD Canada and US banking business. Also responsible for carrying out operational Project Management activities.

Confer with clients to identify and document requirements for data warehouse and business intelligent environments.

Provide Abinitio consulting services and support design of ETL data load from operational and external environments to the business intelligent environment using Abinitio software

Conduct business and technical studies, design, develop, integrate and implement, support business software

Perform software development activities on operating systems such as UNIX, Windows, Sun Solaris, and HP-UX etc.

Utilize relational database servers such as MS SQL Server, DB2 family, Oracle for the smooth execution of the operation.

Provide advice on information systems strategy, security and service delivery

Adhering to best practices for project support and documentation.

Performing operational Project Management activities like forecasting, invoicing, audit, accrual, billing, PCR etc.

Environment: Ab Initio Co-Operating System v3.15/GDE 3, HP-UX v11i, IBM DB2, Oracle 10, HPQC,Citrix

Team Size : 30 to 40

Mar, 2011 – May,2011 Senior Software Engineer Accenture Services Ltd, Mumbai, India

Vodafone,UK project involved building new data warehouse to house the retail billing data for the customers. My role is as follows:

System Analysis, Designing Technical documents as per client’s requirements.

Preparing high level ETL load mapping documents.

Code reviewing from the quality and performance point of view.

Actively participated client teleconferences, often chairing them for the team.

Interacted effectively with client over various issues and have also received client appreciation.

Team leader activities like attending calls, reviewing each and everyone’s performance on a daily/weekly basis.

Joining stand-up calls.

Attending client calls.

Environment: Ab Initio Co-Operating System v2.15/GDE 3,HPUX, Oracle 9i, MS SQL

May 2010 – Mar 2011, Information Technology Analyst Tata Consultancy Services Ltd., Kolkata, India

The project involved maintenance and production support of the ETL applications/interfaces of Kaiser Healthcare Management, USA.

System Analysis, Designing Technical documents as per client’s requirements.

Preparing User Manual, Documenting test results.

Code reviewing from the quality and performance point of view.

Production support activities of ETL processes

Successful resolve of tickets for ETL application failures.

Actively participated client teleconferences, often chairing them for the team.

Interacted effectively with client over various issues and have also received client appreciation.

Team leader activities like attending calls, reviewing each and everyone’s performance on a daily/weekly basis.

Joining stand-up calls.

Attending client calls.

Appraising the team members

Environment: Ab Initio Co-Operating System v2.15, HP-UX v11i, IBM DB2, Oracle 10, Remedy,Citrix

May 2005 – May 2010, Information Technology Analyst Tata Consultancy Services Ltd., Kolkata, India

The project involved maintaining the billing applications/interfaces to Geneva (Telecom Billing Engine) to bill the wholesale customers of British Telecommunication, UK.

My responsibilities were

System Analysis, Designing Technical documents as per client’s requirements.

Preparing User Manual, Documenting test results.

Code reviewing from the quality and performance point of view.

Successfully solved bridge cases in case of failure or anomalous behavior of project applications on the LIVEBOX.

Actively participated client teleconferences, often chairing them for the team.

Interacted effectively with client over various issues and have also received client appreciation.

Team leader activities like attending calls, reviewing each and everyone’s performance on a daily/weekly basis.

Joining stand-up calls.

Attending client calls.

Environment: Abinitio Co-Operating System v2.15, HP-UX v11i, Oracle9.2, Geneva v5.3

Contact this candidate