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
• 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
• 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
• 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
• 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.
• 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
• Vast experience in presentation using SAS, Excel, Pivot Tables and Vlookup, DDE for presenting the end results
• Excellent communication and report writing skills, with the ability to effectively communicate results of analytics to diverse audience

TECHNICAL SKILLS

Languages: SAS, JAVA, Microsoft C, Microsoft C#, Microsoft Visual Basic, Html, XmlJava Script

Other Applications: MS Visio, MS Word, MS Excel, MS Power Point, MS Access., Illustrator, Photoshop, Flash, Dreamweaver.

Database: Microsoft SQL Server and Microsoft Access

Platforms: Microsoft Windows® XP and Microsoft Windows 7/vista Unix

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. SAS Developer

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 and 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.
• Coordinatedwithusersandmanagedthedeploymentofcontent,code,andconfiguration 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.

Confidential, Phoenix, AZ

Senior SAS Application Developer

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.

Confidential, Rocky Hill, CT

SAS Developer

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 Proc Metalib as 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

Confidential, Horsham, PA

SAS Programmer

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 proc sql, 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

Confidential, Detroit, MI

SAS Developer

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.

Confidential, Chattanooga, TN

SAS Programmer

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