Resume

Sign in

Data Air Force

Location:
Atlanta, Georgia, United States
Posted:
September 10, 2018

Contact this candidate

Resume:

WINFRED DELL MAJORS

Business Intelligence/SQL/Power BI/Vb.net/VBA/Visual Basic/Excel/Ms Access/SSRS/SSIS/SSAS Developer Cell: 770-***-**** – Email: ac6z03@r.postjobfree.com

COMPUTER SKILLS

Software: Microsoft Visual Studio 2008, 2012, 2014, SAP, SAS, ABAP, SQL, SSRS, My SQL, SSIS, SSAS, SSRS, T-SQL, Microsoft Suite Package 97, Visual Basic, VBA, Visual Fox Pro, Latitude, SharePoint 2013, Power BI, Install Shiled, QlikView, Crystal Report Writer, Fox Fire, Front Page, VBScript, HTLM, ActiveX, JavaScript, PHP, Visual Studio 2003, Visual Studio 2005, Visual Studio 2012, My SQL, WordPress, Microsoft Word, Excel, Access, Publisher, Power Point, Visio, Oracle BI Publisher, Tableau, and Microsoft Server 2005 R2, 2008 R2, 2010, 2012, 2014, and 2016.

EXPERIENCE

Profit Sword Alpharetta, GA Apr 18 – Present

SQL Data Analysist/SSRS/SSIS/SSAS Developer

Designing and plan BI solutions

Built the data integration flows in an efficient way to avoid duplication of data.

Writing reports against the data warehouse interacting closely with internal and external end users

Pulling in BI Analysts for data accuracy in their source system and data modelers to run reports

Gathering requirements with internal users and requests to customize reports that are needed

Writing relational and multidimensional database queries

Using SSRS, SSIS, SSAS, Oracle, Install Shield, and Power BI to do data analysis, forecast trends, and created dashboards and reports to help the customer understand their data.

Used SSIS to create ETL packages (using delimited flat files or excel spread sheet) to update databases, tables, and reports.

Bring data together from diverse data sources

Profile data

Cleanse data

Use Power BI to translate business needs, design, build, and deploy BI solutions

Create cubes, dimensions, and measures in SSAS to create MDX to be used for research and designing reports and dashboards

Wells Fargo Bank Phoenix, AZ Oct 17 – Jan 18

Remote Business Intelligence Developer/SQL Data Analysist/SSRS Report/Power BI Developer

Designing and plan BI solutions

Built the data integration flows in an efficient way to avoid duplication of data.

Writing reports against the data warehouse interacting closely with internal and external end users

Pulling in BI Analysts for data accuracy in their source system and data modelers to run reports

Gathering requirements with internal users and requests to customize reports that are needed

Writing relational and multidimensional database queries

Using SSRS, SSIS, SSAS, Oracle, and Power BI to do data analysis, forecast trends, and created dashboards and reports to help the customer understand their data.

Used SSIS to create ETL packages (using delimited flat files or excel spread sheet) to update databases, tables, and reports.

Bring data together from diverse data sources

Profile data

Cleanse data

First Financial Management Asset – Atlanta GA Mar 17 – Oct 17

Business Intelligence Developer/SQL Data Analysist/SSRS Report/Power BI Developer

Designing and plan BI solutions

Built state-of-art reports with multipliable layouts and dashboards that delivered information in a user-friendly and efficient way.

Built the data integration flows in an efficient way to avoid duplication of data.

Writing relational and multidimensional database queries

Using SSRS and Power BI to do data analysis, forecast trends, and created dashboards and reports to help the customer understand their data.

Used SSIS to create ETL packages (using delimited flat files or excel spread sheet) to update databases, tables, and reports.

Bring data together from diverse data sources

Comprehensive transformation

Profile data

Cleanse data

Use Power BI to translate business needs, design, build, and deploy BI solutions

Develop and execute database queries and dashboards

Create visualizations and reports for requested projects

Dentistry For Children – Atlanta GA Jan 16 – Dec 16

Business Intelligence Developer/SQL Data Analysist

Used Vb.net, MS Access, WinForms, Qlikview, Install Shield, FoxPro, My SQL, Excel, Pivot Tables, Crystal Reports, VBA, SSRS Report T-SQL, SSIS, SSAS and SQL to develop, import, export and create excel spread sheets, pivot tables, sql tables, create main and drill-down reports, dashboards, and win forms databases with search conditions/filters.

Built state-of-art reports that delivered information in a user-friendly and efficient way.

Built the data integration flows in an efficient way to avoid duplication of data.

Using VBA and Visual Basic to build user forms, macros, and reports in Excel and MS Access.

Using Tableau to do data analysis, forecast trends, and created dashboards and reports to help the customer understand their data.

Created macros using the macro editor and implemented VBA in MS Access to do data entry, operations, import\export data, database objects, applying filters, queries, and search with where conditions on the database files, forms, and reports.

Used SSIS to create ETL packages (using delimited flat files or excel spread sheet) to update databases, tables, and reports.

Coke One North America – CONA, Atlanta GA Mar 15 – Nov 15

Sql Developer/SSRS Report Consultant

Used Vb.net, Access, WinForms, T-SQL, VBA, Qlikview, Install Shield, Excel, Tableau, SSRS Report, SSIS, SSAS, Report Configuration Management Server, Tableau and SQL to develop, support, debug/troubleshoot, and database tuning

