HIMANSHU GARG

• Consolidating Enterprise Level Complaints
• Developing macros designs according to process requirements in different areas dealing with RAW telecom data and various tools inputs
• Developing automation tools for auto processing of data
• Giving sessions on various important features of excel to different teams to reduce way of work
• Identifying the type of complaints and analyzing on micro level
• Data manipulation using SAS, SQL functions, SAS Procs
• Writing codes to generate reports using Base SAS and SQL in different formats and making predictions based on these reports
• Providing appropriate Data to Internal /External Auditors /Attorneys as required
• Exporting/Importing data to/from MS-excel to/from SAS data set & performing Data validation, Data cleaning and Data manipulation by SAS/SQL procedures
• Writing SQL queries to fetch required data from database tables as per requirements and testing them as well
• Creating automated Macros and Automation through power query, Chat GBT, VB
• Appending tables, Merging tables using POWER BI and generating advance graphics using visualization
• Airtel is decided to compare the revenue of 2g,3g and 4g on a quarterly basis
• So they want to know from which technology they are getting highest revenue and from which technology getting lowest revenue for this they are providing a sales data of 4 months
• So analyzing the data shared by client and converting them into quarterly revenue reports to find that which technology of the company is more in demand
• Checking the space utilization and reporting the same

Working with as Ericsson global india private limited

• Ltd
• As Engineer having prime responsibilities
• Giving KSS and sharing knowledge regarding various day to day activities and regarding various automation macros
• Develop various useful macros and solutions
• Develop macro for division of data in to various notepads
• Develop macro for 4g-5g PRE POST
• Develop macro for node count of different XML
• Develop macro for RAPI tool remarks combiner through python
• Develop solution for KPI fetching of different CRS in one go
• Develop automation macro for 4g-5g pre-post through RESET tool
• Performing on 4g activities, 3G, 2g outage and non outage activities
• Performing bigger activities like BSc rehoming, SGSN rehoming, PCU card swap, PCU card addition
• Performing BSC parameters and UNITS check and rectifying errors to the desired levels
• Has a experience in performing all critical BSC migration TDM, A-overIP MSS pooling
• Running plans, BSC dump using Nokia tools for change in parameters in BSCs
• Diagnosing all basic computer units according the new software requirements
• Performing GBover IP, SLC bitrate change implementation
• Performing OSS migration
• 2G site deletion/creation
• Running optimizer Plan
• Working on Nokia configuration manager, configuration editor, License manager, software manager
• Using CM Software Manager for BTS Software Up-gradation of Nokia Ultra, Flexi & Metro Sites
• BSC features, licenses upgrade according to the requirements of the client
• Creating plans for the critical activities to reduce wastage of time in outage window
• Looking after emergencies raised in BSC’s during the outage activities
• Has done Knowledge sessions on various technologies
• Has done team leading and team managing capabilities in need of hour
• Established strong working relationships with clients through exceptional communication skills, fostering trust and collaboration.

• Working with Nokia siemens as CM BSS ENGINEER having prime responsibilities
• Performing bigger activities like BSc rehoming, SGSN rehoming, PCU card swap, PCU card addition
• Performing BSC parameters and UNITS check and rectifying errors to the desired levels
• Running plans, BSC dump using nokia tools for change in parameters in BSCs
• Diagnosing all basic computer units according the new software requirements
• Performing GBover IP, SLC bitrate change implementation
• Performing OSS migration
• 2G site creation
• Running optimizer Plan
• Working on Nokia configuration manager, configuration editor, Licence manager, software manager
• Using CM Software Manager for BTS Software Up-gradation of Nokia Ultra, Flexi & Metro Sites
• BSC features, licenses upgrade according to the requirements of the client
• Creating plans for the critical activities to reduce wastage of time in outage window
• Looking after emergencies raised in BSC’s during the outage activities

• Performing Nokia BSC integration
• Performing Nokia BSC commissioning
• Solving BSC related issues like call muting, call drop, data calls problem, inter BSC handovers, Intra BSC handovers
• Integration of Nokia sites
• Solving site related issues
• Defying Nokia2G to Ericsson 3G handovers
• Defining inter MSC and Intra MSC 2G Nokia handovers
• Technical support for clearing unwanted alarms on sites
• Performing BSC parameter verification
• Rehoming Re-established BSC's to new MGWs or MSS
• Performing NSEI creation and deletion according to new SGSN
• Resolving hardware and software related issues to BSC
• New NOKIA and ERICSSON 2g site creation and old site deletion
• Ericsson Node B site create
• Oss definition at BSC end

• Performing BSC software upgrade to the newest software version
• Performing BSC CD upgrade at various software levels
• Performing BSC parameters and UNITS check and rectifying errors to the desired levels
• Diagnosing all basic computer units according to the new software requirements
• Performing hardware additions to the BSC though coordination with BSC engineers
• Performing Frame relay to IP implementation
• Using CM Software Manager for BTS Software Up-gradation of Nokia Ultra, Flexi & Metro Sites
• BSC features, licenses upgrade according to the requirements of the client
• Creating plans for the critical activities to reduce wastage of time in outage window
• Collecting approvals from customers for the outage activities
• Looking after emergencies raised in BSC’s during the outage activities

• Company Overview: A telecom vendor doing projects of Bharti, Vodafone, TTSL, Uninor, idea, maxis, BSNL, MTNL
• Posted in Jammu and Kashmir for Vodafone project as a project engineer
• Had worked on Nokia siemens Flexi BTS, PDH links, FIUs, FIFA, FIPA transmission card(2G)
• Responsibilities are: To survey the sites according to the requirements of the projects for the site
• For example, requirements like MCB requirements, pole mount requirements at the desired height and angle, HCT & VCT space requirements, BTS space requirements all taken into consideration
• To look after Full installation process of the network elements like Flexi BTS, Transmission rack, GSM, Microwave antennas, Feeder cables and IF cables according to the given plan and according to the quality standards
• To work in accordance with proper health and safety measures
• To monitor and create the external alarms from the BTS
• To perform on air activities like commissioning of BTS, FIFA card, FIU, sending power and frequency values to the radio attached with the microwave antenna, integration of sites, E1 patching
• To make cross connections at the near end and far ends
• To monitor the OMU signal after media is thrown
• To provide Q1 address to the sites having FIUs
• To provide pre acceptance test of the site and removal of all the punch points in the site
• To check VSWR at each sector
• To look after internal alarms the internal alarms if any
• A telecom vendor doing projects of Bharti, Vodafone, TTSL, Uninor, idea, maxis, BSNL, MTNL

• Company Overview: A Govt
• Of India (ministry of defense) Enterprise as a graduate Apprentice
• The Dual Monitor Multi-Functional Console (DMFC) – AKANSHA system
• The DMFC-AKANSHA system provides the information about the variety of weapons and sensors on the class of ships to the operator
• In addition to this, the system shall be capable of receiving/transmitting information from/to other platforms via data link
• The DMFC- AKANSHA information
• It will acquire, store, process, integrate, correlate and display the tactical data in real time
• The system accepts and store target related data received from sensors and would be capable of processing and analyzing the threat automatically
• Responsibilities: Analysis of the Intel boards peripheral connections using Schematics and ATP documents
• E-Flashing of Intel, Orion and Power PC cards
• Meeting quality standards of interfaces of the particular DMFC nodes
• A Govt
• Of India (ministry of defense) Enterprise as a graduate Apprentice
• Supported staff members in their daily tasks, reducing workload burden and allowing for increased focus on higher-priority assignments.