PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

Responsibilities:

• Multiple daily post trade reporting for financial, governance, or banking regulations across different countries.
• Working closely with associates located in New York and London with various legal and compliance metrics.
• Adhoc report requests from other departments and team members, custom report creation for repeat runs, automation of data tasks or manipulation, and merging of varied data sources.
• Technical Experience: Oracle 11, PL/SQL, Advanced Microsoft Access, Advanced Microsoft Excel, Strong VBA(Excel/Access) programming, SharePoint Development, Business Objects, Python
• Crafted an internal multi - pillar informational view of business workflows website, including Tableau visuals.

Confidential, Raleigh, NC

Data Analyst

Responsibilities:

• Joined a new Data Analytics Group to help internal CPAs conduct financial completeness and criteria specific journal entry analysis on multiple company general ledgers for auditing purposes.
• Some required excel file manipulation before import and others required cleanup from inside the Caseware Idea software/platform to conduct testing.
• QuickBooks files required custom excel data re-arranging.
• Criteria were used to scan and isolate journal entries in files that may have included 11 million rows of data and then summarized the results into a sorted and filtered excel export for review.
• Expedited the processes required as some client files would contain multiple entities where the criteria would get duplicated for each and overall determined efficiencies to get the most done in the least amount of time.
• In the first 7 weeks, completed 175% more than the average of the other 3 personnel who were working on the same tasks.

Confidential, Nashville, NC

Data Analyst

Responsibilities:

• Worked with management to convert business information data into KPI Metrics reporting (week over week).
• Visual Studio 2015 Express & VB.net to create data tools. Weekly 2008/2014 MsSQL SMS database work.
• Utilized Excel VBA macros to create ad-hoc reports & weekly reports that combined VS Apps for import/export.
• Acquired data from legacy, primary, and/or secondary data sources and maintained databases.
• Developed and implemented data collection systems and other strategies that optimized data quality.
• Identified, analyzed and interpreted trends or patterns in complex data sets for ongoing statistical reports.
• Filtered and cleaned data, reviewed computer reports and performance indicators to locate and correct problems.
• Created external responsive web application using PHP, MySql, CSS, HTML, and jQuery for employee use.

Confidential, Tucson, AZ

Data Analyst

Responsibilities:

• Sophisticated web research to report product price analysis (including custom web data extraction methods), competitor price, sales, and inventory analysis (custom Excel reports with macros), and the development of internal web application to store, maintain, and edit these informations using: PHP, HTML, and MySQL (new LAMP environment mixed with existing MsSQL 2005/2008).
• Recommended and created an internal custom Web Tickets system to allow 40 employees to submit things that needed fixing with inventory and web site for me to administer and maintain the work flow (HTML, PHP, MySQL): 500 records entered in 12 months.
• Maintenance of website copy (product features/benefits/advantages, sales & clearance items), also mass data updates to the main Sage Pro ERP system based on certain criteria.
• Access, PDF, and Excel merging and lookups / cross-matching for reports and other analysis.
• Developed a Retail Outlet Kiosk with touch-screen interface, accessing a custom developed web site remodel (from scratch) of existing e-commerce site to allow users to stream-line inventory at a store location, add items to a cart, and print out an order slip to hand to the employee of the store to complete the ordering process.

Confidential, Durham, NC

Web Developer

Responsibilities:

• Remotely developed a customized platform (with fully responsive design) to handle a CMS/CRM type solution, also created tutorials
• Site includes a full college-level type class/scheduling system with training events (including pre-requisites), students, registering, trainers, attendance, scores, and more.
• Over 645 different screens of activity allow users to manage their data, files, and reporting (including PDF generations). 363 custom built PHP files, 3.43 million characters of programming code (interwoven with SQL, HTML, and CSS) via 8,700 IF statements

Confidential, Phoenix, AZ

Web Developer

Responsibilities:

• Styled OpenCart platform (and fully responsive design) meets customized coding situations that allow this shopping cart to be controlled from their inhouse Sage ERP system.
• Custom extensions and re-work to allow for highly specific display of certain data to engage the online shopping experience.
• Over 25,000 filterable attributes on a little over 3,000 products (including alternate color versions of like products), brings this wholesaler to the cutting edge on the web Hovering block menu features 3 levels of subcategories
• Created a custom layer that allows users of the site to instantly export the entire live data of the whole site (even down to images - urls) via XML so that they can import it into their own site for retail (like drop-shipping).

Confidential, Phoenix, AZ

Web Developer

Responsibilities:

• Took on both a single site and an array of mirrors of that site type of project while maintaining ssl/https, different domains and sub-domains, and scrupulous settings and methods per the hosting company.
• Confidential is the base e-commerce platform and variants of it utilizing multi-stores in OpenCart allow this single admin and database location to feed manipulatable copies of it housed underneath Confidential sub-domains.
• Individual sites (affiliates) of Confidential allow changes to products, including visibility and price, while Confidential acts as a separate hub to sell the same products to resellers.