We provide IT Staff Augmentation Services!

Sr. Sas Programmer Resume

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.