Prateek Mittal Email & Phone Number

Noida, Up, In

Noida, Uttar Pradesh, India

•Working on Upliftment of Data Governance for a Banking Client.•Governing the iRISK Attributes as per APRA.•Lead the Team on Technical and Business Metadata Creation.•Identification of Atomic, Underlying and Derived CDE's •Data Remediation for the governed terms to get the correct DQ Rules Status•Uplifting the Data Governance Catalogues by updating the referencing Policies and DQ rules. •Creating Design of Informatica Mappings from Data Governance Point of View.

India

Working for Travel and Transportation client as Datastage Offfshore Lead for Application Managing Freight Management and Package Exception Reports. Supporting 24 hours PROD Support and Change Requests.Migrating Windows Server based Application to Azure using ADF ,Azure SQL Message Queues , AZ Copy and jenkins for CI - CD pipeline.Converting SQL Server Proc's to ADF, Modelling the database with key relationshios that are missing.Successfully migrated Oracle Database to Exadata.Done Process improvement resulting in reduction of Application Completion time by 2 hours.Performance improvement of Datastage Jobs.File Purge Automation

Pune

- Responsible for Datastage end to end solution for client fund reporting using Datastage and SSIS.- Weekly reporting for performance and progress of BI solution to onshore client senior manager.- Provided much needed improvement ideas to previously developed solutions to make them more oriented towards business requirement with small code.

Gurgaon, India

- Performed Installation and migration of IBM WebSphere Data stage Enterprise Edition/PX on UNIX platforms. Experience migrating between 7.5 and 8.5. - Analysed existing Infrastructure of Data Stage jobs, ensured best practices are being followed, and recommended short term and long term improvement roadmap .- Maintain ownership of release activities which interact with ETL projects. Work with Prod Support to maintain and administer the ETL deployment environment.- Developed modules on Talend and Cassandra for an e-commerce client ingesting data for an e commerce site.- Comprehensive development for a banking client converting information into knowledge that provides a systematic process for Loans processing.- Support the production environment 24 * 7 for an e commerce client.- Implemented procedures for maintenance, monitoring, backup, and recovery operations for the ETL environment.- Reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs. - Infrastructure optimisation, troubleshooting, and debugging.

Gurgaon, India

- Worked exclusively for Telecommunication and Retail clients developing solutions to help them in there Future insights.- Worked directly with clients to support their requirements and changed needed on adhoc basis for the smooth operation of client.- Ownership and responsibility of Production Systems through Incident & Problem Management. Proactively monitor applications to ensure that incidents can be identified and resolved.- worked proactively with client to generate reports on utilization of telecom resources with Datastage and Cognos

B.Tech., Electronics And Communication

Activities and Societies: Robotonics, Genero-10

High School, Mathematics And Computer Science