Maninder Gujral

Chapin, SC *****

ad0abw@r.postjobfree.com

+1-812-***-****

I have 21 years experience in the Telecommunication industry where I went from a Local RF engineer to a Lead engineer and later in my career I've transitioned to Business Intelligence analyst in the last 9 years. I have a strong understanding of SQL scripts, DAX and M code(Power Query) and using Tableau and Power BI tools. I have passion to understand and learn new tools and features as well as new ways to develop visualizations, I've self taught myself to learn Power Apps and Power Automate and use them effectively with Power BI.

Work Experience:

Senior Business Intelligence Analyst

T-Mobile - Remote

April 2021 to September 2023

As part of CORA - Critical Operations and Reporting Analytics team I provided several analytical reports and maintained and updated existing analytical reports (using SQL, Power-Bi and Tableau) for Operations, Retail, Customer Care, and Executive decks. And provided Ad-Hoc requests for executives. I also developed 2 Automation apps using Power Apps to better help operations collect data from Level-1 technicians, store it and then using Power Automate to send out emails to vendors or another app that uses Power Bi to analyze the results and provide an output based on customer requirements.

Senior Transport and IP Security Operations Analyst

T-Mobile - Remote

April 2020 to April 2021

This was a re-organizational move to the Transport team to provide analytical reports to Vendor Recoupment team and developing automation to reduce manual work and increase productivity. Continued to provide analytical reports based on customer requests, where team members were entering data manually but using SQL to identifying tables storing ticket data and then compiling the reports based on their specifications and recreating what they would do manually in 2-3 days saving work hours to better chase down reimbursement efforts. Also worked diligently to learn Power Automate and Power Apps to develop an app that technicians would submit, save data into SharePoint and send out to vendors for updates regarding outages root cause.

Operation Analytics RF Engineer III

Sprint - Remote

September 2016 to April 2020

Business Analytics using Tableau for National Operations performance and processes. Created reports for daily use by Operations to identify gaps. Also Ad-Hoc reports to answer executive questions and present on PowerPoint for executive monthly reviews. I was promoted to RF Engineer III on April 2017 for providing executive level dashboards and reports, and Ad-Hoc requests.

Ran Analytics and Process RF Performance Engineer II

Ericsson - Remote

December 2015 to September 2016

New tiger team developed to measure RAN and Access teams and work with directors for each teams to ensure management of the teams. Create reports/presentations that provides SLA measurable for each team/director. Created resource modeling reports for RAN teams and analyzed ticketing behaviors and corrected gaps. Provide improvement plans and guidance and continued review.

NTAC Tier 3 Proactive Performance Engineer II

Ericsson - Remote

October 2014 to December 2015

Promoted to newly developed team within Managed Services in Ericsson, Proactive NTAC - Tier III Performance. The team trends Sprint's markets provide through investigations and provide technical expertise to improve markets. I will work with National RF teams and Local RF teams and make professional recommendation in 3G CDMA/EVDO and 4G LTE technologies. I will also set standards and guidelines for Ericsson Tier I and Tier II teams, and implement automation to proactively identify concerns prior to it becoming a reactive issue.

RF Service Assurance Tier 2 Lead Engineer II

Ericsson - Remote

October 2010 to October 2014

Hired into this position to bring down SLA blocking numbers for the Connecticut Market and parts of New York City. Immediately began to see improvement, provided recommendations and escalated on the concerns. In 3 months I was named Lead Engineer for Northeast Team (4 team members -2010 to 2013). By 2013, as market assignments were removed, I was nationwide lead (16 team members - 2013 to 2014) as I took on more responsibility to be the first to learn LTE and then become a resource for the rest of team, a source for training and guidance. My experience level now includes both 3G and 4G technology (CDMA, EVDO, and LTE) and also including backhaul (DS1, Ethernet, IP Backhaul).

RF Engineer II

Ericsson - Evansville, IN

September 2009 to October 2010

