Data Analyst Social Media
Resume:
Clethus Wedgeworth
Garland, Texas 75044
********@*****.***
https://www.linkedin.com/in/clethus-wayne-wedgeworth-mpa-mism-7a2b8b2?trk=hp-identity-name
Professional Summary
Experienced manager with over 10 years of Information Technology management experience. Supervisory experience in recruiting, staffing, and human resources. Skilled in report development, staff recruitment and social media marketing. Excellent customer service skills, to include interpersonal, written and verbal communications. Detailed oriented manager with superior organizational and advanced analytical problem solving. Honorably discharged veteran.
TECHNOLOGY: Programs: SAP, Windows NT, Windows XP, Business Objects, Microsoft Office- Word, Access, PowerPoint, Excel, Microsoft Project, Brio Enterprise, Data Warehouse, Managed Care Database System, FoxPro, PL-SQL, SalesForce, Microfocus COBOL, Visio, PowerBuilder, Crystal Reports, SQL Server
EDUCATION: Master’s Degree, Info. Systems Management, Emphasis in Database Management - Keller Graduate School of Management,
Master’s Degree, Public Administration, Dean’s List - Valdosta State University,
Bachelor of Science, Business Administration, Dean's List - Paul Quinn College,
Microsoft Networking and Data Administration Certification, NPOWER Cybersecurity Training, Currently Pursuing
MILITARY EXPERIENCE:United States Air Force Veteran, Honorably Discharged, Served in National and International Locations
PROFESSIONAL EXPERIENCE:
3/2019-Present Health Management Systems, Irving, Texas
Business Analyst
Conducting Data Mining projects utilizing Toad,
Maintained application systems that have completed the development stage and are running in the daily operations of the firm,
Conducted start of day checks, monitoring and preparation for handover,
Developed and maintain technical support documentation,
Assessed risk and impact of production issues and escalated to business and technology management in a timely manner,
Utilized Microsoft Excel to analyze data source reporting,
Opened and created tickets for work problems,
Acts as advisor or coach to new or lower level analysts.
Writing Standard Operating Procedures to create macros in Visual Basic for automation of reports,
Utilizing Service Now for project management initiatives related to facilitation of departmental data,
Wrote intermediate level SQL queries in Toad, Teradata and SQL Server to perform queries for joining multiple tables for data validation,
3/2018-3/2019 Blue Cross/Blue Shield of Texas, Richardson, Texas
Data Analyst\Business Analyst(Contractor)
Working with multiple reporting tools such as Tableau, Business Objects, Cognos and Structure Query Language to facilitate creation of analysis reports related to ASOC, RFIT and FEP,
Conducting customer service and call center analytics,
Identified ways to maximize the potential of the applications used,
Ensured that storage and archiving procedures were in place and functioning correctly,
Reporting performance and time of receipt of call center personnel is conducted on a daily, monthly and annual basis,
Initiating daily performance tuning related to reporting queries for Business Objects analysis reports,
Primary responsibility is requirements analysis in order to develop analysis of organizational data and performance,
Meeting with management staff on a daily basis to provide support in meeting project and reporting goals and guidelines,
Thorough understanding of Behavioral Health networks in order to create queries and reports in a timely manner
Wrote SQL queries in Toad, Teradata and SQL Server,
4/2017-3/2018 Genpact LLC, Richardson, Texas
Data Analyst\Business Analyst
Analyzing Data structures for organizational performance and efficiency,
Provided help desk and work problem analysis,
Editing PL-SQL scripts through Oracle, SSMS and Tableau to create dashboards and reporting tools,
Training incoming staff on data reporting and providing continuity for staff,
Wrote SQL queries in Toad, Teradata and SQL Server,
11/2016-4/2017 Alcon Laboratories(Contractor), Fort Worth, Texas
Data Analyst\Business Analyst
Working with Data Management to identify duplicate commercial accounts and merge/close as needed,
Utilizing SQL, Tableau, Salesforce, SAP, Cognos, MSAccess and Excel to run comparative analysis on data cubes,
Active involvement in and ownership of Support Project items, covering Stability, Efficiency, and Effectiveness initiatives.
Ensured essential procedures were followed and helped to define operating standards and processes.
Analyzing data needs and meeting organizational representatives for reporting,
Initiating Data reporting for Sharepoint utilization,
Implementing reporting initiatives using PL-SQL within MS Access, InfoPath and Sharepoint for utilization of financial and educational performance evaluations.
Creating User Interfaces, forms, Pivot Tables to analyze organizational data,
Training organizational staff on reporting and database related initiatives,
Conducting oral presentations to team member on how MS Access and Sharepoint can be utilized for reporting to internal and external needs,
01/2016-04/2016 J.P. Morgan Chase, Lewisville, Texas
MIS Developer
Writing PL-SQL code and creating reports for mortgage loan monitoring,
Utilizing internal tools for project management purposes and initiatives.
Developing data reporting and uploading to Sharepoint.
Directly impacted the business by ensuring the quality of work provided by self and others; impacted own team and closely related work teams.
Utilized TOAD within SQL Server to extract organizational data and tables to create and edit new and existing reports which showed customer and organizational trends.
Conducted meetings and conference calls with upper management personnel to make needed changes to data management tools.
Created pivot table and complex PL-SQL formulas,
02/2013-05/2015 NPOWER-Technology Service Corps, Dallas, Texas
Program Marketing and Recruitment Coordinator
Email and Direct Mail Marketing Strategist to create data driving campaigns and Business to Business accounts through Sales Force.
Conducted oral presentations to military reserve and National Guard personnel for advertising program activities to recruit veterans for free information technology training,
Utilized Salesforce for recruitment, organizational and performance reporting, for 50-60 veterans for each class
Initiated Salesforce reports for organizational purposes related to grant funded and organizational initiatives.
Attended local job fairs and veterans related activities for recruitment purposes.
Created and updated Twitter, LinkedIn and other marketing and web based discussion sites for creating interest in the program.
10/2012-02/2013 Bank of America, Plano, Texas
Business Analyst (Contract)
•Wrote organizational reports utilizing PL-SQL scripts and created organizational reports on a daily, weekly and monthly basis by exporting data to MS excel for formatting purposes.
•Utilized Salesforce Reports for placement on web platforms such as SharePoint.
•Created Excel spreadsheets with VLOOKUP and Pivot Tables for centralizing data.
•Updated and inserted tables into the database.
•Created Visio Diagrams for organizational initiatives.
06/2012-10/2012 Verizon FIOS, Irving, Texas
Business Data Analyst (Contract)
•Developed management reports to ensure Supply Chain weekly and monthly goals were tracked on a monthly basis.
•Tables to create daily and weekly ad-hoc reports for management requests.
•Wrote SQL scripts using inner, outer queries and Sub reports using T-SQL, MS Access, Excel,
•Utilized Crystal Reports and TOAD to extract organizational data related to customer billing and utilized data to create 200 management related reports which showed customer geographic and demographics.
•Worked with clients to gather customer requirements and determining reporting external business initiatives,
•Created complex SQL formulas using T-SQL, Webi, Oracle Reporting, sub reports, text/CSV/Excel Extracts, Custom Running Totals and Graphs and Charts related to Inventory related statistical data, Inventory accountability related data utilizing Crystal Reports Environments.
10/2011-06/2012 Oncor Energy Corporation, Irving, Texas
Revenue Assurance Analyst (Contract)
•Maintained organizational data related to customer billing and utilized data to create management related reports which showed customer service trends.
•Utilizing Access to verify with team members on needed organizational requirements and determining reporting solutions,
•Created data reports to reflect customer billing and satisfaction trends,
•Wrote SQL scripts and built reports for organizational analysis and tables to create daily and weekly ad-hoc reports for management requests,
•DS), FoxPro for Windows
Contact this candidate