Santanu Basu

ETL Architect and Datawarehouse Consultant

Cell : 203-***-**** Email:adgloh@r.postjobfree.com Farminton, MI 48335

PROFILE

Over 13 years of solid experience in Core data warehouse, cloud DW, analytics and business Intelligence.

Deep experience in providing technology leadership, architecture guidance in large global BI program implementations for fortune 500 customers across industries- Banking and Financial Service, Healthcare and Manufacturing.

Able to effectively translate business requirement into technical solutions with IT best practices

Develop customized client solutions and strategies through business architecture and transformative networking. Utilize various consultative assessments and methodologies to analyze client as-is situations and future requirements.

Equal exposure in Production support and development projects as Technical/Project Lead. Have experience to design and build data warehouse from the scratch.

Have been working as Assistant Consultant at Tata Consultancy Services for past 10 years. Worked as Programmer Analyst at Cognizant Technology Solutions approx. 3 years

SKILLS

EDUCATIONAL QUALIFICATION

Degree

UNIVERSITY

YEAR OF PASSING

Master of Science (Computer Science)

University of Calcutta, India

2007

Bachelor of Science (Computer Science)

University of Calcutta, India

2005

PROFESSIONAL EXPERIENCE

Project 1:

Project Name: SYNAM (Syndication Account Management) Development & Support

Client: Wells Fargo Bank, United States

Duration: Feb 2017 – Till Date

Project Description:

Wells Fargo acquired part of GE Capital business. As part of this acquisition, GE Capital’s IT systems need to be migrated to Wells Fargo in a lift and shift mode. On a high level the activities that are required for completing lift and shift are – Data Center setup, Application setup in non prod environments, Database setup and Migration, Integration with existing Wells Fargo Apps, SIT and Business Testing, Go Live and production support post Go live.

Role

Requirement gathering from the Wells Fargo business and accounting team; Feasibility analysis; Write up ETL architecture documents; Develop/review technical specification documents.

Maintenance, enhancement of SYNAM data model; Database management

Actively involved in SYNAM data mart and application server setup in prod and non-prod environments, NAS drive, data conversion, Autosys batch jobs.

Actively involved and supervised System and integration testing (SIT), User acceptance testing and Go-Live.

Onshore – Near shore – Offshore coordination, Team management. Co ordination with other Well Fargo IT team, status reporting to IT/business

Post Go live support - address failure of Production batch jobs, ad-hoc report generation based on business request, data warehouse performance monitoring

Establish best practices, standard operating procedures, migration checklist and other support documents, Enforce Agile methodology for future enhancements.

Project 2:

Project Name: OFSAA (Oracle Financial Service Analytical Application)

Client: GE Capital HQ, Norwalk, United States

Duration: Aug 2013 – Jan 2017

Project Description:

Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) provides the core foundation for delivering the Oracle Financial Services Analytical Applications, an integrated suite of solutions that sit on top of a common account level relational data model and infrastructure components. Oracle Financial Services Analytical Applications enable financial institutions to measure and meet risk-adjusted performance objectives, cultivate a risk management culture through transparency, manage their customers better, improve organization's profitability and lower the costs of compliance and regulation. GE Capital bought this product to meet its regulatory requirement to Federal Government, USA

Role

Requirement gathering from the GE Capital treasury business, feasibility analysis and writing technical documentation

Worked as data architect, data modeller, Informatica administrator and infrastructure lead during the build phase of OFSAA

Joined production support team after OFSAA first Release went live and became overall technical lead.

Was responsible for root cause analysis of failure of Production jobs, coordinating with upstream system owner and IT managers and for small enhancement project.

Project 3:

Project Name: UTCFS BI Support

Client: United Corporation Fire & Security

Duration: Jul 2010 – Aug 2013

Project Description:

UTC Fire & Security products provides innovative electronic security and fire safety solutions that help secure and protect people, assets, communities and infrastructures. It is offering ongoing partner support and a comprehensive portfolio of products including fire detection, intrusion detection, access control and video surveillance, UTC Fire & Security Products is the single-source provider to meet existing and future security needs of a broad range of customers.UTC Fire & Security is part of UTC Climate, Controls & Security, an unit of United Technology Corp

Role

Involved in design, development of ETL for small/large enhancement project and BO report and dashboard based on ad hoc request.

Write up technical specification documents

Informatica administration and Business object administration.

Monitoring daily ETL and reporting jobs, creation of new jobs/reports/ETL based on business request

Creating standard SOPs and involved in automation project which save times and human effort simultaneously.

Project 4:

Project Name: ClaimSphere

Client: Healthnet, United States

Duration: Feb 2009 – Jul 2010

Project Description:

Health Net, Inc is one of the largest fortune 500 health care companies in America. It has almost 30 years of health plan experience. The company provides various Health Plans via tailored programs for group, individual, Medicare, Medicaid, TRICARE and Veterans affairs etc. HN is looking for a performance management solution through measuring specific and significant Key Performance Indicators (KPI), which has become an integral part of its requirements.

Roles and Responsibilities:

Analysis of the Requirement docs sent from Onsite

Development of Business Object Dashboard & WEBI Reports

Design and maintenance of Healthnet data warehouse

Ensure quality of deliverables by following pre-defined standards and templates

Develop, maintenance of supporting documents

Project 5:

Project Name: CARAT

Client: Credit Suisse Financial Service, Switzerland

Duration: Aug 2007 – Feb 2009

Project Description:

It was a small enhancement project is to process the new requests of the business users and to implement them in different subject databases like accounts, references, credit and risk, payments. The data is being loaded from the different feeder files, which comes from Mainframe environment. Credit Suisse has 900 feeder files processed on daily basis. Each feeder file contains high volume of data, so the load should take the optimum time which is also a major goal for cognizant in this project

Roles and Responsibilities:

Analysis of the BSD docs sent from Onsite

Developing Informatica Mapping and Workflow, unit Test Plan and test cases

Ensure quality of deliverables by following pre-defined standards and templates

Day to day coordination between onsite and offshore from offshore.

LANGUAGES

Fluent in English. Moderate in Spanish, French & German

Oracle

Teradata

Microsoft SQL Server

Appworx

Autosys

JSON

Python

Ruby

UNIX shell scripting

Qlikview

Informatica Power Center/MDM

Infomatica Cloud

Hadoop Hive QL

IBM Data Stage

Business Object

OBIEE

OFSAA

Syndication Account Management

Snowflake

Tableau

Contact this candidate