Lalit Kumar Singh

Mobile No: +919*********

E-mail: actbsk@r.postjobfree.com

Career Objective:

Lead the roll in analytics domain to help business in better decision making, gaining competency and profitability with evidence-based insights from operational data analysis and reporting.

Summary:

Worked on SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/GRAPHS, Excel (Formulas, V-Lookup, H-Lookup. Index Match, Pivot Table, Pivot Chart, Bar, Graphs etc).

Data management skills like Merging, Handling missing values, Reading raw data files, creating data structures, Handling programming errors, Accessing and Managing data, Appending, Concatenating and Interleaving of SAS datasets.

Importing and Exporting Excel and Access files using LIBNAME, PROC IMPORT, PROC EXPORT and PROC SQL.

Data Merging, Data Subsetting with use of PROC SQL, MERGE and SET statements.

Knowledge of Statistical Analysis – Correlation, Simple & Multiple Regression, Chi-Square, Analysis Of Variance, Cluster, Factor and Logistic Regression.

Optimized performance using Data Validation and Data cleaning using Statistical procedures like PROC FREQ, PROC MEANS, and PROC UNIVARIATE.

Comprehensive prepared reports using SAS report generating procedures like PROC PRINT, PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS and PROC TRANSPOSE.

Core competency using operational data and getting inferential input to be provided for business decision support by using technical tools like SAS (Base and Advanced), SAS/SQL and SAS/MACRO.

oData Analysis and Manipulation: SAS, SAS/SQL, Excel.

oAdvanced Analytics Technique: SAS/MACRO.

Ability to understand the business problem, strategically planning and client communication.

Ability to analyze complex data and communicate and disseminate this information to lay people clearly and accurately.

Highly motivated, positive and goal-oriented individual with analytical approach having excellent communication skills.

Possess strong ability to quickly adapt to new applications and platforms.

Professional Experience:

COMPANY: Baroque Technologies Pvt. Ltd.

CLIENT: Vodafone India Pvt. Ltd.

DURATION: Aug’14-Till Date.

ROLE: Business analyst.

LOCATION: Delhi.

Project:

Working with Corporate Project Management Office (PMO) for Business process Improvement for Call centre Operations across PAN India Operations (23 circles).

Responsibilities:

Fetch data from BAM for all circles, collate the fetched data and distribute to SME’s for audit.

Using modeling techniques like Logistic Regression, Customer Segmentation, Clustering to find out the Churn Rate across Pan India.

Collecting required data from different circles by calling their SPOC’s for the data.

Merging of data from multiple sources and ensuring data integrity.

Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE and PROC REPORT.

Using the Import and Export facilities in SAS to exchange data between SAS and Microsoft Office environments (Excel, Access).

Creating Macros and developed SAS programs for Data cleaning, Validation, Analysis and Report generation using newly created as well as existing macros.

Using Data _Null_ and SAS procedures such as Report, Tabulate, Freq, Means, Summary and Transpose for producing customized reports.

Performing Sorting and Merging of data and generating tables, listings and graphs using SAS/Base, SAS/Stat and SAS/Graph, SAS/SQL.

Modify existing SAS programs and creating new programs using SAS to improve consistency of results.

Collate all the audited data and analyze it on different parameters whether all circles are following the standard process.

Analyze the BAM data (i.e. Reason for customer Call, Tagging is done properly or not, TAT extension, Customer has got resolution or not, Bounce frequency, Final Churn from customer etc).

Analyze all data to see how much non adherence of process is impacting the operations and overall business.

Preparing the presentation for the Vodafone PMO from the analyzed data.

Environment: Base SAS, SAS/SQL, SAS MACROS, SAS/STAT, Excel 2010.

COMPANY: Baroque Technologies Pvt. Ltd.

CLIENT: MTS Systema Shyama Teleservices Ltd.

DURATION: July’12-July’14.

ROLE: Software Engineer.

LOCATION: Bangalore.

Description:

MTS Systema Shyama Teleservices Ltd. is a privately held telecommunications company which specializes in enterprise network, telephony, and call center technology. I was involved in Data cleaning, Data manipulation, Requirement gathering, Generating Reports, Data analysis, worked on Companies customer details, Profits, Selling, Resellers, Distributors.

Responsibilities:

Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE and PROC REPORT.

Creating permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE AND DATA_NULL_ for analysis.

Used the Import and Export facilities in SAS to exchange data between SAS and Microsoft Office environments (Excel, Access).

Created Macros and developed SAS programs for Data cleaning, Validation, Analysis and Report generation using newly created as well as existing macros.

Used Data _Null_ and SAS procedures such as Report, Tabulate, Freq, Means, Summary and Transpose for producing customized reports.

Performed Sorting and Merging of data and generated tables, listings and graphs using SAS/Base, SAS/Stat and SAS/Graph, SAS/SQL.

Modified existing SAS programs and created new programs using SAS macros to improve ease and speed of modifications as well as consistency of results.

Provided all data analysis, ad-hoc and custom reporting of customer data. This involved extracting data from an Oracle database, XML files, and Flat files data used as input for SAS programs to create Excel spreadsheets, Access databases, and hard copy reports.

Used data step options like KEEP, DROP, RENAME, IF, WHERE, COALSECEC, when reading raw data files.

Environment: Base SAS, SAS/SQL, SAS/ACCESS, SAS/GRAPH, SAS/MACROS, SAS/ODS.

COMPANY: IACT Pvt. Ltd.

DURATION: July’09- June’12.

ROLE: MIS Executive

LOCATION: Delhi

Responsibilities:

Generate timely and accurate reports for analysis. Create MIS/ Dashboard reports and present it to the Management.

To ensure effective Data base Management and Analyze data to create daily, weekly, monthly and quarterly reports.

Extensive usage of MS Excel (Formulae, Function, Formatting, Sum If, Count If, Average, V lookup, H lookup, Pivot Table, Pivot Chart, Index Match, Charts, Graphs etc) for report preparation.

Making advanced presentation in MS PowerPoint to present MIS & other related important reports.

Maintaining Trainer wise Information (Time Sheet, Performance Tracker, Utilization and Process Adherence) Reports and Account wise Training Calendar.

Client Feedback Reports, their Analysis & Analysis of Trainer Feedback.

Prepare and analyze reports & other statements with a view to apprise management of process operations and assist in critical decision-making process by using MS-Excel.

Coordinating with engagement team in getting the data & circulating the same to the team.

Maintain data as per requirement of management authority by use of various aspects like Charts, dashboard, and pivot table.

Ability to create and maintain reports that allow the company to get information on daily business activities.

Able to work independently and effectively and drive things to closure.

Analyzed data for operations to help design strategy heading.

Joining multiple tables using SQL joins (Append, Concatenate and Joins) for Data Analysis.

Collate Analyze and Present company performance details quarterly and half yearly.

Create and maintain reports in Excel that allows the company to get information on daily business activities.

Environment: MS-EXCEL, SQL.

Technical Skills:

SAS Skills: Base SAS, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ACCESS.

SAS PROCs: Tabulate, Report, Summary, Means, Freq, Sort, Reg, Logistic, Summary, Format, Transpose, Contents, Import, Export, etc.

Languages: SAS, SQL.

Operating Systems: Window7/2000/XP, UNIX.

Office Tools: MS-OFFICE, Word, Excel, PowerPoint.

Education:

B.E. (Telecommunication) from Sir M.V.I.T., V.T.U., Karnataka.

12th Science from B.I.E.C. Patna.

10th C.B.S.E, B.V.M, Nainital.

Place – Delhi

Lalit Kumar Singh

Contact this candidate