Data Developer

Location:

Newtown, PA, 18940

Posted:

September 10, 2010

Contact this candidate

Resume:

Hemanta

*****.*****@*****.***[pic]

EXPERIENCE SUMMARY:

1. SAS Certified Base Programmer with over 6+ years of experience in the

banking, financial and pharmaceutical industry and clinical trials in

analysis, design, development, testing and implementation of Statistical

models and applications in Client/Server environment on Windows and UNIX

environments.

2. Over 4 years of experience in Base SAS, SAS/MACROS, SAS/AF, SAS/INTRNET,

SAS/ACCESS, SAS/STAT, SAS/GRAPH, SAS/ETL, SAS/OLAP, SAS/SQL,SAS/MDDB,

SAS/ODS on both PC SAS and UNIX.

3. Successfully increased portability of existing SAS programs and created

new programs using SAS macro variables to improve efficiency and

consistency of results.

4. Strong experience in data extraction and sorting from various databases

like Oracle, DB2, SQL and MS Access using PL/SQL.

5. Integrated data from different sources (SAS data sets from CROs, CRF

data and electronic laboratory data).

6. Imported data from and exported data to external data sources such as

DBMS tables, PC files, MDB, DBF, Spread sheets and delimited files etc.

7. Experience in developing SAS Procedures, Macros, and application for

data updates.

8. Experience in producing external files and reports employing various SAS

procedures, like Proc Print, Proc Report, Proc Summary, Proc Freq, Proc

Mean, Proc SQL.

9. Command in generating reports and handling of large databases to perform

complex data manipulation using multiple files in SAS datasets.

10. Expertise in using SAS ODS to create HTML, RTF and PDF output files and

Data _Null_ to create ad hoc and customized reports.

11. Generated Listings, Reports, and Tables, Graphs and summaries for

Integrated Summaries.

12. Implementation of data cleaning techniques using PROC FREQ, PROC PRINT,

_NULL_, PROC MEANS, PROC TABULATE, PROC UNIVARIATE, NODUPKEY, PROC SQL,

PROC COMPARE, creating validation data set, restructuring the patients

data set, created macro to check numeric, character, invalid, and

discrete data character values.

13. Developed SAS programs to generate safety and efficacy reports and

extensively used SAS for pre-processing of data, data analysis and

statistical analysis.

14. Working knowledge of RDBMS concepts and implementation using SQL server

as a back-end database server and excellent in writing SQL queries.

15. Created graphs using PROC GPLOT and GCHART permanent formatted SAS data

sets for present and future analysis, infield several data sets and

sorted and merged by common variables.

16. Experience in various ETL tools like Informatica, SAS, and Business

Objects.

PERSONAL ATTRIBUTES:

17. Solid leadership and influencing skills which balance creative yet

practical solutions for the businesses.

18. Excellent verbal and written communication skills which can clearly

articulate complex concepts and ideas to all levels of the organization.

19. Good analytical, conceptual and strategic thinking and planning

20. Team oriented with ability to work effectively with many different

people across many diverse organizations.

21. Ability to identify and manage risks and issues, including appropriate

escalation when needed.

22. Self-starter and able to work independently with minimal supervision

TECHNICAL SKILLS:

SAS Skills SAS (9.1.3) Skills

SAS/BASE, SAS/MACRO, SAS/SQL,

SAS/STAT,

SAS/ACCESS, SAS/ETL, SAS/AF, SAS/LAB,

SAS/GRAPH,

SAS/INSIGHT, PC SAS, ODS (including Proc

Template)

Other Skills

SPSS, SPSS, SAP

Web Technologies J2EE, Java Web Services (SOAP & RESTful)

Frameworks Spring, Struts 1.3, Hibernate, JSF, JUNIT,

AJAX

Programming Languages C, C++, Java, SAS

Java Special APIs Java Mail, JCE, Swing

Development Tools ANT, Eclipse 3.2, Net Beans

Operating Systems Windows (XP, NT/2000), UNIX (Solaris & HP

UX), Linux

Databases SQL, PL-SQL, JDBC, Oracle 10g, DB2, MYSQL

Application Servers Weblogic 9.1, JBOSS 5.0, Web Sphere 7.0,

Tomcat 6.0

Web Servers Sun One, Apache

Software Design Tools Rational Rose, RUP, UML, Agile Methods

CHRONOLOGY OF EXPERIENCE:

Duration: Aug 2009 to Till Date

Client: PROVIDIAN

Role: SAS Data warehouse ETL Developer

Environment: SAS9.2, SAS/Base, SAS/Access, SAS/Macro, SAS/SQL, SAS/Graph,

