Data Quality Visualization

Satish Kondapareddy

************@*****.*** Phone: 074********

Summary

●An Experienced IT Professional experience, worked in Reputed Companies like SAS, NOVARTIS, Pfizer, ABBOTT, HETRO pharma, ABN AMRO, NBS, PFG, RBS, HP, HSBC, HMRC, VIRGIN MONEY, PFIZER, IKANO BANK (IKEA GROUP).

●Extensive Banking experience in Data Architecture, Data Quality - best practices and Control practices and methods to Scaling Data Quality, Data warehouse, Data governance framework,

Data Management, Data stewards, Data Visualization, Data harmonization, Data cleansing etc.

●Sound experience in Architectural principles and processes.

●Sound experience in Logistic, IT, Banking and Retail domains in CRM, E-commerce / Web Application.

●Conducted system data quality audits for all loans and transferred loan specifications to the banking system; updated rate changes, borrowing base, loan grades, and payment changes into the system.

●Resolved issues related to the overall financial integrity of banking institutions including loan investment, portfolios, capital, earnings, and large troubled accounts.

●Performed routine credit transactions including new loan funding, advances, payments, payoff, paydown, and fee waivers.

●Experienced in Data manipulation, Data Visualization, SAS Visual Analytics Installation on Non-Distributed & Distributed Environments in Linux, and Windows Operating Systems and HDFS, Apache Spark, Spark-SQL, Python.

●Strong business analysis and gap analysis skills, Requirement management, User stories, functional design and specification documentation, project planning, Impact Analysis, and release management.

●Strong experience in credit sanctioning, underwriting, due diligence, and gap analysis.

●Compiled loan and credit documents required for appraisals to process loan applications.

●Led one-on-one client consultations to compile and assess clients’ financial standing and eligibility for loans.

●Managed information systems, ensuring the accuracy of each loan application incompliance with established standards of practice.

●Analyzed current trends and changes in regard to the financial market and policies to provide clients with the most up-to-date information.

●Very good understanding of regulatory frameworks like MiFID (Markets in Financial Instruments Directive) and EMIR (European Market Infrastructure Regulation).

●Internal and external stakeholder management at different levels and from different teams in the projects. Acting as link between the business and Development Teams and managing the 3rd party suppliers.

●Handle daily stand ups, JIRA board, sprint planning, sprint review and sprint retrospect meeting.

●Conducting workshops, product demos and training the users/Customers.

●Handling Business process flow charts using MS Visio and use case diagrams.

●Worked on MIS/KPI reports. Experienced in preparation of test cases and review and testing execution.

●Handled enhancements to the applications to fit the evolving industry requirements.

●Hands on experience on Agile and waterfall methodologies.

●Conduct Impact analysis, handle change requirements and manage requirement traceability matrix.

●Ability to communicate complex situations quickly and clearly to different stakeholders with a variety of technical skills and to resolve issues quickly and correctly.

●Exposure to change management and Lean six sigma and governance.

●Handled project management and hands on experience on MS Project.

●Experienced in preparing documentation of Installation and standard operating procedures.

●Sound Knowledge of all Windows and LINUX Server Operating systems.

●Evaluate SAS environments to ensure architecture and specifications adhere to best practices.

●Architect and design platform solutions to meet and exceed expectations of Product Manager.

●Architectural standards/principles, global product-specific guidelines, security standards and design standards.

●Experience in DevOps, data Strategy and leading practices.

●Sound experience in Configuration Management, DevOps, Build and Release Engineer.

●Good knowledge of Software Development Life Cycle, SCM practices along with software Build and Release Management methodologies.

●Extensively worked on Hudson and Jenkins for continuous integration and for End-to-End.

●Sound experience in DevOps culture along with AWS, like PaaS, IaaS, Cloud Infrastructure Services.

●Responsible for Continuous Integration (CI) and Continuous Delivery (CD) process implementation using Jenkins along with Python and Shell scripts to automate routine jobs.

●Created Jenkins Jobs to automate application Builds by pulling code from GIT & GitHub repositories.

●Having good experience with installation and configuration of Kubernetes, clustering, and managing local deployments in Kubernetes.

●Lead and develop projects from early concept through design development.

●Prepare drawings, specifications, and construction documents.

