PRADEEP KUMAR REDDY BOYILLA

248-***-****

acf2xq@r.postjobfree.com

[pic]

Summary of Experience

Over 8 plus years of extensive industry experience in the analysis, design,

development of statistical data models including data extraction and

manipulation, writing macros and reporting on various projects for

financial industries using SAS and its tools.

. SAS professional with around 7 years of experience in developing

statistical methods routinely used in financial analysis.

. Around 1.5 years of experience on Hadoop, HDFS, HBASE, HIVE, IMPALA,

OOZIE, SQOOP, and Map Reduce Programming.

. Around 1 years of experience on R programming.

. Starting Working on Tableau Dash boards.

. Having fair knowledge on python scripting

. Having Expertise on SAS Admin activities like installing SAS,

maintaining users using SAS Management Console.

. Having expertise knowledge in using Teradata SQL Assistant for

Teradata, Aginity Workbench for Netezza and SQL Developer for Oracle.

. Experience in SAS/BASE, SAS/EG, SAS/SQL, SAS/MACROS, SAS/ODS,

SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/DI STUDIO

. Solid understanding and proficient use of various procedures like proc

SQL, proc report, proc freq, proc means, proc contents, proc dataset,

proc append, proc import, proc export, proc print, proc printo, proc

sort, drop, keep, retain, date manipulations, formats, in formats.

. Excellent command in writing complex routines for Data Validations,

data extraction, transformation and loading to target decision support

systems using MS Excel Macros and SAS on various environments.

. Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc

reporting and coding utilizing SAS on UNIX, Windows

. Experience in using various MS office tools for analyzing, arranging

and presenting data

. Strong experience in coding using SQL, procedures/Functions, SAS

macros.

. Experience in creating SAS programs for EDIT CHECKS and performed data

validation on raw data sets and created data set for analysis

. Experience in the different methods of extraction, transformation and

loading of data into the warehouse (ETL)

. In-depth experience in SAS DI STUDIO where creating SAS Jobs by using

