Satish Kumar

• Understanding the system, business requirements and scope of the project
• Collaborated with cross-functional teams to implement data cleansing, profiling, and scrubbing techniques, ensuring data accuracy and reliability
• For testing used magic commands and written spark SQL for testing code Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, SQL, Spark SQL and Azure Data Lake Analytics
• Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks
• Developed pyspark code for data cleansing like trimming of columns and duplicate checks, key duplicates etc
• Hands on experience on implementing different types of joins in pyspark and SQL.
• Good understanding of Spark Architecture including Spark Core, Spark SQL, Data Frames, Driver Node, Worker Node, Stages, Executors and Tasks.
• Produced monthly reports using advanced Excel spreadsheet functions.
• Utilized data visualization tools to effectively communicate business insights.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
• Improved decision-making processes with accurate data analysis and visualization techniques.· Excellent experience on Data Visualizations and implemented several dashboards and Data Analysis views for VA partners and app teams.

· Excellent experience working on Health Care Systemsand applications.

· Hands on experience working on Waterfall Model as well as Agile Model, implementation of various sprint.

· Experience in Microsoft Power BI and Tableau reports, dashboards and publishing them to the end user to make decisions.

· Interacted with end-users and functional analysts to identify and develop Business Requirement Documents (BRD) and transform it into technical requirements.

· Supported team using techniques in Microsoft Excel and working knowledge of Visual Basic for Applications (VBA), Power BI, and Data Analysis Expressions (DAX)

· Expertise in tuning the performance of Mappings and sessions in Informatica and determining the Performance bottlenecks.

· Enhancements to existing dashboards to improve capabilities and expand insights as well as creation of new dashboards.

· Extracted and analyzed data using Power Query, PivotTablesand created different types of charts like pie chart, bar chart, tree map etc. in Power BI and Excel to provide data visualization.

• Improved decision-making processes with accurate data analysis and visualization techniques.

• Enabled stakeholders with actionable, intuitive performance insights, responding to business requests for research and analysis of member data
• Developed pyspark code for data cleansing like trimming of columns and duplicate checks, key duplicates etc
• Hands on experience on implementing different types of joins in pyspark and SQL
• Developed and maintained Databricks notebooks using SQL and Python
• Experienced in implementing audit logs in every notebook
• Experienced in implementing dynamic notebooks using notebook parameters
• Hands on knowledge on using dbutils commands
• Utilized Azure synapse for creating robust data pipelines, ensuring seamless and efficient data movement across various sources and destinations
• Hands on knowledge on different connectors in data bricks like creating mount point to connect to data lake storage
• Extract Transform and Load data from Sources Systems to Azure Data Storage services.
• Collaborated with cross-functional teams to define key performance indicators and develop actionable insights from large datasets.
• Presented findings from in-depth data analyses to senior leadership in clear, concise reports tailored to their specific interests and concerns.
• Drafted technical documentation for internal business areas and processes, incorporating factors such as technical design, data manipulation, ETL and storage management.
• Tracked and leveraged data trends, aggregate statistics and volume fluctuations to hone [Type] performance metrics.
• Created dashboards to monitor and track key performance indicators.
• Utilized data visualization techniques to present and explain complex data sets.
• Developed customized reports, summarizing and presenting data in visually appealing format.
• Developed complex dashboard and reporting tools to track business performance metrics.
• Deployed predictive analytics models to forecast future trends.

• Standard chartered – GBS, is a wholly owned subsidiary of Standard Chartered Bank, UK Plc, Standard chartered – GBS, handles a wide range of value-added and complex services from Banking Operations to support globally
• Retail risk team is basically to design, analyze and maintain the data as per the bank requirements for all retail banking teams across all countries
• Understanding the systems, business requirements and scope of the project
• Involved in enhancements of SAS Programs
• Supporting Ad hoc queries requested by the team
• Collaborate with peers, managers to resolve issues and achieve goals
• Strong skills in Data Analysis, Requirement Analysis, and Data Mapping for business processes.
• Collaborated closely with business partners to understand their needs and develop tailored analytical solutions accordingly.
• Mentored junior analysts in mastering SAS programming skills, fostering their professional development and growth.
• Spearheaded the migration from legacy systems to updated SAS platforms, ensuring minimal downtime during transition periods.
• Identified areas for cost reduction through a thorough analysis of financial data using SAS software.
• Optimized marketing campaigns by conducting thorough customer segmentation analyses using SAS analytics.
• Increased efficiency in data analysis by designing and executing complex statistical models using SAS software.
• Leveraged the full potential of SAS capabilities to drive data-driven decision-making across various departments within the organization.
• Produced monthly reports using advanced Excel spreadsheet functions.
• Utilized data visualization tools to effectively communicate business insights.
• Identified, analyzed and interpreted trends or patterns in complex data sets.
• Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
• Collaborated with stakeholders to identify business needs and data sources.

