PROFESSIONAL SUMMARY:

• More than 8 years of experience in Data Analytics, Data Analysis, Business Intelligence, Analytical Reporting with expertise in SAS, MS SQL and Tableau in Banking, Financial Services and Insurance
• Experience in Data Validation, Data Modeling, Data Profiling, Data Quality, Data Integration, Data visual analytics and Data Verification
• Expertise in analysis and reporting using SAS/BASE, SAS STAT, SAS/MACRO, SAS/REPORTS, SAS/GRAPHS, SAS/ACCESS, SAS/CONNECT, SAS/SQL, DI Studio etc.
• Experience working in SAS Business Intelligence (BI) platform with Enterprise Guide, Stored Process, Information Map Studio, Microsoft Add - In, Data Integration Studio and Web Report Studio
• Experience in SAS/ACCESS, SQL Pass-Through facility, LIBNAME, INFILE, Proc IMPORT/ EXPORT & SAS IMPORT/EXPORT Wizard, SAS Enterprise guide for importing and exporting RDBMS- Non- RDBMS, risk data management.
• Extensively worked on data validation, data cleansing, and statistical analysis using SAS Procedures such as PROC UNIVARIATE, PROC MEANS, PROC SUMMART, PROC FREQ, PROC SORT, PROC CORR and SAS Data step statements such as KEEP, RENAME, FIRST OBS, OBS, FIRST., LAST., PUT, FORMAT etc.
• Experience in producing ASCII text, HTML, RTF, PDF formatted reports using ODS Statement.
• Expertise in generating report using SAS Functions and SAS procedures like, PROC REPORT, PROC TABULATE, PROC TRANSPOSE, PROC SUMMARY, PROC FREQ and customized report using extensive use of DATA NULL
• Extensively worked on SAS Macros to automate Business as Usual (BAUs) reporting
• Experience in SAS Data Integration Studio
• Experience and expertise of Banking, Financial Services and Insurance (BFSI) products such as Home & Auto Insurance and Credit Cards.
• Experience in Credit Loss Forecasting, and Credit Database Management and extensive knowledge in Logical and Conceptual Modeling
• Proficient in MS Office Suite (Word, Excel, Power Point etc.)
• Expertise in project management, business consulting, global stakeholder management, business process development and process optimization
• Good understanding of statistical concepts like Linear and Logistic regression, time series, Factor/ Cluster analysis, Hypothesis testing, Segmentation, Sampling etc.
• Extensive experience in requirement analysis, design, application development, programming, testing, implementation, and coordination with senior management
• Involved in implementing test plans, documentation, validation and execution processes
• Experience of team handling; demonstrated ability to perform successfully within team environment. Excellent in Analytical and Problem Solving Skills
• An excellent problem-solver, able to quickly grasp complex systems and identify opportunities for improvements and resolution of critical issues
• Possess excellent interpersonal, communication and analytical skills with demonstrated abilities in stakeholder relationship management

TECHNICAL SKILLS:

Operating systems: Win95/98/XP/2000/NT, MVS, Z/OS

Analytical/BI Tools: SAS (Base SAS, Enterprise Guide, SAS/MACRO, SAS/ACCESS, SAS/STAT, SAS/GRAPHS, SAS/ODS, SAS/SQL, SAS/REPORT, SAS/CONNECT, DI Studio etc.), Tableau, Informatica

Languages: MS SQL Server 2003/05/08, DB2

Databases: SQL Oracle

Application Software: MS Word, Excel, MS PowerPoint

Servers: Mainframe, Unix

PROFESSIONAL WORK EXPERIENCE:

Confidential, New York, NY

Sr. Data / BI Analyst

Responsibilities:

