We provide IT Staff Augmentation Services!

Sas/sql Programmer Analyst Resume

Vernon Hills, IL

SUMMARY:

  • SAS & SQL Programmer/Analyst with Hadoop, Statistical Analysis, Predictive Modeling, ETL, QA, UAT Testing and Agile experience.
  • SAS Certified Professional with 9.5 years of experience working as a Sr. Data/Business Analyst extensively involved with SQL, Hadoop and SAS Development.
  • SAS and SQL Certified. Cleared Global Certifications in Base SAS 9.3, Predictive Modeling using Enterprise Miner 13 as well as Oracle SQL Expert (1Z0 - 047).
  • Involved in a SAS-HADOOP integration project at Confidential that resulted in cost savings of over 200 thousand dollars. Received a bonus cash reward from Confidential for this contribution.
  • Awarded thrice by Mphasis for excellent work while on a project at Confidential .
  • Interacted with key stakeholders and business partners to identify gaps with business and provide solutions to drive efficiency. Conducted daily status report calls, communicated progress to business team and coordinated efforts with offshore team.
  • Experienced in writing/updating Business Requirement Documents (BRD’s) and Functional Requirement Documents (FRD’s).
  • Worked in all phases of testing like smoke testing of the builds, Functional, Database, User Acceptance Testing (UAT) along with Regression testing. Involved with implementing Scrum and Agile methodologies and working with user stories and sprints/releases.
  • Experienced with Data analysis, Data warehousing, ETL testing, OLAP, OLTP, SCD - Type 1 and 2, Data mapping and Dimensional modelling experience in decision support systems (Data marts) using Star and Snowflake Schema.
  • Developed and modified existing SAS programs as well as imported data using SQL Pass Through and Libname engine methods to create tables and extract data from Teradata, SQL Server and Oracle DB.
  • Extensive experience writing complex SQL and PLSQL queries including Joins, Aggregations, Grouping, Views etc. along with knowledge on Unix and Linux and scheduling Unix jobs.
  • Strong experience with Excel using VLOOKUP’s, Pivot table’s, Charts, Arrays, Sparkline’s, Outlining, Customized reports.
  • Extensively used SAS and SQL for analyzing data and understanding customer behavior which helped in customer profiling, market segmentation and performing trend analysis.
  • Experienced with SAS Visual Analytics Data Builder, SAS Visual Analytics Explorer, SAS Visual Analytics Reports Designer modules. Used SAS Visual Analytics and Tableau for preparing, exploring, analyzing, and interpreting data, creating dashboards and generating customized reports.
  • Worked with SAS Predictive Modeling for preparing data, building predictive models, assessing models, performing Linear and Logistics regression, Anova/Arima tests, scoring new data sets, implementing models, customer segmentation etc.
  • Successfully integrated SAS with Hadoop with Cloudera Hadoop.
  • Team Leadership and Management: Was part of the Data Analytics and SAS Development team. Lead the Team meetings and daily status calls and was responsible for updating team members during daily standup meetings on the progress of the work.
  • Data Integration and ETL Experience: Involved in ETL and Data Migration activities including the HADOOP-SAS integration along with linking databases with Teradata, Oracle and SQL Server. Performed QA validation of data which includes data validation and verification of data on both Source and Target DB’s using SQL and SAS. ETL testing includes knowledge of Type 1 and Type 2 Slowly Changing Dimensions(SCD’s).
  • Requirements Gathering: Involved in Requirements Gathering and preparing Business Requirements document as well as Technical Specifications. Responsible for writing Functional Requirement Specifications (FRS). Conducted the FRS reviews and walkthroughs with designers, developers and stakeholders.; developed activity and UML diagrams using Visio; presented approach to internal stakeholders.
  • Training and Mentoring: Mentored analysts on SAS tool and oversaw the SAS development activity. Trained new joiners on various business requirements and test scenarios.

AREAS OF EXPERTISE:

  • Banking and Finance
  • Investment Banking
  • Retail Banking
  • Commercial Credit Cards
  • HealthCare and Pharma
  • Retail and Supply Chain
  • Data Analysis
  • SAS Development
  • Retail Banking and Cards business.
  • SAS Statistics
  • SAS Visual Analytics - Designing and Exploration
  • Risk Management
  • Cross-Functional Collaboration
  • Team Leadership & Management
  • Coaching, Training & Mentoring
  • Predictive Modeling
  • Strategic Planning / Tactical Execution
  • Continuous Process Improvement

