Mohammed S. Email & Phone Number

• Consulted with application development business analysts to translate business requirements into data design requirements used for driving innovative data designs that meet business objectives.• Involved in information-gathering meetings and JAD sessions to gather business requirements, deliver business requirements document and preliminary logical data model.• Performed requirements gathering and design analysis for customer contact history for customer relationship management.• Worked as business requirements analysts with subject matter experts to identify and understand requirements.• Supported data warehouse projects with logical and physical data modeling in Oracle environment and assured accurate delivery of DDL to the development teams.• Documented the data requirements and system changes into detailed functional specifications. Took ownership of Source to Target Mapping and tracked and maintained changes.• Performed Extraction, Transformation and Loading (ETL) using Informatica power center.• Designed and implemented data pro ling and data quality improvement solution to analyze, match, cleanse, and consolidate data before loading into data warehouse.• Extensively used Erwin to design Logical, Physical Data Models, and Relational database and to perform forward/reverse engineering.• Responsible for designing new FACT or Dimension Tables to existing Models.• Experienced in building Automation Regressing Scripts for validation of ETL process between multiple databases like Oracle, SQL Server, Hive, and Mongo DB using Python.• Implemented stored procedures, functions, views, triggers, packages in PL/SQL.

• Created and analyzed business requirements to compose functional and implementable technical data solutions.• Delivered Working Widget Software using EXTJS4, HTML5, RESTFUL Web services, JSON Store, Linux, HADOOP, ZOOKEEPER, NO SQL databases, JAVA, SPRING Security, JBOSS Application Server for Big Data analytics.• Identified integration impact, data owes and data stewardship.• Created new data constraints and leveraged existing constraints for reuse.• Created data dictionary, Data mapping for ETL and application support, DFD, ERD, mapping documents, metadata, DDL and DML as required.• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time• Scheduled tech SSIS jobs using JAMS, Windows Scheduler, Tasks on Snowflake and SQL server• Anticipated JAD sessions as primary modeler in expanding existing DB and developing new ones. Evaluated and enhanced current data models to re etc. business requirements.• Generated, wrote, and ran SQL script to implement the DB changes including table update, addition or update of indexes, creation of views and store procedures.• Performed end-to-end implementation assessment of various AWS services like Amazon EMR, Redshift, S3, Athena, Glue, and Kinesis• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.• Developed the logical data models and physical data models that confine existing condition/potential status data fundamentals and data flows using ER-Studio• Ensured that the logical model is compliant with the conceptual model and all the Consolidated and updated various data models through reverse and forward engineering.• Compared different WFHM DB environments and determined, resolved, and documented discrepancies.• Help build ETL data pipelines using SSIS, AWS Glue and Python to migrate data from traditional data warehouses (SQL) to Redshift, Aurora and Snowflake..

• Responsible for envisioning and architecting the enterprise-level Identity and Access Management Infrastructure initiative, addressing the need for compliance with the HIPAA regulations pertaining to security and privacy of patient health information.• Reviewed EDI companion guides for all payers to ensure compliance, edit integrity and maintain up-to-date list of payer contacts.• Document and communicate changes throughout the user organization, supporting Information System Change Management (ISCM) and compliance.• Created Dashboard in Power BI using different visualization.• Managing SSAS cube for different analysis.• Creating and updating SSIS packages for different logic.• Prepared and created analytic reports on customer insights such as user geographic location, age groups, and gender using Microsoft Excel (advanced), Word, and PowerPoint.• Test data using Power pivot, VLOOKUP and different excel formula.• Managed data quality and data governance processes, ensuring data accuracy and completeness.• Collaborated with cross-functional teams to develop and implement data-driven solutions to business challenges.• Removing corrupted or wrong data from the database.• Performing quality analysis on the data• Developing and managing databases.• Creating database systems and processes for data management.• Filtering data basis requirements from various stakeholders.