SUMMARY:

• Experienced Information Technology Professional with over 21 years of experience.
• Demonstrated ability to plan and execute complex and novel customer programs which require specialized knowledge, development of, or improvements to existing techniques and procedures.
• Reputation as a strong leader, producer, contributor to team success with a focus on managing analytic projects to ensure that quality work products are delivered in a timely manner.

TECHNICAL SKILLS:

• Knowledge to track measure and evaluate data results of market test and implementation of new products, programs and services.
• Demonstrated experience with Application Development and Streamlining.
• Strong analytical and project management skills.
• Proven ability to manage multiple projects within a deadline oriented environment.
• Ability to develop quantitative and qualitative methods for evaluating business initiatives.
• Ability and desire to interact in a team environment, willing to contribute to team efforts.
• Capacity to work independently on critical initiatives simultaneously with minimum support and meet aggressive target deadlines.

PROFESSIONAL EXPERIENCE:

Confidential, Mooresville NC

Sr. Database Analyst

• Responsibilities include developing business solution through constant modification of existing business intelligence solutions. Designed, code, debug, test, document, and support server based application such as MS Access, DB2 and Teradata.
• Worked within Pricing and Promotion and across Lowes in order to understand the business’s functional and data requirements to provide them with technical solutions and uniquely tailored to suit different audiences.
• Developed a standard reporting tool for SOS margin audit, which identified opportunities to review RTM (return to merchandise) agreements with vendors to improve RTM collection terms. EST $27M in annualized margin improvement with a 2% increase.
• Developed multi - user application (Promo Tracker) used to transfer data to align with Lowe’s promotional strategy. Functionalities include (MS Access front-end, back-end, SQL, stored procedures, DB2, Terada and ODBC.
• Responsible for creating visually and verbally engaging reports, for various assigned departmental heads, management, and stakeholders. Using skills such as (SQL server reporting services, SAS enterprise, Teradata SQL assistance, MS access, MS Excel, Data Modeling, VBA and etc.)

Sr. Database Analyst

• Identifies, research, and analyzes Data reporting issues in order to develop solutions and perform root cause analysis of issues including debugging ETL code.
• Design, execute and track multi-channel marketing programs (including: email, direct mail) using Eloqua, SAS, MS Excel Charts.
• Developed tracking, measurement and reporting of key metrics across the marketing funnel, sales funnels and salesforce databases.(Eloqua, SAS, Excel)
• Drive and assist with data analysis to improve operation including uncovering data anomalies and performing research of other forms of key operational data.
• Identify and create Marketing leads for all 6 regions that identify potential small business Time warner cable prospects for Mail, outbound telesales and Email applying standard exclusions, i.e. (Gov’t, Healthcare, education)
• Create ad-hoc extracts/report using various tools (Oracle, PL/SQL, T-SQL, MS Access, VBA, MS Excel, WinSQL, SAS, and Db visualizer, Oracle and Netezza, Eloqua).
• Performs root cause analysis of issues including debugging ETL code, Experienced in eliciting, defining, writing, and managing business specifications, technical specifications, and other project documentation for applications development

Sr. Database Analyst

• Determine the data quality standards for the organization and ensure adherence of the processes data to these standards, Conduct research as required judging the authenticity of the data. Make corrections, wherever required
• Developed an automated MS Access solution for legacy pricing and pricing changes, which consist of backend and Front end database, which includes input screens, search capabilities, export and import functionalities and reporting.
• Work closely with various departments to standardized procedural process in order to create automated processes, reporting, a nightly batch updates to Webserver.
• Developed a complex MS Excel user form using (VBA), to be distributed to 100’s of field users for pricing updates and changes, which consist of multiple validations, edits along with error reporting.
• Developed database for financial reporting by importing data from Excel to Access and set field parameters, which creating efficiency in data management
• Involved in all aspects of the System Development Life Cycle (SDLC).

Database Analyst

• 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.
• Provide analysis, design and execution of manual functional and user acceptance testing and assist in the QA effort for the application.
• 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.
• Developed and designed all aspects of the System Development Life Cycle (SDLC).

Database Analyst

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

Database Analyst

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

Data Analyst/Developer

• Responsible for Desktop Deployment Conversion from Wachovia to Confidential, 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.

Assistant Vice President /Reporting Manager

• 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:
• 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.
• SQL statements for conditional store procedures to extract and export data from and to our Data Warehouse.
• 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.
• 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)