Adam Beckner Email & Phone Number

Kansas City, MO, US

Kansas City, Missouri Area

• Work directly with clients and business partners to develop custom reporting solutions
• Develop custom pharmacovigilance safety reporting for internal and external clients
• Design, develop and document pharmaceutical client reporting for FDA submissions
• Develop custom reporting for the Clinical Trial Management System supplementing the inadequate standard reports to help improve system utilization and accuracy
• Develop datasets powering the pharmacovigilance Tableau dashboards
• Partner with data management group to develop reports identifying gaps and issues that may exist in clinical site and patient data collection so they can be resolved

• Developed and maintained commission reporting for entire sales force
• Accurately processed over $1 million in commission payouts for 700+ employees across multiple plans and locations each month
• Greatly improved accuracy and flexibility of the commission system while updating the code for the 2012 plans
• Modeled and implemented new sales plans and proposed plan changes
• Provided reporting and analysis to senior executives on sales rep performance
• Researched and resolved all discrepancies and exceptions

• Upgraded ETL processes and infrastructure
• Configured Windows 2008 Server for ETL migration from end-of-life machines
• Developed ETL template for improved logging and reliability
• Tuned SQL for improved performance
• Provided detailed explanation of solutions to customers

- Produced monthly and ad-hoc client reporting using OBIEE - Responsible for data validation - Coordinated multiple data file feeds for integration with new client - Implemented ImageNow software solution for document imaging and storage

• Converted outdated MS Access and VB code into reliable SSIS ETL projects
• Designed, coded, tested, and deployed twenty-three SSIS projects in nine months
• Wrote T-SQL queries to extract and utilize data
• Utilized VB.NET scripts for custom tasks when default tasks did not meet needs
• Trainer/SME for other teams using SSIS
• Worked directly with business partners on project design and implementation

June 2008 - Nov 2008 - In my most recent role at American Century Investments (ACI) I acted as primary IT support for their entire Institutional channel. I was in the process of re-writing data feeds for the Institutional Client Reporting system using TIBCO Business Works. The completion of this project will allow the retirement of the current outdated.

Summer of 2002 and 2003

Developed painting business following freshman year at ISUCompleted 10 large projects with 100% customer satisfactionScheduled all projects and managed assets (budget, supplies, tools)

Management Information Systems, Business

Activities and Societies: MIS Club

Mis

Activities and Societies: MIS Club - President