Krishna

 Having 5+ years of experience in development, analysis and support in the BFSI domain.
 Expertise in Base SAS, SAS/Macros, SAS/ODS, SAS/Access, SAS/Report and SAS/SQL in Windows and Linux Environment.
 Extensive experience in developing automation frameworks.
 Expertise in analysing information system needs, evaluating end-user requirements.
 Well versed in SQL and Teradata scripting.
 Having good experience in data analysis with expertise in various methodological and content areas.
 Ability to manage large and complex data sets and create meaningful management reports from various sources.
 Strong experience in performance tuning techniques using SAS.
 Having good knowledge on banking domain and process involved having associated with fourth largest UK bank.
 Capable of adopting new technologies, new environment and new domains.
 Having hands on experience in Data Extraction, Validation, Manipulation and Reporting.
 A dedicated team player with good communication, interpersonal, problem-solving and decision-making skills.
 Highly self-motivated with lots of interest to learn new things. It may be for personal or organizational benefits.
 Ability to work cooperatively with wide range of personalities and meet deadlines.

Involved in writing SAS data steps and macros to extract, clean and validate data from external source and compare with the source programmers output.
Automated 100 framework reports and integrated 50 reports to reduce manual intervention and optimize performance using SAS.
Automated 50 SPOD (SPDE engine) dependency framework reports.
Generate performance dashboards consisting of graphical output for various metrics and comparing the data over the past few months for various banking products using excel which goes to the senior level team and used by the executive MI in business planning.
Create MI reports by combining the various tasks from different heritages by extracting the data from SQL Server and Mainframes using PROC SQL with ODBC, PROC download/upload and manipulating the data to get the required output in turn enhancing the efficiency (Store/modify SAS datasets on IBM Mainframe static and Generational datasets (GDG) and access using Mainframe TSO regions).
Gathering client requirements for adhoc report, extracting the data from the database, performing quality checks, devising codes and procedures, delivering and testing the same.
Output delivery and support of technical development of new and existing daily, weekly and Monthly Management Information (MI) reporting and understanding the requirements of the various operational and MI reports and monitors the output to identify the trends and thus the business flow.
Ensure regular communication between the client and the Operations team to ensure that project plans, business expectations and key stakeholders are kept up to date.
Maintain the data integrity during extraction, manipulation, processing, analysis and storage and working with complex and huge datasets, and generate reports in various formats such as excel, RTF, HTML and list files using SAS ODS facility.
Validating the data and examining the quality and detail of output reports, according to the procedures and standard and ensure the quality of deliverables meet internal standards.
Explore and develop tools and technologies to support the MI Development methodology, across requirement gathering, development, delivery and testing.
Managed Data Analysis and Processing activities involving analysing, studying and summarizing data for extracting useful information which would assist in strategic decision making and planning.
Extensively worked on SAS framework which is the architecture to run the jobs in a batch process by understanding and using the various user defined macros and rewriting the existing codes into the SAS framework, to generate efficient automated and error free reports and testing the outputs in development and testing phase.
Performance tuning for the various reports using various SAS procedures like PROC SQL ,PROC SORT and data step options like MERGE, IF/WHERE, DROP, KEEP and RENAME.
Worked on 180 Quick Questions and 105 Work Requests.
Mentoring and training new team members on project overview and process documentation.
Been a strong key player in the team and currently helping the client for Audit readiness by Project Buckley, SAS Automation and SFW (SAS Frame work) for all daily, weekly, monthly and quarterly reports checking depends on SLA’s.