SUMMARY:

• As a Data Analyst my goal is to obtain a dynamic opportunity with a people oriented company.
• I am interested in growing with a company that allots for the celebration of team and individual milestones.
• The company that would allow me to best leverage my information technology skills within Microsoft Excel
• Data Visualization, Information Architecture, Data Mapping and Information Assurance; in turn for the ultimate growth of government or commercial organizational projects.

TECHNICAL SKILLS:

• Microsoft Excel, SQL, Relational Database, Microsoft Access, SharePoint, Microsoft
• Dynamics, Data Visualization, Experimental Design & Analysis, Cloud Computing, Data
• Analysis, Troubleshooting, Risk Assessments, SAP, Quest Analytics, Microsoft SQL Server
• Management Studio, Jenkins, Jira, Confluence, Data Management, Python

PROFESSIONAL EXPERIENCE:

Data Analyst

Confidential, Baltimore, MD

Responsibilities:

• Provided cleansed and normalized data streams to support our client facing application for a high visibility project called store locater.
• Normalized and cleansed large datasets sales data utilizing our CRM Kaboomi in resolving data accuracy issues.
• Utilized Trello, Atlassian Jira, and Microsoft Teams to ensure seamless team collaborative efforts.
• Created data templates to complete ETL operations seamlessly into MDS and OPAL systems.
• Utilized Dell Boomi to create a seamless migration of Data between Opal, MDS and Boomi, for our Store Locator application.
• Extracted weekly reports from power BI in order to update store sales data footprint.
• Created several excel Dashboard in order to create seamless internal data visibility; in order to complete tasks with highest priority.
• Utilized Microsoft Access Database to run queries to extract Store Locator application data.
• Created unique data templates for each CRM system extract.
• Utilized the data governance framework to deploy small data projects designed to streamline in house data processes for our SL application and deployment.
• Maintained key market updates for European and Asian footprints.
• Maintained weekly updates of our North American market KPI’s.
• Executed large Q4 data cleansing project to normalize Store Status Data for South American markets.
• Utilized Python scripting and Jypter notebook to extract data sets that created actionable decisions for management.
• Took a lead role in our data integration planning process to plan the initial phase of conversion to single source data operations for Finance.
• Utilized SQL Loader to input external .CSV, .JSON, and .XLSM market files into MDS.
• Performed record linking and matches between multiple data sets utilizing pandas.

IT SPECIALIST

Confidential, LAUREL, MD

Responsibilities:

• Resolved data related complaints by consolidating data sources.
• Created and analyzed all the phases of the project management processes.
• Audit files and metadata entries for completion and proper organization.
• Created automation Dashboards to increase work productivity by creating visibility into expiring contracts.
• Managing Procurement Intranet and updating procurement guidelines pages and subheadings.
• Redesigning Intranet landing pages to improve user experience.
• Created a searchable Access database for procurement buyers and specialists.
• Created a contract repository for legacy system documents.
• Performed data audits on contracts located in P - drive.
• Utilized insight analytics to track and performed contract tracing for operations team.
• Approved data streams for publishing onto Commissioner dashboard.
• Created data clusters to reorganize procurement drive and created standardized naming conventions for new contracts and purchase orders.
• Restructured department data utilization by implementing cloud based tracking software called CTRAX to seamlessly migrate tasks utilizing many programs into one user friendly utility
• Utilized Jira to track internal project requests to completion
• Consulted on major IT dashboard project buildouts
• Created demos for highly visible dashboard launch objectives
• Liaised with directors and CEO’s to created pathways that would create immediately impactful changes in the workflow of procurement department.
• Managed time efficiently across multiple construction projects to ensure contracts were in alignment with public solicitation policies.

Data Engineer

Confidential,Salt Lake, CITY UTAH

Responsibilities:

• Provided Data Mapping expertise for large sets of data that are integrated within our client's Salesforce platform.
• Made recommendations on process improvements in Github and features documentation.
• Maintain data quality and control
• Communicate with Architects and Client stakeholders on progress, impediments and adhere to data rules/guidelines.
• Experience working with the financial services; loan processing, mortgages, lenders
• Working with 3rd party vendors and specification of deliverables.
• Data analysis using salesforce to work with large sets of data
• Data mapping experience in MTRNS
• Utilized VSCode, GitHub
• Utilized Hadoop ecosystem to reduce redundancy during large data -migrations to Salesforce.
• Worked with developers on integration from proprietary system to Salesforce platform.
• Utilized Apex and Json languages to complete assigned jira tasks.
• High level of written and oral communication
• Proficiency with Excel, CSV Files, Jira, and collaboration tools
• Experience in meeting deadlines in a fast-paced environment
• Demonstrated ability to solve problems with a sense of ownership, enthusiasm and innovation.
• Strong team work skills
• Demonstrated poise, confidence and professional maturity to interface with senior-level executives.

DATA ANALYST

Confidential, COLUMBIA, MD

Responsibilities:

