Data Analyst Tableau Developer

Sanjay Kumar

Data Analyst (SAS/ Tableau Developer)

PROFESSIONAL SUMMARY

●Data Analytical professional with 10 Years of experience in Banking, Pharma and HR Analytics applying SAS programming, Python, Power BI and Tableau, performing Data analysis, profiling and composite report.

●Extracted data for reporting from departmental and enterprise sources. Administered the design and development of data structures and data extracts to support comprehensive data collection, loading, and extraction needed for reporting.

●Developed and maintained supporting documentation of measurement methods and algorithms, data sources and reporting processes.

●Provide support and documentation (data/metric definitions, exceptions, common questions, etc.) to facilitate other domains use of the data to support their business needs.

●Work to identify and automate tools that deliver routine performance information.

●Review reports and analyses and test datasets.

●Used SAS and SQL to perform ETL from oracle and Teradata database, and created SAS datasets, SAS macros, proc/data steps and SAS formats as required.

●Good understanding and In-depth knowledge on Tableau, Power BI, Python, PROC SQL, SAS EG,SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/MACROs, SAS/ODBC and SAS/ACCESS, SAS/EG, SAS studio, SAS Viya.

●Analyzing Banking, HR and Retail Data, generated reports, tables and graphs. Used Statistical procedures like PROC FREQ, PROC MEANS and PROC UNIVARIATE on data using Data Validation and Data Cleaning.

●Employed Tableau best practices formulating reports, developing sql reports and created advanced Tableau dashboards.

●Manage quality standards of data consistent with best practices of data management.

●Develop new and modify existing SAS/SQL code to meet project objectives.

●Run SAS/SQL code to assess, clean, validate and analyze large datasets to support email campaigns.

●Extensively used PROC SQL joins and PROC SQL set operators to combine tables horizontally and vertically.

●Used SAS/SQL pass-through facility for connecting to various data sources.

●Maintaining of on-going reporting for the dashboards and reports developed by others.

●Created groups, hierarchies and datastes to develop summary levels and detailed reports.

●Developed daily and monthly dashboards in Tableau to track the volumes of different process for trend analysis.

●Created Summary repots using SQL summary statistics for daily reporting.

●Developed reports using calculated fields, Parameters, Sets, Groups, Bins and Trend Line options Using Tableau

●Worked on Tableau Server and Scheduling reports.

●Gather data requirements from various stakeholders/ business users.

●Review and confirm data requirements with various stakeholders/ business users.

●Perform data mapping to the respective data sources - table, field name.

●Expertise in Problem solving and Created Macros to improve the efficiency of report generation and automation of programs and maintenance.

●Practiced Agile Frameworks such as Scrum, Kanban.

●Have written complex SAS/SQL Codes to generate daily, weekly and monthly reports using various SAS procedures, Macros and SQL procedures.

●Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel, PDF and access tables and RDBMS.

●Technically strong in designing HTML, RTF, CSV and PDF formatted files using SAS/ODS.

●Good Working knowledge in Ad-hoc programming for data management departments.

●Uses effective communication to set clear expectations and smoothly resolve issues among customers, partners, subordinates, peers, and supervisors.

Experience Profile

●Working as Data Analyst at Synchrony Financial, Alpharetta, GA (Currently Remote) from January 2018 to till date.

●Worked as SAS Analyst at ADP PVT LTD, Hyderabad from April 2016 to January 2018.

●Worked as SAS Consultant at SymphonyTeleca, Bangalore from January 2013to April 2016.

Educational Profile

●Master’s in Business Administration with Statistics, April 2013Jawaharlal Nehru Technological University, Andhra Pradesh, India.

●Bachelor of Science, May 2010 Osmania University, Andhra Pradesh, India.

Microsoft Certifications

●Querying Microsoft SQL Server 2012

●Administering Microsoft SQL Server 2012 Databases

Technical Competencies

Statistical Packages : SAS 9.4, SAS Enterprise Guide 9.7, Tableau

Databases : SQL Server 2005/2008/2012, Oracle, Teradata, Netezza

Technologies & Tools : Power BI, Base SAS, SAS/SQL, SAS/Macros, SAS EG,SAS Viya, Advanced SAS, SQL Server, Tableau

Operating Systems : Unix, Windows, Vista/XP/2000

Packages : MS Office 2007/2010/ 2013

Project Profile

Project #3 : Collections & Credit Risk Strategy Implementation

Organization : Synchrony Financial

Location : Alpharetta, GA

Role : Data Analyst

Tools : SAS 9.4, SAS Studio, SAS Enterprise Guide 9.7, SAS Viya, Tableau

Duration : January 2018 to Till Date

Roles and Responsibilities:

●Implemented collections strategies across all the due stages (2-7) to collect the due amount from the account holders

●Created Daily, Monthly and Quarterly Reports.

●Responsible for sending Letters, Emails and SMS to the right population.