●Design and document commercial and industrial building projects.

●Coordinate preliminary architectural studies for major new structures and alterations to existing structures & site development.

●Work with teams across business lines, in remote locations, and coordinate with teams.

●Assess database implementation procedures to ensure they comply with internal and external regulations.

●Design and implement effective database solutions and models to store and retrieve data.

●Experience on Application Migration and Data Migration from On-Premises to AWS Cloud.

●Good exposure with creating CloudFormation templates for quick, easy, and rapid deployment of Infrastructure, Google Cloud Platform, Puppet, .net,

●Experience in SDLC, ITIL, Waterfall, Agile methods,

●Good stakeholder relationship skills.

Education and Certifications

ITIL v3 Foundation and ISO 20,000 MBA Investment Banking – IBI London

Jobs and Roles

AVENIR Digital Ltd, London Role: Business Analyst (Dec 2020– till date)

SAS Institute, Belgium Role: Business Analyst (Feb 2020 – Dec 2020)

AVENIR Digital Ltd, London Role: Business Analyst (Apr 2019 – Jan 2020)

SAS Institute, Netherlands Role: Business Analyst (July 2018 - Mar 2019)

HSBC, Leeds Role: Business Analyst (May 2017 - July 2018)

AVENIR Digital Ltd, London Role: Business Analyst (Nov 2016 - May 2017)

NATIONWIDE BUILDING SOCIETY, Swindon Role: SAS Consultant (Dec 2015 - Sep 2016)

PARKER FITZGERALD, Halifax Role: Lead SAS DI Developer (April 2015 - Dec 2015)

HP UK, Blackpool Role: SAS ETL Developer (Oct 2014 - Jan 2015)

HSBC, Chester, UK Role: Risk Analyst (May 2014 - Aug 2014)

IKANO BANK, Nottingham, UK Role: Risk Analyst (Nov 2013 - Jan-2014)

VIRGIN MONEY, Newcastle upon Tyne Role: Risk Analyst, Data Architecture (Mar 2013 - Sep 2013)

DWP, Newcastle upon Tyne Role: MI Analyst (May 2012 - Nov 2012)

Key Experience

AVENIR Digital Ltd, London Role: Business Analyst (Dec 2020– till date)

Project: IFRS17 Client: Atradius

Design and implementation of major data governance projects such as the data governance framework and the warehouse and business intelligence executive portal. Ensure business functionality by consolidating key performance-based metrics and dimensions. Communicate with cross-divisional personnel at both team and executive levels to understand performance measurement methodologies. Direct team members in compiling business requirements and executing project milestones.

●To undertake business analysis, collect business requirements, change request and produce appropriate documentation using industry standard tools and techniques.

●Prepare HRD’s and BRD’s.

●Resolved issues related to the overall financial integrity of banking institutions including loan investment, portfolios, capital, earnings, and large troubled accounts.

●Performed routine credit transactions including new loan funding, advances, payments, payoff, paydown, and fee waivers.

●Prepare requirement traceability matrix using JIRA software.

●Support Project managers in project plans and handle Scrum meetings.

●Compiled loan and credit documents required for appraisals to process loan applications.

●Led one-on-one client consultations to compile and assess clients’ financial standing and eligibility for loans.

●Managed information systems, ensuring the accuracy of each loan application incompliance with established standards of practice.

●Analyzed current trends and changes in regard to the financial market and policies to provide clients with the most up-to-date information.

●Handle stakeholders at different stages of the project life cycle.

●Conduct workshops for requirements gathering. Take ownership of the requirements and get them baselined.

●Identify: Define and collect data quality issues, where they occur, and their business value.2.

●Prioritize: Prioritize data quality issues by their value and business impact.

●Analyze for Root Cause: Perform a root cause analysis on the data quality issue.

●Improve: Fix the data quality issue through ETL fixes, process changes, master data management, or manually.

●Control: Framework to control the data management like seven must-have data quality checks in ETL.

NULL values test

Volume tests

Numeric distribution tests

Uniqueness tests

Referential integrity test

String patterns.

Freshness checks

Data Observability: The Key to Scaling Data Quality

SAS Institute, Belgium Role: Business Analyst

Project: SAS PSD Client: SAS Institute, Belgium (Feb 2020 – Dec 2020)

