Sonia E Email & Phone Number

Singapore, Singapore

Singapore

• Use ETL(SSIS) to develop jobs for extracting, transforming and loading data into target data tables• Create SSIS packages to extract data from multi formatted Flat files, Excel & XML Files.• Use different transformation like Lookup, Condition Split, Derived column, Data Conversion etc..• Designing and Developing Type 1 & 2 Slow Changing Dimensions in order to maintain the changes in databases for business purposes.• Have good experience with designing and implementing MOLAP, ROLAP and HOLAP in SSAS• Create reports in SSRS with different type of properties like filters, Interactive sorting, SQL parameters• Generate several drill down and drill through reports using SSRS• Create Packaged configuration file with staging and destination databases.• Prepared Technical Documentation for every stored procedure and updated stored procedures with new data elements. • Work on querying and analyzing large datasets. • Creating Database objects -Schema, Tables, Views, indexes, roles• Performed SQL Backup and Restore tasks on Various SQL Servers• Experience in coding using C#.net while working with SSIS• Assist in design and development of Data Warehouse/Data Mart• Setting up of SFTP accounts for data transfer between agencies.• Performing encryption and decryption testing

Singapore

Technical Engineer - (Nov 2015 – July 2020)Roles and Responsibilities: • Use ETL(SSIS) to develop jobs for extracting, transforming and loading data into target data tables• Create SSIS packages to extract data from multi formatted Flat files, Excel & XML Files.• Use different transformation like Lookup, Condition Split, Derived column, Data Conversion etc..• Designing and Developing Type 1 & 2 Slow Changing Dimensions in order to maintain the changes in databases for business purposes.• Have good experience with designing and implementing MOLAP, ROLAP and HOLAP in SSAS• Create reports in SSRS with different type of properties like filters, Interactive sorting, SQL parameters• Generate several drill down and drill through reports using SSRS• Create Packaged configuration file with staging and destination databases.• Prepared Technical Documentation for every stored procedure and updated stored procedures with new data elements. • Work on querying and analyzing large datasets. • Creating Database objects -Schema,Tables,Views,indexes,roles• Performed SQL Backup and Restore tasks on Various SQL Servers.• Experience in coding using C#.net while working with SSIS.• Assist in design and development of Data Warehouse/Data Mart.• Develop workbooks and responsive dashboards for company to analyse assignment performance and revenue performance using advanced BI visualization with Tableau.• Experienced with VLOOKUP’s and data sorting and filtering.• Wide experience in developing various Pivot tables.• Responsible for handling and resolving reporting issues related to existing as well as the new changes been implemented inside the organization.• Supported the users and the management in providing the analysis and forecasting reports.

Singapore

Roles and Responsibilities: • Preparation of IO Lists, Cable Lists, Instrument Lists• Perform electrical design and prepare drawings for the client using E-plan & AutoCAD (11 Yrs).• Preparation of as-built drawing prior for submission to Clients.• Prepare Bill of Materials (BOM)

Specialist Diploma In Business And Big Data Analytics, Data Processing And Data Processing Technology/Technician

Bachelor'S Degree, Information Technology