Ujjwal Krishna

Experience

• 

  Brillio

  Aug 2011 - Jun 2014

  - Automated ETL processes, making it easier to wrangle data and reducing time by as much as 40%.- Involved in Designing of Database.- Developing SSIS Packages and SSRS Reports.- Development and Maintenance of SharePoint Sites and Workflows.- Worked with Sqoop to transfer data from SQL Server to Hadoop Distributed file system HDFS- Worked with Hive database to create database and then create table to store the files stored in HDFS. Created Map Reduce Program to parse the XML and then store in different derived tables. Show less

  • Senior Software Engineer

    Aug 2013 - Jun 2014

  • Software Engineer

    Aug 2011 - Jul 2013
• 

  JPMorgan Chase & Co.

  Jun 2014 - Oct 2018

  Implemented end-to-end implementation of BI solutions includes ETL design and reports for the business users in SSRS, QlikView.➢ Work closely with our BI team to develop our data infrastructure to provide access to information and expand reporting capabilities.➢ Worked on Creating Data warehouse using Star Schema and define relationship between tables for the Client Service Team.➢ Created a tool (Client Issue Detection) for the Business to analyze and take informed decision which resulted in saving ~30 Hrs. weekly➢ Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved indexcreation, removal, modification, file group modifications and adding scheduled jobs to re-index and update statistics in databases.➢ Worked on Hadoop Infrastructure. Show less ➢ Responsible for the integration of operational and financial data from various upstream transactional systems➢ Worked on visualization for teams Client Service, KYC, and Client Onboarding team to stream the process and reducing manual efforts.➢ Worked on ETL Development and followed best practices of data management and data governance.➢ Worked on data dictionary and creating metadata information.➢ Worked on implementing a new data architecture for the Client Onboarding team to act as historical data store➢ The process helped reduce the TAT to 3 hours daily.➢ Provided Training sessions and organized tech sessions to help the team members to upskill. Show less

  • Associate

    Apr 2016 - Oct 2018

  • Team Lead

    Jun 2014 - Apr 2016
• 

  Anheuser-Busch InBev

  Nov 2018 - Mar 2019

  Specialist

  NOCC (Network of capability center also called as Shared service center) Transformation basically works on creating the Business Efficiencies and dollar savings by following different strategies. These strategies help to implement a proper inflow and outflow of the FTE from different Business Units to NOCC, NoCC Center to different NoCC Center and by creating efficiencies in the NOCC itself. Based on these strategies target is made for the entire year and month on month reporting are done to check how close we are to achieve these targets. Responsibilities:1. Understanding the business process, for the NOCC Transformation team.2. Analysis of the requirement provided by the clients and transforming them in to functional and technical specification.3. Develop, refine and scale data management and analytics procedures, systems, workflows, and best practices4. Automation of different Excel reports in the Qlikview to have a proper view of the data which must be analyzed.5. Responsible for maintaining quality reference data in SQL by performing operations such as cleaning, transformation and ensuring Integrity in a relational environmentInvolved in Development and Testing of Data. Show less

• 

  Quotient Technology Inc.

  Mar 2019 - Dec 2021

  Quotient is the leading CPG marketing technology ecosystem that delivers data-powered, personalized, frictionless digital promotions and ads that inspire action and deliver results.Quotient offers digital coupons, including online printable, social, mobile and loyalty card promotions.Leveraging our proprietary Promotions, Media, Audience, and Analytics Cloud platforms, together with an unparalleled network of retail partners,we power digital marketing programs for over 2,000 CPG brands. We operate a leading digital coupon distribution network – powered by Coupons.com, manage a leading CPG retail media platform, and have developed a premium audience CPG data management platform. Our Analytics platform measures campaign performance and powersoptimization that leads to better marketing program results.- Works closely with project manager to develop work plan for Data Warehouse projects and keep the manager aware of any issues- Building Data Pipelines to pull data from Snowflake to Relational Database System.- Develop framework, metrics and reporting to ensure progress can be measured, evaluated and improved.- Perform in-depth analysis of Coupon Data for the purpose of identifying opportunities, developing proposals and recommendations for use by management.- Extensively involved in writing SQL queries- Created the entire ETL flow for the data flow from various sources to SQL.- Worked on NoSQL – MongoDB for storing semi structured data and performed different CRUD operations. Show less

  • Lead Data Engineer

    Mar 2021 - Dec 2021

  • Senior Data Engineer

    Mar 2019 - Mar 2021
