Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

Terry Masson

Jackson,USA

Summary

Accomplished Lead Database Developer at TeamADeveloper with expertise in SQL development and database design. Proven track record in transforming complex business requirements into actionable solutions, enhancing data integrity and performance. Strong problem-solving abilities and effective communication skills foster collaboration across teams, driving successful project outcomes and optimizing ETL processes.

Overview

14
14
years of professional experience

Work History

Lead Database Developer/Business Analyst

TeamADeveloper
Newark, DE
02.2016 - Current
  • Capture & clarification of business requirements through a range of analysis techniques (data flow diagrams, sequence diagram, case tool analysis, gap analysis and work & process flow diagrams).
  • Involved in creating Business, Functional, Technical Requirements by working with all the stake holders - Business team, Architects and Development team members at onsite & offshore.
  • Involved in conducting meetings for Agile projects requirements sessions with stakeholders and able to articulate and create the requirements in User Story format. Worked with stakeholders, Product Owner for effectively scoping/user stories.
  • Instrumental in developing and implementing Business Continuity and Disaster Recovery (BCP & DRP) Plans for corporate sites.
  • Created company policies and procedures governing corporate security, email and Internet usage, access control, and incident response.
  • Involved with RTP (Risk Treatment Plan) for the region with input from IT security assessments, penetration exercises and audit exercises.
  • Worked on creating business, functional, use cases, technical requirements artifacts.
  • Worked closely with the HR department to define work rules for different types of exempt and non-exempt employees.
  • Involved in understanding business problems and transformed these into EPICs/Feature and User Stories.
  • Involved in creating User Stories, prioritization, iteration / Sprint planning, Release planning, Scrum Retrospective by working with Scrum Master and Project Manager.
  • Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
  • Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from online transaction Processing (OLTP) databases to data warehouse databases and involved in Data cleansing in the data transfer.
  • Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
  • Design, develop and defining schemas of the data warehouse (snowflakes and star schemas) and choosing star schema to increase performance.
  • Created and modified several database objects such as Tables, Views, Indexes, Constraints, Stored procedures, Functions and Triggers using SQL and T-SQL.
  • Generated SQL scripts for creating tables, Views, Primary keys, Indexes, Constraints, Sequences and Synonyms.
  • Provided SQL Server training for developers and development groups.
  • Used majority of the transformations, tasks, containers present in SSIS which include Fuzzy grouping, Derived Column, Conditional Split, Aggregate, Lookup, Row Count, Merge Join, Union All, Multicast, Sort, Copy column, Data conversion and other transformations during development.
  • Developed various operational Drill-through and Drill-down reports using SSRS.
  • Developed different kinds of reports such as Sub Reports and Charts, Matrix reports.

IT Network Security Analyst

TeamADeveloper
Newark, DE
05.2013 - 02.2016
  • Oversaw companywide efforts to identify and evaluate all critical systems.
  • Designed and implemented security processes and procedures and perform cost benefit analysis on all recommended strategies.
  • Collaborated with external auditors to conduct in-depth compliance audits and penetration testing, presenting results to senior management.
  • Develop curricula and facilitate awareness training.
  • Assess the system for risk exposure for threats and vulnerabilities on an Enterprise level.
  • Identify, analyze and develop mitigation guidance for vulnerabilities.
  • Prioritize newly identified vulnerabilities based upon severity, potential operation impacts, exploitation, and mitigation strategies.
  • Understand, review and interpret scan results.
  • Apply FISMA compliance to determine the effectiveness of implemented security measures and ensure adequacy in the security of business assets.
  • Utilize NIST SP 800 series to identify threats and vulnerabilities and recommend pertinent security controls to mitigate the occurrence of future threats and vulnerabilities imposed on a business' network.
  • Provided expertise on technical services including all aspects of information security.
  • Conduct IT risk assessments to identify system threats.
  • Assessed system design and security posture as well as advising information security compliance with FISMA and NIST SP 800-53 controls.
  • Conducted security control assessments to assess the adequacy of management, operation privacy, and technical security controls implemented.
  • Performed maintenance and advanced configuration of systems in order to protect systems from emerging cyber threats.
  • Conducted forensic traffic logs analysis to isolate issues and respond to analyst alerts.
  • Business Impact Analysis (BIA) to analyze mission-critical business functions, and identify and quantify the impact if these are lost (e.g., operational, financial). BIA helped to define the company's business continuity plan and IT internal control audit objective.