Installation and configuration SAS Viya 3.5 (Visual Investigator, ESP, VA, Forecasting server and other components on the AWS env) Viya 3.5, SAS 9.4 in Windows, Unix, CentOS machines. Migration of Metadata components find tunning of environment for effective use in Azure. Creating and managing Ansible play books. Administering and deploying development CI/CD tools such as Git, Jira, GitLab knowledge of distributed computing and non-distributed computing and low latency, multithreaded, high-available and Grid solutions.

AVENIR Digital Ltd, London Role: Business Analyst

Project: Zeva Client: Avenir, UK (Apr 2019 – Jan 2020)

●Azure API Management, Security, Cloud-to-Cloud Integration (Public, Private).

●Windows Azure (Website, web role and worker roles).

●Responsible for collaborating on and setting cloud vision; providing thought leadership in cloud infrastructure and cloud services architecture to meet operational objectives for cloud solutions.

●Educate customers of all sizes on the value proposition of managed services on Azure and participate in architectural discussions to ensure solutions are designed for successful deployment in the cloud.

●Advanced knowledge of databases advanced knowledge of relevant web services, mail, backup, and application monitoring.

●Define cloud network architecture using Azure virtual networks, VPN & express route to establish connectivity between on premise & cloud.

●To undertake business analysis, collect business requirements, and produce appropriate documentation using industry standard tools and techniques.

●Handle change requests and project support, prepare HRD’s, BRD’s and project documentation.

●Prepare requirement traceability matrix using JIRA software.

●Handle stakeholders at different stages of the project life cycle.

●Conduct workshops for requirements gathering. Take ownership of the requirements and get them baselined.

●Setting the collaboration framework, creating a solution prototype, participating in technology selection.

●Controlling solution development, supporting project management, technical design from IRB ‘As Is’ to ‘To Be’.

●Designing the process and Documentation like conceptual designing, process designing, overarching documentations.

SAS Institute, Netherlands Role: Business Analyst

Project: FRAAI Client: ABN AMRO (Jul 2018 – Mar 2019)

FRAAI project is an advanced project, to determine the Default, forbearance, performance, Impairment instantly using live data, by creating a data pool and default engine to calculate. Requirement gathering, design, Development, and Implementation Business Rules for Definition of Default and CRR in FRAAI project - Mortgage Portfolio and point of contact and Documentation.

Responsible for

●To undertake business analysis, collect business requirements, and produce appropriate documentation using industry standard tools and techniques.

●Handle change requests and project support.

●Prepare HRD’s, BRD’s and project documentation.

●Prepare requirement traceability matrix using JIRA software.

●Handle stakeholders at different stages of the project life cycle.

●Conduct workshops for requirements gathering. Take ownership of the requirements and get them baselined.

HSBC, Leeds Role: Business Analyst

Project: IFRS 9 Client: HSBC (May 2017 – Jun 2018)

IFRA9 implementation – Requirement gathering, code review, remediation, Development, Implementation and Scheduling of SAS DI jobs, for Secured and Unsecured portfolios to support Parallel. Lead the Project, point of contact for the IFRS Project and Documentation.

Responsible for all

●Developed process mapping of current and future business processes.

●Prototyped new procedures and trained new users on software enhancements.

●Led project teams, internal and external, to achieve project defined milestones and deliverables.

●Translated business user concepts and ideas into comprehensive business requirements and design documents.

●Created project plans in accordance with project management framework standards and procedures. Identified ongoing issues and gaps within project plans, to eliminate implementation issues.

●Planned, facilitated, and reported on quality assurance testing efforts.

●Define, Setting and amending existing Data Quality Management framework, Data Quality Management, DQ checks, setting up Data Governance framework in the new project, Data visualization and reporting to enhance insight analysis for stakeholders to make their decisions.

AVENIR Digital Ltd, London Role: Business Analyst

Project: LMS Client: Avenir Digital (Nov 2016 – May 2017)

Designing and implementation of public and private facing websites on AWS Cloud. Migrating from On-Premises Infrastructure to AWS Cloud.

●Configured and managed various AWS Services including EC2, RDS, VPC, S3, Glacier, CloudWatch, CloudFront, Route53, SQS, SNS etc.

