SUMMARY

• Sr. Data Analyst, SAS Programmer with 9 years of professional experience in the area of data analysis, decision support solutions and reporting in various projects for Banking, Financial and Healthcare industries.
• Experience in Base SAS, SAS/Macros, SAS/SQL, SAS/STAT, SAS/Access, SAS/GRAPH, SAS/ODS and SAS Enterprise Guide,.
• Experience with PROC SQL, writing queries, using Left Join, Right Join, Outer Join and Union.
• Strong expertise in reporting and summarizing data using PROC REPORT, PROC TABULATE, PROC SUMMARY, PROC MEANS and PROC FREQ.
• Knowledge on SAS efficiency techniques and experience in handling huge volumes of data
• Strong understanding in various SAS STAT techniques such as ANOVA, Pearson chi - square test, T-Test, Correlation and Regression Analysis
• Experience in accessing RDBMS databases such as Oracle, Teradata using TOAD and Oracle SQL Developer, Teradata developer, SQL Server and SAS/Access facility
• Extensively worked on SAS views and SAS Indexes to reduce I/O bottlenecks and processing time for large volumes of data.
• Proficient in using Import and Export procedures to handle data in raw text format, ORACLE and DB2 database management systems.
• Experience in multiple databases such as Oracle Server, DB2, MS SQL Server, and MS Access
• Proficient in using ODBC to connect SAS System with relational database management systems, such as Microsoft SQL and Oracle, to retrieve data and create SAS datasets
• Knowledge in using SAS/ACCESS to Export, Transfer and Load (ETL) data from ERP packages
• Knowledge in data warehousing and business intelligence concepts, design principles experience in RDBMS development including SQL, PL/SQL, languages.
• Quality Control, Execution, and Maintenance (Debugging, Enhancements and Testing) of all delivered Production Code.
• Experience in using SAS to create reports from relational database or multi-dimensional cubes.
• Ability to work in fast paced environment with little or no documentation, able to employ new ideas, concepts, methods, and technologies
• Strong analytical, diagnostic skills and ability to work in a fast-paced and team-oriented environment.

TECHNICAL SKILLS

Statistical Software: SAS v 9.x, SAS/Base, SAS/Stat, SAS/Graph, SAS/SQL, SAS/Access, SAS/ODS, SAS/Macros, SAS/Connect

Operating System: MS Windows /98/2000/XP/7/VISTA, UNIX

Languages: SAS, SQL

SAS Procs: SQL, REPORT, MEANS, UNIVARIATE, CORR, REG, TABULATE, FREQ, CHART, SORT, SUMMARY, CONTENTS, FORMAT, IMPORT AND EXPORT, APPEND, TRANSPOSE, ANOVA, PRINT

MS Office: Word, Excel, PowerPoint, Access and Outlook

Database: Oracle, DB2, MS Access

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Sr. SAS Developer/Analyst

Responsibilities:

• Responsible for analyzing various database (DB2 & Teradata) containing product, sales, transaction, demographic, loan, account, region, banking, and billing data to create a list of risk and non-risk customers.
• Used SAS/Enterprise Guide to analyze Banking Habit data (Online Banking, Walk In Banking, Mobile Banking, Tele Banking, and Drive In Banking), Loan data (Home Loan, Student Loan, Car Loan, and Business Loan) to identify the risk involved.
• Extensively worked with commercial customer data using hash objects and joining data set, indexing, data aggregation, sub-setting, creation and modification of views, accessing multiple databases. Modifies macros for report generation using SAS/Macros as per the requirements.
• Used SAS procedures like Proc SQL, Proc Freq, Proc Sort, Proc Report, Proc Means, Proc Compare, Proc Summary, Proc Univariate, Proc Tabulate, Proc Datasets, and Proc Corr to performed advance statistics on consumer datasets and to create customized reports of a preferred list of customers as per the given requirements from businesss analysts.
• Developed Stored Processes to distribute reports and in a secure manner.
• Created reports in the style format (RTF, PDF and HTML) using ODS statements.
• Actively involved in designing and developing daily, weekly, monthly, quarterly and yearly ETL (Extract, Transform and Load) processes by SAS DI Studio for different business streams and wrote complex Korn Shell script to automate ETL processes and send out a notification emails to concerned people.
• 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 using macros debug options like Merror, Serror, Mlogic, Mprint and Symbolgen.
• Created new datasets from raw data files using data infile & input statement, and modified existing datasets using Set, Merge, Sort, Update and conditional statements.
• Developed SAS based applications for measuring financial performance of newly acquired accounts: Forecast Vs Actual.
• Developed adhoc-reports as per business requirements and created various reports like summary reports, tabular reports.
• Developed Macros in Shell Scripts for Data Management, Submitting batch jobs and Performing FTP

