LEELADHAR

Email: ac2esl@r.postjobfree.com

Phone: 516-***-****

SUMMARY:

Data analyst with over 8 years of Experience in Data management, data extraction, manipulation, validation, and analyzing huge volume of data.

Excellent knowledge in SAS programming, merging, producing reports, SAS Formats, SAS Functions, SAS Informats and storing data in SAS files.

Advanced SAS programming and SAS procedures experience such as PROC SQL, PROC DATASETS, PROC FORMAT, PROC PRINT, PROC APPEND, PROC TABULATE, PROC COMPARE, PROC CONTENTS, PROC IMPORT, PROC EXPORT, PROC SORT, PROC TRANSPOSE, PROC FREQ, PROC SUMMARY, PROC UNIVARIATE and PROC CORR.

Experience on SAS/CONNECT to submit SAS programs on Remote servers.

Thorough in doing edit checks, validation of Analysis datasets, Tables, Listings and graphs.

Developing system documents like Functional Specifications, Technical Specifications, and User Manuals etc.

Extensive experience in preparation of reports.

Experience in UNIX. Worked with batch files and ran SAS programs using UNIX shell scripts.

working with Enterprise Guide 7 & 7.1 and Microsoft Add-In.

Have strong experience in working with SAS Visual Analytics reporting solutions.

Familiar with Clustering, Classification, and Other Data Exploration Tools.

Good at understanding the client data, and business requirements.

Experience in Developing and executing campaigns using campaign management tool.

Exposure to python for data analysis.

experience with Teradata version for ETL, analysis and reporting.

Preparing solutions and reports for client’s business problem.

Ability to work independently with minimal guidance.

Able to play a key role in analyzing problems and come up with creative solutions as well as producing methodologies and files for effective data management.

Possess fundamental understanding in finance, accounting, marketing, production, Retailing and personnel management.

In-depth knowledge of wide range of Insurance and Banking domains with proven skills in transforming business requirements into technical specifications.

Worked with clients HSBC, Western bank, U.S. BANK.

RELATED EXPERIENCE

Project Name

Marketing Campaign

Client Name

U.S. BANK, St’ Louis, MO Through Capgemini

Role

Data analyst

Duration

April 2015 – Till now

Project Objective:

I worked with Capgemini as a campaign marketing analyst. My role as a data analyst Is to assist in the design, development, and execution of marketing campaigns and customer selections. Produced campaign results and created various financial reports.

Responsibilities:

Pulled large amount of data from multiple data sets using proc import, libname and infile statements.

Maintained warehouse data sets to support marketing analytics.

Developed SAS programs using Enterprise Guide to create customer mailing list for Direct Mailing Campaigns.

Increased email marketing effectiveness by implementing campaign management tool.

developed and executed SAS code to define customer populations to be targeted in marketing campaigns.

Performed customer intelligence analyses, identified & assessed emerging analytics, research trends and solutions.

Audited campaign populations to ensure marketing requirements were met.

Extensively used SAS reporting procedures such as PROC RERORT, PROC TABULATE, PROC FREQ and PROC SUMMARY to analyze campaign effectiveness and wrote monthly summary on campaign performance.

Developed and managed all SAS programming functions (including but not limited to: SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS) related to marketing list work.

Responsible for creating and maintaining reports utilizing SAS Visual Analytics

Generated graphs using SAS Report and SAS /GRAPH and reports using SAS/ODS.

Advanced use of Microsoft Excel / Access to create pivot tables and charts as part of data manipulation and marketing analysis.

Developed scripts for pre-campaign and post-campaign comparison analysis.

Communicate with business contacts as necessary to help explain results.

Environment: Base SAS v9, VI Editor, UNIX, SAS Enterprise Guide, Visual Analytics, CI, Teradata, SAS/MACRO, SAS/GRAPH, SAS/STAT, campaign management tool, MS Excel.

Project Name

Performance Analysis

Client Name

HSBC, Atlanta, GA through Accenture

Role

Data Analyst

Duration

Sep 2013 – Feb 2015

Project Objective:

Accenture providing IT solutions to support and develop IT solutions to Auto Owners Insurance Company. As a data analyst I was mainly responsible to create different types of reports. I created reports on daily, weekly and monthly basis to the right customers on the right time. I was responsible for creating reports on the data which is available in different sources like ORACLE, DB2, Mainframes Flat files, EXCEL, and Text Files.

Responsibilities:

Extraction of data by using Proc Dbload, Proc SQL, Proc import from and to DB2 and Oracle 9i.

Created SAS data sets by accessing remote clients by SAS CONNECT and SAS ACCESS.

Manipulated, cleaned, integrated and processed data using SQL, MS Excel & SAS Code on AIX UNIX according to the specifications.

Created Information MAPS using the Information Map Studio for Analytics and Business Forecasting Team for creating the Time Series Forecasting Models and also written SAS Stored Processes to Create Efficient Reports and delivering it in the Web Portals using the Information Delivery Portal and SAS Management Console.