TECHNICAL SKILLS:

  • SAS 9.3/9.4 Windows
  • SAS Enterprise Guide 13
  • SAS Enterprise Miner
  • SAS Visual Analytics 7.3
  • SAS Visual Analytics LASR Server
  • SAS Management Console
  • Oracle 11g
  • SQL Server
  • Teradata
  • SAS Data Integration Studio
  • Toad for Hadoop
  • HUE for Hadoop
  • SQL Plus
  • SQL Developer
  • MS Excel
  • MS Visio
  • Jira
  • ALM
  • Java Eclipse
  • Informatica Power Center
  • SAS Access
  • Tableau
  • Qlikview
  • SAS
  • SQL
  • PLSQL
  • HIVE
  • IMPALA
  • JAVA
  • PYTHON
  • Unix
  • Linux
  • Windows

PROFESSIONAL EXPERIENCE:

Confidential, Vernon Hills, IL

SAS/SQL Programmer Analyst

Responsibilities:

  • Involved in a SAS-HADOOP integration project at Confidential that resulted in cost savings of over 200 thousand dollars. Received a bonus cash reward from Confidential for this contribution.
  • Engaged with the business team to get the requirements and design/create SAS programs as per the requirements.
  • Involved in test planning, design and implementation of test cases.
  • Working on AD-HOC SAS and R reports for various Sales and Marketing teams to be used in various targeted campaigns.
  • Using SAS Access to Teradata and Oracle to connect with the Teradata and Oracle tables using libname, Filename and SQL Pass Through methods and validated results against results generated from Teradata SQL Assistant. Performed complex SQL joins, SAS sorting, de-duping and merges along with using SAS Macros for repetitive tasks including shrinking data, exporting log results etc.
  • Automated SAS jobs using Windows Scheduler and PowerShell.
  • Integrating SAS 9.4 with Cloudera Hadoop 5.9 version using SAS Access Interface to ODBC by using libname and SQL Pass through methods to connect with Hadoop and generating AD-HOC reports.
  • Used Python programming to generate tab delimited files for Hadoop export.
  • Used SAS Statistics including proc glm, proc sgplot, proc reg procedures and generated graphs, charts etc. to analyze and forecast data.
  • Using Unix and Linux commands to transfer data from local Landing directory to Hadoop using Hadoop fs commands. Used HUE Interface for Hadoop to verify the tables on the front end.

Confidential, Piscataway, NJ

SAS/SQL Programmer Analyst

Responsibilities:

  • I nvolved in requirements gathering, updating BRD’s, FRD’s, creating visio’s and providing suggestions/recommendations to client to improve the product. Working with Agile and Scrum methodologies and working in smaller, achievable and well-defined Sprint Cycles. Involved with conflict resolutions and updating Product Owner about any Product Backlog. Involved with releases/sprints and retrospective meetings.
  • Involved in the development of test plans, test scenarios and test strategies to facilitate the process of testing. Also involved in Analysis, Design, and Functional Specifications to identify Test Requirements, Design Test Cases, Test Scripts, and Test Data with expected output.
  • Writing high level UAT Test Scenarios, UAT Test cases based on requirements captured in BRD and business scenarios covered in the Use cases documented in Jira.
  • Validating fields in UI with those in Database along with testing various scenarios in Database by writing complex queries. Carrying out database testing and inserting and updating records as per requirements.
  • Published Daily Test status reports / defect metrics for the client to review/discuss on a daily basis and create formulae in Dashboards in QC to generate specific reporting data as per client requirement. eg: Total Open Defects Summary List.
  • Used SAS Enterprise Guide to write queries in SAS and create tables using proc sql and SAS queries and then finally transfer the tables to the Designer section using SAS LASR Analytics Server and create Visual Analytic reports in SAS VA which are then used for visual analytics exploration.
  • Worked as a SAS VA developer and extracted data from Hadoop into SAS and then migrated datasets on SAS LASR Analytics server using hdat and sasiola to use this data for Visual Analytics Designing and Exploration.
  • Used SAS Visual Analytics Designer module for creating reports - inserting objects into reports, using different tables and graphs to display results, used different container objects like vertical, horizontal, prompt containers in reports, used calculated and aggregated items, created new hierarchy, inserted images, used stored process, used gauges to display status of variables, used customer graphs to display results, worked with interactions, parameters report links and ranked values in reports.

