Senior Data Analyst Data Engineering & Analytics
Resume:
EXPERIENCE
Subbu Samavedam
************@*****.*** LinkedIn GitHub
CHRISTUS HEALTH – Irving, TX July 2024 – Present
Senior Data Analyst
• Performed advanced data analysis for ad-hoc and recurring business needs; automated test scripts using Python.
• Designed secure data pipelines to Snowflake from cloud/on-prem sources using Azure Data Factory, Data Lake, Blob Storage, Databricks, and PolyBase.
• Built analytics models in Snowflake; conducted data profiling, mapping, and architecture documentation.
• Queried large datasets from Cassandra for efficient search, sort, and aggregation operations.
• Developed REST APIs and created custom Tableau dashboards with calculated fields, geo-coding, and scorecards.
• Built interactive Power BI reports with DAX, bookmarks, drill-through filters, and R-based custom visuals.
• Applied Machine Learning in Python for multilingual NLP tasks; used Spark and Scala for model prototyping.
• Delivered complex Tableau visualizations (e.g., LODs, parameters, filters, time intelligence).
• Published and maintained Power BI workspaces; performed data refresh scheduling and app management.
• Conducted backlog grooming with stakeholders to prioritize sprint items and align with business goals.
• Monitored batch processes via Splunk Dashboards and ensured successful job executions.
• Developed and maintained Alteryx workflows to automate manual data validation and reconciliation across multiple systems and sources.
• Integrated Alteryx with SQL Server, Excel, and Snowflake to streamline ETL processes and generate clean, structured datasets for reporting.
• Collaborated with leadership and cross-functional teams to define KPI standards and enforce consistent reporting frameworks.
• Delivered sprint deliverables in Agile sprints; facilitated demo sessions and sprint reviews with product owners.
• Established data governance practices by documenting data lineage, retention policies, and regulatory compliance procedures.
• Utilized Alteryx Designer to build end-to-end data pipelines involving data cleansing, transformation, and enrichment.
• Transformed and analyzed global plant data in Excel/Power BI to assess profit/loss performance.
• Executed ETL across SAP HANA, Teradata, and legacy SAP systems into data warehouse environments. GLOBAL LIFE Dec 2022 – Feb 2024
Senior Data Analyst
• Designed and deployed cloud-based applications using AWS (EC2, S3, Glue); participated in Agile sprints and team scrums.
• Built scalable infrastructure; monitored performance, managed issue logs, and coordinated with QA/ETL teams for smooth deployments.
• Developed conceptual data models using Erwin and ensured MDM quality with match/merge rule execution.
• Automated ETL pipelines with Python, SQL, and generated KPI dashboards in Qlik Sense and Excel (VLOOKUP, Macros, PivotTables).
• Led knowledge-sharing sessions and mentored junior analysts on Tableau storytelling and Python-based automation techniques.
• Actively participated in Agile ceremonies including sprint planning, backlog grooming, and daily stand-ups using JIRA.
• Ensured compliance with HIPAA by implementing data validation checks and encryption for sensitive health data pipelines
• Created dynamic, reusable macros and analytic apps in Alteryx to support business users with parameterized inputs.
• Leveraged Alteryx Spatial and Predictive tools for geospatial analysis and forecasting models integrated with Tableau/Power BI
• Analyzed investment data from IDW & CRD using DbVisualizer; built NLP/ML frameworks and optimized performance scripts.
• Created MapReduce programs and designed logical/physical models to support enterprise data warehouses.
• Wrote complex SQL, PL/SQL procedures, triggers, and cursors for data extraction and validation.
• Developed interactive Tableau dashboards using actions and filters; published reports on Tableau Server with scheduled refreshes.
• Used DAX extensively to build measures, time intelligence, and PowerPivot models; deployed models in SSAS and SharePoint.
• Shared responsibility for Hadoop, Hive, Pig administration; created SSIS packages for incremental loads and SCDs.. COGNIZANT March 2021 –July 2022
Program Analyst
• Delivered end-to-end project execution in an Agile environment; built data warehouses and data marts from scratch based on reporting needs.
• Created ad-hoc SQL scripts, procedures, triggers, and views; built dashboards in Tableau (Azure SQL source) and managed access in Power BI Online.
• Designed SSIS packages for data movement and cleansing; automated ELT pipelines to Big Query using Python and Google Cloud.
• Built NiFi POCs, developed Azure functions in C#, and used Scala to pull API data into Spark Data Frames.
• Built dashboards and wrote DAX queries in Power BI; supported multiple Tableau and Power BI reports.
• Led knowledge-sharing sessions and mentored junior analysts on Tableau storytelling and Python-based automation techniques.
• Actively participated in Agile ceremonies including sprint planning, backlog grooming, and daily stand-ups using JIRA.
• Ensured compliance with HIPAA by implementing data validation checks and encryption for sensitive health data pipelines
• Developed Spark Python modules, MapReduce, and Hive pipelines for predictive analytics; authored PIG scripts for ETL tasks.
• Migrated and developed applications using Azure Web Jobs, Data Factory, Logic Apps, and Blob Storage; deployed web apps with MVC architecture.
• Wrote and maintained PL/SQL procedures using Oracle 11g, developed SSAS tabular cubes, and supported dashboard/report generation.
• Created multiple databases and implemented back-end logic using SQL, PL/SQL, and SSAS for reporting and analytics. PARLE AGRO March 2019 –Feb 2021
Program Analyst
• Analyzed data sources and created source-to-target mapping (STTM) documents with transformation logic.
• Collaborated with data modelers and ETL developers to draft Data Functional Design documents and enforce modeling best practices.
• Interacted with SMEs to analyze legacy system data (Mainframes, COBOL) and convert it into structured formats.
• Created and maintained data mapping repositories and ensured metadata, naming standards, and normalization rules compliance.
• Supported ETL development for data extraction from multiple SORs to data marts/warehouses; handled small enhancements and data quality improvements.
• Provided 24x7 issue support, resolved data-related tickets, and ensured audit and security compliance in mapping processes.
• Contributed to data cleansing, validation, and migration activities; supported backend development and database-integrated applications.
EDUCATION
LAMAR UNIVERSITY - Texas, USA Aug 2022 – May 2024
Master of Science in Computer Science
JNTU – A - India July 2018 – July 2021
Bachelor of Technology in Electrical and Electronics Engineering SKILLS
Programming Languages Python, R, SQL, Linux, UNIX shell scripting, Java, JSP, HTML, JavaScript, JIRA, T-SQL, PL/SQL, C/C++, XML, HTML, CSS, Visual Basic6, VBScript, Java script, C#, PHP, .NET, VB.NET, ASP.NET Operating Systems MS-DOS, Windows Server, UNIX, Linux. RDBMS/Databases MS SQL Server, Oracle, TOAD, MS Access, SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, Database. Cloud Technologies Microsoft Azure, ServiceNow, Confidential Web Services (AWS) and Oracle Enterprise Manager Cloud.
Technologies & Primary
Tools
Artificial Intelligence, Machine Learning, ML, PMML, AI, Big Data, Hadoop, Spark, Cloudera, Storm, Kafka, Hive, Impala, Flume, Sqoop, C, C++, Python, Graph Lab, AWS, R, Spark, scikit- learn Databases MySQL, MongoDB, DynamoDB, Oracle, PostgreSQL Methodologies Software Development Life Cycle, Agile, Waterfall, Data Modeling Logical/Physical/ Dimensional, MS Project, SQL Profiler, Toad and TFS.
BI Tools Power BI Desktop, Alteryx, Einstein Analytics, SAP Business Objects, Tableau server, Workday, Reader, Online, Crystal reports, MS Excel, SSRS and Excel Power View
CERTIFICATIONS
• Power BI Data Analyst Associate – Microsoft
• Certified Data Analyst Associate – Microsoft
• Certified System Administrator – ServiceNow
• Certified Application Developer – ServiceNow
• Certified Cloud Practitioner – Amazon
Contact this candidate