Satwik M. Email & Phone Number

Phoenix, Az, Us

Denton, Texas, United States

As a Graduate Teaching Assistant for the Data Visualization course at the University of North Texas, I applied my extensive background as a data analyst to enrich the educational experience. My responsibilities included crafting comprehensive question papers and assignments that challenged students to think critically and apply practical skills. Drawing upon my expertise, I facilitated hands-on learning and provided insightful guidance on utilizing Power BI and Tableau, empowering students to master these essential tools. My contribution not only helped students grasp complex concepts but also bridged the gap between theoretical knowledge and real-world application, preparing them for successful careers in data analysis.

Bengaluru, Karnataka, India

Designed real-time batch processing solutions deploying Spark and Kafka within the Epic Systems environment, achieving a 25% reduction in patient data reporting times by tuning ETL workflows and advanced SQL techniques.Formulated and maintained cloud-based data pipelines with AWS Glue and Azure Databricks, ensuring efficient data integration and computing across AWS EC2, S3, RDS, and Azure SQL.Engineered data analytics applications, utilizing Python, Scala, and Java to create robust data models and automated reporting solutions in Tableau, enhancing systematic performance by 30% through optimized data integration and visualization.Enhanced ETL routine in the Epic Systems environment by manipulating complex SQL scripting for better transformation sequences, reducing processing time by 25%.Contributed to the progression of configuration strategies administering SQL Server Management Studio, improving data accuracy and accessibility by 40% in internal healthcare standards.Developed and maintained ETL processes using Informatica and Health Catalyst, ensuring seamless data integration from diverse healthcare sources.Implemented data quality checks and validation processes, reducing data discrepancies and enhancing data reliability.Collaborated with cross-functional teams to gather requirements and deliver tailored data solutions that met business needs.Created and optimized SQL queries for performance tuning, ensuring efficient data retrieval and processing.Automated data extraction and transformation processes using Python scripts, reducing manual intervention and increasing efficiency.Integrated on-premises data systems with cloud platforms, facilitating a smooth transition to a hybrid data environment.Conducted regular performance assessments and optimization of ETL workflows to ensure high efficiency and reliability.

Hyderabad, Telangana, India

Assisted in controlling and analyzing data throughout the product lifecycle using AWS Data Pipeline and Tableau, ensuring 98% data integrity and availability for critical decision-making processes.Supported the streamlining of data integration mechanisms by incorporating SAP PLM and Microsoft Power BI, enhancing operational excellence by 20% and improving product quality.Collaborated with engineering and IT teams to facilitate the seamless flow of product-related data using SQL and Python scripts, boosting cross-functional collaboration and increasing product development efficiency by 25%.Developed and maintained ETL processes using Talend, ensuring efficient data integration from multiple sources into the product lifecycle management system.Designed and implemented machine learning algorithms with scikit-learn and TensorFlow to predict steel demand, optimizing the supply chain and reducing inventory costs by 15%.Automated comprehensive data quality checks using Python and Pandas, ensuring high data integrity and consistency across multiple data sourcesSpearheaded the deployment of scalable cloud-based solutions on AWS and Azure, leveraging services like EC2, S3, and Azure SQL Database for cost-effective data management.Enhanced data visualization capabilities with D3.js, creating intricate and informative visual representations of complex datasets for better stakeholder understanding.Implemented robust data governance frameworks using Collibra, ensuring compliance with data management policies and enhancing overall data quality.Utilized Docker and Kubernetes for containerization and orchestration of data applications, improving deployment efficiency and scalability in cloud environments.

Vishakapatnam, India

Constructed interactive dashboards and reports using Tableau and Power BI to visualize steel inflow, outflow, and regional distribution, elevating decision accuracy by 25%.Leveraged SQL Server Profiler and Query Analyzer to enhance the performance of indexes and automate database responses, optimizing database operations and improving data execution efficiency. Spearheaded the optimization of SQL Server database systems by revising performance indices, database triggers, and SQL procedural code, improving query response times and system efficiency by 20%.Architected and deployed real-time data processing pipelines using Apache Kafka and Spark Streaming, enhancing the speed and precision of operational analytics. Developed and executed efficient data migration strategies with SSIS and Azure Data Factory, ensuring smooth transitions with minimal downtime during system upgrades.Leveraged the Hadoop ecosystem, including tools like Hive and Pig, for large-scale data management and analytical processing, driving significant business insights.Constructed and optimized data warehouses with Snowflake and Redshift, enhancing data storage efficiency and enabling advanced business analytics. Pioneered predictive analytics initiatives by developing sophisticated models using Python, accurately forecasting steel sales trends and significantly enhancing inventory management strategies by 30%.Developed and maintained ETL processes using Talend, ensuring seamless data integration and accurate data flow for reporting and analysis. Implemented data security measures using encryption techniques and SQL Server security features, safeguarding sensitive information and ensuring compliance with industry standards.Collaborated with cross-functional teams to gather data requirements and deliver customized data solutions, improving overall project outcomes and stakeholder satisfaction.