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 &.
• 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.
• 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.
• 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.

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.

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.

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.

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.

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.

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.