●Proactively collaborating with the strategy team to ensure implementation is delivered accurately and strategy sheets are accurate.

●Designed summary reports/controls to identify any gaps or potential issues in the process at the earliest.

●Making sure each job runs every day it is supposed to, codes new strategies continuously and send Letters, Emails and Texts as Strategically designed.

●These processes consist of multiple data pulls, multiple file transfers as well as process notifications to several process owners.

●Identifying issues in the strategy sheet and scheduled meeting with strategy managers to make sure that we are consistent with the strategy.

●Responsible for running Quarterly Settlement Campaigns.

●Created Month over month dashboard to see the data volumes at a one glance using Tableau.

●Created Inventory dashboard for various clients of PLCC and PSCC using Tableau

●Gather data requirements from various Strategy Managers/ business users.

●Actively Scheduled review calls with strategy managers and team to make sure that we have the right strategy

●Supported Validation teams to overcome challenges during Validations.

●Created Summary reports for easy Validations.

Project #2 : Strategic Workforce Planning

Organization : ADP PVT LTD

Location : Hyderabad (INDIA)

Role : SAS Analyst

Tools : SAS 9.4, SAS Enterprise Guide 9.7,Tableau, Python

Duration : April 2016 to January 2018

Roles and Responsibilities:

●Good experience with sophisticated Base SAS development for performance enhancement and advanced SAS Dataset storage best practices.

●Developed reports using calculated fields, Parameters, Sets, Groups, Bins and Trend Line options Using Tableau

●Worked on Tableau Server and Scheduling reports.

●Gather data requirements from various stakeholders/ business users.

●Review and confirm data requirements with various stakeholders/ business users.

●Perform data mapping to the respective data sources - table, field name.

●Review filtration/ transformation rules.

●Extensively used Pandas, NumPy, Seaborn, Matplotlib, Scikit-learn, SciPy and NLTK for developing various machine learning algorithms.

●Used

●Beautiful soup Beautiful soup to scrape the web pages.

●Graphical representation of data for different Business units.

●Prepared a geographical footprint of 3 years headcount for different regions of the organization to compare the headcount growth and the expected future years using SAS-Graphs(Geo Maps)

●Presented Trend Analysis of different staffing types like (Home shore, nearshore, offshore, etc..) using SAS Stacked Bar graphs

●Handling Enterprise Data Warehouse and mapping data from multiple sources (including flat files, Excel), building and implementing the data flows and loading the data into a SAS Analytical/Reporting data mart.

Project #1 : Imapctrx

Organization : Symphony Teleca

Location : Bangalore (INDIA)

Role : SAS-Data Analyst

Tools : Base SAS, SAS EG, EXCEL VBA

Operating Systems : Windows

Duration : January 2013 to April 2016

Roles and Responsibilities:

●Consolidating data and operationalize and create robust / interactive product portfolio reporting that is timely (daily) and accurate.

●Involved in writing code using data step programming and macros to extract, clean and validate data from external source and compare with the source programmers output

●And create smaller but more efficient datasets that can cater to reporting that is automated, support and helps to create analytic Dashboards for lagging and leading indicators, support the re-carding exercise program by creating an accurate and automated tracking & campaign upload mechanism.

●Created Market share trend analysis to compare all IMPACT RX products benchmark comparison and trend Analysis.

●Gathering client requirements for adhoc report, extracting the data from the database, performing quality checks, devising codes and procedures, delivering and testing the same and prepared SAS Macros for Projects.

●Developing Data maps and data mart for the products using SAS DI Studio.

●Proficient with running SQL, SAS Macros and SAS ODS, and working with complex data structures in extracting and transforming data.

●Validating the data and examining the quality and detail of output reports, according to the procedures and standard and ensure the quality of deliverables meet internal standards

●Automate existing reports using SAS Macros and PROC SQL, VBA to reduce manual intervention and optimize performance using Statistical procedures like PROC FREQ, PROC MEANS.

●Created water fall charts and data visualization in SA/Graphs to compare the MOM and YOY growth rates in various pharma products.

●Extensively used Proc Tabulate and Proc Print to Generate Reports

●Automate the adhoc queries into regular reports

●Optimize the data preparation & data analysis scripts with respect to data access methods, access performance, storage, data integrity, system performance & system availability.

●Generation, delivery and support of technical development of new and existing daily, weekly and Monthly Management Information (MI) reporting and understanding the requirements of the various operational and MI reports and monitor the output to identify the trends and thus the business flow.

●Validating the data and examining the quality and detail of output reports, according to the procedures and standard and ensure the quality of deliverables meet internal standards

●Explore and develop tools and technologies to support the MI Development methodology, across requirement gathering, development, delivery and testing.

●Automate existing reports using SAS Macros and PROC SQL, VBA to reduce manual intervention and optimize performance using Statistical procedures like PROC FREQ, PROC MEANS.

Contact this candidate