Liaising with end-users and on-site coordinator in gathering the requirements.

Carried out specified data processing and basic statistical techniques using SAS PROCS.

Loaded the data into databases like Oracle/DB2/XLS using SAS/Access.

Involved in writing macros for automation and Unit Testing

Prepared solutions and reports for client’s business problems.

Created various weekly, Monthly and Quarterly Reports in PC-SAS.

Worked with batch files and ran SAS programs using UNIX shell scripts.

Involved in teleconferences and meetings with the customers, managers and Implemented data management plans designed to meet project deadlines.

Environment: SAS 9.1 (SAS/Access, SAS/Connect, SAS/Stat, SAS Enterprise Guide, SAS/Graph, SAS/SQL, SAS/ODS), Automation, UNIX, Oracle 9i, DB2, MS Excel.

Project Name

Mortgage Loan Analysis

Client Name

Western Bank, Pune, India through Accenture

Role

Data Analyst

Duration

Feb 2010 – Aug 2013

Project Objective:

Accenture is a global professional services company which provides IT services to Bank and my role as a data analyst was responsible for developing and maintaining Loan Management System, which mainly deals with Mortgage Loans. Under this project I analyzed historical payment data of our customers and developed reports about their payments behavior in the recent years.

Responsibilities:

Pulled loan-level data from multiple internal and external sources using SAS and SQL procedures.

Coding SAS programs with the use of BASE SAS and SAS/MACROS for ad hoc jobs.

Created, managed and optimized tables, views and queries in a Teradata environment using Teradata and UNIX.

Used PROC MEANS, PROC FREQ, PROC UNIVARIATE and PROC CORR to generate all kinds of descriptive statistical measurements.

Performed data analysis activities such as customer data profiling, data cleansing and data exploration to identify trends, patterns and anomalies using python.

Cleaned & Structured the data using different Functions, Format, Informat, Merging, Sorting Techniques depending on different attributes of reporting like number of newly opened accounts, closed accounts Mortgage loans, late fee for a particular period.

Loaded the valid datasets into PC files using PROC EXPORT.

generated ad-hoc reports and tables according to project requirement and reviewed by Loan Department Managers.

Created & analyzed Business Requirements Documents (BRD) and prepared Functional Requirement Documents (FRD) and Technical Documents.

Used SAS system macros for error handling, code validation and collected files to a given directory and scheduling.

SAS programs extensively used in UNIX.

Environment: Base SAS, Teradata, UNIX, Unix Shell Scripts, DB2 Teradata, SAS/QC, Business Objects, MS Office, Microsoft Office Suite (Excel, Access, Power Point),ORACLE, Python,Windows XP.

Project Name

Biomed CML

Client Name

Medwin Hospitals, Hyderabad, India

Role

Data Analyst

Duration

Jun 2008 – Jan 2010.

Project Objective:

Biomed Informatics Medwin Hospitals was set up as a premier research Centre with the objective to offer services in the field of Pharmacovigilance, Clinical Research, Clinical Data Management (CDM), SAS Clinical, Oracle Argus Safety Database, Oracle Clinical OC/RDC, Regulatory Affairs and Healthcare since the year of 2000. Biomed has been developing new therapeutics for the Chronic myelogenous leukemia (CML) is characterized by the Philadelphia (Ph) chromosome and BCR/ABL gene rearrangement which express the c-kit receptor tyrosine kinase (KIT), which is responsible for cancer. Therefore, appropriate control of their synthesis is required to assure the complex orchestration of cellular processes within multicellular organisms. For this Biomed Informatics Medwin Hospitals has developed a molecularly targeted drug that inhibit the action of pathogenic tyrosine kinase. I was involved in Phase II and Phase III studies that assess the clinical efficacy of Study.

Responsibilities:

Received different SAS transport files from Data managers. Used SAS program to convert SAS transport file to current platform.

Proc SQL, Proc Import was used to retrieve data from databases like Oracle, and Excel.

Developed SAS programs to generate baseline, follow-up, drug safety reports from Oracle data base

To ensure Data Quality & Integrity, programmed EDIT CHECKS(such as DOB between specified range, match AGE with DOB) and validation of Analysis datasets as specified in the Data Validation Manual (DVM), and generated Error Reports & Alert Messages, including error messages for missing data.

Generated the required SAS datasets from large database using Sorting and Merging techniques.

Used procedures proc means, univariate and freq to identify outliers & used options like noduprec, nodupkey to delete duplicate records within the datasets.

Existing SAS Macros were used to generate text files and data results on a weekly schedule.

Used FILENAME, fileref in a SAS procedure to output analysis (Number of records, Patients, Visits, etc.) of text file to another file.

Produced ad hoc reports and created reports in the style format using ODS statements. The generated reports were reviewed by the statisticians and sent to FDA.

Environment: SAS8, SAS/BASE, SAS/MACROS, SAS/SQL, Oracle8, Windows NT/ 2000, HTML.

Contact this candidate