SUMMARY:

• SAS Programmer with around 5 years of experience on Data Analytics as a SAS Developer/Analyst. Proficient in SDLC, Agile and waterfall methodologies, cloud - based file services and cloud-based backup. Good ability to work on multiple tasks andstrong interpersonal, analytical, presentationskills, communication,andproblem-solving skillsand work independently as well as in a team.
• Core technical expertise in SAS/BASE, SAS/STAT, SAS/SQL, SAS/ACCESS, SAS/MACRO, SAS/SQL, SAS/ODS in Windows environment.
• Strong exposure to all steps of project life cycle such as original data collection, secondary data query, data manipulation and analysis, optimizing, summary of findings, develop analysis indications; communicate strategic insights and presentation of results. Expertise in Data Manipulations using SAS data step, such as SAS Format/Informat, Merge/Joins, Procedures like PROC APPEND, PROC DATASETS, PROC SORT, PROC TRANSPOSE, SQL Passthrough. Experience in Data extraction from several databases includingOracle, SQL Serverand other external files usingSAS/Access, SAS/SQL pass through facility, Libname statements,and Proc Importprocedure and viaSAS Data steps.
• Extensively used Proc SQL, Proc Transpose, Proc Format, Proc Means, Proc Univariate, Proc Freq, Proc Print and Proc Compare for checking teh assumptions and conducting Statistical Analysis.
• Automated and scheduled production jobs through Putty and SAS Scheduler and Tableau production process by Live and Scheduled extracts to auto-refresh data.
• Leveraged large datasets from various data sources like SQL Server, Teradata, DB2, Oracle and Google Cloud.
• Extensive experience creating test scenarios and validating lower-level data (account level, client level).
• Strong quantitative and analytical abilities to analyze and validate data using SQL.
• Familiar with teh clinical data reporting in CDISC SDTM 3.1.2 format
• Familiar with CDISC conventions i.e., SDTM and ADAM models and hands on experience implementing them.
• Worked on data blending, cross-database joins, unions, extracting data/connecting live to a data source in Tableau.
• Extensively used SAS for cleaning of data and auto sorting dataset for teh tableau dashboards.
• Worked with various Lines of business on creating reports on weekly, monthly, and quarterly basis.
• Performed various types of testing, such as functional, regression, user acceptance testing manually.
• Expert at presenting complex analytic methodology, results, and recommendations to diverse senior-level audiences through visual, verbal, and written deliverables. Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps with Tableau desktop. Good noledge in Normalizing and De:normalizing teh tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
• Worked cross functionally between multiple teams to provide data-driven recommendations and solutions.

TECHNICAL SKILLS

SAS Tools: SAS/BASE, SAS/EG, SAS Mgmt Studio, SAS/Flow, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS DI StudioDatabase Oracle, Teradata, DB2, SQL Server, Hadoop, Google Cloud, MS Access.

Reporting: Tableau, SAS BI, Excel

Operating Systems: UNIX, WINDOWS, Linux

Languages: SQL, SAS

Tools: Putty, WinSCP, Ultra edit -32, Microsoft TFS, Citrix Systems

Software Packages: MS Office, Tableau, Tableau Prep

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SAS Developer

Responsibilities:

• Responsible for gathering business requirements, and work with various teams to gather/research/create requirements and source data, perform Gap analysis and Audit on reports to ensure process / reporting accuracy.
• Deliver analytical/quantitative projects on default and credit risk issues impacting teh portfolio.
• Developed teh target Database table as per teh requirement by writing teh source qualifier Queries.
• Created Data Steps and PROC SQL to combine and aggregate data for accessing and manipulating database system. Wrote various queries usingSAS/Base,SAS/SQL,andSAS/Macrofor creating reports according to teh Users requirement, extensively used Proc SQL to retrieve, update and report information on from sas dataset and other database products.
• Created Store Procedures, Functions and Views, modified existing SAS macros to assist with producing reports and deliverables.
• Created complex SQL queries using Inner, Left, Right, Outer, and cross Joins and transformed these queries into SAS code.
• Good experience in using Aggregates, Analytical functions like RANK, DENSE RANK, Sequence in teh queries.
• Involved in Identifying, analyzing, and interpreting trends or patterns in complex data sets.
• Developed several on demand Excel reports/dashboard to higher management.
• Created crosstabs to display underlying data based on various graphs and charts created for further data analysis.
• Distributed reports using techniques like Presentations, PDF, and Reports to different user community.
• Prepared design documents and presentations for client meetings. Publishing noledge base articles in internal portal.

