Salman Mohammed

● Created comprehensive and highly detailed functional requirement documents (FRDs), business requirement documents (BRDs), and system requirement specifications (SRSs) to guide project execution
● Collaborated with ServiceNow HRSD technology teams and business users to identify requirements, resulting efficiency and productivity within the HR department
● Collaborated effectively with onshore and offshore teams as well as clients to ensure clear communication and alignment
● Conducted thorough business analysis to evaluate the client's operations, identifying opportunities for improvement
● Developed complex SQL queries to extract and analyze data from multiple databases
● Developed Test plan, Test cases and Test data and validated all test cases are documented
● Developed comprehensive test plans for 5 complex projects, ensuring thorough testing coverage and reducing post-release bugs by 30%.
● harmonization workshops & requirement gathering sessions to review the scope & prepare SRS
● Monitored progress, resolved problems and reported regularly to IT management and stakeholders.
● Promoted business improvements through alternative service delivery approaches.
● Worked as a part of scrum team, in Agile methodology with sprint cycle, daily stand ups and story implementation, large cross functional project and support team.
● Build platform features, user stories, and maintain the backlog with priorities using Jira platform.
● Extensively worked on EDW Teradata performance optimization and brought down the queries to seconds or minutes from spool out and never-ending queries by using various Teradata optimization strategies.
● Collaborated in identification of work processes, standards, and instructions.
● Created data mapping document verification and validation (both Source – Target and Target – Source data validation)
● Reviewed functional and design specifications to ensure full understanding of individual deliverables. Used tool Python to data clean and visualize data to make better decisions for project implementation.
● Performed Sanity, End to End, Regression and User Acceptance Testing (UAT).
● Ensured data structure and integrity.
● Ensured all error handling processes perform as expected.
● Experienced performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
● Documented test execution results and updated the status of the testing activities

Experienced in documenting business and functional requirements in the form of BRDs, FRDs, and SRSs, among other formats, with high technical detail to assist project execution.
Data cleaning, Data Manipulation experienced with scripting and programming language Python.
Worked as a part of scrum team, in Agile methodology with sprint cycle, daily stand ups and story implementation, large cross functional project and support team.
Build platform features, user stories, and maintain the backlog with priorities using Jira platform.
Extensively worked on Teradata performance optimization and brought down the queries to seconds or minutes from spool out and never-ending queries by using various Teradata optimization strategies.
Collaborated in identification of work processes, standards, and instructions.
ETL verification and validation (both Source – Target and Target – Source data validation)
Ensure data structure and integrity.
Ensure all error handling processes perform as expected.
Experienced performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Managed different business-related problems by giving predictive/prescriptive insights deploying different kind of models.
Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries

Understood business requirements from client and translated it to appropriate Analytics use cases.
Build in depth analyses, translate the analyses into marketing digestible insights, presenting business opportunities for strategic action, while using analysis and data to support concepts.
System analysis and design techniques, such as database normalization, business analysis, workflow procedure, modular programming, stored procedures, and interface with an operating system.
Handled Missing values and replaced missing values, Imputation, and variable generation.
Experienced in conducting analysis on large and complex datasets using SAS and Power BI.
Developed work orders and project plans.
Troubleshoot client and reported application issues.
Investigated and analyzed the root cause of the reported issues and provided issue resolution to the clients.
Installed the VM’s and configured DHCP, DNS, VPN and Active directory.
Assessed support inquiries to identify whether issues were system or user related.
Collaborated in identification of work processes, standards, and instructions.
Prepared reports for the Wages and Working Conditions Committees

