SUMMARY:

• More than 6 years of working experience in different versions of SAS and SAS related applications in Finance, Banking, Healthcare and Retail domain.
• Experience includes a clear understanding of all phases of SDLC and working with users to gather business and technical requirements;
• Proficient in requirements collection from clients and processing information to the project team.
• 6 years of professional experience with increasing responsibilities and successful record of achievements in application design, project management, data analysis, forecasting and statistical analysis.
• Experience on working with SAS under platforms such as Windows (XP, Windows 8) & UNIX.
• Extensively used SAS procedures such as PROC SORT, PROC MEANS, PROC SUMMARY, PROC FREQ, PROC TABULATE, PROC REPORT, and PROC PRINT for producing customized reports and external files.
• Accountable for writing complex SQL Queries (PROC SQL and PL/SQL) for the analysis of large health care tables like Claims, Membership, medical, provider, sales and support data.
• Identified project scopes and facilitated meetings for business requirements gathering and architected business and systems processes for different projects
• Responsible for writing business requirements, designing & developing technical specifications, and creating mapping for end to end ETL processes.
• Extensive experience in processing large datasets with millions of records for data transformation including data cleansing, data scrubbing, data profiling and applying business logic rules to incoming data.
• Developed advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis. Experience in performing Ad Hoc Queries for various application and reports on a daily basis using complex SQL Queries.
• Strong working experience with different databases like Oracle, MS SQL Server, and MS Access.
• Extensively used SAS/MACRO for creating macro variables and macro programs to modify existing SAS program for ease of modification while maintaining consistency of results.
• Worked in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Responsible to Identify & record defects with required information for issue to be reproduced by development team.
• Knowledge of SAS performance improvements techniques for different processes and effective team player with strong communication & interpersonal skills.

PROFESSIONAL SKILLS:

SAS Skills: Base SAS, SAS/Macro, SAS/Connect, SAS/SQL, SAS/STAT, SAS/BI, SAS/Access, SAS Enterprise Guide 4.0, SAS Information Delivery Portal.

Databases: Oracle 10g/11g, MS Access, MS SQL Server

Programming Languages: C++, MS Visual Basic, Java, SQL PL/SQL

SAS Procedures: Print, Transpose, Contents, Means, Chart, Plot, Tabulate, Univariate, SummarySort, Reg, SQL, Copy, Freq, Forms, Upload, Download, Formats.

Operating Systems: Windows 8/7, UNIX, LINUX

PROFFESIONAL EXPERIENCE:

Confidential, Farmington Hills, MI

Data Analyst

Responsibilities:

• Responsible for advance analysis of sales data, product data, lease data, credit card transactions data identify the potential risks and create a detailed list reports.
• Worked on pre - existing MACROS and wrote macros from scratch for data validation by checking data distribution and comparison to standard data.
• Worked on data modeling, design and development of Data Warehouse and kept up with SQL Server best practices.
• Used SAS for pre-processing data, data analysis, generating reports, statistical analysis, and graphs.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Developed complex SAS, SQL and SAS Macros processes to bring the data from disparate data source, stage into the SAS, transform the data as per the business requirements, create delimited file from target SAS datasets to load into the data marts tables.
• Reviewed and modified SAS Programs, to create customized ad-hoc reports, processed data for publishing business reports.
• Written complex SQL queries for validating the data against different kinds of reports
• Extensively used MS Access to pull the data from various data bases and integrate the data
• Modified/Created Queries and Involved in extensive DATA validation using SQL queries and back-end testing.
• Worked in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Performed data mining on Claims data using very complex SQL queries.
• Identify & record defects with required information for issue to be reproduced by development team.
• Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.

Confidential, Minneapolis, MN

Sr. SAS Developer/analyst

Responsibilities:

• Responsible for advance analysis of non-commercial customer’s enrollment data, product data, banking data, credit card transactions data, and demographic data to identify the potential risks and create a detailed list reports.
• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis.
• Developed application for measuring financial performance of newly acquired accounts: Forecast vs Actual and developed SAS programs for generating reports on key financials, Income Statements, and Balance Sheet.
• Involved in the creation and conversion of SAS datasets from tables and flat files, analyzing the dataset and generating reports by employing complex data manipulation.
• Transformed the SAS datasets as per the business model requirements using various SAS data step techniques and procedures.
• Actively involved in reading .txt files into SAS, creating SAS datasets, analyzing large SAS datasets, generating delimited files and writing SQL load script to load the data in to SQL Tables.
• Developed UNIX fast load shell scripts to schedule the load of vendor flat files on daily, weekly and monthly basis to corporate data warehouses
• Extensively involved in the validation and documentation of SAS codes and wrote cross validation queries to check the validity and integrity of the data loaded on to the data warehouse with respect to the source datasets in SAS.
• Extracted data from warehouse using LIBNAME statement and SQL pass through facility to create SAS data sets for reporting and analysis by internal clients like Business Analytics, Marketing Department
• Wrote reusable macros to automate the recurring reports in SAS, and also wrote Korn-Shell scripts for running SAS programs in batch mode on Unix
• Worked on SAS Enterprise Guide to perform data analysis and develop stored processes to distribute the reports in a secure manner
• Worked in fast pace environment as an individual and as a team member.

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

