Shaun Mitchell Email & Phone Number

Tampa/St. Petersburg, Florida Area

Tampa, Florida

i PL/SQL, DB Artisan 4.02 , Visio, DB2, TOAD, VSS; Lead and manage globally Citi compensation process on sending payroll feeds information to all regions through our Payroll Module for mid-year and year-end bonus and salary adjustments Working closely with the senior compensation specialists across all Citi businesses and geographies, to deliver timely and accurate operational support and data analysis to a variety of compensation processesWork with HRSS and Citi Shared Services – Information Services global partners and global compensation to resolve any data discrepancies and/or data feed issues impacting compensation processesPartner with businesses to facilitate compensation process enhancements and provide training and ongoing support to the compensation teamsPartner with the technical development team with responsibility for support activitiesProvide HRIS data quality analysis to ensure compensation data is accurate and timely

Creating, supporting, and maintaining ongoing operational, managerial, and executive reporting Accountable for the quality and accuracy of reporting deliverablesCollaborating with project team members to gather project plan status for reporting needsLead the facilitation, coordination and resolution of cross-functional projects within/across teamsResponsible for making sure the tasks for the compliance taxonomies are being met and track in MS ProjectAssist Stakeholders and Work stream Lead in the Tollgate and validation process to ensure the deliverables are logical, structured and completeConduct enterprise data quality measurement and reporting on critical data elements.Build data quality assessments and measurement of critical data utilized by Citi strategic systems and processes supporting Citi Global Functions and sectors.Profile and identify root causes of data quality issues and develop recommendations for addressing those quality issues.Produce various reporting statistics using Business Objects and Cognos for management reporting.Communicate and collaborate with other team members and clients to develop solutions as needed and maintain knowledge of data quality best practices.

Manage team of Business System Analyst III in their daily task of running reports, creating stored procedures, Functional Requirement Documentations, and development of new reports via SQL for the business Created and owner of SharePoint site used to house business reports and new report request submission forms Develop and owner of Oracle schema used to create tables and views so the analysts can run their reports for the business.In charge of producing graphs and charts for top level executives and presenting my finding and trends to the group on a weekly bases Troubleshoot and resolved and technical or data quality issue and occurred in the system

Creation and maintenance of business reports for multiple business operations.Ongoing development of monthly/daily reporting, development of a web-based reporting application, and ad hoc analysis for multiple clients in a complex business environmentUtilize Business Objects to create customize reports and use as a host for internal and external client use

Ensure standards for quality and timeliness are followed by the departmentInterface with FNFS clients to ensure that business requirements are followed and expectations are metLead Projects to automate current process of doing bids for clientsProvide ongoing direction to staff to ensure the business functions are scalable and effective

Applications developer and liaison between business units, develop multiple stand-alone databases that improved workflow and job performance.Responsible for statistical analysis and management reporting for Senior Management that improved business unit’s process.ETL Testing by verifying that data transformed correctly according to various business requirements and made sure data loads into the data warehouse without any data loss and truncation Utilize knowledge of information resources and group processes to develop effective management reports for leadership teams.Utilize DFSS tools in projects or a new process which include testing new applications.

AVPGathered and documented business requirements in the BRD from stakeholders.Documented business process and built DB2 tables to support business rules and requirements, for customer data storage and maintenance.Planned test schedules and performed manual testing for web-based applications.Worked in Agile development environment with frequent changing requirements and features set.Manually tested cases before moving them to SIT and UAT regions for automated testing.Prepared business test plans, including definition of testing requirements; testing criteria, test scripts, user acceptance conditions and cycle (end-to end) test requirements.

Bachelor Of Science Degree, Business Finance

Associate Degree, Business Communication