Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Rachid Rami

Pawtucket,RI

Summary

8+ years of IT experience focusing on Data integration, Data Conversion, Data Analysis, Consultancy, Data warehousing, ETL development and Business Intelligence. Delivered innovative database /data warehousing solutions to multiple Government tax and Child support agencies as well as Finance Industries. Extensive experience in developing stored procedures, Complex queries using TSQL and Oracle PL/SQL. Experience in resolving on-going maintenance issues and bug fixes. Experience in data migration from various data sources like Excel, SQL Server, Oracle, XML files, Flat files using SSIS, ODI and/or straight SQL, Monitoring, debugging and tuning ETL jobs and workflows. Experience in generating on-demand and scheduled reports for business analysis using SQL Server Reporting Services (SSRS). Experience in creating test data and unit test cases, writing validation scripts to ensure successful data loading process. Experience in performance tuning of SSIS packages, Query optimization and database consistency checks. Very good skills of documenting different kinds of metadata. Experience in using Team Foundation Server (TFS) as well as JAZZ as a tool for source control, data collection, reporting and project tracking. Thorough knowledge in RDBMS concepts. Hard worker, fast learner and result oriented. Remarkable logical, analytical and interpersonal skills. Good communication skills; written and verbal.

Seeking a position as a Database Analyst/ ETL Developer to leverage a company’s investment as well as provide an opportunity for advancement. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Overview

9
9
years of professional experience
1
1
Certification

Work History

ETL Developer/Data Analyst Consultant

Revenue Solutions INC
10.2021 - Current
  • Identify column level data quality issues of source systems to drive data quality, data cleansing and error checking in ETL packages.
  • Analyze business requirements and worked closely with business users in multiple projects in US and Canada to understand business requirements to design process for data extraction, business logic implementation and loading into target tables.
  • Extract data from different external files as well as RDBMS databases into staging area and populated onto Data Warehouse using Visual Studio and/or Jams.
  • Migrate SSIS packages, files, folders between different environments on remote servers.
  • Design and document error-handling strategy in ETL packages.
  • Develop different kinds of reports per requirement using SSRS reporting functionality.
  • Create test data and unit test cases to ensure successful data loading process
  • Being involved in troubleshooting and resolved complex technical issues.
  • Wrote all Selection SQL queries to audit tax non-filers for Saskatchewan Ministry of Finance (Canada) as part of compliance program implemented by our company.
  • Wrote and executed code to convert Individual Income Tax for Missouri Department on Revenue project using Stored Procedures
  • Use SSRS to create reports as needed and specified by client.
  • Mentor and assist new hires and/or employees new to BI development responsibility, to quickly learn what they need to know to succeed in their job and role.
  • Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
  • Reduced processing time for ETL tasks through implementation of parallel execution strategies.
  • Mentored junior developers on best practices in ETL development, fostering culture of continuous learning within team.
  • Conducted regular code reviews to ensure adherence to coding standards and maintain overall code quality across projects.
  • Established effective communication channels with key stakeholders to ensure timely delivery of project milestones.
  • Deployed scalable solutions capable of handling large volumes of data while maintaining high standards of reliability and performance.
  • Documented technical specifications and designs, facilitating knowledge sharing among team members and supporting future development efforts.
  • Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
  • Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
  • Wrote and optimized in-application SQL statements.
  • Developed strong working relationships with clients by consistently delivering high-quality results tailored to their unique requirements.
  • Improved data accuracy by conducting thorough data cleansing and validation processes.

ETL Developer/Data Integration Specialist/ Consultant

Accenture/RSI
01.2019 - 10.2021
  • High level involvement in requirement gathering, estimation and design with customer and helping out in data modeling and creating High level and low level Design Documents
  • Mapped more than two thousand columns from legacy tables to new application tables
  • Wrote Ad hoc SQL scripts to analyze and understand legacy data
  • Worked in Client location and directly dealing with new business requirements
  • Involved in writing a bigger part of ETL rule document based on client needs
  • Designed, developed, and implemented custom Oracle Data Integrator ODI Modules in order to take advantage of power of database engine
  • Extracted, transformed and loaded EL/T millions of data rows using Oracle Data Integrator 12 C.
  • Developed ETL flows to get data from Operational Data Store and loading it to target using ELT tool Oracle Data Integrator using different Knowledge Modules
  • Expertise in all modules of Oracle Data Integrator ODI implementations including Repository, Topology, Contexts creations in Oracle data Integrator (ODI).
  • Involved in functional testing, Performance testing, data validations etc.
  • Wrote PL/SQL test scripts to validate converted table level counts as well as column level counts.
  • Reviewed and ensured documentation and configuration implemented are in sync with the changes in Requirement, Design, and Code Changes
  • Worked and consulted with the client on the entire change requests, proposing the possible solutions and how to implement them
  • Involved in the long go-live process to move from the retired legacy system to new system
  • Involved in the complete software development life cycle (SDLC).

Data Engineer

Revenue Solutions INC
07.2015 - 01.2019
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
  • Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
  • Collaborated with cross-functional teams for seamless integration of data sources into company's data ecosystem.
  • Established robust monitoring processes to proactively detect system anomalies or performance bottlenecks before they impact users or critical operations.
  • Conducted extensive troubleshooting to identify root causes of issues and implement effective resolutions in timely manner.
  • Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.

Education

Database Management Technologies Certificate -

University of Massachusetts
Lowell, MA
01.2014

Linux/Unix OS & Oracle Database Administration Training -

TechSkills
Bloomington, MN
01.2007

M.B.A -

Johnson & Wales University
Providence, RI
01.2006

Skills

  • SQL development
  • Data Quality Management
  • Data Mapping
  • Data Governance
  • Performance Tuning
  • Data Warehousing
  • Business Intelligence
  • Change Data Capture
  • Data Warehousing Management
  • Report Generation
  • Data Analytics
  • Requirements Gathering
  • Technical and Functional documents writing

Certification

  • Data engineering Training - 2019-2022
  • Microsoft Azure AZ900 Certification
  • MDM and Data governance training

Timeline

ETL Developer/Data Analyst Consultant

Revenue Solutions INC
10.2021 - Current

ETL Developer/Data Integration Specialist/ Consultant

Accenture/RSI
01.2019 - 10.2021

Data Engineer

Revenue Solutions INC
07.2015 - 01.2019

Database Management Technologies Certificate -

University of Massachusetts

Linux/Unix OS & Oracle Database Administration Training -

TechSkills

M.B.A -

Johnson & Wales University

Similar Profiles

CREATE PROFILE
Rachid Rami