Hemant Kamal -Latest.doc (1)
Download as DOCX, PDF0 likes101 views
This document contains the career profile of Hemant Kamal, who has 5 years of experience in SAS Reporting and Analytics. He currently works as a Senior Analyst at Loyalty Solutions and Research Pvt. Ltd, where his responsibilities include developing marketing reports using SAS tools, maintaining SAS code, and ensuring delivery of reports and data to partners. Previously, he has worked as a Senior Analyst at EsselGroup India Pvt Ltd and as a SAS Programmer at Vivante Technologies, where he gained experience in tasks like data migration, report generation, campaign management, and data analysis. Hemant Kamal holds an MBA in Finance and a BA degree.
More Related Content
What's hot (20)
Similar to Hemant Kamal -Latest.doc (1) (20)
Hemant Kamal -Latest.doc (1)
- 1. Hemant Kamal Mob : 9711661716 Email : hemant0810@yahoo.in Career Synopsis  5 years of experience in SAS Reporting & Analytics.  Working with LSRPL(Payback) as a Sr Analyst.  Extensive experience in Data Analysis,Producing Reports,Analysis Datasets using Various SAS Tools and Unix Scripting  Work proficiency SAS /BASE, SAS-EG, SAS Info Maps, SAS Dashboard and Web Report Studio, PROC /SQL,My SQL and SAS-CI for Campaign Management,Scheduling and deploying of SAS Jobs  SAS BI Reporting and Analytics  Experience working in UNIX environment, SFTP/FTP.  Extensively involved in Data cleaning.  Excellent organizational, teamwork, presentation and interpersonal skills. Technical Skills  SAS Tools : SAS/BASE, SAS Customer Intelligence Studio for Campaign Management, SAS-Information Map, SAS – Enterprise Guide ,SAS Dashboard and SAS Web report Studio and Exposure to SAS Data Integration studio  Operating Systems : Windows XP, Vista, Windows 7  Database : My SQL, Professional Experience Organization : Loyalty Solutions and Research Pvt. Ltd (Payback) as Sr. Analyst Duration : September 2014 to till date Responsibilities:  Development of new Marketing reports through extensive use of SAS-Base and Advanced, Macros.  Maintaining existing SAS deployed codes and scheduling the ETL Marts and Reports through SAS and Unix scripting.  Ensuring Ad-hoc delivery to the partners as per the requirement  Preparation and Maintenance of ETL updates.  Preparation of data and its validation for the Modelling team.  Making the Current data warehouse more effective and efficient.
- 2. Organization : EsselGroup India Pvt Ltd (Dish TV) as Sr. Analyst Duration : June 2013 to September 2014 Responsibilities:  Data Migration of Current data from SQL Database into SAS and Configuration of Marketing Campaign through SAS-CI  Preparation of Data-Mart in SAS –DI as per the requirement of the Marketing Department.  Preparation of Marketing reports through Web Report Studio.  Building Information maps and cubes that can be further used for Reporting and Campaign.  Making the Current data warehouse more effective and efficient.  Providing training and mentoring to the functional users so that they can make reports and design campaign on their own thus eliminating dependency on IT  Campaign Management through SAS CI  Customer segmentation.  Finding Patterns in Customer Data.  Driving insights after merging data from multiple sources and presenting it to the Senior Management.  Driving insights and helping marketing team to build strategies Previous Organization : Vivante Technologies as SAS Programmer Duration : July 2009 to May 2013 Project Details: Project : SAS Analytics, Consulting & SAS Algorithm Customer Matching initiative for an US Bank Client : US Major Bank Environment : SAS Enterprise Guide, MS Excel Responsibilities :  Working in a team of Analysts engaged on De-Duplication Analytics (Customer Matching)  Review the current customer matching process to Assess and quantify qualitative and quantitative impact of poor matching and Improve matching efficiency of the current matching process.  To provide business acumen in understanding the problem and structure. Project Details: Title : Banking System Team Size : 08 Duration : January 2011-February 2012 Environment : SAS/BASE, SAS/STAT, SAS/GRAPH,SAS/MACRO,SAS/ODS, SAS/SQL.
- 3. Description: The client is one of the leading banks and it has many branches across the globe. Main aim of bank is to provide finance to the customers through credit cards. The bank has other operationalactivities like opening an account,personal loans, vehicle loan, house loan,withdrawals of money transactions while done through ATM’s, Cheque, credit card transactions. These banks have historical data of years of years. All these details contain daily transactions, which are given by clients, were given to us. The project involved extensive use of Base SAS, SAS/Macros,SAS/Access and SAS/Reports. Job Responsibilities:  Prepared customized reports to help client provide a strong competency in understanding risk and accordingly perform better customer selection and customer satisfaction.  Deleting or replacing missing values in the datasets by using SAS statements and procedures like PROC FREQ AND PROC MEANS.  Combined data from various sources to create SAS data sets by using Set and Merge for generating Reports.  Worked with complex datasets to extract customized reports using PROC SQL, PROC SORT, PROC REPORT, and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.  Generated output files in text format, HTML, PDF and RTF format using SAS/ODS. Client : S.J.R.T IMPEX Pvt Ltd. Designation : Sr. Business Operations Executive Duration : July 2009-December 2010 Responsibilities:  Act as interface between company and customs department & providing day-to-day tasks in order to secure daily operations and agreed service levels.  Provide import & custom papers to Clearing house agents  Keep track of the goods and its quantity as per the Shipping documents & Packing order  Follows up performance and delivery accuracy for own/named customer/area  Updating clients about latest consignments through email  Keep record of the segregated goods and send the report to the Management Worked with IBM DAKSH Gurgaon from 18th July 2007 to 25th June 2009 for an U.S. based Health Insurance Company as a Process Executive in backend process. Responsibilities: Processing Health Insurance related Claims which include  Initial set up of claims  Status Updation  Processing claims as per the guidelines provided by the Health Insurance Company  Payment issue  Closing claims  Allocation of claims to team members
- 4.  Work on the projects sent by client Academic Profile  MBA ( Finance) from ICFAI University in 2012.  Graduation (BA Pass) from Delhi University in 2007.  12th passed from CBSE Board in 2004 Personal Details Date Birth 08 Oct, 1986 Father’s Name Sh. Shyam Singh Kamal Gender Male Nationality Indian Date: Place: (HEMANT KAMAL)