DEBASMITA SAMAL
Data Architect
Bengaluru
Summary
- Data Architect well-versed in defining requirements, planning solutions and implementing structures at the enterprise level.
- Around 11 years of experience in the IT industry in development & support lifecycle, requirements gathering, design, coding and deployment.
- Skilled business solutions technology professional offering in-depth understanding of securing and leveraging data resources.
- Good experience in Data Warehousing ,Data Quality , Data Visualization & Data Masking techniques.
- Analytical problem-solver with a detail-oriented and methodical approach.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Data Architect
Accenture
Bengaluru, India
03.2018 - Current
- Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
- Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
- Migrated numerous legacy systems to newer technologies, reducing costs and enhancing efficiency of computing tasks.
- Designed & developed ETL flows that involves source data cleansing, standardization ,transformation & target file extraction that is again sent to different SAP systems
- Enhancements & Performance improvement for existing ETL codes.
- Handled GDPR activities for RR2R (Revenue Record to Report) & IFRS15 standard modules.
- Involved in DPIA (Data Protection Impact Assessment) for different modules.
- Carry out weekly team meetings, Client connects & Operation delivery meeting with the Management.
- Facilitated Scrum framework – sprint planning, backlog grooming, daily scrums, sprint reviews and sprint retrospectives.
Data Quality lead
Accenture
Bengaluru, India
12.2016 - 02.2018
- Ensure Data quality, perform data validation, verification of data flowing from different HRMS module to Data hub
- Profiling of Source data and perform reconciliation between different data sources
- Assist ETL development team with the understanding of data, its sources & various upstream & downstream processes
- Build DQ framework using PL/SQL & Dynamic SQL to compare data between difference Source & Target
- Execute DQ process to validate & verify the data flow between difference systems
- Identify test scenarios to validate data flow from difference source to target via ETL
- Work with the MSTR reporting team to validate various cubes data and ensure dashboards retrieve the required data for reporting purposes
- Understanding ETL mappings & transformations to write DQ rules for different entities for both technical scenarios & functional scenarios
- Raise defect based on the data differences between systems, provide analysis and work with the ETL dev team to fix the defect
- Investigate data quality issues and give appropriate solutions.
Application development Team Lead
Alstom Transport AMS
Bengaluru, India
11.2015 - 12.2016
- Coordinating with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
- Involved in writing business logic using PL/SQL that manipulates data stored in an Oracle DB
- Involved in ETL , using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures
- Analysing & debugging issues occurring in different Production & non Production environments
- Work on enhancements, change requests & new releases for the existing application
- Creating different unix shell scripts to automate various batch processes
- Involved in the continuous enhancements and fixing of production problems
- Designed, implemented and tuned interfaces and batch jobs
- Managing multiple right from transition to team members, application support (L2/L3) small enhancements & change requests
- Secondary Responsibilities:
- Was involved in mobilisation activity for smooth transition & handover from Client and other stakeholders during initial phases of the project
- Ensured timely completion of KT timelines and deliverables
- Handling Vulnerabilities management & Knowledge management processes
- Involved in various Continuous Improvements initiatives to automate recurring activities and repetitive tickets reduction to reduce manual efforts
- Involved in Re-hosting activities for various applications from one old Datacenter to the new one.
Application development Senior Analyst
IMFA.net
Bhubaneswar, India
06.2014 - 10.2015
- Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
- Worked on SQL
- Loader to load data from flat files obtained from various facilities every day
- Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module
- Performance tuning of the existing code for better and faster execution
- Scheduling of different jobs for proper execution on a daily basis
- Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE
- Created different unix scripts to automate tasks and schedule jobs using crontab
- Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching
- Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
- Created indexes on the tables for faster retrieval of the data to enhance database performance.
Systems Engineer
TCS
Bhubaneswar, India
11.2012 - 06.2014
- Worked as a developer for Informatica to PL/SQL rewrite
- Tracking the ETL workflow and design to write a similar logic using PL/SQL procedures
- Implemented a generic logic using Dynamic SQL to handle different incoming file formats that were earlier processed through /loaded with the help of Informatica
- Involved mainly with processing GL Posting and Autorec files and paving their way to the target GL tables(posting) or different Reports(autorec)
- Worked on SQL
- Loader to load data from flat files obtained from various facilities every day
- Implementation of DCA(Data Capture architecture) in pl/sql to replace ETL mappings for processing incoming flat files having GL data
- Registering jobs through Concurrent Programs to run through OracleApps front end
- Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements
- Scheduled jobs to run through Autosys
- Retrofication of General Ledger database objects from 11g to 12i.
Systems Engineer
Tata Consultancy Services
Gurgaon, India
04.2012 - 10.2012
- Worked as a developer for making enhancements to table structure, migrating data to target table
- Optimized pl/sql procedures for better performance, faster execution
- Scheduling different processes using $universe for automation
- Worked using Hints to achieve the performance and Tuned SQL, Stored procedures, created views improved the performance of the reports
- Develop Reports; based on Business requirements, using SQL, PL/SQL concepts like Stored Procedures
- Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs
- Wrote SQL, PL/SQL, SQL
- Plus programs required to retrieve data using cursors and exception handling
- Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries
- Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
Systems Engineer
BSNL A&M
Gurgaon, India
07.2010 - 09.2012
- Worked as a pl/sql developer in SLR team that deals with providing Sub Ledger Reports to BSNL and handling reconciliations for the same
- Handled RA & FMS module i.e
- Revenue Assurance and Fraud Management System which involved providing different Billing reports and carrying out verification and validation of reconciliation reports
- Created and modified SQL
- Plus, PL/SQL and SQL
- Loader scripts for data conversions
- Wrote SQL, PL/SQL, SQL
- Plus programs required to retrieve data using cursors and exception handling
- Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries
- Handled different L3 activities for applications
- Has worked on Plan Configuration of different price plans for BSNL using Billing Catalogue Maintenance GUI of Convergys Infinys Rating and Billing tool
- Wrote Shell Scripting programs to execute PL/SQL and SQL Files
- Has worked on Testing and Mapping of new Price plans for BSNL
- Has also worked in Rollout team which is concerned with providing live support at client locations and making them understand the various business processes and their workflow.
Education
Bachelor of Engineering - Information Technology
Silicon Institute of Technology, Biju Patnaik University of Technology
Skills
Oracle
Informatica PowerCenter 101
Tableau 105, Power BI,MS Excel
Unix,Linux,Windows
SQL, PL/SQL, Unix shell scripts
Agile Development
Analytics
Team Building
Training and mentoring
AWS (EC2, ELB, RDS, S3, Cloudwatch)
Certification
AZ-900: Microsoft Azure Fundamentals
Timeline
AZ-900: Microsoft Azure Fundamentals
07-2020
Data Architect
Accenture
03.2018 - Current
Data Quality lead
Accenture
12.2016 - 02.2018
Application development Team Lead
Alstom Transport AMS
11.2015 - 12.2016
Application development Senior Analyst
IMFA.net
06.2014 - 10.2015
Systems Engineer
TCS
11.2012 - 06.2014
Systems Engineer
Tata Consultancy Services
04.2012 - 10.2012
Systems Engineer
BSNL A&M
07.2010 - 09.2012
Bachelor of Engineering - Information Technology
Silicon Institute of Technology, Biju Patnaik University of Technology