Experience Summary
Consultant – Database Analyst 4
Wells Fargo, Charlotte NC 5/2012 – Present
• Developed and maintained several in-house applications (Front-end and Back-end) used to capture data. Included input screens, search capabilities, export and import functionalities and reporting.
• Assists in the planning, analysis, design, implementation, maintenance, and/or control of the organization's databases.
• Performed basic server-class database activities including the following: routine troubleshooting, maintenance, and production support; basic database performance monitoring and tuning; data mapping; routine testing; and smaller back-up and recovery activities.
• Duties involved working with management to determine database needs, and limitations, based on their needs, and creating automated reporting and applications using (MS Access, VBA, SQL Scripts, Excel, MS Scheduler, Batch scripts, etc.)
• Responsible for streamlined reporting processes to improve metric reporting efficiency via development of automated reporting applications using VBA programming in Access/Excel.
• Developed basic logical data modeling; database design; programming and coding (Visual Basic), documentation of policy and procedures.
Consultant – Database Analyst
Lowes Companies, Mooresville NC 3/2011 – 6/2012
• Duties involved, creating data marts from DB2 tables to store business data in order to be reported and analyzed.
• Responsible for remodeling in-house Access applications to run more efficient and effective, and automating processes for ease of use for users.
• Duties involved working with management to determine database needs, and limitations, based on their needs, and creating automated reporting and applications using (MS Access, VBA, DB2, SQL, Excel, MS Scheduler, Batch scripts, etc)
• Responsible for streamlined reporting processes to improve metric reporting efficiency via development of automated reporting applications using Data mart, VBA programming in Access/Excel.
• Duties involve, creating multiple schedule batch jobs using (Stored Procedure, SQL statements), work with IT team for configurations of hardware/software to perform installations, testing, upgrades, as well as work with IT team on optimization of data storage, efficiencies, capacity planning and database growth.
Consultant – Database Analyst
Wells Fargo/Wachovia, Charlotte NC 7/2010 – 3/2011
• Assignment involves Encryption methods for Data at Risk for chosen Lines of Businesses (LOB), dealing with encryption efforts for Servers, Database, and Tapes devices.
• Duties involved, interacting with LOB’s to identify and report on number of devices to be encrypted and progress status of each LOB encryption efforts per business unit.
• Responsible for creating informative reports in Excel, Access. Also maintaining a relational database to house and store encryption data. Which consist of several data feeds, including SQL Database (ODBC), Excel, Pac2000/Discover, and Share Point.
• Duties involved creating new data feeds/views via Discover/Pac2000 from Wachovia old PICCT data feed, in order to continue reporting and maintain w on encryption platforms.
• Responsible for streamlined reporting processes to improve encryption metric reporting efficiency via development of automated reporting applications using Data mart, SharePoint, SQL querying, ETL and VBA programming in Access/Excel/Word.
Consultant – Data Analyst/Developer
Wells Fargo/Wachovia, Charlotte NC 12/2009 – 5/2010
• Responsible for Desktop Deployment Conversion from Wachovia to Wells Fargo, PC and Desktop replacement and Imaging Project
• Duties involved, interacting with internal business unit Managers to identify hierarchy, divisions, roles, and users to assign common application and selected applications used per role within the business unit.
• Responsible for creating business and Technical Specifications, to develop a relational database and user interface to manage data and create user deployment application reports per business unit.
• Collaborated directly with Business units to assess the effectiveness and technical impact of business requirements and to reach consensus on alternative solutions when necessary in an effort to maintain a consistent use of license and common applications used to perform each LOB job.
• Streamlined business unit reporting processes to improve deployment reporting efficiency via development of automated reporting applications for users’ desktop reimaging applications creating and using Data mart, SharePoint, SQL querying, ETL processes, custom forms, and VBA programming in Access/Excel/Word.
Consultant – Developer/Analyst
CB Richard Ellis, Charlotte NC 10/2009 – 10/2009
• Provide data analysis, reporting, and documentation using SQL querying, VBA programming in Access/Excel/Word for Bank of America Account.
• Analyze and monitor trends in R & M cost, work order processes, utilizing MS Access systems.
• Streamline client reporting processes to improve manager efficiency via development of automated reporting applications for client programs using SQL querying, ETL processes, custom forms, and VBA programming in Access/Excel/Word.
Assistant Vice President / Strategic Alliance Group (SAG) Reporting Manager
WACHOVIA MORTGAGE, FSB (1/2008 – 5/2009), Charlotte, NC
• Responsible for IT department management, which include 7 Regions throughout the US, managing and creating new innovative backend databases (Access, SQL databases).
• Created new innovative and complex in-house applications (Website, Access, Excel), also upgrades to existing applications, databases and Websites using (Access, SQL, Java script, VBA, VB script, Excel, ASP, Stored Procedures). Using Life Cycle Model concept to implement new and current production upgrades.
• Created and managed 6 user friendly web base tools for all Wachovia Mortgage, FSB lines of businesses (i.e., Mortgage Consultants, Private Banking, Portfolio, etc.). These sites were created to win external business and grow market share, track closings and market fund totals, and features Online and downloadable reports. Using (Macro Media Dream weaver tools, VB Scripting, SQL, Ms Access, ASP, Excel, ADO, and ODBC).
• Other responsibilities included, but not limited to the following:
o Daily maintenance and backup of web server databases. Setting up and creating ms dos batch files to automatically compress the backup files to save disk space using compression.
o Architect and maintained Data Warehouse (Tables, store procedures) in order to provide the business with access to accurate consolidated information from various internal and external sources.
o Responsible for the daily maintenance and backup of web server databases. Setting up and creating ms dos batch files to automatically compress the backup files to save disk space using compression.
o SQL statements for conditional store procedures to extract and export data from and to our Data Warehouse.
o SQL stored procedure to build and feed production data to update tables based on specific variables and condition for Retail Mortgage web application, which is setup on a scheduler to run nightly.
o Proactively communicated and collaborated with external and internal customers to analyze information needs and functional requirements and deliver the following artifacts as needed: (Functional requirements (Business Requirements Document), iii. Use Cases, GUI, Screen and Interface designs)
Developer (CONTRACTOR) (6/2005 – 12/2007)
WACHOVIA CORPORATION, Charlotte, NC
• Responsible for daily reporting (excess of 40 to 60 reports a week), using Ms Access (VBA, Macros, Form design), MS Excel (VBA, Macros, Form design) , SQL Database, stored procedures and ad hoc reporting
• Maintained database integrity by scrubbing, compressing database tables for storage to a secure offsite hard drive. Provide reliable Web data storage using MS Access database backup for files, text, programs, data, and other materials (Files stored on removable media, such as floppy disks, zip disks or CDROMS are excluded.) Web Developer:
o Work as a liaison among stakeholders performing business and systems analysis in order to recommend solutions that will enable the organization to achieve its’ goals
o Database Creating/removing tables, bulk loading, development and production of two database environments (production and development) using dimensional data modeling, database architecture, Open Database Connectivity issues, security, SQL statements/programming.
o Layout and design of Webs and HTML pages and Applications, Web architecture and navigation structure, colors, graphics, forms, Internet, explorer/Netscape compatibility, Ms Access tables, ODBC Connections links to SQL Servers, page file size, unity/corporate identity, plug in use, new technology incorporation.
o Programming Languages used: HTML, JavaScript, Java Server Pages, Visual Basic, Visual Basic Script, VB.net, Active Server Pages (ASP), application security (IIS), SQL.
BSA - BI-LO LLC (12/2003 – 6/2005)
Developer – Customer Analysis Research and Targeting / Wachovia Corporation (7/2003 -12/2003)
Developer / Wachovia Corporation (3/2003 – 6/2003)
Programmer Analyst / Public Consultant Group (3/2000 – 11/2002)
IT Consultant / Bank of America (4/1999 – 12/1999)
Programmer Analyst / Bank of America (5/1996 – 4/1998)