Sales And Systems Analyst, Data Analyst, Data Manager Resume
0/5 (Submit Your Rating)
Cincinnati, OH
SUMMARY
- Results oriented Data Manager bringing 20 years in communications, sales and marketing. Strong organizational, analytical, problem resolution and follow - up skills.
- Experience leading analysis activities on large software development and integration efforts
- Experience with informational delivery tools such as Cognos and Impromptu
- Understanding of catalog structure and the ability to merge catalogs to deliver reports to management to make critical business decisions
- Ability to analyze, research and implement solutions for problems within system applications and procedures
- Ability to develop and document system implementation procedures and create training materials
- Consulting experience as a member of large and small requirements teams, gathering and analyzing data, preparing for key status meetings.
- Proficient in Word and Power point, expert in Excel, knowledge of SQL and Oracle.
- Define data standards - Had sole responsibility for recommending and collaborating with internal and external personnel to implement data standards in three different databases. Vet DB, Breeder DB and Distributor DB.
- Data Validation rules- Managed 2 data coordinators that were responsible for the upload and validation of accuracy of Distributor submissions. Collaborated with H.P. programmer to define rules.
- Cleanse/Enhance data- Distributor submissions, i.e., find and replace, insert leading zeroes etc. Was responsible for all catalog changes and table updates.
- Develop/Modify reports- Since 2001 was solely responsible for delivering Monthly and Quarterly sales reports to upper/mid-level, and Field Sales Managers for total North American Pet Care Division.
- Data Migration Efforts- Collaborated consistently with Corbus programmer to send Distributor sales data to Vet and Breeder databases.
- Implementation of BI and reporting tools- Siebel and Sales Force
PROFESSIONAL EXPERIENCE
Confidential - Cincinnati, OH
Sales and Systems Analyst, Data Analyst, Data Manager
Responsibilities:
- Managed the sales and marketing information network to include uploading data from other databases correcting errors, and monthly reporting accuracy
- Created monthly sales reports derived from four different databases and delivered on time consistently
- As Data Analyst was responsible for the adhoc reporting of all products and presentation to upper management and field sales personnel for the total North American Pet Care division
- Managed 4 personnel and 2 contractor programmers to ensure the accuracy, upgrades, catalog changes or additions to the database (MIDB) that houses all of P&G's Pet Care data
- Experience with information delivery tools such as access, SQL, Cognos and Impromptu
- Analyzed and implemented solutions for problems within system applications or current procedures
- Defined project needs wrote business requirements to define scope and objectives
- Developed and documented system implementation procedures and created training materials
- Ensured the currency, quality, and integrity of the data in several databases providing consistency and synchronization across all platforms
- Maintained and enhanced databases and reporting cubes as needed to ensure efficient processing and production of reports and ensured data consistency of data attributes, naming conventions and element types (data cleansing)