Data Analyst Power Bi

Vincent Anany

Gaithersburg, MD ************@*****.*** 240-***-****

PROFESSIONAL SUMMARY

Detail-focused Data Analyst with 14 plus years IT experience in data warehousing, process validation and business needs analysis. Proven to understand customer requirements gathering and translate into actionable project plans. Dedicated and hard-working with passion for Big Data with vast knowledge in BigFix, window Linux, severs and SDLC for datasets testing and products management in various agencies, by using MSSQL Server, Oracle DBA, SSIS Visual Studio, SCCM, Window, HCL-BigFix,Tenable, Splunk & Nessus for data process validation, data warehousing, and business needs analysis. Maintain and provide data analysis utilizing Power BI, SQL scripts, Python, Excel, ETL, AWS, Python, Kubernetes, Docker to develop data initiatives to improve profitability, accountability and decision-making that contribute to the success of the organization. Very detail-oriented with excellent problem solving, and committed to delivering high-quality, accurate results. Excellent verbal and written communication skills enthusiastic team player with strong initiative and quick learner with ability to work collaboratively in a fast-paced environment.

SECURITY CLEARANCES

Public Trust

SKILL SUMMARY:

MSSQL Server & SSIS Visual Studio

PowerBI, SQL scripts & Python,

HCL-BigFix,Tenable, & Nessus,

Splunk, Microsoft SCCM administrator

HCL-Bigfix Fixlet Development

HCL-WEB Report/JIRA, Splunk

Server/Desktop Patch Management

Windows, Linux Red Hat & Unix

Oracle Database 11g&12C

Software Packaging, Configuaration

Vulnerability security management

Remedy Ticket Management

Desktop Support / Risk management

SOP document development

Project Management/ Documentation

RF/Wireless AP design placement

Hardware troubleshooting

AWS, Kubernetes, Docker

SDLC/Application design Deployment

Supervisory Experience of 6 to 10 person team.

EXPERIENCE

Department of Labor (Peraton Corp) Washington, DC

HCL-BigFix Engineer/Data Engineer (March 2018 to Present)

Directly responsible for the global management of the BigFix consulting contract for Department of Labor

Analyze data in MSSQL Server environment using complex SQL scripts for BigFix deployments have been upwards of 23K+ endpoint devices at DOL to enure clean data initiatives, accountability and availability.

Perform data transformation functions through SQL, BigFix, SSIS Visual Studio, Power BI by importing and exporting data from the MSSQL Server, HCL-BigFix, Tenable, Nessus, Splunk, AWS, excel and or other sources, leveraging SQL for data migration and pivoting aggregate extract from to support data engineering.

Deploying server, desktop patches and track vulnerability remediation for DOL BigFix Lifecycle Patching.

Perform ETL (Extract Transform Load) to Migrate Data from source to destination using SSIS in Visual Studio.

Using the schema compare functionality in SSIS to migrate Database object from Dev to QA,UAT and PROD environments and Create complex SQL queries to aggregate and extract data from Relational Database systems.

Create and maintain clear compelling visualizations (charts, graphs, dashboards) to communicate findings to non-technical stakeholders and managers.

Manage IT Infrastructure operations for the Service Desk, End User Computing, Asset Management, as well as Infrastructure Support for Engineering and Operations.

Design and manage data systems, coordinate various data sources, collect descriptive facts for existing

data and document data systems provided by the State or created as part of this project.

Provide data cleaning and interpret system development life cycles, project management approaches and requirements, design and testing techniques.

Provide data modelling and design, including software development and database management.

Ensures all hardware are within compliance of the common operating environment, identifying and re mediating discrepancies and Document processes and current projects by creating Business Requirements Documents.

Provides information and data utilized for asset reporting include data analysis and quantitative and qualitative assessment for patching vulnerabilities management.

Completes overall patch/release management as well as ensures all packages are deployed efficiently and as transparently as possible and create KPIs to track performance across projects using PowerBI.

Identifies, manages, and monitors for vulnerabilities that may affect compliance requirements and change management procedures.

Troubleshoots related issues for users and performs problem resolution regarding related service requests

Provide subject matter expertise on issues and tasks related to remote distribution of HCL-BigFix dataset.

BigFix DOL Project Type Highlights:

Data Analysis, Compliance, Lifecycle.

Patch Management, Vulnerability management.

Department of Labor (Booz Allen Hamilton) Washington, DC

HCL- BigFix Engineer (November 2015 to March 2018)

Acted as primary BigFix Administrator for distributed enterprise utilizing IBM BigFix for inventory, compliance, patch management and software distribution on a daily basis for all operational and network administration.

Utilized HCL- BigFix to develop custom software distribution packages to ensure silent software installs for end users and, provide data analysis with partner both internal and external stakeholders, including actuaries, program managers, and data scientists and data engineers to identify challenges and provide data insights.

Performed data mapping for the process and compiled and reviewed organization charts to meet requirements/developed and executed automated test case scripts Test for the Front-end applications.

