SAS DEVELOPER CONSULTAT IS AVAILABLE
Mithilesh Kumakula
| Click here to if you no longer wish to receive our emails |
It’s apleasure reaching out to you.
I would like topresent an Excellent consultant SAS DEVELOPER isavailable immediately for Corp to Corp positions.
May I also requestyou to please share your Corp2CorpRequirements to mith...@econtenti.com
Kindly see the attachment ofconsultant resume and details
Position: SAS Developer
Location: Northbrook, IL
Availability: Immediately
Relocation: Open
Email Id: sasvat...@gmail.com
Kindly see theresume below
Thanks
Mithilesh
Phone:732-447-9738
Fax: (732) 393-8766
Vatsal
CERTIFICATION â— AUTO-CAD 2D AND 3D
SASDeveloper
Summary:
• Around5 years of experience in IT industry with SAS programming, Data Visualization,Analytics and the related Database Platforms.
• Strongexpertise in statistical programming and Data analysis skills like SAS, R andPython.
•Experience in Data visualization tools like Tableau, Tibco Spotfire
• ExperienceMainframe programming languages like JCL, COBOL, CICS
• Strongexpertise in using Tableau software as applied to BI data analytics, reportingand dashboard projects. Worked on Tableau [10.X/9.x/8.x] versions.
• SolidFoundation in use of SAS/Macro, SAS/Connect, SAS/ Access, SAS/SQL, SAS/ODS
• Skilledin using SAS Statistical procedures like PROC REPORT, PROC TABULATE, PROC FREQ,PROC MEANS, PROC UNIVARIATE, PROC APPEND, PROC PRINT, PROC IMPORT, PROC EXPORT,PROC TTEST, PROC CORR, PROC REG, PROC ANOVA, PROC GLM
•Experience in handling large data sets using SAS
•Experience in using SAS to read, write, import and export to another data fileformats, including
delimitedfiles, Microsoft Excel and Databases.
•Proficient in Tableau data visualization tool to analyse and obtain insightsinto large datasets, create visually compelling and actionable interactivereports and dashboards
•Experience working with Extract &Live connections with high data volumesand connecting to multiple data sources like Oracle, MS Access, Excel, My SQLusing Data Blending
•Proficient in design and development of various dashboards, reports utilizingTableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts,Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, WaterfallCharts, Geographic Visualization and making use of actions, other local andglobal filters as per the end user requirement.
• Excellent experience in analyzing andmanaging customer's operational problems related to mainframe functions
• Worked in understanding/gathering therequirements, extensive impact analysis, design of complex Mainframe legacyprojects and provide estimates for all stake holders.
•Experience in Python packages like NumPy, Pandas for Data modification andmanipulation, Matplotlib, Seaborn for Data Visualization and Scikit Learn forcreating statistical machine learning algorithms like Linear Regression,Logistic Regression, K Nearest Neighbours, K Means Clustering, Support VectorMachines, PCA, Decision Trees and Random Forests
•Experience in importing and exporting data from MS SQL Server using ImportExport Wizard
•Extensive experience in MYSQL and SQL and in performance tuning SQL queries forbetter performance.
•Experience in creating complex Spotfire dashboards and visualizations by usingthe key concepts filtering scheme, Data on Demand, property controls, TextAreas in TIBCO Spotfire
• StrongExpertise in creating various complex List Reports, Grouped Reports, cross tabReports, Chart Reports using Tibco Spotfire
•Performed v-lookups in Excel for data comparison within multiple excelworksheets.
•Experience in handling multiple projects.
•Enthusiastic and Goal-Oriented team player possessing excellent communication,problem solving and analytical skills.
•Interpersonal skills and leadership capabilities with high level ofadaptability.
Professional Experience
CVS Health - Northbrook, IL November2018 to Present
SAS Developer
TheCampaign Targeting Analytics Analyst is responsible for performing databaselist pulls for strategic initiatives to support communications to PBM membersprimarily relating to formulary and benefit plan designs.
Responsibilities:
•Executing structured SAS-SQL Teradata code to synthesize large amounts ofrelational data to optimize complex member communications products to keyaudiences.
• Createdvarious kinds of reports based on the BRD/FRD provided by the businessstrategist/Client.
• Createdthe reports in different file types like .TXT files, .CSV file, Excel spreadsheets using DATA _NULL_ and FILE statement, Output Delivery System (ODS) andvarious PROCEDURE steps
•Validating the output files from the program output and updating to themanager.
•Modifying the existing SAS Code based on the business require document.
• Workedon importing data into SAS from various types of sources like .TXT files, .CSVfiles, Excel Spread Sheets and creating the SAS datasets from those inputsusing IMPORT procedure, INFILE statement and LIBNAME engine.
• Workingon the existed data set using SET statement, and subsetting the dataset usingMerge statement using PROC SORT, Conditional Statement, PROC SQL
•Validating the data by querying the Teradata database.
• Workedon Aprimo Tool for accepting, Updating and Completing the task.
•Performing Load Communications by loading the targeted data in customer servicedatabase to help for the customer information.
Environment: SAS/Base, SAS/Macros, SAS/SQL, SAS/Access,Teradata SQL Assistant, MS- SQL Server, SAS Enterprise Guide, MS-Office,Excel/VBA Scripting, Aprimo, Mainframe/Zos, JCL
FedEx WHQ - Memphis, TN November 2017 to October 2018
SAS Programmer/Analyst
FedExCorporation is an American Multinational courier delivery service companyheadquarters in Memphis, TN. Worked with the data integration department mainlyfocusing on integrating FedEx data with the TNT data. In this process, we builtdifferent queries in SAS, Teradata, to perform data accessing, management,manipulation and load the data into target tables and worked with the errorhandling team to consolidate the data by removing the irregularities. Workedwith the information management, product and service department to generateperiodic and ad-hoc reports to the business users for the marketinganalysis.
Responsibilities:
•Retrieved the customer's data from the Teradata database into SAS environmentusing SAS/Access and SQL Pass through facility
• Createdreports based on the business requirement documents and communicated with thebusiness user to know what type of data that must be shown in the reports
• Used SASBASE Data steps and Proc steps for manipulating and modifying the data and forcreating data sets showing the customers information.
• Creationof new dataset from raw data files by using import techniques and UsingDATALINES and Worked on modifying the existed data set using SET statement, andsubsetting the datasets using Merge statement using PROC SORT, ConditionalStatement, PROC SQL
• UsedPython, SQL to create Statistical algorithms involving Multivariate Regression,Linear Regression, Logistic Regression, PCA, Random forest models, DecisionTrees, Support Vector Machines.
•Acquiring data from TNT data sources and maintaining Error databases for theError handling process
•Validating the data to ensure the quality, validity and accuracy of contentreceived from TNT
• Queryingthe Teradata database using Teradata SQL Assistant to acquire the missinginformation for the error data received from the TNT
•Analyzing the Error patterns by creating pivot tables based on the ErrorDescription using Excel
• Creatingstatus reports on a weekly basis for the Error analysis to identify open andclosed errors.
• CreatedError visualization reports using Tibco Spotfire
• Workedon importing data into Tibco Spotfire from different sources like, Excel, SQLServer Database
• Createdmultiple Visualization reports/dashboards using Dual Axes charts, Histograms,filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and WhiskerPlot, Stacked Bar etc.
• Createdinteractive Dashboards and Business Presentations by importing data from Excelsheets using Tibco Spotfire.
•Identifying areas of improvement to make the process efficient and reduce thetime for handling
• UsingExcel functions such VLOOKUP to identify and match relevant records and isolatethe unexpected records
• UpdatingMainframe CICS Screens with correct customers data to update in thedatabase
•Publishing the up to date master data file on SharePoint site for users toaccess
• CreatedVBA automation tools to automate the bulk upload of files to Excel.
•Coordinating with other teams and TNT team to handle specific kind ofErrors
Environment: SAS/Base, SAS/Macros, SAS/SQL, SAS/Access,Teradata SQL Assistant, MS- SQL Server, SAS Enterprise Guide, MS-Office, TibcoSpotfire, Excel/VBA Scripting. Mainframe CICS
Telligent Tech - Dublin, OH January 2016 to October 2017
SAS / Mainframe Developer
Responsibilities:
•Retrieving the data from various sources such as .TXT, .CSV, Excel, differentdatabase into SAS environment using different SAS procedures, SAS/Access andSQL Pass through facility
• Createdreports based on the business requirements.
•Implementation of online screens in Mainframe systems in Health caredomain.
• Workedon SAS Base for manipulating and modifying the data and for creating SASDatasets.
•Performed extraction, transformation and loading from large database tablesusing SAS/ETL
• Createdreports in various formats such as Excel, CSV, PDF and RTF using SAS proceduresand SAS/ODS
• Workedon SAS/Macros to reduce the time for programming syntax and to increase theproductivity of data processing steps
•Developed various dashboards, Network graphs and story boards by combiningvarious dashboards.
• Workedon importing data into Tableau from various sources like Excel, Databases, SASEtc.
• Blendeddata from multiple databases into one report by selecting primary keys fromeach database for data validation.
•Preparing Dashboards using calculations, parameters, calculated fields, groups,sets and hierarchies in Tableau.
•Have an experience ofMainframe coding/developing, release support.
• Created multipleVisualization reports/dashboards using Dual Axes charts, Histograms, filledmap, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot,Stacked Bar etc.
•Developed reports using multiple measures like Individual Axes, Blended Axes,and Dual Axes.
• Reviewedbasic SQL queries and edited inner, left, and right joins in Tableau Desktop byconnecting live/dynamic and static datasets
• UsedAdvance analytics like LOD, Clustering, Forecast, Trend lines, User Definedtable calculation for the creation of dashboards.
Environment: SAS/Base, SAS/Access, SAS/SQL, SAS/Macro,Tableau Desktop 10.x/9.x/8.x, MS Office Suite, SQL Workbench, Oracle 11g, MSExcel/VBA
Citi Cards - India July 2015 to September 2015
SAS/Mainframe Developer
CitiCards, head quartered in Jacksonville, Florida, is part of Citigroup, which isthe largest bank in the world. Citi Cards is the largest issuer of Visa andMaster card in the world with more than 150 million customers in 105 countries.Citi cards has diversified into retail card business with acquisition of Searscredit card business and Home depot's private label business.
SASsolutions and Validation team of Systems Control deals with SAS Requests. SASRequests can be SAS scan requests or File creation requests. SAS scan requestsare raised to pull the details for accounts from various account data files.File creation request includes the requests raised for creation of files toupdate the values for an account or to identify the account.
Responsibilities:
• Createdvarious kinds of reports based on the BRD/FRD provided by the businessstrategist.
• WroteSAS programs in both UNIX/Mainframe platforms
• CreatedVSAM Datasets in Mainframes using JCL.
• Workedon Chageman to install and updated the jobs in the production region.
• Workedon creating mainframe applications using JCL, COBOL, DB2 and CICS
•Experience in developing programs in Mainframes using JCL, COBOL, DB2
• Workedon importing data into SAS from various types of sources like .TXT files, .CSVfiles, Excel Spread Sheets and creating the SAS datasets from those inputsusing IMPORT procedure, INFILE statement and LIBNAME engine.
• Creationof new dataset from raw data files by using import techniques and UsingDATALINES
• Workingon the existed data set using SET statement, and subsetting the dataset usingMerge statement using PROC SORT, Conditional Statement, PROC SQL
• Createdthe reports in different file types like .TXT files, .CSV file, Excel spreadsheets using DATA _NULL_ and FILE statement, Output Delivery System (ODS) andvarious PROCEDURE steps
• Creatingcustomize and summary reports using PROC REPORT, PROC MEANS, PROC FREQ, PROCPRINT, PROC TABULATE as per the given requirements from business analysts.
•Frequently used SAS Options like DROP, KEEP, RENAME, COMPRESS=, OBS= etc. forefficient programming and storage space saving when needed.
• CreatingUNIX Scripts to transfer file between mainframe and Unix Servers.
•Automating the business requirement based on frequency of run (Daily, Monthly,Yearly) provided by business Strategist.
•Installing the automated runs in the Unix production server using the Servicenow and Unix JIL scripts and in Mainframe using the service now and Infomanpackage.
• Created,modified/Updates SAS code in the production jobs to incorporate changes in newaddition of merchandise and re install them in the production server.
•Maintaining the process document for the jobs which are installed in productionserver.
Environment:SAS/BASE (9.2)/UNIX, SAS/BASE (9.2)/MAINFRAME, SAS/MACRO, SAS/SQL, SAS/STAT,MS-OFFICE, JCL, COBOL, DB2, CICS
This email is generated using CONREP software. |
A90024