• 

  Koch Industries

  Dec 2021 - Jun 2023

  BI Tech Leader

  Koch Industries, Inc. is an American privately-held corporation based in Wichita, Kansas. Its subsidiaries are involved in the manufacturing, refining, and distribution of petroleum, chemicals, energy, pulp and paper, chemical technology equipment, ranching, finance, commodities trading, and investing.Expertise: BI, Reporting, Data Engineering, Cloud, Stakeholder Managements, Hiring, Mentoring and Coaching.• Leadership: Part of leadership teams collaborating with various business stakeholders for Profitability, Inventory, Operations, and OTIF (On-Time-In-Full) business metrics• Responsible for technical development, leadership and architecture that include storage, modelling, ETL design, development, technical support, capacity planning and security.• Achieved 20% improvement in operational efficiency by leading a process automation initiative that reduced manual efforts and streamlined workflows, resulting in annual cost savings of $500,000.• Spearheaded the successful migration of legacy reporting systems to a modern data analytics platform, reducing report generation time by 50% and improving data accuracy by 15%.• Led a team in implementing a comprehensive Business Intelligence solution, resulting in a 30% reduction in report creation time and enhancing data visualization capabilities for different stakeholders.• Collaborated with cross-functional business stakeholders to develop and implement a profitability analytics framework, enabling real-time visibility into margin analysis and contributing to a 10% increase in overall company profitability.• Mentored and coached a team of BI/Data engineers, resulting in a 40% increase in productivity and a 25% reduction in project delivery time.• Design and develop complex data solutions such as data warehouse, server configurations, reporting and dashboards, data migrations, ETLs and OLAP/OLTP sTeystems for various customers and domain.• Document Technical Requirements Show less

• 

  JPMorganChase

  Jul 2023 - now

  Key Responsibilities:Development of a comprehensive data strategy and roadmap to transition data ingestion, transformation, and consumption pipelines, ensuring alignment with organizational goals.Architect and Implement scalable, automated ETL/ELT pipelines leveraging Databricks features, including Delta Lake, to optimize data integration, transformation, and storage.Design consumer-centric data models and workflows to support product teams in executing data-driven strategies and enhancing analytical capabilities.Lead the migration of legacy data systems to Databricks, ensuring minimal downtime, robust data quality, and seamless integration across diverse data sources.Collaborate cross-functionally with product teams and business stakeholders to align data solutions with evolving business needs.Ensure compliance with data governance and security standards, implementing role-based access controls, encryption, and audit trails.Establish monitoring frameworks to ensure the reliability and performance of data pipelines, optimizing for cost efficiency and scalability. Show less Key Responsibilities and Achievements:Analytical Framework Development: Designed and implemented robust analytical frameworks tailored to the unique risk landscape of the International Consumer Business Banking LOB. These frameworks enable proactive identification and mitigation of credit and fraud risks, contributing to a reduction in fraudulent activities and an improvement in credit risk assessment accuracy.Reactive and Proactive Analysis: Led a high-performing team in conducting comprehensive reactive and proactive analyses to uncover hidden insights within complex datasets. Through deep dives and advanced analytics, delivered actionable recommendations to optimize risk management strategies, resulting in increase in efficiency and effectiveness.Strategic Insights Delivery: Collaborated closely with business stakeholders to deliver strategic insights derived from data analysis. Provided actionable recommendations to enhance risk mitigation tactics, streamline processes, and drive business growth. Notably, contributed to the development of new products and services aligned with risk appetite and regulatory requirements.Performance Metrics Tracking: Established robust performance metrics to track the effectiveness of risk management strategies and initiatives. Regularly monitored key performance indicators (KPIs) such as risk exposure, fraud loss rates, and portfolio quality metrics. Cross-Functional Collaboration: Fostered strong partnerships across cross-functional teams including Data Engineering, Technology, and Business Operations. Coordinated efforts to integrate advanced analytics solutions into operational workflows, driving efficiencies and enhancing risk mitigation capabilities.Continuous Improvement Initiatives: Championed a culture of continuous improvement by implementing process enhancements and leveraging emerging technologies. Show less

  • Vice President - Data Architect

    Dec 2024 - now

  • Vice President - ICB Data & Analytics

    Jul 2023 - Dec 2024
• 

  JPMorganChase

  -

  Vice President - Data Architect