Report Writer/analyst/developer Resume
5.00/5 (Submit Your Rating)
SUMMARY
- Known for engaged and approachable management style in fast - paced, global sourcing environments.
- Strong analytical and problem solving skills, adept in managing change and delivering profit improvement through the application of best practices and technology.
- Database ERP/MRP (Deltek-Costpoint, AS400, Confidential, Confidential, SAP, Oracle, Manhattan-WMS, DB2, MS SQL Server-2012/2014-SSMS-SSAS-SSIS-SSRS)
- Strong (advanced) SQL skills ( SQL, T-SQL/M-SQL) (in MS Sql Server 2012 and 2014 management studio environment) (relational database, local as well as remote access)
- Qlikview and JReports (java-based) report writing/development/analysis
- Crystal report writing/analyst (Crystal version 2011 and 2013)
- Stored procedures (advanced) (creation/development/analytics)
- Stitch queries (SQL) creation/development/analytics (multiple fact tables utilized/complex)
- Working with various databases: SAP, DB2, Microsoft SQL Server 2012/2014, Oracle, Costpoint, Confidential, Confidential, WMS-Manhattan, AS400 working with the Supply Chain and Operations sector of Company (creating and analyzing cost sheet data, various forms of KPI's processes and indexes, etc) extracting raw data from SAP-mainframe as well as BI applications-utilizing:Microsoft Office and Project/Excel/Access (vlookup, pivot tables, macros, data source connections)
PROFESSIONAL EXPERIENCE
Confidential, Winder, GA
Report Writer/Analyst/Developer
Responsibilities:
- Writing reports in Cognos/SAP-Crystal Business Objects software; mapped and wrote programs, created filters and parameters to provide customized reports for internal clients and suppliers.
- Worked with Management team to identify and develop standard reporting metrics and standard reports for use by SCMS team to support Customer requirements.
- Provided support to DB2-WMS/AS400/ Confidential “system”) roll out with respect to Cognos and SAP/Crystal-Business Objects interface.
- Worked closely with the management team to determine impact of changes in process and tools and adjust reporting and documents as needed.
- Developed and assessed "what if" scenarios in DB2-WMS/AS400/ Confidential “system”.
- Create reports with relational and dimensional data
- Security cubes and other control objects; use control objects and their role in TM1; modify control objects to set and document TM1 properties and attributes; identify how control cubes manage TM1 security; use control objects to monitor TM1 performance
- Working and development with Cognos Framework Manager
- Utilizing SAP Business Objects with Sharepoint
Confidential, Norcross, GA
Senior Buyer and Cognos Report Writer/Analyst
Responsibilities:
- Developed, managed and carried out RFP/RFQ analysis
- Strong negotiation and cost analysis skills (domestic as well as international)
- Reviewed and provided recommendations for source selection in support of bid and proposal activities
- Monitored purchase order status, resolving supplier performance issues and assisting in preparing associated modifications
- Tracked and reported savings against budget and prior purchase activity, including cost avoidance
- Maintained professional and compliant Procurement records in accordance with organizational procedures and government audit compliance
- Responsible for meeting specifications and on-time delivery requirements of customers
- Worked cross functionally to address quality, cost or manufacturing issues etc in a timely and effective manner.
- Export compliance knowledge including ITAR
- Responsible for collection, analysis, and reporting of Confidential, procurement responsiveness, system & policy controls and vendor performance metrics
- Responsible for the creation and maintenance of dashboards and procurement reports supporting the financial close cycle
- Provide analytical and problem-solving support to the Procurement department with the goal of obtaining and gaining a better understanding of key operational metrics and data to support cost reduction initiatives, process improvement initiatives
- Experience with managing ad-hoc report requests and/or report development projects
- Confidential -program-the world's premier shoulder-fired anti-armor system (procurement of commodities for units/assemblies during a five year period).
- Estimated procurement volume of ten million dollars during this time period; with cost savings of 10%-15% (based upon customer budgetary guidelines).
Confidential, Tallahassee, FL
Buyer/Senior Buyer
Responsibilities:
- Responsible for working with suppliers on RFQs, purchase orders, and other procurement transactions.
- As Database Administrator, developed customized reports in Crystal software to support internal clients and suppliers.
- Worked with Procurement Management team to determine standard reporting metrics and standard reports for use by Procurement team to support requirements.