Sajna Safarath Rowther

Providing guidance to the business in Information Management (IM) and Information Governance (IG) and the execution of an information management strategy defining good information management practices, processes and requirements for the complete lifecycle management of all organizational information assets (business data, master data, reference data, content, integration and analytics

Designed, Implemented and operated comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
Developed data warehouse process models, including sourcing, loading, transformation, and extraction.
Created and implemented metadata processes and frameworks.
Created plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
Created supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
Designed and implemented warehouse database structures.
Developed and implemented data extraction procedures from other systems, such as administration, billing, or claims.
Developed standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
Implemented business rules via stored procedures, middleware, or other technologies.
Developed data mapping documents between source systems, data warehouses, and data marts.
Evaluation of all data and perform various tests on data warehouse and ensure effective implementation.
Instrumental in providing analytical skills with the ability to research, identify and resolve data integration issues.
Ensured compliance to standards and policies related to data.
Coordinated closely with business owners, solution teams and design teams to ensure that solution architectures are fit-for-purpose and adequately meet data requirements
Developed excellent visualizations and dashboards that helped for Decision making.
Manage and continuously improve the design and implementation of Information and Data Architecture processes and artefacts
Understand and advocate information/data architecture and Enterprise Architecture (EA) principles and be prepared to "sell" the information/data architecture process, its outcome and ongoing results
Coordinate closely with technical and Business analysts to ensure EA and business interests are taken into account
Coordinate closely with business data architects to ensure adherence to documented procedures and standards
Responsible for guidance on high level solutions for information/data architecture requirements
Assist, coach and mentor information/data architecture practitioners

Lead projects at various stages from requirements gathering and business rules analysis to creating physical database model, SSIS/SSAS development, BI reporting.
Lead and improvised existing Enterprise Data Warehouse
Instrumental in creating process , procedures, policies and standards for data warehouse implementation
Creating/ Managing the project plan, task allocation, work with stake holders and PMO office for achieving project goals in an agile work environment
Designed architecture for SSIS implementation and cube creation using SSAS
Co-ordinate with business owners, DBAs, reporting team to address system improvements
Managed the project in breaking down the existing EDW to manageable data marts
Mentored individuals from business and technical stand point
Instrumental in creating an in-house tool for meta data and data governance for quality purposes
Responsible for Data Modelling, Architecture, Production support and migration to various Database technologies
Hands on SSIS, SSAS development and production support of around 32 data marts and the Enterprise Data Warehouse, Meta data and Universe creation for reporting
Expertise in BI reporting using Tableau, MS Power BI

Managed all the product development activities from inception and deployed within stringent timelines.
Liaise with business subject matter experts in analysing business requirements (Productivity related – KPIs), understand the various data sources.
Developed standard dashboards and reports based on the stakeholder requirements that lead to decision support.
Worked with Type 1 and 2 dimensions, fact tables, star schema design, Operational Data Store (ODS) and other data warehouse concepts.
Translated business requirements into design and technical specifications for implementation.
Collaborated with business analysts and offshore developers toward the implementation of changes, and worked with Quality Assurance (QA), and change management teams for IT releases to the data warehouse.
Engaged in data analysis, technical design, documenting, coding, unit testing, deployment and maintenance of various data load modules.
Provided technical design overviews for the DW setup, and participated in technical reviews for IT related implementations.
Delivered key support to multiple IT teams and business users, and created and maintained technical and application support documentation.
Extracted data from IT systems created 20 years prior and without referential integrity, overcoming issues with extensive source data analysis as well as agreements on data extraction and usage rules with source system teams by having an interface control document in place.
Provide database architecture and design for all current and future database systems.
Hands-on database management for all data systems, including relational and non-relational database platforms.
Hands-on management of databases, stored procedure/function development, data schema layouts.
Instrumental in performance tuning the database to cater requirements of the clients with standard best practices.

Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.
Work closely with IT and the Business group to understand business reporting requirements and analyse logical model, and develop subject matter expertise in a short time.
Create and design logical and physical data models using ERWIN– identify entity & its relationships and define the project’s informational needs.
Design Source to target mapping as per the requirement of the client and business rules to load the data from ODS to Data Warehouse.
Architect the database schema and implement a relational (for ODS) and dimensional model (star schema).
Review and maintain the schema, its tables, indexes, views and PL/SQL procedures in Oracle 10g.
Developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
Maps sources system data elements to target systems and develops, tests, and supports extraction, transformation and load processes – define mapping, sessions and workflow
Defines and captures metadata and rules associated with ETL processes
Review and analyse database performance, cubes and reports generated using Oracle Discoverer, Crystal Reports, Cognos, OBIEE (based on client requirements)

Providing guidance to the business in Information Management (IM) and Information Governance (IG) and the execution of an information management strategy defining good information management practices, processes and requirements for the complete lifecycle management of all organizational information assets (business data, master data, reference data, content, integration and analytics)

Designed, Implemented and operated comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
Developed data warehouse process models, including sourcing, loading, transformation, and extraction.
Created and implemented metadata processes and frameworks.
Created plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
Created supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
Designed and implemented warehouse database structures.
Developed and implemented data extraction procedures from other systems, such as administration, billing, or claims.
Developed standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
Implemented business rules via stored procedures, middleware, or other technologies.
Developed data mapping documents between source systems, data warehouses, and data marts.
Evaluation of all data and perform various tests on data warehouse and ensure effective implementation.
Instrumental in providing analytical skills with the ability to research, identify and resolve data integration issues.
Ensured compliance to standards and policies related to data.
Coordinated closely with business owners, solution teams and design teams to ensure that solution architectures are fit-for-purpose and adequately meet data requirements.
Developed excellent visualizations and dashboards that helped for Decision making.
Manage and continuously improve the design and implementation of Information and Data Architecture processes and artefacts.
Understand and advocate information/data architecture and Enterprise Architecture (EA) principles and be prepared to 'sell' the information/data architecture process, its outcome and ongoing results.
Coordinate closely with technical and Business analysts to ensure EA and business interests are taken into account.
Coordinate closely with business data architects to ensure adherence to documented procedures and standards.
Responsible for guidance on high level solutions for information/data architecture requirements.
Assist, coach and mentor information/data architecture practitioners.

Lead projects at various stages from requirements gathering and business rules analysis to creating physical database model, SSIS/SSAS development, BI reporting.
Lead and improvised existing Enterprise Data Warehouse.
Instrumental in creating process, procedures, policies and standards for data warehouse implementation.
Creating/ Managing the project plan, task allocation, work with stakeholders and PMO office for achieving project goals in an agile work environment.
Designed architecture for SSIS implementation and cube creation using SSAS.
Co-ordinate with business owners, DBAs, reporting team to address system improvements.
Managed the project in breaking down the existing EDW to manageable data marts.
Mentored individuals from business and technical standpoint.
Instrumental in creating an in-house tool for metadata and data governance for quality purposes.
Responsible for Data Modelling, Architecture, Production support and migration to various Database technologies.
Hands-on SSIS, SSAS development and production support of around 32 data marts and the Enterprise Data Warehouse, Metadata and Universe creation for reporting.
Expertise in BI reporting using Tableau, MS Power BI.

Managed all the product development activities from inception and deployed within stringent timelines.
Liaise with business subject matter experts in analyzing business requirements (Productivity related – KPIs), understand the various data sources.
Developed standard dashboards and reports based on the stakeholder requirements that lead to decision support.
Worked with Type 1 and 2 dimensions, fact tables, star schema design, Operational Data Store (ODS) and other data warehouse concepts.
Translated business requirements into design and technical specifications for implementation.
Collaborated with business analysts and offshore developers toward the implementation of changes, and worked with Quality Assurance (QA), and change management teams for IT releases to the data warehouse.
Engaged in data analysis, technical design, documenting, coding, unit testing, deployment and maintenance of various data load modules.
Provided technical design overviews for the DW setup, and participated in technical reviews for IT related implementations.
Delivered key support to multiple IT teams and business users, and created and maintained technical and application support documentation.
Extracted data from IT systems created 20 years prior and without referential integrity, overcoming issues with extensive source data analysis as well as agreements on data extraction and usage rules with source system teams by having an interface control document in place.
Provide database architecture and design for all current and future database systems.
Hands-on database management for all data systems, including relational and non-relational database platforms.
Hands-on management of databases, stored procedure/function development, data schema layouts.
Instrumental in performance tuning the database to cater requirements of the clients with standard best practices.

Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.
Work closely with IT and the Business group to understand business reporting requirements and analyze logical model, and develop subject matter expertise in a short time.
Create and design logical and physical data models using ERWIN– identify entity & its relationships and define the project’s informational needs. Design Source to target mapping as per the requirement of the client and business rules to load the data from ODS to Data Warehouse.
Architect the database schema and implement a relational (for ODS) and dimensional model (star schema). Review and maintain the schema, its tables, indexes, views and PL/SQL procedures in Oracle 10g.
Developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
Maps sources system data elements to target systems and develops, tests, and supports extraction, transformation and load processes – define mapping, sessions and workflow.
Defines and captures metadata and rules associated with ETL processes.
Review and analyze database performance, cubes and reports generated using Oracle Discoverer, Crystal Reports, Cognos, OBIEE (based on client requirements).

• Providing guidance to the business in Information Management (IM) and Information Governance (IG) and the execution of an information management strategy defining good information management practices, processes and requirements for the complete lifecycle management of all organizational information assets (business data, master data, reference data, content, integration and analytics

• Designed, Implemented and operated comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
• Developed data warehouse process models, including sourcing, loading, transformation, and extraction.
• Created and implemented metadata processes and frameworks.
• Created plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
• Created supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
• Designed and implemented warehouse database structures.
• Developed and implemented data extraction procedures from other systems, such as administration, billing, or claims.
• Developed standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
• Implemented business rules via stored procedures, middleware, or other technologies.
• Developed data mapping documents between source systems, data warehouses, and data marts.
• Evaluation of all data and perform various tests on data warehouse and ensure effective implementation.
• Instrumental in providing analytical skills with the ability to research, identify and resolve data integration issues.
• Ensured compliance to standards and policies related to data.
• Coordinated closely with business owners, solution teams and design teams to ensure that solution architectures are fit-for-purpose and adequately meet data requirements
• Developed excellent visualizations and dashboards that helped for Decision making.
• Manage and continuously improve the design and implementation of Information and Data Architecture processes and artefacts
• Understand and advocate information/data architecture and Enterprise Architecture (EA) principles and be prepared to "sell" the information/data architecture process, its outcome and ongoing results
• Coordinate closely with technical and Business analysts to ensure EA and business interests are taken into account
• Coordinate closely with business data architects to ensure adherence to documented procedures and standards
• Responsible for guidance on high level solutions for information/data architecture requirements
• Assist, coach and mentor information/data architecture practitioners

• Lead projects at various stages from requirements gathering and business rules analysis to creating physical database model, SSIS/SSAS development, BI reporting.
• Lead and improvised existing Enterprise Data Warehouse
• Instrumental in creating process , procedures, policies and standards for data warehouse implementation
• Creating/ Managing the project plan, task allocation, work with stake holders and PMO office for achieving project goals in an agile work environment
• Designed architecture for SSIS implementation and cube creation using SSAS
• Co-ordinate with business owners, DBAs, reporting team to address system improvements
• Managed the project in breaking down the existing EDW to manageable data marts
• Mentored individuals from business and technical stand point
• Instrumental in creating an in-house tool for meta data and data governance for quality purposes
• Responsible for Data Modelling, Architecture, Production support and migration to various Database technologies
• Hands on SSIS, SSAS development and production support of around 32 data marts and the Enterprise Data Warehouse, Meta data and Universe creation for reporting
• Expertise in BI reporting using Tableau, MS Power BI