Created queries, tables, views, functions, triggers, drill down, sub reports, score cards, and dash boards that created scheduled email subscriptions, cleaned up data (ETL), set relationships and enhanced features in analyze tables to management information system. These established knowledge of data for accurate retrieval and use in report writing.

Created dynamic link library.

Provided self-service business intelligence, integrating data for multiply data sources and performing calculation using power pivot for Excel.

Majorsware Technologies July 13 – Mar 15

Business Intelligence Developer

Used Vb.net, VBA, WinForms, Access, T-SQL, FoxPro, SSRS, SSAS, SSIS, Crystal Reports, Qlikview, and SQL to develop, support, debug/troubleshoot, create queries, tables, reports, cleaned up data (ETL), set relationships and enhanced features in basketball stats software program to record each player stats and inventory management application.

Analyzed tables to management information system to establish knowledge of data for accurate retrieval and use in report writing.

Used SQL, SSRS, Microsoft Access, FoxPro, Crystal Reports, VB.net, VBA, and Excel to provide technical reports and data charts for the customers.

Demonstrated outstanding communication skills to translate reporting requests in order to accurately meet the actual information and deadline needs of users.

Using Tableau to do data analysis, forecast trends, and created dashboards and reports to help the customer understand their data.

Created macros using the macro editor and implemented VBA in MS Access to do data entry, operations, import\export data, database objects, applying filters, queries, and search with where conditions on the database files, forms, and reports.

Center of Disease and Control (CDC) March 03 – June 13

Business Intelligence Developer

Developed, supported, debug/troubleshoot, ftp data from and to client, and enhanced features of the current releases of Vaccine Administration, Inventory, and Management software packages (using Microsoft SQL Server 2008, SSRS, SSIS, SSAS, VB.Net, C #, Tableau, Qlikview, VBA, My SQL, SAS, SharePoint 2013, T-SQL, Visual Fox Pro 7,8, & 9, Visual Studio 2010, Microsoft Access, Excel, Crystal Reports, and Visio) for medical facilities, providers, and doctor’s nationwide.

Analyzed business and technical requirements and translated them into efficient reporting solutions.

Analyzed business and technical processes, and related data to produce the data flows that meet the business requirements.

Built state-of-art reports that delivered information in a user-friendly and efficient way.

Designed business intelligence solutions with Microsoft SQL Server 2008 R2 / 2012 and (SSMS).

Developed data links and data loading scripts, including data transformations, reconciliations and accuracies.

Created data packages and modelling data integration flows with SQL Server Integration Services (SSIS) from various data sources.

Built the data integration flows in an efficient way to avoid duplication of code and changed the software application from Visual Fox Pro to VB.Net and WinForms back-end and front-end.

Provided development, preventative maintenance and debugging for window base applications. Used Microsoft SQL Server 2008 and ODC drivers to connect to data files.

Data migration, created database files, database tuning, writing sql queries – procedures – reports - triggers, building and maintaining all types of vaccine management reports (sort, grouping, inventory, and calculating data) for external and internal needs (SSRS).

Provided help desk support, technical advice, training, and recommendations.

Modified, debugged, and created Visual Basic 6 programs, queries, and reports.

Wrote a vaccine ordering program, SQL queries, procedures, parameters, designed and built relational database, designed and implemented of business intelligence systems, cleans and maintains the database by updating data to improve and enhance our vaccine management processes.

Used Oracle BI Publisher, Crystal Reports, and SQL Server to created database, tables, connections, triggers, procedures, parameters, adding default, unique keys, daily backups, restore, data maintenance, security, business intelligence, write queries, joins, setup data relationships, reports, dashboards, import data, export data, and setup referential integrity constraints.

Customized settings, creating a project and package, control task, business intelligence integrating data for multiply data sources and performing calculation capabilities an excel workbook using power pivot, perform data integration and workflow solution, extractions transformation and loading (ETL).

Created macros using the macro editor and implemented VBA in MS Access to do data entry, operations, import\export data, database objects, applying filters, queries, and search with where conditions on the database files, forms, and reports.

Implemented Healthcare vaccine data and reports.

Implemented sql tera data report using SSRS, SSIS and Power BI

EDUCATION

2012 – ABAP Training & SAP Training – Business Processes, Transactions Codes, Databases, and Reports

Center of Disease and Control (CDC)

1200 Corporate Square/Blvd (Bldg. # 12)

Atlanta GA 30329

1986 - 1989 Allan Hancock College

Vandenberg Air Force Base, California 93437-5000

Major: Computer Science

1993 - 1993 New Horizon Computer Center

Bakersfield, California 93309

Major: Network Administrator

1988 - 1990 Community College of the Air Force

Vandenberg Air Force Base, California 93437-5000

Major: Military Leadership

Minor: Military Discipline

Total Quality Management (TQM)

Professional Military Education

2000 –2000 Oracle University

PL\SQL Construction, Implementation, Functions, and Procedures

AWARDS & HONORS

Air Force Commendation Medal, Air Force Achievement Medal, Air Force Outstanding Unit Award, Air Force Good Conduct Medal, National Defense Service Medal, Air Force Longevity Medal, Noncommissioned Officer Professional Military Education Graduation Medal, Air Force Basic Training Medal, and a SECRET security clearance.



Contact this candidate