ABHISHEK AGGARWAL

+91-931*******

ac491z@r.postjobfree.com

CAREER OBJECTIVE

Seeking for a prospect in an organization which can utilize my analytical and technical Skills for growth, benefit and success for the betterment of the company, I’m associated with. COMPANY EXPERIENCE

Sopra Steria Group, Noida :- (Sept 2014 – Present) SUMMARY

Currently associated with Sopra Steria Group, Noida as a Senior Software Engineer.

Certified SAS Programmer with experience in Analysis, development, testing and validating the applications.

Worked on SAS/Base, SAS/Macro and SQL.

Provided technical assistance for development and execution of test plans and cases as per requirements.

Experienced in handling Terabytes of records and manipulating them through SAS

Imported raw data files in excel format in SAS and subsequently created SAS Datasets and performed data manipulations on the datasets.

Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements.

Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the Database.

Documentation, presentation, analyze data and generate reports.

Standardized those reporting programs into macros.

Supported technical team members in development of automated processes for data extraction and analysis.

Participated in learning of techniques for statistical analysis projects, algorithms and new methods.

Extremely energetic, detail oriented, organized, team player with strong analytical abilities and problem solving skills

Highly persistent and motivated with willingness to assume responsibility PROJECTS

Client: - TESCO

Role: - SAS programmer

Responsibilities:-

Data Extraction from Teradata as per the requirement.

Extracting BAU reports related to customers, sellers, total sales, delivery options etc. on daily basis using PROC SQL, MACRO for both online and offline stores.

Monthly reports for obsolete products, rejected products etc. using PROC REPORTS so that it will be easier to analyze the data.

Expertise in generating data from tables for various phases and visits on an hourly, daily and weekly basis.

Few Geographical reports also i.e. region wise sales, profit & loss etc.

Producing external files and reports using PROC EXPORT to export the result in html, pdf, csv formats. Concept of ODS (output delivery system) is used for exporting the output.

Various SAS procedures like Proc Print, Proc Sort, Proc Summary, Proc Freq, Proc Mean etc. are used frequently on daily basis for performing daily tasks

Had performed FACTOR analysis with help you STATS team for variable reduction for analytics use.

Done hands-on Cluster analysis also.

Client: - British Telecom

Role: - Analyst

Responsibilities: -

Generate reports related to Addition/deletion of customers from the network.

Extract bills reports which are pending after 1 week of billing cycle.

Monthly Payment methods preference report of customers to be processed.

Complaints reports based on based regions of UK is extracted on daily basis.

Reports based on whether customers attracted towards Promotional/seasonal offers.

Quarterly report of all the privileged customers.

Many other BAU activities like documentation, MOM reports etc. SYSTEM EXPERIENCE

Operating Systems : Windows XP, Windows 7 Professional.

Application Packages : SAS v9.1/BASE,Oracle Database 10g Express Edition

Programming Languages : SAS Base/Advance, Oracle 9i, SQL ACHIEVEMENTS

Received SPOT award for spontaneous troubleshooting the error.

Awarded three times V@W (Value at Work) for contributing smart solutions to complex problems by Sopra Steria Group.

Awarded Star performer award for quickly handling the applications separately. CERTIFICATIONS

SAS Certified Base Programmer.

PERSONAL DETAILS

Nationality:

Passport Number:

Driving License:

Indian

M2366684

DL-072**********

Date Of Birth: May 31st, 1992

Marital Status: Single

Language: Hindi, English

DECLARATION:

I hereby declare that all the information provided here is correct to the best of my knowledge. DATE: 01st March, 2018 (Abhishek Aggarwal)

Contact this candidate