Data Analyst Social Media
Resume:
Shari Robinson
Data Developer
*****.*.********@*****.***
WORK EXPERIENCE
Pierian Spring Foundation, Inc • 06/2010 – Present Director
SKILLS
•3D Printing
•Accounting
•As the Director of a nonprofit, I have been responsible for education, management, technical, infrastructure, hiring, and planning decisions within the organization. Having started with the company at the beginning, I have led the organization through to a solid of success.
• Active Server Pages
•Adaptive Server Enterprise
•Agile
•Analysis
Head Robotics Coach
• Application Architecture
•Application Server
•As the Head Coach of Lord of the Bricks Robotics teams, responsibilities include preparing students for participation in worldwide robotics competitions, as well as for careers in engineering.
•Educate and assist team members with software development in RobotC, JAVA, Python, Machine Learning, Rev power systems, Lego Mindstorms, and Lego EV3, as well as other languages, as needed.
•Provide support, resources, education, and assistance with the creation, from start to finish, of competition-worthy robots, including, but not limited to: CAD Design and 3D printing, prototyping, brainstorming, wiring, assembly, testing, engineering notebook creation, fundraising, social media presence, marketing, outreach, graphics design, business planning, SWOT Analysis, animation and design, project management, and other activities required to endured the continued success of the team.
•Team is a multi-year State Championship team, has advanced to the East Super Regional Championships, and has been a winning team of the Google Lunar X-Prize Moonbot competition.
• AS/400
•Batch Processing
•Best Practice
•Brainstorming
•BTEQ
•Bug Fixing
•Business intelligence Reporting
•Business Management
•Business Planning
•Business Process Mapping
•Business Requirement
•Business Rule
•CAD Software
•Call Analytics
•Case Management System
•COBOL
•Code Deployment
•Code Review
•Cold Calling
•Collaborative Marketing
•Communication skills
•Computer Animation
•Creativity
•Customer Satisfaction
•Customer Surveys
•Custom Reporting
•Data Administration
•Data Analysis
•Database Application Development
Department of Elections • 02/2022 - 11/2022 Data Analyst
• Database Design/Refactoring
•Database Management System
•As a Data Analyst 2, responsibilities include maintain voter records' ETL Processes • Working with large data sets or data warehousing • Collaborate with other IT staff, vendors, partners and other stakeholders to design and develop data movement and electronic data interfaces utilizing best practices and the production of standard design patterns. • Develop relational database and data warehouse components including tables, views, indexes, procedures, ETL packages, and data interfaces. • Design data management and interface components and practices to facilitate efficient and effective organization, maintenance, and utilization of data. • Plan, design and implement system and database integration via both batch and semi- real-time approaches, including the development of ETL processes for data movement between database architecture components and end- application databases. • Assist in the design and development of SQL Server Analysis Services (SSIS) packages to satisfy business needs. • Assist with database administration including the debugging and optimization of SQL queries and stored procedures. • Design and develop SSIS packages in VB.NET. • Code backup using GIT. • Project tracking using Jira. • Build and edit Data Factory pipelines, manage database needs, reporting, work with customers on file issues and perform data research.
• Data Collection
•Data Control
•Data Editing
•Data Extraction
•Data Flow Diagram
•Data Formatting
•Data Infrastructure
•Data Integration
•Data Interface
•Data Interpretation
•Data Management
•Data Mapping
•Data Mart
•Data Modeling
•Data Profiling
•Data Reporting
•Data Transfer
Bowlero • 01/2020 - 05/2020 Database Developer
• Data Validation
•Data Warehouse
•As a Senior Database Developer, I excel in managing company data infrastructure and assets. My expertise lies in planning, designing, and implementing data interfaces and management components. With a robust technical background, I skillfully administer Microsoft SQL Server infrastructure. I have a deep understanding of data models, design, access, and table maintenance. Additionally, I specialize in developing and administering ETL processes using SSIS and other tools, adhering to interface management standards, and implementing effective monitoring and alerting systems. My experience extends to interpreting data models, creating data access solutions, reporting, data marts, analytic cubes, and visualization.
•Essential responsibilities and duties include:
•Collaborate with IT staff, vendors, and partners to design and develop data movement and electronic data interfaces, following best practices and standard design patterns.
•Collaborate with other software architects, database architects, design analysts, business analysts and others to understand business requirements.
•Create high-quality relational database and data warehouse components, including tables, views, indexes, procedures, ETL packages, and data interfaces.
•Architect data interfaces, including data flow diagrams, data mapping documentation, data dictionaries, and data management plans.
•Develop, implement, and optimize stored procedures, views, materialized views, functions, triggers, and synonyms using T-SQL with all the necessary error handling.
•Optimize data management and interface practices for efficient organization, maintenance, and utilization of data.
•Lead system and database integration efforts, employing both batch and semi-real-time approaches. Develop ETL processes to facilitate data movement between database architecture components and end- application databases.
• Design Report
•Desktop Application
•Determination
•Development Standards
•DevExpress Universal
•Digital Analytics
•Domestic Relations
•E-commerce
•Electric Power System
•ETL Tool
•Error Handling
•Facilitate
•Financial Reporting
•Functional Specification
•Fundraising
•Git
•Graphical User Interface
•Graphic Design
•Healthcare Industry
•Hypertext Markup Language
•IBM AIX
•IBM DB2
•IBM Informix
•Identity Management
Richmond Public Schools • 11/2017 - 01/2020 Sql Developer
• Interface Management
•Inventory Management Software
•As a SQL Developer, responsibilities include collecting data from various sources; developing SQL queries of medium to high complexity; developing, deploying and/or maintains reports and Microsoft SQL Integration Services (SSIS) packages using Microsoft SQL Server Reporting Services (SSRS) 2008 and/or higher; determining and documenting technical requirements for application systems, including system module interface and report design, unit test plans, and test cases; supporting all phases of the software development cycle including requirements gathering, analysis, design, testing, implementation, and production; developing, debugging, and testing system interfaces and reports based on user requirements and input from subject matter experts; process documentation; creating database release deployment scripts and database objects; providing recommendations regarding further definition of development standards and application architecture; performing unit testing and assists in user testing of interface or report modifications; developing and maintaining effective partnerships with various client groups in order to meet project needs; performing related duties as assigned. Aspen, VersaTrans, Access, SQL Server, JAVA, .NET, Excel, Google Workgroups, custom solutions.
• Issue Resolution
•Java
•JIRA
•Job Control Language
•Korn Shell
•Learning Management System
•Machine Learning
•Management
•Management Information System
•Marketing
•Meal Planning
•Microsoft Access
•Microsoft Analysis Services
•Microsoft Azure
•Microsoft Excel
•Microsoft FrontPage
West Creek Financial • 07/2017 - 08/2017 Data Analyst
• Microsoft SQL Server
•Microsoft Visual Studio
•As a Data Analyst, responsibilities include collecting data from various sources, both internal and external; assessing the quality of the data; analyzing the story being told by the data; formatting data for database inclusion; migrating data into existing databases; designing tables, queries, and database solutions to meet determined needs; creating entity relationship diagrams; developing reports and reporting solutions. MySQL, Access, Excel, Google Workgroups, custom solutions.
• MySQL
•.NET
•Numerical Analysis
•Object Modeling Technique
•Online Analytical Processing
•Online Database
•Oracle Database
Supreme Court of Virginia • 05/2016 - 07/2017 Vb.Net Developer
• Oracle Peoplesoft
•Performance Appraisal
•As the VB.NET Developer, responsibilities include performing bug fixes, enhancements, and new development for the proprietary Juvenile & Domestic Relations (JDIS) software, which provides users of the Juvenile Case Management System (JCMS) the ability to digitize case documents found in the Juvenile & Domestic Relations District Courts, allows users to select cases in which to add, edit and review scanned documents, and provides interfaces that share scanned documents and data from JCMS with internal and external agencies.
•Rewrite code, and redesign databases to accommodate new features, as well as correct process issues.
•GUI modifications, add-in management, and development schedule generation.
•Identifying risks in both design and process.
•Participate in a Technical Review Board to manage user requirements and maintain end-user involvement, as well as to provide integration with QA.
• Planning Process
•Powershell
•Private Tutoring
•Problem Management
•Problem Solving
•Pipeline
•Process Documentation
•Project Management
•Project Monitoring
•Proprietary Software
•Provide Support
•PuTTY
•Python
•Quality Control
•Query Design, Optimizations
•Rational ClearQuest
•Work directly with non-technical users to gather information and requirements, and streamline processes.
•Perform independently with little direction as the sole application developer for this package.
•Informix Server, VB.NET, SQL, DevExpress, Team Foundations Server, ClearQuest ticket management system, Wireframing.
• Relational Database Management System
•Release Management
•Report Generation
•Reporting Software
•Report Writing
Requirements Gathering
Partnership Marketing • 5/2016-6/2016
Sql Developer
•As the SQL Developer, responsibilities included performing bug fixes, enhancements, and new development for the proprietary inventory fulfillment software. Produced SSIS packages to automate tasks involving ETL and data manipulation; standardized data and produced documentation of stored procedures, tasks and processes to ensure successful data transfers; created stored procedures in SQL Server; supported data in SQL Server, Tableau, and Azure environments; diagnosed and produced solutions for existing process issues; identified risks in both design and process; cultivated relationships directly with non-technical users to gather information and user requirements; provided interim support and clarity after previous developer left, requiring advanced troubleshooting and process mapping skills; independently performed with little direction as the sole application developer SQL Server, SSIS, BI, T-SQL, Azure, Tableau, Visual Studio 2008.
• Requirements Management
•Risk Management
•ROBOTC
•SAP Crystal Reports
•SAS Enterprise Guide
•Satellite Networking
•Scheduling Process
•Scrum Methodology
•Server Management
•Shell Script
•Software Debugging
•Software Design Description
•Software Design Pattern
Arc Of Baltimore • 05/2014 - 03/2016 Vb.Net Developer
•As the VB.NET LifePrint Developer, responsibilities included performing enhancements as well as new development for the proprietary software, which tracks elements of care for individuals with disabilities for State-required funding support. Rewrite code, and redesign databases to accommodate new features, as well as correct process issues. GUI modifications, reporting elements, and development schedule generation. Identifying risks in both design and process. Worked directly with non-technical users to gather information and requirements, and streamline processes. Perform independently with little direction as the sole application developer SQL Server, VB.NET, DevExpress, Citrix.
• Software Development
•Software Development Life Cycle
•Software Requirements Specification
•Software Technical Support
•SQL
•SQL Server Integration Services
•SQL Server Management Studio
•SQL Server Reporting Services
•Stored Procedures/Functions/Triggers
•Streamlining Process
•SWOT Analysis
•Sybase Software
Pyramid Consulting/Capital One • 04/2011 - 05/2014 Data Analyst/Programmer
• System Testing
•Tableau Software
•Team Development
•Technical Competency
•Technical Documentation
•Technology Analysis
•As a data analyst/programmer, responsibilities included scripting and automation using Unix, SQL Assistant, SAS Enterprise Guide, Teradata, Excel VBA, Putty, and UltraEdit. Perform data manipulations and scrubbing. Unix, BTEQ and KSH scripting. Responsible for ObiOne outbound call data reporting, quarterly Infosec audit processes, inbound call reporting, agent processes and missing data, call transfer reporting, customer satisfaction and escalations reporting, and data migrations and transfers.
• Teradata Database
•Test Cases
•Ticket Management
•Time Management
•Toad Software
•Training experience
Transact-SQL (T-SQL)
•Worked directly with non-technical users to develop requirements, and assist with analysis. Performed independently with little direction.
• Troubleshooting
•UltraEdit
• Unit Testing
Management Excellence • 4/2011-7/2011
Database Programmer
•As a database programmer, responsibilities included programming and modifications to two Access Database/VBA applications for maintaining elevator units, as well as data migrations and merges. Access, Excel, VBA, Automation, MSI setups. Worked directly with non- technical users to develop requirements, and assist with analysis. Performed independently with little direction.
Unix Operating System
•Usability Testing
•User Involvement
•User Story
•Views
•Visual Basic
•Visual Basic for Applications
•Visual FoxPro
•Visual Studio
•Work Independently
ADDITIONAL EXPERIENCE
Unparalleled ability to communicate effectively and work with both business and technical users across all levels of the organization
Proven ability to work collaboratively on project teams, and to work independently with minimal supervision
Demonstrated ability to develop and maintain positive, productive working relationships with customers and co-workers while delivering quality systems in short time frames
Industry experience includes banking, financial, insurance, transportation, State and local governments, retail, E-Commerce, non-profit, healthcare, telecommunication, legal, payroll, entertainment, and tech.
10+ years of experience programming Visual Basic/VBA/VB.NET.
10+ years of experience Data Mapping, Data Analytics, and Data Manipulation
10+ years of experience with ETL processes such as SSIS, reporting packages such as SSRS, and analysis packages such as SSAS, as well as SAS Enterprise Guide.
10+ years of experience designing, creating, modifying, and data analysis/reporting of relational databases and data warehouses, as well as with database applications development.
10+ years of experience with SQL, T-SQL, etc., including advanced queries, views, stored procedures, or functions
Software Development in an Agile Scrum environment
10+ years of experience developing with Access, Oracle, Sybase, SQL Server, Informix, DB2, etc.
10+ years serving as a Data Architect
5+ years’ experience building data flows using ETL tools and creating and implementing ETL processes
Experience with Salesforce and Azure cloud-based environments
Ability to architect and model mission critical RDMS, BI, OLTP, OLAP and solutions leveraging multiple DBMS technologies
Extensive experience with Data Analysis, Data Profiling, Data Flows and Data Modeling
Demonstrated experience with profiling and loading files from various data sources which include RDMBS, OLAP cubes, mainframe file systems, web services, APIs, XML, text files and other documents
Ability to work with both business and technical users to define and gather reporting/analytics requirements with experience translating business and technical requirements into comprehensive data reporting strategies and analytic solutions
Unparalleled ability to communicate effectively and work with both business and technical users across all levels of the organization
Proven ability to work collaboratively on project teams, and to work independently with minimal supervision
Demonstrated ability to develop and maintain positive, productive working relationships with customers and co-workers while delivering quality systems in short time frames
Industry experience includes banking, financial, insurance, transportation, State and local governments, retail, E-Commerce, non-profit, healthcare, telecommunication, legal, payroll, entertainment, and tech.
10+ years of experience programming Visual Basic/VBA/VB.NET.
10+ years of experience Data Mapping, Data Analytics, and Data Manipulation
10+ years of experience with ETL processes such as SSIS, reporting packages such as SSRS, and analysis packages such as SSAS, as well as SAS Enterprise Guide.
10+ years of experience designing, creating, modifying, and data analysis/reporting of relational databases and data warehouses, as well as with database applications development.
10+ years of experience with SQL, T-SQL, etc., including advanced queries, views, stored procedures, or functions
Software Development in an Agile Scrum environment
Contact this candidate