Satyadhar Kumar C Email & Phone Number

Pittsburgh, Pennsylvania, United States

• Managed configuration and testing for various technology implementations, ensuring seamless integration with existing systems.• Performed in-depth system analysis to identify gaps, resulting in business process improvements and optimized workflows.• Partnered with IT and cross-functional teams to facilitate the transition and integration of new third-party technology platforms, including the implementation of OneTrust.• Conducted requirement analysis and mapped as-is, to-be process flows, contributing to the development of streamlined processes.• Led the configuration of assessments and workflows within OneTrust, providing solutions to identified problems without the need for custom coding.• Utilized JIRA for tracking project progress and MS Office Suite for documentation and reporting, ensuring all stakeholders were informed and aligned.• Provided critical input and advocated for the 3rd party risk office, driving technology deliverables and decision-making in unclear situations.• Developed data analysis solutions using SQL, contributing to process mapping and the depiction of workflows using Visio.• Supported the implementation of technology and system solutions with a focus on risk management, aligning with Freddie Mac’s operational goals.• Leveraged strong organizational and time management skills to manage multiple priorities and deadlines, maintaining project momentum.• Key Achievements:• Successfully implemented OneTrust within a third-party office, improving the efficiency of risk management processes.• Provided input on critical business decisions, ensuring alignment with organizational objectives.• Developed and maintained effective relationships across divisions, enhancing collaboration and project success.• Delivered data analysis projects that supported informed decision-making, utilizing SQL and Tableau to present actionable insights.

New York, New York, United States

• Managed the configuration and testing of technology implementations, ensuring alignment with business objectives and successful integration across systems.• Conducted comprehensive system analyses to identify gaps, optimize processes, and recommend actionable improvements that enhance operational efficiency.• Partnered with IT and various business divisions to facilitate the seamless transition to new third-party technology platforms, ensuring minimal disruption and smooth integration.• Led requirement analysis sessions and mapped as-is and to-be process flows, driving the development of efficient and scalable business processes.• Contributed to the implementation of OneTrust within a third-party risk management context, including the configuration of assessments, workflows, and testing solutions.• Delivered successful technology implementations by leveraging advanced analytical skills, exposure to SQL, and process mapping tools like Visio.• Acted as a key communicator between business and technical teams, translating complex technical concepts into actionable insights for stakeholders. Maintained comprehensive documentation of all decisions and processes.• Supported project management efforts, contributing to the timely delivery of key projects and managing multiple priorities within tight deadlines.• Demonstrated flexibility and adaptability in ambiguous situations, providing critical input and making informed decisions to drive project success.• Applied business analyst expertise within the mortgage industry, understanding and contributing to the end-to-end software development life cycle (SDLC) and Agile methodologies.• Utilized enterprise tools like JIRA, MS Office Suite, SharePoint, and data visualization tools like Tableau to enhance project delivery and stakeholder communication.

Charlotte, North Carolina, United States

I significantly contributed to data management deliverables, focusing on business needs analysis and data modeling techniques within the Azure cloud platform. Collaborating closely with technical and business teams, I played a key role in development efforts, emphasizing Azure services. My responsibilities included developing scripts for stored procedures, views, functions, streams, and workflows within Azure, along with producing analysis documents on ETL/ELT processes to support migration efforts to Azure.Utilizing Databricks, I ensured data security by implementing server-side encryption. I delivered end-to-end PySpark ETL pipelines on Azure Databricks, orchestrating data transformations through Azure Data Factory (ADF) and scheduling via Azure Automation Accounts, triggered by Tidal Scheduler. Additionally, I developed ETL/ELT applications using Azure Synapse Analytics and actively participated in daily scrum meetings to define stories, provide updates, and address blockers.My technical expertise spans Azure Databricks, ADLS, ADF, AAS, DAX, Azure Automation Accounts, Azure AD, Azure IAM Security Groups, PySpark, Spark SQL, Azure Data Warehouse (ADW), Power BI, DAX coding, MSBI, SSAS, CI/CD, and Production Support. I implemented control flow architecture for big data applications using ADF V2, Azure Databricks, Azure Synapse Analytics, Azure Data Lake Storage, Azure SQL DB, and Azure Key Vaults. I also evaluated current architecture and formulated a migration plan using a work breakdown structure aligned with the cloud migration strategy.I was instrumental in migrating data into RV Data Pipeline using Databricks, Spark SQL, and Scala. I provided estimates, authored design and solution documents, and devised ETL loading strategies with offshore developers, focusing on Azure cloud technologies. Additionally, I created complex, high-performance SQL queries within RDBMS (SQL Server, DB2, Oracle) and NoSQL systems in Azure.