SAS/STAT, SAS/Connect, PL/SQL, MS Office, Shell, Sync Sort, DB2, JCL, MVS,

UNIX, Windows NT/2000

Description: Providian Financials is a leader in the direct marketing of

credit cards, auto loans and other consumer financial services. The project

involved analysis, development, implementation, and evaluation of a third-

party validation and data cleaning on Transactional data. Task involved

working with very large datasets, developing blocking methods. It also

involved design and implementation of statistical reporting processes,

regular data collection and analysis and team management.

Responsibilities:

. Constructed SAS data sets using match merging, sub-setting, selecting

and summarizing observations.

. Developed SAS reports using DATA_NULL steps and wrote to External

Files.

. Ran several SAS procedures including UNIVARIATE, MEANS, CORR, REG and

TABULATE.

. Developed shell scripts for Data Management and submitting batch jobs.

. Developed application for measuring financial performance of newly

acquired accounts.

. Used proc SQL to extract marketing demographics from a DB2 data

warehouse for model testing, segmentation, scoring, and list

management purposes.

. Processed data collection to ensure proper quality of data.

. Maintained the daily error log for cleaning the data.

. Developed SAS macros for data cleaning, reporting and to support

routing processing.

. Analyzed and interpreted numerical data from various sources.

Organized and summarized data for analysis.

. Developed Macros in shell scripts for performing FTP.

. Ran queries in Informix database using SQL.

. Presented numerical information in various formats.

. Actively involved in design and implementation of application software

using primarily SAS system and analyzed existing application software

and recommended improvements.

. Responsible for locating appropriate databases for projects and

performing relevant analysis.

. Developed batch jobs to run the SAS processes to update the Oracle

database. These processes call PL/SQL procedures to insert data into

Oracle. Developed these jobs based on dependencies and relations

between the processes.

. Involved in development and enhancements of SAS Programs for user

acceptance and generating reports, tables and listing.

July 2008 to July 2009,

Client: Sun Trust Bank, Richmond, VA

Role: SAS Developer

Project: Grant Knowledge -Data Collection Tool

Environment: SAS 9.1: BASE, STAT, GRAPH, MACRO, ODS, SQL

Description:

SunTrust Banks, Inc. is the ninth largest bank holding company in the

United States. Its primary businesses include deposit, credit, trust and

investment services. Through various subsidiaries, the company provides

credit cards, mortgage banking, insurance, brokerage, and capital markets

services.

As a key member of statistical modeling team, developed and ran SAS

programs to support Marketing and Analysis statisticians. Responsible for

creating new SAS code, utilizing existing code, and maintaining data in

SAS. The project involved working with end users and analysts to provide

analysis of credit card customer base on demographical basis and

forecasting risk. The permissions to grant a credit card to an individual

were based on the analysis done. The information of the person applying for

the credit card is gathered and processed for further approval or rejection

Responsibilities:

. Experience in using MDB in order to obtain neutral assessments and

monitored market, credit and operational risks. The market data were

mostly obtained from external commercial sources such as Reuters,

Bloomberg or Datastream.

. Interacting extensively with end users on requirement gathering,

analysis and documentation.

. Developed complex SAS Macros to simplify SAS code and effectively

reduce coding time.

. Imported Data from relational database (ORACLE) into SAS files per

detailed specifications.

. Imported data using LIBNAME and PROC SQL Pass -Thru facility to reduce

processing time.

. Performed complex statistical analysis using PROC MEANS, PROC FREQ,

PROC UNIVARIATE, PROC REG, and PROC ANOVA.

. Extensively used SAS ODS facility to create customized reports in

HTML.

. Interacted with data using the Dynamic Data Exchange (DDE) facility in

SAS

. Performed competitor and customer analysis, risk and pricing analysis

and forecasted results for credit card holders on demographical basis.

Duration: May 2007 to July 2008

Client: Wright Express LLC, Portland, ME

Role: SAS Consultant

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT,

SAS/GRAPH, SAS/ODS, UNIX, WINDOWS 2000.

Description:

Wright Express Financial Services Corporation is a leading provider of

fleet cards to commercial and government fleet Industry. Building Enhanced

Systems and Technology (e.BEST) project was designed for the development of

companys technical infrastructure and applications, which includes customer

relationship management (CRM). My job involved file handling of the

applications, which were written using SAS and run on a UNIX server.

Developed SAS code according to the specifications and developed the ETL to

transform data from legacy systems into conformed, cleansed data using SAS

and SQL. The job also included designing an Online Financial system, which

consisted of maintaining the database for the customers to access, view and

modify their transactions securely.

Role & Technical Responsibilities

. Involved in developing, testing, and writing programs and reports in

SAS according to specifications as required.

