SUMMARY:

• SAS Professional with 15 years of experience in application development and analysis in the areas of Banking & Financial Services Industry (Consumer Mortgage Lending and Retail Cards)
• Extensive experience in systems building in all platforms with SAS (IBM, WINDOWS, UNIX)
• Hands on programming in IBM mainframe technologies (COBOL II, JCL, SQL, VSASM, DB2, IMSDB, CICS)
• Experience working with large volumes of data in the financial services industry
• Data mapping to identify source for critical data elements
• Data extraction from raw data files of various sources using DATA STEP, PROC IMPORT, PROC SQL
• Data manipulation with SET, MERGE, PROC APPEND, PROC SQL and other SAS functions
• Data reconciliation, validation, cleaning and audit using PROC COMPARE, PROC FORMAT, PROC FREQ, PROC PRINT, PROC MEANS, PROC SUMMARY, PROC TRANSPOSE, DATA STEP and PROC SQL
• Report and graph generation by employing DATA NULL, PROC PRINT, PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC ODS
• Improve efficiency and boost performance with SAS MACRO, INDEX and HASH OBJECTS
• Migrate SAS datasets from Mainframe to Unix and vice versa using CPORT/CIMPORT
• Familiar with Base SAS, SAS Macros, SAS/ETL, SAS Enterprise Guide
• Excellent written and verbal communication skills: Experienced in creating business requirements, technical design specification, functional specification, mapping documents and collaborate across teams to deliver complex systems and components.
• Excellent organization and time management skills: manage time effectively by planning tasks and activities ahead of time to ensure timely delivery of results
• Experience with database manipulation (ETL) and SQL Programming and Reporting
• Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, Business Analysts.
• Strong Problem Analysis & Resolution skills and ability to work in Multi - Platform Environments like Windows and UNIX
• Highly responsible and goal-oriented
• Highly skilled in Code evaluation and Optimization
• Demonstrated leadership skills while managing an offshore team of 20
• Strong ability to multitask and work effective with little supervision ability to coordinate onsite and offsite resources deliverables activities

TECHNICAL SKILLS:

Domain: Banking, Consumer and Mortgage Lending (CML)

SAS Tools: Base SAS, SAS Macros, SAS/SQL, SAS ODS, SAS Enterprise Guide (EG), SAS Studio

Programming Languages: SQL, SAS, COBOL II, C, JCL, UNIX

Database: SQL Server, DB2, IMSDB

Platforms: Windows, MVS, Z/OS, UNIX

Other: Changeman, Xpeditor, File Aid, Endevor, Intertest, SDF-II, CA7, SYNCSORT, IDCAMS, DB2 tools SPUFI, QMF, Platinum, DB2 File Aid, VSAM, REXX, CICS, Snowflake Data Warehouse Essentials

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SAS Programmer

Responsibilities:

• Attend remediation team meetings with the business and understand the remediation projects of retail cards area.
• Extract data from database using SAS/SQL procedures and create SAS data sets for research activities.
• Analyze and identify the accounts that needs to be remediated.
• Perform compounding and calculate Harm amount for the identified accounts.
• Developing SAS advanced codes to create data for the regulatory reporting.
• Create letters for the refunds and send to Epiq/R5 servers.
• Responsible for tracking the problem accounts and perform Harm/Loss analysis using SAS and Excel.
• Responsible for posting monetary and non-monetary transactions.
• Create validation reports for the posted monetary and non-monetary transactions.
• Conduct thorough analysis on historical data to generate seasonality of demand index profiles.
• Generate ODS output using SAS/ODS in CSV and PDF.
• Create reports using PROC Means, PROC Report, PROC Tabulate, and ODS.
• Perform in-depth quantitative data analysis.
• Code SAS programs using Base SAS and SAS/Macros.
• Regular interaction with the Business analysts for the presentation.

Confidential

Sr. SAS Programmer/Analyst

Responsibilities:

• Attend Business requirement gathering meetings, Data requirement / Data provisioning workshops for HSBC Consumer Mortgage Lending Data Warehouse applications.
• Responsible for creating design and functional specification documents.
• Perform Data Mapping exercise to identify source for the critical data elements identified.
• Perform Data analysis, Data Reconciliation, Data Profiling to create statistics for the fields.
• Engaging with business and source system SME’s to capture/understand the source application data structure.
• Ensure and enhance Data Integrity by monitoring and upgrading system process controls.
• Involve in development of the end-end ETL (Extract Transform Load) process for the projects and provide expert solution, architectural guidance and create initial drafts of deliverables.
• Collaborate with business users, managers and stakeholders to provide on-going process re-engineering and optimization using SAS Macro language.
• Co-ordinate development efforts between the onsite and offshore teams.
• Conference daily calls with the offshore team in India to update status of each deliverable and discuss any issues faced by the offshore team.
• Review work products delivered by offshore and ensure adherence to Capgemini quality processes.
• Track deliverables and report the status of the same to the Onsite Manager.
• Involve in System Integration Testing / User Acceptance Testing support/ Production support.
• Executed and implemented many applications from scratch by leading an offshore team of 20 members.
• Migrated all the Data and applications of Mortgage Lending Data Warehouse as part of Consumer Mortgage Lending Business shutdown activities.

Confidential

Tech lead/SAS Programmer/Analyst

Responsibilities:

• Attend Project requirement meetings, understand requirements and prepare detailed design documents with pseudo codes for the development of new CML Data Warehouses and maintenance requests.
• Estimate and perform feasibility analysis on every Development Project, Service Request (PCR) & Enhancement and accordingly negotiate and prioritize client requests discussing with onsite team.
• Perform Data mapping exercise to identify source for the required data elements.
• Involve in design and development of the end-end ETL (Extract Transform Load) process for the projects and provide expert solution, architectural guidance and create initial drafts of deliverables.
• Co-ordinate development efforts and lead offshore team.
• Review work products delivered by offshore and ensure adherence to Capgemini quality processes.
• Evaluate the code for performance standards, understand key code metrics, take design decisions and optimize the code.
• Involve in System Integration Testing / User Acceptance Testing support/ Production support.
• Deliver the Tasks to the Clients and close them in Capgemini Tracking tools Clarity and Service Request Management System.
• Captured all the defects and entered in Capgemini Clarity. Root Cause Analysis (RCA) & Causal Analysis and Resolution (CAR) done for UAT & Post Delivery defects.
• Deliver Project Status Report on weekly, Monthly to the Onsite Mangers and Client Managers.
• Provide Project Induction to the new joiners and mentoring the new joiners.
• Facilitate Conference calls between Onshore and Offshore Consultants to make the Knowledge Transition very smooth at both the ends (kick-Off meetings, Walkthroughs, KT, Weekly Project Status meetings and Production Support turnover meetings).

Confidential

SAS Programmer/Analyst

Responsibilities:

• Analyzed business requirements to design SAS programs and build data warehouses.
• Developed various modular programs to extract, transform and load data using SAS macro programming
• Compared and validated the output data sets using PROC COMPARE, PROC REPORT, PROC TBAULATE for unit testing
• Involved in code reviews, Integration and User Acceptance testing
• Code evaluation and optimization.
• Monitored production jobs.
• Analyzed & resolved the production defects/issues.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Analyzed business requirements documents.
• Developed various modular programs to extract, transform and load data using SAS macro programming
• Compared and validated the output data sets using PROC COMPARE, PROC REPORT, PROC TBAULATE for unit testing
• Involved in code reviews, Integration and User Acceptance testing
• Monitored production jobs.
• Analyzed & resolved the production defects/issues.
• Attended technical and functional trainings.