Confidential, Jersey City, NJ

Module Lead/Technical Data Analyst

Responsibilities:

  • Involved in requirements gathering, updating BRD’s, FRD’s, creating visio’s and providing suggestions/recommendations to client to improve the product. Working with Agile and Scrum methodologies and working in smaller, achievable and well-defined Sprint Cycles. Involved with conflict resolutions and updating Product Owner about any Product Backlog. Involved with releases/sprints and retrospective meetings.
  • Writing high level UAT Test Scenarios, UAT Test cases based on requirements captured in BRD and business scenarios covered in the Use cases documented in Jira.
  • Verifying the UI application for various positive and negative scenarios for each release and performing regression testing for every release.
  • Involved with raising UAT/SIT level defects, defect management and defect tracking in ALM for all releases.
  • Updated User Guide, Page Help File and CBT Training deck for customers.
  • Training LOB’s for every new release, resolve issues and take feedback from them for improving of the application.
  • Planning the number of test cases for a particular release and allocating tasks i.e. assigning respective modules to individual testers for writing test cases within a planned timeframe.
  • Engaging with customers and AD Team on a daily basis for SIT/UAT Phase Testing review along with attending calls for QA/UAT testing review and helping the QA team resolve any issues/concerns.
  • Participating in Root Cause Analysis meetings/discussions for defects review.
  • Responsibilities involved Data Integration and Data Migration using Base SAS 9.3 with Oracle, SQL Server and Teradata engines and using SQL Pass through and Libname methods to integrate and import data from these databases, involved with writing SAS Macros and data transformation and creating datasets and then transferred data to SAS LASR Analytic Server for Data Visualization using SAS Visual Analytics Designer module. Assisted with UAT testing efforts like planning UAT test scenarios and test cases and sending daily Status reports and engaged in Daily Status calls with client and developers. Worked with End-Users of reports/BI tools to understand their issues and solve them for each release.
  • Imported data from Teradata, Oracle, SQL Server into SAS Enterprise Guide and performed data transformation using SQL queries to generate customized results and save results into respective data sets. Also, imported data from various datasets including flat files, excel, csv etc. and generated output files in the form of listing, HTML, RTF and PDF formats using SAS ODS. Created dashboards and customized reports using Tableau.
  • Developed/assisted in creating customer models, forecasting models, customer segmentation analysis, exclusively used SAS Enterprise Guide to gather data (ETL), data modeling, validate models and prepare reports.
  • Build and execute SQL queries for data mining, data quality, data profiling and data trend and data structure analysis. Used SAS statistics to evaluate the results.
  • Created joins, joins with custom SQL & blended data from different data sources using Tableau Desktop and created dashboards and reports using Visual Analytics and Tableau.
  • Verified data on Source and Target side of ETL, verified data completeness and transformation rules, tested referential relation and integrity of data as per requirement specification documentation, checked for duplication of records and/or data errors.
  • Extensively used Excel for VLOOKUP’s and Pivot tables to generate customized reports for client and help with immediate firsthand identification of problems.

Confidential

Data Analyst/Developer

Responsibilities:

  • Worked as a Data Analyst using SAS and SQL, involved with database migration and data warehousing project. Created SAS Data sets in SAS Enterprise Guide as per requirements and validated data using SAS and SQL.
  • Worked on ensuring Data Completeness, Data Transformation, Data profiling & Data Quality for various data feeds coming from source.
  • Created workflow and process flow Visio diagrams reflecting current and proposed business processes and site functionality.
  • Wrote requirement specification, user stories, acceptance criteria, test cases and used Jira as ticket management tool and confluence for documentation
  • Used SQL queries/joins to query SQL Server databases for data analysis and documentation of data flow and data processes for ETL Migration.
  • Created Data Mapping Documents and Source to Target Transformation document for ETL / Data Warehouse.
  • Planned and conducted requirements, elicitation meetings with the business to collect functional and non-functional requirements relating to client's enhancement initiatives.
  • Used SQL queries to extract data from different databases including testing and production for data validation and data analysis.
  • Regularly worked on data issues from the client perspective and converting them into data mapping and data validations.
  • Designed and developed Use Cases, Use Case Diagrams, Workflow diagrams and Activity Diagrams by using UML and Visio.
  • Validated and verified data using various SQL queries including Joins, Aggregate functions, Group by etc.

