SUMMARY:

• Over 8 years of work experience working as a Sr. Business/Data Analyst with SAS and SQL. Skilled inData Analytics,Predictive Modeling,Data Warehousing, Data Integration, Data Management and Data.
• SAS Certified Professional with 8 years of experience working as a Sr.Business/DataAnalyst using SAS and SQL.
• SAS and SQL Certifications cleared in Base SAS 9.3, Predictive Modeling using Enterprise Miner 13 and Oracle SQL.
• Experienced in writing/updating Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and propose changes as per various internal and external requirements gathered for process improvement.
• Good experience with statistical modeling procedures, including Linear Regression, Logistic Regression, GLM, Mixed models, and ARIMA models.
• Experienced with data analysis, data warehousing, ETL testing, data mapping and dimensional modelling experience in decision support systems (data marts) using Star Schema. Analysis & Design (Use Case, Sequence and Activity diagrams).
• Extensive experience writing complexSQL and PLSQL queries including Joins, Aggregations, Grouping, Views etc.
• Strongexperience with Excel using VLOOKUP’s, Pivot table’s, Charts, Arrays, Sparkline’s, Outlining, Customized reports.
• Well versed with JAVA, Selenium and Appium concepts including OOPS, Classes, Interfaces, Polymorphism etc.
• Involved in Design and development of SQL Programs, procedures, UNIX shell scripts to track status, create SASDatasets and data files and involve in ETL and Data Migration.
• Worked with SAS DataIntegration Studio to develop and automate ETL Processes. Good experience with ETL and DW concepts. Have been part of Data migration and ETL testing projects and used SAS DI tool for automating.
• Experience in data validation, data cleaning and statistical reporting using statistical procedures like Proc Freq, Proc Means, Proc Univariate, Proc TRANSPOSE, Proc REPORT, Proc GCHART, Proc Summary and Proc GPLOT Procedures.
• Knowledgeable with Anti Money Laundering(AML) and Banking concepts. Worked with Retail Banking and Cards projects and good understanding of FederalReserve norms and regulations. Performed several ad hoc analyses and created trend reports requested by finance and marketing teams to understand customer/transaction patterns.
• Good understanding of variousretailing formats and retailing campaigns. Have also completed post - graduation in Retail Management and an Executive MBA in Marketing from IIT Bombay.
• Experienced with Decision Tree, Time-series Analysis, Multivariate Statistical Models, Sampling Designs, Probability Modeling, Econometric Models, Information Retrieval and Meta-analysis, Data Mining, Statistical Classification, Predictive Analytics.
• Experienced with SAS Visual Analytics Data Builder, SAS Visual Analytics Explorer, SAS Visual Analytics ReportsDesigner modules. Used SAS Visual Analytics and Tableau for preparing, exploring, analyzing, and interpreting data. Results were helpful for understanding customer behavior analysis, customer profiling, marketsegmentation, generating trend.Strong experience with SAS Visual Analytics Designer module, knowledgeable with Tableau.
• Worked with SAS Predictive Modeling for preparing data, building predictive models, assessing models, scoring new data sets and implementing models. Certified Predictive Modeler and good knowledge with
• Linear and Logistics regression, ANNOVA, Standard deviation, variance etc. Good experience with Statistical analysis and forecasting.

PROFESSIONAL EXPERIENCE:

Technical/Data Analyst

Confidential

Responsibilities:

