EXPERIENCE SUMMARY:

• 7+ years of relevant professional experience as a Senior Data Analyst/ Looker Developer & SAS Developer across healthcare, Retail, insurance and Banking industry in a high placed work environment.
• Having 5+ year experience as a SAS Developer and 2+ Years as a Looker Developer.
• Extensively used SAS Tools like SAS Base, Macros, SQL, ODS, Access, Connect, Graphs, SAS EG and Looker - Lookml
• Experience with developing Lookml models, looks, and dashboards
• Develop, Designed and Support Interactive dashboards, reports and exception Reports.
• Extensively used SQL runner in looker for creating derived tables and created Lookml to get the functionality as per the business requirements.
• Provide production support for looker dashboards and reporting solutions along with performance tuning
• Having good knowledge on Tableau, R & Power BI.
• Experience on retrieving and loading the very large volume of data (i.e., Terabytes) from and to different databases like DB2, SQL Server, Oracle, Teradata, Hive.
• Expertise with SAS programming and proficiency with shell scripting on a Linux/Unix platform, SAS Grid Environment and Windows Environment.
• Good Experience on System Development Life Cycle (SDLC) methodology for the Analysis, Design, Development, Testing and Maintenance of various SAS projects.
• Analyze data and interpret trends or patterns in complex business processes using data analysis software and techniques.
• Having experience in Scrum/Agile methodology.
• Analyze large data sets to facilitate management reporting. Data analysis activities may include data cleansing and transformation, developing trend reports and forecasts, bench marking results against competing data sets.
• Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL Process.
• Experience in setting up connections to different Databases like oracle, SQL, DB2, HADOOP according to user requirement
• Experience in using SAS/BASE, SAS/MACRO, SQL, SAS/STAT, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/GRAPH, Excel, and MS Office tools.
• Expertise in using SAS ODS facility to create HTML, RTF, XML and PDF files
• Experience in extracting data from flat files, Excel spreadsheets and external RDBMS (Oracle) tables using LIBNAME and SQL PASSTHRU facility.
• Support the development of business requirements and completion of software testing activities associated with the delivery of applications and financial models to clients.
• Interpret and communicate results of data analysis and model output to clients accurately and effectively.
• Support analysis related to client business problems using valid statistical methods and tools.
• Comfortable in working with UNIX environment and UNIX scripts.
• Experience with data management software Level-headed calm able to work efficiently in high-stress situations and with imminent deadlines. Ability to relate relevant information to for keeping consistent and accurate record

TECHNICAL SKILLS:

Technologies: SAS: Base SAS, Macros,SQL, Stat, Access, Connect, ODS, Graphs, SAS BI, SASEGLooker, Tableau, R, Power BI, MS Office

Operating Systems: UNIX, WINDOWS, Mainframes

Databases: DB2, Oracle, Teradata, SQL Server, Sybase

WORK EXPERIENCE:

Confidential

Looker Developer/ SAS Developer

Responsibilities:

• Follow the agile/sprint methodology and gather the requirements from the business and Preparing Technical & Functional Specification documents for project.
• Used SAS & Informatica for ETL and creating the data mart tables for reporting and analysis.
• Created Lookml views from data mart tables and developed models for looks and dashboards.
• Created Lookml views by writing complex SQL in Sql runner in for creating derived tables.
• Having good experience in creating dimensions, Measures, calculated measures, Custom measures, custom dimensions, table calculations, creating filter and dynamic filters parameters.
• Monitoring production changes via Bit Bucket.
• Have a good knowledge Bit bucket commands for the process the pushing Lookml codes into prod environment using Linux.
• Created and helped to lot of end users for scheduling the reports in looker.
• Created lot looks user on user activity to monitor the usage on server level.
• Have been presented no of dashboards to business to explain the functionality of looker.
• Having good Looker Administration experience in upgrading the looker (from 21.6 to 21.8) giving the permission group level, user and domain level, Tracking the user activity for the performance issues, monitoring the dashboard scheduled jobs.
• Created dynamic dashboards for monitoring the PSJ Jobs in order to identify the log running jobs.
• Created number of legacy dash boards and helped in migrating into new dashboards.
• Having experience in migrating dashboards from TEST environment to PROD using include Dashboard Lookml.
• Create & modified the SAS Code to extract large volume (Terabytes) of data from flat files, excel files, .dat files, Oracle, Teradata and created into SAS data sets.
• Writing the complex SAS Scripts to by making use of existing Source code to simplify the resource contention in multiple environments like Windows, UNIX
• Develop the SAS Macros to reuse and execute the Scripts dynamically.
• Preparing different test plans that fits for components test and tracking system defects and executes them for every scenario thoroughly.
• Discuss with project team members for repeating issues/problems and prepare the improvement plan for new or existing issues.
• Track each system defects in service now tool as Incident tickets, problem tickets made analysis and suggesting code review options to meet business needs.
• Build the different dashboards for technical defects incident, problem and change ticket and will share with the team and project management.
• Automate the dashboards for Daily/weekly/monthly/yearly scheduling and send the email notification with dashboard reports to managements
• Collating and presenting the recommendations and insights that would enable continuous measurable improvement in the client’s business decisions
• Explore and implement new technologies related to the project’s performance improvement and sharing across the project team members.
• Creates the customized dashboards like problem, incident tickets, etc. for across the teams for multiple usage.
• Identify and understand the problem by going through the issue and preparing the RCA (Root cause Analysis) document for the .
• Interacting with respective business team and Delta Dental team members through emails and meeting.
• Analyze the complex problem and prepare the resolution plan to resolve the problems.
• Communicate with the business teams for resolving the problem

