CHAITALI DATTA

SAS Programmer/DATA ANALYST

acbaju@r.postjobfree.com

718-***-**** (cell) USA

Objective: Seeking an opportunity to leverage my knowledge and technical skills in data

mining/analysis using quantitative/statistical methods in the retail/financial/insurance

industry.

SUMMARY:

Expertise in data mining, transformation, and analysis.

Expertise in building customized code in SAS, SQL or other data-mining / ETL tools.

Experience in working with large scale corporate datamarts, and resolving inconsistencies and

challenges that can exist across varying data structures.

Familiarity in enterprise data systems and databases such as Oracle, DB2 and Teradata.

Ability to use business judgment to guide analysis, draws implications from analysis, and

synthesize into clear communications.

Experience with Credit Card data from TSYS.

Develop segmentation & business analyses, using SQL/SAS in a large data warehouse

environment.

Experience with analysis and development of business logic and system needs to prepare

dataflow diagrams and documentation and identified new pattern/trends, underlying principles

and relationships in datasets.

Data mining techniques to analyze and explore large datasets collected from simulation

runs of models built using (model building simulative software).

Analysis and exploration of datasets using quantitative methods, exploring the ergodic behavior

of a system and analysis of stationarity of the system.

Can comprehend functioning of retail business, financial markets and effect of macro

economic variables.

Excellent communication and interpersonal skills. Proven record in problem solving and business

innovation. Comfortable in a fast and dynamic environment, self-motivated with ability to

manage multiple tasks simultaneously.

Technical Skills:

SAS 8/9, SAS/BASE, SAS/MACRO, SAS/SQL, SAS ODS, SAS/ACCESS, SAS

SAS Tools: Enterprise Guide, SAS/STAT, SAS/XML.

Languages: C, SQL, Minitab, FORTRAN, Matlab

Office Tools: MS Excel, MS Word, MS PowerPoint, MS Visio

RDBMS: Oracle, Sybase, MS Access, MS SQL Server,Teradata

Operating System: Windows 98, 2000, NT, XP, Unix, AIX

EDUCATION:

MS in Statistics University of South Carolina USA. Aug04-Aug06

MSc in Mathematics Visvabharati INDIA. Aug97-Aug99

CERTIFICATIONS:

SAS Base Programming Exam for SAS 9.1.3. USA.

SAS Advanced Programming Exam for SAS 9.1.3. USA.

EXPERIENCE:

List Processor(Sas Developer/Programmer Analyst)

Client: CHASE Card Services, Wilmington DE. Oct 09 – Present

This position is a position in the marketing services execution department. The main task is to

provide excellent business, application analysis and implementation support as it relates to Credit

Card products and services.

Responsibilities

• Develop code for execution of marketing campaigns and provide audits to the marketer.

• Maintain programs through implementation, debugging and fixing.

Provide SAS/SQL coding based on business requirements

• Improve processing efficiency using Unix and SAS

• Creation of reports in excel, text, html to be sent to the vendor.

• Provide business analysis and solutions to the end client.

• Interpret and analyze the output from run the engine programs.

• Collaborate on projects with associates and business leaders from multiple groups

within the organization.

• Drive standardization and automation in analysis and reporting.

Programmer Analyst Apr08 – Nov08

Client: JPMorganChase, Chicago, IL

This project was to support the conversion of customer pricing from the existing Treasury

Services International billing system to CAP9.0. It also supports price modeling for other billing

initiatives.

Responsibilities:

• To download data from flat files and convert to sas datasets.

• Document data elements and files and track down reference tables where necessary.

• Perform data transforms and joins to create necessary data views.

• Maintained and enhanced pricing models according to business needs. (Price models

were mathematical models.)

• Adapt existing SAS code and create new code for price modeling in accordance with the

conversion requirements.

• Created new programs and modified existing programs according to business needs.

• Created new programs by extracting macros from existing programs and combining

together into new routines.

• Created CSV data files to be used for data import routines.

• Performed integrity checks.

• Validated the pricing models. Created new variables according to business requirements.

• Validated the output.

Environment: SAS/BASE, SAS/MACROS, Excel, UNIX/AIX., HTML, XML

Client: Cisco Systems, San Jose, CA Apr07-Oct08

SAS Programmer

The project included extraction of large bookings datasets from Oracle databases and automation

of a forecast model developed by the analytical forecast practitioners at Cisco Systems. It also

involved creating data flow charts, documentation, extensive testing of the newly developed

forecast model. The project also included running monthly and weekly jobs like extraction, pid

analysis and running the forecast model to generate forecasts of Cisco bookings.

Responsibilities:

• Extracted data from Oracle databases using Proc SQL and SAS/ACCESS on Windows

platform.

• Defined and documented business processes and work flow diagrams using MS Visio

and Microsoft word.

• Automated user defined dates and moving windows used as smoothing parameters within

a forecast model.

• Worked on efficiency of the codes of forecast models.

• Worked closely with users and forecast practitioners to develop applications and reports

as per requirements.

• Used SAS system macros for error handling, code validation, date stamping of log files,

collect files to a given directory and scheduling.

• Supported the development of forecast models.

• Used proc arima, proc expand, proc forecast and exponential garch models to forecast

CISCO products.

• Used sales data of CISCO to forecast future sales of CISCO products.

• Used SAS/BI to do reporting, query and analysis.

Environment: SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/ETL

Oracle8, SAS ENTERPRISE MINER, SAS TEXT MINER, Window 2003, XML.

University of South Carolina, Department of Statistics, Aug 04-Aug06

Columbia, South Carolina

Supervised two undergraduate level statistics laboratory classes each semester.

Tutor at statistics help center

Worked in STATLAB in Summer 2005

Masters Thesis Topic: Modeling of Nonlinear datasets.

University of Dortmund, Germany 44221 May 01-Aug04

Research Associate

Worked in the field of Quantitative and Computational Methods as a Research Associate in

Dortmund University.

It included analysis and exploration of datasets using quantitative methods, exploring the ergodic

behavior of a system and analysis of stationarity of the system.

Environment: UNIX, Sun Solaris, R and simulators HIT and APNN tool box.

Member of SFB-559, Germany Aug01- Aug04

The project included analysis and modeling of large logistic networks. It involved working with

Computer engineers to provide data mining techniques to analyze and explore large datasets

collected from simulation runs of models built using Arena/HIT (model building simulative

software). Mathematical models were built of real life problems using Process Chain notations.

The main responsibilities were problem formulation, identifying the short and long term

objectives of the model, decision variables and control parameters, data collection from

simulative runs, validation and tracking of performance metrics, visual representation of results,

testing, analysis and interpretation of results. It involved using and developing various

exploratory data analysis techniques to get a better insight of the dataset

Regional Computer Center, Calcutta Oct 99-Dec00

Developed a Pension scheme of Calcutta Municipal Corporation using Developer 2000 and SQL

VISA STATUS, USA

Present status: H1-B holder

H1b holding company: OPEN SYSTEMS TECHNOLOGY

Contact this candidate