SUMMARY

• Experienced Information Technology Professional, with over 22 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.
• 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

Reporting/Data Analyst

Confidential Charlotte Nc

Responsibilities:

• Responsible for creating a custom BI profit and loss dashboard and reports tool(using SQL,Data model,Vba,analysis, data mapping, advance excel), with functions that include measuring trends versus previous year, data models and performance across various dimensions.
• Duties include process Improvement Reporting and Metrics, and lead the technical aspect of the PMO to create the reports and metrics producing the values so we can perform some root cause analysis.
• Responsible for maintaining in - house software and redeveloping databases (SQL, VBA, Advance MS Excel and Access) that are currently being used in the warehouse.

Sr. Data Analyst

Confidential, Mooresville NC

Responsibilities:

• 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 SAS, SQL server, rand Teradata, SDLC.
• Create DataMart’s and data integration for reporting, along with developing complex sql code and store procedures to load and automate data from databases I.e. (DB2,SAS,Teradata,Oracle) systems.
• 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 data integration using SAS developement, and SSIS for ETL process, data mapping in order to migrate data from many of Confidential data sources into one single consistent platform.
• 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.)
• Create Dashboard that measured current elasticity and sales data to measure forecast, which included projection model calculations.

Consultant - Sr. Database Analyst

Responsibilities:

• Research, and analyzes Data reporting issues in order to develop solutions and perform root cause analysis of issues including debugging ETL code, data mapping, data integration using SAS for structured and un structured data.
• Design, execute and track multi-channel marketing programs (including: email, direct mail) using Eloqua, SAS & SAS development, Salesforce,GEMS, MS Excel Charts.
• Responsible for staging new data bought from data sources using complex SQL ie (Dun and Bradstreet, InfoUsa and etc) and applying set criteria used to find non time warner business class customers using (ETL,SQL,T-SQL, Excel, MS access, SAS,) .
• 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 Confidential prospects for Mail, outbound telesales and Email applying standard exclusions, i.e. (Gov’t, Healthcare, education)
• Create ad-hoc extracts/report data mapping, integration, using various tools (Oracle, PL/SQL, T-SQL, (advance MS Access, MS Excel using vba,,sql connection strings), 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

Consultant - Sr. Database Analyst 4

Confidential, Charlotte NC

Responsibilities:

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

Consultant - Database Analyst 4

Confidential, Charlotte NC

Responsibilities:

• 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.
• Responsible for creating data marts using SQL SSIS tool to perform ETL from multiple relational database within Confidential used for analytics, reporting cleansing and etc.
• 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 complex SQL, proc statements,VBA programming in Access/Excel.
• Developed basic logical data modeling; database design; programming and coding (Visual Basic), documentation of policy and procedures. Perform all aspects of the System Development Life Cycle (SDLC).

Consultant - Database Analyst

Confidential, Mooresville NC

Responsibilities:

• Duties involved, creating data marts from DB2 tables using Complex SQL and stored procedures 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

Confidential, Charlotte NC

Responsibilities:

• 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

Confidential, Charlotte NC

Responsibilities:

• 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 using (SQL,VBA),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.