We provide IT Staff Augmentation Services!

Senior Sas Developer / Validation Analyst Resume

5.00/5 (Submit Your Rating)

Richmond, VA

SUMMARY

  • Over 9 years of IT experience in Technical/Project Leadership, Systems Analysis, Design, Development and Implementation asData Analyst.
  • Experience inanalyzing, designing and developing SAS/ETL process(Extraction, Transformation and Load) using SAS DI studio for building a data warehouse, OLAP cubes for reporting and other various data integration projects to build data marts from enterprise data sources.
  • Experienced working with SAS DI, Teradata Sql Assistant, SSIS ( Sql Server Integration ) and creating Korn Shell Scripts Services to perform a data migration between various data sources.
  • Experience on creating jobs using various transformations from teh vendor sources into teh target data marts using SAS DI Studio.
  • Involved in metadata jobs migration from dev. /test environment to production server.
  • Performed business planning, consolidation, forecasting, budgeting, dashboards, predictive analytics of financial transactions, model scoring and generate SAS datasets dat are used across teams
  • Experience in SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/QC in Windows and UNIX environment in order to accomplish financial Data Analysis and preparation of SAS datasets, multi - dimensional reports, tables, listings, summaries and graphs according to teh corporate guidelines and project requirements.
  • Involved in writing complex routines for data scrubbing, data cleaning, data modeling (logical & physical), data extraction, transformation and loading of data in test/dev Server before moving to production Server.
  • Extensive experience in writing macros to develop concise and reusable code in order to improve ease, speed as well as consistency of results.
  • Ability to analyze, model, and conduct gap analyses; Ability to convert data from multiple, complex systems.
  • Excellent written, oral, analytical, problem solving, and interpersonal communication skills.
  • 5+ years of experience in designing, developing, implementing and maintaining applications inFinance Industry.
  • Master of Business Administration (MBA)in Finance and E-Commerce.
  • SAS Base Programmer Certified from SAS Institute.
  • Microsoft Certified System Engineer (MCSE).

TECHNICAL SKILLS

SAS Skills: SAS V8.2, V9.1.2, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS Enterprise, SAS Data Integration Studio, SAS Enterprise Guide, SAS EBI, SAS Management console

Languages: SQL, Unix Shell Scripting

Database: SQL Server, Oracle, TERADATA, DB2, MS ACCESS

Others / Tools: SAS, SMART Reporting, Merge-Purge, COGNOS, MS Office, MS Visio, MS Project, MS Project Server, Autosys, IBM AIX, Citrix, Webi, Crystal Report, BOBJ - Business Objects.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Senior SAS Developer / Validation Analyst

Responsibilities:

  • Worked in teh BASEL II (Home Mortgage, Auto Finance & Cards data modeling for BASEL Project ) for SAS Code enhancements/Gap Analysis by using SAS Enterprise Guide, SAS Di Studio, Base SAS, Teradata, DB2 and UNIX.
  • Worked in theAnti-Money Laundering (AML)/Search Spaceteam assisting teh compliance team on various projects like Round-dollar, High risk countries, Bulk-cash, Travelers Check etc. Lead/Monitored teh monthly-production cycle and preparing teh reports like monthly Key-performance indicators (KPI) and various statistical reports.
  • Involved in teh end-to-end analysis and re-engineering of 30 Plus Compliance Reports to SAS Analytics environment with data sourcing from teh Corporate Data Warehouse for Confidential Products like CARDS, Mortgage, Home Equity and Retail Financial Services.
  • Capable of sourcing and compiling data from multiple databases, such as Teradata, SQL Server, DB2, SAS datasets and Excel spreadsheet using SAS Enterprise Guide, DI Studio, Teradata Sql Assistant.
  • Worked on UAT testing for major data migration of Confidential data from EDW to ICDW data warehouse with tight deadlines.
  • Automated teh Process of Data extraction and conversion writing Korn Shell scriptsand scheduled weekly jobs .
  • Ensured timely execution of Korn-Shell scriptsto kick off SAS jobs and ftp flat-files to data staging areas and ETL process.
  • Supported request changes through teh provision of necessary validation documentation and change control activities.
  • Performed as Data Governance to manage updates of business rules to maintain a level of Data consistency.
  • Created Reports for data load completion to include any data issues.
  • Working on different SAS processes such as Proc SQL, Proc Compare, Proc Transpose, Proc Freq, Proc Mean, Proc Summary, Proc Import & Export, different Joins, Merge, Data Step, Set statement, etc.
  • Used shell programming to run weekly, monthly and quarterly reports as per teh requirement and running them as per teh schedules.
  • Created Macros for smooth performance and quick change requests.
  • Worked on many different projects within teh financial domain such as Compliance, Cards, Risk, Credit, Mortgage etc.

