Paramjit Singh Email & Phone Number

Phoenix, Arizona, United States

- Design and develop robust data architectures and data pipelines to support data ingestion, processing, storage, and retrieval. - Evaluate and select appropriate technologies, frameworks, and tools to build scalable and reliable data infrastructure. - Optimize data engineering systems and processes to handle large-scale data sets efficiently. - Design solutions that can scale horizontally and vertically. - Collaborate with cross-functional teams, such as data scientists, software engineers, and business stakeholders, to understand data requirements and deliver solutions that meet business needs. - Effectively communicate complex technical concepts to non-technical stakeholders. - Optimize data engineering systems and processes to handle large-scale data sets efficiently. - Enforce data governance policies and practices to maintain data integrity, security, and compliance with relevant regulations. - Collaborate with data governance and security teams to implement robust data protection mechanisms and access controls. - Provide mentorship and guidance to the data engineering team, fostering a culture of continuous learning and innovation. - Contribute to hiring and training efforts to build a skilled and motivated data engineering workforce.

Phoenix, Arizona

Sole point of contact for design, implementation and problem solving across machine learning based products; managing devOps and channel partners; building a productive offshore team of 10+ from ground-up, managing performance, and heading a team of 15+ vendor resources; showcasing and marketing team accomplishments to senior leaders, projects included…Fingerprint: Workload Optimization:Enterprise Customer Graph: ADAPT: Global Servicing Data Warehouse: Hadoop Dynamic Queue Allocation: Global Commercial Payments: BigBatch: Where’s my Data?: Quick ETL: Nucleus: xFeed: See projects section for more details…• Championed the adoption of DevOps practices in Big data lake with 1-click delivery pipelines; applying machine learning and data driven solutions for observability and ensuring effective cluster resource utilization to optimize E2E data pipeline execution from 96 hours to 17 hours• Partnered with product and engineering teams to implement end-to-end Data and ETL strategy for Global Servicing Data Lake, integrating data from 40+ operational systems, ensuring data governance, observability, GDPR, PCI compliance, scalability, fault tolerance and efficient querying capabilities• Engineered model governance and compliance strategy for 50+ marketing personalization ML models, ensuring regulatory adherence (PCI-DSS, GDPR), mitigating data privacy and security risks, and establishing transparent model reporting, fostering responsible utilization of customer data• Innovated self-serve capabilities and contributed to the community through open source on 3 projectsSee projects section for more details…

Gurgaon, India

Responsible for supporting and optimizing World Service Data Warehouse (WSDW) which integrates information from various operational systems into a centralized data repository with capability to serve the analytical, reporting, and decision-making needs of the World Service business organizationLead design and implementation of scalable and optimized solution for complex MIS for Global Dispute Management process of American Express.Recognition : Built an innovative tool to automate generic build activities for Informatica ETL processes that enables to decrease time-to-market, standardize the process and achieve huge cost avoidance.The tool is capable to automatically build the Informatica code (mapping/sessions/workflow) as per the user defined template in few clicks.

Gurgaon, India

Headed a team of 4 on solution design for batch optimization and visualization for the RBS Risk Platform, an application owned by Group Credit Risk & Finance, which provides the Aggregation, Calculation, Reporting and Analysis facilities for Basel 2. Led efforts to update the application to meet Basel 2 Advanced qualification requirements, and demonstrate the use of internally derived rating models for risk grading and scoring• Led a team of 15 on technical solutioning, liaising with business users to gather and define business requirements and obtaining sign-off from business stakeholders• Designed logical and physical data model of the Basel 2 solution, incorporating novel entities, attributes, dimensions and facts in the data warehousing environment using dimensional as well as ER modeling• Delivered professional guidance concerning strategic and tactical planning of Master Data Management• Designed ETL strategy, incorporating functional and non-functional requirements such observability, reliability, fault tolerance, partition management, data lifecycle and error handling frameworks• Managed end-to-end development, deployment, and execution encompassing build and quality assurance• ClearCase Integrator for the project, bringing together substance, product, organization and referential data for all technical and functional trackers raised by UAT and business users

Gurgaon, India

Led a team of 4 on batch optimization and visualization for RBS Risk Platform which calculate risk weight of all company assets to calculate business risk which processed and stored data in a warehouse to enable business report generation aggregation and analysis facilities for Basel 2• Optimized Informatica workflows using variety of techniques like pipeline partitioning, parallel session processing, source SQL query tuning, lookup optimization, indexing and pushdown optimization• Reduced runtime of some workflows by over 70%, highly appreciated by peers• Built and deployed complex business logics using Informatica, Oracle stored procedures to load data from disparate sources, to efficiently populate target data warehouse and data marts• Designed innovative automation solutions such as Auto Code and Auto UTP to increase team efficiency

Kansas City, Missouri Area

Contracted to lead small offshore teams (2-5) at GE client premises…Worked on a project to consolidate 600 existing ledgers into one general ledger environment• Liaised directly with business users to gather requirements, analyzed Data Architect's functional specs and translated into technical specs documentation for all mappings• Conducted a comprehensive assessment of source systems for optimal data acquisition strategy• Designed and customized models for data mart, supporting data from multiple sources in real time• Wrote powerful hybrid ETLs using mainframe and Informatica to process several TB data in a few hours• Formulated Cognos powerplay cubes, CQ reports and Impromptu Reports and published to Cognos• Received a Pat-On-Back award for an innovative solution to maintain data hierarchies

Hyderabad Area, India

Played Role of Mainframe Developer and Onsite/Offshore Coordinator with 3 offshore team members to support FINANCE & HR application and GER (Global Expense Reporting) applications for Employee Reinsurance CorporationMy responsibilities included• Analysis, Design and Development using COBOL, RPGII, CICS,VSAM on ZOS and Informatica using DB2 and Oracle• Responsible for overseeing the Quality procedures related to the project. Recognition : Created process to enable self service for "cheque reprint process" leading to reduction of 100+ helpdesk tickets per annum

Master Of Science - Ms, Data Science, 3.97

Bachelor Of Technology (B.Tech.), Electrical, Electronics And Communications Engineering, 73

Activities and Societies: Folk danceElectronics and Communication Engineering

12Th, Physics, Chemistry, Maths, 82

Physics, Chemistry, Maths