PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Business Intelligence Developer/SQL Data Analysist

Responsibilities:

• Used Vb.net, MS Access, WinForms, Excel, Pivot Tables, Latitude, Qlikview, 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, sub-reports, dashboards, link reports, bookmarks, document maps, sql procedures, parameters, and databases with search conditions/filters.
• 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.
• Using VBA and Visual Basic to build user forms, macros, and reports in Excel and MS Access.
• Using SSRS to do data analysis, forecast trends, and created dashboards and reports to help the customer understand their data.

Confidential - Atlanta, GA

Business Intelligence Developer/SQL Data Analysist

Responsibilities:

• Used Vb.net, MS Access, WinForms, Qlikview, 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.

Confidential, Atlanta, GA

Sql Developer/SSRS Report Consultant

Responsibilities:

• Used Vb.net, Access, WinForms, T-SQL, VBA, Qlikview, 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.
• 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.

Confidential

Business Intelligence Developer

Responsibilities:

• 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.

Confidential

Business Intelligence Developer

Responsibilities:

• 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, 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.