We provide IT Staff Augmentation Services!

Reporting Specialist Ii Resume

2.00/5 (Submit Your Rating)

Williston, ND

Hire Now

SUMMARY:

Accomplished SQL Developer possessing 10 years of experience in developing database solutions for small and large - scale software packages, skilled in providing complex SQL queries, stored procedures, and triggers used for business intelligence, reporting, ETL, ad-hoc and software development Confidential of Expertise

TECHNICAL SKILLS:

  • SQL (Transact, Other Variations)
  • Microsoft SQL Server Reporting Services
  • Microsoft SQL Server Integration Services
  • Views, CTE, Temp Tables
  • Triggers
  • Shell Scripting
  • Team Foundation Server
  • SQL Optimization
  • Microsoft SQL Server (2005+)
  • Microsoft SQL Server Administration (2005+)
  • Database Design
  • Stored Procedures
  • Functions
  • RDBMS Scripting
  • Visual Studio (2012+)
  • Requirements Gathering

PROFESSIONAL EXPERIENCE:

Confidential

Reporting Specialist II

Responsibilities:

  • Works closely with Executive Management, Department Leads and End Users to define report requirements
  • Creates SQL Server (SSRS) Reports for end users, from inception to deployment
  • Manages reporting infrastructure to include server and all associated databases
  • Creates new reports using report definitions and existing database structures
  • Converts legacy reports to MS-SQL Server Reporting Services
  • Creates ad-hoc data reports used for audits for legal-compliance, finance, operations and other departments
  • Works with IT Department application developers and web developers to develop database solutions for software ecosystem
  • Responds to reporting issues via halp desk tickets, by finding root cause and fixing the problem, involving other IT departments as required
  • Creates ETL processes for departments to individualize data that is captured by other departments
  • Creates Integration Packages (SSIS) for processes outside of scope of existing software suite
  • Owns Data Warehouse and all administrative duties required to keep the data warehouse operational
  • Defines, Creates, Maintains SQL Server Agent jobs designed to extract, transform and load data into the data warehouse
  • Investigates halp desk tickets assigned to Reporting, Integration or Data Warehouse and fixes issues
Confidential

Senior Business Analyst/Product Owner

Responsibilities:

  • Administers SQL Server database for warehouse management system (WMS) as well as bar-coding system
  • Creates ad-hoc data reports for operations, finance, logistics, manufacturing
  • Utilizes SQL Server Reporting Services (SSRS) to develop custom reports, providing insight to data otherwise not visible
  • ERP expert across all phases of Manufacturing/Distribution backend systems (Oracle Based)
  • Subject Matter Expert in forecasting, ordering, and distribution system
  • Subject matter expert in planning and barcoding systems across all phases of Manufacturing/Distribution while supporting several sites across the U.S. and Internationally
  • Identifies and validates key functional and non-functional requirements
  • Develops training materials
  • Develops halp guides and work instructions
  • Create reports in ERP tool (IFS) for end-users as needed
  • Identifies and troubleshoots ERP system issues as they arise

Confidential, Williston, ND

Analyst

Responsibilities:

  • Worked to define gaps in production efficiencies
  • Worked to mitigate gaps that have been identified
  • Worked to define functional requirements
  • Worked to define non-functional requirements
  • Worked with vendors to established service level agreements
  • Managed vendor agreements and resolved any discrepancies
  • Developed documentation specifications for projects assigned
  • Defined, created, and maintained system used to track logistics activities
Confidential, Overland Park, KS

Business Analyst

Responsibilities:

  • Worked to gather functional requirements
  • Worked to gather non-functional requirements
  • Conducted user interviews, workshops, data analysis, and JAD sessions
  • Developed functional specification documents
  • Developed non-functional specification documents
  • Developed Use Case documents
  • Developed wire-frame and UI documentation
  • Updated and maintained requirements repository on SharePoint
  • Assisted Project Management in development of project schedule and associated resources
  • Assisted QA in preparation of test cases and halped to schedule and execute testing of system
Confidential, Kansas City, MO

Business Analyst

Responsibilities:

  • Gathers requirements through ad hoc data analysis, interviews, workshops, peer reviews and surveys.
  • Defines and documents business requirements
  • Defines and documents business processes
  • Defines and documents non-functional requirements
  • Creates functional and non-functional requirements specification documents
  • Develops, maintains, and is in charge of requirements repository
  • Works with business and IT to develop Use Cases
  • Works with QA to define test cases
  • Involved in functional and user acceptance testing of developed application

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship