SUMMARY

• 4 years of Data Analysis experience and reporting on Financial data
• 4 years of experience in SAS Programming and reporting
• 5+ years of SQL experience with Joins, subqueries, stored procedures, views and aggregation
• Data Modelling experience on SAP HANA in two full project implementation’s
• Worked on SAS - QRM, Asset Liability Management process involving bank balance sheet data
• Experience in Agile and Waterfall Software development life cycle
• Experience translating business needs into Business Requirements and documentation
• Worked on Data Analysis/Data Mapping on more than 20 source systems data for Liquidity Risk Management and 2052A Projects
• Worked on large data sets, extracting data, analyzing and presenting teh reports to higher management
• Extensively worked on RDBMS such as Oracle 10g, DB2, Netezza and MySQL Server. Used TOAD or similar database interface tools for Querying & Analyzing data
• Familiar with excel Formula’s, VB macro’s, Pivot tables and Vlookup’s
• More than 1.5 years of experience with Data Mining and Predictive Modeling related projects
• Hands on experience with Hypothesis testing, T tests, ANOVA and Statistical Experimental designs
• 1.5 years of Data Analysis and Agile project experience at Tata Consultancy Services., India
• Ability to communicate well among teams and always loves to work with multiple teams

PROFESSIONAL EXPERIENCE

Senior Data Analyst

Confidential

Responsibilities:

• Data modeling (Creating Analytical/Calculation views) on SAP HANA for 2052A.
• Developed SAS code for reconciling teh data for 2052A to GL data..
• Using SAS calculated cash flow forecasting for Loans and securities.
• Worked on different banking products available at Confidential &T, this includes LOANS, DEPOSITS, SECURITIES, REPO’S, DERIVATIVES and COMMITMENTS.
• Involved in data mapping from Source to Target for teh purpose of Liquidity Risk Management reporting.
• Modelled views on SAP HANA for LRM reporting.
• Developed SAS code for teh collateralization of Public Funds deposits with Securities.
• Performed data profiling using SAS and SQL and executed a systematic data quality analysis according to teh business requirements.
• Performed data analysis using SAS/SQL and SAP HANA for LRM.
• Worked on System Integration testing for LRM data, helped teh end user with User Acceptance testing teh LRM application and tracked teh project testing and defect tracking on HP-ALM application.
• Written SQL queries and executed on TOAD tool to pull data from DB2 database.
• Validate teh feasibility of business requirements with existing data, reaching out to source systems to acquire new data according to business needs for LRM.

Funds Management Data Manager

Confidential

Responsibilities:

• Use SAS Programming to pull monthly raw data extracts from different source systems and applying transforming logic and filters according to QRM business needs.
• Creating permanent SAS datasets for all teh data and tan push teh data in to QRM application for Asset and Liability management process.
• Used SAS programming for preparing reports on data for audit, CCAR and regulatory purposes.
• Worked on Derivative’s products like, SWAPS, SWOPTIONS and FUTURES.
• Prepared Amortization Schedule for teh Interest Rate SWAPS and Currency SWAPS later this data was used on polypath’s for modelling purposes.
• Worked on Payment Advice reporting, which sends out teh payment information to clients.
• Extracting source data and automated teh process with coordination of IT team to run teh jobs on ESP scheduler.

Confidential

SAS/SQL Programmer

Responsibilities:

• Prepared new datasets from raw data files using import techniques and modified existing datasets using SQL, Set, Merge, Sort, Update, Format functions.
• Read datasets with alot of missing values using MISSOVER and TRUNCOVER.
• Created reports in teh style format (RTF, PDF and HTML) using SAS/ODS.
• Developed custom reports using PROC Report.
• Involved in analyzing data using procedures
• Used procedures like IMPORT and EXPORT to obtain and load data from MS Excel and MS Access.
• Clinical data analysis and creation of reports by extensive use of Base SAS, SAS/Macro, SAS/SQL and SAS/Graph.
• Generated detailed and self-explanatory reports extensively using PROC REPORT.
• Production of Customary Reports and user friendly interfaces.
• Performed statistical modeling including linear and non-linear regression and PROC ANOVA.
• Performed exploratory statistical data analysis using various statistical procedures like PROC FREQ, PROC MEANS, PROC SUMMARY and PROC UNIVARIATE.
• Created datasets and generated reports using PROC TABULATE, PROC REPORT, SAS ARRAYS, PROC SQL and MACROS.
• Formatted HTML, Excel and PDF reports using SAS output delivery system (ODS).
• Worked with statisticians, physicians, performed ad hoc data exploration, and standardized reporting.

Confidential

Predicting profitability

Responsibilities:

• Implemented CRISP-DM Standards and cleansed teh data to come up with relevant variables that impact teh customer’s seasonality and business. Softwares used SAS Enterprise Miner and SAS Enterprise Guide.
• Built Regression, Neural network and Decision tree models to predict teh profitability of teh Seasonal customers.
• From regression and decision tree models, identified teh critical factors effecting teh profitability of teh customers.
• Analyzed teh Banking Direct Marketing campaign data to predict teh customer interest towards subscribing to term deposits by using IBM SPSS and Tableau tools.
• Built Logistic Regression and CHAID models to identify teh important variables from teh predictor importance graph.
• Increased teh efficiency of directed campaigns for Term deposit subscriptions by reducing teh number of contacts to do with teh high specificity rate for teh models built.

TECHNICAL SKILLS

Business Intelligence Tools: SAS Enterprise Guide 5.1, Enterprise Miner 12.1, IBM SPSS, Rapid Miner, Tableau, Microstrategy Reporting, JMP, SAP BW

Databases: DB2, SAP HANA, Oracle, Microsoft SQL Server 2008, Toad, MS Access, SQL and MySQl

Database Tools and Languages: Toad, SQL and MySQl

Programming Languages: Base SAS, Adv SAS, ASP.Net, PHP, C++

Software’s and Development Tools: MS Office, Visual Studio, Rally and Eclipse