| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Chandra Shekhar DeshmukhMobile: PHONE NUMBER AVAILABLE EMAIL AVAILABLEProfessional Summary Having 15 years Extensive experience in Data Analysis , Data engineering ,Data Quality ,Data migration , along with SAS,AZURE/ AWS data bricks. Extensive experience in SAS programming and data analysis using BASE SAS software in WINDOWS and UNIX Environment. Integration of both traditional and emerging data sources with SAS customer intelligence CI. Hands on experience in SAS programming tasks such as extracting and merging SAS data sets, writing SAS procedures, macros, validating data, producing reports, and using SAS formats and functions. Experience with SAS procedures such as PROC IMPORT, PROC EXPORT, PROC TABULATE, PROC SORT, PROC FORMAT, PROC PRINT, PROC MEANS, PROC FREQ, PROC REPORT, PROC TRANSPOSE, PROC SGPANEL and PROC SGPLOT.
Modified existing SAS programs and created new SAS programs using SAS Macros to improve ease and speed of modification as well as consistency of results.
Experience in data management tasks such as data extraction, data validation, data processing, data cleaning, and data analysis.
Proficient in preparing business specific and adhoc reports using key performance metrics for senior management and business partners for presentation, forecasting and further analysis.
Proficient in all regression steps of missing and capping treatment, variable transformations, bivariate analysis, logistic regression, scoring and validation.
Excellent analytical, problem solving, communication and interpersonal skills with good knowledge in finance and credit cards business domain. Has expertise in Oracle 10g, TOAD 8, SQL Server 2005, SAS (Enterprise BI Server), Cube Designer (SAS OLAP Studio). Using SAS/SQL for extract, transfer and load ETL methodology and processes. Good analytical, conceptual and strategic thinking and planning. Star Schema and Snow flex Schema in SAS DI. Having expertise on Hive and Python, tableau.Education:
MCA in Computer Science at University of Pune ,2009 Pune, Maharashtra BCA in Computer Science at Makhan Lal Chaturvedi Rastriya Pratrakarita University ,2005 BhopalTechnical Skills:Operating System Windows 2000, Linux, MVS/ESA, OS/390, z/OSEnvironment Client/Server,
Database Oracle 10g/9i/8i, Oracle Clinical 4.x, MS Access, SQL Server , Hive, DB2 , TeradataInternet Tools HTML, ASP.net , JSPSAS SkillsSAS/BASE, SAS/PROC, SAS/SQL, SAS/ODS, SAS/Graph, Stored process, SAS/Intranet, SAS/MACRO, SAS Enterprise Guide, SAS Information Delivery Portal , SAS Information Map Studio , SAS Management Console, SAS Web Report Studio , SAS BI Dashboard , SAS Enterprise Report. , SAS OLAP Cube designer, SAS DATA Integration Studio (ETL)., Hadoop, python , SQL/HIVE, SAS, SAS Enterprise Guide 7.1.Languages C, PL/SQL, UNIX, Shell ScriptingOther Data Modelling, Excel, SAS Enterprise Guide and DI
Functional:Management and Leadership Skills Business Analysis and DevelopmentTraining & development
Banking and Health insurance domain using SAS/HIVE/SQLProfessional Experience:
Barclaycard 07/2019 Current DateBICEP- Barclaycard (USA), SAS ConsultantProject Description:The overall objective of this project is to migrate all existing 1View USA Cards SAS processes/ AZURE data brick from the SAS 9.2 environment to a new SAS 9.4 Grid environment. Responsibilities: Handing 16 processes and SAS jobs (700) including dependencies for scheduling
Worked extensively with business users on requirements gathering, analysis and documentation. Existing process and job documentation, including implementation plans and amendment
Modifying data using SAS/BASE and Macros. Worked on analysing medical claims data and interfacing SAS with MS office applications such as Access/Excel. Built, maintained, and scheduled SAS production SAS jobs source code (Autoexe and global program) Data in BIW 2.0 and views to create equivalence to 1View from the Colossus program. Build prove area or Test data location for all environment. X command replacements from the Barclays platform team Tivoli scheduler: Run and Monitor of flows ETL /Data lack creation and reporting in Azure data bricks
Environment: SQL/HIVECiti Financial Services - NY 07/2018 06/2019RSIM Retail Services information management - SAS DeveloperProject Description:The project involves in Customer data intelligence for credit card portfolio for sears master card which will be extracted from different data sources/vendor and detailed tables for subject areasResponsibilities: Prepare the data and data analytic as per the business requirement Working into extract, testing and impact the data from lending transformation areas over the different Country. Run the Daily, weekly and monthly Dashboard production batch. Data analytics for CR data as per business demand
Generate different matrix or dashboard as per need. Adhoc request handling as per business demandEnvironment: SAS, SAS Enterprise Guide 7.1.
PNC Financial Services - PA 01/2018 06/2018SAS Developer -Retail risk and Lending TransformationProject Description:The project involves Retail and risk and their other business segment, line of business, Credit Card, HE, Helot Details which will be extracted from different data sources/vendor and detailed tables for subject areasResponsibilities: Prepare the data and data analytic as per the business requirement Working into extract, testing and impact the data from lending transformation areas over the different Country. Run the Daily, weekly monthly production batch. ETL design for source to target mapping, testing for different banking vendor.Generate different matrix or dashboard as per needEnvironment: SAS, SAS Enterprise Guide 7.1.USAA - SAN ANTONIO, TEXAS 06/2016 17/2017SAS Developer - Credit risk strategy execution managementProject Description:The project involves different investment banking client and their business segment, line of business, Credit card and HE details which will be extracted from different data sources and detailed tables for subject areas sources and detailed tables for subject areas.Responsibilities: Prepare the data and data analytic as per the business requirement Working in EBA to extract the data from different subject areas over the different Country. Run the Daily, weekly monthly production batch. ETL design for source to target mapping for different banking clients. Generate different matrix or dashboard as per needEnvironment: SAS, SAS Enterprise Guide.AETNA- India 12/2014 06/2016SAS Developer - ASH Data warehouseProject Description:The project involves different subject areas which will be extracted from different data sources . And detailed tables for subject areas. On the top of it MDS will be created as summarized table. Detailed Tables are considered for each subject area, and there will be one summarized MDS table which will have data elements from all subject areas as well data Analysis over the different states.Responsibilities: Involved in requirement gathering, discussion and gap analysis, ETL design, coding and testing as end to end DataMart creation for ASH. Working in ASH to extract the data from different subject areas over the different states. Coordinating with onsite team for requirement gathering, product enhancement and testing
Environment: SAS Base, SAS BI Enterprise Server 9.2, SAS Enterprise Guide 4.2ANTEM 01/2013 12/2015SAS Developer -INFOMART Data Analytics and ReportingProject Description:Infomart and there reporting application deals with the maintenance and functions related with Insurance offered by the client across the USA region. As well data Analysis over the different states.Responsibilities: Development and Maintenance of Data warehouse and Reporting for business. Handling data for Business or Region. Dash boarding and Reporting for Business or RegionEnvironment: SAS Base, SAS BI Enterprise Server 9.2, SAS Enterprise Guide 4.2AMEX - NY 06/2012 01/2013SAS Developer REPS Data ware housing and ReportingProject Description:REPS project is to build a process to extract data from upstream source systems and create a master data set MCA and BCA for data warehouse and reportingResponsibilities: Development and Maintenance of data warehouse for EMIA Market. Handling data for particular Business or Region. Dash boarding for Business or RegionEnvironment: SAS Base, SAS BI Enterprise Server 9.2, SAS Enterprise Guide 4.2, SAS Information Delivery Portal. SAS OLAP Cube designer, SAS DI Studio, SAS Information Map Studio, SAS Management Console 9.2., SAS web report Studio, SAS BI Dashboard and Stored process server, Oracle10g, Windows 2003 Server, UNIXGE - India 05/2011 06/2012SAS Developer -HR Analytics Reporting
Project Description:HR Analytics Report designed to improve the quality and Analysis. Data for HR Analytics and Generating Dump variable as required different Model and reports listings, summaries and graphs for submissionResponsibilities: Extracting data from data warehouse, understanding the data and testing it. Different kind of data sets Testing and Variable Testing as per the requirements.
Find out the Variable which used in HR System. Find out the attrition rate for particular Business or Region (here we have also perform Testing). Creation of Dump variable and checking or Test as per Business rule. Created SAS data sets in local SAS directory and Test it creation one is matching or not. . Responsible for converting the business rules to SAS Datasets and then used to generate Dashboard, model, and reports. Created reports and efficacy reports using PROC REPORT for publishing and submissionEnvironment: SAS Base, SAS BI Enterprise Server 9.2, SAS Enterprise Guide 4.2, SAS Information Delivery Portal. SAS OLAP Cube designer, SAS DI Studio, SAS Information Map Studio, SAS Management Console 9.2., SAS web report Studio, SAS BI Dashboard and Stored process server, Oracle10g, Windows 2003 Server, UNIX
|