Confidential

SAS developer/ Data Analyst

Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Created the SAS Regression Scripts and for validating the migration data between the source and target environments.
• Automated the process with Shell Scripts and generate PDF reports with the differences.
• Analyze the PDF reports if differences and reach out to the respect teams and correct the data.
• Designed and developed Extract, Transform, Load (ETL) processes using SAS to populate Data Warehouses and Reporting Data Marts.
• Write the SAS Programs to extract large volume of data from Oracle, Teradata and created into SAS data sets.
• Performed data analysis, created reports & graphs with extensive use of BASE SAS & Macros with the help of SAS Report procedures.
• Created reports using SAS from Teradata database tables into different reports like HTML, PDF and RTF.
• Experience on Change Management procedures and version control for SAS code
• Document the all the programs, organizing process flow, developing the macros, graphs and charts using Enterprise guide.
• Create Unix shell scripts and DOS scripts for running batch jobs to extract, merge, manipulate and analyze large volumes of healthcare data.
• Developed UNIX shell scripts as part of the automation of Secure file transfer protocol (SFTP) in production environment through ECG (Electronic Communication Gateway).
• Key player in interacting with business team to understand issues and propose solutions.

Confidential

SAS developer

Responsibilities:

• Responsible for full cycle of reporting solutions for all Credit cards payment’s using SQL Assistant and implementation of the data visualization solution for wells Fargo retail services LOB.
• Developed work flow base on business process requirements and In-depth understating of complex tables to generate level of details, analytics, joins & Blends and extracts.
• Updating ticket raised tasks work notes day to day.
• Involved in developing and providing technical, analytical and reporting support to the retail business needs in all the categories like customer information, employee information & industry.
• Worked on migrating the code & process from local code to shared SAS environment to leverage scheduler tools and reports can be triggered by any associate.
• Responsible for pulling data from Teradata to develop reports for all the tickets related to Rush plastic fee, Late fee, cash advance fee, ODP fee, BT fee, Merchandise Finance Charges and more which are in retail services for whole USA and Canada.
• Generating reports in transaction level to help in building to find out Fraud transactions to control and report to related departments.
• Created different types of summery tables and listings tables using PROC MEANS, PROC TABULATE, PROC REPORT.
• Designed and developed SAS datasets from various sources like Excel datasheets, flat files and Oracle creating reports and files from existing SAS datasets.
• Used PROC UNIVARIATE and SAS/STAT procedures for analyzing the transactional data on a weekly basis.
• Written SAS/SQL code to support the development of an item and test analysis system.
• Used SAS PROC SQL, pass through facility to connect to tables and created SAS datasets using complex SQL join conditions.
• Responsible for delegating work to the team.AuditingQA weekly production at 95% or greater.
• Designed and presented technical specifications. Assisted for project artifact documentation in business requirement documents, functional specs, flow charts and system architectures source to target mappings.
• Displaying various reports and models results on SAS Web Report Studio via SAS stored process for diverse bank departments.
• 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 market research and segmentation analysis using R, SAS and Excel to get the potential target customers and identify the market trend and opportunities for the retail products for the LOB.
• Research and report variances forauditingpurposes and Managed and auditingprocess to support business needs.

Confidential

Data Analyst / SAS Programmer

Responsibilities:

• Responsible for extracting the data, cleaning, manipulating, transferring and managing data in SAS.
• Experience in entering, analyzing and coordinating data, generating tables, listings, graphs, and reports.
• Extracted data from Oracle table, performed quality checks, validated the data, and created SAS datasets. Modifying data using SAS code by importing, sorting, merging, and restructuring.
• Analyzing the data sets, generating statistical reports using PROC tabulate, PROC report
• Experience in data transformation and edit checks.
• Performed quality checks on the existing table, listing and figures, Tested and debugged SAS programs against data.
• Used SAS PROC SQL to extract data from different relational database management (Teradata) systems.
• Also cleaned the data using SAS code (SAS Macros) and develop SAS Code on UNIX according to the specifications.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS/Base, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Debugging and correcting the syntax and semantic errors in the code.
• Read datasets with a lot of missing values using MISSOVER and TRUNCOVER.
• Created reports in the style format ( PDF and HTML) using SAS/ODS.