At JetBlue Airlines in Long Island, NY, I served as a Data Analyst / ETL SQL MSBI Developer from March 2019 to May 2020. My role primarily involved data aggregation, grouping, and merging from multiple databases using SQL to create comprehensive datasets for modeling. I developed an optimized Logistic Regression model to predict customer response rates to email marketing campaigns, specifically focusing on the likelihood of purchasing insurance policies. To enhance operational efficiency, I automated these campaigns by engineering production-level code, which significantly streamlined the daily processes.I also constructed production-level Ordinary Least Squares (OLS) regression models aimed at forecasting sales prices. These models achieved an adjusted R-squared of over 60%, surpassing the performance of previous models. By automating the binning and visualization of variables with SAS macros, I reduced variable exploration time by over 80%. Additionally, I utilized linear splines to transform and establish linear relationships between continuous variables and their target outcomes. For advanced data analytics and manipulation, I relied heavily on Python libraries such as Boto3, Pandas, and NumPy, ensuring robust data processing and enhancement.Ensuring the reliability of the models was a key focus, which I achieved by conducting coefficient consistency tests across different segments. I standardized data formats to maintain high data quality and usability, and I simplified data processing by automating weblog extraction using Airflow Directed Acyclic Graphs (DAGs). In my role, I applied advanced statistical techniques, including cluster analysis and factor analysis, to uncover hidden patterns within the data. I also developed and implemented anomaly detection algorithms to identify irregularities, ensuring data integrity.

India

As a Data Engineer and Power BI Developer at Valiance Solutions, I played a key role in designing and developing interactive Power BI reports and dashboards that empowered stakeholders to uncover valuable insights and trends. My responsibilities included configuring Power BI gateways, resolving data inconsistencies, and implementing Time Intelligence functions using DAX to deliver high-quality reports across various data sources, including SQL Server and Excel.I also utilized Python and SQL to conduct thorough data analysis, integrating data with third-party tools to enhance connectivity and automate routine tasks. Additionally, I developed and maintained SSRS reports, optimized performance, and created SSIS packages for ETL processes, ensuring seamless data flow from source systems to the Enterprise Data Warehouse (EDW).My work involved close collaboration with offshore teams to troubleshoot issues, modify existing reports, and meet evolving business requirements, all while ensuring data integrity and accuracy. My technical skills in Power BI, SSRS, SSIS, and SQL, coupled with my ability to translate complex data into actionable insights, contributed to driving informed decision-making within the organization.

India

In my role, I extensively utilized SQL Server Integration Services (SSIS) to perform data extraction, transformation, and loading (ETL) operations. These operations involved pulling data from various sources, including CSV, Excel, TXT, and SQL Server databases, into the data warehouse. I conducted thorough requirement-gathering sessions with departments such as Actuarial, Claims, Accounting, and Database Marketing to ensure that business needs were well understood for new projects.I designed, implemented, and maintained robust ETL processes using SSIS, ensuring efficient and accurate data movement across multiple systems. By orchestrating ETL job scheduling and automation through SQL Server Agent, I guaranteed the timely execution and updating of data pipelines. My work included implementing rigorous data validation and cleansing routines within ETL processes, which was crucial in maintaining the accuracy and integrity of data throughout the data warehouse.Additionally, I developed and managed SSIS packages and stored procedures to load Dimension and Fact tables, optimizing data flow and transformation. A significant achievement was engineering a Master ETL Package to orchestrate the execution of child ETL packages, streamlining deployment and maintenance. I employed ETL techniques such as Slowly Changing Dimension Transformation to enable historical data tracking and maintenance in the data warehouse.My responsibilities also involved writing SQL scripts, queries, and stored procedures to support ETL processes, facilitating data validation and transformation. I designed and implemented new Dimensions and Facts within the Enterprise Data Warehouse (EDW) environment and redesigned existing dimensions to meet evolving business requirements. I also developed ETL packages to extract, transform, and load data into OLAP databases using SSIS, enabling multidimensional data analysis.

Bachelor Of Technology - Btech, Computer Science

Master Of Science - Ms, Computer Science