Sign in

Data Sql Server

Livonia, MI
August 28, 2012

Contact this candidate


Seeking a SAS Programmer Analyst position with opportunities for growth

Professional Summary:

* 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



* Capable of analyzing extensive data sources and generating

comprehensive reports using SAS combined with SAS Business

Intelligence tools.

* 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

communication skills.

* 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

and Maintenance.

Academic Qualifications:

* 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

Technical Skills:

SAS : SAS 9.1, SAS 9.2, Base SAS, SAS/Macros, SAS/Access,



SAS : JMP, Enterprise Guide, Enterprise Miner,


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

Work Experience:

Aetna, Blue Bell, PA

Aug 2011 - Present

SAS Programmer

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

and expatriates.


. 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

tabular reports

. 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

clients requirements

. 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

sales data

. 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,


. 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,


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

for analysis.

. 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,


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

performance indices.

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

SAS Developer

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

business Methods.

. 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,

SAS/Macros, JAVA,

J2EE,Weblogic,Webmethods, MS Excel, UNIX, Remedy, ClearCase and

ClearQuest, SQL Server.

Medpace Inc. Cincinnati, Ohio

Aug 2007 - May 2009

SAS Programmer

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

SDTM/Adam standards.

. Assisted in providing and maintaining project plan for all

projects/study including milestones, tasks, and coordination of

programming activities

. 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

SAS Developer

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

summary data.

. 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,


Contact this candidate