Utilizing IBM BigFix Security Compliance & created custom STIGs to ensure sites were audit compliant with federal, state and agency regulatory as well as reporting functions against corporate policies.

Developed datasets migration plan from network file shares to MSSQL Server,Tenable, Nessus, Splunk, BigFix Software distribution library, organizing software packages and distributions utilizing Gold Image libraries and Ad-hoc package offers based on AD categorization of job function.

Assisted with the identification of production business processes, documented process, identified risk and issues, formulated solutions and wrote Standard Operating Procedures (SOPs) for triage and training of computer based access into Mainframe and custom Bantec software systems, including custom user manuals and engineering troubleshooting/maintanined SOPs.

Set up new workstations by utilizing IBM BigFix OS Deployment with software and patch management baselines and created custom audit reports utilizing BigFix SOAP and REST reporting tools.

Maintained Windows 2008/12 Windows server farm utilizing patch management and OS support services within BigFix and performed troubleshooting for hardware and software issues as Level III support technician.

Performed troubleshooting for network issues related to windows based server functions and connectivity issues.

Accenture Federal Services Arlington-VA

Data/Security Analyst (June 2015 – November 2015)

Monitor and Support the cyber security and network security compliance of assigned subsidiary divisions

Design and manage data systems, coordinate various data sources, collect descriptive facts for existing data and document data systems provided by the State or created as part of this project

Provide data cleaning and interpret system development life cycles, project management approaches and requirements, design and testing techniques.

Provide data modelling and design, including software development and database management.

Conduct remediation actions when malicious emails are identified by applying the appropriate blocks within the network and identifying infected assets while coordinating remediation.

Provides Measure non-compliant aspects, formulate remediate efforts, create remediation plan and measure progress to reaching goal.

Work with key stakeholders, management, and project teams to formulate goals, standards, processes, and policies to assist with compliance management.

Utilize security tools such as IBM QRadar, Source Fire, and Fire Eye to identify potential threats or comprises. Create informative and accurate Incident Response reports, open BMC remedy tickets and desktop support

Works with senior IT engineering staff to ensure that proper operation and performance of customer products and/or services are appropriate and operating as intended and to troubleshoot and fix as required.

Conduct security research on latest IT security threats such phishing emails or campaigns and malwares.

Deploys target software manually and reviews for issues or problems during deployment on VM images, such as additional software or updates required.

HCR ManorCare Silver Spring, MD

Oracle DBA(June 2014 – June, 2015)

Provides database security measure for the end-users by, auditing, granting and revoking access. Assist in developing strategies backup and recovery for hot and cold backup NetBackup. Provided logical and physical backups and database recovery by using RMAN and OEM.

Provides 24x7 operational support for production databases on a rotating schedule. Managed data retention policies including archiving, and backup and performs data migration from one database to Oracle 11g to Oracle 12c.

Performed installation, Patching and upgrading for security, consistency and availability. Provide database security measure for the users by, Auditing, granting and revoking access. Assist in developing strategies backup and recovery for hot and cold backup NetBackup.

Performed Performance Tuning by using AWR/ASH, ADDM, explain Plan, Vmstat to gather statistics. Assist and monitored RAC and Data guard performance with Grid Control & OEM for high availability.

Adventist HealthCare assigned to CIGNA, Inc. Supporting - CMS Rockville, MD

Oracle DBA(December, 2009 – June, 2014)

Provided Backup and Recovery for the Oracle E-Business Suite to ensure consistency and availability. Acted as a Service Oriented Architecture (SOA) technologies and Subject Matter Expert (SME) for Oracle database related issues and services.

Assisted in installation, Patching and upgrading for security, consistency and availability. Provide data analysis report for service to team and resource management.

Provided Performance Tuning by use AWR, ASH, ADDM, Explain Plan, and Vmstat Provides trend

analysis for service management team to enable them to make informed decisions regarding resource management. Managed backup and recovery of the environments.

Maintained Data and provided experts ICD 9 to ICD10 ETL Modification. Recommendations strategies for Oracle compliances to improve database architecture, and database stability to ensure high performance and availability.

Maintained Oracle Data Guard & Standby Database and provides critical solutions for database security and disaster recovery with Data Grid Control. Perform capacity planning; identify the server hardware. Developed stored database procedures, packages, and triggers using PL/SQL.

Provided expertise in Data modeling by Using UML, Visio & to create Entities diagram, use case diagrams and sequence diagrams to define business requirements. Collected and analyzed business requirements from Stakeholders and End-users to ensure specifications. Actively participated in planning, architecture, implementing, patching, maintaining and upgrading. Maintained excellent support for data security.

EDUCATION

Master of Science: Health System Management - University of Baltimore - May, 2014, Baltimore

BS of Health Economic Information – University of Birmingham - November, 2009, Birmingham, UK

CERTIFICATIONS

Certified- MS-101: Microsoft 365 mobility and security

Oracle Administration 11g Certified Associate (OCA)

Certified Ethical Hacker (CEH)

CompTIA Security + Certified

Activities and Honors

DOL - Customer Services - Certificate of Achievement Washington, DC

Contact this candidate