We provide IT Staff Augmentation Services!

Senior Business Analyst/ Data Analyst Resume

Schaumburg, IL

TECHNICAL SKILLS:

MS Access, MS Excel, MS Word, MS PowerPoint, MS Visio, MS MapPoint, MS Project, MS Project Server, MS CRM, MS Visual Basic (Excel, Access), MS Visual Studio, SQL Server Management Studio, Data Warehousing, Preactor, Forecast Pro, Syspro, Cognos, Tableau, HP UNIX, Sigma Bi, JD Edwards, Crystal Reports, Minitab, Power Bi

PROFESSIONAL EXPERIENCE:

Confidential, Schaumburg, IL

Senior Business Analyst/ Data Analyst

Responsibilities:

  • Implemented a 5S program and developed database scoring and tracking tools for 2 distribution centers
  • Streamlined monthly reporting process and reduced processing time from 5 to 2 days
  • Serve on Data Warehouse/ Data Governance committee to identify opportunities to ensure data quality
  • Restarted and streamlined Duty Drawback processing to recover an estimated $150K annually in import duties
  • Designed and implemented a database and new process for tracking HTS codes and correcting incorrect entries

Confidential, Woodridge, IL

North American Business Analyst/ Project Manager

Responsibilities:

  • Developed Six Sigma process improvement project for processing monthly transactions that saves an estimated $200k/ yr (Waterfall)
  • Developed automated system to manage quarterly price increases based on raw material index changes
  • Created a North American Scorecard to summarize companywide metrics for a $360 million business Lead Business Analyst on Shoplogix software implementation for 3 production facilities, as well as CRM

Financial Analyst/ Project Manager

Confidential

Responsibilities:

  • Established quarterly/ monthly/ weekly reporting
  • Implemented 3 instances of Preactor production scheduling software and designed 3 front end applications and SQL tables (accomplished Agile methodology) Created visual studio reporting to give snapshots of manufacturing schedules for 3 production facilities in a Syspro ERP environment
  • Created a database tool to assist Customer Service in identifying tool conversion configurations and available inventory realtime Regularly served on Data Warehouse/ Data Governance committee in Toronto to identify lowest common denominators for new enterprise software implementation (Microsoft Dynamix)
  • Integrated 3 Supply Chains’ data and ERP systems
  • Established ongoing Supply Chain reporting and analysis and process to assist Director of Inventory in managing inventory

Confidential, Bolingbrook, IL

Financial Analyst

Responsibilities:

  • Completed quarterly/ monthly/ weekly financial reporting
  • Created and maintained Forecasted Sales database used to report variances and review client profitability
  • Designed new category analysis to assist Marketing, Business Development and the Executive team in strategic planning
  • Established the annual budget and monthly forecast for a $3.5 million segment of the business
  • Developed a database to process month end GL reconciliation between Hyperion and proprietary software and facilitated resolution of variances with other departments

Pricing Analyst

Confidential

Responsibilities:

  • Gathered requirements from both Business Development and Pricing team and assisted in design and implementation of CRM
  • Developed analysis for Sales Team to identify opportunities for increased gross margin via cost savings and pricing strategies
  • Established process for estimating pricing, confirming and updating pricing structures in the ERP system
  • Reorganized the process of maintaining pricing proposals and customer contracts for Business Development
  • Lead Pricing team in the month end accrual process/ unbilled estimates of work in progress
  • Acted as IT liaison/ Business Analyst for the continuous development and improvement of proprietary systems and databases
  • Created customer level reports for Sales by designing queries in Cognos and MS Access

Confidential, Chicago, IL

Real Estate Investor/ Realtor

Responsibilities:

  • Located and purchased properties to renovate and sell for profit
  • Coordinated construction projects with condo associations and contractors
  • Researched raw material prices to minimize expenses
  • Supervised work in progress to ensure projects were completed in a timely manner

Confidential, Woodridge, IL

Margin Analyst

Responsibilities:

  • Established a pricing template and new process for prioritizing and creating pricing proposals
  • Created new monthly analysis by product category for Business Development
  • Managed the estimation of pricing for 30 inside reps and 20 outside reps
  • Acted as lead trainer for the Margin Management department on database applications/updates as introduced by corporate

Confidential, Downers Grove, IL

Technical Recruiter

Responsibilities:

  • Winner of the 2001 Sales Lead competition Negotiated contracts and placed candidates in technical roles at Confidential and Confidential
  • Populated enterprise database with sales leads, candidate data, open positions and information on competitors
  • Consulted with hiring managers to present prospective candidates and elicit feedback on current employees

Confidential, Downers Grove, IL

Marketing Manager

Responsibilities:

  • Worked with upper management to plan the company's promotional activities and improve processes
  • Coordinated every aspect of the company's participation in trade shows, tracked results and competitor’s offerings
  • Managed a department of 6 employees and implemented a performance - based incentive program Facilitated weekly conference calls with Sales to field customer feedback
  • Established new reporting to summarize feedback from the Customer Service call center for upper management

Hire Now