Software Developer Data Warehouse

PROFESSIONAL SUMMARY

** ***** ** ********** ** Business Intelligence, Data warehouse

Designing & Implementation, Technical Guidance & Team Management. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy. ACCOMPLISHMENTS

WORK HISTORY

IT Specialist, 11/2009 to 07/2015

IBM India - Pune, India

Senior Software Developer, 09/2007 to 10/2009

Patni Computer Systems - Mumbai / Pune - India

CONTACT

Address: Charlotte, NC 28278

Phone: 470-***-****

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

WWW: linkedin.com/in/deepanjana-bi

swas-patil-4ba8707

SKILLS

Technical skills:

DEEPANJANA BISWAS PATIL

• Awarded IBM Excellence & Eminence Award in 2014. Awarded Client appreciation certificate from Lloyds CIO Darryl West in 2011

•

• Received IBM's Eminence & Excellence award in 2011

• Received IBM's Best Certificate from client in 2011. Awarded 'Honorary Mention' in Techathon 2014 for developing 'ETL DQ Analyzer' at IBM Pune.

•

Single point of contact and technical lead for offshore development across 3 different vendors; Managing team of 25 ETL developers across different locations for timely deliveries.

•

Translate business requirements as defined by clients into requirements and design deliverables and create solution proposals for change requests, using standards and guidelines prescribed by IBM Global Solution Delivery Framework (IGSDF) for Banking projects.

•

Design, development and implement Extraction, Transformation and Load (ETL) processes to source, cleanse, transform and integrate required data in Data Warehouse.

•

On-site coordinator for renowned Dutch bank at Amsterdam from March 2012 till Nov 2012.

•

• Create estimation & deployment documents for the projects.

• Train teams on ETL tools and processes viz., DataStage & DB2. Requirement gathering, requirement analysis, building prototype and on-site coordination at Japan for renowned manufacturing company from Feb 2008 till Dec 2008.

•

• ETL Design and development for Banking and Manufacturing projects Data warehouse tools: DataStage

(Parallel & Server) & Informatica 9

•

• Database: DB2, HiRDB, Oracle (

• Unix shell scripting

Implementation of Object Oriented

Data Model

•

Worked in both Agile and Waterfall

model projects

•

Software Engineer, 06/2005 to 09/2007

HSBC GLT - Pune, India

EDUCATION

Bachelor of Engineering, Computer Science And Engineering, 05/2004 Shivaji University - Kolhapur, Maharashtra, India

CERTIFICATIONS

C2090-421: InfoSphere DataStage v8.5

in IBM DataStage.

Installation & Environment setup for DataStage Server Edition, HiRDB

(Hitachi Database) at the client location.

•

Review of design documents, DataStage jobs, Testing and supporting teams to complete deliverables.

•

• Transition from module lead to team lead for 9 resources.

• Performed module lead roles in 2 projects.

Requirement Analysis and creation of technical documents for DataStage development

•

Developed DataStage PX jobs, Sequence jobs, SQL queries and Unix scripts for projects.

•

• Performed peer reviews, provided technical support to testing teams. Highly involved in process related activities related to projects and organization.

•

Contact this candidate