various (File Reader, File writer, Extract, SQL Join, Lookup, Sort,

User written and SCD Type2 Loader etc transformations.

. Good analytical skills pertaining understanding a business domain

coupled with excellent teamwork and strong communication skills.

. Hard working, ethical and highly result oriented. Ability to quickly

grasp and apply new concepts and technologies.

Technical Skills

SAS Tools SAS/BASE,SAS/EG,

SAS/SQL,SAS/MACROS,SAS/ODS,SAS/STAT,SAS/ACCESS,

SAS/CONNECT,SAS/DI STUDIO.

Programming R, Python, SQL, PL/SQL and Unix Shell Scripting

Databases Oracle 11g, Teradata, Netezza

Environment Windows and Unix.

Education

B Tech in Electronics and Communication Engineering from JNTU Hyderabad

in 2005

Certifications

SAS Certified Base Programmer for SAS 9.

PBS Client has given best employee award for year 2009.

Experience

. Working as Senior Analyst/Developer in Dish Network LLC from March

2013 to till date.

. Worked as Sr. Software Engineer in Larsen & Toubro Infotech Ltd from

Feb 2008 to March 2013.

. Worked as SAS Programmer in IVenture Technologies, Bangalore from Dec

2005 to Jan 2008.

Professional Summary

Enterprise Analytics, Dish Network, CO March

2013 - Till Date

Senior Developer/Analyst

As a team we will be doing predictive models for different teams across

Dish and generating Fraud reports based on fuzzy logic.

Responsibilities:

. Collecting the requirements from retailer services group for Fraud

reporting.

. Generating the daily, weekly and monthly fraud reports based on fuzzy

fraud logic.

. Fuzzy logic is implemented by using SAS in built function called SPEDIS.

. Connecting to Netezza to get the activations and deactivations and Work

order data.

. Connecting to Teradata to get the demographics, accounts and neighborhood

data.

. Working to get the training and scoring data for models.

. Working to get the data for Upsell and Winback and Retention modeling.

. Requirement gathering for need base segmentation Tableau dah board

reports.

. Working on viewership data to get the list of customers who watched more

VOD to give promotions and recommendations.

. Working in R programming for address scrubbing for external vendors such

as Altitude and Trost.

. Generating daily report with the current status (AC,DV, NP etc..) for

each account.

. Worked on python script to parse xml file and put the data in Hadoop.

. Working on Hadoop to SQOOP the tables from Netezza and Sqoop.

. Using OOZIE to create the workflow with SQOOP, HIVE, shell actions.

. Using Workflow coordinator to schedule the workflow on weekly base.

. Using Impala to get the data from the HBASE tables.

Environment: SAS 9.3, SAS/EG 5.1, BASE/SAS, SAS/MACRO, SAS/SQL,

SAS/CONNECT, SAS/ACCESS, SAS/ODS, R, Hadoop HBASE, HDFS, HIVE, Impala,

SQOOP,OOZIE Oracle 11g, Netezza, Teradata Windows XP.

GCBC (Global Consumer BASEL Consolidator), Citigroup, NJ

November 2010 - March 2013

Sr. Software Engineer

Worked on the implementation of BASEL II revised framework on international

convergence of capital measurement and capital standards.

Responsibilities:

. Collection of the user requirements from the business users in the form

of business requirement document (BRD) and prepare functional

specification and technical design documents.

. Create the Folder structure and update the File monitor program in UNIX

for each file upload.

. Understand and update the existing code or create new code by using

BASE/SAS, SAS/MACROS and SAS/SQL to implement new requirements.

. Upload the File from PeopleSoft front end and check the SAS log in UNIX.

. Populate the status table in each stage and error table if any error

occurs and load the ODS and Warehouse tables if file processed

successfully.

. Working on enhancements for CLTV and Master Table load process with

Utilization band.

. Developed and supporting the CLTV and Master table load process.

. Designed and developed the Retail, Treasury and Recon portfolios file

upload functionality.

. Wrote various format and integrity edit checks on CSV files and on

staging SAS datasets.

. Develop SAS code to validate data of different portfolios.

. Modified existing SAS programs and created new programs using SAS macro

variables to improve ease and speed of modification as well as

consistency of results.

. Analyzed and implemented the code and table changes to improve

performance and enhance data quality.

. Done Code Optimization using SAS macros.

. Keeping track of any data validation issues using MQC (Mercury Quality

Center).

Environment: SAS 9.3, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT,

SAS/ACCESS, SAS/ODS, Oracle 11g, TOAD, AIX-Unix 5.3 and Windows XP.

GCBC Automation, Citigroup, NY May 2010 - October

2010

Sr. Software Engineer

Re- Engineering SAS to Ab initio to automate the File creation process.

Responsibilities:

. Understanding the BASL BRD to know the significance of each column the in

the CSV file

. Get the Production the SAS code and analyze.

. Create the understandable EXCEL template to start dad mapping for each

line of business.

. Worked on source to target data mapping of all the target fields for each

business lines.

. Extensively utilized SAS/BASE, SAS/SQL and SAS/MACRO.

. Extensively used procedures such as PROC APPEND, PROC IMPORT, PROC

MEANS, PROC SUMMARY, PROC CONTENTS and PROC SQL.

. Involved in project review meetings with respective Business SME's.

. Generate the genealogy by using EXCEL MACRO to make it better

understandable to end user.

Environment: SAS 9.1.3, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT,

SAS/ACCESS, SAS/ODS, Oracle 11g, TOAD, AIX-Unix 5.3 and Windows XP.

Statistics from Betalings Services, NETS, DENMARK

September 2009 - April 2010

Software Engineer

The customers for this solution are creditors, banks, internal supporters

and sales representatives/account managers. The purpose is to make data in

Betalings Service available and accessible to customers for statistics and

data extracts. The solution provides the same data as available in existing

BS supplemented with few transforms and additional features requested by

the customers.

Responsibilities:

. Analyzes the business requirements.

. Creates Conceptual and Logical data modeling.

. Creates the Physical data modeling.

. Creates technical specification document including the ETL process flow.

. Creates the SAS jobs using DI Studio to process the source files and to

load the SAS SPD tables.

. Creates the SAS jobs to migrate the data from SAS SPD tables into SAS

tables.

. Creates and revises the common macros.

. Creates and executes the test cases as part of unit, integration, system

and performance testing.

. Consolidates the defects identified while reviewing and testing and

analyzing the same to prevent them.

. Creates the miscellaneous docs like developer guidelines, trouble

shooting guide, optimizing process flows, parallel processing, SAS defect

prevention and code review checklists etc.

Environment: SAS DI Studio 3.4, SAS 9.1.3, BASE/SAS, SAS/MACRO, SAS/SQL,

SAS/CONNECT, SAS/ODS,SAS/ACCESS DB2 and Windows XP.

BS Re-Engineering, NETS, DENMARK February 2008 -

August 2009

Software Engineer

PBS is a leading payment service provider in Denmark owned by major Danish

banks. It is specialized in electronic payments and card services. To meet

its ambitious plan for growth in a cost effective manner, PBS has been re-

engineering of existing payments application with a different technology

and added functionality.

Responsibilities:

. Analyzed the functional requirement document.

. Analyzed the impact of the new change requests and estimates the effort

for the same.

. Involved in creation of Logical data modeling.

. Created the Physical data modeling.

. Created technical specification document.

. Created the SAS jobs using DI Studio to process the source files and to

load the DB2 tables.

. Created the SAS jobs using DI Studio to fetch the data from DB2 tables

and to generate the out files.

. Used various transformations like File Reader, File writer, Extract, SQL

Join, Lookup, Sort, User written and SCD Type2 Loader in SAS jobs to

perform ETL operation.

. Created and executes the test cases as part of unit, integration, system

and performance testing.

. Consolidated the defects identified while reviewing and testing and

analyzed the same to prevent them.

. Created the miscellaneous docs like developer guidelines, trouble

shooting guide, optimizing process flows, parallel processing, SAS defect

prevention and code review checklists etc.

Environment: SAS DI Studio 3.4, SAS 9.1.3, Base/SAS, SAS/MACRO, SAS/SQL,

SAS/CONNECT, SAS/ODS, PROC FREQ, Proc MEANS, DB2 and Windows XP.

Bank Credit Analysis, Commerce Bank, INDIA May

2006 - January 2008

SAS Programmer

The objective is to develop a credit risk rule that can be used to

determine. If a new applicant is under a good credit risk or a bad credit

risk or average risk by using no of explanatory variables of historical

data Essentially developing a function of several variables that allows us

to classify a new applicant into one of 3 categories good, bad or average

Classification procedure by using logistic Regression.

Responsibilities:

. Reading data from different sources like .csv, excel, tab delimited

files.

. Perform various business checks on the source data to confirm whether

data is correct or not.

. Compare the source data with historical data to get some statistical

analysis.

. Perform transformations like Merge, Sort and Update etc.. to get the data

in required format.

. Generate Reports in user required format by using ODS and PROC Report.

. SAS data sets are validated using SAS procedures like Proc Means, Proc

Frequency and Proc Univariate.

. Performed data integrity checks and data cleaning using SAS MACROS and

data steps, created HTML outputs with table of contents using ODS HTML.

Environment: SAS 8, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ODS, SQL

Server 2000 and Windows XP.

Contact this candidate