Confidential

SAS Developer

Responsibilities:

• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets. Responsible for providing Clinical SAS programming and analysis support for clinical studies, responsible for Developing reports for Safety and efficacy as per study requirements. Generated SAS/MACROS and stored procedures for reusability and to minimize data processing. Developed and maintained data retrieval and analysis tools for reporting and performed complex ad-hoc processes as necessary to develop viable recommendation for improvement.
• Build acquisitions database for origination analytics (pricing, credit quality, volume) across all residential real estate using SAS.
• Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.
• Performed data analysis, statistical analysis, generated reports, listings, and graphs using SAS tools.
• Manipulated files and their associated data for loading onto internal databases using SQL.
• Experience in pulling data from multiple sources both Internal and External for various reporting and analytical purposes.
• Consult on teh model redevelopment efforts for teh home equity origination scorecard and creating standard logic, definitions, and code for identifying home equity in vendor public record data.
• Handled production support on-call and through texts/emails.
• Established and maintained timeliness for projects and coordinate activities with requesting internal departments or external requester to obtain specific information to meet project expectations.
• Worked on conversion of existing SAS reports to Tableau dashboard reports.
• Responsible for running weekly production jobs and batch jobs.
• Debugging errors on production runs and fixing issues.

Confidential

SAS Developer/Analyst

Responsibilities:

• Created SAS database files, Ad-hoc analyses, developed standard reports and supported SAS users. Involved in extracting, analyzing data from teh data warehouse (ETL).
• Worked extensively on ADM- Analytical Data Mart and its maintenance and support for users.
• Worked on debugging, performance tuning of large datasets using SAS, SQL and PL/SQL coding.
• Proficient in Understanding and using teh pre-defined SAS/Macros.
• Performed data analysis and data profiling technique using SQL queries to discover and determine, issues and variances.
• Coordinated with cross-functional teams in different locations for quality data and analysis.
• Performed Data Mining process on different data sources like Oracle DB, Excel, Flat Files and converted them into SAS datasets.
• Worked on mapping data from existing DataMart to EDW data source and maintained Historical data for Line on Business and Finance team.
• Used SQL Assistant to analyze and query from teh Teradata DB.
• Generated SAS/MACROS and stored procedures for reusability and to minimize data processing.
• Developed and maintained data retrieval and analysis tools for reporting and performed complex ad-hoc processes as necessary to develop viable recommendation for improvement.
• Performed data analysis, statistical analysis, generated reports, listings, and graphs using SAS tools.
• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets.
• Cleansed theinformationthe use ofvariable selection, missingvaluereplacement, transformation, and partition
• Generated reportsthe usage ofSAStacticslike PROC SUMMARY, PROC REPORT and PROC FREQ
• Wrote scripts for back up and running batch files and perform quality assurance and validation on teh transported data and reports.
• Used point-and-click interface, created process flow, generated data warehouse, Data Marts, and data streams.

Confidential

JR. SAS Developer

Responsibilities:

• Worked primarily done from home office, with infrequent travel to Rochester.
• Worked primarily done from home office, with infrequent travel to Rochester.
• Extracted data from Oracle tables in UNIX.
• Extracted huge volumes of data and uploaded into Oracle using SQL Loader.
• Used SAS Macros, Proc Univariate, Proc Summary, Proc means, Automatic Variables and Proc options with LIST, OUT, MISSING options to perform various analysis using analytics.
• Used version control to coordinate teh development across teh various phases.
• Involved in updating and retrieving data from data warehouse and generating analysis reports using sas/base, sas/macro, and proc report.
• Extracted of data from oracle and other flats files into SAS data sets using SAS/access, SAS/connect, proc sql, and SAS import utilities. Designed and created teh SAS data sets from excel spreadsheets and from different kinds of flat files for data manipulation p.
• Project Description Axis bank, Bangalore, India is one of teh nation’s largest banking organizations, serving a broad range of consumer, commercial, corporate, and institutional clients.
• Teh project involved fact -based reports to immerge decision support process fast and reliable.
• Teh team was involved in extracting data from complex data warehouse and analyzed on forecasting and involved in summarizing and reporting it.
• Involved in implementation of required data, documents, and models to identify and solve problems required for decision process.
• It helped teh decision makers for monitoring and analyzing teh performance of teh company financial loan data.
• Responsibilities As a SAS Analyst interacted with business users and business analysts and prepared technical specs.
• Extracted data from Oracle tables in UNIX.