Nasrin: Resume/ * of *

Nasrin Aktar

(***) ***- *278

ady5s9@r.postjobfree.com

https://www.linkedin.com/in/nasrin-aktar-4a182917

Summary

Experienced data analyst.

Contribute to systems conversion and data migration.

Administer databases to ensure data security, integrity, and quality.

Manage, maintain, and ensure data consistency and accuracy.

Provide technical support and analytical assistance for data use and utilization.

Produce and deliver datasets and data reports in the requested format.

Demonstrated ability to learn, improve, and acquire further efficiency.

Capable of working independently or in a team under minimal supervision. Skills

Data Analysis: Screening, Evaluating,

Summarizing, and presenting data

Data management: identifying odds and

inconsistencies, cleansing, editing, and

implementing updates

Data Integration: logical and consistent

Data Migration: Conversion and Mapping

Data Dissemination: datasets and summaries

Documentation: processes and techniques

Provide technical and analytical to identify and resolve conflicts and issues

Experience working in Azure platform and

DevOps

RDBMSs: SQL Server, Oracle, and SQL/DS

MCAS: Excel, Access; MCTS: Microsoft CRM

Professional Experience

Database Administrator/Analyst, KCS 2022 - 2023

Data Management: With a focus on managing and maintaining databases to ensure data integrity and accuracy, the role involved distributing data and reports to meet business’ needs. This included providing users with requested datasets and customizing electronic forms to capture data, as well as modifying reporting templates to align with specific requirements. Responsibilities also encompassed periodic management and updating of databases to endorse flawless data quality within systems such as SIS, Raiser's Edge, and SQL Servers

Data extraction and report creation: Extracting data and creating useful reports involves efficiently accessing databases using various techniques and tools. By writing SQL queries retrieved specific information from complex data structures based on criteria or conditions. Transformed and manipulated data for reporting purposes, including applying cleansing, formatting, and integration from multiple sources. Identified glitches and inconsistencies, contributed to data-driven decision-making processes by providing accurate and actionable information to stakeholders. Effectively communicated complex information in alignment with business objectives

Nasrin: Resume/ 2 of 4

Users’ support: Customized, managed, and distributed data and reports based on business needs. This involved tailoring existing tools and techniques to align with specific requirements, such as designing layouts and modifying data fields. Facilitated easy and instant access to data for users by utilizing SQL queries and report templates enabling users to quickly retrieve the desired data in a structured and organized format

Technical Assistance: Automated mass data updates by customizing tools and techniques (queries, stored procedures) to eliminate manual processes of frequent updates and changes to data. This involved developing scripts by linking multiple data tables for desired data items, saving time, reducing errors, and ensuring accurate, consistent, and up to date data availability

Systems used: PowerSchool SIS (PM 23.1.0), Blackbaud Raiser's Edge (version 7.9) IT Data Analyst, SBCI, Toronto 2018–2022

Was actively involved in the routine data cleansing process of organization’s Absence Study (AS) project, aiming to enhance data quality and eliminate errors or inconsistencies. Utilized various techniques and tools available in MS Office suites to ensure data accuracy and consistency

In order to verify the completeness of processes, run existing reports templates on cleaned data that provides a concise overview of the captured data and highlights any issues or discrepancies

To maintain standardized and easily accessible data for analysis and reporting, was responsible to upload cleaned data into the Master Database after undergoing necessary cleansing and validation procedures

Participated in a data conversion project (EDS) with specific focus on transitioning data to a more robust and scalable environment. Was assigned the task of testing and validating data accuracy, integration, and migration from multiple Access databases to Azure SQL Server

Conducted thorough data analysis and comparison of migrated data with the original data in legacy systems, identifying conflicts, glitches, or issues during the conversion process

Documented findings, including identified conflicts or glitches, and proposed solutions for resolution. Collaborated with the project’s developer group to address any issues or discrepancies that occurred during the conversion process

Systems used: Excel, Access, Azure SQL Server

National Data Integrity Analyst, JDRF, Toronto 2017–2018

Inspect, edit, compile, transform capture data into a presentable format ensuring its accuracy and reliability.

Update and modify input data to maintain data quality and integrity, making required adjustments.

Identify and address conflicts or issues that impeded process flows, compromise quality, posed security risk.

Systems used: Clear View CRM, Donor Drive & AKA Raisin Data Analyst, CVIS Project, The Hospital for Sick Children 2014–2017

Was engaged in a system conversion project that facilitated the transition of diagnostic data from MUSE to LumedX's EMR Systems. Played a key role in ensuring smooth and successful conversion by leveraging skills and knowledge

Conducted scanning and analysis of legacy data in SQL Server, ensuring the accuracy of the conversion process. Collaborated with professional experts when necessary to address any challenges or concerns

Actively monitored and reported glitches, conflicts, and performance issues to vendors, providing detailed information and documentation of the probable resolution

