SUMMARY:

Experienced programmer /system administration / IT Project management and many years of functional IT experience. Well versed with various visual analytics / BI tools including SAS / Power BI.

CORE SKILLS:

• SAS Programing and Development
• Shell Scripting - Bash, Python, awk Ksh(Korn)
• Can Work on Linux Command Line
• SVN Sub versioning system
• ITSM/Change Management
• Can use Control-M
• Procedural / OO Languages: C/C++/Core Java/Fortran / GCC Compiler
• SAS Administration - install-configure, administer and apply hotfix
• Linux Administration -Installation, configuration, patching upgrade and administer
• Proficient on Linux - Comfortable with Windows
• Excel/Access/VBA
• Data Analysis / regression / visualization with SAS / R / Python / Excel
• Common office tools - MS Office /Libre Office/ Lotus SmartSuite, L A T E X, Gnuplot
• Data Analysis and Visualization with SAS, Python, R, Excel
• Working Knowledge of LAMP Stack / WordPress / Joomla
• Worked from programing, desktop support to System Admin and IT project management

PROFESSIONAL EXPERIENCE:

Confidential

Senior SAS Programmer

Responsibilities:

• SAS Applications / tools / L3 Support
• Managing / monitoring/ trouble shooting batch SAS programs on Unix Server
• RCA of failed jobs and remediation
• Gathering user requirements and grooming JIRA Stories for Agile Development
• Developing / updating / modifying SAS programs, macros/ reports / Excel Reports as per business requirements.
• SAS programs for handling large / longitudinal data / transactional data
• Creating / modifying / updating SAS ODS/ Reports
• SAS program Automation
• SAS and Teradata / DB2 /ORACLE
• Developing / updating / modifying Unix Shell Scripts
• Working on Unix command line - Ksh / Korn Shell
• SVN and Control M

Confidential, Farmington Hills, MI

Senior SAS Programmer /Admin

Responsibilities:

• Data Base Migration project
• Migration of DB2 databases.
• Developing / updating / modifying DB2 /SAS queries / SAS programs.
• Updating SAS Server Meta-data- Creating / updating libraries and authentication Domains / User Groups etc.
• Proc SQL (Implicit and explicit/pass through SQL).
• Handled large datasets
• Remote database connectivity (SAS Connect)
• SAS / Excel VBA / DDE
• Created Data Dictionaries and validated data (SAS Proc Content/ SAS SQL / Proc Compare).
• Extensively used SAS Enterprise Guide, and SAS Windowing environment.

Confidential, Chicago

Sr SAS Developer

Responsibilities:

• Developed a complex self-contained end to end SAS Solution / Application
• Developed program design and architecture by gathering user requirements.
• The solution processes compressed archive to SAS data sets based on the busines logic.
• This is a SAS EG based application meant to be used by business users/ Actuaries
• User input through SAS Prompts. SAS programs for handling large / longitudinal data / transactional data
• SAS programs for handling large / longitudinal data / transactional data
• Involves multiple SAS procedures, SQL queries, automation macros and executing operating system level commands and running Windows applications from within SAS.

Confidential, Chicago, IL

SAS BI Administrator

Responsibilities:

• Worked on Multi-tier multi environment SAS Grid - with job scheduling on Appworx
• Providing support to customers by troubleshooting problems with SAS and other software applications / environment and providing technical solutions, including SAS BI, JMP, and
• Orders, license control & tracking, installation, etc., of additional software as needed.
• Applied SAS hot fixes on Linux servers
• Manage daily issues, request tickets
• Oversee all aspects of SAS environment including installation, patching, backup, access control, day-to-day monitoring..
• Document, report, track and implement fixes for software and hardware problems with appropriate vendor.
• Managing / monitoring, trouble shooting batch SAS programs on Linux Server
• RCA of failed jobs and remediation
• Developing / updating / modifying SAS programs
• Developing / updating / modifying Linux Shell Scripts

Confidential, Auburn Hills

SAS BI Administrator

Responsibilities:

• Experience in Architecture / designing the SAS BI and Office Analytics System
• Installed SAS BI Server, SAS POC Grid Server and R server
• Provides IT systems support for the SAS environment and suite of products that include various SAS clients such as SAS EG, SAS Studio, SAS AMO, SAS E-miner, SAS IML SAS IML Studio etc.
• Performed various activities that include installation, configuration, monitoring, troubleshooting and repairing of various installation including metadata server, App-Servers etc.
• Performed Migration from SAS 9.2 to SAS 9.4,
• Part of team for creation and deployment of Virtual Apps for various SAS Clients
• Installed various foundation Products such as SAS-OR, SAS IML and R programming language
• Created handbook of standard operating procedures.
• Installed and configured ODBC Drivers- odbc.ini. Oracle Client and Data Direct drivers DRIVER for MS SQL Server on UNIX environment.
• Optimized SAS IO - Optimized SAS IO on Windows 2008 servers
• SAS Automation: Developed Unix shell scripts for automation and scheduling to the program in batch mode and taking snapshot of monthly data
• Provided programing support to end users - analyzed SAS logs, optimized SAS programs, creating stored procedures and developing insights into data using BI tools.
• Monitoring server performance using SAS logs and Linux utilities (SAR, VMSTAT, IOSTAT etc) and Linux logs
• Created SAS EG project to analyses performance metrics and logs.
• Managing / monitoring, trouble shooting batch SAS programs on Linux Server
• RCA of failed jobs and remediation
• Developed SAS programs for SAS metadata extraction and reporting
• Developing / updating / modifying Linux Shell Scripts
• Provided Application programing and development support to SAS Developers

Confidential, Minneapolis

SR. Analytics Consultant

Responsibilities:

• Supported credit risk modeling team
• Created datasets from various raw data sources - spreadsheets, flat files (such as txt, csv), SQL databases for analysis and submissions
• SAS programs for handling large / longitudinal data / transactional data
• Developing / updating / modifying SAS programs
• Developing / updating / modifying Linux Shell Scripts
• Worked independently with minimal supervision.