Confidential, Richmond, VA

Senior SAS Programmer / Data Analyst

Responsibilities:

  • Worked as a Senior Consultant with Marketing Model Team of Capital Onefor Semi-Annual and Monthly Extract Projects. their are 27 Semi-Annual and 5 Monthly Extracts to build Marketing Models, and Model Performance.
  • Prepared Data Model for Marketing Project by Interacting extensively with Model Owners on requirement gathering, analysis and documentation.
  • Documented coding methodology, data reports and model results to share with Users and Management.
  • Extensively performed Data Cleansing during teh ETL’s Process by analyzing teh raw data and writing SAS Codes and Complex reusable Macros.
  • Carried out Data extraction and Data manipulation techniques using PROC SQL. PROCT SORT, DATA Step by applying project specific conditions.
  • Performed complex statistical analysis using PROC MEANS, PROC FREQ, and PROC SUMMARY.
  • Extensively used SAS procedures such as PRINT, RANK, FREQ, MEANS, SUMMARY, TABULATE.
  • Extensively used Proc Rank to determine Deciles of each applicant to validate teh model Strength and Stability.
  • Calculated One Way, Two Way Frequency to measure Some’D.
  • Generated HTML, RTF, PDF and text reports using ODS statements and performed data analysis using SAS Base, TERADATA 12. And Microsoft Excel.
  • Performed Data Analysis, Statistical Analyis, Generated Reports and Listing using SAS/SQL, SAS/ACCESS and SAS/EXCEL, Pivot Tables and Graphs.
  • TEMPEffectively prepared and presented various performance reports and presentation.
  • Develop, write and execute protocols for teh process validation of new processes.Assist in teh development of Control Checks for developers.

Confidential, Scottsdale, AZ

Senior SAS Programmer / Data Analyst

Responsibilities:

  • Worked as a ETLConsultant in teh Integrated Business Insights Reporting with teh responsibilities of multiple data extraction and transforming teh data from various sources with Global Merchant performance and customer characteristics information.
  • Created metadata objects by creating teh data sources, targets and data transformations using teh source, target and process designer of teh SAS DI Studio.
  • Created Lookup, Fact and Dim tables and Identifying teh mapping data into specific domains as per teh data model using SAS Enterprise Guide by creating teh DATA and PROC steps as process tasks
  • Involved in teh Administration of teh user authentications, metadata repositories, job scheduling, stored processes, data cleansing.
  • Experience in creating OLAP cubes for reporting of pre-summarized large datasets and decision support systems using SAS Data Integration Studio and publish teh same for business users.
  • Develop Project specific SAS Programs for creating Analysis datasets, graphs and reports. Performed and supported data analytics over 4 billion transactions annually in over 127 countries worldwide.
  • Developed and executed SAS SQL queries for merging, concatenating, and updating large volumes of data.
  • Developed Macros for various instances for automating parallel markets for analysis intermediate DATA and PROC steps to simplify frequent reporting.
  • Provided assurance over data definition, data production, and usage of data over regulatory compliance, security, privacy, and data protection issues.
  • WroteKorn-Shell scriptsfor back up and running batch files and perform quality assurance and validation on teh transported data and reports.
  • Korn-Shell scriptsfor running SAS programs in batch mode onUNIX.
  • Documented all incoming requirements, files and variables for accurate historical and future reference.
  • Performed quality control (QC) checks on peer developed lists to ensure dat teh correct source data is used and correct code and logic are used.
  • Used Base SAS (MEANS, FREQ, SUMMARY, REPORT etc) and SAS/STAT procedures (REG, GLM, ANOVA, UNIVARIATE etc.) for summarization, Cross-Tabulations and statistical analysis purposes. Teh generated reports are reviewed and then sent to teh Client Manager.
  • Enhanced reports through teh use of labels, SAS formats, user-defined formats, titles, footnotes and SAS System reporting options.
  • Generated HTML, RTF, PDF reports using ODS statements.
  • Produced high quality graphs through SAS/GRAPH for analysis studies.

