Data Sql
Resume:
************@*****.***
VENKAT
SUMMARY:
7.3 years of experience in Reporting and analytics by using SAS, SQL and MS Excel.
My strength lies in sound programming aspects using SAS focused.
Proficient in SAS/BASE, SAS EG, SAS/SQL, SAS MACRO, SAS/Access and EXCEL.
Professional Experience Business Analysis, Data Analysis in Finance, Insurance, Marketing, and Healthcare projects.
Expertise in building mathematical and statistical models in Database Marketing, and Risk Management Groups.
Expertise in processing large datasets for transformation, data cleansing, data scrubbing, data profiling and applying business logic rules to new data.
Expertise in writing advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis.
Experience using SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/GRAPH, MS Office tools.
Experience in generating reports employing various SAS procedures like s and Data _null_.
Developed SAS programs generate new datasets from raw data files using Import Techniques and modified existing datasets using SQL, Set, Merge, Sort, Update, Formats and Functions using (HTML, Excel, PDF, Word, XML) and converting various files types to SAS Datasets.
Experience with PROC, SQL, SAS Array and SAS Macros and developing new Codes.
Extensive experience in preparation of reports, tables, Listings and Graphs.
Good exposure to Banking and credit cards, Loans, Current accounts and savings accounts domain.
Automating the process by using SAS Macros to make the process user effortless.
Having the knowledge of DI STUDIO
knowledge of creating JOBS, creating STORED PROCESS
Ability to work independently, collectively, good communication skills, a leader, builder as well as quick and self-learner, and able to deliver under press.
Willing to relocate: Anywhere
SAS Expertise:
SAS Tools : Base SAS, SAS Macros, SAS/Connect.
SAS Procedures : Import, Export, Data sets, Content, Sort, Report, sql.
DI STUDIO : Creating jobs, Stored Process, OLAP CUBES, USING TRANSFORMATIONS
ACADEMIC PROFILE:
Bachelors in Technology (B. Tech) from JNTU University in 2009
WORK EXPERINCE
Accenture - October 2013 to July 2016
John Deere - Moline, IL, USA
SAS Programmer/Senior Analyst
Description:
John Deere is a manufacturing company of Tractors, Combines, Hay And Forage, Agriculture Customers comes for warranty of the vehicle and company spends some amount of money for repairs and replacement of the parts we have to analyze the failing parts and suggest the company to reduce its warranty cost so that we can save company in terms of cost and better reliability.
Responsibilities:
Generate EI List for Alerts for the major failures. Developed SAS code to generate Reports.
Extract the data from MDAW by using SQL queries.
Create the stored process as per their requirement for standard Reports and make changes in SAS MACRO code if needed.
Using Enterprise-Miner for Text Analytics, to get the text-themes which are useful in Root Cause Analysis of the failure.
Preparing Evidence-Package to know detail analysis of a part failed.
Helped the team to Automate Supplier Analysis Report using Proc Report and PROC SQL to save time and reduce manual errors.
Environment: E-Miner, STORED PROCESS, SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ACCESS, MS EXCEL
SakSoft - June 2012 to August 2013
ANZ- New York,NY, USA
SAS Analyst/Consultant
Description:
ANZ Bank provides Saving Accounts and current Accounts for its customers. This dash board contains MDAB, CDAB, Activity of the Current Account (CA) and Savings Account (SA).The Dash boards also contains Product per customer (PPC) i.e apart from the accounts how many other products the customer is having with Bank.
Responsibilities:
Involved in collecting the data from sql pre-checking the data requirements.
Preparation of code according to requirements.
Once the output is ready prepare the pivots for the values to be pasted into the Dash Board
Pasting the current month’s values into Dash Boards and updating the graphs.
The Dash Boards for errors and finding out the reasons for high or low values compared to previous month.
From the dash board preparing Power Point Presentations (ppt) required for meetings.
Environment: SAS/BASE, SAS/EG (4.1, 4.3, 4.5), SAS/SQL, SAS/MACRO, SAS/ACCESS, MS EXCEL, Stored Process
3i InfoTech - November 2010 to May 2012.
ICICI Bank- New York, NY, USA
SAS Analyst
Description:
ICICI Bank provides loans. This report contains two kinds of reports one is for home loans (HL) and other for commercial loans both the reports contains net credit loss (NCL) and nonperforming assets (NPA) for the previous two months and current month. This report also contains closure values and expected closure values for the gross book and net book.
Responsibilities:
Creating job using DI STUDIO for extraction of data and joins.
Using Transformations FILEREADER & FILE WRITER, SQL JOIN, LOADER.
involved in extracting the data from server and importing the text and csv files
Bifurcating the data into categories according to the requirement.
Mapping the data sets using sql joins.
Developed the macros for reducing the manual interaction.
Environment: DI STUDIO, EG (4.1, 4.3, 4.5), SQL, MACRO, MS EXCEL
NOA solutions - May2009 –November 2010
Pune, MH, India
SAS Analyst
Developed the sas code to extract the data from oracle, Excel and CSV files by using Proc sql and Import procedures and by using INFILE statement.
Integrating the data for all the credit cards.
Testing the data with previous months of the data in terms of count of variables,
Attributes of columns.
Validating the report for count of cards with the extraction query.
Working on various reengineer projects with objective of process improvement, new development and digitization.
Developing and Managing projects including designing, coding, implementation and maintenance using technologies such as SAS, MS Office, PROC SQL, PROC FREQ, PROC MEANS, and PROC REPORTS.
Mange reporting team including SAS Analyst, Report Developers, Data Analysts.
Conduct extensive analytical exercises; Deliver daily, monthly, quarterly, ad-hoc reports covering the global data environment.
Development, validation, enhancement and tracking of MI for risk management.
Work closely with departments to validate/confirm data for official announcements to risk management committee.
Used SAS/Macros facility to provide reusable programs to create periodic reports with minimal chance of errors.
Conduct extensive global portfolio trend overview on new businesses.
Analyze existing customer's data quality, activities, delinquency performance and loss performance.
Work with key stakeholders in the business and present solutions/output in a logical and consistent format.
Working together with Finance, Loss Mitigation, Pricing and Operations to implement various Projects, Analysis, and Reports.
Implemented project management methodology in daily work activities.
Environment: SAS 9.1, SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ACCESS, SAS/ODS, MS OFFICE
Contact this candidate