Consultant / Compliance Data Analyst Resume
Lincolnshire, IL
SUMMARY:
- Proficient in all phases of the Project Management cycle, with an emphasis on process improvement, cost reduction, and risk management. Skilled at communicating and coordinating with multiple groups of stakeholders.
TECHNICAL SKILLS:
Technical Skills: Agile methodologies, theory, and practice. Highly familiar with all phases of the Software Development Lifestyle, including requirements gathering, technical specifications, and Specific technologies include IBM Netezza, Informatica, EBX5, SQL, Access, Oracle Taleo, and Salesforce.
Soft Skills: Friendly and professional demeanor with broad administrative background supporting executive, project management, and global business teams. Highly adaptable, and a quick learner. Excellent at relationship building, problem solving, and translating technical terms to common speech.
PROFESSIONAL EXPERIENCE:
Confidential, Lincolnshire, IL
Consultant / Compliance Data Analyst
Responsibilities:
- Conducted research in MedPro and state licensing board websites to verify healthcare provider licenses for sales contact reporting to FDA
- Utilized internal databases based on MS Access, SAP, Salesforce, and Oracle to enhance FDA reporting datasets
- Reduced data defects by 80% in assigned data tranches
Confidential, Lincolnshire, IL
Consultant / Master Data Analyst
Responsibilities:
- Supported team spinning up internal Global Master Data reference sytems
- Conducted research on in - house systems and online to resolve duplicate records in Global Customer Master Data systems based off Salesforce, Savvion and Oracle platforms
- Performed ad-hoc and targeted data remediation to improve overall data quality and improve targeted sales campaigns
Confidential, Deerfield, IL
Consultant / Business Analyst
Responsibilities:
- Owned processing of enterprise-wide annual sales and manufacturing data across 4 BUs into one consolidated report for executive-level review during annual business rationalization cycle
- Revamped reporting process developed by prior consultant, streamlining report creation and reducing both time and document size by over 50%, in part by utilizing advanced features in Excel
- Developed PowerPoint presentation to BU executives demonstrating competitive intelligence value proposition of new global BI survey system - RenalMIS. Also wrote documentation for process to solicit additional detail from program participants
Confidential, Chicago, IL
Consultant / Business Analyst
Responsibilities:
- Recruited to assist TCS in a multi-year data quality and data certification program for a multinational banking client, touching their entire global enterprise
- Evaluated data field definitions and expected values for compliance with Basel III regulation set
- Worked with international teams (spread across EMEA, APAC, and NA) to provide 24/7 client care and to meet demanding schedules, including attending off-hours calls and bridging language/cultural gaps
- Assisted in QA testing for new EBX5-based workflow for master data issue tracking and response
Confidential, Northfield, IL
Consultant
Responsibilities:
- Built queries and reports in Salesforce.com to identify opportunities for data quality improvement and research Data Change Requests from the field, approving or denying DCRs as appropriate
- Conducted research in MedPro and state licensing board websites to verify healthcare provider licenses for sales contact reporting to FDA
- Worked in IBM Initiate Inspector data warehouse environment to adjudicate healthcare professional and healthcare organization information records
- Participated in Agile sprints to enhance data quality in targeted areas, focusing on several hundred records at once
- Designed and wrote training manual for team of 5 offshore data stewards for database cleanup effort heading into quarterly and fiscal year reporting, touching hundreds of thousands of biographical records
- Collaborated with other data stewards to reduce ongoing data entry errors through targeted education and by conducting training of field sales agents in groups of 15-20
Confidential, Arlington Heights, IL
Project Manager
Responsibilities:
- Lead and coordinated data exchange integrations between Aurico’s award-winning, proprietary reporting platform and customer/vendor Applicant Tracking Systems, streamlining workflows and reducing costs to vital background reports to our clients
- Coordinated with outside development staff to guide development of the reporting platform, including automated data retrieval and processing
- Acted as liaison between Aurico staff, customers, technology partners, and outside developers to close bug reports, update system features, and develop new system abilities, workflows, and interfaces
- Developed transition plan to reduce Aurico’s reliance on outside software developers, increasing productivity and security and leading to annual software development cost savings of more than 50%
- Began initiative to create internal Lessons Learned knowledgebase, as part of the company’s ISO 9001:2008 compliance program
- Created documentation and wrote User Stories to guide outsourced Agile-based development team of 5, with a goal of reducing change requests and negative impacts on system users as features and improvements rolled out
- Drove down outstanding trouble tickets backlog by more than 80%
Confidential, Northfield, IL
Project Coordinator and Master Data Analyst
Responsibilities:
- Coordinated between competing demands from multiple business units, including Grocery, Cheese & Dairy, Coffee, and Beverage
- Assisted with governance of global, 6-year, $750 million SAP installation through report analysis, process improvement, and targeted communications
- Reduced average work package turnaround time from 7 days to 3 by simplifying Master Data group workflows and streamlining data verification and entry procedures
- Analyzed data on new and changed Kraft food products from completeness and accuracy. Total sales on these products was over $150 million annually
- Assisted with management and coordination of over 500 offshore resources, primarily in India
- Drove missing data rate on mission-critical report from over 30% to 1% through targeted communications with team leads and cross-continent supplier management
Confidential, IL
Event Lead
Responsibilities:
- Planned and executed two separate events with a national audience for a worldwide educational nonprofit.
- Successfully bid for the event twice, working in conjunction with the local group and chosen hotels
- Negotiated hotel and vendor contracts, conducted meetings, brought in and managed staff of 45+.
- Coordinated all planning, including complex room setup changes, with hotel staff.
