We provide IT Staff Augmentation Services!

Sas Consultant Resume

San Antonio, TX

PROFESSIONAL PROFILE

  • Six years of experience in Java and SAS development projects( Reporting)
  • Excellent knowledge of SAS Base, SAS Macros using various SAS procedures.
  • Excellent knowledge in Program Design using SAS language
  • Worked extensively in SAS 9.0, SAS Base, SAS Macros using various SAS procedures, Core Java, J2EE (Servlets, JDBC, EJB, JMS), Web - Services, Hibernate
  • Worked on credit risk projects for a client in insurance domain
  • Excellent knowledge in requirements gathering and converting the business cases into technical specifications
  • Extensive Experience in arranging and participating in meetings with Business Users and suggesting recommendations for improving system performance
  • Excellent client facing skills, outstanding analytical skills with attention to detail and a focus on system issues.
  • Has extensive experience in Data collection, design, analysis and development of systems.
  • Has good experience in using MS Excel, MS Word, MS outlook and other Microsoft Products.
  • Used ODS to display outputs in HTML, CSV, PDF or other file formats.
  • Extensive experience in writing reusable macros
  • Worked on projects following waterfall and lean agile models
  • Excellent daily basis support to Analytics groups for all the issues related SAS Files
  • Worked extensively on NORKOM Fraud analysis and detection tool.
  • Have good deployment knowledge in RTC project management tool.

TECHNICAL PROFICIENCY
  • SAS Base SAS Macros
  • Java, PL/SQL, Web Services, NORKOM tool
  • SAS Components: SAS/SQL,SAS/Connect, SAS/Graph, SAS/Access Interface (to Oracle, DB2, MySQL, SQL Server)
  • Third-Party Software tools :
    • Scheduling and Monitoring tools: Control M
    • Version Control tool: Star team, RTC
    • Development tool: Eclipse
    • Web Application Servers: WebSphere, Tomcat
  • Operating Systems: Windows, UNIX, z/OS
  • Database Management Systems: DB2, MySQL, Oracle 10g, 11g,MS SQL
PROFESSIONAL EXPERIENCE

Job Title: SAS Consultant

Confidential, San Antonio, TX

SAS EG, Base SAS 9.2, SQL,RTC

Day-to-day Activities and Responsibilities:

  • Meeting business partners and managers to obtain functional requirements
  • Translating business requirements to technical design specifications for coding, validation and reporting purposes
  • Created a new SAS environment(Folder structure for SAS code, scripts, SAS logs) on the UNIX server
  • Managed a team of five members with their day today work
  • Periodic interaction with Manager to discuss project progress and recommendations for scope of improvement
  • Technically execute, prepare and present results to business partners
  • Identify data gaps, source system inconsistencies and develop strategy to fix them
  • Performed Program Documentation on all programs, files and variables for accurate historical record and for future reference.
  • Generated reports in HTML format using SAS/ODS.
  • Used SAS statements like DLM, DSD, and COMMA9. TRUNCOVER, MISSOVER to get rid of erroneous data.
  • Performed Data Analysis on the data sets using PROC MEAN, PROC FREQ and PROC TRANSPOSE.
  • Used SAS import and Access to import external files.
  • Responsible for merging large data sets efficiently.
  • Create and manage RTC components for source control management
  • Role is hands-on Technical Project Management and Lead.

SAS Consultant

Confidential, San Antonio, TX

SAS EG, Base SAS 9.2, Star team

