Programmer Analyst Resume

SUMMARY:

Competent and Result oriented professional with demonstrated capabilities in Analysis, Developing and generating Reports using SAS Programming.
Offering over 3 Years of experience as a Data Analyst in Windows.
SAS programming, data mining, data manipulation, quantitative and qualitative data analysis.
Involved in reading raw data files (CSV), text files into SAS, creating and managing the datasets based on client requirements.
Writing Macro Codes to automate complex processes.
Sub setting datasets into various datasets using SAS Macros.
Extensive coding in SAS/Base, SAS/Macros, SAS/SQL and SAS/ODS in windows environment to get various reports.
Good command of Merge, Where, Keep/Drop, Rename, Functions and IN/Formats.
Performs defect analysis and correction. Generating output files in the form of listings, RTF and PDF formats using SAS ODS.
Data manipulation by merging, appending and sorting datasets.
Tested and debugged existing macros.
Ability to work on multiple projects simultaneously and meet the deadlines as and when required.

TECHNICAL SKILLS:

Tools: SAS 9.2, SAS EG, Putty, MS Office, Tableau

Knowledge: Banking

PROFESSIONAL EXPERIENCE:

Confidential

Programmer Analyst

Project Description

We get the data from the web portal which contains information of the different application like Applications EONID, Division, Super Department, Department, ITSO Owner, Region, Strategy, Strategy type and environment. We have to send a monthly report to the client in the end of the month which contains the information of the application like last remediation date, owner information, Department and environment.

Solution Environment

SAS EG

Technologies

Languages: Base SAS, Advance SAS Programming

Database: SQL

Responsibilities:

Using macros along with Proc IMPORT and EXPORT for making datasets out of files and then exporting required data from dataset to Files of desired format.
Sanity checks for the missing data in both files.
Reading the raw data in fixed field & free format data.
Used SAS for pre - processing of data, data extraction, validation & manipulation.
Used SAS /Base and PROCs for reporting purpose.

Debugging/analysis on ongoing issues.

Confidential

Programmer Analyst

Project Description

This project involves the KPI Tracker of different team which contains the information like TCMs, service now Tickets, Jira’s, Story Points and other Deployment work effort. So we need to consolidate all the tracker of the team and need to prepare a final report according to the data.

Solution Environment

SAS EG

Technologies

Languages: Base SAS, Advance SAS Programming

Responsibilities:

Provisional system setups.
Reading the raw data in fixed field & free format data.
Used SAS for pre-processing of data, data extraction, validation & manipulation.
Used SAS /Base for reporting purpose and SAS/MACROS for automating the same.

Confidential

Programmer Analyst

Project Description

Daily before EOD we get the data of customers who have done updates in their details like address, contact information and email address with the bank. Two files are received one is of the actual data and the second one is containing the data of updates corresponding to every customer and we need to update those changes in the actual data of customer and send it back to the bank.

Solution Environment

SAS EG

Technologies

Languages: Base SAS, Advance SAS Programming

Database: SQL

Responsibilities:

Preparing Reports as per the client specifications.
Concatenating and merging Datasets using MERGE.
Manipulating complex data using DATA step programming, SAS procedures.
Documenting the set of changes for future s and sharing with the team.
Effectively communicating within the team (Onshore/offshore) and articulating concepts and ideas effectively.

Credentials:

PGD in Wireless and Mobile Computing with 77% marks.
Bachelors in Electronics and Communication Engineering from SITM Lucknow with 75.32% marks.
10+2 from C.B.S.E. Board with 73% marks.
10th from C.B.S.E. Board with 69.8% marks.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship