| Confidential 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 business 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 new datasets from raw data files using data infile input statement, and modified existing datasets using Set, Merge, Sort, Update and conditional statements.
- debugged existing macros using macros debug options like Merror, Serror, Mlogic, Mprint and Symbolgen.
- Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and
- Created complex and reusable Macros and extensively used existing macros and developed SAS
- Developed SAS based applications for measuring financial performance of newly acquired accounts: Forecast Vs Actual.
- Ran Monte Carlo simulations to calculate quarterly capital requirements for Citizen's operational risk component
- 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 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.
- 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.
- analyzing the raw data and writing SAS Program and creating complex reusable Macros.
- Extensively performed Data Cleansing during the ETL's Extraction and Loading Phase by
- Performed Consumer profiling, Sales forecasting and testing.
- 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. |
| 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 developed SAS Programs 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 SAS Analyst Responsibilities: - 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.
- Experience in entering, analyzing and coordinating data, generating tables, listings, graphs, and
- Responsible for extracting the data, cleaning, manipulating, transferring and managing data in SAS.
- 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. |
Privacy Policy
