Shruti G Email & Phone Number

Dallas, Texas, United States

SQL & T-SQL Expertise: Optimized complex T-SQL queries using MS SQL Profiler and Database Engine Tuning Advisor, resulting in improved database performance.Data Mapping & Modeling: Experienced in logical data modeling, creating ER and class diagrams, and developing data mappings between source and local systems.Advanced Reporting & Visualization: Developed custom reports and dashboards in Workday, Adobe Analytics, and Power BI, tailored to business needs for actionable insights and KPI tracking.Workflow Automation: Reduced manual processes by 60% through Alteryx workflows for data preparation, cleansing, and reporting automation.Python & ETL Development: Created Python ETL scripts for data extraction, transformation, and loading, using regular expressions and merging capabilities for efficient data handling.Machine Learning & Data Science: Applied Python (pandas, numpy, scikit-learn) for machine learning models, regression analysis, and data visualization, enhancing data-driven insights.Cloud & Data Architecture: Skilled in AWS, Hadoop, and Google Dialogflow for data analysis, deep learning frameworks, and virtual assistant development for business intelligence.Agile & Cross-functional Collaboration: Worked in Agile environments with cross-functional teams to design, develop, and deploy data solutions across platforms such as SQL Server, Oracle, Sybase, and DB2.

Full SDLC Engagement: Actively involved in all stages of the Software Development Life Cycle (SDLC), from gathering business requirements to deploying solutions, ensuring smooth data flow between source and destination systems.Advanced Data Integration & Migration: Designed complex SSIS packages to handle data migration from multiple sources and automate workflows using Automic UC4, enhancing ETL and integration efficiency.Analytical Proficiency with R & Python: Utilized libraries like NumPy, Pandas, Seaborn, and Scikit-learn for data analysis and machine learning, visualizing results with Tableau and Power BI to drive insights.Database & Cloud Expertise: Developed complex stored procedures, functions, and queries across Oracle, SQL Server, and Sybase environments; skilled in AWS cloud configurations, security, and VPC setup.Machine Learning & Big Data Solutions: Experienced with Hadoop ecosystem (HDFS, Spark, MapReduce) and machine learning tools for predictive modeling, clustering, and regression, supporting big data analytics initiatives.Cross-functional Data Governance & Quality: Collaborated on data governance, data quality, and data lineage projects, leveraging Erwin and MS Visio for data modeling and enhancing data accuracy and accessibility.Dynamic Dashboard & Reporting Development: Empowered decision-makers with custom, interactive reports in Tableau, SSRS, and Adobe Analytics, optimizing insights for real-time business decisions and personalized marketing strategies.

Houston, Texas, United States

Expert in Data Warehousing & OLAP: Designed multi-dimensional OLAP cubes, configured dimensions, measures, and MDX queries to support in-depth business analysis, creating centralized data warehouses for improved data accessibility and query performance.Advanced ETL & Data Integration: Developed comprehensive SSIS packages to extract, transform, and load (ETL) data from multiple sources, including flat files and databases, into ODS; performed rigorous testing and validations to ensure data accuracy.BI & Reporting with Power BI and SSAS: Created dashboards and reports using SSAS tabular models, SQL BI views, and deployed them in Power BI and SharePoint environments, helping organizations derive actionable insights from data.Machine Learning & Predictive Analytics: Built predictive models and machine learning algorithms using Python, Spark, and Hadoop on AWS, preparing raw data for analytics to drive data-driven decisions.Informatica & Data Quality Management: Leveraged Informatica tools (Data Explorer, Data Quality) for data profiling, migration, and integration; performed data validation and ETL testing for accurate, reliable data pipelines.Comprehensive Reporting & Visualization: Developed SSRS reports and complex Tableau dashboards, including drill-down, matrix, and KPI-based reports, aiding in strategic planning and business performance analysis.AWS & Cloud Data Solutions: Configured AWS Data Pipeline for data loading and transformations from S3 to Redshift, optimizing ETL data flows for enhanced performance and scalability.

India

Data Modeling & Database Design: Developed logical and physical data models using ERwin, defining data relationships and mappings to support business requirements and facilitate efficient data storage.ETL Development & Optimization: Built SSIS and T-SQL procedures to transfer data across OLTP systems, staging areas, and data marts, applying XML transformations and optimizing ETL data flows for high performance.Advanced Reporting with SSRS & Power BI: Created comprehensive drill-down and drill-through reports on business-critical metrics such as revenue, claims, and customer interactions, utilizing SSRS and Power BI.Database & SQL Expertise: Designed database objects including stored procedures, triggers, and indexes in SQL Server; proficient in T-SQL for data manipulation and reporting.Data Analysis for Business Insights: Analyzed claims, revenue, and other key metrics in SQL and Microsoft Access, contributing to strategic decision-making through data-driven insights.Project Documentation & Requirements Management: Documented data mapping and transformation processes in Functional Design documents and managed project requirements using IBM Rational Requisite Pro and Microsoft Visio.