• Developed architecture, business logic and database structure of the project as per business requirements.
• Developed and modified existing SAS programs as well as imported data using SQLPass Through and Libname engine methods to extract data from the Teradata and Oracle DB as well as create tables in Teradata and Oracle.
• Imported data from Hadoop into SAS 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.
• Worked on data issues from the client perspective and converted them into data mapping and data validations.
• Analyzed business requirements and assimilated them into use cases, diagrams and process flows.
• Worked on Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database. Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Participated in business requirement meetings with the business sponsors, end-users and business analysts to gather end-user requirements for the above feature.
• Interacted with multiple clients in Gathering Requirements and Preparing Business Requirements as well as Technical Specifications. Responsible for writing Functional Requirement Specifications (FRS). Conducted the FRS reviews and walkthroughs with designers, developers and stakeholders.
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams/State Chart Diagrams (UML).
• Identified and gathered defects, issues, enhancements related to projects and initiate appropriate Change Management tasks and work towards finding a resolution.
• Update project status to the Project Sponsor, Business Customer and Senior Management on a regular basis.
• Developed documentation (Requirements Document, Functional Specification and Design, System Integration Synopsis, Cost Benefit Analysis and Training Materials).
• Build and execute SQL queries for data mining, data quality, data profiling and data trend and data structure analysis.
• Worked with SAS Predictive Modeling for preparing data, building predictive models, assessing models, scoring new data sets and implementing models. Used Linear and Logistics regression modeling along withANNOVA and ARIMA modelingto provide analytical consultation, modeling, and solutions to optimize business goals, objectives, and priorities of the credit business.
• Used both Classification and Regression models to classify credit risks and customer revenue.
• Used Decision Trees with the Classification Models to partition data into subsets based on categories of input variables and are able to handle missing values.
• Using different modeling techniques, tried to find out the customerlifetime value based on net profit for predicting the future relationship with customers.
• Used Linear and Logistics regression to establish relationship among these variables and used independent variables to predict the outcome/response and using Logistics regression predicted the unknown variables. Designed and developed forecasting and optimization models for forecasting real time and ad-hoc scoringand conducted various studies for comparison and benefit assessment of various advanced analytical models.
• Extracted data from Hadoop into SAS and then migrated datasets on SAS LASR Analytic server using hdat and sasiola. Experience with customer Data integration and importing files from various data sources.
• Used SAS ETS tool for forecasting and time series analysis that enabled forecasting and simulation of business processes.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC RANK , PROC SORT, PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC SUMMARY, PROC REPORT for creating a preferred list of customers as per the given requirements from business analysts.
• Extensively used Excel for VLOOKUP’s and Pivot tables to generate customized reports for client and help with immediate firsthand identification of problems.
• Verified the excel results with results generated from SQL and SAS. Developed, implemented, and facilitated process for data identification, segregation, and cleansing of data as well customized results using through excel pivot tables and Vloop’s.
• Developed/assisted in creating customer attrition models, forecasting models, customer segmentation analysis, exclusively used SASEnterprise Guideto gather data (ETL), data modeling, validate models, prepare reports and have used SAS DI tool for data integration.
• Scheduled batch jobs using Unix and created DataMarts or customized Views as per specific demands.
• Executed UNIX shell scripts that invoked SAS and created datasets in SAS. Connected remotely to UNIX servers using PUTTY across different test environments.
• Participating in Root Cause Analysis meetings/discussions for defects review.
• Involved in ETL migration testing project using complex SQL queries including Joins, Unions, aggregate functions, Group by, views etc.
• 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, usedcalculated and aggregated items, created new hierarchy, insertedimages, 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.
• Performed several ad hoc analyses and created trend reports requested by finance and marketing teams to understand customer/transaction patterns using data.
• Segmented customers based on their consumer patterns which include frequent shoppers, occasional shoppers and dormant customers, etc. and performed longitudinal analysis for the campaigns team. Analyzed customer data which included Behavioral models, Customer Profiling, Segmentation , Trend Analysis, Predictive Modeling , Lift modeling and Validation using SAS and SQL .

Business/Data Analyst

Confidential

Responsibilities:

• Worked as a Data Analyst using SAS and SQL, involved with database migration and data warehousing project. Created SAS Data sets 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.
• Worked with various Tableau Desktop functionalities & capabilities (Filters, Hierarchies, Sorting, Sets, Parameters, Custom Groups, Creating Story, Mapping, Custom Geocoding, etc.) 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 UseCases, 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.
• Created data set specifications or programming specifications in SAS, SQL in accordance with project requirements and good documentation and programming practices.
• Designed dashboards using Tableau and also used SAS VA for exploration and reporting.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC RANK, PROC FREQ, PROC MEANS, PROC REPORT, PROC SUMMARYfor creating a preferred list of customer reports as per the given requirements from business analysts.
• Used SAS and SQL to check for duplication of records and report all errors during data migration.
• Used SAS and SQL queries to concatenate and mergeresults. Used Proc Append and Proc SQL Join queries for appending/merging data results.
• Designed and developed UNIX shell scripts as part of the ETL process, automated the process of loading andextracting the data.
• 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.
• Reviewed the data mapping document regularly for ETL testing and generated customized queries using SQL to verify the requirements. Generated high level test scenarios for testing each phase and then wrote descriptive test cases for each phase and logged defects in ALM and Jira.
• Pointed out ETL issues with regards to migration and provided alternative solutions.
• Used complex SQL queries including Joins, Unions, aggregate functions, Group by, inline views etc. to perform data validation.

Business/Data Analyst

Confidential

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 SQLand 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 andOracle databases to SAS Datawarehouse. Validating results by writing SQL queries and then comparing with original data using tools like BeyondCompare.
• 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 BeyondCompare.
• 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.

Business/Data Analyst

Confidential

Responsibilities:

• 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.
• Involved inverification 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.