Business Analyst Data

Location:

Durham, NC

Posted:

June 12, 2025

Contact this candidate

Resume:

Sheldon C. Lennon

Current Location: Durham, NC, have worked remotely since 2005

Work Status: US Citizen, No Visa or Sponsorship Needed

Date Available for Interview/Discussion: 24 hours Prior Notice On Average

Cell Phone: 919-***-****, talk & text friendly

Email Address: **************@*******.***

Qualification Summary:

Expertise in implementing policies for improving and maintaining business compliance for multiple IT automation disciplines, and various integration systems.

Held global controls to approve and remove accesses manually and by performing an upload via API in production. The objective within this requirement is data governance and access controls.

Daily Power BI /Excel usage to create and maintain pivot tables to read and analyze large data into scalable formats. Daily SharePoint usage to maintain actuals from ESSBASE internal systems, to refresh data and calculate risk(s) within project scopes.

Weekly assistance with global ad-hoc reporting measurements as needed, to assure data is being calculated timely and accurately with scheduled excel reports and also organizational changes.

Creation of key monthly Excel reports/metrics that influence team variable compensations, as well as departmental decisions.

Provided critical alignment support within and across these global teams. I lead cross-functional strategic planning team meetings and seminars. Coordinated projects based on skilled technical resources for pipeline projects. Recruited global technicians for time-sensitive skillset criteria and availability.

Built /managed excel metrics which were utilized by various global teams to distribute weekly pipeline reports, sales, bookings, and revenue dashboards.

Extensive hands-on experience in the testing of critical business processes, compliance, which all help aid business value across multiple global markets.

Analytical love for large raw data and my abilities to transform into pivot tables/metrics to help aid business value across multiple regions. I can offer front and backend physical support when and where needed, while multi-tasking various assignments.

Good working experience in writing and optimizing SQL queries for extracting, manipulating, and migrating data from databases. Creating detailed data maps to illustrate the flow of information between systems and databases.

Soft Skills:

IT case management SPOC/key admin support (debugs, error tracking/testing/resolve)

Proven results driven and key global team producer and communicator.

Champion (SAP- Fieldglass, JIRA, Oracle/Tableau/Ad-hoc reporting), API integration/testing.

SQL /Toad error tracking and data migration

Business revenue & global bookings forecasting/report creations (Excel / PowerBI)

Order management SPOC (SAS, Purchase requests, Iprocurement/CCW/SmartBuy)

Global Business Continuity SPOC / Project Management/ ServiceNow

