Business Data Analyst

Woodbine, MD Keith • shugartk@Stehman yahoo.com Shugarts • 301-***-**** • LinkedIn

Strategic problem Curious, solver with Creative, an innovative Adaptive mindset eager Business to creatively Data resolve Analyst new tasks and challenges through efficient project management. Strong leader focused on building effective teams through cross department collaboration. Critical thinker able to quickly analyze issues and deliver successful solutions.

— Key Qualifications —

Solid understanding of data profiling, organization, quality, processes, and flow, providing a comprehensive skillset covering all aspects of data management, analysis, and governance.

Effective communicator, particularly as a liaison between teams and departments, providing information in clear, concise ways through facilitating productive meetings and dispersing written reports.

Ability to capture complex business requirements from a variety of sources and break down into tasks and projects, taking the functionality requests and decomposing into technical specifications.

Exceptional expertise in project management, producing accuracy, quality, and proper scheduling while managing tasks, meetings and communication across departments.

Strong proficiency in numerous technologies, systems, and software, willing and able to quickly learn new platforms and independently master unfamiliar tools. Professional Experience

Ciena Corporation – Hanover, MD

Senior Business Analyst, 7/2019 to Present

Engage cross-department teams to implement enterprise-wide governance programs, creating data and process systems to streamline the compilation and sharing of information, ensuring better communication and accuracy. Determine project roadmaps based on business needs to assist project owners in specifying details and timelines for application requests. Train via video and written documents to educate on newly deployed systems and functions. Document and educate leadership on potential risks of executing presented projects. Produced SQL queries, accurately identifying problems and gaps within data sets to deliver quick response to any issues.

Selected Contributions:

Crafted Data Analysis and Data Quality Cycles to support the implementation of an Enterprise-wide Data Governance Program.

Reduced lead time by more than 60%, bringing new account creation period through Salesforce from several days to less than 24 hours.

Improved internal audit reporting efficiency by over 3000%, connecting approval and source system information.

Integrated COTS Software Applications – Salesforce, SOA, Oracle, and ServiceNow – with internally developed Applications to allow for the sharing of Data, collaboration between Business Units, and improved Data Accuracy, Quality, and Performance along with the creation of Data Governance principles to support the integration.

Generated templates and trainings for enactment of new systems and functionality, presenting leaders and stakeholders, then at enterprise level, significantly increasing productivity and team performance.

Senior Data/Business Analyst: serve as a multi-faceted Analyst working with the Program Manager, Data Architect, and Project Manager to implement an Enterprise-wide Data Governance Program. Engaging with various teams across the Business to conduct Logical and Physical Data Mapping exercises perform Data Quality and Data Analysis to support ongoing Projects, perform Data and Process Mapping, Process Improvement, and Data Modeling. Building out internal SharePoint site for use as a Knowledge Hub for Data Governance Program to include Documents, Policies, Strategies, Templates. Additionally creating a Data Quality Cycle and Data Quality Checklist which can be used throughout the Enterprise to support Data Governance efforts.

Collaborates with Project Manager to work with cross functional and maxtrixed teams including application owners, application developers and analysts and the like to determine to understand scope of work and lay out a roadmap to delivery based on business needs and functionalities desired for new or revised application.

Performed data quality and analysis/profiling on internal and external data sources

Determined data handling requirements for internal and external sources to include APIs

Actively worked with the Business to troubleshoot data flow and data quality issues in support of deployed functionality

Present Demos to Leadership and other Stakeholders. Create Training Documents and Training Videos to support newly released functionality.

Works with leadership to identify any risks/issues that may impact the delivery for the program. Document those risks to ensure they are communicated to the leadership for awareness and escalation. Convene meetings and plan agenda to ensure important issues are aired and resolved

Managing the and prioritizing the backlog with the Data Architect and Project Manager in JIRA and MS Teams and facilitate stand ups to track progress through completion

Works with program leads to prep for Planning sessions T. Rowe Price – Owings Mills, MD

Senior System Analyst, 6/2016 to 7/2019

Prioritized incident reports, quickly examining all situations to determine execution order and level of support needed. Created central document database to house answers to common issues, decreasing time spent researching solutions. Led meetings and trainings to elevate levels of cooperation and teamwork while dispersing information and continually improving overall performance. Supported improvement and troubleshooting of COTS Application, AWD, along with the Development Team and Vendor. Produced SQL queries, accurately identifying problems and gaps within data sets to deliver quick response to any issues. Selected Contributions:

Presented new processes, utilizing Agile strategies, to streamline and clear 100-incident support backlog.