Data cleaning, Data Manipulation, Data Visualization experienced with scripting and programming language Python.
Extensively worked on Teradata performance optimization and brought down the queries to seconds or minutes from spool out and never-ending queries by using various Teradata optimization strategies.
Experienced in identifying, analyzing, and interpreting trends and forecasts and recommending improvements.
Understand predictive models, supervised and unsupervised learning, data mining, and machine learning concepts and use cases.
Feature selection and cross-validation by KNN and K-means clustering models, data exploration by training and test samples.
Heat map analysis and OLS summary sheets for validating data correlations.
Successfully imported packages such as Numpy, Pandas to work with Data frames and Matplolib for data visualization process and imported packages and Libraries such as CSV, Mat plot for data preprocessing and data visualization.
Analysis of datasets by application of different Data mining and advanced statistical modeling, Machine Learning Techniques using Python programming including Scikit-learn, Pre-processing, Ensembling, etc.
Used Teradata Profiler to analyze data.
Excellent working experience in SQL (Teradata, MS-SQL).
Optimized high volume tables in Teradata using various join index techniques, secondary indexes, join strategies.
Developed and modified SSIS packages to support an enterprise data ETL environment.
Implemented business rules on data using Stored Procedures, Functions, and Packages.
Created new Tables, integrity constraints (Primary Key/Foreign Key) in SQL.
Verified multi-source data consolidation to brand new target platform and EDW integration using SQL scripting for: ETL verification and validation (both Source – Target and Target – Source data validation), Ensure data structure and integrity, Ensure all error handling processes perform as expected, BI data validations.
Experienced performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Managed different business-related problems by giving predictive/prescriptive insights deploying different kind of models.

Reviewed prepared and executed test cases for the testing of a national provider of claims management solutions applications to ensure business requirements and standards are achieved.
Reviewed functional and design specifications to ensure full understanding of individual deliverables.
Performed Smoke and Sanity, Functional Testing, System Integration Testing, End to End, Regression and User Acceptance Testing (UAT).
Experienced of SQL and Excel, programming Python.
Analyzed and modified Test Cases and executed them.
Developed application software in COBOL.
Also extensively involved in Testing COBOL, VSAM, CICS and DB2 applications and has clear concepts of Testing Methodologies.
Extensively worked with Mainframe technologies COBOL, JCL, VSAM, DB2, CICS, CDS AND PUTTY.
Strong experience in JCL, SQL, DB2, FILE-AID, QMF, SPUFI, Cobol, MVS, VSAM, TSO, ISPF, CICS, and QA Testing.
Discussed the project timeline with the Project Manager for updating the Test Plan Timelines.
Used JIRA to log defects, track and generate defect reports and graph.
Interacted with BA and Development Team for creating Functional Test plan.
Developed Test cases and Test data and validated all test cases are documented & can be audited.
Document test execution results and updates the status of the testing activities on a daily basis.

Understand business requirement from client and translate it to appropriate Analytics use cases.
Retail Execution – Inventory Management/Supply Chain, CRM, Sales, and Operation, Procurement.
Systems analysis and design techniques, such as database normalization, business analysis, workflow procedure, modular programming, stored procedures, and interface with an operating system.
Developed work orders and project plans.
Collaborated with other analysts, marketing managers, and engineers on both strategic initiatives and ongoing data infrastructure enhancement projects.
Experience in deploying Hadoop cluster on public and private cloud environments like: Amazon AWS.
Verified multi-source data consolidation to brand new target platform and EDW integration using SQL scripting for FTP we have used tool ETL.
Developed and modified SSIS/SSRS packages to support an enterprise data ETL environment.
Strong working experience with Terra data and Peta data.
Expert at all Microsoft Office applications, particularly Excel and Power point.
ETL verification and validation (both Source – Target and Target – Source data validation).
Ensure data structure and integrity.
Analysis of Logistic and Linear Regression Relationship by Data Mining.
Performed Big Data Analyst Hadoop HQL (Hive Query Language).
Handled the real-time dataset by establishing a connection between FileZilla, Putty, HDFS and Virtual Machine using Hive in Linux Operating System and Microsoft Azure platform.
Constantly reviewed and enhanced reporting / analysis to improved clarity and presentation.
Developed new and/or adhoc reporting to respond research inquiries and on-going monitoring.
Support Product Development process through analysis and implementation stages.
Conducted market research on products, markets, customers, prospects and suppliers as part of business reviews and analysis.
Data Analysis and Data Mining and External Data Enhancement.
Data cleaning, Data Manipulation, Data Visualization using Power BI and SAS.