Antonio J. Kendall

Summary:

Antonio brings with him very broad experience as a Business/Data Analyst and Database Developer.

He has extensive experience in monitoring service tickets for production issues of a wide variety; break/fix and on-call support of Production issues, working with internal customers to increase efficiency, productivity, and robustness of conversion process; troubleshoot, fix, and documentation of job failures.

He has experience in Data Mapping of proprietary data to SQL Server database to support SSRS (and other) reporting tools; creating data views and SQL objects to support development of proof-of-concept SSRS reporting and migration of existing reports to SSRS.

Antonio has worked on various projects and initiatives in the Software Development Lifecycle

Extensive experience working with MS Office, Object Oriented Concepts, and problem-solving solutions.

Antonio Kendall

(Local to Charlotte, NC and available immediately)

Summary of Qualifications

7+yrs SQL

10+yrs VBA

10+yrs Access

10+yrs Excel

10+yrs Technical Support

Highly adaptable, versatile, and seasoned professional with twenty years of Information Technology Experience.

Business and Systems Analysis, ETL Requirements, Documentation and Business to Developer Liaison

Eleven plus years of report generation with MS Access, Crystal Reports, ReportSmith, and Actuate.

Worked extensively with a wide range of relational database management systems analyzing, accessing, and presenting data in meaningful formats for customers.

More than ten years of Visual Basic and Access programming experience in addition to a wide variety of Legacy and Object Oriented application development tools

Spent significant time providing support to customers in Help Desk environments as well as face-to-face training by researching business process issues and devising solutions.

Extensive experience working with MS Office, Object Oriented Concepts, and problem-solving solutions.

Excellent written, verbal, and communication skills between management, developers, and customers.

Produced Help Systems, source code documentation, and training manuals.

Technical Skills

Languages

MS Access, Visual Basic, SQL Server,.Net, Delphi, Flash, NetObjects Fusion, JavaScript, Visual FoxPro, Visual C++, some light HTML, XML, XSLT.

Applications/Reporting

SQL Reporting Services (SSRS), Simego, Ouvvi, Microstrategy. Crystal Enterprise, Crystal Info, Crystal Reports, Light Tableau, Actuate, MS Office Suite, MS Visio, Visual Studio, MS InfoPath, Front Page, Dreamweaver, Business Objects.

Databases

SQL Server, SSIS, SSMA, MS Access, Teradata, Oracle, Visual FoxPro, T-SQL.

Operating Systems

Windows 10, 7, XP, 2000, NT, Windows 9x, 3.x, MS-Dos, and Linux.

Miscellaneous Skills

Borland Delphi, Business and Systems Analysis, Clipper, Clarion, Remedy, Oracle Power Objects, SuSE Linux, NT Administration, Novell Administration, PC Tech, Technical/Requirements Analysis and Help Systems writing. Jira.

Professional Experience

Lead Business Analyst May 2019 – Nov 2019

LPL (Collabera)

Business Analysis and documentation of business requirements including BRDs and FSDs for LPL response to regulatory legislation for California residents.

Research alternative solutions for recommendations to mitigate risks and challenges in the design and development of the response solution.

Interface with Business/Legal, and Technical Subject Matter Experts (SME) staff for solution design, development, testing, implementation, enhancements, and support initiatives and projects.

Facilitate meetings between Lines of Business and Technical Teams and provide status updates to management.

Coordination of work efforts between multiple work streams via meetings and other communications.

Researching and evaluation of reporting solutions including visualizations to support reporting requirements

MS Office suite including Word, Excel, One Note, PowerPoint Presentations, and Visio (Workflow diagrams).

Microsoft Project and light Jira creating stories for project task and milestone tracking.

Business Analyst

TIAA (Collabera) Sep 2018 – Nov 2018

VBA development for the Client Engagement Tool for the Process Control Team

Research solutions for the integration of disparate functionality of user tools and processes to a single application framework for proof of concept. Microsoft Excel, VBA, Pivot Tables, VLookups for workbook/worksheet updates.

Technical Business/Data Analyst Jul 2017 – May 2018

TIAA (Collabera)

As a member of the Onboarding Transitions Team, was responsible for attending/organizing meetings, updating documentation, client transition updates for tracking, file processing of various types of client data files during testing phases in lower environments for testing purposes, in an AGILE environment.

Analyze file and data errors and assist technical and business partners in identifying and resolving data errors

File processing documentation and Webex training sessions for new team members as well as serving as a technical resource for new team members.

Provided reporting assistance for business partners

Monitor adherence to requirements per CRD and Discovery documentation provided by Transition Managers and Data Leads.

Coordinated testing efforts with Operations to ensure smooth Go Live transitions to Production environments

Provided assistance to business and technical partners during warranty period to resolve issues arising during the Post Go Live period.

