**** ********* ******** ** **, Apt#***
Atlanta, Georgia, USA, 30328
Email id : *********@*****.***
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