C.S Mohan Plot No - 76, Ambal Nagar,

8th Cross Street,

Pallikaranai,

Chennai - 100

Email: Hand Phone: +91 9841745272

Professional Summary

  • Certified SAS Developer with around 6 years of experience in SAS analysis, development, testing and validation the applications onWindows environment.
  • Worked at Client location (UK) for couple of times and had a good rapowith customers and got appreciationsfor requirement understanding,scripting and all deliverables.
  • Strong SAS programming background for creating, maintaining existing code and supporting the reporting functions.
  • Expertise in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ACCESS and SAS/CONNECT
  • Excellent knowledge in SAS procedures like PROC SUMMARY, PROC TABULATE, PROC REPORT, PROC COMPARE etc.
  • Expertise in SQL, Oracle and UNIX
  • Hands-on in SQL Stored Procedures and Subqueries
  • Extensive knowledge in Development and Customization of SAS Scripts for Extraction, Transformation and Data Analysis.
  • Experience in manipulating and analyzing large datasets.
  • Experience in Base SAS, SAS DI Studio, SAS EG
  • Having knowledge in SAS Management Console.
  • Experience in creating reports using Crystal Reports.
  • Experience in functional testing and database testing
  • Ability to handle multiple tasks simultaneously
  • Strong Communication, Analytical, Problem-solving and Interpersonal skills
  • Good Client Management and Leadership Skills

Technical Proficiency

Statistical Tools: SAS Base, SAS Macros, SAS/Access, SAS/Connect and PROC SQL

Languages : HTML, XHTML, CSS, Java Script, C, C++

DBMS: Oracle 10g, Sql Server 2005, 2008 and MS- Access

Reporting Tools: Crystal Reports

Testing Tools :ALM, JIRA

Core Strengths

Leading Capability Planning & Organization

Programming Ability Systematic

Problem Solving Multitasking

Self-Motivated Concept Development

Educational Qualifications

●MCAin April 2006 from Anna University.

●MBA (Project Management) in 2014 from Alagappa University (Distance Education)

●BSC (Computer Science)in April 2003 from University of Madras

Professional Experience

Organization / Designation / Duration
HCL Technologies / Senior Software Engineer / June 2010 Till date
Gordon Woodroffe Logistics Limited / Senior Executive - IT / December 2006 June 2010

Projects Profile

Project Name

/ E-Trade and Solvency
Client / DLG Direct Line Group
Role /

SASDeveloper

Location /

Offshore

Type /

SAS Development

Organization / HCL Technologies
Duration / October 2017 Till Date
Team Size / 6
Environment / Software / Technology: SAS EG, SAS DI, Proc SQL, PROC Compare, PROC FORMAT, SAS/Macros, SAS/SQL, SAS Reporting

Project Description:

The project specialises in sellinginsuranceand other financial services, sold directly to consumers by telephone and the internet. This project covers of all insurance services as Business, Homeowners, Auto, Motorcycle, Renters and Life.

Contribution:

  • Performing the tasks of designing and developing project-specific SAS programs like producing analysis datasets, graphics and reports
  • Written SAS macro programs to facilitate the validation of datasets.
  • Manipulated, transferred and managed data in SAS
  • Used data _null_ and PROC REPORT to generate the outputs.
  • Reviewed large macro codes for running the programs.
  • Extensive use of PROC SQL, PROC FORMAT, PROC COMPARE to create subsets of data for further analysis, to compare between two datasets and for specific format required

Project Name

/ SAS Development & ETL Testing
Client / UKAR UK Asset Resolution
Role /

SASDeveloper

Location /

Onshore - Client (UK)

Type /

SAS Development

Organization / HCL Technologies
Duration / December2013 October 2017
Team Size / 15
Environment / Software / Technology:SAS EG, Proc SQL, PROC Compare, SAS/Macros, SAS/SQL, SAS Reporting

Project Description:

The project involves gaining more insight into the customers behaviour so as to deliver improved services and to estimate revenues and volumes of customer transactions for planning and subsequent Management action which also involves in collecting, collating and carrying out complex data analysis in support of management & customer requests. Also involved in reporting statistical findings by using customer segmentation techniques to design dashboards which will make the decision making ease for the Management.