Provided progress updates for Tower reporting.

Business/Data Analyst/Database Developer Feb 2016 – May 2017

Bank of America Apr 2017 – May 2017

MS Access to SQL Server Migration project analysis

Documentation of existing database solution in preparation for migration.

Import Excel data to Pivot Table for additional analysis and visualizations

Bank of America Nov 2016 – Dec 2016

Data Mapping of proprietary data to Teradata database to support AML/Fraud Investigations Division

Data Analysis for support of proprietary information systems

Light Tableau Reporting and Visualization. Process Flow documentation with MS Visio

Wells Fargo, Charlotte Feb 2016 – Sep 2016

Data Mapping of proprietary data to Teradata database to support Wholesale Credit reporting

Data Analysis for the production of business reporting to the Wholesale Credit Corporate Environment

Data Analysis and prototype analysis. Process Flows with MS Visio

Application Solution testing and evaluation/discovery

Data Mapping of proprietary data to SQL Server database to support SSRS (and other) reporting tools

Data Analysis for migration of data to a new data warehouse. Utilized Excel Pivot Tables for data slicing.

Create data views and SQL objects to support development of proof-of-concept SSRS reporting and migration of existing reports to SSRS

Created SSRS reporting templates for use in new report generation and development

Babson Capital Management, LLC, Charlotte, NC Jul 2014 – Jan 2016

Associate Director

SQL Development of stored procedures, views, tables and other SQL objects in support of a proprietary system of record

SQL Code project enhancements per request of the business, in an AGILE environment.

Monitor service tickets for production issues of a wide variety

Break/Fix and on-call support of Production issues

Creation, editing, and support of new proprietary user interface screens and panels, adding and modifying on a project basis for the internal business customer

Assist internal business customers with inquiries. Research root cause and upstream/downstream impacts

Modify/Troubleshoot TWS Scheduler batch jobs

Developer/App Systems Engineer/Business Analyst Jul 2012 – Jun 2014

Wells Fargo, Charlotte Apr 2013 – Jun 2014

Development and support of data synchronizations for monitoring and reporting.

Daily break-fix of ETL data syncs between various platforms, including SQL Server, SharePoint, .csv, and Oracle using SSIS, Simego, and Ouvvi.

Automate scheduling of sync jobs via Windows Scheduler with Simego, and Ouvvi Automation

Ouvvi setup and migrations between Dev, UAT, and Prod environments.

Troubleshoot, fix, and documentation of job failures

Wells Fargo, Charlotte Jan 2013 – Mar 2013

Created an application to import and consolidate customer data to eliminate manual processes for required business intelligence.

VB/VBA/Excel, Access, MS Office automation, data integration, and development.

Redesigned data collection process utilizing macro enabled MS Excel workbooks for more efficient and user friendly customer experience.

Created a database solution for data consolidation, organizing, reporting.

This project effort reduced production time from 6 weeks, down to approximately 9 minutes or less, per customer.

Created addition utilities to replace manual processes for maintenance and setup for new clients.

Wells Fargo, Charlotte Jul 2012 – Dec 2012

Gathered requirements, documented, data mapped, validated, and executed for ETL from disparate data sources into SQL Server environment for Document Imaging conversions

Utilized SQL Server SSIS, VB/VBA/Excel (incl. Pivot Tables and VLookups), Access, MS Office automation, data integration, and development.

SQL Coding: Created and altered Tables, Views, and Stored Procedures for document imaging conversions (SIT, UAT, and Production environments)

Worked with internal customers to increase efficiency, productivity, and robustness of conversion process

Assisted QA team by providing test data and ad hoc data reports/summaries

Performed SQL Server database backups/restores

Data analysis using SQL Server, MS Excel, MS Access

Project documentation for Functional System Designs, Release Notes

Bank of America, Charlotte, NC 2010 – 2011

Systems Analyst/Business Analyst

Gathered requirements, documented, data mapped, validated, and executed for ETL from disparate data sources into SQL Server environment.

Utilized SQL Server SSIS, SSMA, VB/VBA/Excel, MS Office automation, data integration, and development.

Created and altered Tables, Views, and Stored Procedures.

Utilized ETL and Data migration with SSIS (BIDS) and SSMA.

Used business requirements for development planning, development, testing, and implementation for reporting efforts.

Utilized Microstrategy Business Intelligence reporting.

Worked strongly with MS Access.

Worked with internal customers to increase efficiency, productivity, and robustness of reporting operations in upper management reporting group.

Initiated SQL Server 2008 R2 setup, configuration, and administration for BI transition from MS Office technology to SQL Server data/Microstrategy BI reporting platform.

Worked with T-SQL.

Wachovia Corporation, Charlotte, NC 2001 – 2010

TAC Worldwide (at Wachovia) –Technical Analyst