Solutions delivery support (IT/C-Worker Support/Project Mgt/ Timecard debugs, integrations

Vendor management liaison

(Supplier & Partner Services), Accounts Payables liaison Top AS ISO champion (Int. &Ext.)

Efficient in Subscription & Transactional work /assignments

Recognized as never have missed a day of school or work. (K-12th-NCCU + work), **Accountability

Technical Skills:

Hardware: IBM ThinkPad-Lenovo, Mac, HP, Dell, IP phones, Video Conferencing (WebEx)

Software: Microsoft Suites, SharePoint, WebEx, Wiki, Lotus, Netscape, Firefox, Safari, Oracle Business, Adobe Acrobat, Tableau, Smartsheets, iProcurement, JIRA, CCW, SAP- Fieldglass, WorkDay, NetSuite, TOAD, Essbase, Cloudhealth, SAS

Methodologies: Resource Assignment Metrics, Resource Skills Management, Resource Requirements Gathering, Resource Sourcing, Vendor Management, Scrum, Crystal Methods, Global Bookings, Waterfall, Agile

Technologies: UC, UCC, MP, WLAN, R&S, Security, Video, Data Center, Storage, Optical, Virtualization, Cloud,

Professional Affiliations:

SPOC/primary contact for Cisco’s Adopt-An-Angel Programs (Durham, Orange and Wake counties), 2005-2022

Founder, Durham Public Schools Hub Farm, Durham, NC. Click to view news article, 2013

Education:

BS Business Management – North Carolina Central University, Durham, NC

Professional Experience:

Wells Fargo Remote

Senior Technology Operations Analyst Jan 2024 – May 2025

Responsibilities:

Over this period of my contract assignment, I have supported Privilege Access Controls (PAC) within the Enterprise Access Management team at Wells Fargo. Daily JIRA tool inputs, compliance checks, mapping variances to the aligning teams, initiating requests, creating or overseeing the requests to assure governance checks are balanced day-to-day as per protocol. I have enjoyed learning, performing analytical scanning on Wells Fargo’s numerous mainframes, database tables, compliance measurements, and being aligned to the technology side of banking. Our core team connects weekly to discuss any new pitfalls with our processes, and continued emphasis placed on data cleanup to the other aligning teams. Daily usage of other tools are documented as such, and other data cleanup efforts are successfully managed within timely announced SLA’s. Access and compliance are huge factors within the banking enterprise segments. Any breach of access within these segments are always deemed at risk, and need to be documented, removed, and leveraged within a few hours of notification.

Professional Experience:

Cisco Systems Research Triangle Park, NC (remote)

Data Analyst/Business Operations Analyst Oct 2022 – Oct 2023

Responsibilities:

Daily JIRA tool governance to assure client support cases are staged and aligned to the proper Cisco internal security teams accordingly. These teams worked rapidly to remove vulnerability attacks within Cisco’s infrastructures and operating systems.

Monitored backlogged IT cases to assure they were being maintained properly and closeout activities have been executed as per defined processes. Often acted as the liaison between the client requestor and security team member(s) to assure all critical data, client adobe contract signatures were applied properly.

Writing and optimizing SQL queries for extracting, manipulating, and migrating data from databases. Creating detailed data maps to illustrate the flow of information between systems and databases. In addition to, supplied bi-weekly readout of health-checks to all core internal teams.

Other concentrations included monthly and quarterly accruals, sales (bookings & investigations), weekly headcount analytics, software renewals, daily dashboard maintenance and debugs.

Developing process flowcharts to visually represent the sequence of activities within business processes. Identifying bottlenecks, inefficiencies, and areas for improvement in existing processes.

Documenting functional and non-functional requirements for system enhancements or new implementations.

Cisco Systems Research Triangle Park, NC (remote)

Data Anslyst/Fieldglass Systems Analyst Jun 2017 – Jul 2022

Responsibilities:

Recognized as the passionate Fieldglass guru/SPOC that provides technical workflow solutions and business value for many Cisco personnel and outside Cisco approved vendors.

My daily tasks include front/backend support to global users, problem/error tracking, custom modifications, systems configurations to name a few. Daily monitoring of various system integrations to assure when systems errors arise, can be debugged using TOAD queries and other customized uploads.

Weekly assistance with global ad-hoc reporting measurements as needed, to assure data is being calculated timely and accurately with scheduled excel reports and also organizational changes.

Worked with a global tool, interface, and processes, ensuring seamless API integration. Coordinated API updates globally, addressing challenges and ensuring smooth operations.

Have self-resolved over 7000+ IT cases, with a medium weekly average of 50-60 cases. Daily tasked included checking the "errors" file, which contained listings of integration errors. 80% were common and the remaining is usually considered "NEW", which also had to be debugged, tested, and repushed via API in production.

The API set up in the testing environment was great when testing large rows of data. Proficient use within a testing environment for debugging and testing scenarios. Once successful alignments were met, utilizing PROD environments to re-pushed large rows of data via API for VP changes, cost center changes, worker access changes, location changes, and other compliance measurements, etc.

Rapidly diagnosed errors, configured successful alignments, and then uploaded API customized updates ahead of scheduled integration periods. Case story writing was minimized during this time, as I was the SPOC.

Oracle – NetSuite Durham, NC (remote)

Business Systems Analyst III Oct 2015 – Feb 2017

Responsibilities:

Resource utilization tracking and collaboration with management on assignment decisions.

Creation of key monthly Excel reports/metrics that influence team variable compensations, as well as departmental decisions.

Point-person for financials, revenue recognition reports, audits. Owner of all standard PS project templates, task details, and the updating of starting budgeted efforts on all PS projects.

Creation of daily/weekly ad hoc project reporting, bookings (sales & monitoring), backlogs, SharePoint, CAT Surveys, and engineer utilization reports. (Received notice on 2.17.17 – my position being relocated overseas)

Cisco Systems Research Triangle Park, NC (remote)

Business Systems Analyst/Operations/Project Management Apr 2005 – Oct 2015

Responsibilities:

Recognized as the SPOC for resource provisioning (C-worker and IT Support) for over 350 new hires. Maintained system compliance following internal/external ISO protocols.

Evaluated timelines and utilization of global technician teams weekly to ensure effective communications and case management updates. Built /managed excel metrics which were utilized by various global teams to distribute weekly pipeline reports, sales, bookings, and revenue dashboards.

Increased AS global skillset compliance (CSI) from 31% to 92% in 6 months. In my 9 year role as a Business Analyst, I created a wide variety of templates and reporting performance reports via Tableau & Oracle BO databases to help global teams prepared for weekly, monthly, and quarterly revenue & bookings forecasting calls.

Global contributor in designing/updating portals to maintain Y/Y trending, weekly billable and utilization reports by business sector/LOB. In my resource management shadowing role, I worked as a technical project manager resourcing support to various projects. Prioritized team assignments and reporting data based on urgency and locations.

Performed device provisioning of physical security devices, IP cameras, and mobile devices during intervals of high demand and backlogs. When devices failed, I helped to troubleshoot issues within recording, multi-device enablement, and refreshing IP’s across sectors before users attempted to reorder units incorrectly.

Usually 3 stages with a SME, prior to successfully creating RMA’s to get equipment reordered and provisioned again. Often it was user error(s), internet mapping issues, and thus saving Cisco time and costs. Managed and govern RMA’s for cost tracking with asset management and department costs.

Contact this candidate