Sonu Kumar

Senior Analyst at Providentia Technologies
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Delhi, India, IN

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • India
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Senior Analyst
      • Aug 2021 - Present

      • Strong experience on Base SAS, SAS/ODS, PROC SQL and SAS MACROS using SAS EG, SAS Windows. • Skilled in using SAS Base procedures like PROC IMPORT, PROC EXPORT,PROC PRINT, PROC SORT PROC SQL, PROC APPEND , PROC FORMAT,PROC FREQ,PROC MEAN ETC. • Experience in analysis and Sanity Checking, validating and manipulating complex data using SAS • Proficient in TABLEAU with the understanding of various features of it like Data Reporting and Visualization with Dashboards and stories and Charts. • Data management skills like Merging, Handling missing values, Reading raw data files, Creating data structures, handling programming error. • Optimized performance using proper use of IF & WHERE ,KEEP/DROP. • Data cleansing using functions like SCAN,SUBSTR, COMPRESS, INDEX, INTNX, INTCK ,PUT ,INPUT ,NMISS,SUM, MEAN ,DAY ,YEAR,QTR ETC. • Extensively used FIRST DOT & LAST DOT in Conditional Split of dataset. • Used ARRAY (1D,2D,Dynamic). • Used Macro for automation Expertise in producing RTF, PDF, HTML files using SAS ODS facility. Show less

    • Analyst
      • Mar 2018 - Jul 2021

      • Extracted data using proc import & performed multiple sanity checks on the data. • Worked for one of the biggest US Telco (Sprint). • Analysis of the data & generating weekly & monthly report on customer billing data in form of pie chart, bar graph and producing RTF, HTML, PDF files using SAS ODS. • Extracted data using proc import & performed multiple sanity checks on the data. • Worked for one of the biggest US Telco (Sprint). • Analysis of the data & generating weekly & monthly report on customer billing data in form of pie chart, bar graph and producing RTF, HTML, PDF files using SAS ODS.

  • NSN (Nokia Solutions and Networks)
    • Siliguri, West Bengal, India
    • Field Operation Engineer
      • Nov 2015 - Jan 2018

      • Operation & Maintenance of 94 2G sites of Bharti Air Tel at Siliguri Cluster. • Operation & Maintenance of Node-B 52 Sites. • Operation & Maintenance of 60 4g Sites. • Ring Implementation and Maintenance by FLEXI HYBRID, CERAGON -OLD+NEW etc. • Implementation and Maintenance of Nokia Flexi, Ultra, MR, MR10 BTS, 3G AND 4G NOKIA BTS. • Defining and testing of all alarms. • Ring Implementation and Maintenance by Ceragon IP10, IP20 & Flexi Hybrid. • In Telecom wireless industry for one Years with hand on Experience in the field of GSM and aware of BTS, Transmission • Equipment & Microwave equipment. • Knowledge of BSC (NOKIA BSC 3I) handling commands like (ET RESET, LOOP TEST, SECTOR BLOCKING, BCF LOCK/UNLOCK, alarm check, BSC scan and monitoring of any sites etc.). • Implementation and maintenance of RRI, FIFA, FIPA, FIQB, E1T1, FIU etc. • Implementation, Testing and commissioning of microwave links SDH and PDH. Show less

Education

  • Visvesvaraya Technological University
    Bachelor of Engineering - BE

Community

You need to have a working account to view this content. Click here to join now