Chetana Ray
Cell-734-***-********
acqe9i@r.postjobfree.com
SUMMARY
Experience in Advance and Base SAS with Over 8 years of robust professional work experience in Data Cleaning, Data Aggregation, Data Mining, Data Analysis, Application Development and Reporting with SAS
Understanding of the client’s vision, goals, limitations, data sources and time lines
Firm grasp over understanding of business needs and strategies to develop reliable and effective solutions
Firm understanding of Proc Olap and Proc Infomap to deliver solutions meeting complex business needs
Extensive experience transferring data across platforms (Mainframe, Unix, PC) based on the business and reporting needs
Vast experience in presentation using SAS, Excel, Pivot Tables and Vlookup, DDE for presenting the end results
Proven skills in SAS Base (data step and proc) and SAS Macro fulfilling on demand business needs
Advanced SQL skills with ability to code complex queries to load, clean, format & store data
Clear understanding of data modeling principles like star and snow-flake schema, dimensional data model, 3nf etc.
Designed several ETL jobs using SAS DI Studio to port the ODS data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging the final data
Ability to code complex MDX code for OLAP cubes to have a tradeoff between storage space and performance
Experience in SAS/STAT with linear and logistic regression, ANOVA, DOE, Clustering etc. to gain insight into the data
Skilled in analytical and business reporting using SAS, MS Office, VBA and RDBMS technologies
Conceptual knowledge of marketing mix, segmentation and association rules, market basket analysis, test and control groups, sample size criteria, hypothesis testing etc.in marketing domain
Experience in loading SAS Metadata Server with metadata from external packages for ETL development
Involved in preparing and reviewing BRD, FRD documents to serve development and reporting
Experience in coding mathematical expressions in SAS as per the requirement using legacy and new functions
Extensive experience in Teradata tools & utilities like SQL Assistant, BTEQ, FastExport & TPump for business analytics and reporting on massive Enterprise Data Warehouse
Strong skills in requirements gathering, analysis and ETL design, coding, debugging
Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
Completed several projects with accountability for design, development, and implementation of enhancements which involved secure data transfers to external vendors
Involved in projects having to deal with cross functional teams and multiple stakeholders
Minimum time to self-sufficiency in any environment
Excellent communication and report writing skills, with the ability to effectively communicate results of analytics to diverse audience
EXPERIENCE
Data Analyst /SAS Developer
Fannie Mea New York City, NY
May`14 – Feb’15
Responsibilities:
Wrote advanced SAS programs involving macros, SQL joins, merges, prompts and building Enterprise Guide projects.
Using Query data user interface in ECM, defining process and creating multiple automated workflows for varies type of cases- fraud, security Etc.
Created dashboards reports to users using TABLEAU by connecting to various data sources (Oracle, XLSX, CSV, ParAccel,DB2). Build the TABLEAU Dashboard utilizing complex calculated field, table calculations, filters, parameters. Generated context filters and used performance actions while handling huge volume of data.
Developed Information Maps, OLAP cubes and based on project requirements.
Experienced with extensive debugging of SAS codes to identify the issue.
Participated in peer code reviews and validated SAS code, Tableau dashboard deliverables
Performed unit testing on Stored Processes and newly developed SAS programs.
Translated user data and reporting requirements into SAS programming language.
Assisted the SAS User Coach to develop content for the SAS Training including Exercise Manual, SAS Datasets, EG projects, Information Maps.
Performed ad hoc querying, reporting and data management.
Build standard and custom reports for distribution to internal and external customers/users.
Coordinated with users and managed the deployment of content, code, and configuration changes to schedule production loads/jobs.
Worked with relational databases such as Oracle, Sql server, MS-Access and SAS storage server SPDS.
Worked with different kinds of mortgage data including Advances, Third party sale, Modifications, Penalties, etc.
Environment: SAS 9.2, SQL Server, Microsoft Office Suite 2010 Microsoft Excel, MS Access, Unix.
Senior SAS Application Developer
July’13–Mar’14
JPMorgan Chase & Co. Westerville, OH
Risk Model Optimization- Modeling Data Infrastructure & Technology (MDIT) team within the Chase Home Lending - Risk Modeling & Forecasting organization develops infrastructure for modeling and forecasting teams which includes designing, developing, deploying, and maintaining analytic applications and data structures needed by modeling and forecasting teams. It performs analytical/quantitative projects on credit risk issues impacting the portfolio.
Responsibilities:
Efficiently accessing /pulling loan-level data from multiple internal and external sources (EDW data warehouse) using different SAS techniques.
Optimize existing process/Code.
Automate process using Shell Scripting and SAS.
Producing reports summarizing portfolio credit performance.
Process analysis and process improvement.
Creating technical and user documentation.
Identifying innovative techniques and developing utilities that can increase the speed and efficiency of the modeling tool set.
Document and communicate model results and insights to senior staff in Chase Home Lending Management.
Environment: - SAS v9.2, SAS/MACRO, SAS/SQL, SAS/Connect, SAS/ACCESS, AIX 5.3, Windows XP, Enterprise Guide 4.2., UNIX Shell scripting, DB2, EDW, Oracle.
SAS BI Developer
NPD Group, Port Washington, NY Feb’12-May ‘13
Company Overview: NPD Group, headquartered in Port Washington, NY, is the leading global provider of consumer and retail market research information for a wide range of industries. NPD provides critical consumer behavior and point-of-sale (POS) information and industry expertise across more industries than any other market research company. Through its consumer panel & retail sales tracking services, it helps clients understand and profit from consumer and retail trends by telling them who is buying, what, where and why at the international, national and store levels.
Involved in developing data-quality (DQ) system and custom market research (MR) dashboard reports in SAS domain. DQ system consists of multiple business lines with data loading varying from weekly to monthly time period. For certain business/frequencies, the DQ needs to be performed after ‘Load Complete’ as well as ‘Go Live’. MR reports are developed for clients containing high end, critical and multi-faceted analysis of performance of product/brand/category/segment etc. in the varied industry sectors like Apparel, Beauty, Technology, Auto etc.
Responsibilities:
Extensively used Proc OLAP to generate cubes for DQ and custom reporting
Adeptly performed Data Management for the Business Unit: data profiling and cleansing of business unit's assets data using SAS.
Developed SQL queries to fetch data from schema of terabyte range
Developed Cubes using formats replacing aplha to conserve disk space for input tables
Used Excel and call execute routine in SAS to generate Proc Olap code having ease of maintenance
Served as a direct point of contact with the end user to understand the requirement and develop technical solutions to deliver in terms of quality, time and accuracy
Produced reports in excel using SAS add-in, Proc Report and ODS Tagsets
Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis using SAS and Excel
Developed SAS stored procedures and views to provide BI analysis and insights
Involved in developing and maintaining documentation of operational processes and data mappings
Used ProcMetalibas well as SAS SMC to configure/alter information of datasets/views/
Tables.
Developed several reports using SAS Information Map studio to be presented in Excel as well as Web reports
Extensively used Proc SQL and SAS Macros for application automation
Extensively used SAS Dictionary tables and Proc Metadata to get real time information for SAS datasets
Used Excel templates and VBA to generate custom reports from data in SAS tables
Extensively involved in mainframe SAS for analyzing very large datasets
Involved in fine tuning the code to reduce the churn time and improve the efficiency
Coded extremely complex SAS Data step and procs including the advanced techniques and the use of the available options to serve the ever evolving and dynamic business reporting needs
Extensively used proc tabulate, proc rank, proc transpose in developing custom reports
Involved in aggregating data residing on the vast network of distributed servers with all forms of data storage
Exported large SAS data sets (more than 300 variables) to MVS external files to be sent to external vendors using SAS and SAS/Macro
Hands on experience in moving SAS data sets from Unix to PC environments using FTP
Used Meta Engine as well as SQL Pass thru method to load the manipulated data from external tables into SAS data sets
Environment: SAS ENTERPRISE GUIDE, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Reports Studio, SAS Add In, SAS/SQL, SAS/MACROS, SAS/BASE, SybaseIQ, VBA
SAS Programmer
GMAC Horsham, PA Aug’11-Jan’12
The Project was to build a Mortgage accounts management system. My responsibility was to provide various adhoc mortgage service requests such as Current Account Balance, Payment History, Tax and Insurance Data, Online Payments, description of mortgage product and its tenure to the team and clients as per request.
Responsibilities:
Understood the system use cases and UML diagrams based on the functional business requirements.
Worked with importing external data files and dealing with missing data and data anomalies in SAS data sets and raw data files.
Generated new datasets from imported raw data files using Import Techniques and modified existing datasets using SQL, Set, Merge, Sort, Update, Formats and Functions.
Imported data from flat files, oracle database using libname as pass through facility as per necessity; created analysis SAS datasets
Generated SAS batch programs and generated log files, list files and reports in desired directories by passing parameters using UNIX shell scripts.
Performed data management functions including manipulation, validation, review and export to database, missing value were read using MISSOVER and TRUNCOVER options.
Proficiently used SAS system macro for data stamping of log files and collection of files to a given directory and scheduling.
Created customized reports using DATA _NULL_ technique, created Analysis datasets, and performed validation before report generation using base SAS programming.
Performed data cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, PROC RANK, and macros in SAS.
Involved in preparing UAT Plan based on User Requirements Document (URD) and prepared the UAT Cases and UAT Procedures.
Experienced in Validation, documentation and testing component programs in an efficient manner for inclusion in integrated reports.
Transferred and Migrated Data from one platform to another for further analysis, developed, analyzed and designed SAS programs in UNIX platform.
Generated SAS data files, graphical reports and summary statistics, developed standard reports and document writing.
Involved in extracting, analyzing and clustering financial data using procsql, proc summary, Proc report, data _null_.
Created SAS Programs to bulk load the data and transfer data tables using SAS/ACCESS and SAS 9.2.
Extensively applied dataset merging, macro facility, Proc report, SAS functions, and SAS formats also to analyze data gaps for dollar amounts in the source system.
Performed data analysis, data migration, data preparation, graphical presentation, statistical analysis, reporting, validation and documentation.
Generated customized reports to help business users in understanding risks with ease and accordingly optimize performance.
Developed reusable Macro programs for convenient use from time to time.
Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.
Provided day to day support to the Business Users while User Acceptance Testing (UAT) for which created various test cases and test scripts and expected results set addressing the business requirements
Documented defects arising out of coding, testing, organized them in Quality Center and maintained traceability back to requirements in Requisite Pro.
Scheduled and performed exhaustive Test Reviews with the Requirement Leads, Rule Leads, Test Leads, and Business Owners to identify defects and seek signoffs.
Developed and maintained Excel Reports on an adhoc basic. Development, maintain and automate the report using different excel functions, creating crucial reports.
Environment: Base SAS, SAS EG, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS Macros, Rule Admin,MS Office Suite 2010,, Rapid SQL, Oracle 10g, Windows XP, Unix
Senior SAS DeveloperAug’10 –Nov’11
Deloitte Services LP, Nashville TN
JEDAR -Journal Entry Data Analysis Routines is a methodology that uses exploratory data analysis procedures to test journal entry populations with the objective of profiling journals, identifying unusual items, and selecting items for testing.
Responsibilities:
Lead the SAS team in gathering requirements, coordinating weekly meeting with the users to discuss issues and provide solutions.
Capturing User Requirement using technical specs.
Responsible for proper coding, documentation and validation of SAS programs/macros/procedures to produce the standardized data display.
Developed and Validated SAS reports.
Production Support.
Used extensively Base SAS, SAS/Macro, SAS/Graph, SAS/SQL,SAS DDE, SAS/Connect Batch UNIX jobs and Excel to develop codes generate various analytical reports to be shared with Business user’s
Developed report to capture performance statistics.
Work with various teams to enhance performance of JEDAR Application.
Environment: - SAS v9, BASE SAS, SAS/ MACRO, SAS/ SQL, SAS/Connect, SAS GRID Manager, SAS DDE,AIX 3, Excel, Windows XP,VBA, MS EXCEL,SAS Enterprise Guide 4.1.
Clinical SAS Programmer Nav’08 – June’10
Becton Dickinson, NJ
Description: BD is a medical technology company that serves healthcare institutions, life science researchers, clinical laboratories, industry and the general public. BD manufactures and sells a broad range of medical supplies, devices, laboratory equipment and diagnostic products.
Responsibilities:
Perform SAS programming to provide data review complex listings/reports to support Data Management function for Oncology during Phase I and Phase II trials.
Identify statistical and programming needs and use standard and customized SAS programs and macros
Successfully designed and implemented statistical reporting processes for regular data collection and clinical data analysis.
Understanding CDISC structure for both CRF datasets (SDTM) and analysis datasets (ADAM)
Developed and maintained programs in SAS using SAS tools for Windows in a user support environment.
Merging and sorting of data collected at different time intervals.
Performed statistical data analysis, generated ad-hoc reports, tables, listings and graphs using tools such as SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL and SAS/STAT.
Performed documentation on all programs, files and variables for accurate historical records and for future reference.
Performed reporting, validation and documentation in compliance with FDA
Extensively used SAS/Macro facility to provide reusable programs that can be conveniently used time to time.
Produced quality customized reports by using PROC TABULATE, PROC REPORT, and PROC SUMMARY and also provided descriptive statistics using PROC MEANS, PROC FREQ and PROC UNIVARIATE.
Performed testing, documentation, review, and verification of all programs according to SOPs.
Performed sorting and merging techniques on the input data sets for Data Preparation.
Cleaned, transformed, analyzed, and presented clinical data using PROC SQL.
Environment: SAS Base 9, SAS/Graph, SAS/ Macro, SAS/Stat, Windows
Clinical SAS programmer Sept’06-Oct’08
Athero Genics, Inc. Alpharetta, GA
Project: Athero Genics, Inc. is an emerging pharmaceutical company mainly focused on discovery, development and commercialization of novel pharmaceutical products that address the critical unmet need in treatment of chronic inflammatory diseases including atherosclerosis and diabetes.
Responsibilities:
Involved in mapping of CDISC/SDTM model to convert legacy data to SDTM standard.
Created the mapping specification and flow chart according to requirement.
Created metadata and data definition tables as per the requirements.
Used M.S. Excel for SDTM mapping specification.
Implemented data transformation according to CDISC/SDTM standards.
Performed edit check in created SAS dataset using different SAS procedures.
Involved in phase I to III of the clinical trials related to atherosclerosis.
Typical responsibilities were includes import data from source, reading the raw data and creating the Datasets for further analysis.
Worked in mapping of clinical trial data from company standard to CDISC standard.
EDUCATION
Master in Mathematics, M S University
Associate in Computer Information Systems Programming, Schoolcraft College
Associate in Web Design, Schoolcraft College
CERTIFICATIONS
Base SAS Certified Programmer -2015
Microsoft Certified Professional Solution Developer
Microsoft Certified Professional
COMPUTER SKILLS
Languages
SAS,JAVA, Microsoft C,Microsoft C#, Microsoft Visual Basic,Html,Xml,
Java Script
Other Applications: MS Visio, MS Word, MS Excel, MS Power Point, MS Access., Illustrator, Photoshop, Flash, Dreamweaver.
Software
Database: Microsoft SQL Server and Microsoft Access
Platforms: Microsoft Windows® XP and Microsoft Windows 7/vista Unix