Day-to-day Activities and Responsibilities:

  • Meeting business partners and managers to obtain functional requirements
  • Translating business requirements to technical design specifications for coding, validation and reporting purposes
  • Worked with model developers and the model implementation teams to develop logical data models and ensure efficient flows of information through automated business processes
  • Connected to DB2 and pulled data into SAS data sets using SQL pass through facility.
  • Performed basic SAS analysis on existing customers data, and database segmentation using PROC MEANS, FREQ
  • Developed SAS programs for querying data from large datasets using SAS Enterprise Guide
  • Used SAS Data Null and PUT statements to create customized reports for management.
  • Created complex and reusable macros.
  • Testing and debugging macros.
  • Used ODS in order to generate PDF files
  • Created SAS datasets and CSV files which are used by downstream systems
  • Integrated the downstream process with the risk model code
  • Performed Data Analysis on the data sets using PROC MEAN, PROC FREQ and PROC TRANSPOSE.
  • Involved in validation of tables, listings and datasets using procedures like PROC FREQ.
  • Periodic interaction with Manager to discuss project progress and recommendations for scope of improvement
  • Identify data gaps, source system inconsistencies and develop strategy to fix them
  • Peer review code and reports developed every month
  • Provide regular technical support for co-workers in a cross team environment

Job Title: SAS Consultant

Confidential , San Antonio, TX

SAS EG, Base SAS 9.2 ,Star team

Day-to-day Activities and Responsibilities:

  • Meeting business partners and managers to obtain functional requirements
  • Translating business requirements to technical design specifications for coding, validation and reporting purposes
  • Written SAS code for developing data sets from raw data files received in text format. This included cleaning data.
  • Extracted raw data from the warehouse and created SAS data sets that are required for the project analysis using SAS/ACCESS and SAS/CONNECT
  • SAS/ENTERPRISE GUIDE software was used for file and program management purposes.
  • Connected to DB2 and pulled data into SAS data sets using SQL pass through facility.
  • Wrote different joins and merges to create reports based upon the requirements given.
  • Written time and resource efficient code using PROC SQL.
  • Written macros to automate the code so that they generate reports on the invocation of the macro which helped to save time and manual intervention
  • Generated reports in HTML format using SAS/ODS.
  • Used SAS import and Access to import external files.
  • Responsible for merging large data sets efficiently.
  • Documentation of the entire project.

Job Title: SAS and Java Consultant

Confidential

SAS EG, Base SAS 9.2,MySQL,Oracle 11g, Java/J2EE, Web services, EJB, Hibernate, RTC

Day-to-day Activities and Responsibilities:

  • Meeting business partners and managers to obtain functional requirements
  • Translating business requirements to technical design specifications for coding, validation and reporting purposes
  • Involved in the design and development of databases
  • Developed application using Java, MS Excel, web services, Oracle database and PL/SQL.
  • Prepared the coding standards document and developed Assent-PMD rules to enforce them.
  • Involved in writing code in Java with features like Collections, Exception Handling and multithreading.
  • Responsible for Configuration Management (code deployment and handling CIT box related issues).
  • Unit testing and integration testing of the system.
  • Prepared the coding standards document and developed Assent-PMD rules to enforce them.
  • Performed data cleansing and data validation using data step and SAS procedures
  • Drafted test cases/scenarios to facilitate testing
  • Configured the text analytics engine for validating Insurance claims
  • Coordinated with Developers, business managers to gather business requirements and prioritize them

Job Title: Java Consultant

Confidential

Java/J2EE, Web services, EJB, Hibernate, RTC, MySQL, Oracle 11g,

Day-to-day Activities and Responsibilities:

  • Requirement analysis based on System Requirements document to cover the functionality, operations, technical issues and scope of work
  • Responsible for designing the BOM (Business Object Model) class diagram.
  • Construction of Hibernate and Dozer modules.
  • Delivering the Technical specification of all the major modules
  • Preparing Analysis and Design documents and Unit Test plan
  • Quality Process Management using IQMS
  • Development of the new system or modification of existing system as per the requirements.
  • Support Component Integration Testing (CIT)
  • Responsible for Implementing Atomic Work Task logic to run parallel tasks using task manager
  • Implemented financial feature in ECAMS system.
  • Worked with Log4J logging framework.
  • Involved in design and implementation plan and Unit Testing of the SDLC
  • Enhance existing code to meet new requirements
  • Responsible for End to End Fraud alert and case management.

Hire Now