Swati
Summary
Practical data engineer possessing in-depth knowledge of data manipulation techniques Offering 3+ years of background, managing various aspects of development, design and delivery of database solutions. Tech-savvy and independent professional bringing outstanding communication and organizational abilities.
Overview
4
4
years of professional experience
Work History
Data Engineer
Honeywell
Gurugram
07.2023 - Current
- Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
- Design, develop, build, and implement ETL utilizing SQL Program with Snowflake.
- Optimized existing queries to improve query performance by creating indexes on tables.
- Created stored procedures for automating periodic tasks in SQL Server.
- Optimized SQL queries and database schemas for performance improvements in data retrieval operations.
- Streamlined data flow from diverse sources using ETL tools such as Informatica, and Altryx.
- Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL.
- Work closely with project management, analysts, data modelers, and ETL developers to understand project requirements.
Business Analyst
Genpact Headstrong Capital Markets
02.2022 - 07.2023
- Responsible for developing, compiling, and analyzing all formal business needs for clients
- Build and maintain a framework to research, manage, timely resolve queries, and troubleshoot, ensuring preparation and timely delivery of reports for global clients with the help of tools Like Business Object Xi, SQL, Power BI
- Maintaining data quality and data accuracy of clients' investments as well as company Equity and Non Equity holdings using share point and Excel
- Creating customized reports based on client's requirements on investment analyst's interaction which involves data cleaning, data transfer, Data modification, visualization and Trouble-shooting reporting anomalies and modify existing reporting packages as business needs require
- Automating reports of analyst based on their research and handling daily tasks, managing and ensuring the consistency and transparency of data.
Analyst
Vaco Binary Semantics
10.2020 - 01.2022
- Develop and design reports and dashboards using a variety of data mining and presentation tools
- Drive efficiencies within the current reporting structure including enhanced automation
- Coordinate and complete ad-hoc inter-department requests and requests from strategic partners by providing decision support and consultative services
- Creating and executing daily and monthly reporting for management and industry benchmarking.
Education
Post Graduation - M.Sc. Physics
APG Shimla University
08.2020
Graduation - B.Sc. Physics
Dibrugarh university
07.2018
Skills
- Data Warehousing
- Data Modeling
- SQL and Databases
- Relational databases
- Stakeholder Management
- Data Transformation
- Analytical Thinking
- Adaptability
Hobbies and Interests
- Culinary Exploration
- Exploring New Technologies
- Financial Investments
TECHNICAL SKILLS
Languages : SQL, Python
ETL tools : Informatica, Altryx
Data wearhouse: SQL Server, Snowflake
Projects
Youtube data analysis using AWS service:
- Create a dashboard using AWS service like s3 bucket, Athena,Glue, IAM role and snowflake .
- Analyzes data of different region and transform raw data into meaningful insight.
SQL Case Study: Danny's Dinner
- Applied basic to advanced SQL functions to solve case study problems using day-to-day data.
- Utilized window functions such as Row Number, Dense Rank, and Inner Join.
Timeline
Data Engineer
Honeywell
07.2023 - Current
Business Analyst
Genpact Headstrong Capital Markets
02.2022 - 07.2023
Analyst
Vaco Binary Semantics
10.2020 - 01.2022
Post Graduation - M.Sc. Physics
APG Shimla University
Graduation - B.Sc. Physics
Dibrugarh university
Similar Profiles
Gary HuardGary Huard
Senior Field Service Supervisor at HoneywellSenior Field Service Supervisor at Honeywell
Jeremy BennettJeremy Bennett
Maintenance Technician at HoneywellMaintenance Technician at Honeywell
Jacob TippettJacob Tippett
Machine Setup Operator at HoneywellMachine Setup Operator at Honeywell
Freeman HeathFreeman Heath
Workflow Specialist at HoneywellWorkflow Specialist at Honeywell
Anudeep Rao DagguAnudeep Rao Daggu
Data Engineer at Johnson & JohnsonData Engineer at Johnson & Johnson