Confidential

Data/Business Analyst

Responsibilities:

  • Developed and automate daily, weekly, monthly, and seasonal reporting/scorecards to monitor the health of the online business as well as share business insights with marketing, product development, sales, and finance stakeholders using SAS and SQL and generated customized reports for client.
  • Ensured data integrity and testing processes are followed for reporting and research tools. Worked with internal and vendor support teams to report and resolve data discrepancies.
  • Supported data and analytics requests throughout the development cycle including gathering data requirements, sourcing and validating data, analyzing data, building models, synthesizing insights, and presenting results.
  • Analyzed performance and impact of digital marketing and merchandising investments with key e-retailer accounts to determine customer impact and return on investment (ROI) (for both online and in-store purchases).
  • Applied multivariate statistical tools to help build predictive models, improve customer segmentation, optimize approach to online pricing, and improve elements of the digital marketing mix.
  • Worked on Legacy and Payment Net 3 "Migrations" project focused on transferring important customer information from one database system to another due to recent up-gradations. Worked on Payment Net database network and conducting back-end validation with Oracle and MS SQL Server and ensured that all data is correctly migrated from SQL Server and Oracle databases to SAS Data warehouse on SAS Enterprise Guide. Validating results by writing SQL queries and then comparing with original data using tools like Beyond Compare.
  • Designed and implemented SQL queries for QA testing and report / data validation.
  • Validated and verified stored in DB2 database using SQL queries prepared status summary reports with details of executed, passed and failed test cases.
  • Validating fields in UI with those in Database along with testing various scenarios in Database by writing complex queries. Also worked towards improvement of SQL queries. Performed Regression testing during the Testing phase to ensure a new improvement has not affected/modified the existing functionality.
  • Involved in Database ETL migration project from SQL Server to Oracle database and which involved extensive usage of SQL queries to validate and verify the proper and complete migration. Logged defects in ALM to reports issues with migration. Tracked the Slowly changing dimensions that change over time to help with understanding of current and historic data.
  • Was part of the Legacy Migrations team along with handling the PNET3/P4 Migrations. Extensively used UNIX to run batch jobs and perform backend validation.
  • Writing complex SQL queries and modifying the queries in Oracle and SQL Server and validating the results against existing data using a tool called Beyond Compare.
  • Developed and automate daily, weekly, monthly, and seasonal reporting/scorecards to monitor the health of the online business as well as share business insights with marketing, product development, sales, and finance stakeholders.
  • Using SAS Predictive Modeling created data sources in Enterprise Miner, explored and assessed data sources, build predictive models using regression analysis (linear and logistics), decision trees and neural networks, used fit statistic for different predictions, used decision processing for adjusting over sampling, used profit/loss information for assessing model performance and for comparison of models and forecasting.

Confidential

Data/Business Systems Analyst

Responsibilities:

  • Involved in data verification, data manipulation and coding activities including the usage of basic and standard SAS procedures, SQL queries and Macro coding. Involved with Data migration upgradation project which included migration of data from SQL Server to Oracle and then into SAS.
  • Imported data from various sources into SAS and was involved with data migration project and upgradation project using SAS. Migrated from SAS version 8.0 to 9.0 on SAS Enterprise Guide.
  • Involved in verification of programming logic by overseeing the preparation of test data, testing and debugging of programs. Worked with the development of test plans, test scenarios and test strategies to facilitate the process of testing. Also involved in Analysis, Design, and Functional Specifications to identify Test Requirements, Design Test Cases, Test Scripts, and Test Data with expected output.
  • Involved with Data Migration and ETL testing project using complex SQL queries. Used various SQL queries including Joins, Union, Aggregate functions, Group by, Inline views, transpose etc. for validating data.
  • Using the data mapping document or the requirements document, created detailed test cases for each phase of the ETL process. The test cases checked for the required columns, old versus new changes, data integrity etc. The test cases included detailed description, expected versus actual results comparison etc.
  • Used SAS and SQL queries to perform data validation and verification.

Hire Now