Seeking a SAS Programmer Analyst position with opportunities for growth
* 7 years of experience in the IT industry, proficient in working on
Development, Test and Production.
* Over 6 Years Experience working with SAS 9.0, 9.1 and 9.2 as a SAS
* Experienced working in the Financial Industry with Banking
Institutions handling risk assessment, credit card domain and also
in Pharmaceutical Companies and Insurance.
* Strong SAS Analytical experience working with large data sets with
a fine understanding of Data Distribution, Data Graphs, Descriptive
Statistics, Data Relationships as well as Trends and Time Series.
Working experience using and interpreting/presenting SAS procedures
such as Proc Univariate, Proc Freq, Proc Means, Proc Reg and Proc
* Good Business Analysis and Statistical Data Modeling skills able to
make sense of Big Data.
* Strong SAS programming background using various SAS components like
SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ODS and
* Capable of analyzing extensive data sources and generating
comprehensive reports using SAS combined with SAS Business
* Substantial Knowledge of SAS-Business Intelligence, SAS Enterprise
Guide 4.1, SAS Enterprise Miner 7.1, JMP 9, SAS OLAP Cube studio
9.1, SAS Information Map Studio 3.1, SAS Data Integration Studio
3.4 and SAS Management Console 9.1
* Experience in writing complex and efficient algorithms using
advanced SAS programming techniques like Merging SAS Data sets,
writing Macros, SAS Formats & Informats, SAS Functions and SAS
procedures like Proc Freq, Univariate, Means, Summary, Tabulate,
Import, Export, Copy, Print, Contents, Compare, Report, Ttest,
Gplot, Format, Sort, Transpose and Proc SQL.
* Experienced in converting SAS datasets to various file types
(including HTML, PDF, Excel, CSV and ASCII) as well as converting
various file types into SAS datasets.
* Knowledgeable in various data Extraction, Transformation and
Loading (ETL) techniques; worked on SAS-BI(Business Intelligence)
Multi-Tier Client/Server environment.
* Extensive knowledge in database modeling, management and data
access/analysis. Specifically experienced in relational databases
and SQL programming in MySQL, Oracle, MsSQL, DB2.
* Good understanding of Business Analysis skills; experience in
collecting and documenting software requirements from clients coupled
with developing Design Documents.
* Performed exceptionally working independently as well as in a team
with excellent interpersonal, analytical, problem solving and
* Proven to be fast and ardent learner capable of adapting to new
domains, technologies, concepts and environments.
* Experienced in all the SDLC phases with exceptional performance in
Development, Documentation, Test, Implementation, Training, support
* Bachelors of Arts Degree in Computer Science - Le Moyne College, US
* Bachelors of Science Degree in Business Administration - Management
Information Systems - Le Moyne, US
* Certificate in Software Engineering - SAS & Visual Basic- IST
(Software Technologies) - Kenya
SAS : SAS 9.1, SAS 9.2, Base SAS, SAS/Macros, SAS/Access,
SAS : JMP, Enterprise Guide, Enterprise Miner,
SAS/BI (SAS/E-GUIDE 4.1,
SAS/DIS 3.4, SAS/OLAP 9.1, SAS/IMP 3.1)
RDBMS : Oracle 10g, MySQL, SQL Server, DB2
Programming : C++, Java, Python, SQL, SAS, Visual Basic
Operating Systems : UNIX, Windows, Mainframe z/OS
Architecture : Data warehousing concepts
Mainframe : COBOL, JCL
ETL Tool : Informatica
Scripting : UNIX Shell scripting
Aetna, Blue Bell, PA
Aug 2011 - Present
Aetna offers a broad range of traditional and consumer-directed health
insurance products and related services, including medical, pharmacy,
dental, behavioral health, group life and disability plans, and
medical management capabilities and health care management services
for Medicaid plans. Our customers include employer groups,
individuals, college students, part-time and hourly workers, health
plans, governmental units, government-sponsored plans, labor groups
. Performed ETL on Oracle and DB2 databases to extract and prepare data
for analysis and reporting
. Data processing and validations were done extensively on the SAS
datasets using edit check programs
. Involved in standardizing reporting procedures for graphical and
. Used advanced SAS tools to automate the reporting systems to generate
daily and monthly reports for advanced premium, policy risk-in-force
count, monthly claim count, claim recovers, claim outstanding
reserves, paid claim reports, outstanding loss, agent commission etc.
. Used SAS Procedures to generate Ad-hoc reports such as renewal policy
count reports by state, agent commission report by agent type based on
. Wrote Output Delivery System SAS Procedures to publish reports as HTML
pages to the Web
. Assisted data mining team to extract data patterns and trends from
. Developed and maintained the SAS code for Acquisition models, X-Sell
and Up-Sell marketing models, segmentation and targeting and campaign
. Used procedures like PROC FREQ, PROC Means, PROC Sort, PROC Print,
PROC Tabulate, PROC UNIVARIATE and PROC Report
. Data Fixing and Batch monitoring and performing troubleshooting of
various issues ranging from batch programs
Environment: Windows XP, SAS 9.1.3, SAS/BASE, SAS/MACRO, SAS/ACCESS,
SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Enterprise
Guide, HTML, Teradata, Unix.
SunTrust Bank, Nashville, TN Nov
2010 - July 2011
Sr. SAS Programmer
SunTrust Banks, Inc., with total assets of $178.2 billion on March 31,
2012, is one of the nation's leading financial services holding companies.
Through its flagship subsidiary, SunTrust Bank, the company provides
deposit, credit, trust and investment services to a broad range of retail,
business and institutional clients. Other subsidiaries provide mortgage
banking, insurance, brokerage, investment management, equipment leasing and
capital markets services.
. Utilized both financial analysis and computer science skills in a
multidisciplinary Position of financial quantitative analyst, which
involved data modeling, econometric analysis, risk modeling and data
analytics using SAS and SQL.
. Played a key role in data analysis and data modeling (model design,
development, and model implementation) using SAS. Handled huge
datasets, of over 80 million records.
. Performed all the necessary ETL processes to obtain and prepare data
. Developed SAS programs using Base SAS, SAS/EG, SAS/Macros and
. Demonstrated high level of competency in statistical and analytical
principles, tools and techniques and supported the advancement of the
"best-in-class" analytical capabilities.
. Analyzed merchant loan data and built several rule based models, using
base and advanced SAS, to track the performance of merchants.
Presented and implemented my own data models and reporting templates,
which provided a better picture of the performing and non-performing
. Developed a model that helps the Account Management team to make
monthly and annual product renewal decisions. Built pattern
recognition statistical tools (scanners) to analyze the data patterns
and trigger notifications if a merchant's loan performance is abnormal
or undesirable (based on risk models). Profiled all the merchants
based on 4 years of data and tracked the out-of-pattern behavior from
the merchants. The model improved loan approval decision making and
reduced loan risk and improved profitability.
. Developed and scheduled various daily reports to run automatically
using Crontab.SAS. Used ODS Tagsets and PROC REPORT to color code the
rows in the excel output.
. Coordinated with offshore team in India to support underwriting
. Tracked the card member behavior by analyzing the credit risk
. Presented various designs and data models to senior executives
responsible for risk management and business development.
Environment: SAS 9.1.3, SAS/EG, SAS/Base, SAS/Macros, SAS/Access, SQL,
SAS/CONNECT, Crontab.SAS, ODS Tagsets, PROC REPORT, FTP, SAS-OLAP, Cobol -
Flat Files, UNIX & Mainframe z/OS
Cablevision, Long Island, NY
Apr 2010 - Oct 2010
Sr. SAS Developer/Team Coordinator
Cablevision is a leading telecommunications and media company with a
portfolio of Operations that includes a full suite of advanced digital
television, voice and High-speed Internet services, valuable local media
and programming properties and movie theatres.
. Gathered and analyzed the business requirements and developed
prototypes of the data models.
. Built cubes using SAS OLAP Cube Studio, designed dimensions, measures,
levels, hierarchies for report generation based on multiple KPIs.
. Extracted data from the database with over 35 million records using
SAS/Access, SAS SQL procedures and created SAS datasets (ETL).
. Joined several tables residing in different platforms using SAS Proc
SQL to gather relevant data for measuring performance of the
. Derived several columns from existing columns using SAS SQL procedure.
. Created information maps using SAS Information Map Studio.
. Created reports in SAS Web Report Studio using Information maps.
. Scheduled and evoked several programs and tasks using Unix Shell
. Demonstrated the reporting tools and presented them to senior vice
presidents and several program managers.
. Lead a team of 3 analysts in designing, analyzing and reporting key
Environment: SAS 9.2, SAS BI, SAS Management Console, SAS Enterprise Guide
4.0, Unix, SAS DI Studio, AS/Access, SAS/SQL, SAS/Base, SAS/Macros,
SAS/Graph, PL/SQL, Oracle and Endevor
Bristol-Myers Squibb, Princeton, NJ
June 2009 - Mar 2010
Bristol-Myers Squibb is a global BioPharma company firmly focused on
its Mission to discover, develop and deliver innovative medicines that
help patients prevail over serious diseases.
. Enhancing SAS applications in different environments for Models and
. Wrote SAS Macro's when ever re-usability was needed.
. Created Ad-hoc reports in Excel and HTML for Business users using
. Used SAS/Access to read data from SQL Server database for Audit
purposes (among other ETL tasks).
. Extensively used SAS Formats and Informats to read and write data.
. Working closely with Internal and External Auditors to provide
information about different production applications.
. Worked closely with other support teams like Unix Administrators and
SAS Infrastructure team to solve infrastructure related issues.
. Worked extensively in troubleshooting and fixing bugs for various
applications in a timely manner.
. Good knowledge of change managements and defect tracking tools like
ClearCase, ClearQuest, Remedy and Change Tracker Turbo.
. Interfacing with the business area to support production systems,
assisting in ad-hoc requests and providing technical expertise and
. Quick trouble-shooting skills and highly responsible in supporting
critical financial application during month end process.
. Worked as Incident Manager and escalated incident tickets based on
impact and urgency.
Environment: SAS 9.1.3, SAS/Access, SAS/Connect, SAS/SQL, SAS/ODS,
J2EE,Weblogic,Webmethods, MS Excel, UNIX, Remedy, ClearCase and
ClearQuest, SQL Server.
Medpace Inc. Cincinnati, Ohio
Aug 2007 - May 2009
A global leader in research-based drug development, Medpace builds strong
strategic partnerships with select Sponsors to advance the most efficient
and cost-effective path to drug approval. As a therapeutically-focused
Clinical Research Organization (CRO), we view ourselves as stewards of your
drug, leveraging our extensive medical and regulatory expertise to deliver
additional input, strategy, and efficiencies to each and every phase of the
clinical trial. From custom solutions addressing the needs of small and
midsize biotechnology companies to full-service offerings for global
pharmaceutical companies, Medpace has the breadth, depth, and flexibility
to deliver a superior result, specific to your needs, on six continents.
. Worked in SAS PC for design, development and operations.
. Perform data extraction from various sources
. Performed quality control, as required per SOPs, for statistical
programming deliverables (including input in Validation Plan & QC
. Provided items required for e-submission (i.e. SAS transport files,
define.pdf, annotated CRF)
. Created derived-analysis datasets for the biostatistician based on
. Assisted in providing and maintaining project plan for all
projects/study including milestones, tasks, and coordination of
. Executed analyses specified in the Statistical Analysis Plan (SAP)
under the guidance of the project statistician
. Secondary programmer to validate SAS programs that produce derived-
analysis datasets and data analyses.
. Designed, developed and tested SAS code to track and forecast the
sample and lab test results.
Developed code to track patients' end of study visits and early
. Tested the macros to track error handling and email notification due
to system failure.
Produce frequency and distribution tables for various studies for
Environment: SAS 9.1.3, SAS DIS, SAS EG 4.0, SAS/Base, SAS/Macros,
SAS/Access,, SAS/CONNECT, SQL, Oracle, SQL Server, Windows OS
CFC Stanbic Holdings Ltd (CFC Stanbic Bank) - Nairobi, Kenya
April 2005 - May 2007
Rooted in Kenya, CfC Stanbic Bank is a corporate and retail bank licensed
by the Central Bank of Kenya to
provide banking services in the Kenyan economy. The bank is part of the
Standard Bank Group a leading
African financial services organisation, which was founded more than 150
years ago and today has operations in 18 African countries and across the
Leveraging its regional, continental and global network, CfC Stanbic Bank
is the premier service provider of international corporate and investment
banking services and takes pride in providing innovative financial
solutions for Kenya's growing retail banking population.
. Developed a program to monitor the Transaction Types-Wires In/Out,
Withdrawals/Transfers-on a daily basis.
. The report displayed a column of each trading day of the amount and
number, by transaction types with sub-Totals and totals. This was done
using SAS (Base, SQL, Macros, and Proc Transpose) and DB2 Tables of
Brokerage and Financial Data on a z/OS System.
. Developed a Reporting System to be distributed to the Branch Managers
of the FA who has any split relation with the Director. These reports
displayed data of Corp Name, Acct #, Household ID, Reinvestment
Partner, Commissions, Assets, FA Name, Partnership Type and also
. These are programmed using SAS SQL joins and SAS Passthru Facility and
Libname Engine to extract data from large DB2 Tables of Brokerage and
Financial information which was then processed with SAS (Base, SQL,
Macro, ODS, Proc Report, Data Steps) on IBM OS using JCL. These
processes are migrated to the production System with CHGMAN Package.
Environment: SAS 8.2, JMP, SAS Business Intelligence, SAS/Base,
SAS/Macros, SAS/Access, SQL, MS-Office, SAS/CONNECT, CHGMAN, DB2, z/OS,