• Database and Quest Analytics
• Medicare Healthcare standards and codes from Centers of Medicaid and Medicare.
• Created Excel Progression reports for project milestones for provider network development.
• Data mapping for Analytics team to identify provider and network gaps.
• Created Data modeling and Scenarios for clients to generate simulated network data maps.
• Manipulated data tables using SQL queries, and Utilized Macros to pull data from Internal system called WebTrack.
• Utilized collaborative tools such as Jira, Slack, Microsoft Teams, Zoom, Outlook, Google Hangouts to facilitate team meetings and seamless collaborations.
• Reconciled data with data loads into Jenkins system to update provider network data.
• Ran assignments jobs in order to update existing records with a Proprietary software platform called WebTrack.
• Utilized Client generated HSD tables to create seamless data.
• Proprietary software platform called WebTrack.
• Utilized Client generated HSD tables to create seamless data streams in accordance with CMS codes.
• Created SharePoint sites to ensure team collaboration was fluid and all documents and updates could be easily accessible to Clients and the team.
• Created PowerPoint presentations of the data-flow the Analytics team to inform new prospects of how to effectively utilize our provider recruitment services.
• Utilized Geocoding methods to create a data maps to engage our future targets and prospects.
• Utilized data loading into Jenkins to update Web Track of new Facilities and Providers identified with client migrated data.
• Scrubbed and loaded provider data utilizing industry best practices.
• Performed data research to verify data validity.
• Deployed Data cleansing methods that ensure valid data entries into company wide Web Track System.
• Collaborated with project managers to ensure deadlines were met and proposed standards and goals were met.
• Created and analyzed data phases of various projects to ensure project managers needs were met when presenting to the client.
• Resolved data related complaints by consolidating data sources.
• Working with clients and project managers to understand their data migration needs and determine any data gaps.
• Reduced department data errors by 3% by enlisting new best practices for migrating data into WebTrack.
• Updating provider credentialing within Web Track System.
• Running Jenkins jobs to update large client datasets.
• Update project milestones using Jira and Asana tools.
• Normalization of client data for loading.
• Identification of data anomalies based on established best practices criteria.

IT SPECIALIST

Confidential, LAUREL, MD

Responsibilities:

• Implemented new business process for Bonds and Insurance department.
• Streamlined data conversion and reduced data risk.
• Reduced manual entry data tasks by creating customized automated dashboards for department.
• Created detailed FY’ forecasts to ensure rapid deployment of key decision making by management.
• Updated Jira tickets and uploaded updates to ongoing projects.
• Resolved data related complaints by consolidating data sources.
• Created substantial database networks to streamline procurement workload tracking.
• Utilized Oracle SQL to execute data modeling and mapping requests.
• Optimized Jira utilization by building
• Application of tools such as, Tableau for data visualization of big Data.
• Researched and provided solutions that were deployed department wide.
• Analyzed various data solutions and with procurement team to solve interdepartmental Data transfer disparities.
• Worked alongside management to analyze various data solutions, that streamlined the procurement and purchasing departments.
• Oversaw the deployment of Intellicheif Server based software EBS solution. Implemented Oracle compatible Data Warehouse for Legacy data.
• Deployed the initial stages of a (PPM) system to create a cloud based office.
• Utilized business intelligence tools such as Tableau and SAP for real time business intelligence predictive Analytics and machine learning.
• Designed unique VBA Macros.
• Utilized Openfire software to assist with data cleansing
• Configured I-drive and G-Drive and increased capacity of department storage abilities and created file hierarchy and standardized naming conventions.
• Converted printing, scanning peripherals to automate all manual tasks.
• Restructured department data utilization by implementing cloud based tracking software called CTRAX to seamlessly migrate tasks utilizing many programs into one user friendly utility.
• Researched and deployed zonal OCR technology to be deployed department wide in order to eliminate physical repositories of documents.
• Utilized microft365 to enhance team communications and collaborations.
• Elimination of Data redundancy with deployment of EBS software solutions
• Reduced processing time of contracts and bonds department by 2%.
• Reorganized historical dataset within FileNet and generated dynamic reports.
• Performed CRUD operations in MS Access

DATA ANALYST

Confidential, BOWIE, MD

Responsibilities:

• Worked with business requirements analysts/subject matter experts to identify and understand requirements. Conducted user interviews and data analysis review meetings.
• Defined key facts and dimensions necessary to support the business requirements along with Data Modeler.
• Resolved the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Performed Data Validations using SQL developer.
• Utilized jira to execute project deliverables, and maintained timely ticket creation and completion.
• Performed data modeling and mapping utilizing Oracle SQL Developer
• Responsible for loading, extracting and validation of client data.
• Created a Big Data pamphlet for unified data manipulations.
• Project Management, Requirements Analysis Software development lifecycle, full lifecycle documentation, database.
• Converting to a physical data model depending upon the database being used.
• Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Design dimensional model for warehouse data.
• Implement the data model for development.
• Working with clients to understand their data migration needs and determine any data gaps.
• Utilized VBA scripts to help work continuity.
• Design project plans and teams to deliver on-time, on-budget and on-scope results within risk tolerances without undue project management overhead.
• Created and analyzed all the phases of the project management processes.
• Audit files and metadata entries for completion and proper organization.
• Created metadata reports using MS Excel.

IT Specialist -Marketing

Confidential, Anaheim California

Responsibilities:

• Specialized in creating dynamic digital and print campaigns.
• Utilized Excel to aggregate regional sales data and performed intranet data transfers.
• Maintained clear concise communication between vendors and stakeholders.
• Clear and timely documentation of all key updates.
• Created, updated and presented marketing collateral that includes technical presentations, data sheets, case studies, requirements gathering, use cases.
• Created demonstrations that highlight the key values of the product so as to aid in better market penetration of new technologies and features.
• Regional research that included and featured comparisons, bench marking, demonstration set up and development, as well as provided guidance on enhancing the features and fixing the bugs.
• Involved in supporting the outbound activities like customer and field engagements by scheduling technical workshops, doing product demonstration and implementing the virtualization solutions.
• Created outbound materials by liaising with the product management team as well as engineering team to produce implementation guides, product guides, white papers, and competitive papers.
• Developed data collection methods and data analysis.
• Utilized VBA macros in Excel.
• Organized and managed several tasks with varying deadlines, in order to launch products in varying regions.
• Developed presentations with accuracy and detailed explanations to adequately service deliverables.
• Analyzed and resolved key stakeholder complaints while working diligently with team members to ensure campaign success.