Informatica, Oracle, AWS Redshift, Teradata, Python, Tableau

*

Summary Statistics

Skills -> Years

• Over ** years of Business Discovery, Data Discovery & Analysis, Data Modeling, ETL Design, Development, Testing, Implementation and Troubleshooting in the field of Data warehousing and Application Development.

• Domain Experience - 5 years in Airlines, 2 years in Healthcare & Bank & 1 year each in Automobile and Oil & Gas Sector.

• More than 8 years of experience in Niche Technologies like Teradata, Informatica ETL Appliances.

• More than 7 years of experience In Oracle Programming & more than 1 year in SAP BO XI R2, Tableau 9/10.

• Proactively worked & provided tuning approach & contributed significant roles in Application Tuning.

• Played various roles on Projects that required Data warehouse/MDM Source consulting, which include DW ETL Architect, Program Technical Lead, and Project/Team Lead and Managerial roles with a maximum project team size of 50 Consultants.

• Proficient in analyzing business requirement & translate them into developer friendly design documents.

• Experience in DW/ODS Data Modeling.

• Designed & implemented end to end ETL Implementation.

• Exposure in Hadoop Architecture, Amazon Elastic MapReduce, Spark, Hadoop Streaming, Python programming.

• Exposure in Amazon Redshift.

Domain -> Years

Professional Experience

Technical/ETL/Data Architect Dec 14 – Till Date

Wipro Ltd, San Francisco Bay Area, CA, USA

Client - Apple Inc & Bank Of The West.

Working on niche technology as Technical Architect/Manager. Responsible for Analysis, Design, Development, Testing, and Implementation of DW ETL/MDM Source solutions for new implementations and upgrades.

• Providing solution design based on the discussion with BA at onshore & co- ordinate & distribute the task with offshore model across different locations.

• Deliver new and complex high-quality solutions to clients in response to varying business requirements.

• Directly handling clients along with the down-line business users in order to provide better solution design for the client.

• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

• Handling multiple roles including release management across different teams at onshore.

• Conduct Weekly Review Meeting with the Business Users.

• Handling Resources by Allocating task based on the availability. Roles -> Years

Satyaki De

355 Reflections Cir, Apt – 13, San Ramon, CA-94583 Email id : *********.******@*****.***

Cell: +1-804-***-****

Linkedin: https://www.linkedin.com/in/satyaki-de-7ab11413 2

Lead/Application Developer

Jan 10 – Nov 14

Awards & Achievement

IBM - USA, Hong Kong, India

Client - Cathay Pacific Airways, British Petroleum, Wellpoint

& TIAA-CREF

• Received a Special Recognition & Eminence Award – GBS-GD (Orion) from IBM in 2012 & 2013.

• Received Manager Choice Award in 2014.

• Received Onsite Assignee Top Contributor Award in 2014.

• Received Recognition & Appreciation Certificate from OTN for contributing to its Technical forum in 2015. Working on niche technology as Technical Manager/Teradata Specialist/Informatica Designer & responsible for analysis, design, development, testing, and implementation of ETL solutions for new implementations and upgrades.

• Directly handling clients along with the down-line business users in order to provide better solution design for the client.

• Coordinating & Preparing AID document once KT is started on various data marts as these modules are getting prepared for new development & enhancement for our team.

• Deliver new and complex high-quality solutions to clients in response to varying business requirements

• Responsible for managing scope, planning, tracking, change control, aspects of the project.

• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.

• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Education

Masters in Computer Application - IGNOU, India

Technical Skills

RDBMS: Oracle 9i/10g/11g

O/S: Windows NT/2000 Server, AIX, HP-UX 11.1, SCO UNIX, Red Hat Linux 5.0, Mac OS

Language: Pro*C, Oracle PLSQL 9i/10g/11g, Teradata BTEQ 13.0/14.0/15.0, Python

BI: SAP BO XI R2, Tableau 9/10

DW: Teradata 12.0/13.0/14.0/15.0

Columnar Database: Amazon Redshift

ETL: Informatica 9.5/10, Teradata 12.0/13.0/14.0/15.0 ERP: Oracle Apps 11i (OM Module), D2K

Certifications & Professional

Trainings

• Oracle Certified Associates (9i) from Oracle University.

• Completed Informatica Big Data Edition v10 at Wipro Ltd.

• Completed Amazon RedShift from AWS Lab.

• Completed Training on Tableau.

• Received Teradata 13/14 training at IBM India

• Received Netezza Appliances – IBM training at IBM India

• Completed Teradata SQL, Advanced SQL &

Fundamentals from Teradata Education Network at IBM India

• Completed HIPAA on Healthcare from IBM.

• Completed Advanced Analytics on Banking Domain on from Wipro.

• Received Cognos Reporting Solution 8.4 training at IBM India

• Received Informatica Power Center 9.0 training at IBM India

• Completed DWBI training at IBM India.

• Completed Data Modeling training at IBM India.

• Received Business Objects XI Release 2 training from Pragati Software at SkyTECH Solutions Pvt Ltd.

• Completed QMS Training at SkyTECH Solutions Pvt Ltd. Prior Experience

SkyTECH Solutions Pvt Ltd, WB, India (Dec 06 – Jan 10)

Role: Software Engineer

Client - United Airlines, American Airways.

Digital Domain India Pvt Ltd, Delhi, India (Jan 06 – Nov 06)

Role: Software Engineer

Client - Suzuki

Computec International Ltd, WB, India (Jan 05 – Nov 05)

Role: System Engineer

Client – Fusin Brand Ltd

Freelance Developer/Trainee Jul 04 – Dec 04

Laser & Cable Pvt Ltd, India

Working on one of the major government suppliers mostly in north & eastern India with their upgraded cables & other equipment. This inventory management system into the Oracle-based system for faster & better results that can be useful for decision-making purpose in order to evaluate business growth & failure reasons.

Languages, Misc

Language

• English

• Hindi

• Bengali

Miscellaneous

• Networking and Social Engagement

• Passionate Photographer

• Professional involvement in Oracle and Teradata

Community

• Public Speaking and Mentor Young Minds

Contact this candidate