●Worked with AWS Discovery tool and architecture assessments providing critical data for migrating to AWS.

●Design, Implement and maintain all AWS Infrastructure and services within a managed service environment.

●Design, Deploy and maintain enterprise class security, network, and systems management applications within an AWS Environment.

●To capture as-is and to-be process of credit card/campaign mailing process.

●Handle MI reports, BAU process of invoice payments for 3rd party service providers, PMO responsibilities and customized PRINCE 2 project methodology to suit Credit card projects.

●Co-ordinate with teams for smooth campaigning process and manage external and internal stakeholders.

●Identify, Manage and Communicate Issues and Risks to Senior Management.

●Provided executives with analytics and decision-support tools used as the basis for reorganization, consolidation, and relocation strategies.

●Partnered with developers to automate manual processes, saving time and money while decreasing errors. Credited as a primary driving force behind a 5% increase in margins this fiscal year.

●Collaborated with stakeholder groups across the organization to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs.

●Performed quality assurance, system integration and user acceptance testing facilitating on-time, on-budget and acclaimed “go-live” of enterprise implementations for up to 12,000 global users.

●Created POC using AWS Code Commit, Code Pipeline and Code Deploy for Continuous Integration on AWS Infrastructure.

Nationwide Building Society, Swindon Role: SAS Consultant

Project: IFRS9 Client: NBS (Dec 2015 – Sep 2016)

Designing, development and Implementation of IFRS9 models in unsecured models - Personal loans, Credit Cards in IMCC Team. Worked on the IFRS9 project, to replace the existing IAS 39 with IFRS9. The primary objective is to build the IFRS9 model. Development Loans, Personal current account and Cards Data architecture design, detail design documents for the model to generate hung multiple data marts for business users pointing to different locations like staging and target location in DEV, UAT and PROD. The model includes monthly Impairment, modified asset, calculations for Implementation of PD, EAD, and LGD models. Documentation with conceptual, Logical and Physical designs in the data warehouse.

Responsible for all SAS admin tasks like - User/ group Security access, ACT, Plug-in for secured access, Mid - tier set up, Client – tier setup etc.,

Environment and Tools Used: SMC (9.1), SAS plat form admin, Unix.

Parker Fitzgerald, Halifax Role: SAS DI – LEAD Developer

Project: IFRS9 Client: Lloyds Bank (Mar 2015 -Dec 2015)

Worked through Parker Fitzgerald in Lloyds bank, Halifax, in IFRS9 project, to replace the existing IAS 39 with IFRS9 in Lemans environment. The primary objective is to build the IFRS9 model. Developed Loans, Personal current account and Cards Data pools design, detail design documents for the model to generate hung multiple data marts for business users pointing to different locations like staging and target location in DEV, UAT and PROD. The model includes monthly input files, monthly output files Impairment, modified asset, calculation engine for PD, Implementation of PD, EAD, and LGD models. Worked closely with the modelling team in developing impairment model – PCA.

Identifying code, data and process issue, suggesting code remediation in LEMANS from as-is and to-be implemented – data warehouse.

Documentation with conceptual, Logical and Physical designs in the data warehouse.

Environment and Tools Used: SAS Di (4.2) SAS EG (4.3), SMC (9.1), UNIX, macros, SAS programming, Hadoop framework.

HP, Blackpool Role: SAS Consultant, ETL Developer

Project: Audit Trail Analysis Service-2 (BENCap, LMS) Client: DWP (Oct 2014-Jan 2015)

●Worked with AD as a SAS Consultant - ETL Developer for ATAS2.

●Application development of BENEFIT Cap and LMS are the main objectives of the role.

●Liaise with Production team and schedule meet to design, deploy and schedule the Jobs using SAS DI.

●Create user defined jobs, chart down the requirements for the Metadata. Update the metadata by Microsoft Plugin’s.

●Perform the role of individual business area group admin and use SAS Management Console to define and setup the Group’s. permissions and user roles for each area.

●Unit, Integration and UAT Testing, Documentation at every stage.

Environment and Tools Used: SAS/BASE, SAS/Macros, SQL, SAS/EG, SAS/DI, SAS/MC, Putty, WINSCP, and AUTOSYS.

HSBC, Chester Role: Financial crime Risk Analyst