Contributed to the preparation of comprehensive manuals, conducted training sessions, and provided one- on-one assistance during systems implementation, ensuring a successful migration of database systems Nasrin: Resume/ 3 of 4

Systems used: SQL Server 2008 R2, LumedX's EMR ( ApolloLX, ScheduleX), Excel, Access SQL Data Analyst, Corporate Office - FRHI, Toronto 2012–2013

Compiled operational insights of this global business into Excel datasets, consolidating and organizing data for analysis and reporting purposes

Created complex SQL queries to manipulate and compile data, leveraging the power of the database management system to extract relevant information and generate meaningful insights

Documented SQL scripts and PL/SQL procedures for mutual use within the team, ensuring consistency of data pull and facilitating collaboration in database-related tasks

Utilized various systems and tools including Excel, Access, and Oracle Database 11g to perform data analysis, query execution, and database management tasks.

Computer Instructor, HiTech Network Inc., Toronto 2011–2012

Conducted corporate training sessions for MS Dynamics CRM, MS Access, and MS Excel, providing instruction and guidance to participants on how to effectively utilize these software applications

Delivered classes using a combination of formal presentations and hands-on demonstrations, ensuring participants gained practical knowledge and proficiency in using the tools

Managed web-based inquiries, prepared files, created reports, and promptly responded to customer inquiries, ensuring timely and accurate resolution of their concerns

Applications used: Excel, Access, MS Dynamics CRM 4.0, MS Dynamics CRM 2011 Data Analyst, Corporate Office, HDC, Toronto 2011–2011

Managed and analyzed inventory and purchase orders' data, ensuring accurate and reliable information for effective inventory management and purchasing decisions

Handled data transactions and uploads from Excel to the ERP system, ensuring seamless data integration and maintaining data consistency

Extracted and manipulated data to create customized data sets as per users' requests, meeting their specific data requirements and supporting their analytical needs

Produced data aggregate forecasts to assess inventory status and determine purchasing requirements, enabling proactive inventory management and efficient procurement processes

Ensured data uniformity and integrity by actively collaborating with resources and maintaining effective communication with other offices or departments

Systems used: SAP/ERP, Excel, Access, BI Tool, and Win Shuttle Database Administrator, RealCo - a project of TDSB, Toronto 2006

Planned, designed, and defined database systems to effectively collect, store, and document business process data, ensuring efficient data management and retrieval.

Inspected, edited, and updated data while preparing existing HR and inventory data for seamless integration into the database, maintaining data accuracy and consistency.

Implemented databases to consolidate and integrate relevant processes into a unified system, facilitating streamlined operations and improved data accessibility.

Created and documented queries and reports, leveraging database capabilities to generate meaningful insights and facilitate informed decision-making by users. Nasrin: Resume/ 4 of 4

Managed databases, ensuring their smooth operation, performance optimization, and adherence to data security and integrity standards.

System used: MS Office products, such as Front Page, Word, Excel, Access Programmer/Data Base Assistant, ICDDR’B 2002–2005

Worked in an international health research organization’s demographic surveillance system (DSS) project and was closely involved in the data processing. Worked extensively with large-scale data sets that were collected in flat files (FF) and stored in relational databases (DB). My responsibilities included the following:

• Data Handling: Responsible for comprehensive data management tasks including inspection, cleaning, editing, updating, analysis, manipulation, compilation, reporting, and documentation of processing history.

Data processing: Ensured smooth data process flow, detected/reported setbacks, and performed routine backups and restoration to prevent data loss

Application and Systems involvement: Worked proficiently with SQL/DS and Oracle database systems on different platforms, creating complex queries using SQL queries and PL/SQL procedures

Reporting: Collected and prepared data from various sources in requested formats, making significant contributions to periodic reporting with diverse data presentations

Systems Integration: Engaged in data conversion projects, carefully analyzing and mapping data values for seamless transitions, while collaborating effectively with data sources and IT systems to ensure successful integration

Documentation: Developed comprehensive system documentation, including user manuals and a digital

"Documentation System" facilitating efficient data dissemination within the team

Other responsibilities: Assumed additional responsibilities beyond the primary job role, including acting as a Storage Librarian, serving as a Liaison between data generating and data processing team, and coordinating data dissemination projects

System used: Main Frame Computer S/4361, Oracle Developer 7.3.2.1.0., MS Office Suites Education, Certification, Trainings

Post Graduate Certificate in Health Informatics - Canada

Microsoft Certified Application Specialist (MCAS) in Excel, Access - USA

Microsoft Certified Technology Specialist (MCTS) in CRM 4.0 Applications - USA

Strategies, Tools & Techniques of Client-Server Applications, Oracle platform - Thailand

Oracle Developer2000 Training in SQL*Plus, PL/SQL, SQL - India

Diploma in Computer Science - IUBAT

Bachelor of Science - R.U.

Contact this candidate