Sourav Rana
Kolkata,WB
Summary
Data Modeler shaping enterprise data structures for finance, actuarial, and reporting platforms. Owns logical and physical data models, data dictionaries, reference data catalogues, and SQL generation to keep design, mapping, and delivery aligned. Supports integrated data stores by translating business concepts into governed, traceable models and interface contracts.
Overview
21
21
years of professional experience
Work History
Solution Designer
Tata Consultancy Services
10.2022 - Current
- Designed innovative solutions to enhance system architecture and improve client workflows.
- Collaborated with cross-functional teams to define project requirements and deliver optimal solutions.
- Analyzed complex business needs, translating them into technical specifications for development teams.
- Led design reviews and ensured alignment with best practices and enterprise standards.
Data Modeler
Tata Consultancy Services
08.2020 - 09.2022
- Project#0 Finance Ambition Program
- Client MnG / Prudential, UK (Work Location : London)
- Employer1 Tata Consultancy Services
- Role Data Modeler
- Period Aug 2020 – Sep 2022
- Environment Azure, Synapse, Oracle EDMCS.
- Project Description:
- The Finance Ambition program principles relevant to the data integration are:
- A single source of accurate finance data to enable all Accounting, Actuarial, Regulatory and Management Information Reporting.
- A standard data store that supports inputs to modelling and General Ledger as well as IFRS17 calculations and storage of IFRS17 results.
- A single landing stage for new strategic interfaces from source systems
- A strategic Finance & Actuarial Data Store (FADS) that has layers which meets all Management Information requirements and any required analysis
- The Releases target to deliver data as a shared service performing Data Transformation for Accounting Production Sub Ledger (cost ledger and procurement) as well as performing historical data load. FADS solution delivered to provide the business with MI and Insight Data. So Strategic data delivery, including the Data Protection Layer (DPL) and Finance & Actuarial Data Store (FADS) are the main aims of the project.
- Responsibilities:
- To own entire Data Model of the project of Accounting and Actuarial sides.
- Producing the LDM from the Conceptual Models Provided by/Co-Worked with Business.
- Producing the PDM with all the best practices and Project convention in mind.
- Generating the SQL’s for model and guiding the dev team.
- Producing the technical design of some data integrations, updating the e2e mappings
- Producing the data contract documents for new/updated interfaces.
- Creation and maintenance of the whole project catalogue, by which all the data functional subject area’s can be traversed and all design/model/mappings can be traced back.
- Maintaining the whole release catalogues. Document the status of the each interfaces, their components and functionalities for the entire project to use & share.
- Contributing to the data subject area and data functional designs such as Unit Of Account.
- Review of the stored procedures at times and help them in updating them when necessary.
- Generation and maintenance of the Data Dictionary of the project.
- Generation and maintenance of the reference data catalogue of the project.
- Creation of the confluence page for Models and various Design aspects of the project.
Business Analyst
Tata Consultancy Services
04.2020 - 07.2020
- Project#1 WBA – Business Domain Group
- Client Walgreen Boots Alliance, UK (Work Location : Nottingham)
- Employer1 Tata Consultancy Services
- Role Business Analyst
- Period Apr 2020 – Jul 2020
- Environment Salesforce, Hadoop, Azure
- Project Description:
- Walgreens Boots Alliance, Inc and Tata Consultancy Services announced that the companies have expanded their strategic partnership to advance WBA’s transformation of its global IT function by launching a new operating model for IT Run and Operational services, enabling WBA to accelerate its digitalization program to advance innovation for customers, drive organizational efficiencies across the company and further reduce its cost base.
- The expansion of the WBA and TCS strategic partnership is based on WBA’s review of its IT operating model and vendor landscape. As a result, the WBA global IT team will focus on leading and supporting strategic technology projects that create customer value through the development of new digital products and services on its business platforms. Following a period of transition, TCS will provide Run and Operational managed services, including application maintenance and support, infrastructure and security operations. The TCS approach will blend artificial intelligence, machine learning and advanced software engineering to enhance operational resilience and boost productivity.
- Walgreens Boots Alliance is a global leader in retail and wholesale pharmacy, touching millions of lives every day through dispensing and distributing medicines, its convenient retail locations, digital platforms and health and beauty products. The company has more than 100 years of trusted health care heritage and innovation in community pharmacy and pharmaceutical wholesaling.
- Responsibilities:
- To own the Business Process platform end to end from functional point of view.
- To take part in the Knowledge Familiarization calls, coming up with the business understanding document for them.
- To have the functional importance, business criticality and end to end business journeys defined for the various applications under the platform.
- To come up with L1-L2-L3-L4 business process mapping for the application.
- To come up with system context diagram for the application.
- To define the business KPI’s for that application and help in visualization of the same.
- To come up with the integrated view of the platform and build the high level business view.
Solution Designer
Tata Consultancy Services
11.2018 - 03.2020
- Project#2 Data Hub Solution
- Client EasyJet, UK (Work Location : Luton)
- Employer Tata Consultancy Services
- Role Solution Designer
- Period Nov 2018 – Mar 2020
- Environment AWS, Cloudera CDH (HDFS, Hive, Sqoop, HBase and Spark)
- Project Description:
- The Data Hub has capabilities to support modern lambda architecture and can offer the ability to create analytical results, save data reliably for historical analysis and be a trusted central repository for enterprise master data. In order to do this, there must be the ability to consume and make sense of incoming data with consistently low latency as well as the ability to push data and insights back out to the channels and systems subscribing to them.
- The Data Hub is modern data platform built using CDH 5.11 that resides on AWS Cloud Infrastructure. The Hub enables to ingest large volumes of data from a variety of source business applications. For example, the hub holds 20 years of bookings data from the reservation business domain. Currently the latency of ingestion is daily batches (with few exceptions of more frequent batch ingestion). New real time streaming ingestion are being developed sidewise. By defining Data Zones (as per data sensitivity), the Hub governs data flow through Data Engineering processes and delivers data for various consumption patterns across enterprise. The Hub enables Data Analysts to perform data exploration and self-service analysis. The Hub also caters data to the needs of Data Scientists for executing advanced predictive analytics. The first set of Data products iteration are Single Booking View and Single Customer View delivered through the Hub for servicing EasyJet customers.
- Responsibilities:
- To contribute to end to and solution architecture from AWS Platform standpoint.
- To contribute to develop ETL framework design to be implemented in project.
- To contribute to capacity management/forecasting for AWS framework for the platform.
- To contribute to setup a Multi-AZ platform, defining the ways-of-working of several zones (security wise).
- To collate the business requirements along with the business analysts and stakeholders
- To come up with the solution adhering the framework in place for data ingestion/curation
- To design new data ingestion framework for real time streaming data using Spark/Kudu.
- To understand the GDPR criteria & compliance requirement for the data hub and design the framework accordingly, involving 3rd party anonymization server.
- To decide the future project deliverables as per business criticality and estimate.
- To present the designs in Design Governance Board call for review and collaboration.
- To run the Business Prioritization call with Business analysts to develop & maintain the features’ backlog.
- To help developers understand the requirements and to validate the source data.
- To keep JIRA boards updated in terms of story descriptions, design decisions, acceptance criteria collaborating with the business analysts.
- Collaborate with testing teams to ensure all the testing phases are executed seamlessly and to ensure that the acceptance criteria have been tested properly.
- To plan the releases accordingly, to attend the Technical Security Management call.
BI (Talend) Designer
Tata Consultancy Services
07.2018 - 11.2018
- Project#3 Strategic Inventory Program
- Client Vodafone, UK (Work Location : Newbury)
- Employer Tata Consultancy Services
- Role BI (Talend) Designer
- Period Jul 2018 – Nov 2018
- Environment Talend, Service Now.
- Project Description:
- Inventory reconciliation project’s main objective is to deliver a Clean, Complete and Consistent inventory which is available when and where enterprise customers and employees need it.
- It is important because
- I. Strategically: It enables the digital experience for customers and employees.
- Ii. Commercially: It drives revenues, profitability, and reduces risks.
- To measure the success, it should deliver the followings:
- I. Improved margin through increased revenue and reduced costs
- Ii. Improved customer and employee experience through reduced number of incidents and reduces mean time to repair and reduced operation risks.
- Responsibilities:
- To contribute to end to and solution architecture from ETL standpoint.
- To contribute to develop Talend framework design to be implemented in project.
- To own the ETL (Talend) Low level design and ensure that it’s implemented.
- To ensure if the Talend best practices have been followed in the project.
- To contribute to decide the Program Increment deliverables feature wise.
- To contribute to break the features in the specific functional and technical stories to delivered in the consecutive sprints in an AGILE model to be implemented in phases.
- To keep JIRA boards updated in terms of story descriptions, acceptance criteria collaborating with the business analysts.
- Collaborate with testing teams to ensure all the testing phases are executed seamlessly and to ensure that the acceptance criteria have been tested properly.
Platform Architect
Tata Consultancy Services
04.2017 - 06.2018
- Project#4 Global Consumer Data and Analytics
- Client Johnson & Johnson, USA (Work Location : Kolkata)
- Employer Tata Consultancy Services
- Role Platform Architect
- Period Apr 2017 – Jun 2018
- Environment Cloudera, Alteryx, Talend, Tableau, AWS (Redshift, S3), Mbox
- Project Description:
- Johnson and Johnson want to make brand building a clear source of competitive advantage (New Way of Marketing) by Consolidation and standardization of Global Consumer Analytics Platform
- Deliver the Global Analytics on New Product Development
- Gain sales forecast efficiency by providing supply chain metrics for key retailers e.g. Walmart/Tesco helping
- Extend brand reach and gain consumer insights through Digital marketing platforms e.g. facebook, twitter, youtube, google adwords
- Market Share Analytics and Sales segmentation of Consumer Brands
- Building trade promotion excellent platform (in Roadmap)
- Enable Revenue Growth Management
- Optimize pricing, trade promotions, CIW and mix / assortment
- Develop enablers (Omni-channel pricing, cross-border pricing principles, global commercial policy, cost-to-serve analysis, SMART Spend)
- Responsibilities:
- To Own the amazon Redshift and the EC2 servers
- To monitor and analyze the performance of the Redshift cluster
- To check and ensure if the redshift best practices have been followed
- To ensure if the Talend and Alteryx best practices have been followed in the project
- To ensure if the Tableau best practices have been followed in the project
- To recommend the usage of S3 and Cloudera as a data lake
- To prepare the architectural roadmap –migration strategy for AS-IS to TO-BE state.
- To summarize current platform issues and problems, their impacts on the project and to come up with recommendations accordingly.
ETL Architect of BI Team
Tata Consultancy Services
01.2016 - 03.2017
- Project#5 Commercial Operations Analytics
- Client Johnson & Johnson, USA (Work Location : Kolkata)
- Employer Tata Consultancy Services
- Role ETL Architect of BI Team
- Period Jan 2016 – Mar 2017
- Environment Talend Studio 6.1.1, Tableau 9, Amazon Web Services (Redshift, S3), Mbox
- Project Description:
- DePuy Synthes Commercial Operations Analytics initiative requires an agile team to deliver reporting solution for DePuy Synthes Commercial Operations team. The sprints, backlog and deliverables to be defined in the SCRUM planning process. The objective of this project is to build a robust integrated DePuy Synthes Analytics and Reporting capability to provide the following:
- Sales and Business performance reporting
- Analytics to yield insights identifying strategic and business growth opportunities
- This capability will be focused towards enabling internal management and field sales reporting capabilities for DePuy Synthes companies (Joint Reconstruction, Trauma, CMF, Mitek Sports, Spine, Codman Neuro and Power Tools). FAM reporting will be enabled in subsequent work stream.
- Responsibilities:
- The team followed an Agile methodology viz. SCRUM, and the project executed in Sprints.
- To maintain the Product Backlog of deliverables in a continued SCRUM planning process
- To get approved the product backlog with Product Owner and alignment of the SCRUM team during the project execution
- To define and implement an end-to-end enterprise data integration strategy in AWS platform
- To promote data and business rules reuse and understanding.
- To standardize data content and to reduce data redundancy and cleansing.
- To design the Talend ETL architecture, wrapper design and implementation of auditing layer and to schedule the Talend jobs with Tidal interface.
Data Modeler of DWH Team
Tata Consultancy Services
07.2015 - 01.2016
- Project#6 DWH Design Team
- Client TalkTalk Group, UK (Work Location : London)
- Employer Tata Consultancy Services
- Role Data Modeler of DWH Team
- Period Jul 2015 – Jan 2016
- Environment ER Studio XE 5, MS Excel, IBM Netezza 6.0
- Project Description:
- TalkTalk a prominent broadband, TV, mobile service provider in UK engaged TCS to outsource its Data Warehouse solution and capabilities.
- Responsibilities:
- To own the DW models for the DWH Team.
- To create and own Logical and Physical data models.
- To create data mapping sheet to transform the data various database (stage/audit/presentation) layers for DW
- To present the solution to the lead architects to formally sign off the design.
- To help ETL designers and Test leads functionally to make sure the Business requirement is well covered
BI Designer and Project Lead
Tata Consultancy Services
11.2013 - 06.2015
- Project#7 BI Dashboard Offshore Factory
- Client TalkTalk Group, UK (Work Location : Kolkata)
- Employer Tata Consultancy Services
- Role BI Designer and Project Lead
- Period Nov 2013 – Jun 2015
- Environment Qlikview Version 11.20, SAP Business Objects 4.1, MS Excel, IBM Netezza 6.0
- Project Description:
- TalkTalk a prominent broadband, TV, mobile service provider in UK engaged TCS to outsource its commercial division’s analytics works which generates hundreds of business critical and operational reports for various departments and stakeholders. BI dashboard factory was setup to enable cost effective and timely delivery of these reports from offshore. The program also rolled out a new Qlikview reporting platform & data warehousing solution to support new executive scorecards and dashboards as well as migration of excel and business object based legacy reports.
- Responsibilities:
- To understand business process, challenges and reporting requirements.
- Analyze data inventories and identify required data sets, propose mockups and build reports using Qlikview, replacing the existing Business Objects 4.1, MS Excel based reporting
- Create solution for integration, automation & migration of legacy reports and deliver the complete data imagination through tailored data visualization for business executives and stakeholders.
BI Data Modeler and project lead (offshore)
Tata Consultancy Services
06.2013 - 10.2013
- Project#8 Active Video Networks Effectiveness Project
- Client Comcast, USA (Work Location : Kolkata)
- Employer Tata Consultancy Services
- Role BI Data Modeler and project lead (offshore)
- Period Jun 2013 – Oct 2013
- Environment Software:- Pentaho DI 4.4, Cognos Database:- My Sql
- Project Description:
- COMCAST is the largest cable operator, one of the biggest mass media, home Internet service providers, and the third largest home telephone service provider in the United States, providing cable television, broadband Internet, telephone service and in some areas, home security to both the residential and commercial customers in 40 states and the District of Columbia.
- The Customer is embedding increased customer self-help capabilities into its products and services. One such solution, the Active Video Network Remote Control Help Solution is currently being piloted to 55,000 customers. In this project, TCS America will use its knowhow, experiences and TCS America analytical engines to determine the effectiveness of the AVN Remote Control Help capability and usage. TCS America will glean insights through the correlation of the activity of AVN Remote Control Help customers with other the customer data sources. Potential data sources that COM may make available for this correlation analysis includes IVR call data, GrandSlam data, Einstein data, EDW data, NDW data, OnTrack data and other similar sources.
- The analysis performed will seek to understand and positively shape the impact of this newly-introduced capability on relevant COM business metrics, such as the average number of monthly calls to COM Customer Care Centers, First Call Resolution (FCR) Rate, Call Average Handling Time (AHT), and similar such metrics as appropriate. Generally, the analyses will seek to understand the impact on customer experience.
- Responsibilities:
- To own the DW models (OLAP) for the MI solution.
- To create and maintain the various database (stage/audit/presentation) layers for DW.
- To design the data mapping from source to description
- To design and develop the ETL mappings
- To present the solutions to the customer.
Business Intelligence (BI) Data Modeler
Tata Consultancy Services
10.2012 - 05.2013
- Project#9 BI Project (initial phase) with Glaxo Smith kline
- Client Glaxo Smith kline, UK (Work Location : Kolkata)
- Employer Tata Consultancy Services
- Role Business Intelligence (BI) Data Modeler
- Period Oct 2012 – May 2013
- Environment Software:- ERwin Database:- Oracle 9i, 10g, Siebel 8.1.1.2 (Siebel Tools).
- Project Description:
- Glaxo Smith Kline is a British multinational pharmaceutical, biologics, vaccines and consumer healthcare company headquartered in London.
- The Customer has a portfolio of products for major disease areas including asthma, cancer, virus control, infections, mental health, diabetes and digestive conditions. It also has a large consumer healthcare division that produces and markets oral healthcare and nutritional products, drinks and over-the-counter medicines, including Sensodyne, Boost and Horlicks.
- This engagement was a initial phase of a BI project where TCS was engaged to do a due diligence of a BI project, initial requirement analysis and project strategy and planning.
- Responsibilities:
- Understanding BI requirements – tactically and strategically
- Perform data analysis against BI requirements
- Defines the overall corporate data model on which BI is based on
- Develop relational model, dimensional model (Logical/Physical)
- Resolve discrepancies in data definitions that arise among multiple sources and projects
- Gain consensus among users on common business data definitions
Data Analyst and Modeler – OLAP (MI Team)
Tata Consultancy Services
06.2011 - 08.2012
- Project#10 Child Maintenance and Enforcement Commission – BI Team
- Client CMEC, UK (Work Location : Leeds)
- Employer Tata Consultancy Services
- Role Data Analyst and Modeler –OLAP (MI Team)
- Period Jun 2011 – Aug 2012
- Environment Software:- System Architect Database:- Oracle 9i, 10g , Siebel 8.1.1.2 (Siebel Tools) , TCS BaNCS
- Project Description:
- The Child Maintenance and Enforcement Commission is a Non-Departmental Public Body established to take responsibility for the child maintenance system in Great Britain. In February 2006, the UK Government announced a twin-track approach to the reform of child maintenance: a three-year Operational Improvement Plan to stabilize the performance of the existing Child Support Agency (CSA), alongside a longer-term redesign of the child maintenance system. The Child Maintenance and Enforcement Commission was established in July 2008, charged with completing the operational improvement Plan and delivering the second phase of reform: the fundamental redesign of the child maintenance system.
- The overall objective of the Commission is ‘to maximize the number of those children who live apart from one or both parents for whom effective child maintenance arrangements are in place’. The Commission identified three core functions to deliver its objective through the new system of child maintenance:
- Promoting the financial responsibility that parents have to their children;
- Providing information and support about the different child maintenance options available to parents; and
- Providing an efficient statutory maintenance service with effective enforcement.
- Responsibilities:
- To own the DW models (OLAP) for the MI solution.
- To create and maintain the various OLAP model star schemas.
- To analyze and assess the Data Item Register given by business to develop the reporting capabilities and identification of the necessary facts and dimensions.
- To interact with clients while reporting requirements are shaping up, involve with the report design team (BICC) to finalize the layout.
- Consolidation, analysis and prioritization of business requirements.
- To review and analyze the MI High Level Reporting Requirements and the report design document for complete coverage of business expectation.
- To propose and develop/amend the data model (star schemas) to suite the report and the capability build.
- To facilitate the review of any data model design decisions made by peer MI data modelers.
- To ensure we have the data scenarios covered in the reporting requirement/design actually matches the Siebel data we have in DWH so they are covered from the data standpoint.
- The work is in agile mode and I ensure as a module lead that all deliverables meets the SLA and the quality client’s expectation.
- Data mapping to source in order to design the ETL routines from source to the target DWH
Data Architect and Modeler – OLTP (Data Architecture Team)
Tata Consultancy Services
03.2010 - 06.2011
- Project#11 Child Maintenance and Enforcement Commission – Future Scheme
- Client CMEC, UK (Work Location : Leeds)
- Employer Tata Consultancy Services
- Role Data Architect and Modeler –OLTP (Data Architecture Team)
- Period Mar 2010 – Jun 2011
- Environment Software:- System Architect Database:- Oracle 9i, 10g , Siebel 8.1.1.2 (Siebel Tools) , TCS BaNCS
- Project Description:
- The Child Maintenance and Enforcement Commission is a Non-Departmental Public Body established to take responsibility for the child maintenance system in Great Britain. In February 2006, the UK Government announced a twin-track approach to the reform of child maintenance: a three-year Operational Improvement Plan to stabilize the performance of the existing Child Support Agency (CSA), alongside a longer-term redesign of the child maintenance system. The Child Maintenance and Enforcement Commission was established in July 2008, charged with completing the operational improvement Plan and delivering the second phase of reform: the fundamental redesign of the child maintenance system.
- The overall objective of the Commission is ‘to maximize the number of those children who live apart from one or both parents for whom effective child maintenance arrangements are in place’. The Commission identified three core functions to deliver its objective through the new system of child maintenance:
- Promoting the financial responsibility that parents have to their children;
- Providing information and support about the different child maintenance options available to parents; and
- Providing an efficient statutory maintenance service with effective enforcement
- Responsibilities:
- To create the Conceptual / Logical / Physical Data Model (OLTP) for the solution.
- Create and maintain various data artifacts like Business and Technical Data Dictionary, Reference Data catalog, with a change control in place.
- Analyze and Assess the Data Quality and implementing the data Governance process.
- Work with the Siebel architects and designers to manage the Siebel data aspects of the solution.
- To own, and manage changes to, the Siebel Data Model and ensure it is well understood across the development team and, where appropriate, the Commission and other non-TCS development parties
- To facilitate the review of any data design decisions to ensure that they are agreed by all required parties including the multiple development streams, Integration Team, the MI team and associated architects and designers.
- To support the review and agreement of the Siebel Data Model (using an appropriate version management process).
- To ensure that any data changes to the model are fed through to Systems Architect where the logical models are defined and modeled.
- To provide input to support the mapping of business logical and system logical models in Systems Architect.
- To provide support to developers, integration and testing team and MI on Siebel data matters and data requirement implementations.
Designer/Developer
Tata Consultancy Services
07.2007 - 12.2009
- Project#12 Master Data Management – Customer Master Files – BT Openreach
- Client British Telecom, UK (Work Location : Glasgow / Kolkata)
- Employer Tata Consultancy Services
- Role Designer/Developer
- Period Jul 2007 – Dec 2009
- Environment Hardware:- HP, Software:- Ab Initio (ETL Tool) Unix Shells OS:- Unix HP-UX, Database:- Oracle 9i, 10g
- Project Description:
- Openreach is a division of the British telecommunications operator BT Group, established after BT reached an agreement with OFCOM to implement certain undertakings, pursuant to the Enterprise Act 2002, after OFCOM’s strategic review of telecommunications.
- The division was created to “Ensure that all rival operators have equality of access to BT’s own local network”. The local network or “access network” is the wiring connecting customers to their local telephone exchange, starting at the Main Distribution Frame (MDF) in the exchange and ending at the network termination point (NTP) at the end user’s premises. Openreach also manages the connections between the MDF and the BT Wholesale/Local Loop Unbundling (LLU) termination points located in the exchange, often referred to as jumper connections, and Wholesale Line Rental (WLR) lines for other Customer Providers (CP) in telecom business.
- The project provides a tactical solution for BT to maintain the data for Openreach customer’s by migrating and synchronizing the customer data from legacy systems like CSS and COSMOSS and to be loaded onto the strategic CRM systems like Openreach LLU and WLR Siebel. The customer data comprises of various logical entities like Address, Asset, Billing accounts and Retailer ID information’s, for witch daily batch processes and some continuous processes are responsible to keep all the information’s into account. However, the latest focus of the project was on the Migration jobs for all Openreach Installation including BT lines to move towards a more complex canonically hierarchical model so that it can support more features per asset catering to the various possible products which all the CP’s provide to its customers across UK.
- Responsibilities:
- Involve in the business requirements gathering process and bring clarity whenever necessary.
- Discuss the Data Mapping framework with the Lead Solution Designers.
- Study the e2e business requirements and come up with solution from component level.
- Analyzing the impact on the other components by a proposed change on the component.
- Study the relationship between the data elements identified in the legacy and the strategic systems.
- Assess the feasibility of a solution for the business requirements by assessing the readiness of source data systems and reusable solution in hand.
- Design the ETL solution suitable for the business requirement.
- Study the source data to ensure the data quality so that the proposed solution should cover all the business scenarios correctly and to identify the exception cases.
- Analyzing the in life defects and proposing the optimal feasible solution for them.
- Module Leader to drive the AGILE initiatives.
- Deployment Management was the added responsibility during the last phase of the project.
Developer/Tester
Tata Consultancy Services
02.2006 - 06.2007
- Project#13 CRM - Single Interface Model (SIM) – BT
- Client British Telecom, UK (Work Location - Kolkata)
- Employer Tata Consultancy Services.
- Role Developer/Tester
- Period Feb 2006 – Jun 2007
- Environment Hardware:- HP, Software:- Ab Initio (ETL Tool) Unix Shells OS:- Unix HP-UX, Database:- Oracle 9i, 10g
- Project Description:
- The project aims to prepare a single interface model (SIM) repository for BT Retail’s customers which would include data for domestic and business customers to have the 360-degree view of one customer. The data would be fetched from several sources in BT, and would comprise the full range of entities like billing accounts, addresses, sites, assets, contacts, consumers etc. The data loaded onto SIM will then be used to feed two databases, OneSiebel and OneView, served by Siebel GUIs. These data repositories are mainly used for central data hub for the entire peripheral component, to govern the data quality and integrity.
- Responsibilities:
- Involve in the ETL development of the entities by understanding the requirement
- Preparing the test cases with the design understanding and to review.
- Testing of the new/changed processes with a data setup covering all the possible scenarios
- Developed a Unix shell based testing tool which was highly appreciated in the project.
- Loading the test data onto several test Siebel environments to support the e2e test.
- Configuration management and version control of the dev/test and live environments.
Education
Bachelor Of Technology -
West Bengal University of Technology
01-2005
Skills
AWS Cloud Single/Multi AZ
S3: Glacier
RDS
Redshift
Infrastructures
Talend 7 (Certified 56)
AbInitio (GDE11438,Co>op214)
Informatica 901
Pentaho DI 44
Alteryx
System Architect 112
Erwin Data Modeler r7
ER Studio XE 5
Lombardi Blueprint20
Power Designer
TIDAL
Talend Scheduler
Qlikview Version 112
Oracle Business Intelligence
Tableau
Microstrategy Mobile BI
Cognos
Oracle (9i /10g)
Netezza 60
Siebel 8112 (Tools)
My SQL
Hbase
Azure Synapse
PL/SQL 80
T SQL
Unix Shell Script
HiveQL
Scrum
Jira
Confluence
Timeline
Solution Designer
Tata Consultancy Services
10.2022 - Current
Data Modeler
Tata Consultancy Services
08.2020 - 09.2022
Business Analyst
Tata Consultancy Services
04.2020 - 07.2020
Solution Designer
Tata Consultancy Services
11.2018 - 03.2020
BI (Talend) Designer
Tata Consultancy Services
07.2018 - 11.2018
Platform Architect
Tata Consultancy Services
04.2017 - 06.2018
ETL Architect of BI Team
Tata Consultancy Services
01.2016 - 03.2017
Data Modeler of DWH Team
Tata Consultancy Services
07.2015 - 01.2016
BI Designer and Project Lead
Tata Consultancy Services
11.2013 - 06.2015
BI Data Modeler and project lead (offshore)
Tata Consultancy Services
06.2013 - 10.2013
Business Intelligence (BI) Data Modeler
Tata Consultancy Services
10.2012 - 05.2013
Data Analyst and Modeler – OLAP (MI Team)
Tata Consultancy Services
06.2011 - 08.2012
Data Architect and Modeler – OLTP (Data Architecture Team)
Tata Consultancy Services
03.2010 - 06.2011
Designer/Developer
Tata Consultancy Services
07.2007 - 12.2009
Developer/Tester
Tata Consultancy Services
02.2006 - 06.2007
Bachelor Of Technology -
West Bengal University of Technology