Rakesh Jami
Los Angeles,CA
Summary
- Over all 3+ years of strong experience in Data Engineering, Data Analysis with large data sets of structured and unstructured data, Data Validation, Data acquisition, Data Modeling and Data Visualization.
- Hands-on experience in handling database issues and connections with SQL and NoSQL databases such as MongoDB, Cassandra, SQL server, and PostgreSQL.
- Proficient in designing, developing, and implementing data pipelines using Azure Data Factory and Synapse Analytics to orchestrate and automate data workflows, ensuring efficient data ingestion, transformation, and loading processes.
- Hands On experience in using Azure Analytics services - Azure Data Lake Storage, Azure SQL DW, Azure data bricks, Azure Data Factory and Azure Synapse Analytics.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Azure DataLake Developer
Los Angeles Police Department
Los Angeles
10.2023 - Current
- Worked on migration of data from On-prem SQL server to Cloud databases (Azure Synapse Analytics (DW) & Azure SQL DB).
- Designed and developed batch processing and real time streaming solutions using ADF, databricks cluster and stream analytics.
- Performed the dataflow transformations using the dataflow activity.
- Worked with the complex SQL Views, stored procedures, triggers in large databases from various servers.
- Configured Azure data platforms for data pipelines, ADF, Azure Blob storage and Datalakes. Build workflows to automate data flow activities.
- Performed data mapping and validation to ensure that the data is accurate and consistent during the data migration process.
- Implemented data quality solutions using informatica data quality (IDQ) to ensure data accuracy, completeness, and accuracy.
- Created visually appealing and interactive dashboards using Power BI Desktop, designing, and implementing data visualizations, charts, graphs, and KPIs.
Data Engineer
DXC Technology
Hyderabad, Telangana
06.2020 - 11.2021
- Responsible for design,developing and maintenance for the ETL processes using the Informatica power center.
- Developed Data Stage extract jobs using SQL server SSIS and load the data into a staging area in the form of flat files/Data Sets.
- Extensive experience with SQL/PLSQL programming and query tuning.
- Created SSIS packages to clean and load data to data warehouses.
- Developed Data Analysis Expressions (DAX) formulas to perform complex calculations, create custom measures, and build calculated tables to support advanced analytics within Power BI.
Education
Master of Science - Data Science
Kent State University
Kent, OH05-2023
Bachelor of Science - Electronics And Communication Engineering
Malla Reddy Engineering College
Hyderabad09-2020
Skills
- Programming: Python, SQL, PL/SQL,MS-SQL,SAS
- Databases: Oracle, DB2,Postgres SQL,MYSQL
- ETL Tools: Informatica power center, SSIS, ADF, Azure Synapse
- Cloud Technology: AWS, Azure
- Tools: SQL Developer, Azure Data Studio, SSMS, GitHub, Visual studio, SQL Assistant,PySpark
- Visualization: Tableau, Power BI, Excel
Certification
- Hacker Rank (SQL Basic): https://www.hackerrank.com/certificates/08d817b18983
- Hacker Rank (SQL Intermediate): https://www.hackerrank.com/certificates/22577be5c8b0.
- Hacker Rank (SQL Advance): https://www.hackerrank.com/certificates/9c75f6710e66.
Timeline
Azure DataLake Developer
Los Angeles Police Department
10.2023 - Current
Data Engineer
DXC Technology
06.2020 - 11.2021
Master of Science - Data Science
Kent State University
Bachelor of Science - Electronics And Communication Engineering
Malla Reddy Engineering College
Similar Profiles
Paul MadisonPaul Madison
Police Officer-II at Los Angeles Police DepartmentPolice Officer-II at Los Angeles Police Department
STEPHEN GLICKSTEPHEN GLICK
Police Officer - Leadership & Training at Los Angeles Police DepartmentPolice Officer - Leadership & Training at Los Angeles Police Department
Craig MarquezCraig Marquez
Officer In Charge - Detective Training at Los Angeles Police DepartmentOfficer In Charge - Detective Training at Los Angeles Police Department
Tristin DotsonTristin Dotson
Police Officer at Los Angeles Police DepartmentPolice Officer at Los Angeles Police Department
Jennifer BedollaJennifer Bedolla
Substitute Program Leader at Think Together, SELASubstitute Program Leader at Think Together, SELA