SUMMARY

• Result driven professional with extensive management reporting, data analytics, application management, project management experience in delivering consumer finance applications at various Confidential Group Companies (Credit card /Commercial Finance/Transportation).
• Over 13 years of experience in the financial industry as project manager, business/data analyst, technical lead, and software developer roles. Have extensively worked on SAS EBI tools, Tableau, QlikView, Crystal Reports in developing new ETL flows, building customized automated MI reports and dashboards.
• Involved in all phases of project implementation starting from requirement gathering, data analysis, model designing, data profiling, Conceptual and Logical Modeling, Construction, Security and Data testing and implementation of business - based models.
• Simultaneously managed multiple projects with shifting priorities. Strong coordination and communication skills, interaction with all stakeholders: users, management, other technology, operations and support teams.
• 13 years of professional experience in all stages of SLDC and change management systems - requirements gathering, analysis, prototype, design, develop, test, release, deploy and production support of critical business applications.
• Exposure in building critical data models and reports with excellent exposure to Credit card /Commercial Finance/Transportation.
• Fair knowledge of Credit Card Approval, Credit Scoring, Decision making, Payment Processing (ACH/SWIFT/Fedwire).
• Over 8 years of experience in MIS/KPI Reports, Senior Management Reporting by providing key reports on various business performance and reconciliation metrics within SLA.
• Good Communication and Strong interpersonal skills to deal effectively with a broad range of contacts from technical staff to clients to senior management.
• Self-motivated analytical thinker with excellent communication, interpersonal and presentation skills. Over 8 years of experience in leading team.
• Over 10 years of hands on experience in SAS BI Tools designing data models, data reconciliation, ETL workflows; PL/SQL, DB2, Oracle, Performance tuning of SQL queries
• Over 10 year of experience in developing and maintaining Autosys jobs for scheduling.
• Over 3 year of experience in designing and developing MIS reporting dashboards using Tableau.
• Working knowledge of UNIX shell scripts, Python, R.
• Handled several responsibilities like Requirement Analysis, Development, Design innovations (Providing Optimal Technical Solutions), Reviews, Client interactions, offshore team anchoring and onsite-offshore co-ordination activities, project management, project estimation

TECHNICAL SKILLS

ETL Tools: Base SAS 9.3 / 9.4, Ab-Initio

Other Tools: Tableau 10.0, Qlikview, Crytal Reporting, SAS EBI tools - SAS DI Studio, SAS OLAP, SAS Information Map Studio, SAS Web Report Studio, SAS Enterprise Miner, SAS Model Manager, SAS Studio, SAS VIYA, SAS LASR

Databases: Oracle, SPDS, Teradata

Scheduler: Autosys, LSF scheduler, Appworx

Languages/Scripting: SQL, PL/SQL, Unix shell scripting, basic knowledge of Python

Operating Environment: Unix (Solaris), Red Hat Linux, Windows servers

Domain Knowledge: Consumer Finance, Credit Card Business, Commercial Finance, Credit Scoring, Payments, Transportation.

PROFESSIONAL EXPERIENCE

Confidential

SAS BI/ Tableau Consultant

Responsibilities:

• Work with business users in gathering and analyzing business requirements. Create business requirement documents, functional specification documents, and user test cases for acceptance testing. Design, develop, automate the delivery of various Tableau visualizations, KPI metrics, and dashboards using Tableau Desktop for various stake holder MI reporting.
• Use SAS statistical packages for Qualitative and quantitative methods of data analysis. Performed regression analysis, segmentation analysis, and correlation analysis on commercial finance data using SAS. Merge and link SAS data sets, design and develop customer’s contractual summary reports using SAS procedures.
• Create SAS Macros for data analysis, data loading, data manipulation, data reconciliation, data cleansing, and data Optimization using Oracle/SQL Server PL/SQLs, data base stored procedures.
• Integrate various data sources and databases and designed/developed data models and backend queries for presenting data using Base SAS. Create SAS reporting artifacts for end business users to access and help reach to a decision using different procs like Proc summary, means, univariate, frequency, and SAS macros.
• Use data modeling concepts to build various predictive/explanatory models to help users take their decisions for business.
• Develop customized automated Tableau interactive vendor management and customer inventory reports and Dashboards using action filters, parameters, and calculated sets for dashboards and worksheets, interactive views, trends and drill downs along with user level security, and advanced charts.
• Work with business users/shareholders in developing user acceptance testing (UAT), and share various test results and data points with the users/stakeholders.
• Work with offshore team (team of 8 developers/testers/support analysts) in allocating, guiding, monitoring daily project work, and mentoring them.

Confidential

Risk Modelling - QlikView/ Project Lead - SAS

Responsibilities:

• Extensively involved in meetings with Business and analyst team to gather the requirements and understanding the business rules and confirm feasibility in SAS based on requirements provided.
• Analysis of existing SAS server and data models and automated processes in it to provide more efficient and optimized solutions.
• Developed Enterprise Models through SAS E-Miner and implemented the models which are based on FSLDM for Confidential Decision making team.
• Responsible for analyzing data reports to find system bugs, data integrity issues and process issues and creating a safe and secure environment for different business groups to secure the data among the user groups.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized reporting using QlikView for the Senior Management and Stakeholder reporting on various key performances.
• Designed and developed various automated daily reoccurring reporting using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks for the senior management team in QlikView.
• Implemented Incremental Load, Optimized load & Binary Loads for performance tuning and optimal reports.

Confidential

Lead Software Developer

Responsibilities:

• Worked as a Module Lead gathering client requirements and preparing ITRDD documents for confirmation.
• Conceptualized the design and solution implementation by developing SAS DI jobs, OLAP Cubes, SAS Infomaps, autosys jobs, end user SAS Reports.
• Reported the project status and team status in timely fashion to on-site Leadership team.
• Developed several complex Ab initio graphs associated with certain major interfaces like Account Family, Application family and ensured standardization of all graphs in shortest possible time and SAS graphs to improve performance and efficiency.
• Created business scenarios and prepared Test Cases to carry out unit testing & integration testing successfully.
• Led post-production support team.