Resume of Sukanya Banik

SUKANYA BANIK

Summary:

  • Posses 9 years of experience in the industry.
  • Extensive experience with ETL design and development using Informatica ETL tool. Have been involved in analysis and design of complex datamart schemas, migration strategies and interfaces for Data Warehouses using Informatica ETL tool.
  • Have been involved in the conceptualization, development and end-to-end implementation of the Analytics warehouse for Elance.
  • Have been instrumental in setting up the Global Delivery Model in the BI group for Intrasphere.
  • Have been a part of the technical recruitment panel Cognizant, Mindtree and Intrasphere
  • Have had extensive client interaction in the various projects executed and have received accolades for the same.
  • Have been involved in pre-sales activities for Cognizant, HLL and GE.
  • Have worked in the management side as the project lead and well versed in the QMS processes. Excellent leadership qualities and have motivated and led teams to deliver quality results.
  • CSQA certified professional.
  • Great team player with strong interpersonal skills.
  • Excellent analytical, logical and communication skills.
  • Have been at onsite (USA, Minneapolis) for 14 months through Tata Consultancy Services.

EXPERIENCE

Total Years of Experience –9 yrs

EXPERIENCE SUMMARY

Sl No / Employer / Experience In Years / Employment Period
1 / Cognizant / Current Employer / Dec 06- Till date
2 / MindTree / 1.5 / Mar 05 – Oct 06
3 / Intrasphere / 0.5 / Jul 04 – Feb 05
4 / TCS / 4.5 / Nov 99 – Jun 04
EDUCATION
Sl No / Degree / % Marks / Institution / Completion Year
1 / BE Mechanical. / 59% / RegionalEngineeringCollege, Rourkela / 1999
2 / 10+2 , CHSE / 60% / RamadeviWomensCollege, Bhubaneswar / 1994
3 / 10, ICSE / 82% / St. Vincent’s ConventSchool / 1992

SKILLS PROFILE

Data Base :ORACLE 8i, Oracle 9i

ETL Tools : Informatica, Exposure to Business Objects Data Integrator

Languages : SQL, PL/SQL, VB 6.0, ASP

Application :Oracle Financials (Basic concepts of AR, GL, FA and their Interface

Programs), Exposure to Microsoft SQL Server 2005 BI Suite

PERSONAL PROFILE

DOB: 8th August, 1977

Passport No – A 4833053

Marital Status – Married

Mobile - +91-9945610719

RESPONSIBILITIES AND PROJECTS EXECUTED

For Cognizant Technology Solutions,

1. Group RCI – July 2008 till date

Client :Group RCI

Role : Offshore Project Lead

Designation :Senior Associate

Team Size :8

Location : Cognizant, Bangalore

Industry : Travel & Hospitality

Description Of Project:

RCI's core business is Exchange Vacations. RCI provides its global community of more than three million timeshare owners worldwide with quality vacation experiences at more than 3,700 resorts in 101 countries through RCI's week-for-week and points-based timeshare exchange networks.

RCI’s vision is to build an enterprise operational data store which provides an uniform synchronized enterprise wide view of the transactional data.

Responsibilities:

  • Project Management and Reporting etc
  • Delivery Management
  • Estimation
  • Resource Management
  • Reviews
  • Quality Audit etc.
  • ETL Design and Strategy
  • Team Management and Co-ordination
  • Appraisals

Platform/Languages/Tools : Informatica 8.6

Database : Oracle

2. IM DATA – May 2007 till July 2008

Client :Thrivent Financials – IM Data

Role : Offshore Project Lead

Designation :Senior Associate

Team Size :22

Location : Cognizant, Kolkata

Industry : Insurance

Description Of Project:

Thrivent Financial for Lutherans is a non-profit, Fortune 500 financial services organization helping 2.8 million members achieve their financial goals.

Information Management (IM) data project is a IT modernization project which aims at building foundational capabilities that will be used for multiple purpose and be shared by more than one division. It will consolidate core member information to support various downstream consumers like SMEP, Statements, Compliance etc.

Responsibilities:

  • Team Management and Co-ordination
  • Project Management and Reporting etc
  • Delivery Management
  • Estimation
  • Resource Management
  • Reviews
  • Quality Audit etc.
  • ETL Design and Strategy
  • Training
  • Offshore Process Co-ordinator

Platform/Languages/Tools : Informatica 8.1

Database : DB2

2. REALOGY – January 2007 till April 2007

Client :REALOGY

Role : Offshore Project Lead

Designation :Senior Associate

Team Size :6

Location : Cognizant, Kolkata

Industry : Real Estate and Mortgage

Description Of Project:

REALOGY has built a pilot Finance Data Warehouse (FDW) which can answer relevant business questions and also provide a set of key business metrics. The project involves an end-to-end implementation of building a BI layer to address various analytical needs of the REALOGY business like reports of payments made to potential franchisees to start up the business, trend reports to provide the senior management with an understanding of the trends in Closed Sides, Open Sides and Listings, Enterprise Awards and Recognitions process etc.

