Software Engineer Data
Resume:
ABHISHEK AGGARWAL
******************@*****.***
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
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