VINODKUMAR K RAMACHANDRAN

*****,****** ******* ******, *** no:2, Tampa, Florida-33613

+1-813-***-**** ac0h82@r.postjobfree.com

SAS programmer analyst with 3 years of experience in different versions of SAS and SAS related applications Finance, Banking, Retail and Marketing domains. Extensive knowledge in the extraction of financial, marketing data, performing statistical analysis and production of exemplary reports with tables, graphs and listing for decision making. Experience includes a clear understanding of all phases of SDLC and working with users to gather business and technical requirements.

EMPLOYMENT SUMMARY:

SAS Programmer Analyst

ING Vysya Bank Ltd Bangalore, India(2013-2015)

Extensive experience in SAS programming and data analysis using BASE SAS software in WINDOWS environment.

Responsible for advance analysis of non-commercial customer’s enrollment data, product data,banking data, credit card transactions data, and demographic data to identify the potential risks and create a detailed list reports.

Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis.

Developed application for measuring financial performance of newly acquired accounts: Forecast vs Actual and developed SAS programs for generating reports on Key financials, Income Statements, and Balance Sheet.

Identifying user requirements, functional specifications and business rules to design, develop and implement effective Data Warehouse for analysis and reporting purpose.

Performed Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process.

Developed advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis. Experience in performing Ad Hoc Queries on large datasets (Billions records) for various application and daily reports using complex SQL Queries.

Strong working experience in environments like SAS/BASE,SAS/MACROS,SAS/GRAPH,SAS/ETS,SAS/ACCESS,SAS/CONNECT,SAS/QC,SAS Enterprise Guide and with different databases like Oracle, MS SQL Server 2000/2005, IBM Cognos,MS Access,Teradata,Flat files and Excel spreadsheets.

Proficient in Microsoft Office Packages, MS Project,MS Visio.

Created reports using SAS/ODS and SAS /Views from oracle database tables into different formats like HTML, RTF, PDF and Excel and also created reports through SAS BI Tools (SAS OLAP Cube Studio, SAS Web Report Studio, SAS Information Delivery Portal,SAS add-in for Excel,Dashboards,JMP).

Generated Tableau Dashboard with quick/context/global filters, interactive views, trends,parameters and calculated fields on Tableau (7.x / 8.x) reports.

Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2008 Reports Services (SSRS) and SSIS.

Extensively used SAS/MACRO for creating macro variables and macro programs to modify existing SAS program for ease of modification while maintaining consistency of results.Used various MACRO debug options such as MPRINT, SYMBOLGEN, MLOGIC, MFILE to Debug stored process and SAS codes.

Experience includes a clear understanding of all phases of SDLC and working with users to gather business and technical requirements.

ACADEMIC CHRONICLE:

Master of Science in Engineering / Industrial Management.

University of South Florida Tampa, FL,U.S.A-2016

Field of study includes: Data Analytics, Business Analytics, Lean Six Sigma, Total Quality Management, Operations Research, Project Management, and Corporate Finance.

Post Graduate Diploma in Financial Management.

Manipal University Bangalore, India-2015

Bachelors of Engineering in Electronics& Communications Engineering.

Anna University Chennai, India- 2009-13

CERTIFICATIONS:

Foundation of Data Analytics Using R programming –University Of Texas, Austin (EdX.org)

Data Analytics Using MySQL – Duke University (Coursera.org)

Strategic Business/Marketing Analytics Using MySQL,R – ESSEC Business School(Coursera.org)

Mastering Data Analysis in MS Excel – Duke University(Coursera.org)

Data Visualisation and Communication with TABLEAU - Duke University(Coursera.org).

Contact this candidate