Data Governance Azure
Resume:
Satish Devarasetty
Email: ********************@*****.***
CAREER SUMMARY:
An IT professional with 10+ years of experience working as a Data governance Analyst in Banking/Finance sector.
Experienced in Agile (Scrum), Waterfall and various Software Development Life Cycle (SDLC) processes and methodologies.
Experienced with Data Warehouse in the development and execution of data conversion, data cleaning and extractions, data governance, data profiling and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
Have been a key part of Cloud Migration project (On-prem to AZURE)
Experience working on applications involving Azure Databricks, SQL Server, Azure Data Factory (ADF), Azure Data Lake Storage, Azure Synapse Analytics.
Hands on experience in creating data pipelines using Azure Data Factory, Azure synapse analytics.
Experienced working on Tableau to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business.
Solid knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snowflake Modeling for FACT and Dimensions Tables) using Analysis Services.
Experience in Data modeling for Data Warehouse development, Data Analysis for Online Transaction Processing (OLTP) and Business Intelligence (BI) applications.
Experience in writing database objects and ETL technical specification documents/STMs.
Experience in consolidation of data systems for statistics into snowflake data warehouse using Talend.
Experience collaborating with DBAs and ETL developers to identify and resolve technical, data quality, and change management issues.
Experience managing Azure Data Lakes (ADLS) and Data Lake Analytics and an understanding of how to integrate with other Azure Services.
Hands-on experience using Azure Data Bricks as a service and Notebooks.
Hands-on experience working on Azure synapse analytics.
Implementing the data governance program vision using Microsoft Purview, Databrick Unity Catalog and Purview, promoting the role of governance and enforcing policy, while following data governance best practices.
communicating Data Governance policies to all relevant stakeholders, and provides training and guidance as needed in concert with our Highland Learning and Development team.
Development and maintenance of data pipelines on Azure Analytics platform using Azure Databricks, PySpark, Python, Pandas and NumPy libraries.
Provides recommendations on all Data Governance activities, oversight, and support for Asset Management to ensure awareness across the organization and drive decisions for data standards and policies.
Knowledgeable in cross-validation techniques of Machine Learning models.
Ensured data compliance by monitoring data flow within InterSystems Cache environments.
Expertise in Data Visualization by producing tables, graphs, listings using various procedures and tools.
Conducted performance tuning of ETL processes in Informatica, SSIS, and Data360 to ensure optimal performance when processing large-scale datasets.
Proficient in checking the APIs, if returning data in XML format is not as defined in the API documentation.
Coordinated with cross-functional teams to ensure smooth project implementations.
Worked with database development and design using Big Data, Oracle SQL, PL/SQL using TOAD and Microsoft SQL server T-SQL, Teradata, and MS Access.
Ensured compliance with data security and governance policies through documentation.
Developed academic performance reports for student success analysis.
Facilitated data governance meetings and workshops to gather requirements, define data standards, and establish data ownership and stewardship roles.
Facilitated knowledge-sharing sessions to improve understanding of BTO-supported data platforms.
Documented data governance processes, workflows, and standards, ensuring clear understanding and adherence across the organization.
Collaborated with IT teams to implement data governance tools and technologies, such as metadata management and data lineage tools, to support data governance initiatives.
Provided training and support to business users on data governance policies, procedures, and tools, fostering a data-driven culture within the organization.
Experienced in Python to manipulate data for data loading and extraction.
Highly skilled in using Hadoop (pig and Hive) for basic analysis and extraction of data in the infrastructure to provide Data Summarization.
Experience in automating recurring reports using SQL and Python.
Experience with Microsoft SQL Stack including SQL Server Reporting Services (SSRS) & (SSIS).
Experience interacting with stakeholders, Subject Matter Experts (SMEs) and end-users to understand, analyze, communicate, and validate requirements using Joint Application Design (JAD), Joint Application Review (JAR) sessions.
Managed data documentation repositories for faculty and administrative teams.
Designed training materials and workshops to educate teams on governance frameworks.
Integrated Java and Python-based solutions for building robust data pipelines.
Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
Participated in weekly project status meetings and task review meetings, documented, and disseminated meeting minutes effectively.
TECHNICAL SKILLS:
Methodology
Agile-Scrum, Waterfall, Hybrid
ETL Tools
Informatica Power Center, MS SQL Server Integration Services (SSIS), Data Stage
Reporting and Visualization Tools:
Power-BI, COGNOS-BI, Query Studio, Report Studio, Tableau, SSRS, MicroStrategy, Crystal Reports, MS Project, MS Office, MS SharePoint
Data Modeling
Erwin, Star-Schema Modeling, Snowflake Schema Modeling
Programming Languages
SQL, PL/SQL, HTML, Visual Basic, Java, UNIX shell scripting, Python, R
Database
Oracle 11g/10g/9i/8i/7.3, SQL Server, MS Access, Azure Devops, AWS
Utilities
AWS (RedShift, EC2, EMR, Lambda, S3, AWS IOT), Azure, Tableau
Operating System
Windows, UNIX, Linux
Programming Tools
SQL*PLUS, SQL* Loader, TOAD
Big Data
Hadoop, Spark, Spark SQL, and Hive
Defect Management
HP Quality Center/ ALM, JIRA
CERTIFICATIONS:
Certified Project Management Professional (PMP)
Certified Scrum Master
Certified Microsoft azure Administrator (AZ-104)
EXPERIENCE:
Client: UPS, Atlanta, GA Jan’23 – Present
Role: Sr. Data governance Analyst
Responsibilities:
Conducted in-depth data analysis to support investment decision-making processes.
Participated in the full lifecycle implementation of ERP systems, including requirements gathering, system design, testing, training, and post-implementation support.
Integrated data governance projects with enterprise DevOps and CI/CD pipelines.
Assisted in reviewing and updating data policies.
Developed and published a set of metrics capturing Data Quality trends for a week, month, and quarter to ensure our Data Quality programs are working effectively.
Integrated AI-powered MDM tools for data matching, deduplication, and enrichment.
Conducted business process mapping and analysis to identify opportunities for process improvement and optimization
Configured Informatica Enterprise Data Catalog (EDC) for metadata management, data lineage, and impact analysis.
within the ERP environment.
Provided technical support for Linux-based analytics environments, ensuring seamless data operations.
Integrated PowerCenter with SQL Server, Oracle, Snowflake, and cloud platforms for seamless data movement.
Automated error handling and logging mechanisms in Informatica, SSIS, and Precisely Data360 to ensure data consistency and to reduce manual troubleshooting.
Supported the publication of research findings based on analytics and statistical modeling.
Created pipelines and scheduled jobs in Azure data factory and Azure Synapse analytics on a timely basis.
Partnered with BTO leadership to drive strategic data initiatives and enhance decision-making.
Automated change request and approval processes for better project governance.
Implemented data governance practices and security measures to protect sensitive financial data.
Worked in Agile, SDLC and waterfall environments, adhering to project timelines and deliverables.
Utilized JIRA for task tracking, issue management, and collaboration with cross-functional teams.
Created and maintained technical and functional documentation for data pipelines.
Collaborated with stakeholders in the financial sector to gather and document business requirements, ensuring alignment with industry-specific regulations and standards.
Implemented both ETL architectures in Azure using Data Factory, Databricks, SQL DB and SQL Data warehouse.
Connected Tableau to SQL on Azure to create several operation reports that require live updates
Managed data governance policies for report accuracy and consistency.
Generated statistical reports for student success metrics.
Developed Java-based ETL components to handle large-scale data processing in enterprise systems.
Created BRDs and FRDs to capture functional and non-functional requirements accurately.
Managed MDM project roadmaps and implementation strategies for data governance initiatives.
Conducted source-to-target mapping exercises, mapping data sources to target data models, and ensuring data integrity and accuracy during ETL/ELT. Ensured compliance with regulatory requirements and financial data standards.
Project Management Professional (PMP) or Certified Scrum Master (CSM) certification for Agile project management.
Managed data-related risks and compliance requirements within BTO-supported applications.
Utilized Informatica Cloud Data Integration to connect cloud-based data sources and improve data pipeline scalability in hybrid cloud environments.
Ensured compliance with enterprise data management strategies across IT projects.
Provide Data Quality advisory services participating in cross-functional teams and development or improvement task forces.
Implemented data synchronization across heterogeneous environments using Precisely Data360, ensuring accurate and real-time data integration.
Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.
Developed complex SQL queries and stored procedures to generate financial reports and dashboards, providing valuable insights to stakeholders.
Integrated Linux-based applications with cloud storage (AWS S3, Azure Blob Storage, Google Cloud Storage).
Demonstrated advanced proficiency in Excel and PowerPoint to manipulate and analyze complex data sets, create informative visualizations, and develop impactful presentations for executive-level stakeholders.
Integrated EDC with data sources such as relational databases, cloud storage, and ETL tools to enable automated cataloging.
Enhanced our metadata management capabilities by setting up and organizing data sources in Azure Purview. This involved creating detailed metadata schemas that improve our ability to discover and govern data across the organization.
Utilized Data360 to enrich customer and transactional data by integrating external datasets (e.g., geographic, demographic), providing deeper insights for targeted business strategies.
Created statistical reports for performance analysis.
Designed and maintained databases, including schema design, table creation, and optimization. Implement SSIS packages
for data migration, database backup, and performance tuning.
Established go-live readiness checklists to ensure smooth deployment of governance projects.
Published academic performance insights through structured reports and dashboards.
Designed and maintained databases using SQL Server and Oracle for efficient data storage and retrieval.
Designed data extraction processes from Intersystems Cache to SQL-based reporting tools.
Developed and optimized SQL queries to extract, manipulate, and analyze large datasets.
Provided technical guidance on data integration across multiple BTO systems and external platforms.
Collaborated with IT teams to implement data governance tools and technologies, such as metadata management and data lineage tools, to support data governance initiatives.
Provided training and support to business users on data governance policies, procedures, and tools, fostering a data-driven culture within the organization.
Built custom APIs for real-time MDM data exchange between applications.
Monitored and measured data governance metrics and KPIs to track progress, identify areas for improvement, and report on the effectiveness of data governance initiatives.
Designed and implemented data integration workflows using Informatica PowerCenter to extract, transform, and load large datasets across multiple systems and databases.
Contributed to data governance audits and assessments to ensure compliance with data privacy regulations and industry standards.
Created and configured data sources within Azure Purview to establish a centralized metadata repository.
Cataloged and organized diverse data assets, including databases, files, and APIs, using Azure Purview.
Integrated PowerCenter with SQL Server, Oracle, Snowflake, and cloud platforms for seamless data movement.
Developed data governance policies in alignment with BTO and enterprise-wide compliance requirements.
Developed metadata schemas and taxonomies to enable effective data discovery and search capabilities.
Created project dashboards, KPIs, and progress reports for real-time tracking.
Designed data models and reporting schemas to improve report performance.
Managed Linux-based data processing environments, ensuring high availability and performance.
Automated metadata ingestion from PowerCenter, SQL Server, Snowflake, and Hadoop-based systems.
Applied Python libraries such as Pandas and NumPy for data manipulation, cleaning, and advanced analytics.
Environment: JIRA, ETL/ELT, Data Modeling, Data Mapping, SQL Server, Python, NumPy, Pandas, Oracle, SQL Server, SQL, Power BI, Tableau, Azure, Purview, Metadata, Excel, MS Office, Power Point
Client: Standard Chartered, Bangalore, India Mar’17 – July’21
Role: Sr. Data governance Analyst
Responsibilities:
Developed optimized ETL processes using Azure cloud platform to capture and aggregate operational metrics of thermostatic engine cooling fan; built interactive visualizations as a deliverable.
Responsible for data analysis, extracting data elements from various OLTP’s using ETL techniques and utilized Business Intelligence Tools for report generation.
Performed Data profiling on source Databases and fed inputs to Source to Target mapping documents.
Supported financial technology initiatives, ensuring seamless data flows across BTO applications.
Responsible for providing accurate and timely reporting and data mining to all levels of the business.
Assisted multiple teams across the global organization to update and maintain Excel reports, providing reporting capabilities to constantly changing business requirements.
Designed Power BI and Tableau dashboards to visualize complex datasets for stakeholders.
Used Agile, Scrum, and Waterfall methodologies for managing data governance projects.
Conducted data quality evaluations to ensure accuracy and completeness.
Use Spark connectors with Databricks to import and export between Databricks spark cluster and Azure SQL database or SQL Server database.
Created MDM governance frameworks for data ownership, stewardship, and accountability.
Developed data-driven insights for strategic decisions.
Developed data profiling and quality checks within Precisely Data360 to identify discrepancies and data quality issues before transformation.
Supported the publication of research findings based on analytics and statistical modeling.
Create an Azure Data Factory pipeline that executes a Databricks notebook against the Databricks jobs cluster
Collaboration with Databricks security team, design and implement security best practices for Azure
Managed secure file transfers (SFTP, SCP) between Linux servers and external data sources.
Used various report items like tables, sub report and charts to develop the reports in SSRS.
Provided user training and support for data consumers leveraging EDC for analytics and reporting.
Maintained data governance documentation for compliance audits.
Draft task and project timelines of Data Quality product solutions to collaboratively support the Data Analytics and Warehousing team.
Created SSIS Packages to integrate data coming from Text files and Excel files.
Developed SSIS package to extract, transform and load (ETL) data from different sources into destination target, such as data warehouse utilizing SQL Server Integration Services (SSIS).
Experience with Azure transformation projects and Azure architecture decision-making to implement ETL and data movement solutions using Azure Data Factory (ADF) and SSIS.
Developed custom queries and scripts for analyzing healthcare data stored in Intersystems Cache.
Designed and developed ETL workflows using Informatica PowerCenter for extracting, transforming, and loading data from multiple sources.
Integrated MDM solutions with enterprise applications such as SAP, Salesforce, Workday, and ServiceNow.
Created SQL statements to work within the functional document and ran the results against the facets system to ensure the correctness of the data.
Optimized Informatica ETL processes by fine-tuning sessions, mappings, and workflows to enhance data throughput and minimize load times.
Worked with MDM systems team with respect to technical aspects and generating reports.
Created Tables, Stored procedures, and defined functions.
Identified data patterns, provided metrics, diagnosed problems, and provided intelligence for business operations using Tableau.
Worked closely with PMO teams to align governance projects with strategic business objectives.
Collaborated with business and technical teams to understand data requirements and implement ETL solutions in Informatica, SSIS, and Data360 that met business and reporting needs.
Used Python for manipulating the data read from data sources and convert them as CSV files to SQL standards
Created ETL design mapping sheets, data reconciliation strategy, data archival strategy- ETL framework, stored procedures and built SQL query objects to detect data loss.
Built and designed business intelligence /data visualization dashboards in Tableau.
Created technical documentation for BTO applications, detailing system integrations and dependencies.
Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package by the advanced feature of SQL Server Integration Services.
Created reports, tables, and figures in Tableau and Excel.
Develop and maintain dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
Deployed and configured ETL tools (Informatica, SSIS, Python scripts) on Linux servers for scalable data processing.
Collaborated with cross-functional teams to publish data governance and compliance reports.
Design, develop, implement, and maintain scheduled analytics, reporting and scorecards using Excel and PowerBI.
Involved in writing extensive SQL queries for back-end testing of oracle database.
Worked with SAP MDG, Informatica MDM, and other MDM platforms for centralized data management.
Investigating software bugs and reporting to the developers using the Quality Center Defect Module.
Analyzed system requirements and developed detailed test plan for testing.
Developed project plans, business requirements (BRD), design documents, and test plans.
Tracked and reported defects using Quality Center.
Generated defect reports using Quality Center for the developers.
Environment: Agile, MS Office, Excel, ETL, Tableau, PowerBI, VBA, Snowflake, Python, AWS Lambda, Amazon SQS, T-SQL, Jira
Client: Kotak Mahindra Bank, India Sep’15 – Mar’17
Role: Sr. Data governance Analyst
Responsibilities:
Worked with various data domains primarily with Master and Reference data which includes Hogan Customer Information system, security and Inventory Master, over the counter products, reference data and Traded products.
Worked with other data domains like Financial Management and Reporting data specifically on Regulatory Data Repository.
Estimated initial project costs and optimized financial reporting leading to faster project funding approvals for Loan and Mortgage Processes.
Implemented Master Data Management (MDM) for all entities in the project by maintaining a master hub for improving the data quality by following various data governance techniques and data dictionary standards.
Worked with various Data sources like Oracle, SQL Server, Teradata and HDFS (Hive).
Worked closely with application business data owners and technical data managers on applications which are in scope to implement data quality controls.
Assisted in modernization and migration strategies for databases, platforms, and APIs within BTO.
Collected Data Dictionaries from data owners or leveraging available dictionaries from centralized metadata repository to identify critical business data elements.
Involved in documenting the ETL process and wrote SQL Queries for the retrieval of the data.
Identify and propose resolution of recurring Data Quality problems.
Developed active Data Quality monitoring and measurement, establishing and publishing KPIs and SLAs.
Managed the integration of big data sources into the data pipeline using Informatica and Data360, enabling the processing and transformation of large-scale datasets for analytics.
Partnered with technical team and subject matter experts to research reported data anomalies, identify root causes, and determine solutions.
Executed enterprise data governance strategies in line with the organization`s strategic plan and objectives.
Oversee the creation of data governance policies and standards.
Worked with Bank Related Customer Master Data for Data analysis purposes by utilizing Teradata Database and Teradata SQL Assistant for querying.
Optimized Teradata Tables by building indexes for faster retrieval of Data.
Provided end-of-the-end technology support for financial data systems within the Business Technology Office (BTO).
Developed SQL scripts to create database objects like tables, views and sequences.
Developed SQL and PL/ SQL scripts for migration of data between databases.
Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, complex database triggers and data migration scripts.
Environment: Waterfall methodology, Talend, Oracle, Teradata, ETL, MDM, UNIX, SAS, SQL Server, PL/SQL, SSIS
Client: HSBC, India Aug’14 – Sep’15
Role: Data Analyst
Responsibilities:
Prepared test Data sets and performed data analysis and used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
Worked directly with internal customers to understand the business environment and needs.
Performed data analysis to understand data flows.
Performed gap analysis and data mapping.
Performed data quality checks.
Worked with SMEs to define multifamily mortgage business rules.
Performed data and business rules validation and verification.
Performed back-end testing by extensively using SQL commands on UNIX to verify the database security and accuracy.
Worked on data modeling and produced data mapping and data definition documentation.
Created (Extract, Transform, Load) ETL design mapping sheets, data reconciliation strategy, data archival strategy- ETL framework, stored procedures and built SQL query objects to detect data loss.
Worked with the business users to understand & document the design and functionality requirements.
Involved in testing and documentation for application developed in SDLC Environment.
Worked with project manager to document and manage change request.
Contributed during daily status calls, weekly, monthly status meetings, and review sessions.
Answered questions and scenarios that came up as the developers and testers work off the business requirements.
Created process flows, presentations and reports to document recommendations and deliver them to the business stakeholders.
Responsible from the user perspective to analyze dashboards and analytical reporting requirements using Tableau.
Performed detailed analysis of complex business processes, data requirements and propose solutions.
Composed user manuals, technical references, and other customer facing technical documents for EUCs.
Wrote and executed complex SQL queries for analysis and testing in TOAD.
Involved in writing Data Mapping Documents for the system and involved in documenting the ETL process and writing SQL Queries for the retrieval of the data.
Developed test plans, test cases, procedures, and documents given business requirements and design documents.
Performed portfolio level testing.
Involved in investing root causes and business impact of deferred defects.
Performed User Acceptance Testing (UAT) of the EUC applications.
Environment: Agile, Data Modeling, ETL, TOAD, UNIX, UAT, MS Office Suite
Client: Protangent Solutions, India Jun’11 – Jul’12
Role: Salesforce Admin
Responsibilities:
Looking into Production Support and lots of enhancements on top of an existing system.
Following Responsible for creating and customizing Page Layouts, Record Types, Email Templates, Validation Rules Workflows and Approval Process.
Responsible for creating Users, Profiles, Roles and Permission Sets.
Worked on Security settings for objects at Profile, Role and Organization level.
Created Sharing rules for various objects.
Worked on Reports and Dashboards.
Worked on MS-Excel Data to validate the data by creating tables and queries.
Worked on application functionality by checking the dependencies.
EDUCATION:
Master’ s in Information Systems- University of North Texas, Denton, TX, USA
MBA in Finance – Alliance University, Bangalore, India
B. Tech in Computer Science – JNTU, Kakinada, India
Contact this candidate