Utilized Salesforce to input and aggregate data on international loan products being offered among international banking institutions. Created queries and reports to extract that data for integration into an RDBMS data store to support the International Credit Products Group sales and servicing teams as part of an initiative for a new application with more robust automation and reporting capabilities.

Access 2003/2007/VBA/SQL Server, International Credit Products Group Designed and developed database solutions for tracking Sales and Servicing of international loan products.

Designed custom user interfaces, custom reporting, general automation, and maintenance utilities according to user specifications and needs.

Automated data updates via multiple SQL Server instances.

Access/VB/VBA Developer, Human Resources

Designed and developed database applications for Human Resources Capacity Management, Recruiter

Scorecard tracking and Bonus Accrual Management. Data analysis and design. Office application integration via VBA and Visual Basic.

Designed and developed user interfaces to aid in the automation effort for producing monthly and quarterly reporting

Wachovia Mortgage - Access/VB/VBA/SQL Developer

Report Writing, Maintenance, Application Modification and Support. Visual Basic and Access

Development Support of existing Access Database, SQL Server, and reporting solutions for the integration of Impact data with MLS and Polaris Loan Origination Systems.

CIBHR Learning Team- VB/Access/SharePoint Services Developer, Business and Data Analysis

Designed and developed database and reporting solution for Junior Talent Analyst and Associate Training Programs.

• Analyzed existing data and manual processes in order to devise a strategic path toward a more versatile and serviceable information store.

Wrote Quick Reference Guides/How-To instructions for end users to minimize application learning curve.

Developed custom reports with configurable parameterized/data filtering interface to dynamically build reports based on user-selected options.

MS SharePoint team site-building and administration.

Application Testing and Performance Tuning. Development documentation.

Performance Reporting and Metrics Team- VB/Access/Report Writer, Business and System Analysis

Designed and developed internal metrics reports for the Availability Management group to measure metrics for unit costing and efficiency using MS Access, DB2 mainframe backend, pass-through and ODBC querying.

Excel and VBA method exposure from within applications.

MS Forms, Infopath

Access Control Project - SQL Developer

Wrote and tested SQL Server queries and stored procedures in support of the ACT tool backend data.

Produced data reports for audit requests as well as routine data verification processes.

Served as the Access Review System (ARS) Data Analyst for the quarterly review cycle, responsible for the coordination and execution of the review cycle process and related tasks.

Data Modeling, SQL Server 2005, 2000, and SQL Reporting Services.

VB/Access/Crystal/Actuate/SQL Server Reporting Services Developer, Report Writer, System Analysis

Designed, developed, tested, and implemented process and reporting solutions to fulfill service requests for internal support of the business units as well as Microsoft .Net application and SQL

Reporting Services development, support, and reengineering.

Performed support and enhancements of existing Correspondent Performance Data Capture and Reporting applications, forms, and reports using Access, SQL Server 2000, MS InfoPath, and Reporting Services in response to changing business requirements and OCC mandates.

Designed, developed, and implemented Visual Basic, MS InfoPath, and MS Access forms and reporting solutions for the Accounting department to facilitate the transmission of Equity Direct, Direct-To- Consumer, and Mortgage Plus check data to a third party funds distributor via the Data Transmissions Group.

Developed a security enhancement for the Exodus application to distribute administrative functionality among Accounting and support managers.

Researched, analyzed, and aggregated Polaris, Fitech, and ALS loan data to produce reports to support the Corporate Compliance/Legal team in preparation for pending litigation and class action lawsuits.

Supported Seagate Info Servers for Crystal Reports generation and email/fax distribution of Broker Channel Pipeline reports to brokers in the field as well as performing document revisions for merger related initiatives.

First Union National Bank, Charlotte, NC 2000 – 2001

Technical Analyst, Developer

Wrote Sybase SQL Server queries and stored procedures to efficiently access data used for Enterprise Crystal Reporting.

Created and altered tables and views.

Configured Crystal Info Servers and Automated Process Schedulers to build an enterprise-reporting infrastructure and developed Crystal Reports for customer base per specifications.

Analyzed data and requirements with Business Analysts to protect data integrity while meeting customer needs.

Assisted in the team development of a browser based front-end solution for the enterprise reporting system, using HTML, JavaScript, along with VBScript on the server-side.

Assisted in the development of a transparent database security subsystem for web-accessible reporting.

Mentored a co-worker in SQL, query writing, stored procedure writing, and Crystal Reports.

Performed database environment testing and troubleshooting for performance enhancement using Cast.

Optimized Workbench and Sybase Query.

Conducted numerous load-balancing tests using non-production servers to ensure reliable operation under heavy use conditions and compiled reports for standalone deployment to at-risk desktop locations.

Education

Bachelor of Science: Computer Science, Winston-Salem State University, Winston-Salem, NC

Contact this candidate