Database and Security Analyst

TeamADeveloper
Newark, DE
07.2011 - 04.2013
  • Provided remote and on-site support including Tier-III support for LAN/WAN products.
  • Provided project leadership to business delivery infrastructure; ensuring commercial excellence, cost, schedule, and scope requirements are met and provided coaching and mentoring to service desk teams in the area of about 3,000 IT users.
  • PHARMACY MANAGEMENT SYSTEM – The main aim of the project is the management of the database of the pharmaceutical shop. This is done by creating a database of the available medicines in the shop. The database is then connected to the main program by using interconnection of the c# program and the database already created. The management system is used can generate reports, as per the user's requirements. The software can print invoices, bills, receipts etc. It can also maintain the record of supplies sent in by the supplier.
  • EMPLOYEE JOB SCHEDULING AND PROGRESSION TRACKING SYSTEM - The system function is to track employee hourly progression and day-to-day operations.
  • Code, debug, document and install new programs and make changes to existing programs/technologies.
  • Perform maintenance and develop documentation for all developed programs.
  • Write structured application/interface code from specifications conforming to established methodology and standards.
  • Provide first-line problem resolution or escalation, as well as technical assistance.
  • Analyze end user needs and developing customer oriented solutions which interface with existing applications.
  • Develop, implement and maintain application software to established standards and specifications.
  • Work in cooperation with technical support to prepare application software procedures and documentation for usage, operation, back-up and recovery, problem resolution, shut-down and initialization and process automation.
  • Liaise with end users to test application software, ensuring accuracy, integrity, interoperability and completeness to achieve desired results.
  • Used various report items like tables, sub report and charts to develop the reports in SSRS and upload into Report Manager.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from large number of tables.
  • Performed the six steps of the Risk Management Frame work for compliance with FISMA.
  • Reviewed Security Artifacts: SSP, SAP, SAR, CPT, PTA, PIA, PII, POAM & ATO for compliance.
  • Coordinated meetings with other stakeholders, drafting agenda and preparing reports.
  • Lead Security awareness and training programs to educate employees on important security measures to be used in order to enhance the Confidentiality, Integrity and Availability of the system.
  • Performed continuous monitoring on Information systems using NIST SP 800-137.
  • Reviewed and updated System Security Plan (SSP) using NIST SP 800-18 rev1, NIST SP 800-53a rev4 and NIST SP 800-53.
  • Developed Contingency plans, Disaster Recovery Plans and Incident Response plan for Information Systems using NIST SP 800 - 34.
  • Taking part in self-assessment of systems using the 2016 FISMA Metrics questions as yardstick for quarterly FISMA compliance scorecards.
  • Ensured Information Systems are compliant to NIST Standards by ensuring Controls are put in place using Security Test and Evaluation Templates (ST&E) and POA&M.
  • Creating ATO package documents; SSP, SAR and POAM based on the security assessment.
  • Involved in Creation of tables, indexes, sequences, constraints and created stored procedures and triggers, which were used to implement business rules.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
  • Extensively involved in SQL joins, sub queries, tracing and performance tuning for better running of queries.
  • Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.
  • Designed and created different ETL packages using SSIS and transfer data from heterogeneous database different files format Oracle, SQL Server, and Flat File to SQL server destination.

Senior Business Intelligence & Architect

DataSev
Newark, DE
  • Analyst patient’s data and communicate with business to understand the journey to recovery, and all levels of care including medically-monitored detox, inpatient care, outpatient care with in-person and telehealth options, and outpatient care inclusive of medications for addiction treatment.
  • Gathers business intelligence from a variety of sources including company data, industry and field reports, public information, or purchased sources.
  • Compiles business intelligence or trends to support actionable recommendations.
  • Maintains current knowledge of industry and business trends through communication with professional organizations, suppliers, customers, competitors, and other informed individuals.
  • Summarizes financial and economic data reports for review by executives, managers, clients, and stakeholders.
  • Assesses market strategies by analyzing related products, markets, or trends.
  • Uses business intelligence data and tools to identify and monitor current and potential customers.
  • Identifies markets for future product development and methods to improve sales of existing products by analyzing technology trends.
  • Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
  • Querying, creating stored procedures and writing complex queries and T-ETL Joins to address various reporting operations and random data requests.
  • Technology: Qlik View/Sense, Power BI, SSRS, SSIS, Erwin, Visio, ASP.NET C#, SSRS, SSIS, SQL Server 2016/2014, Visio, Visual Studio .NET, Management Studio, Sales Force

Senior Software Engineer

Comcast/ Effectv
, Remote
  • Implement Data Solutions that maximizes engagement between advertisers and their audiences by creating campaigns that reach them at the right place and time, by targeting advertisers’ audiences across linear TV, streaming, and video on demand.
  • Communicating with business users to develop data migration process and other user interfaces that drive business value and efficiently and effectively leverage the use of data.
  • Provided input to technical solutions in architecture meetings determining project scope, tasks, timeframe, resources to provide project estimates for the business analyst and Manager.
  • Creating packages to Extract, Transform and Load data using ETL Server Integration Services (SSIS) into premise databases data warehouse and Amazon S3, Redshift to facilitate reporting operations.
  • Involved in developing, enhancing the browser-based applications using ASP.NET, C#.
  • Creating and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
  • Validates results by testing programs, ensures operation by training client personnel; providing support, and provides reference by writing documentation.
  • Identifying options for potential solutions and assessing them for both technical and business suitability.
  • Involve with production support tickets and various problem resolutions, debugging and optimization of SQL queries and stored procedures, including connectivity, code efficiency and communication issues.

Education

Master's of Science - Homeland Security

Wilmington University
New Castle, DE
12.2017

Bachelor of Science - Organizational Management

Wilmington University
New Castle, DE
05.2016

Skills

  • Database design
  • SQL development
  • ETL processes
  • Data analysis
  • Stored procedures
  • Business requirements
  • Problem solving
  • Effective communication
  • Team collaboration
  • Writing queries
  • Data migration planning
  • Database development
  • Relational database management
  • Microsoft SQL
  • Business continuity
  • Project management
  • Application development
  • Data migration
  • Documentation
  • ETL development
  • Cloud database services
  • Database analysis
  • Implementing security measures
  • Python
  • PL and SQL development
  • Excellent communication
  • Microsoft powershell
  • Information systems management

References

References available upon request.

Timeline

Lead Database Developer/Business Analyst

TeamADeveloper
02.2016 - Current

IT Network Security Analyst

TeamADeveloper
05.2013 - 02.2016

Database and Security Analyst

TeamADeveloper
07.2011 - 04.2013

Senior Business Intelligence & Architect

DataSev

Senior Software Engineer

Comcast/ Effectv

Master's of Science - Homeland Security

Wilmington University

Bachelor of Science - Organizational Management

Wilmington University

Similar Profiles

  • Joshua Kirchmeier

    Joshua KirchmeierJoshua Kirchmeier

    Manager – Internal Audit at Blue Cross Blue Shield of MichiganManager – Internal Audit at Blue Cross Blue Shield of Michigan

  • Kenyatta Wade

    Kenyatta WadeKenyatta Wade

    Truck Driver/Asst at Baton Rouge CargoTruck Driver/Asst at Baton Rouge Cargo

  • Jaylen Bonney

    Jaylen BonneyJaylen Bonney

    Custodial Support at Enviro-CleanCustodial Support at Enviro-Clean

  • Logan Halbert

    Logan HalbertLogan Halbert

    Marketing and Sales Representative at Home InsteadMarketing and Sales Representative at Home Instead

  • Ubaid Mehraj

    Ubaid MehrajUbaid Mehraj

    Software Developer/Engineer, Network Administrator, Systems Administrator, Database Administrator (DBA), IT Security Analyst, DevOps Engineer, IT Support Specialist, Executive Assistant, Administrative Assistant, Paralegal Assistant, Office Clerk, Admin Coordinator, Office Manager, Program Manager, Business Analyst, System Analyst at Think Next Private LTDSoftware Developer/Engineer, Network Administrator, Systems Administrator, Database Administrator (DBA), IT Security Analyst, DevOps Engineer, IT Support Specialist, Executive Assistant, Administrative Assistant, Paralegal Assistant, Office Clerk, Admin Coordinator, Office Manager, Program Manager, Business Analyst, System Analyst at Think Next Private LTD

CREATE PROFILE
Terry Masson