Developed system to allow for better and quicker system issue response, reducing reaction times by 25% and unfulfilled SLAs by 33%.

Business Analyst: worked with three-person Data Governance Team to build out Data Governance process within the Judicial Data and Analysis Office. Took lead in building out Data Governance framework by consulting with internal experts and documenting best practices gathered from various sources. Mentored younger Business Analysts and hosted weekly meetings to share knowledge, ideas, and tips

Wrote up a Data Maturity Assessment to be able to measure the maturity level of offices and branches who will be installing a Data Governance process so that the various Offices could identify where they were in the Data Governance process begin building out their Road Maps allowing them to reduce review time by 33%

Created Access database to be able to normalize data from Informix, SQL Server, Oracle, and DB2 databases and support analysis, profiling, and metrics creation involving data flows from 3 internal databases and 97 external court databases

Worked with cross functional teams including application owners, application developers and analysts and the like to determine to understand scope of work and lay out a roadmap to delivery based on business needs and functionalities desired for new or revised application.

Tracked course of project from meetings, conferring with product owners and technology leads, and receiving updates. Maintained the project schedule as needed and work with PMs from different workstreams delivering the work to build the schedule activities as for planned future releases

Worked with leadership to identify any risks/issues that may impact the delivery for the program. Documented those risks to ensure they are communicated to the leadership for awareness and escalation. Convened meetings and plan agenda to ensure important issues are aired and resolved

Managing the backlog in JIRA and MS Project and facilitating stand ups to track progress through completion

Work with program leads to prep for Planning sessions

Collaborate with Strategy Manager and fellow Senior Business Analyst to host workshops for enhancement of existing interfaces involving heads and other subject matter experts from over 12 other US Courts offices

Present Show-Me and Try-Me sessions for user community to introduce them to new features created during upcoming releases involving over 20 members of the development team and associated offices US Courts – Washington, D.C.

Business Analyst, 10/2015 to 6/2016

Hosted workshops for management and subject experts from other offices in the US Courts, collaborating with other strategists and analysts to enhance existing interfaces. Collaborated across departments and teams to streamline the project management process and ensure proper process and communication. Produced SQL queries, accurately identifying problems and gaps within data sets to deliver quick response to any issues. Selected Contributions:

Crafted a custom Microsoft Access database, condensing data from internal and external departments, easing the analysis and profiling of data.

Business Analyst: worked with three-person Data Governance Team to build out Data Governance process within the Judicial Data and Analysis Office. Took lead in building out Data Governance framework by consulting with internal experts and documenting best practices gathered from various sources. Mentored younger Business Analysts and hosted weekly meetings to share knowledge, ideas, and tips

Wrote up a Data Maturity Assessment to be able to measure the maturity level of offices and branches who will be installing a Data Governance process so that the various Offices could identify where they were in the Data Governance process begin building out their Road Maps allowing them to reduce review time by 33%

Created Access database to be able to normalize data from Informix, SQL Server, Oracle, and DB2 databases and support analysis, profiling, and metrics creation involving data flows from 3 internal databases and 97 external court databases

Worked with cross functional teams including application owners, application developers and analysts and the like to determine to understand scope of work and lay out a roadmap to delivery based on business needs and functionalities desired for new or revised application.

Tracked course of project from meetings, conferring with product owners and technology leads, and receiving updates. Maintained the project schedule as needed and work with PMs from different workstreams delivering the work to build the schedule activities as for planned future releases

Worked with leadership to identify any risks/issues that may impact the delivery for the program. Documented those risks to ensure they are communicated to the leadership for awareness and escalation. Convened meetings and plan agenda to ensure important issues are aired and resolved

Managing the backlog in JIRA and MS Project and facilitating stand ups to track progress through completion

Work with program leads to prep for Planning sessions

Collaborate with Strategy Manager and fellow Senior Business Analyst to host workshops for enhancement of existing interfaces involving heads and other subject matter experts from over 12 other US Courts offices

Present Show-Me and Try-Me sessions for user community to introduce them to new features created during upcoming releases involving over 20 members of the development team and associated offices Discovery Communications – Silver Spring, MD

Senior Business Analyst, 3/2014 to 9/2015

Gathered information regarding department needs, translating requests into projects by outlining requirements and exploring functional and technical needs. Provided learning opportunities regarding Agile, applying principles and theories as necessary. Condensed review process for old documents by developing automations and dropping search time by 500%. Produced SQL queries, accurately identifying problems and gaps within data sets to deliver quick response to any issues. Selected Contributions:

Saved the company over $3M through the implementation of research database, gathering vital information used to make decisions regarding existing and potential contracts and negotiations.

Senior Business Analyst: interacted with stakeholders across the company to gather requirements, translate business requirements into technical and functional requirements, provide updates, review analysis, and review reports. Assisted Scrum Master in implementing Agile throughout the Team and providing the team with a better understanding of Agile Principals, Theory, and Ceremonies

Worked with Development Team to implement the capture of Genre for use in identifying Assets under Control and allowing the Business to better leverage its $2,000,000,000 investment in Content by providing better understanding and insight into the makeup of the Content

Worked with cross functional teams including application owners, application developers and analysts and the like to determine to understand scope of work and lay out a roadmap to delivery based on business needs and functionalities desired for new or revised application.

Tracked course of project from meetings, conferring with product owners and technology leads, and receiving updates. Maintained the project schedule as needed and work with PMs from different workstreams delivering the work to build the schedule activities as for planned future releases

Worked with leadership to identify any risks/issues that may impact the delivery for the program. Documented those risks to ensure they are communicated to the leadership for awareness and escalation. Convened meetings and plan agenda to ensure important issues are aired and resolved

Managing the backlog and facilitating stand ups to track progress through completion

Work with program leads to prep for Planning sessions

Created Database which allowed the Business to more easily research Production Companies and associated Content so that Contracts, and Negotiations could be more efficiently undertaken, resulting in over $3,000,000 in savings by allowing the business to understand complex existing relationships

Developed an automated tool to allow the Business to review legacy Development Deals, Licensed Properties, and Content reducing review time by 500%, from several weeks to days

Collaborated with Strategy Manager and fellow Senior Business Analysts to host workshops for gathering of requirements across 12 internal channels including Discovery, Science, Velocity, TLC and 2 international regions – EMEA, and APAC

Transamerican Auto Parts – Compton, CA

Data Manager, 7/2012 to 11/2013

Modernized data management systems, collaborating with IT Director to detect potential areas for improvement. Produced SQL queries, accurately identifying problems and gaps within data sets to deliver quick response to any issues. Oversaw management of all projects, directing automation updates, decreasing inaccuracies by 100% and increasing import speeds by over 500%. Selected Contributions:

Recognized growth opportunities of $1.2M through detailed analysis of manufacturing, partnerships, and expansion potential.

Engaged with external vendors to load part and catalog data into Transamerican's database according to industry standards to improve quality, performance, and trust.

Data Manager: collaborated with IT Director on technical documentation of data load processes, data warehousing, and systems integration for modernization of manufacturing data management. Collaborated with other Team Managers to implement career enhancement programs for junior Analysts and provide an opportunity for sharing knowledge, ideas, and solutions

Performed gap analysis that identified $1.2 million in growth opportunities for the manufacturing group by reviewing opportunities for possible expansion, partnerships, and manufacturing

Worked with cross functional teams including application owners, application developers and analysts and the like to determine to understand scope of work and lay out a roadmap to delivery based on business needs and functionalities desired for new or revised application.

Tracked course of project from meetings, conferring with product owners and technology leads, and receiving updates. Maintained the project schedule as needed and work with PMs from different workstreams delivering the work to build the schedule activities as for planned future releases

Worked with leadership to identify any risks/issues that may impact the delivery for the program. Documented those risks to ensure they are communicated to the leadership for awareness and escalation. Convened meetings and plan agenda to ensure important issues are aired and resolved

Managing the backlog and facilitating stand ups to track progress through completion. Work with program leads to prep for Planning sessions

Implemented template for importation of Product Data reducing errors by 100% and increasing speed of importation by over 500% by automating the Process and adding Data Validation to the Product Information fields.

Reviewed data consumption needs and worked with development team to connect with vendor, source, and industry data through FTP, API, and other methods

Worked with Business to provide an internally automated source of Product Data so that Catalogs, Websites, and other Media could be easily updated which resulted in a reduction of error rates by 75% and a decrease of update times from a week to less than a day

Partnered with Business to implement a process for the capture, storage, and exporting of Product Data which met industry standards and standardized values allowing it to be shared across Platforms and Partners reducing errors by 99% and increasing the ability to share by 200% CarFax, Inc. – Centreville, VA

Senior Business Analyst, 3/2006 to 7/2012

Gathered information regarding department needs, translating requests into projects by outlining requirements and exploring functional and technical needs. Produced SQL queries, accurately identifying problems and gaps within data sets to deliver quick response to any issues. Researched best tools and practices for accurate and efficient data management. Offered training and leadership across departments, facilitating meetings to ensure continued high personnel performance. Analyzed records and processes, pinpointing issues preventing $1M in potential over-billing.

Selected Contributions:

Engaged with over 35 external vendors to migrate and load data into the Carfax database providing over 1 billion service records creating a competitive advantage compared to other vehicle history products

Collaborated with Business, Sales, and Development Team to build Service Program from a 1,000 Dealers and Repair Shops providing 1,000,000 service records to 21,000 Dealers and Repair Shops providing over 1,000,000,000 service records.

Senior Data/Business Analyst: served as lead in development of new data sources, mentoring of junior Business Analysts, and worked with internal and external Customers to troubleshoot, enhance, and support existing data sources. Partnered with the Business to expand Service Link product offering, enhance various data feeds, and work with external Data Providers to insure quality data. Lead Team Business Analyst focused meetings to allow for knowledge sharing and career enhancement. Created weekly meeting for Service Link Business Analysts to share solutions to problems encountered during the week and develop standards for troubleshooting future problems

Spearheaded initiative to create a tool so that Requirements, Business Rules, User Testing, and Data Profiling could be centralized and easily updated reducing time to market of new data sources by 50% and decreasing time to update data sources from weeks to days

Worked with the Development Team to develop Data Integration and Migration Strategies for the consumption of Data from various sources – vendors, suppliers, dealers, aftermarket shops – through a variety of methods – API and FTP.

Partnered with the Business to grow Automobile Dealers and Aftermarket Service Centers from 1,000 to 21,000 participants and increase records from under 1,000,000 to over a 1,000,000,000

Identified issues with Data Feed from an External Data Source which could have resulted in nearly

$1,000,000 in over-billing for records and implemented Process to identify possible over-billing issues in the future

Mentored business data analysts and business technical support specialists and held weekly training. Facilitated leadership and team building workshops/meetings for data operations teams/department

Worked with cross functional teams including application owners, application developers and analysts and the like to determine to understand scope of work and lay out a roadmap to delivery based on business needs and functionalities desired for new or revised application.

Tracked course of project from meetings, conferring with product owners and technology leads, and receiving updates. Maintained the project schedule as needed and work with PMs from different workstreams delivering the work to build the schedule activities as for planned future releases

Worked with leadership to identify any risks/issues that may impact the delivery for the program. Documented those risks to ensure they are communicated to the leadership for awareness and escalation. Convened meetings and plan agenda to ensure important issues are aired and resolved

Managing the backlog and facilitating stand ups to track progress through completion

Work with program leads to prep for Planning sessions Educational Background

Bachelor of Arts, History

College of Charleston, Charleston, SC

1993 – 1998

Training

SPSS

Agile

Agile Best Practices

Agile Team Building

Agile Requirements Writing

Hobbies and Interests

Competition License Holder – Sports Car Club of America

Part Owner – SCCA Club Racing Team

Flying/Aviation – 100+ hours of Pilot-in-Command of a Piper PA28-161

Sailing – owned and lived aboard sailboats in South Carolina and Maryland. Offshore and inshore sailing.

Surfing

Snorkeling and SCUBA Diving - PADI Dive License

Technologies and Keywords

Agile, Application Development, As-Is Analysis, Automation, AWS, Balsamiq, Business Analysis, Business Process Analysis, Business Process Improvement, Business Process Mapping, Business Requirements, Business Rules, COGNOS, Content Management, Current State Analysis, Dashboards, Data Analysis, Data Analytics, Data Extraction, Data Governance, Data Integration, Data Management, Data Mapping, Data Migration, Data Migration and Integration, Data Mining, Data Modeling, Data Models, Data Profiling, Data Quality, Data Quality Methods and Procedures, Data Strategies, Data Visualization, Data Warehousing, DB Visualizer, Documentation, DQ Analyzer, ETL, Functional and Technical Requirement Gathering, Future State Analysis, GAP Analysis, Informatica, Jira, Knowledge Transfer, KPIs, Leadership, Mentoring, MetaCenter, Metadata Management, Metrics, Microsoft Access, Microsoft Excel, Microsoft Office, Microsoft Power BI, Microsoft Power Point, Microsoft Visio, Microsoft Word, Microstrategy, MySQL, Presentation Skills, Presentations, Process Improvement, Production Support, Project Management, Report Creation, Requirements Gathering, Root Cause Analysis, Salesforce, Scrum, SDLC, ServiceNow, Snowflake, Software Development, SPSS, SQL, SQL Server, Systems Analysis, Systems Integration, Tableau, Teamwork, Test Cases, Testing, Troubleshooting, UML, UNIX Server, Use Case Development, User Acceptance Testing, User Experience (UX), User Interface (UI), User Story Writing, Waterfall, Web Services, Written Communication, XML

Contact this candidate