Information Technology Power Bi

EDUCATION

SOUNDARYA BACHU

313-***-**** ad5qhf@r.postjobfree.com LinkedIn

Detroit, MI

Oakland University Graduate School Rochester, MI

Master of Science, Information Technology Management Dec 2024 National Institute of Technology Hamirpur, Himachal Pradesh, India BTech - Electronics and Communication Engineering May 2017 SKILLS

Data Analysis: SQL Server, Snowflake, Azure SQL, Oracle, Netezza, SSIS, Matillion, ADF, Informatica, SSAS, Microsoft Access, Microsoft Excel, AWS, GCP, SAP HANNA, NoSQL

Data Visualization: Power BI, Tableau, SSRS, Quick View Services: Azure Devops, TFS, CI/CD, Control-M

Programming Languages: C, C#, Data Structure, Python, R PROFESSIONAL EXPERIENCE

Digital Engineering Senior Consultant March 2022 – July 2023 NTT Data Services Pune, Maharashtra, India

● Led upgrade and migration of processes from Netezza, Control-M, UNIX, and AWS to Snowflake and Matillion, enhancing operational efficiency and ensuring a seamless transition. Wrote Python and R scripts for task automation.

● ETL Implementation in Informatica for cross function team.

● Collaborated with business users to understand processes and migration blockers. Prepared detailed documentation for each process, ensuring a smooth transition.

● Managed team leadership, completing processes before deadlines and delivering results with maximum efficiency. Consultant Sept 2019 – Feb 2022

Affine Private Limited Bangalore, KT, India

● Designed solutions for handling terabyte-scale datasets, Development of optimized SQL queries and SSIS packages for peak performance.

● Led and hands-on work of the migration of an On-prem processes from SQL, SSIS Database to Snowflake and Matillion, Implementation of processes in Azure SQL, ADF and Azure blobs. Work on GCP.

● Developed and documented processes in Azure Data Factory (ADF) and enhanced Python code for web scraping, ensuring data availability for ETL processes.

● We were able to get new project before completion of current project on delivering projects ahead of schedule, reflecting the excellence of deliverables.

● Optimized performance of existing processes by implementing indexes and partitions, resulting in a 40% performance improvement.

Software Engineer Jun 2017 – Aug 2019

Motherson Sumi Infotech and Design Ltd Noida, UP, India

● Writing complex queries in SQL including SPs, functions, views, indexes, partitioning and implementation of efficient SSIS packages.

● Created and managed SSAS packages, and prepared Power BI and Quick view reports for convenient data presentation.

● Gathered and understood business requirements, validated data from source systems, and monitored calendars for successful scheduled processes, ensuring efficient data extraction and pushing. enhancements and development according to Change Requests and documentation.

● Identify late-arriving dimension and missing dimension data, backtrack process flow, understand ERP data, and identify data, Development of logic for rejecting invalid data and resolving rejections during master/incremental data push and

● Performance Optimization of the process to reduce duration by 50% PROJECTS

Energy Mix Optimization: Enhancing Sustainability Jan 2024 - Apr 2024

● Used Python and Pandas to convert non-relational Energy Information Administration data into a relational format. Designed an efficient data warehouse structure with SQL and SSIS, ensuring optimal storage and retrieval.

● Utilized SSAS and Power BI for a focused and insightful analysis, minimizing redundancy in analysis and visualization to derive meaningful insights efficiently.

Healthcare Data Analyzer Sept 2023 - Dec 2023

● Analyzing healthcare data in Microsoft Excel, querying data in Microsoft Access for preliminary insights after table creation, and then generating reports in Tableau to extract valuable insights. Internship: Studies of Aerosol Properties Using Remotely Sensed Data May 2016 – July 2016 Indian Institute of Remote Sensing Dehradun, Uttarakhand, India

● Gathered aerosol data from space layers, stored data in Oracle, used MATLAB for insights, enabling significant decision-making.

Contact this candidate