Responsibilities:

  • Estimation
  • Resource Management
  • Project Management and Reporting etc
  • Quality Audit etc.
  • Team Management
  • Training
  • Data Modeling and ETL Design
  • Co-ordination with onsite counter parts

Platform/Languages/Tools : MS - SQL Server 2005 – BI Suite , Informatica 7.1, Erwin

Database : SQL Server 2005

For Mindtree Consulting Pvt Ltd,

1.Elance , SPM Analytics Warehouse - April 2005 till July 2006

Client :Elance

Role :Technical Lead

Designation :Consultant

Team Size :3 (In MountainView)

Location : MindTree, Bangalore

Industry : Services Procurement and Management

Description Of Project:

Elance is provides software as a tool custom built for the “Services Procurement and Management” Industry. The Analytics project involves building a warehouse for providing in depth analysis of the

“Services Procurement and Management” process for customers having implemented the software solution. Along with providing the analytical understanding of customer’s own process, the warehouse also aims at providing an accurate study of market averages for resource rates etc.

Responsibilities:

  • Multiple Environment Set Up (Local and Remote at Mountain View)
  • Estimation (For Development and Bug fixes) and Impact Analysis
  • Devise the deployment strategy for the warehouse
  • Data Analysis and derive the source system relationships
  • Schema design
  • ETL Design
  • ETL Development
  • Review and Testing
  • Configuration Management
  • Team co-ordination (with QA and development )
  • Co-ordination with onsite counter parts

Platform/Languages/Tools : SQL, PL/SQL, TOAD, Informatica 7.1, Erwin

Database : Oracle 9i

Operating System : Windows 2000, Linux

For Intrasphere Information Technologies Pvt. Ltd.,

1. Pfizer Global Pharmaceuticals, Medical Datamart - September 2004 to February 2005

Description Of Project:

Project was carried out with the objective of building a Medical Data Mart to support clinical trial financial, schedule, resource analysis, and reporting requirements. The data mart will have one source of data, the Global Medical Data Warehouse (GMDW).

Platform/Languages/Tools : SQL, PL/SQL, TOAD, Informatica 6.2

Database : Oracle 9i

2. Global Security Project, Pfizer - July 2004 to September 2004

Description Of Project

This project consists of developing the data mart for the Global Security BU namely for monthly incident reports and dashboards. It also consists of developing the seamless integration of the already developed BO universes to the data mart and build ETL processes to populate the data mart.

Platform/Languages/Tools: SQL, PL/SQL, BO – Data Integrator 6.5

Database : Oracle 9i

Brief Synopsis of the key projects involved in Tata Consultancy Services

from Nov, 1999 till Aug 2004

1. GE Capital Rail Cars

Description of Project:

This project involves providing support and carrying out enhancements for the all GE Rail application systems based Oracle Financial ERP applications. GE CRS employed Oracle 11i Financials for their financial operations and Informatica as the Data extraction and loading tool from various source systems into the financials application.

2.GE Capital Real Estate, eFlash Migration

Description of Project:

‘E Global Reporting’ (eGR) module is responsible for maintaining and enhancing a group of applications named ‘eFlash’, ‘Tenant’, and ‘PMR’. All these applications were standalone applications but being migrated to one integrated data warehouse. The migration to data-warehouse has been executed using Informatica as the Extraction, Transformation and Loading (ETL) tool

4. GE Capital TLS Production Support

Description of Project:

There various Intranet Applications that is under the purview of production support are Fleet Status, Purchase Order System, Courion DBA, Query Management System, Head Count System:

Apart from the technical and the managerial work involved, undertook a six-sigma process improvement project.

5. GECFS Augustin / FAVRe(File Access and Vault Retrieval) as Onsite Coordinator (GE Capital Fleet Services, Minneapolis – USA)

Description of Project:

The objective of the project was to provide a paperless environment for various departments in Fleet Services like the Services, Title and Licensing, Remarketing departments. This application has the additional functionality of multiple indexing. Through this application, one document can be indexed to multiple records. This saves the effort for rescanning the same document multiple times. After the documents are indexed, the electronic documents are retrieved for viewing and/or printing. The accessibility to the scanned files is available through web-browsers on the intra-net.

6. GECFS - ORMS Requirements Analysis – January 2001 – March 2001 as analyst (GE

Capital Fleet Services, Minneapolis – USA)

Description of Project:

The requirements analysis phase will outline the functionalities of the ORMS system. Based on a high level discussion the Online Registration Management System (ORMS) would be developed using Java Server Pages and EJBs and provide the following major functionalities:

The Marketing Tool

The users would be able to create profiles and register themselves for events and seminars in the website. Once the user registers, an e-mail notification would be sent out to them notifying them about their registration.

System Administration

There would be administration functionality to the tool, which would be available to only a particular set of users. It would enable the admin users to generate reports based in an excel format, create and modify event and event information and send update mails to the attendees if there is any alteration of the event