Data Engineer Sql Server

Sama Srujana

Email: ******************@*****.*** Mobile: 940-***-**** Location: Lewisville, TX

PROFESSIONAL SUMMARY

6+ years of experience as a Data Engineer, specializing in data solutions for the Courts and Justice division.

Expertise in SQL Server Reporting Services, SQL Server Integration Services, and Power BI for data visualization and reporting.

Proficient in T-SQL, data modeling principles, and ETL processes to ensure data integrity and accuracy.

Strong programming skills in C#, Python, and Java, enabling effective data manipulation and analysis.

Proven ability to collaborate with cross-functional teams to gather requirements and deliver actionable insights.

Exceptional problem-solving and analytical skills, with a detail-oriented approach to data management.

Experience with AWS and big data technologies, including Hadoop, Spark, and Kafka for data processing.

Certified Azure Data Engineer Associate and AWS Solution Architect, demonstrating a commitment to professional development.

SKILLS

Programming Languages: C#, Python, Java, T-SQL, SQL, R, Scala, JavaScript

Frameworks & Libraries: Apache Spark, Apache Kafka, .NET Framework, Pandas, NumPy, Flask, Spring Boot, Hibernate

Databases & Data Warehousing: SQL Server, Azure SQL Database, Amazon Redshift, Snowflake, PostgreSQL, MySQL, Oracle Database, MongoDB

Big Data & Streaming: Hadoop, Apache Spark, Apache Kafka, AWS Glue, AWS Kinesis, Google BigQuery, Databricks, Flink

Cloud Platforms: AWS (EC2, S3, Lambda, CloudWatch), Azure (Data Factory, Synapse Analytics), Google Cloud Platform (GCP), IBM Cloud

DevOps & CI/CD Tools: Jenkins, Docker, Kubernetes, Git, Terraform, Ansible, Azure DevOps, AWS CodePipeline

Testing & QA: Apache JMeter, Postman, Selenium, NUnit, PyTest, TestNG, Data Validation Tools, Data Quality Tools

Security & Compliance: Data Encryption, IAM (Identity and Access Management), GDPR Compliance, HIPAA Compliance, OWASP Standards, Security Audits, Data Masking, Network Security

Monitoring & Observability: Grafana, Prometheus, AWS CloudTrail, Splunk, ELK Stack (Elasticsearch, Logstash, Kibana), Datadog, New Relic, AppDynamics

Collaboration Tools: Atlassian JIRA, Microsoft Teams, Slack, Confluence, Trello, Microsoft Dynamics CRM, Google Workspace, Zoom

Documentation Tools: Microsoft Word, Confluence, Markdown, LaTeX, Google Docs, Visio, Lucidchart, Notion

Operating Systems: Windows, Linux, macOS, Ubuntu, Red Hat, CentOS, Solaris, Debian

CERTIFICATIONS

• Azure Data Engineer Associate (DP-203)

• AWS Solution Architect - Associate

• Databricks Certified Data Engineer Associate

EDUCATION

MS in Information Systems

Trine University GPA: 4.0/4.0

B.Tech in Statistics and Electrical and Electronics Engineering

Christu Jyothi University of Technology Percentage: 80%

WORK EXPERIENCE

Privia Health – Arlington, VA

Senior Data Engineer – January 2024 to Present

Spearheaded the design and implementation of scalable data pipelines using AWS services, resulting in a 30% increase in data processing efficiency across healthcare analytics.

Engineered ETL processes with SQL Server Integration Services (SSIS) to automate data ingestion from multiple sources, reducing manual data entry time by 50%.

Collaborated with cross-functional teams to develop interactive dashboards in Power BI, enhancing data visibility and decision-making for operational leaders.

Optimized existing SQL queries, improving report generation speed by 40% and ensuring timely access to critical business metrics.

Developed and maintained comprehensive documentation for data models and ETL workflows, ensuring clarity and consistency across teams.

Conducted root cause analysis for data discrepancies, implementing corrective measures that improved data integrity by 25%.

Led training sessions for stakeholders on data visualization tools, increasing user adoption rates and empowering teams to leverage data insights effectively.

Implemented monitoring solutions for data pipelines, proactively identifying and resolving issues, which decreased downtime by 15%.

Participated in Agile ceremonies, collaborating with product owners and developers to align data engineering efforts with business objectives.

Utilized Python for data manipulation and analysis, streamlining processes and enhancing the accuracy of predictive models.

Technologies Used: AWS, SQL Server, Power BI, SSIS, Python, T-SQL, Agile, ETL, Data Warehousing, Data Visualization, SQL

Webster Bank – Stamford, CT

Big Data Engineer – May 2021 to July 2023

Automated data processing workflows using Apache Spark, resulting in a 35% reduction in data processing time for large datasets.

Designed and implemented a real-time data streaming solution using Kafka, enabling immediate insights into customer transactions and operational metrics.

Collaborated with data scientists to develop machine learning models, leveraging big data technologies to enhance predictive analytics capabilities.

Optimized data storage solutions in AWS S3, reducing storage costs by 20% while improving data retrieval speeds for analytics.

Developed comprehensive data quality checks and validation processes, ensuring the accuracy and reliability of financial reporting.

Led cross-departmental workshops to gather requirements for data solutions, fostering collaboration and aligning project goals with business needs.

Enhanced existing data models by integrating new data sources, improving the granularity of insights available to business units.

Implemented CI/CD practices for data pipeline deployments, increasing deployment frequency and reducing errors in production environments.

Utilized JIRA for project management, tracking progress and ensuring timely delivery of data engineering projects.

Conducted performance tuning of SQL queries, achieving a 30% improvement in query execution times for critical reports.

Technologies Used: Apache Spark, Kafka, AWS S3, SQL, JIRA, Data Modeling, ETL, Machine Learning, CI/CD, Data Quality

Ross Stores – Dublin, CA

Data Engineer – March 2019 to April 2021

Developed and maintained ETL processes using SQL Server Integration Services (SSIS), ensuring timely data availability for business intelligence reporting.

Collaborated with business analysts to design and implement data models that supported strategic decision-making, improving operational efficiency by 20%.

Conducted data validation and integrity checks, ensuring that reporting metrics were accurate and actionable for management.

Created interactive dashboards in Tableau, enabling real-time insights into sales performance and inventory management.

Implemented automated reporting solutions using SQL Server Reporting Services (SSRS), reducing report generation time by 60%.

Participated in cross-functional teams to identify data needs and develop solutions that enhanced data accessibility across departments.

Utilized Python for data analysis and manipulation, streamlining data preparation processes for analytics teams.

Designed and executed test plans for data pipelines, ensuring robustness and reliability of data transformations.

Provided technical support for data-related inquiries, facilitating effective communication between technical and non-technical stakeholders.

Documented data processes and workflows, creating a knowledge base that improved onboarding for new team members.

Technologies Used: SQL Server, SSIS, SSRS, Tableau, Python, Data Modeling, ETL, Data Analysis, Reporting, Data Integrity

Contact this candidate