Naresh Kumar Aouti

Certified BASE SAS Programmer with 3 years of experience in IT industry specializing in data warehousing, data analysis, and data reporting in the banking and finance sector.

Experienced professional adept at reading data from various sources including Notepad, Excel, CSV, MS-Access, and Oracle. Proficient in extracting and analyzing data to drive business insights. Skilled in utilizing data manipulation tools and techniques to ensure accuracy and efficiency.

Experienced professional with expertise in Base SAS: Essentials, including accessing data, creating data structures, managing data, generating reports, and handling errors. Skilled in cleaning data using SAS base procedures to check for duplicate variables and remove unwanted duplicates.

Experienced professional proficient in SAS character, numeric, and date & time functions. Demonstrated ability to leverage these skills to achieve successful outcomes.

Used output delivery system extensively to generate reports in HTML, RTF, PDF and EXCEL reports.

Good experience on various SAS functions like SCAN, SUBSTR, TRIM, STRIP, INTCK, INTNX, MEAN, RANGE, NMISS, CEIL, FLOOR, ROUND, ABS, CAT etc.

Willing to learn any technology according to company requirements.

Project 1 Title : UCL Monitoring, 

Client : FNBO, 

Role : SAS Analyst, 

Environment : Base/SAS, SAS/SQL, SAS Macros, 

Database : Client Data

Project 2 Title: APP   Fraud

Client: FNBO

Role: SAS   Analyst

Environment: Base/SAS, SAS/SQL, SAS Macros

Database: Client Data

Analysis of the Corporate Salary Accounts and Savings Accounts based on their Average Month Balance (AMB) and Product Holding(PH) are maintained which we need to report the seniors on daily basis. Based on the requirement by product team we develop code and analyze as per the project.

• Worked as part of a global team to develop SAS ETL software required to support a variety of business needs and often communicate with end-client on required specifications on data.
• Developed database in projects with large, diverse, client data source files and Worked on the planning and coordination of work activity for projects involving more than 2 million records.
• Salary accounts close every month.
• Bring the all information of current and saving accounts and those accounts balances.
• Refreshing the data marts every day without delay, so that the other dependent reports get released in time.
• Performing ETL concepts like validation, scrubbing, De-normalization, structuring, summarizing, and integrating.
• Analyzing data and generating reports using various SAS procedures.
• Developing MACROS to perform automation of SAS programs.
• Linking all the products at unique id level .to suppress or to generate offer at Unique Id level rather than on individual product id level.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries. Migrating of data from flat files to SAS data sets.
• Performed SAS programming required for data analysis and reporting.
• Documentation, Preparing Excel reports using SAS
• Involved in development and enhancements of SAS Programs.
• Involved in writing code to extracting, cleansing and validate.
• Developed SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Created HTML reports using SAS ODS facility.

Telugu,English, Hindi.

• Citizenship: Indian
• Gender: Male
• DOB: 06-06-1994