• WNS is Serviced company providing support to Suncorp Group which is into insurance and banking in Australia
• We do MIS reporting and improve customer services by delivering timely and accurate financial balanced reports
• The aim of the project was to provide users with all claims and policies related information for analysis
• Also design and develop the reports for the customers
• Database will provide integrated data from its operational systems and provide tools to capture, analyze and maximize the full potential of the integrated data through decision support and analysis
• Understanding the business requirements and scope of the project
• Project included running weekly and monthly reports using Base SAS,Macros and SQL
• Traveled to onsite for report transition purpose
• Developing SQL Queries and doing exploratory analysis on the data
• Actively participated in the SDLC phases, from planning to support, ensuring the successful implementation of projects in production environments
• Conducted audit checks on generated reports, ensuring data quality and compliance with established standards
• Engaged in continuous learning and staying updated on emerging technologies, contributing to the adoption of best practices in data analytics
• Enhanced SAS programs using pass-through methods and Libname statements for extracting data from diverse sources
• Worked on making changes in Tableau reports, ensuring alignment with evolving business requirements
• Developed and executed SAS programs for extracting data from Data-mart, supporting business analysis and decision-making
• Conducted pre-processing checks on history, responder, and accounts files, ensuring data accuracy and reliability
• Improved report efficiency by revising and automating daily, weekly, monthly, and quarterly reports, providing timely and meaningful information
• Supported ad-hoc queries and collaborated with team members to resolve data-related issues, ensuring smooth data operations
• Traveled on-site for report transition purposes, ensuring a seamless transfer of responsibilities and knowledge transfer
• Strong reporting and analytics experience
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Responsible for error handling, stored procedures, creating tables, views, triggers etc
• Enabled stakeholders with actionable, intuitive performance insights that provide the business with direction; Responded to business requests, including research and analysis of member data.
• Mentored junior analysts, fostering professional development while enhancing overall team performance.
• Collaborated with cross-functional teams to identify areas of improvement, leading to increased operational effectiveness.
• Investigated system issues and implemented resolutions to reduce downtime.
• Improved company efficiency with the development of key performance indicators and tracking metrics.

• Tesco is the largest retailer in the UK
• Our team extract, collate, analyze and present data for the Commercial Food teams in a clear and timely manner and have worked extensively on SQL to fetch out relevant data from the Tesco data warehouse (Teradata)
• Our Team does analysis work extensively on ad-hoc requests Developing SQL Queries for generating standard reports
• Creating reports using Internally Tesco Tools like CAR (commercial Ad-hoc reporting)
• Doing Audit Checks for generated Reports
• Worked on Forecast analysis during production promotions
• Implemented automation scripts for repetitive data extraction tasks, reducing manual effort and increasing efficiency
• Spearheaded process improvement initiatives, streamlining data analysis procedures and enhancing overall team productivity
• Interpret data, analyze results using statistical techniques and provide ongoing reports.
• Improved company efficiency with the development of key performance indicators and tracking metrics.
• Investigated system issues and implemented resolutions to reduce downtime.
• Collaborated with cross-functional teams to identify areas of improvement, leading to increased operational effectiveness.
• Utilized data visualization tools to effectively communicate business insights.
• Produced monthly reports using advanced Excel spreadsheet functions.
• Improved decision-making processes with accurate data analysis and visualization techniques.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.

• Mu-sigma business Solutions is a Service provider to US Bank for campaign management and reporting
• Involved in generating reports for different portfolios for Balance Transfer and Non – BT Campaigns
• This Process is done on a quarterly Basis for all portfolios
• Developing SAS Programs to extract the data from Data-mart
• Doing pre-processing Checks on History, Responder and Accounts file
• Doing Audit Checks for generated Reports
• Running SQL Queries for Analysis Team.
• Collaborated closely with IT teams for seamless integration between legacy systems and new SAP implementations, reducing data migration issues significantly.
• Performed gap analysis between existing systems or processes and desired state, identifying areas for improvement or enhancement.
• Improved business processes by analyzing current practices and recommending optimization strategies.
• Executed analysis of risks and identified risk mitigation strategies.
• Analyzed open orders, backlog, and sales data to provide sales team with insights.
• Reduced operational costs through thorough data analysis and implementing cost-effective solutions.