Environment: SAS/BASE 9.3, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/MACRO,SAS/EG, SAS/ODS, SAS/ACCESS and SAS/CONNECT, IPSwitch, PVCS, Reflection, Putty, SQL Server Management Studio, TERADATA, DB2, SQL Server 2008, Windows XP, Unix Sun Solaris.

Confidential, Richmond VA

SAS Developer

Responsibilities:

• Prepared customized reports to help client provide a strong competency in understanding risk and accordingly perform better customer selection and customer satisfaction.
• Performed statistical analysis of financial and operational data and used SAS/ACCESS to extract data from different relational database management (Sybase, DB2, and SQL SERVER) systems.
• Performed extraction, transformation and loading from large Sybase tables.
• Manipulated existing Sybase database by accessing the data using SQL pass through facility.
• Created and maintained SAS jobs to perform ETL for auto loan related data across relational databases (SQL Server, Teradata) or datasets/flat files in various operating systems (Windows/Unix) using SAS/Access, SAS/Connect, and created field-specific datasets for reporting purpose.
• Optimized production SAS jobs by reduce I/O bottlenecks and processing time for large volume of data, using incremental approach, index, SAS views, etc.
• Automated SAS jobs triggering by UNIX shell script/Windows Task Scheduler/SAS Platform Process Manager for recurring jobs, and by creating specific events detecting scripts for non-recurring jobs.
• Read datasets with a lot of missing values using MISSOVER and TRUNCOVER.
• 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.
• Extensively used the SET, UPDATE and MERGE statements for creating, updating and merging various SAS data sets. Wrote complex SQL queries to update existing SQL tables.
• Performed Consumer profiling, Sales forecasting and testing.
• Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Extensively used Data Null and SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary and Transpose for producing ad-hoc and customized reports and external files.
• Generated high quality reports in the form of listing, TXT, HTML, RTF, EXCEL and PDF formats using SAS ODS.
• Supported and developed a management reporting system, which used a web, front end to generate user queries.

.

Environment: SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACRO, SAS/IML, SAS/EG, SAS/ODS, SAS/ACCESS and SAS/CONNECT, IPSwitch, PVCS, Reflection, Putty, WINSQL, SQL Server Management Studio, Korn shell, Sybase, DB2, SQL Server 2008, Windows XP, Unix Sun Solaris.

Confidential, Northbrook, IL

SAS Developer/Business Analyst

Responsibilities:

• Retrieved tables from Oracle and DB2 databases using SQL Pass through Facility. Ensure all required data has been extracted from server for process.
• Extract the data from Server and modified by using BASE SAS, SAS/SQL and SAS/MACROS in test Environment
• Follow the program shell and based on Requirement call to required macros which are already in Macro Library.
• Tested and debugged existing macros by system option.
• Create Client targeting Setup by Updating the macros and use the logic to check the current client is migrated client or not. Create the migration indicator to capture the claims history for a client connect migrated client.
• Create the Error handling macro which notifies to support team of any error encountered during Execution.
• Provided descriptive statistics using PROC MEANS, PROC FREQUENCY and PROC UNIVARIATE.
• Generate Tables and Graphs using various procedures like PROC REPORT, PROC UNIVARIATE, Data NULL, PROC PLOT, PROC GCHART and PROC GPLOT.
• Created complex and reusable Macros and extensively used existing macros and developedSASPrograms for Data Cleaning, Validation, Analysis and Report generation
• Used SAS/STAT for Statistical Analysis, procedures and reports and Produced quality customized reports by using PROC REPORT.
• Used SAS/ODS to create HTML, RTF and PDF outputs files in the process of producing reports.
• Add the new columns as per the business requirement by modifying the existing macros and regular mailing programs.
• Give the status of work in Everyday status meeting to lead of the Project and send weekly status report to Project Manager.

Environment: SAS/BASE, SAS/ODS, SAS/Connect, SAS/MACRO, SAS/STAT, SAS/SQL, ORACLE, Access, Excel, DB2.

Confidential, FL

SAS Analyst

Responsibilities:

