Shaigi Abraham
Sheffield
Summary
1st Class Honours Masters' degree qualified IT Engineer with over 18 years' experience encompassing Data migration consultancy, SQL development, software development, configuration and implementation. I am currently working as a Data migration consultant.
Proven track record in executing large scale data migrations, optimizing database performance and ensuring data integrity throughout the migration process. I have experience in the full life cycle process of data migration (Planning and Assessment, Design, Preparation, Data Migration, Validation and Testing, Post Migration Review and Support). Strong problem-solving skills combined with excellent communication skills with both internal and external stakeholders.
Overview
17
17
years of professional experience
2004
2004
years of post-secondary education
Work history
Data Migration Consultant
Egress Group
05.2022 - Current
- ERP / HCM Data Migration Consultant for migrating data from Oracle E-Business Suite to Oracle Fusion environment.
- Currently Working for South Yorkshire Police (SYP), Lancashire City Council (LCC) and IBM projects to migrate data from Oracle EBS to Oracle Fusion.
- Involved in the full life cycle of migration from Planning to Support.
- Involved in migrations from other source systems.
- Strong expertise in data extraction, transformation and loading (ETL) between systems.
- Building data migration packages
- Providing consultancy and managing client expectations under strict deadlines.
- · Provide and review technical documentation like FBDL, mapping templates, validation rules, testing documents, Data migration file specification and generating reports.
- · Fixing and advising on migration / Issues for clients.
- · Advance interpersonal skills, possessing the confidence to build relationships with stakeholders at all levels.
SQL Developer / Data Migration Consultant
The Access Group
08.2016 - 05.2022
- Lead Data Migration Consultant for more than 15 Local Authorities across England and Scotland providing data migration consultancy
- Strong expertise in ETL process design, along with developing Oracle / SQL scripts
- Involved in writing complex queries, stored procedures, triggers, functions, joins and views
- Giving consultancy to many clients across United Kingdom to migrate data from various legacy systems to Mosaic social care system
- Provide and review technical documentation like scope documents, mapping templates, validation rules, testing documents, data migration file specification, load summary report for clients
- · Fixing and advising on Migration / SQL issues for clients from various projects.
SQL / Configuration Developer (Implementation)
Servelec Healthcare
01.2011 - 08.2016
- Creating complicated SQL scripts, stored procedures, views and functions that are used within reports to minimise performance issues with large dataset
- Document code, provide progress reports, and perform code review and peer feedback
- Backup and restore of databases: refreshing databases with copies of other databases
- Creating and executing anonymised scripts on copy of LIVE databases to remove confidential data
- Run localisation scripts to configure RIO as per trust requirement
- Scheduling SQL jobs, importing\exporting certificates, controlling access permissions and privileges
- Installing and configuring SQL server
- Involved in the merge projects for various Trust
- Executing scripts to ensure elimination of duplicate data, merging with the correct data and enhancing the performance of the Database
- Involved in triaging issues, bug fixing issues, coordinating with the internal team, and communicating with trust with the updates
- Managing legacy data migration activities, including writing data migration specifications and data migration software
- Involving configuration of forms, reports, letters, and role based access, system constants
- Problem solving and troubleshooting on external projects, working closely with the customer
- Good feedback / recognition from external clients / Managers
- Involved in requirements gathering at client's offices throughout UK
- Created configuration specification based on the requirements for each Trust
- Interacted with external clients throughout the process of requirements gathering, database implementation, bug fixing and warranty support.
Software Developer (RIO)
Servelec Healthcare
08.2007 - 12.2010
- Creating Software design specification / Functional design specification
- Developing Software for new Releases and helping troubleshoot issues
- Diagnosing and correcting problems in the application software
- Assess the impact of software changes on other parts of the system
- Code review and peer testing
- Follow the appropriate coding standards and procedures.
Education
Masters in Computer Applications (MCA), First Class -
Skills
- Oracle
- MS SQL Server
- ETL Tools experience
- Data Mapping and Transformation
- SQL Proficiency
- SSIS , SSMS
- Query optimisation
- Database management
- Performance tuning
- Database design
- ASPNet
- C#
- Visual Basic
Timeline
Data Migration Consultant
Egress Group
05.2022 - Current
SQL Developer / Data Migration Consultant
The Access Group
08.2016 - 05.2022
SQL / Configuration Developer (Implementation)
Servelec Healthcare
01.2011 - 08.2016
Software Developer (RIO)
Servelec Healthcare
08.2007 - 12.2010
Masters in Computer Applications (MCA), First Class -
Similar Profiles
Daniel DurdinDaniel Durdin
Senior Integration Consultant at Egress GroupSenior Integration Consultant at Egress Group
Rachel RussellRachel Russell
Category Manager Electronics at Access and Egress Hardware Group a division Assa AbloyCategory Manager Electronics at Access and Egress Hardware Group a division Assa Abloy
Sharine WenzelSharine Wenzel
Outside Sales Representative at Denver Egress WindowOutside Sales Representative at Denver Egress Window
Charlie RowlesCharlie Rowles
Waiter and Kitchen Assistant at Woodseats HallWaiter and Kitchen Assistant at Woodseats Hall
ANETA SARAPATAANETA SARAPATA
Housekeeper at Travelodge Sheffield Central HotelHousekeeper at Travelodge Sheffield Central Hotel