Data Analyst Security Clearance
Resume:
DATA ANALYST (Active Security Clearance)
GLORIA N. E. N. ARKO
************@*******.***
PROFILE
An IT professional with over Nine years’ experience in various domains such as Healthcare, Insurance, and Finance. An enthusiastic individual with extensive experience in Business Continuity ensuring business recovery solutions are implemented and tested periodically. Data Analysis, Data Manipulation, Data Extraction, Research and Reporting in different formats and from various sources. Cyber Security. Thorough working knowledge of ISO – 22301, NIST 800-34 Rev 1, and 800-30 Rev 1. HIPAA policies, procedures and certification. Proven ability to learn, utilize in-house databases and systems to maintain strategic vision of the organization and link it with everyday work. Able to perform multiple duties in business continuity and analysis, program management, and functional leadership. A wonderful team player who can relate and work efficiently with diverse groups.
SKILLS
●Excellent knowledge and usage of reporting tools such as Microsoft, Tableau, Power BI, and SAS EG.
●Experience in Data Munging (data scrubbing and cleansing).
●Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.
●Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
●Accomplished reduction in recovery time objective (RTOs), recovery point objectives (RPOs), and Business impact analysis (BIAs).
●Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
●Good knowledge of NIST, HIPAA regulations. Healthcare terminologies.
●Self-motivated individual with strong communication skills, great attention to details, ability to work under pressure and frequent update and exposure to new technologies and new business lines.
●Exceptional organizational and time management skills and the ability to work independently.
●Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.
TECHNICAL SKILLS
Business Intelligence tools
Tableau Desktop, MicroStrategy, Excel and PowerPivot, Power BI, SSRS
Querying language
SQL, PL/SQL, TSQL, PYTHON, LINUX, SAS, JAVA
Querying tools
SQL Management Studio, SQL Plus, SQL Developer, PL/SQL
ETL/Other Tools
SSIS, Tableau Prep, SAS Base, SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant
Databases
MS SQL Server, Teradata, MySQL, Oracle, DB2, MS-Access, Oracle
Operating Systems
Win XP, Vista 7, Windows Server, Unix
Cloud Computing Tools
Snowflake, AWS QuickSight, RedShift, SageMaker, Jupiter Notebook, MS Azure, Tableau Server
SDLC
Agile (Jira) and Waterfall, Confluence, Smartsheet, PowerPoint, SharePoint
Operating Systems
Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Mac OS
PROFESSIONAL EXPERIENCE
Inova Health System, Fairfax, VA - System Data Analyst
Jan 2020 – July 2024
●Developed applications utilizing Power BI, Power Apps, Power Automate, and SharePoint to streamline operations and improve data accessibility.
●Utilized strong troubleshooting skills to identify and resolve issues with Power BI dashboards, Power Apps, and SharePoint lists.
●Collaborated with customers in translating user stories and requirements into functional code using Power Apps.
●Identified critical dependencies and gaps, solved technical challenges, and implemented new enhancements using Power Automate.
●Defined and developed methods for robust system monitoring and troubleshooting using Power BI and SharePoint.
●Engaged with stakeholders on prototyping using Power Apps to demonstrate the art of the possible and find creative solutions for complex business use cases.
●Followed all best practices for version control and development management of Power Apps and Power BI dashboards.
●Collaborated with medical, clinical staff leadership, and colleagues to determine information needs and understand requirements for applications and/or reports.
●Maintained the confidentiality of information acquired pertaining to patients, physicians, employees, and visitors to the Health System.
●Generated Key Performance Indicators (KPIs) for customer satisfaction and patient feedback details.
●Created SQL queries and scripts to extract and aggregate data to validate the accuracy of the data. Carried out data extraction and data manipulation using SQL as per business requirements.
●Reviewed business requirements and analyzed data sources from Flat files, Excel, SQL Server for design, development, and analysis projects within Tableau Desktop.
●Participated in meetings, task groups, teams, reviews, and other environments to assist in collaborative solutions.
Commodity Futures Trading Commission, Washington, DC - Embedded Data Analyst (Six Months DoD Contract)
June 2022 – December 2022
●Applied advanced statistical methods and data manipulation techniques using SAS Enterprise Guide, Python, and Excel for comprehensive data analysis on financial transactions and market trends, ensuring compliance with regulatory standards at the Commodity Futures Trading Commission (CFTC).
●Implemented data quality checks and streamlined reporting processes, enhancing accuracy and efficiency in the submission of regulatory reports within tight deadlines, leveraging tools such as SAS Enterprise Guide, Python, and Excel.
●Worked closely with cross-functional teams, including legal and compliance, interpreting and applying regulatory guidelines to data analysis processes at CFTC, integrating AWS QuickSight, SageMaker, and Redshift for seamless data integration and analysis.
●Prepared detailed reports and documentation on market activities, providing clear and concise insights for regulatory purposes, and facilitated communication between technical and non-technical stakeholders, utilizing SAS Enterprise Guide, Python, AWS, Redshift, and Excel for a comprehensive and integrated analytical approach.
●Collaborated with various departments with integration of business continuity requirements into the design phase of new services creating a proactive approach to risk management. Implemented a business continuity management system certified by ISO 22301 standards, highlighting the company’s commitment to operational excellence.
Citizens Bank, San Diego, California - Data Analyst / BI Developer
June 2019 – March 2021
●Used data visualization tools like Tableau and Power BI to provide an easy-to-understand interface for end users to quickly identify key themes within their Data.
●Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
●Revamped the emergency communication plan, incorporating modern technologies to ensure efficient and reliable messaging among stakeholders during a crisis.
●Created complex reports like Detail level Transaction report, monthly Aging, YTD cash goal Reports, Quarterly reports by creating multiple queries.
●Developed and maintained financial reports to clearly communicate actual results, forecasted performance, and variances to plan, forecast and budget.
●Developed dynamic reports, dashboards, and key performance indicators aligned with business strategies and initiatives. Standardized reporting capabilities that track operational performance in real-time with both aggregated and drill down functionality. Workflows and automated manual tasks using SSIS to load the data from sources such as Relational tables, Flat files, Oracle tables, Excel, PDF into the target Data warehouse.
●Efficiently retrieve data using SQL to facilitate financial results and project analysis. Hands on experience to extract, manipulate and built complex formulas in Tableau for various business calculations.
●Developed leading routines and data extracts with SSIS, SAS and SQL procedures.
Inova Health System, Sterling, VA - IT Command Center System Analyst
April 2017 – June 2019
●Develop knowledge of critical business processes and related application interactions and document workarounds that quickly restore IT service. Resolve IT service events incidents, escalated by following up, execute, and maintain active major incident updates to resolve application incidents.
●Ability to navigate through monitoring dashboards interface such as SolarWinds various servers, network devices for outages, hardware failures and power outages. Ensemble dashboard to monitor firewalls, routers, switches, and software to analyze interface backlogged applications issues.
●Engage with appropriate teams such as, engineers, vendors, and stakeholders for assistance to assess severity and scope of events incidents to prioritize resolution in resolving issues found. Grant access to vendors, and personnel though the data center in restricted areas and monitored video surveillance systems located at data centers.
●Communicate essential information directly to employee devices in real time, across desktop, mobile devices, and digital screens via SnapComms. Contribute to the creation and maintenance of standard operating procedures and knowledge articles used by the entire Inova enterprise.
● Assist the Enterprise Service Desk with processing their self-service queue in Service Now by creating new incidents, service requests and RCA tasks. Update and revert OGM (Outgoing Message), Inova Connect dashboard with planned, unplanned system outages and downtime.
HCA/Parallon Reston Hospital, VA - Business Continuity Specialist PRN September 2015 - May 2017
●Managed updates to business continuity documentation to reflect changes in technology and procedures, keeping the company compliant with evolving regulations.
●Designed and facilitated business continuity training programs for over 1000+ employees, significantly enhancing the organization’s recovery capabilities.
●Conducted thorough post-incident analyses for multiple events, each time providing actionable recommendations that strengthened the overall resilience of the organization.
●Assisted with the assessment and mitigation of risks related to IT infrastructure, enhancing subsystem availability, and reducing possible financial losses.
●Established an incident management framework that expedited the response to unforeseen events, noticeably decreasing downtime during critical business periods.
●Implemented a cloud-based solution for critical data backups, which proved instrumental in swift recovery from a significant data breach.
APEX SYSTEM INC, Austin, TX - Information Security Analyst
Jan 2012 – August 2015
●Conducts security assessment and IT security documentation to determine the security posture of the system in line with NIST Risk Management framework and associated federal governance and policies.
●Review and develops IT Risk Cyber security programs, policies and procedure using industry framework (PCI, SOX, HIPPA, NIST)
●Work with business units and third parties to evaluate the risk of vendor relations and perform risk assessments on third parties.
●Used GRC tools to effectively manage user provisioning to guide against violations (SOD) and least privileges.
●Provided ERP audit remediation to resolve segregation of duties violation (SOD) in end user roles, password reset, and validity date extensions upon approvals for users.
●Resolves complex problems requiring detailed knowledge of ERP security configuration and development.
●Identify, analyze, and monitor IT control gaps and perform the documentation, implementation, and testing of the entire IT security control compliance across VA.
●Gathered and reviewed artifacts to develop Authorization packages (SSP, SAR, and POA&MS) for information systems to be granted ATO.
●Reviewed and assessed (PIA) and privacy control in compliance with Privacy Impact Assessment (PIA) and Privacy Threshold Analysis (PTA) using NIST 800-53.
●Conducted Information System Contingency Plan (ISCP) to tabletop exercise annually in line with business Continuity Plan (BCP)
EDUCATION
BSc Business Management and Administration
-University of Cape Coast - Ghana
Associate: Information System Management
-Grossmont College California
CERTIFICATIONS
●CompTIA – Security+
●CompTIA – Cloud+ (CSCP)
●Skill Front – ISO/IEC 27001 Information Security Associate
●Skill Front – ISO/IEC 27001 Information Security Internal Auditor
●Skill Front – ISO/IEC 27001 Information Security Executive
●NIST – Risk Management Framework for System and Organizations
●International Scrum Institute – Certified Scrum Master
●Management and Strategy Institute – IT Certified Ethics Associate
●Management and Strategy Institute – HIPAA Certified Professional
●Management and Strategy Institute – Agile Project Management Fundamentals
Contact this candidate