Confidential, Whitehouse Station, NJ

SAS Programmer

Responsibilities:

• Accountable for writing technical specifications, designing and developing ETL processes, end to end process flow and presenting them to the architect’s team to get the final approval.
• Developed complex SAS, SQL and SAS Macros processes to bring the data from disparate data source, stage into the SAS, transform the data as per the business requirements, create delimited file from target SAS datasets to load into the data marts tables.
• Wrote complex PL/SQL code and Stored Procedures to perform key (primary & foreign) persistency across the data marts and data warehouse. Also responsible for writing load scripts to load the data into the Sybase IQ tables.
• Extensively used Proc Reg, Proc Freq, Proc Contents, Proc Datasets, and Proc Means to perform advance analysis on corporate databases.
• Conducted meeting with business users and data architects to define metadata for tables to perform ETL process
• Worked on pre-existing MACROS and wrote macros from scratch for data validation by checking data distribution and comparison to standard data.
• Handled files having many missing values and special characters and generated datasets based on the conditional requirements of the special character and missing values present in the file raw data files.
• Actively involved in designing and developing daily, weekly, monthly, quarterly and yearly ETL (Extract, Transform and Load) processes for different business streams and wrote complex Korn Shell scripts to automate ETL processes and send out a notification emails to concerned people.
• Analyzed various tables using data manipulation techniques like merging, appending and sorting and created highly customized reports using SAS macro facility, Proc Report, Proc Tabulate, and PROC SQL.
• Performed data cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC SORT with NODUPKEY, PROC UNIVARIATE and MACROS in SAS.
• Analyzed, designed and developed SAS programs in UNIX platform and transferred and migrated data from one platform to another to be used for further analysis.

Environment: SAS BASE, SAS/SQL, SAS/STAT, SAS/MACRO, SAS/ODS, SAS/ETL, PL/SQL, SAS/ACCESS and SAS/CONNECT, PL/SQL, Oracle, Sybase, SQL Server, SQL Studio, WinSQL, SQL Server Management Studio, Putty, Reflection X, Windows, UNIX.

Confidential, Pleasanton, CA

SAS Programmer

Responsibilities:

• Produced data listings, summary tables and graphics for interim and final analysis and publications.
• Provided data in SAS transport files, and other appropriate deliverables and documentation for regulatory submissions.
• Participated in maintenance of software applications. Identifying enhancements and new features. Participated in requirement reviews.
• Performed validation programming on clinical trial data using SAS MACROS.
• Created base macros to run reports. Creating standard reports to use across studies and creating base programs to set up data.
• Helped Statistician in creating graphs using G-Plot.
• Performed Data entry and conversions, data validation and corrections, uploading/ downloading data from/to a PC.
• Extensive use of PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC REPORT, PROC TABULATE.
• Tested and debugged against the test data.
• Used SAS for pre-processing data, data analysis, generating reports, statistical analysis, and graphs.
• Responsible for locating appropriate databases for projects.

Confidential

Database Programmer

Responsibilities:

• Analyzed technical and functional design requirements.
• Designed and coded superior technical solutions.
• Worked on data modeling, design and development of Data Warehouse and kept up with SQL Server best practices.
• Analyzed complex database concepts and the implications of different database designs; identified and applied the appropriate database design techniques.
• Analyzed, consolidate and tuned database for optimal efficiency especially tuning complex queries, procedure and indexing strategies;
• Increased the capabilities of the extract, transform, and load (ETL) layer for data operations;
• Used SQL Server Integration Services (SSIS) for ETL and SQL Server Reporting Services (SSRS) for report generation;
• Conducted need analysis for the development of new system and the modification of existing systems;
• Monitored systems and platforms for availability;
• Regulated backup strategies and database recovery modules and made data available on demand;
• Allocated system storage and planned future storage requirements for the database system.
• Developed asset quality monitoring.