• Responsible for extracting the data, cleaning, manipulating, transferring and managing data in SAS.
• Experience in entering, analyzing and coordinating data, generating tables, listings, graphs, and reports.
• Extracted data from Oracle table, performed quality checks, validated the data, and created SAS datasets. Modifying data using SAS code by importing, sorting, merging, and restructuring.
• Analyzing the data sets, Generating statistical reports using PROC tabulate, PROC report
• Experience in data transformation and edit checks.
• Performed quality checks on the existing table, listing and figures, Tested and debugged SAS programs against data.
• Used SAS PROC SQL to extract data from different relational database management (Teradata) systems.
• Also cleaned the data using SAS code (SAS Macros) and develop SAS Code on UNIX according to the specifications.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS/Base, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Performed Data analysis mainly using Regression and ANOVA (Proc REG, Proc GLM, and Proc ANOVA).
• Conducted meeting with business users and data architects.
• Validated and maintained status on quality control document for the team, validation has been performed as specified in the QC tracking sheet.
• Generated safety, efficacy, and graphs as mentioned in the template and validated as per the QC tracking sheet, used SAS Output Delivery system (ODS) for generating reports in specific output formats like RTF, PDF, and HTML.
• Using SAS Output Delivery system (ODS), generated reports in specific output formats like RTF, PDF, and HTML.
• Debugging and correcting the syntax and semantic errors in the code.
• Read datasets with a lot of missing values using MISSOVER and TRUNCOVER.
• Created reports in the style format (RTF, PDF and HTML) using SAS/ODS.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/ACCESS, SAS/GRAPH, SAS/ETL, SAS/ODS, PL/SQL, MS Office, Teradata, Oracle9i, Windows XP.

Confidential, Boston, MA

SAS Developer/Business Analyst

Responsibilities:

• Involved in extracting, analyzing, and clustering investors data based on their demographic profile. Also involved in the analysis of Marketing and Sales data, performed Retrospective
• Analysis on sales data to analyze and summarize the differences in amount of commission paid.
• Worked closely with client management solutions team, marketing team, sales team to understand customer needs, gather business requirements and document them in appropriate format.
• Produced reports using PROC GCHART, PROC REG, for analysis and used UNIVARIATE and MULTIVARIATE ANALYSIS as Forecasting Methodologies, also used the SAS Forecast Studio for speedy analysis of Forecast Models.
• Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and PROC SQL .
• Assisted in investigating and applying new SAS programming methods using SAS Business Intelligence and techniques to enhance current systems by using various SAS Macros and standard programming procedures.
• Analysis included data reports, generalized reports, SQL queries to Netezza and DB2 platform, variable distribution reports for clients as well as vendors
• Documented methodology, data reports, and model results, and communicated with project team/manager to share knowledge.
• Worked with large data sets (15+ million records) using Pass Thru SQL technique.

Environment: SAS/BASE, SAS/MACROS, SAS/STAT, SAS/ETS, SAS/GRAPH, SAS/Enterprise Guide, MS Excel, MS Project, MS Access, Reflection X, Oracle 8.0, Teradata, DB2, WINDOWS 2000/NT/XP, UNIX.

Confidential, CA

SAS Business Analyst

Responsibilities:

• Conducted thorough analysis on historical data to generate seasonality of demand index profiles.
• Analyzed past data to generate granular price elasticity of demand values and associated reports to aid business decisions regarding promotions and investment therein.
• Spearheaded the requirement gathering, development and testing phases of the YMR Project.
• Performed extensive regression and statistical data analysis using Proc REG, Proc GLM, Proc ANOVA.
• Performed extraction, transformation and loading from large Teradata tables.
• Implemented Set, Merge and SAS/SQL to perform suppressions and exclusions on the data.
• Optimized, automated and productionalized daily / weekly / monthly scripts for increased efficiency and intelligence.
• Generated web based reports via Web Report Studio to enable users and decision makers across the enterprise with self-sufficient access to consistent, accurate data and the predictive power of SAS analytics.
• Generated output using SAS/ODS in CSV, XLS, DOC, PDF and HTML formats.
• Developed reporting procedures using PROC REPORT and PROC TABULATE.

Environment: Windows, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS BI, SAS Web Report Studio, SAS Enterprise Miner, SAS Maps, SAS/Enterprise Guide, SUN Solaris.

Confidential

Senior content specialist

Responsibilities:

• Analyzing financial reports
• Collection of fundamental financial data
• Accessing financial performance of companies
• Analysis of Extra ordinary items & their impact on the Earnings Per Share
• Completing the tasks accomplished within stringent deadlines
• To provide accurate MIS production report
• Problem tracking & trouble shooting within the team
• Having good knowledge of US GAAP Financial Statement
• Having good knowledge of IFRS GAAP Financial Statement
• Training the fresher’s within the team