Kyle Clark Email & Phone Number

New York, New York, Us

Engineered and managed firewall (Checkpoint, Palo Alto), proxy (Bluecoat), and ACL connectivity within Security Operations to ensure optimal network security and functionality.Developed and maintained comprehensive documentation for network connectivity, ensuring accuracy and accessibility for security teams.Collaborated cross-functionally with internal teams to validate, implement, and document secure network connections in a timely manner.Collaborated with engineering teams to implement firewall connectivity supporting the deployment of Zscaler, Admin POD, Illumio ULM, and AWS solutions, including testing and executing firewall changes via automated scripts to strengthen security infrastructure.Supported the divestiture project of the Mexico operations by ensuring proper connectivity and documentation were in place for the transition.

New York, New York, Us

• Security operation, system support, conversions, and implementation of an enterprise level security application system(s). Enterprise security applications performing administration, implementation, configuration, upgrading and policy creation• Part of team that supports and administers large scale McAfee ePO, Symantec DLP, ForeScout CounterACT, and ArcSight infrastructures.• Investigation, documentation, and resolution of incidents to critical business systems that may be caused by or impacting these systems; escalation of issues to and tracking of progress in conjunction with other Citi technical resource teams; working incidents escalated from the level 1 team, which may include scheduling follow up activities to resolve.

• Maintained database system including monitoring backup process, automated jobs, and system availability.• Designed, documented, and implemented security polices, standards, and protocols. • Tested and installed security patches and service packs to ensure systems are kept up to date.

•Formulated and documented the ETL process design based on business requirements and specifications. Demonstrated strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, and expressions. •Participated in quality control processes such as design reviews, peer code reviews, version control, and documentation.•Created various stored procedures to validate source data and update/insert the records into destination tables.•Created user defined functions to encapsulate frequently and commonly used business logic making the system more modular, secured, and extensible. •Scheduled packages to keep extracting data from OLTP database at specific time intervals.•Completed query optimization and performance tuning of stored procedures using SQL Profiler and Database Engine Tuning Advisor.

•Performed data gathering to populate database for new IT helpdesk system.•Mapped out configuration items of IT infrastructure including business applications, servers, interfaces, and their relationships.•Part of analysis team to figure out what data should be gathered, and develop the metadata.•Created SSIS packages to convert data from the gathered format (Excel) to the destination format (Microsoft SQL Database) and populate the corresponding tables according to the business requirements.•Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements. •Establishing referential integrity, data consistency, indexing, and data cleanup procedures to maintain high quality data that can be used for reporting.