Prashant R Email & Phone Number

Arkansas, United States

• Having total 13 plus years of experience in Software and Information technology industry as Data Architect and Data Engineer in Data Management Area with industries like, Banking, Cosmetics, Food Chain, Safety & Compliance and Supply Chain & Logistics and SAP Basis Administrator in SAP Technology.• Extensive experience in gathering business requirements, documentation, development, testing, production support from clients through joint requirement sessions for functional and non-functional requirements.• Extensive experience in disciplined software development life cycle (SDLC) process familiar with Agile, Waterfall and ASAP methodologies.• Experience on Migrating SQL database to Azure Data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and controlling and granting database access and Migrating On premise databases to Azure Data Lake store using Azure Data factory.• Experience in Developing Spark applications using Spark - SQL in Databricks for data extraction, transformation, and aggregation from multiple le formats for analyzing & transforming the data to uncover insights into the customer usage patterns.• Extensive experience in transactional (OLTP) and dimensional (OLAP) data modeling from creating conceptual, logical, and physical data models for various database platforms like DB2, Oracle, and SQL Server as per business/applications needs while maintaining the enterprise standards.• Having good knowledge in database normalization (1NF, 2NF, 3NF) and de-normalization techniques for improved database performance.• Experience in designing of star schema and snowflake schema, for online analytical processing (OLAP) systems.• Evaluating data sources and strong understanding of data warehouse, data mart design, ETL, BI, client/server applications.

Arkansas, United States

• Gathering business requirements, analyzing them, and providing results to the development team.• Analyzing and studying source system, existing models to understand the data of different business units.• Use database normalization methods and performing different normalization techniques (3NF).• Developing, validating, and communicating OLTP & OLAP relational data modeling solutions.• Use ERwin Data Modeler to design data models; publishing the models to Erwin Web Portal tool to view the metadata information about the tables and lineage between the data elements.• Use Erwin Data Modeler to create logical and physical data models for various lines of business based on the approved conceptual models.• Implementing metadata strategy and building metadata repository using Erwin while maintaining business rules, data dictionaries, data transformation rules.• Generating DDL scripts and providing them to the database administrators to physically implement on the database servers; and working with the change requests portal.• Work closely with the group’s change management resources to ensure changes to data management procedures are enabled with the appropriate training and communications support.• Working on data warehouse, database, and operational data storage (ODS), and data marts; creating meta data repository of various data elements in the data warehouse and data marts.

Illinois, United States

• Participated in requirement gathering to understand and document the business requirements in alignment to the financial goals of the company.• Worked on Data Availability audit and recommendations for multiple data sources.• Worked on Invalid email identification, Email domain survey, and cleanup in Marketo and Microsoft CRM Dynamics.• Worked on Data Cleansing and Normalization of Country, Region, and Email in Marketo sandbox and production.• Design of enterprise data model for Marketo and Microsoft CRM Dynamics based on requirements.• Worked on automation and data synchronization for both Marketo and Microsoft CRM Dynamics using SSIS, R, and Ad-Hoc Scripts.• Use Power Designer to design data models; publishing the models to Web Portal tool to view the metadata information about the tables and lineage between the data elements.• Prepared scripts to ensure proper data access, manipulation, and reporting functions with R programming languages.• Formulated procedures for integration of R programming plans with data sources and delivery systems.• Design of STAR schema model for the CRM Leads and CRM Opportunities based on updated requirements for Microsoft CRM Dynamics.• Built enterprise level Datacube (SSAS Model) for both Marketo and Microsoft CRM Dynamics using SSDT and deployed in analysis server.• Participated in Data cleanup project for Marketo and Microsoft CRM Dynamics data and worked on Data duplication.

Texas, United States

• Participated in requirement gathering with business users to understand and document the business requirements in alignment to the financial goals of the company.• Created the conceptual model for the data warehouse using ERwin data modeling tool.• Designed logical and physical data models using data provisioning and consumption techniques.• Reviewed the logical model with application developers, ETL team, DBAs and testing team to provide information about the data model and business requirements.• Normalized the tables/relationships to arrive at effective relational schemas without any redundancies.• Developed scripts that automated DDL and DML statements used in creations of databases, tables, constraints, and updates.• Designed star schema, snow-flake schema and involved in developing the data warehouse for the database.• Worked on forward engineering to enhance the data structures of the existing database and creating new schemas.• Worked on reverse engineering on the existing data models and updates the data models.• Participated with application developers and DBAs to discuss about various De-normalization, partitioning and indexing schemas for physical model.• Created ETL jobs and custom transfer components to move data from smaller teams to centralized area (SQL Server) to meet minimum capital requirements using SSIS.

California, United States

• Gathered business requirements, interacted with business analysts to finalize requirements.• Translated existing databases into models to understand objects and relations using reverse engineering function.• Performed walkthroughs for conceptual, logical and physical data model for validating designs for the enterprise data warehouse.• Involved with implementing Kimball methodology to design data marts.• Implemented primary key, foreign key constraints using RI (referential integrity).• Used normalization and de-normalization techniques to achieve optimum performance of the database.• Responsible for generating in database scripts using forward engineer.• Identified SCD and categorized them under Type-1 and Type-2.• Involved with data analysis using Teradata SQL assist from data source.• Design the documents which included data flow model in VISIO, data mapping documents, design document which will assist the developer.• Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.• Used Talend ETL tool to move data from Data Warehouse to Data Marts. Also, used to load data from files to staging tables.

Texas, United States

• Requirement gathering from the users by participating in JAD sessions, A series of meetings were conducted with the business system users to gather the requirements for reporting.• Understood basic business analyst’s concepts for logical data modeling, data flow processing and data base design.• Created and design conceptual data models using ERwin data modeler.• Created logical and physical data models for dimensional data modeling using best practices to ensure high data quality and reduced redundancy with the IDW standards and guidelines.• Designed and developed Oracle PL/SQL procedures and UNIX shell scripts for data import/export and data conversions.• Performed legacy application data cleansing, data anomaly resolution and developed cleansing rule sets for ongoing cleansing and data synchronization.• Extensively used star schema methodologies in building and designing the logical data model into dimensional models.• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, transformation and loading strategy designing.• Worked on database design for OLTP and OLAP systems.• Designed a STAR schema for sales data involving shared dimensions (conformed) using ERwin Data Modeler.• Designed and build the OLAP cubes for star schema and snowflake schema using native OLAP service manager.

India

• Providing support by monitoring and administering the SAP servers using the appropriate transaction codes & maintaining the checklists.• Daily SAP system monitoring which includes health checks, maintaining spools, maintaining SAP parameter & buffers and operating system buffers.• Monitoring table locks, background jobs, scheduling background jobs, monitoring database buffers, handling routing of transport requests etc., & notify BASIS team for long running jobs.• Daily, weekly reporting to the client and project documentation.