V R ANAND Email: ad49qw@r.postjobfree.com

Phone: +91-709*******

EXPERIENCE SUMMARY:

Over 7 years of extensive experience in SAS programming on different platforms - Windows and UNIX, also having worked in data analysis, updating, testing, trending and business driven data validation

Data Cleaning: Responsible for cleaning and preprocessing raw data to ensure accuracy and consistency. This involves handling missing values, removing duplicates, and transforming data into a suitable format for analysis.

Python libraries such as Pandas, NumPy, and Matplotlib are commonly used for tasks like data visualization, and data analysis.

Automation: Automating repetitive tasks using Python scripts or workflows improves efficiency and productivity.

Skilled in converting SAS codes into Python/Pyspark scripts.

Demonstrated expertise in SAS Macros and PROC SQL, with a focus on performance optimization.

Contributed in SAS Admin task`s like providing user privileges and grid server monitoring, work space monitoring, Object migration using SAS management console etc.

Ability to develop SAS/Linux script to monitor Flow manager batch jobs and Password expire alerts to users And Proficient in Shell Scripting.

Collaborated with cross-functional teams to gather requirements, design data solutions, and deliver analytical solutions tailored to business needs, ensuring alignment with organizational goals and objectives.

Expertise in visualization of SAS reports in Spotfire and Power BI.

TECHNICAL SKILLS:

Pyspark/databricks /SAS codes into Python scripts. Tibco Spotfire & Microsoft Power BI tools

SAS Tools SAS 9.3/9.2/9.1.3, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS,

SAS/STAT, SAS/ODS, SAS/CONNECT, SAS/GRAPH, SAS/ENTERPRISE GUIDE.

UNIX scripting experience and extensive knowledge of Windows applications.

PORTAL Databases Oracle 10g/11g, MS SQL Server 2008/2012, Teradata 12/13, DB2,

MS Access, MySQL, GUI Tools MS Office, MS Project, WINSCP, Putty, WPS, TIBCO DV Studio.

EMPLOYMENT HISTORY - PROJECTS SUMMARY:

PROJECT #1 -

Client : Western Digital Company

Duration : Feb-2021 to Present.

Role : Senior SAS Analyst.

Company : Contenterra Software Technologies

RESPONSIBILITIES: -

Extensively working on converting SAS codes into Python/Pyspark scripts.

Collaboration: Collaborating with cross-functional teams to understand business requirements and provide data-driven solutions is essential.

Effective communication skills and the ability to translate technical findings into actionable insights are key for successful collaboration.

Understanding and documentation of business SAS codes of various functional areas.

Understanding and capable of handling of datatypes and formats like lengths or string/float/integer in both environments (SAS/TDV).

Discussion on Business/Technical requirements and Issue’s resolutions with client.

Built a Yield Management Tool for Product manufacturing unit using MSSQL stored procedure.

Expertise in visualization of SAS reports in Spotfire and Power BI.

PROJECT #2 –

Client : HSBC

Duration : June-2020 to Feb-2021

Role : Senior Software Engineer.

Company : WIPRO Technologies

RESPONSIBILITIES: -

Transforming the business SAS codes connecting to traditional database Teradata into cloud platform – Bigquery.

Transforming the connection strings to connect to Teradata to Bigquery in different methods (explicit/implicit way of connection).

Understanding of various functionalities and procedures in bigquery.

Understanding and capable of handling of datatypes and formats like lengths or string/float/integer in both environments

(Teradata/Bigquery).

Analysing the requirements and developing corresponding SAS codes with the use of Base and SAS Enterprise guide.

Discussion on Business/Technical requirements and Issue’s resolutions with client.

PROJECT #3 -

Client : Blue Cross Blue Shield of North Carolina

Duration : July-2017 to Oct-2019

Role : SAS Developer/Admin

Company : NTT Data Global services

RESPONSIBILITIES: -

Designed the requirements and develop corresponding SAS codes with the use of Base and advanced SAS and Creating HTML Listings, tables and reports Using ODS and DDE.

Managed missing and anomalous data in Data sets and Generating Customized reports using Proc Report Technique.

Executed the ad-hoc reports and extract files. Engineered the applications and handling the issues.

Involved in development and enhancements of SAS Programs as per the need.

Responsible for automating the existing SAS Codes/processes using SAS/MACRO facilitating reusability, increasing the efficiency and flexibility.

Administered the SAS start-up and stop scripts and the status of the server services.

Experienced in troubleshoot services that are not running and restarting the servers and good experience in adding and removing users.

Planned to transforming the data according to the requirement using SAS functions and Procedures.

PROJECT #4 -

Client : Synchrony Financial

Duration : June-2016 to Apr-2017

Project Name : Payment Solutions

Role : SAS Analyst

RESPONSIBILITIES: -

Involved in gathering specifications from the client and designing of the process.

Experienced in various transformations in SAS DI studio tool.

Designed to extract the data from different credit bureaus (TU & Experian).

Executed customer Screening reports/Mailable data reports etc. And providing them to business teams.

Published/Delivered various business reports with diff frequencies. (Monthly/Weekly...)

Involved on data quality checks development using SAS.

Redesigned the existing codes as per the new business requirements.

ACHIVEMENTS:

Achieved "Strong Execution Award" from the client on execution of business report in a very short timeline and with good accuracy.

Achieved "Best Performer Award" from the client on analysing of business report with high accuracy and transparency and conversion them into BRD.

EDUCATION:

Master of Science (Full Time) – Andhra University

DECLARATION:

I hereby affirm that the information furnished in this form is true and correct.

V R Anand

Contact this candidate