. Used SAS/ACCESS to read datasets from, Databases, Flat files, also

read and write other PC File formats into local Data Warehouse.

. Extensive use of SAS/Access, SAS/Connect to connect to various

databases (ORACLE, DB2, SQL SERVER) such as development and production

database (DB2 on UNIX). Also worked on Mainframes, MVS/JCL to read,

modify and edit datasets as per the business needs.

. Performed extraction, transformation and loading from large Oracle

tables.

. Worked on pre-existing macros for data validation by checking data

distribution and comparison to standard data.

Duration: May 2006 to May 2007

Client : Capital One Bank, Mclean, VA, USA .

Role: SAS Developer

Environment: Base SAS, SAS Macros, SAS/Access, Oracle 7.3 and UNIX (AIX).

SAS Procs: Proc Print, Proc Report, Proc Univariate, Proc Mean, Proc Merge,

Proc Sort, Proc Summary and Proc SQL etc.

Responsibilities:

. Developed new or modified SAS programs to load data from the source

and create study specific datasets, which are used as source datasets

for report generating programs.

. Transferred and migrated data from one platform to another to be used

for further clinical analysis. Extracted data from Oracle using SQL

Pass through facility or Libname method and generated

Adhoc reports.

. Developed new or modify SAS programs/Macros to load data from the

source and create study specific datasets, which are used as source

datasets for report generating programs.

. Extensively involved in Oracle PL/SQL programming to create Triggers,

database Packages / Procedures/Functions etc. Creation of database

objects like Tables, Views, and Synonyms etc.

. Prepared, document and test required programs and procedure data

displays in an efficient manner for inclusion in integrated clinical,

statistical summary reports and other reports. Supporting other team

members in designing and developing application programs.

. Write SAS SQL code to develop tool to monitor statistical model

stability, validity, competing risk model, Tansition Matrix, VLM,

automatically creating PowerPoint reports, PDF, and EXCEL.

. Modify existing SAS codes for automation of statistical model

Parameter Vector creation, Retro

Scoring automation, and conduct customer credit risk scoring and model

life dual validation.

. Use JCL pull data from MVS, SAS access from Teradata, data ware

house, clean, transform and manipulate large datasets, perform Ad-hoc

queries and analysis

. Working environment including IBM Mainframe MVS (JCL, TSO, ISPF, IOF,

SDSF),

. Teradata, SAS9.1.3 (Base SAS, SAS Macro, SAS Stats, SAS ODS, SAS AF).

Duration: Dec 2005 to May 2006

Name : Global Exchange Matching System GeMS

Client: Macquarie Bank Ltd, Sydney, Australia

Role: Java Developer

Environment:

Languages : Java(J2SDK1.5.0), J2EE

Database: DB2, SYTEST.

Tools : Edit Plus, AQT, Test Track Pro

O/s : Windows XP

Application Server: IBM Web Sphere

Description:

Macquarie Bank Ltd (MBL) is the only independent Australian full service

investment bank. It has been providing financial services to its clients in

Australia and offshore and is into different financial services including

Treasury and Instruments trading mainly futures and Options. The Futures

division of this bank has two business viz.; execution and clearing. Our

clients imports trades from the exchange either offshore or ASX or SFE, and

allocations from its clients and performs Matching and Allocation. The

present system is in such a way that there are different applications to

import trades from different exchanges and perform the matching/allocation

process. Global Exchange Matching System i.e.GEMS will address the

replacement of these applications into a single integrated application.

This will be implemented in two releases to the client.

Global Exchange Matching System Data Base Management :

On the basis of space allocation in the devices I distributed the databases

accordingly. In the database, users have to be created by the database

administrator.

Contributions:-

1. MANAGING DATABASE:

The database owner can transfer the ownership to others. In this process we

restricted the users from using some specific tables. As a Database owner

or system administrator I was responsible for giving this permission.

There were 5 databases in GeMS Application

1. TESTR2

2. TESTDB

3. SYTEST

4. SYBASE

5. GCSDEV

These were in the Windows Platform.

CARMA and GEMSR1 databases were in Solaris platform.

2. BACKUP:

We already created some devices for backup. Everyday I had to take the

backup in that.

3. MAINENANCE:

Weekly basis we have done DBCC (database consistency checking) and update

statistics. It will check the page allocation properly done or not and also

the page linkage between one page to another page. Update statistic used to

segregate the data properly in the database order. The Update statistics

report has to be saved in SYSTABSTAT (column level) and SYSSTATISTICS (row

level).

4. MONITORING DATABASE:

Through SYBASE Central (kind of tool) we used to monitor the database.

Duration: Apr 2005 to Dec 2005