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.

• 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

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.