Data Analysis Power Bi

V R ANAND Email: ************@*****.***

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

EXPERIENCE SUMMARY:

Over 8 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

Skilled in converting SAS codes into Python/PySpark scripts.

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.

Expertise in visualization of SAS reports in Informatica (IICS), Spotfire and Power BI.

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.

TECHNICAL SKILLS:

Pyspark/databricks /SAS codes into Python scripts. Informatica, 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:

CURRENT PROJECT -

Client : Health First

Duration : May-2024 to Present

Role : Principle Software Engineer

Company : Innova Solutions

RESPONSIBILITIES: -

Data Extraction and Transformation: Extract data from various sources (databases, flat files, etc.), clean, transform, and prepare it for analysis.

SAS Programming: Develop and maintain SAS programs using Base SAS, SAS/SQL, SAS/MACRO, and other SAS components to manipulate and analyse data.

Data Analysis: Perform statistical analysis, data mining, and modelling to uncover insights and trends.

Report Development: Create clear and informative reports using SAS/Report, SAS/Graph, or other reporting tools.

Data Visualization: Develop interactive dashboards and visualizations to communicate findings effectively.

Project Management: Contribute to project planning, execution, and delivery by collaborating with cross-functional teams.

Documentation: Write clear and comprehensive documentation for code, processes, and reports.

Testing and Quality Assurance: Conduct thorough testing to ensure data accuracy and program reliability.

Performance Optimization: Identify and implement performance improvements to SAS programs.

Technical Support: Provide technical support to end-users regarding data and SAS applications.

PROJECT #1 -

Client : Western Digital Company

Duration : Feb-2021 to May-2024.

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