Resume Text:
|
SUDIPTA MITRA
+***********
f2sy15@r.postjobfree.com
EXPERIENCE SUMMARY
● 12 years of experience in Information Management end-to-end Data Warehousing, Business Intelligence, Data Integration & Data Migration. Developing Data Warehouse roadmap, strategy and architecture, enterprise data warehouse, ODS, dimensional data marts and end user reports.
● as member of Business Intelligence and performance management (BIPM) practice, Conceptualize, design solution approach of data warehouse implementations, Implement best practices, perform BI assessment of client projects
● Hands-on knowledge of Data warehousing ETL and OLAP reporting tools, methodologies, 3NF & Dimensional modeling, Solution architecture, Technical architecture, Data Profiling, Data cleansing technologies, testing strategies.
● Business Analysis - Conducted JAD sessions/workshops for Functional and Non-functional requirements gathering for Data Warehousing projects , developed test cases , Traceability Matrix
● Project management Project initiation, scoping, estimation, costing, planning, Risk Management, finalization of technical / functional specifications, communication management, resource administration & optimization, and quality management of the product.
● Business Development by identifying opportunities and proposing solutions for value addition for effective use of BI applications, Leading aspects of proposal development process , scope out effort and cost of
Solution, develop statement of work
TECHNICAL SKILLS
ETL End to End ETL flow design
Tools used INFORMATICA – Power Mart/ Power Center v4.5 to 8.x
IBM Websphere - DataStage 8 , Quality Stage , Information Analyzer
MS SQL SERVER DTS
Oracle Warehouse Builder
Geocoding Tools – CODE1 , QAS
Front End Reporting Design of Multidimensional cubes , semantic layer for various tools
Tools USED: BUSINESS OBJECTS - Designer 5.1,Supervisor 5.1,Web Intelligence2.6.3
MS OLAP Services , Proclarity, Express Server, OBI EE
Database Design Development of , Conceptual , Logical and physical data model both 3NF and Dimensional data mode;
Tool used - Erwin ,
RDBMS worked on Redbrick, Oracle 10g,DB2, SQL Server,Teradata
Solution Design Provide Solution architecture, Technical Architecture , Tool Selection , Conceptualize solution
approach
Other Tools MS Office MS Visio MS Project
Languages used PL/SQL , SQL , Shell Scripting,Perl
Domains Retail , Telecom , Financial Services , Healthcare
EDUCATION
B.Tech Engineering, University of Calcutta
PROFESSIONAL EXPERIENCE
Client: Walgreen Inc.
Position: Solution Architect Feb 09- Till Date
Project 1 E-commerce EDW
The project is for building the e-commerce EDW for the e-commerce business of Walgreens. The E-commerce business consists of Pharmacy, Photo and Self service business and is conducted through the Web portal of Walgreens. Major subject areas that are being built are Customer, product, order, payments, returns, shipment and vendor for all the three areas mentioned.
The goal of the project is to have the EDW platform to merge the store and the online business of Walgreen’s in order enable analysis and reporting across Walgreen’s store and e-commerce business.
Environment: IBM Websphere Information Analyzer, Data stage, Quality Stage, Teradata, Oracle, Business
Objects, UNIX, Erwin, MS Visio, MS PowerPoint.
Responsibilities till date:
•Solution architecture definition for the E-commerce EDW
•ETL high level design
•Review of Low level ETL design prepared by junior developers
•Review of EDW data Model and physicalization of the data model, definition of indexes
•Capacity planning for UNIX file system and Teradata
• Design of product data integration module across the various lines of business.
Client: Walgreen Inc.
Position: DW Architect Jul 08- Feb 09
Project 2: Integrated Specialty Data Warehouse
The project involves building a data warehouse for specialty drugs business at Walgreen and newly acquired specialty businesses to serve WHS managed clients’ reporting needs. A phased implementation approach will provide the complete EDW in 3 years timeframe. The first phase involves integration of dispense data from the mail, retail, specialty pharmacy channels ,the contact data and patient/clinical activity data from the call center operations system which conduct drug utilization review for specialty patients, & specialty program management. The first phase of the EDW will help cater to WHS client reporting requirements with focus on the following KPI s patient utilization, Medical & pharmacy spend trends, plan cost, co-payment cost, and ranking of top prescribers, spending trends by disease categories, Medical Possession ratio for measuring medication adherence, patient demographics, patient retention measures, number of patients contact with reasons.
While canned reports will be built for WHS Specialty client reporting the EDW will also cater to adhoc reporting for Pharmacy Analytics for internal power users. Subsequent phases of the project will add other subject areas to provide the complete EDW.
Environment: IBM Websphere Information Analyzer, Data stage, Quality Stage, Teradata, Oracle, Business
Objects, UNIX, Erwin, MS Visio, MS PowerPoint.
Responsibilities till date:
•Analysis and gathering of Functional and Non Functional requirements. JAD sessions and workshops were conducted with business users and Walgreens IT team.
•Preparation of Business Requirements Document (BRD) and Sign off from the Director of Specialty
Informatics.
•Perform Data Profiling and Analysis of Source Systems; provide data exception reports showing critical violations of data/business rules. Assess Data quality & conformance issues between Walgreens internal source systems and the newly acquired source systems. Determination of cleansing strategy based on the Data Quality Assessment.
•Provide Solution Architecture which includes – Information model, ETL architecture and Presentation Layer for the Specialty EDW
•Information model – Prepare DW Bus Matrix, Logical Data Model & Physical Data Model of 3NF EDW and the Dimensional Data Mart, Analysis of standard pharmacy industry model to validate its conformity with the specialty EDW requirements
•ETL architecture – Prepare Data Flow diagrams, identify major streams like Data Conversion, Historical, Data Retention Archival, Data Quality, Reconciliation
•Presentation Layer – Define Retrieval , Reporting and presentation process & tools
•Prepare High Level ETL design – Process Flow, Source to target mappings, design of data standardization, de-duplication and Cleansing modules for patient and prescriber data, GPI, ICD and Drug names to achieve consolidated views of these data sets.
•Provide Technical Architecture and capacity requirements for the Common Development Environment for in accordance with the project requirement. It involved providing Hardware, software and server sizing requirements to the Walgreens IT infrastructure services team for acquisition of these components
Client: Hallmark Cards Inc.
Position: Data Conversion Lead Nov 07- Jun 08
Project: Data Conversion from Legacy to SAP
This project involved the migration of legacy Oracle applications and mainframe data to the new SAP R/3 implementation at Hallmark. The Wave 1 phase of the project involved migration of the Purchase Order , goods receipt, Vendor master , Employee Organization , GL balances , Fixed assets and project balances data from oracle applications and also Material master data from Hallmarks Operation scheduling and maintenance system and the fixture data from the KBM system. The migration project also interacted with the Data Governance organization to ensure that right data is available and correctly governed, and available to the new implementation of SAP R/3.
Environment: IBM Websphere Information Analyzer, Data stage, Quality Stage, Source Systems were flat files, DB2, Oracle 10g, Spreadsheets., CODE 1 for address Cleansing, MS Visio, MS Project
Responsibilities:
•Preparation of Project Plan, effort & cost Estimates, Resource Scheduling plans, Identify Risk & issues.
•Interact with Business Owners / IT SME of the existing Oracle Apps and material master maintenance systems and SAP R/3 SMEs to prepare the Functional Design document which mapped legacy functions to the target SAP R/3 modules. Preparation of detailed Field Mapping document to map legacy fields to the target SAP R/3 system and also specify transformation rules to be applied for each field.
•Analysis of source systems for validation of business rules, data Integrity and data cleansing requirements particularly with respect to Vendor and Material master data. Identify data quality issues and compile recommendations. Interface with LOB Data Owners as needed to resolve source data quality and cleansing issues.
•High Level ETL process design – Design of Interface between Oracle Apps / Material Master Systems and the Data Migration staging area. Specification of extracts to be generated for the SAP R/3. Detailed design of DataStage jobs and Data Flows based on the Field Mapping Document. Other areas included design of Historical load process and design of special X-ref between the legacy and SAP R/3 application in order to have cross system references during parallel run.
•Manage, Monitor and support construction, SIT testing and production roll out of the Data Migration Software of the TCS team and report progress to the Hallmark IT project manager
Client: Toyota Financial Services
Position: BI engagement Manager Mar 07- Nov 07
Project: Revolution: Collapsing of Data Marts into Enterprise Data Warehouse
Development of a single version of the truth for the different groups and departments of TFS by unifying the existing Data Marts into an Enterprise Data Warehouse (EDW) of TFS. Applying the data governance rules to the data architecture of Enterprise Data Warehouse and maintaining a single metadata layer for all entities of the organization. Creation of the Data Warehouse in EDW that will be the single source of all tactical and strategic reporting across the organization.
Environment: Informatica 8, Oracle 10g, Hyperion System 9 BI+, Sun Solaris, MS project, MS Visio, MS Power point
Responsibilities:
•Conceptualize assist and design the solution approach for collapsing the existing data Warehouse application to the evolving OneSource EDW. Provide detailed roadmap for the implementation process.
•Identify and promote best practices and patterns for data modeling with respect , and provide oversight for all activities related to data cleansing, data quality and data consolidation using standard data modeling methodologies and processes.
•Provide Technical recommendations for optimized data access and retention for the data warehouse and review of Solution architecture, High Level design documents. Build repository of reusable knowledge assets and implement best practices, concept documents for client education.
•Manage the Development team and the Production support teams involved in the engagement. Participate in staff recruitment activities for the engagement and mentoring team members.
•Identify opportunities for value addition to for effective use of BI applications, Lead aspects of proposal development process , scope out effort and cost of solution , develop statement of work
Client: British Telecom plc Feb 06 –Feb 07
Position: Offshore Delivery Manager
Project: Openreach EDW
Development of single version of data allowing business to draw meaningful results by cross linking results from different domains like fulfillment and orders and assurance of service delivery. The implementation of the project provided statutory compliance to the telecom authority regulations providing immediate ROI for British Telecom. Openreach provides a cost effective platform that ensures speedy MIS development and so rationalizes conflicting sources and halts the ineffective onward processing of MIS and proliferation of homegrown MIS solutions. This Data warehouse provides information that is operational, tactical and strategic in nature.
Environment: Oracle 10g, Oracle Warehouse Builder, OBI Suite, HP Itanium Server, Java
Responsibilities:
•Evaluate Logical and physical data model
•Project Hardware capacity requirements
•Develop and communicate project plans, work assignments, target dates. Ensure that data projects follow prescribed development life cycle and meet quality standards
•Responsible for costing, budgeting, resource planning, quality, timely completion, contract management, billing, project health check, profitability, closure, issue resolution and escalation
Client: National Health Service Jul 05 –Jan 06
Position: Project Leader
Project: NHS National Programme for IT
The project involved migration of Data from the legacy systems at the NHS trusts to the new system being implemented at NHS.TCS working in alliance with Fijutsu Systems, PwC & BT provided the solution for migrating data from the legacy stack to the new stack. The developed system would do all the necessary data quality checks and provide early warning to the trusts for necessary corrective measures on there source system and enable integration through successful migration of legacy data into the new environment.
Informatica Data quality ,Informatica Power exchange , Data Explorer , Informatica powercenter
Client: Experian UK Nov 04 – Jun 05
Position: Project Leader
Project: CSD Support
This project involved a Customer sales data mart in Oracle with Oracle sales analyzer as the front end reporting platform. Maintenance & enhancement of the existing data warehouse was part of the work. Strategize and architected the evolution of the of Data Warehouses from one that was loaded weekly to one that would be loaded daily, designed and developed ETL using PL/SQL. The data warehouse was also re-engineered to take feed from the new source system due to replacement of the legacy system.
Client: Experian USA Mar 03 – Oct 05
Role: Technical Consultant
Phase 1: BIS Market re-engineering – Feasibility study
Lead a discovery phase to analyze the feasibility of building a National Business Database. This would house unique identified records for businesses of USA. Formulation of Blueprint for re-engineering of the legacy system into distributed system architecture. The discovery phase involved the study of the system as-is, and performing a GAP analysis with the to-be state. The solution roadmap was provided along with the High level process design, technical architecture.
Phase 2: BIS Market re-engineering
Position: Business Analyst Data Modeler & ETL Lead
As Data Modeler, responsible for merging 12 sources of Data into a single consolidated Data base. The ETL was designed to operate in closed loop mode as the entities and the attributes of the business entity like contact information, address information were subject to change. The change information was captured through NACS updates; tele verifcation.The requirement was to maintain both historical and current information on a single database. 3NF was used in the design of the database. Identification of unique businesses was achieved using special cleansing & geo coding software that was used to cleanse, standardize and dedupe based on identifying characteristics e.g. , name address and telephone numbers.
Environment: Ascential Data stage 7.1, Ascential Integrity Stage, Quality Stage, CODE 1 for address
cleansing
Responsibilities:
•Formulation of Blueprint for re-engineering of National Business Database
•Provide Solution Architecture, Technical architecture
•Tool Evaluation & Selection
•Gap Analysis between as-is and to be state
•Meeting Business Users for Requirements Gathering, Organizing JAD sessions/workshops
•Design of data model for National Business Database
•Data Quality Assessment
•ETL process Design, Design and development of cleansing strategy
•Development of Test Scripts
•Capacity Planning – provide database size projections
•System deployment
Client: Harrods Jul 02 – Feb 03
Role: Data Architect
Project: MIS Data Warehouse
The project involved design and development of Retail Sales Data mart using Microsoft Technologies. The data warehouse consisted of the Staging layer, dimensional model in the SQL server Database, with multidimensional Cubes being implemented in the MS Analysis Serves. The reporting layer was built using proclarity. Some of the application data sources fed to the data warehouse includes Wholesale division data from SAP 4.0 on Unix/Oracle, Sales Audit system which maintain point of Sales data, Retail Express on AS400 which supports Airports division and Direct Mail operations.
Client: GE May 00 – June 02
Project1: GE Digital Cockpit
Role: Technical Lead
The project involved building of a prototype for web based reporting for monitoring the activities of sales representative. The system had specific data security requirements namely restricted data exposure to various levels of user hierarchy. The sales representative for the analysis of the target and calls and meetings attended the prototype. The data is loaded to the system on a weekly basis
Project2: FMIS Project
Role: Technical Lead
The project involved building of a data mart for the analysis of GL data present in the Oracle financial applications system. The major categories of reports included the following - Canned monthly reports, Balance sheet reporting, Budget verses actuals reporting
Project3: Global Data Warehouse Project
Role: Module Lead
GE Medical systems e-integration project involved deployment of web based BO reports for all business acquired by GE medical systems to provide status of business acquisition. Reports were built on data inputs from three poles America, Europe and Asia. Development of a centralized data repository consolidating data from different offices located in the three poles.
Project4: CDS data warehouse
Role: Developer
To provide one point access of customer sales and marketing details by Maintaining repository of customer responses to campaigns, transactions, customer demographic Information, etc. To provide GE Capital Bank with campaign analysis results to enable future planning of campaigns, determination of target groups, budgeting. To help sales and Marketing in making business decisions by providing data from MIDAS repository. The major subject areas were Loan Applications, retail sales and marketing.
Client: Dumrath & Fassnatch Aug 99 – Apr 00
Project: Sales Management System Datamart
Position: ETL and Report Developer
Development of Datamart for the Sales management of Dumrath and Fassnacht Hamburg. This is a project for developing a Datamart application for analyzing and monitoring the daily activities of their sales agents. They have an OLTP developed on Oracle for recording daily activities. The data from OLTP is first copied into a staging area and from there to a star schema. From the star schema we load the data to the OLAP MDDB. Different screens are developed to view that data. Drill down and drill up are possible to view the data at different levels on those screens. Slicing and dicing are also possible on those screens.
Client: TATA Bearings May 98 – Jul 99
Project 2: Migration Legacy to Avalon MRP II system
Position: Developer
The project involved migration of data form the existing legacy system to the customized Avalon system which was implemented at the client site. It involved implementation of several module of the Avalon package, necessitating the migration of the legacy data into the respective modules of the Avalon system.
Client: Heinz India Pvt. Ltd. Feb 97 – Apr 98
Project 2: Implementation & Customization of AVALON CIIM (a MRP package)
Position: Developer
AVALON CIIM is an ERP package. It has four main modules, namely, Distribution, Materials, Production, Planning and Finance. The objective of the project is to customize this ERP package to suit the requirements of Heinz India Pvt Ltd.
|
|
Similar ResumesETL Architect
North Hollywood, CA
- initio, microstrategy, teradata, informatica, webi,...BI Architect
New York, NY
- ssas, mdm, dmx, ssis, plsql, ssrs, multithreaded,...DW & BI Architect
Canada, QC
- datastage, sap bi, snc, informatica,...ETL Datastage Lead /Architect
Tampa, FL
- dataware, datastage, teradata, mdm, locomotive,...Sales Home Experience Assistant High School Coordinator
Albany, OR
- gymnastics, stephanie, caregiver, lebanon, allison,...ETL/BI Architect
United States
- talend, datastage, owb, microstrategy, modeller,...Data Modeler
United States
- embarcadero, rtf, informatica, data architect, etl,...Data Warehouse (ETL) Developer
Irvine, CA
- informatica developer, etl developer, teradata,...Data warehouse Business Analyst
somerset, NJ
- initio, datawarehouse, informatica, data architect,...Data Architect
United States
- bodi, owb, unica, siteminder, webfocus, webi,... |
