Samit Das

Data architect with expertise in data integration and management. Demonstrated success in designing effective data models and optimizing enterprise processes. Skilled in technical documentation and requirements gathering, resulting in improved efficiency and data quality. Strong analytical abilities paired with effective stakeholder engagement.

• Snowflake SnowPro Core
• AWS Solution Architect Associate
• SAFe 5 Practitioner
• TOGAF Standard, Version 9.2

Data Architect / Modeler - (Multiple clients for EY GDS)

Key Deliverables:

• Worked on Design of a common data model and creation of standard data platform and integration

architecture for a large US healthcare client to support specific business use cases.

• Involved in creation of unified Enterprise Architecture Methodologies for a global bank, streamlining

processes across the enterprise - created Function inventories, mapped data and control taxonomies of

different business lines with Enterprise taxonomies, created Target State Process Models in HOPEX- the

Enterprise Process Management tool.

Database Designer- New Acquiring Platform for FIS

Key Deliverables:

• Conducted data analysis, Documented data mappings, data dictionary, data lineage to facilitate future

modernization project to move existing Oracle ODS to Snowflake / AWS cloud

• Proposed solution and design to improve and automate a few BAU application functionalities resulting

in quicker turnaround time for production support team

Solution Designer- Application Development & Integration (Revenue Cycle Management –

Global Billing System for HSBC)

Key Deliverables:

• Helped resolve functional and technical queries from product vendor by doing reverse engineering on

existing application code base, done fit- gap analysis with product vendor

• Done analysis on third party utilities available in the market to automate a few manual tasks in the

project and helped them choose one, resulting in reduction of the manual effort by 75%

• Successfully troubleshoot and resolved data and code migration issues due to product upgrade

Technical Team Lead - Database Design & Application Integration (W&G Delivery - AML

Transaction Monitoring for RBS, NatWest Group)

Key Deliverables:

• Prepared Technical Design Documents for Application and Components, Mapping documents to map

data between various upstream and downstream systems

• Lead key aspects of project – work estimation, resource planning and allocation, status reporting,

client engagement, change management and vendor training

• Address and resolve project risks and roadblocks to efficiently complete deliverables within timeline

Lead Developer – Database Design & Development (Enterprise Data Quality for Dell)

Key Deliverables:

• Involved in building Enterprise Data Quality System for Dell to bring standard data and processes to

monitor, measure, identify and remediate data quality issues

• Designed Database for EDQ that provides a single data model aiming to be a central common data

repository for analytics, Created Logical and Physical data models, source to target data mappings,

Performed data profiling and cleansing

• Developed ETL codes to extract data from multiple legacy systems and load into EDQ using ETL tools

and customized stored procedures, Analyzed and resolved performance issues in ETL process

Agile Developer – Application Development & Integration (Genworth Marketing Solution, TIA

for Genworth Financials)

Key Deliverables:

• End to end ownership of deliveries to production – planning, analysis, design, develop, test, document

and push to production

• Contributed to improvements of software development (products, processes, methods, tools) working

in a continuous delivery model

Module Lead – Application (TIA 6.2 product implementation for Zurich Financial Services)

Key Deliverables:

• Prepared Technical Design documents as per the functional requirements

• Reviewed the TDS / Code / Test Cases prepared by the team members

• Assisted team members with the analysis and development work

Sr. Developer - Database (TIA 5.5 product implementation for GF Forsikring)

Key Deliverables:

• Recommended technical development approach and high-level estimation for development work

• Written PL-SQL packages, procedures, functions, prepared Unit test Cases and performed Unit test

• Prepared Quality Assurance and Knowledge sharing documents for the team

Developer – Database (Best Buy CRM – Canada customer data migration for Best Buy)

Key Deliverables:

• Done impact analysis on BAU codebase, updated design documents as required

• Written PL-SQL packages, procedures, functions, triggers and utilities using Unix shell script

• Banking- Barclays, Citi, HSBC, RBS (now NatWest group)
• Insurance- Zurich Insurance Group, Genworth Financial
• Retail- BestBuy, Dell