Career Objective:
Technical Knowledge:
SAS:
Modules include: SAS Base, SAS Macros, SAS SQL, SAS/STAT, SAS/GRAPH, SAS Access and SAS Data warehouse Administrator.
Database Tools:
SQL Server 2000, MS-SQL and MS-Access
Conversion Software:
Quanvert 1.7.3.1
Platforms:
UNIX, Windows9x, Windows 2000 and Window NT
Programming Languages:
VB 6.0, Java, ASP.NET & VB.NET
Certification:
Ø SAS Base Certified Programmer
Employment:
Standard chartered Bank Ltd. From Feb 2007 to Till Date
Business Intelligence analyst – Associate Manager, Datawarehouse
Job Profile:
Ø It’s a business intelligence unit and the datawarehouse team is responsible for the datamart and finance validation for Unsecured, Secured and wealth banking products.
Ø Creating Cards data mart and profit base monthly and validating with finance number and also modifying the codes as per the collection and finance team request.
Ø Dedupe the customer records using the several keys and calculating maximum unsecured exposure for them depends upon their salary and other details.
Ø Maintaining do not call list (DND) database and extracting the data from it as per the request.
Ø Responsible for CIBIL data upload monthly for all cards, PL, Smartcredit, Auto, Mileage, Mortgage, FAS and SME.
Projects: Aug 2007 – Till date
Project : Customer Profitability – BVL2
Tools : Base SAS, SAS SQL, SAS MACROS and SAS/Graph
Platform : UNIX
Client : India
Team Size : 7
Role:
Product level, account level profit bases are created using account level TP system information & values sourced from Finance MIR’s which are allocated.
These bases are then grouped at customer level via X custid.
Responsibility of handling complex coding in SAS
Project Planning and resource allocation.
Preparation of all individual profit bases for all banking products and aggregated at customer level.
Mar 2007 - Jul 2007
Project : NPA bases for all products
Tools : Base SAS, SAS Macros, SAS/Stat, SAS/Graph and UNIX
Client : Internal
Team Size : 5
Responsibilities:
The objective of this process is to create the bases for asset classification in terms of Non Performing Assets and provisioning thereof will be done borrower wise for the purposes of reporting to regulators.
Responsibilities include importing of raw data which in the form of Excel sheets, and collecting inputs from various units across the bank.
And developing sas codes for identifying cross hold products from several bases and written macro to avoid the duplication of customers.
Marketics Technologies India Pvt. Ltd. From Sep 2004 to Feb 2007
Team Leader
It’s a Marketing Research company which provides solution to leverage the customer information so that marketers can design relevant marketing programs, target the campaigns appropriately, and measure results on the back end.
I am handling team of four members.
The major clients are Proctor & Gamble (P&G), USA
Job Profile:
· Strong concepts of Information Systems, Data warehousing, Data Mining & Business Intelligence.
· Involved in using SAS, SQL, and Business Objects to manipulate and analyses data.
· Using simple Proc house-keeping commands like proc import, proc copy, proc append, Proc SQL (for making queries on datasets
· Using all Proc statements, Regression analysis using Base SAS.
· Convert the data from Quanvert to SAS.
· Data analysis varies from simple descriptive statistics like customer profiling and reports, to more complex data modeling like regression analysis, step disc analysis and frequency distribution.
· Generating the Sales data analysis reports using SQL 2000 and OLAP. Identifying potential customers from database and data-marts.
Projects:
Team lead - Marketics Technologies India Pvt. Ltd, Bangalore
July 2006 - Feb 2007
Project : Global hair color architecture
Tools : Base SAS, SAS Macros, SAS/Stat, SAS/Graph and UNIX
Client : P&G – USA
Team Size : 5
Responsibilities:
Leading a team of five members in Global hair color architecture project.
Interfaced with client to assess the exact requirements and volume of metrics reported in several report.
Joining and Linking Multiple Tables.
Performed data integrity checks and data cleaning using SAS/MACROS.
Project Planning and resource allocation.
Issue Log, Defect tracking and Weekly Status Report
Senior Analyst - Marketics Technologies India Pvt. Ltd, Bangalore
Mar 2006 - June 2006
Project : Data stability
Tools : Base SAS, SAS Access, SAS/Graph and Unix
Database : SQL Server 2000
Client : Confidential
Duration : 4 months
Team Size : 7
Role:
Database Clean up and structuring for mailing and analysis Mail merging for a six level personalization, Label Generation, Mail Handling and Dispatch. Batching of responses to assign day of week and time slot for tennis session.
Responsibilities include importing of raw data which in the form of Excel sheets, Text files to SAS datasets.
Sorting the data, removing the redundant data and match merging the datasets.
User defined queries written using proc sql. Report generation using Proc Report, Tabulate, Freq, Summary.
Nov 2005 - Feb 2006
Project : The Paper towel segmentation Project
Client : P&G Geniva
Tools : Base SAS, SAS Macros, SAS/STAT and Unix
Database : Excel and Quanvert
Hardware : Windows XP
Duration : 4 Months
Team Size : 5
Role:
Involved in complete understanding of Business problems and identifying appropriate analysis technique.
Data cleaning and identifying specific attributes for analysis.
Finalizing the base sizes for breaks.
Guidance to juniors for factor analysis and cluster analysis.
Analyzing the results obtained from cluster analysis and profiling.
Business Analyst - Marketics Technologies India Pvt. Ltd, Bangalore
June 2005 - Oct 2005
Project : Bounty US Data management
Tools : Base SAS, SAS Macros, SAS/Stat, SAS/Graph
Client : P&G – USA
Team Size : 5
Role:
Involved in using SAS, SQL, and Unix to manipulate and analysis data. Data analysis varies from simple descriptive statistics like customer profiling and reports, to more complex data modeling like regression analysis, Predictive sales analysis and frequency distribution.
Getting customer contact information from various sources like Event
registrations, Fax-Back forms, eMail responses and telemarketing agents.
Organizing the data into a standardized format using Format Procedure.
Generating the Sales data analysis reports using Proc Reports.
Building Mart tables using datasteps and Warehouse Admin
Mailing activities done to various customers.
Identifying potential customers from database and data-marts.
Mar 2005 - May 2005
Project : The UK
Tools : Base SAS, SAS Stats, SAS/Graph
Database : Quanvert and MS-SQL
Client : P&G
Duration : 3 months
Team Size : 7
Role:
Involved in Data cleaning, analyzing and supporting a reporting system using
SAS BASE and SAS Stats. Final reports are produced by the system both in Excel and PPT format. Also involved in generating reports/listing using
PROC FREQ/TAB/SUMMARY.
Import of customer data from MS-SQL, Quanvert and Excel into SAS
Have done Regression and Structural Equation Modeling analysis. .
Oct 2004 - Feb 2005
Project Title : Global hair care country segmentation
Client : P&G
Operating System: Windows XP
Language : SAS 8.2, SPSS
Others : Quanvert and Excel
Team Size : 3
Technique : Factors and cluster analysis
Role:
Involed in the data mining and factor and cluster analysis.
Fixing the factors and used those factors in clusters to find out necessary segmentation results.
Have done SAS macros to automate cluster analysis methods.
Educational Qualification:
# B.E Computer Science in Mahendra Engg.college. from Periyar
University In 2004 with 70.5 %.
# H.S.C. from ST.paul’s higher secondary school In 1999 with 84 %.
# S.S.L.C. from Little flower higher secondary school In 1997 with 79%.
Personal Details:
References upon Request.
No comments:
Post a Comment