• Analyzing Confidential Commercial Banking portfolio data and generating analytical reports using SAS, MS SQL and Tableau
• Gathering business requirement from the clients which includes different level of portfolios, required KPIs for different portfolio and designing reporting framework to include key risk parameters such as LICs, write-offs, recoveries and provisions which gives good understanding of portfolio risk
• Extracting data from different sources like Confidential "CARM" system where information is stored in Oracle tables, Excel, Access, and text/CSV files using SAS/ACCESS, SAS/SQL in SAS environment and creating SAS files
• Develop ETL code using SAS DI Studio to create SAS tables and views..
• Register Oracle tables and views using SAS Management Console and SAS DI Studio jobs.
• Migrate SAS Enterprise Guide code and SAS DI Studio code between DEV, UAT and Production
• Using SAS PROC SQL pass through facility to connect to Oracle tables
• Performing data validation, data cleansing, and transposing data using different procedures (PROC MEANS, PROC FREQ, PROC SORT etc.) and statements (KEEP, RENAME, OBS, FIRST., PUT, FORMAT etc.)
• Merging SAS datasets using various SQL joins such as LEFT JOIN, RIGHT JOIN, INNER JOIN and FULL JOIN as well as using SAS procedures such as SET, MERGE, PROC APPEND etc.
• Performing advanced analytics and analyzing data using different SAS and SQL procedures such as PROC UNIVARIATE, PROC SUMMARY, PROC FREQ, PROC CORR, PROC RANK etc.
• Creating analytical reports (periodic and ad-hoc) for different credit card portfolios reports using PROC REPORT, PROC TABULATE, PROC SUMMARY, ODS statements and generating outputs in HTML, Excel and RTF formats
• Importing all Reports from Web Report Studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal
• Developing SAS Macro programs and using macro functions (%LET, CALL SYMPUT, %NRSTR, SYMGET etc.) to automate business as usual (BAUs) reporting process to improve process efficiency and provide more meaningful information vital to the overall strategies
• Created dynamic Macro arrays by SQL and with SAS data step programs
• Extensive usage of MS office and the functionality of excel such as lookups, macros, statements etc.
• Performed approvals for peer audit reviews on reports by analyzing data

Environment: SAS (Base, Macro, Stat, Access, Data Integration - DI Studio), MS SQL Server 2003/05/08, MS Word/ Excel, Oracle

Confidential, New York, NY

Sr. Data / Risk Analyst

Responsibilities:

• Develop and monitor roll rate based loss forecasting models using time series techniques for different credit card portfolios across Confidential Bank, USA
• Extracting data from different sources like Oracle database, Excel, Access, and text/CSV files using SAS/Access, SAS/SQL in SAS environment and creating SAS files
• Performing data quality checks, data cleansing, data reconciliation with different teams at different levels using Proc Means, Proc Freq, Proc Sort, Keep, Rename, etc.
• Develop credit loss forecasting models to forecast key KPIs in risk management such as provisions, LICs, charge-offs etc.
• Working on model documentation for senior management and regulators
• Coordinate with different stakeholders and presenting estimates at regular intervals
• Develop analytical reports using Proc Report, Proc Tabulate, ODS statement and present detailed view of different portfolios at different levels to senior management for key decision making
• Performing advanced analytics and analyzing data using different SAS and SQL procedures such as Proc Univariate, Proc Summary, Proc Freq, Proc Corr, Proc Rank, Proc Transpose etc.
• Write SQL queries in order to get the data from Data Base.
• Develop SAS Macro programs to automate different modeling and reporting processes to improve process efficiency and provide more meaningful information vital to the overall strategies
• Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting
• Performed documentation, UAT for the project.
• Performed analyses, development and evaluation of data/reports in a data warehouse/enterprise environment which includes data requirements

Environment: SAS (Base, Macro, Stat, Access etc), MS SQL Server 2008, Informatica, Oracle, MS Word, Excel

Confidential

Data/BI Analyst

Responsibilities:

• Create daily, weekly and monthly ACV data mart to derive NII, NFI, credit card sales, outstanding balance, defaults etc
• Involved in Data Mapping efforts with detailed understanding of the database structure
• Extract data from Oracle database using SAS/Access, SAS/SQL in SAS environment and create SAS files
• Designed several ETL jobs using SAS DI Studio to port the ODS data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging the final data
• Perform data validation, cleansing and reconciliation with historical patterns and other teams
• Develop analytical reports using Proc Report, Proc Summary, SQL procedures and present detailed view of different portfolios at different levels to senior management for key decision making
• Develop SAS Macro programs to automate different modeling and reporting processes to improve process efficiency and provide more meaningful information vital to the overall strategies
• Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting
• Coordinate with different stakeholders and presenting estimates at regular intervals
• Optimized the monthly Debits Card transactions data mart by implementing new logics and reduced turnaround time by 8 hrs
• Created dynamic Macro arrays by SQL and with SAS data step programs
• Actively involved in different kind of SQL queries for matching of the data.

Environment: SAS (Base, Macro, Stat, Access, DI Studio etc), PL/SQL, SQL Server 2003, Mainframe, Oracle

Confidential

Application Developer

Responsibilities:

• Analyzed functional domain and gathered business requirements from client
• Created software requirement specifications in collaboration with business analysts
• Working on Application development & Programming
• Preparing detailed design documentation & test cases
• Reviewing code written by junior team members

Environment: SAS, Mainframe COBOL, JCL, IMS DB, DB2, FILE AID, COOL: GEN.

Confidential

Application Developer

Responsibilities:

• Analyzed the specifications provided by client
• Created software requirement specifications in collaboration with business analysts
• Prepared detail design document
• Worked on Application development & Programming & Testing

Environment: SAS, MS SQL, Mainframe COBOL, JCL, IMS DB, DB2, FILE AID, COOL: GEN