Pradeep Kumar Email & Phone Number

Jaipur, Rj, In

Jaipur, Rajasthan, India

Role & Responsibilities:➢ Involve in pre-sales with customers and suggest the best solution according to customer requirements, data volume, data frequency, data source and data platform.➢ Served as a subject matter expert (SME) for an application. Coordinated with cross functions teams for requirement gathering, understanding business applications, data flow and data relations.➢ Mostly serving in BFSI domain engagement, Good knowledge of core banking systems, loan management systems, regulatory frameworks, credit bureau systems and how to manage ad-hoc requirements in BFSI.➢ Creating scalable and efficient data architecture with industry regulation with data security, data governance and data quality. Considering storage, computing, data processing and cost-effectiveness factors. ➢ Creation of data model development and data warehouses using MS Azure, AWS & Databricks platform technology.➢ Implementing the medallion architecture and creating the Raw, Silver and Golden data layers in the Data Warehouse & Data Lake.➢ Creating the Logical and Physical Data Model, Using the Star Schema and creating the Fact and Dimension model with the SCD and UpSert requirements. ➢ Creating the Data tables, SQL Procedures and Reporting tables in the database.➢ Creating the ETL data pipelines for seamless integration from different data sources and data transforms to load the incremental data in the data warehouse and data lake. ➢ Implement the organization’s historical data migration and implement the data retention and data governance policy.➢ Implement Row-level security on the data to stop data leakage and misuse. ➢ Working cross-functionally with Global Operations leads Engineering and Support teams to efficiently investigate and resolve data quality bugs.➢ Worked in an Agile Environment for New Developments with comprehensive analysis of all case scenarios & sample data for E2E testing of data lineage & data flow from source to target for achieving desired output.

Jaipur Area, India

1. Create Stories and Backlog refinements.2. Implementing Agile Scrum framework.3. Sync with management and development team.4. Creating the Logical and Physical Data Model, Using the Star Schema and creating the Fact and Dimension model with the SCD and UpSert requirements. 5. Creating the Data tables, SQL Procedures and Reporting tables in the database.6. Implement Row-level security on the data to stop data leakage and misuse. 7.. Maintaining Software Releasing and version plans8. Data visualization and Dashboard presentation. 9. Client's orientation and communication.10. Managing stakeholder expectations and facilitating discussions across high-risk and complexity or under and constrained timescales.

Jaipur Area, India

Jaipur Area, India

1. Dataware house for TV channel2 MIS SSRS Reports for Management3. SSIS Services for Data transfer--------------------------------------------------------------------• Developing the structure of data warehouse for Jewelry TV channels• Developing, implementing ETL transformations and processes for building data warehouse for Jewelry TV channels •Designed database model and sql scripts for ETL processes•Implemented optimization for improving performance.•Data extractions from Log Files source to build up a data warehouse in SQL Server for analyzing and reporting purpose. •Constructed the business logic in ETL by creating SSIS and Packages for ETL.•Successfully deployment in live environment •SQL Reporting from data warehouse for management

Projects for Jewelry manufacturing