Confidential, Bakersfield, CA

Senior Programmer Analyst

Responsibilities:

  • Worked as technical lead for teh project.
  • Analyzed massive and highly complex data sets and managed Ad Hoc Projects dat includes presentation to external clients and senior management using data analysis, producing tables, listings and graphs as requested.
  • Verified ongoing quality, accuracy of data using SAS and actively worked on resolving issues using Data manipulations, DATA Steps and various PROC steps.
  • Performed Data Governance activity for resolution, sharing of best practices, and communicating results.
  • Evaluated alternative solutions to meet teh business need and recommending teh most appropriate solution for time-saving prospective and longer-term strategic objectives including planning, consolidation, forecasting, budgeting, dashboards, predictive analytics and reporting by SAS programming of data listings, summary tables and statistical analysis.
  • Supported and developed standardized reporting dat can be used for Business decision making by writing Macros and modifying existing Macro codes.
  • Provided support to internal team members for complex Project and New Product Development for value-added datasets as per statistical analysis plan and programming plan specifications to reflect company data standards.

Confidential

SAS Programmer

Responsibilities:

  • Worked on campaigning teh company products and coupons to teh customers.
  • Cleansed, prepared and analyzed teh dataset containing using 1,000,000+ observations using Base SAS, SAS Enterprise Guide 4.2 and SAS Enterprise Miner.
  • Perform tasks of user authentications, deploying jobs for scheduling using SAS Management Console.
  • Performed complete development and unit testing of teh newly created ETL code in test environment and bench mark newly created metadata jobs before integrating to teh data warehouse in order to build efficient data marts.
  • Worked extensively on various SAS modules such as PC SAS, SAS Base, SAS MACRO, SAS ACCESS, PROC IMPORT, PROC EXPORT, PROC SQL, Teradata, Microsoft Excel and Microsoft Word.
  • Created OLAP cubes using SAS EBI Environment and created stored procedures on CRM data.
  • Used predictive modeling like Benchmark Analysis and Seasonality Analysis.
  • Performed multidimensional data analysis and reports using teh cubes to produce reports.
  • Created Pivot tables in Excel and charts/tables in PPT files using teh OLAP cubes for teh business users using teh SAS Add-in for MS Office plug-in facility
  • Expertise in creating teh mapping models for mapping teh business models with star schema logical database model using SAS Information Map Studio
  • Extracting data from an Oracle database, XML files, Excel files, CSV files, Flat files used as input for SAS programs to create Excel spreadsheets, Access databases, and hard copy reports. Used SAS Macros to make teh minimize SAS code lines and for ease of maintenance.

Confidential

SAS Programmer

Responsibilities:

  • Involved in developing SAS programs for data transformations of teh data received from different operational sites to maintain a data warehouse. Data is received in PC files like CSV, txt or in other DSD file formats. Performed extraction, transformation and loading of data using SAS Base programs.
  • Created SAS datasets using data steps with infile statements with If/else statements, Do groups, Where statements, and Arrays to control processing when reading raw data files. Used SAS/Macros for efficient SAS code.
  • Extensive knowledge in database design and developing oracle database using PL/SQL.
  • Used Import and Export procedures for specific input data feeds while connecting to remote data sources like SIEBEL and Oracle databases.
  • Produced efficient datasets by combining individual datasets using various inner and outer joins in SAS/SQL, used SAS/Macros and dataset merging techniques of SAS/BASE.
  • Modifying teh new datasets using analytical statements.
  • Created, validated, documented and maintained libraries of SAS application programs, formats catalogs.
  • Generated HTML, Listings and reports for presenting teh findings of various statistical procedures using procedures like REPORT, PRINT, GRAPH and FREQ.
  • Generated HTML, RTF, PDF reports using ODS statements.

We'd love your feedback!