Part of Sprint RF and Field Ops migration to Ericsson. Continued local RF duties for Evansville Market, and continue to worked on the ANM - Affiliate Network Modernization from Lucent to Nortel. Here I was able to gain some Nortel experience, along with project management skills. Worked on planning clusters, setup temporary IS41 borders, pre/post drive-testing, repeater/DAS upgrades all to ensure minimal service interruption during conversion.

RF Engineer II

Sprint - Evansville, IN

March 2007 to September 2009

After merger, I picked up the Evansville Market affiliate market for Sprint. Gained CDMA-1x knowledge meanwhile working on IDEN. Worked on the Affiliate Network Modernization project to convert Lucent cell sites to Nortel cell sites. Ensured market met SLA numbers.

System Performance Engineer

Nextel Partners - Evansville, IN

March 2002 to March 2007

Network optimization for Evansville Market. Local RF engineer, using statistics to identify problem areas and make necessary improvements, i.e. from parameter changes, down-tilting, and adding capacity. I worked closed with local field operation and switch technicians. Worked on interference mitigation and re-tunes, and drive-testing pre/post after major switch migrations or network upgrade. Ensure border handovers were successful. Project management skills from start to turnkey on in-building repeaters. Worked with sales to have customer meet and greet in order to hear subscriber concerns and provide education or make possible optimization to improve subscriber experience.

Education:

Associate's degree in Electrical Engineering

Northern Virginia Community College - Annandale, VA.

Graduated May 1998

Skills:

• Tableau

• Business Analysis

• Network Optimization

• SQL

• Microsoft Power BI

• Microsoft Power Apps

• Oracle SQL

• Data Visualization

• Jira

• Microsoft Power Automate

• DAX

• Data modeling

• PostgreSQL

• Microsoft Excel

• Business Intelligence

• Microsoft SharePoint

• Microsoft SQL Server

• Analytics

• Requirements Gathering

• 4G/LTE

• Business Requirements

• 3G

• MySQL

• Data Warehouse

Links:

linkedin.com/in/manindergujral

Awards/Honors:

Excellence Award

December 2007

Mickey deserves this award because he always makes himself available to the Lexington Team. The Lexington Market is responsible for bringing up multiple sites on air in a short amount of time and Mickey has taken the initiative to help as needed. He volunteers to put on air packages together, verify stats, and even drive test sites in our market. Mickey has a can-do attitude and is eager to work and win as a team. He is modest and humble. He is reliable and a great asset to the team Kentuckiana. 12-13-2007. Awarded by Sprint.

Run Toward The Bull! Award

August 2013

In recognition of identifying a problem, tackling it head on and not shying away from a challenge. Immediately after hiring he improved the KPI numbers for the Connecticut market after analyzing the root cause. And after being vocal and taking part in conversations/staff calls, made him the lead for the Northeast team and again the Northeast team started to see improvements. If there is a question Mickey doesn't know the answer to, he will go out of his way to find the answers. It was easy for him to be given the team lead but he works great in a team environment and gets along with everyone and supports others so they succeed as a team, not as an individual. Another great trait is that he always volunteers himself at every chance, when others don't speak he will definitely speak up and recently he volunteered to help on the Super Bowl project. Awarded by Ericsson.

Game Changer Award Certificate

April 2014

A well deserved thanks to Mickey for his involvement in making this collaborative effort a success. Sprint and Ericsson collaborated to plan, develop and execute the planning and design for Super Bowl XLVIIII at MetLife Stadium in New Jersey. Mickey developed the reports needed to monitor the macro and in-building sites around the venue and ensure their on-air and engaged technicians to ensure the sites remained active and while keeping KPIs below SLA numbers. Awarded by Ericsson.

Certifications and Licenses:

Ericsson Certified Technology - IP and Exam

November 2013 to Present

Scored 100% on the Ericsson Certified Technology - IP exam. Categories included General Knowledge of IP based Networks, MPLS, QoS, IP Routing, and Ethernet.

Contact this candidate