Project: RETAIL BANK WEALTH MANAGEMENT-Data Readiness (FCC – RAM) Client : HSBC (May2014- Aug 2014)

●Worked as a Risk Analyst in Retail Banking Wealth Management team.

●The Main aspect of the project is to KYC, Prioritization and Identifying the list of Customers.

●Gather requirements for the Models to be built in FCC-RAM SAS technics.

●Contributed analytical skills to the development of the FCC-RAM model.

●Observe the data trends as per the Model, Ad-hoc request on Sanctions Reports.

●Identify the data anomalies like missing, invalid, abnormal data to enhance the data readiness.

●Created MI reports whole book of HSBC, all brand HSBC, M&S, and First Direct to support AML, Customer Due Diligence system.

●Tested and deployed the model Data Readiness FCC-RAM project.

●Documentation like – data dictionary, Test process etc.

Environment and Tools Used: SAS/BASE, SAS/Macros, Putty, TERADATA, SAS/EG, VBA.

IKANO BANK, Nottingham, UK Role: Risk Analyst - Credit Risk Analysis

Project: Risk Data Acquisition Client: Ikano Bank (Nov 2013 – Jan 2014)

●Worked as SAS Developer in Credit Risk team. Extracting data from Primary data sources like SQL server.

●Gather requirements for the Models to be built in Data Acquisition using SAS technics.

●Extracting data from different sources, transforming the data as per the Business Requirement, loading the data in the defined Enterprise data marts for different departments.

●Consolidate all the insight of the data and trends to a MI report.

●Identify the Anomalies, issues, missing and invalid information in the data, escalate the information to the senior shareholders.

●Creating data marks and Hash tables of Pan Credit and Bureau-Credit Risk data.

●Optimization and Automation of the process.

●Output the data to Qlik view to generate MI reports on Monthly, Weekly and daily.

●Unit, Integration and UAT Testing.

●Documentation at every stage.

Environment and Tools Used: SAS/BASE, SAS/Macros, SQL server, SAS/EG and QLICK VIEW.

VIRGIN MONEY, Newcastle Upon Tyne, UK Role: Risk Analyst, Data Architecture

Project: RRI (MIGRATION DW- Enterprise Data Warehouse) Client : Virgin Money (Mar 2013 – Sep 2013)

Worked as Data Architect in Insurance Risk assessment team. Ensures master data integrity in key systems as well as maintaining the processes to support the data quality. Identifies areas for data quality improvements and helps to resolve data quality problems through the appropriate choice of error detection and correction, process control and improvement, or process design strategies. Ensures quality of master data in key systems, as well as development and documentation of processes with other functional data owners to support ongoing maintenance and data integrity. In collaboration with subject matter experts and data stewards, defines and implements data strategy, policies, controls, and programs to ensure the enterprise data is accurate, complete, secure, and reliable. Aid in resolving data quality problems through the appropriate choice of error detection and correction, process control and improvement, or process design strategies collaborating with subject matter experts (SMEs) and data stewards. Manages, analyses, and resolves data initiative issues and manages revisions needed to best meet internal and customer requirements while adhering to published data standards.

Environment and Tools Used: SAS/BASE, SAS/Macros, SAS DI, ORACLE11g, OLAP SQL Developer, SAS/SQL, Omiga, VBA.

DWP (HMRC), Newcastle Upon Tyne, UK Role: MI Analyst, Scotland Yard Check cleared.

Project 1: Future Scheme II Client: CMG (May 2012 - Nov 2012)

●Design and programming of SAS matching data strategies.

●Create and manage very large data sets, analyses and reconcile unmatched or exceptional data.

●Develop and maintain SAS databases supporting analysis data activities.

●Edit and modify SAS programs to perform logical edits to rectify data inconsistencies and anomalies.

●Interpret, summarize analyses, Production of reports, including automated reports within the Testing consolidation & reporting system and the production of significant amounts of ad-hoc analysis required by executives across the team.

●Provide support to the Reporting & MI Lead and Consolidation and Reporting Head in the execution of their work.

●Stakeholder management.

Environment and Tools Used: SAS/BASE, SAS/Macros, VBA, SQL/Putty/UNIX, UAT.

REFERENCE: References will be provided.

Contact this candidate