Data Project
Resume:
Executive Summary
> *+ years of experience providing innovative solutions needs in
Financial, HealthCare, Pharmaceutical and Sales and Marketing.
> Expertise in SAS / Base, SAS / Graphs, SAS / Macros, SAS / ODS, SAS /
SQL, COBOL, DB2, VSAM and JCL.
> Familiar with SAS Access, SAS/STAT, SAS/Connect, SAS/ETL
> Extensive experience in preparation of reports, tables, listings and
graphs
> SAS certified professional with profound understanding in BI and Data
Mining awarded by the SAS Institute
> Database Marketing experience in analyzing and reporting on direct
marketing efforts & CRM
> Extensive academic experience in SAS Enterprise Miner, Enterprise
Guide, XL Miner
> Experience in collecting and analyzing huge datasets with tools like
SAS 9.2, XLMiner (Excel Add-in)
> Proficient in IBM utilities and worked with Tools like ENDEVOR, FILE-
AID, SPUFI and QMF.
> Has vast experience apart excellent communication and interpersonal
skills helps contribute to timely completion of project deliverables
well short of schedule.
> Strengths include documenting customer business processes, workflows
and requirements. Defining and communicating system requirements,
documenting business rules required by the solution, documenting and
maintaining business requirements and functional specifications,
partnering closely with business stakeholders to achieve consensus on
major project deliverables
> Excellent background in relational database management systems
(Oracle database 11g/10g/9i/8i) including PL/SQL.
> Experienced in UNIX shell scripting, cronjobs, Vi editior
> Created complex test plans, requirements and design test cases. Managed
execution of different testing phases (unit, integration, systems,
interface and compliance testing).
> Ability to work independently as well as collectively ~ willing to
relocate
Technical Skills
SAS Skills : BASE SAS, SAS/MACRO, SAS/CONNECT, SAS-SQL, SAS/STAT,
SAS/GRAPH, SAS - ODS, SAS/ACCESS,
SAS-AF, SAS Enterprise Guide,
SAS Enterprise Miner, OLAP Cubes
Studio, SAS Information Map, Web
Report Studio
SAS Procedures : PRINT, TRANSPOSE, CONTENTS, MEANS, CHART, PLOT, PRINTTO
TABULATE, UNIVARIATE, SUMMARY,
SORT, SQL, PROC FORMAT,
FREQ, FORMS, UPLOAD, DOWNLOAD,
DATASETS AND FORMAT, PHREG, MI,
IMPORT, EXPORT, REPORT, GCHART, GLM, MIXED, GSLIDE,
COPY, ANOVA, REG
Advanced SAS : Macros, DATA _NULL_, Data Step, Reports, Array
Processing,
Display Manager.
Languages : SAS 9.2 Programming, COBOL, JCL, ASSEMBLER, REXX, PL/SQL
Operating Systems : OS/390, OS/2, MVS/ESA, MS WINDOWS, UNIX AIX
File Organization : VSAM, PS, PDS, GDG
Hardware : IBM-3090, IBM ES-9000, IBM COMPATIBLES
Utilities/Tools : HP Quality Center, Toad for DB2 and Oracle,
TSO/ISPF, QMF, ENDEVOR, FILE-AID,
MS-OFFICE SUITE, EXCEL, OUTLOOK,
POWER POINT
Databases : DB2, IMS/DB, ORACLE, TERADATA, SQL Server 2005/08, MS
ACCESS
Client Engagements:
Hewlett Packard, Chicago, IL (Oct
2010 to Current)
Client: CVS Caremark Corp. as SAS Developer/Analyst
Project Description: iBenefits3.0 Remediation Project
A dynamic and personalized consumer mailing that summarizes prescription
claim utilization and highlights opportunities for members to save on
generics, preferred brands, and mail. Worked with cross-functional teams
like the JAVA UI and EDW Informatica to understand the Functional
requirements and Business Logic better
Responsibilities:-
. Helped interpret the results of actionable business information into
technical specifications
. Worked closely with Database Engineers to design, build, and modify
data processes
. Worked closely with the front end JAVA UI team and back end EDW
Informatica team to implement any software required for accessing and
handling data appropriately
. Created SAS data sets form source tables by programming in BASE SAS
through SAS Enterprise guide. Report Generation and Documentation with
respect to evaluation of model performance and effectively
communicating the results to higher management
. Executed SAS programs in the UNIX box in the batch mode by using cron
jobs
. Gained a comprehensive knowledge transfer of other SAS modules in the
project and provided timely support
. Migration of data from text files and DB2 to SAS data sets.
. Created complex and reusable Macros and extensively used existing
macros and developed SAS source codes
. Documentation, Preparing statistical reports using SAS.
. Wrote Design documents, Program specs and SAS code.
. Involved in the various stages of Project testing (Unit by unit
testing of the SAS source code, System Integration Testing, Functional
Testing, User Acceptance testing)
Environment: SAS V9.1, SAS/Base, SAS Enterprise Guide 4.1, SAS/Macros, DB2,
Toad, Oracle, HP Quality Center, CVS Sharepoint Server, UNIX AIX, IBM
Control Center.
USAA, San Antonio, TX USA
(Aug 2009 to Sep 2010)
Analyst Programmer
Project Description: The policy module deals with all policy related
issues such as customer, quotations, and application submission. After
successful completion of policy processing, customer will be given risk_id.
My assignments involved changing JCL and SAS coding for various production
jobs. Specifications are under constant revision and every conversion
requires analysis, unit testing, code review, and system testing.
Responsibilities:-
. Consolidated and interpreted the results of data mining activities
. Helped translate the results of data mining into actionable business
information
. Worked closely with Database Engineers to design, build, and modify
data processes
. Worked closely with Engineering to implement any software required for
accessing and handling data appropriately
. Created SAS data mining and scoring data sets form source tables by
programming in BASE SAS. Report Generation and Documentation with
respect to evaluation of model performance and effectively
communicating the results to higher management
. Responsibilities include writing SAS MACRO CODE, SCL to read and
create METADATA files on Unix.
. OLAP Cubes and ETL skills to provide for all types of programs.
. Pulled DB2 fields for marketing campaigns and used SAS for reporting
campaigns.
. Migration of data from text files and DB2 to SAS data sets.
. Created complex and reusable Macros and extensively used existing
macros and developed SAS
. Developed an Automated Quality Control System for Data Validation and
data integrity.
. Developed a JCL to run jobs in MVS system.
. Migration of large data from DB2 tables around 400 to SAS datasets
around 8 millions observations.
. Documentation, Preparing statistical reports using SAS.
. Wrote Design documents, Program specs and SAS code.
. Involved in various Testing phases (Unit, System and Integration)
Environment: SAS V9.2, SAS/Base, SAS/Graph, SAS/Macros, SAS-AF, SAS-ODS,
IBM 3090, COBOL II, DB2, JCL, Contol-M, Enterprise Guide, SPUFI, (DI)
Studio, Enterprise Miner, OLAP Cube Studio, SAS Information Map.
Client: HSBC Bank, Buffalo, NY USA
(Jun 2008 to Jul 2009)
Analyst Programmer
Project Description: Developed SAS credit card applications for
Collections and Fraud on Mainframe and later on UNIX. The reports and
graphs developed for acquisition, portfolio analyses and strategies through
data analysis and working with marketing departments.
Responsibilities:-
. Converted raw data to SAS datasets for customer analytics to find
customers' buying preferences.
. Extensive experience in SAS Enterprise Miner, Enterprise Guide, XL
Miner
. Experience in collecting and analyzing huge datasets with tools like
SAS 9.2, XLMiner (Excel Add-in)
. Created Reports using Base SAS, SAS/Reports Procedure.
. Generate reports using PROC REPORT,TABULATE, EXPORT AND DATA_NULL AND
PUT STATEMENTS.
. Migration of data from text files and DB2 to SAS data sets.
. Created complex and reusable Macros and extensively used existing
macros and developed SAS
. Programs for Data Cleaning, Validation, Analysis and Report
generation. Tested and debugged
existing macros.
. Played a major role in quick generation of Ad-hoc Business Analysis
Reports and resolving data
issues upon request.
. Built decision trees and neural networks using SAS 9.1
. Automated SAS applications to CRON and used Shell Script
. Developed an Automated Quality Control System for Data Validation and
data integrity.
. Documentation, Preparing statistical reports using SAS.
. Wrote Design documents, Program specs and SAS code.
. Played a role of coordinator between onsite and offshore for project
delivery
. Involved in various Testing phases (Unit, System and Integration)
. Created SAS MACROS and SAS GRAPHICS. Used Proc REPORT to generate
reports.
Environment: SAS V9.1, SAS/Base, SAS/Graph, SAS/Macros, SAS/Connect, SAS-
AF,SAS-ODS, MVS Mainframe environment
Principal Financial Group, Des Moines, IA
(Oct 2007 to Jun 2008)
SAS Programmer
Project Description: - PRINCIPAL FINANCIAL GROUP is a health care insurance
provider. As a part of month end and year end process in data ware housing
team, everyone month end and year end reports were generated by processing
the data. These reports help the providers for decision support .Data
coming from different sources is processed and manipulated to generate
reports.
Responsibilities:
. Responsible for pulling data by SQL and using Proc Export to Excel to
put reports on Server.
. Used SAS Macros, Data Warehousing, Business Intelligence, and ODS,
Studio and ETL.
. Involved in populating intermediate tables in Data warehouse for
Weekly, Monthly and Yearly load.
. SAS programming and onsite coordinator.
. Data Extraction from various sources like Oracle, Flat files, Excel
spread sheets and manipulated to the format of intermediate tables.
. Created Reports using Base SAS, SAS/Reports Procedure.
. Generate reports using PROC REPORT,TABULATE, EXPORT AND DATA_NULL AND
PUT STATEMENTS.
. Created Macros, in order to generate reports daily, monthly basis.
. Created SAS Views from tables in DB2 using SAS/Access.
. Moving files from Test to Production.
. Designed Test system with SAS, SAS Macros, Meta Data, Oracle SQL,
Oracle, AIX/Unix and Unix Shell Scripts.
. Used Microsoft SQL Server 2000 for SQL.
. Produced SAS Graphs for Engineers.
. Documented the Processes of the System.
. Downloaded SAS files to Microsoft Excel.
. Responsible for SAS Data Warehouse from different files in Test and
Production.
. Designed and developed extracts for BHI warehouse and wrote documents
for support. Installed 9.3 versions of SAS. Used SQL queries in Oracle
and Unix Scripting. Java and HTML for the Engineer to changed the Data
Warehouse through the Web.
. Sequel and SQL for Microsoft Server 2005.
Environment: SAS V9.1, SAS/Base, SAS/Graph, SAS/Macros, DB2, MS-Excel.
Vitex Pharmaceuticals, Watertown, MA, (July
2006 to Sep 2007)
SAS Programmer Analyst -Clinical Trials
Project Description: Vitex is a Biopharmaceutical company developing
products designed to improve the safety of the world's blood supply and is
conducting Phase III clinical trials, designed to inactivate a wide range
of viruses, bacteria and parasites, and has demonstrated its ability to
remove proteins, while preserving the therapeutic properties of red blood
cells. As a SAS Programmer, my role was in analysis of clinical trials data
and generating required reports, listings, summaries and graphs for
submission to FDA and other regulatory authorities.
Responsibilities:
. Generation of reports and transferring the output to the SAS Output
Delivery System.
. Refreshing tables in DB2 Schemas with the SAS data sets
. Coding SAS programs with the use of Base SAS / Macro's for ad-hoc
jobs.
. Client interaction and sending work to off shore
. Work with IT support groups and management teams to define and support
system and information needs,
. Provide high quality service to all internal division and corporate
support teams as well as to all external customers,
. Involved in preparing technical specification documents based on user
requirements,
. Created and implemented statistical analysis plans and specification
documents; participated in database design, data collection
guidelines, and logic checks.
. Conducted, documented and reported Data Validation inspection in
compliance with FDA Regulations (21 CFR) and other regulatory
compliance.
. Participated in designing, coding, testing, debugging and documenting
SAS Programs and Macros.
. Developed SAS programs using Base SAS for tabulation counts,
correlation's and checks for dispersion for normality using PROC
Means, PROC Tabulate and PROC Univariate.
. Applied generally accepted Programming Standards and Techniques to
assure efficient program logic and data manipulation.
. Created a SAS reports using the Data _Null_ technique and Proc Report
for NDA submission as per FDA regulations and company standards.
. Formatted HTML, RTF and PDF reports, using SAS - output delivery
system ODS.
. Involved in preparing study results as well as ISS and ISE for NDA
submissions using SAS.
Environment: BASE SAS V9, SAS/ACCESS, SAS/CONNECT, SAS/Macro, SAS/GRAPH,
SAS/STAT, Excel, Access,Oracle8, Window NT/ 2000 and UNIX.
Life Insurance Corporation of India, Mumbai
(Jun 2004 - May 2006)
SAS Developer
Project Description: Life Insurance Corporation of India is the most
reputed and renowned insurance company in India. Worked as SAS developer in
Claims Department and responsible for deciding if requests for insurance
policies should be accepted by assessing, identifying and calculating the
risk of loss for policyholders.
Responsibilities
. Developed SAS programs using Proc Tabulate, SAS Base and SAS/Stat that
enabled users to generate reports on
Daily/Weekly/Monthly/Quarterly/Annual reports.
. Generated adhoc reports for company's audit and inspection
requirements.
. Data was extracted from databases and also flat files.
. Preprocessed training data and performed advanced modeling on testing
dataset.
. Evaluated the model performance using decision trees and confusion
matrices. Performed model enhancement techniques viz. adboost,
stacking and bagging
. Created SAS data mining and scoring data sets form source tables by
programming in BASE SAS.
. Report Generation and Documentation with respect to evaluation of
model performance and effectively communicating the results to higher
management
. Developed and maintained multivariate statistical models used to
predict customer behavior and to profile customer potential.
. Synthesized coefficients using PROCS MI and MIANALYZE and performed
survival data analysis using PROC PHREG
. Calculating possible risk and premiums for individual organizations.
. Customized existing SAS programs and created new programs using
SAS/Macros to improve the consistency of the results.
. Compile statistics and create detailed reports and graphs for
management and customer review using SAS/Graph, SAS/Macro and
SAS/Report.
. Correlating and presenting weekly or monthly data to senior
management.
Environment: SAS/Base, SAS/Macro, SAS/Stat, SAS/Graph, SAS/SQL, Oracle,
PL/SQL, MS-Excel and HTML
Education: Bachelor's of Engineering
Contact this candidate