Contribution:

  • Performing ETL process through SAS EG.
  • Created, modified/Updates SAS code to incorporate changes in new releases of the product.
  • Data manipulation by merging, appending and sorting datasets.
  • Created complex and reusable Macros and extensively used existing macros
  • Extensive use of PROC SQL to create subsets of data for further analysis.
  • Involved in code reviews.
  • Developed SAS code using Macros to run recurring jobs and optimized code.
  • Mentored and trained new team members to complete the projects efficiently and within time.
  • Validating the ETL Mapping document provided by the Business Analyst Teams
  • Working closely with business SMEs.

Project Name

/ SAS Development
Client / LBG -Lloyds Banking Group
Role /

SAS Programmer

Type /

SAS Development

Organization / HCL Technologies
Duration / February 2012 December 2013
Team Size / 8
Environment / Software / Technology: Base SAS, Proc SQL and SAS/Macros

Project Description:

This project deals with enhancing the end to end BI application developed in SAS. It comprises of ETL process and reporting mechanisms. This project helps the bank by processing the transaction data and loading into data warehouse and preparing reports for operational and regulatory purposes.

Contribution:

  • Leading the team in front for development activities
  • Used SAS Macros and procedures like Proc SQL, Proc Transpose, Proc Means, Proc Freq.
  • Developed SAS macros for Data cleaning, Data mining and Reporting and to support routing processing.
  • Formatted HTML, PDF, CSV and RTF reports, using SAS - output delivery system ODS.
  • Extraction of data from Data Ware housing tables and Data marts.
  • Modifying data using SAS/BASE and Macros.
  • Creating Customized reports in Enterprise Guide for the users.
  • Repaired syntax errors in the code
  • Extracting data from the database using SAS/Access, SAS /SQL procedures and create SAS data sets.

Project Name

/ Pfizer-PGM-Managed Services-Support
Client / PFIZER
Role /

Team Lead

Type /

Support

Organization / HCL Technologies
Duration / June 2010 February 2012
Team Size / 10
Environment / Software / Technology:VB.Net, SQL and Crystal Reports

Project Description:

It is Level 3 support project which contains more than 50 applications across the globe. We will be giving L3 support where it involves bug fixing, code changes and enhancement if required.The technologies were used VB.Net, SQL and Crystal Reports

The tools used are HP Service Center which is to create and close the ticket and

Serena Work Flow Management which is to create against the Service Center ticket to monitor the ticket status continuously.

Contribution:

  • Leading the team and assigning the task to them
  • Providing L3 support as bug fixing in the existing program
  • Analyze the program and changes will be made if required
  • Preparing SCM report for business monthly
  • Interacting with client on a weekly basis for status update

Project Name

/ Business Operating System (BOS)
Client / In-house Development and Maintenance
Role /

Senior Executive - IT

Type /

Development

Organization / Gordon Woodroffe Logistics Limited
Duration / December 2006 June 2010
Team Size / 15
Environment / Software / Technology: VB, VB.Net, SQL and Crystal Reports

Project Description:

This ERP which covers operation activities of Domestic Air Imports, Air Exports, Sea Imports, Sea Exports, Air Import and Export Clearance, Sea Import and Export Clearance and Core Finance to end user in different standard export formats for the customized.

Contribution:

  • Requirement Analysis, Programming, Maintenance of database.
  • Requirement freezing with inter departments of all the branches.
  • Providing solutions for the clients by implementing the system for their operations.
  • Involved in training for the new comers with the programming standards, project setup.
  • Preparing Context sensitive help documents and Manuals.

Personal Profile

Date of birth : December 07, 1982

Marital Status : Married

Nationality : Indian

Languages Known

To Speak: English, Tamil and Telugu

To Write: English and Tamil

Key Achievements

  • SAS Certified Base Programmer for SAS9.

Areas of Interest

  • To develop more advanced SAS Programming suites.
  • To generate and implement SAS programming for various projects.

C.S. Mohan

Email: Hand Phone: (0) 9841745272