Pragya Jha

About Pragya Jha

With over 10 years of experience as a Business Intelligence Consultant, I have successfully delivered data solutions that enable data-driven decision making and business performance improvement. Currently, I am working with Slalom, a leading consulting firm that helps clients solve complex business problems and achieve their goals. My core competencies include: Project Planning and Execution: I lead and manage critical data projects, overseeing data conversion and reporting processes, from conception to implementation. I orchestrate the end-to-end migration from legacy systems to modern cloud applications, ensuring project milestones are met on time and within budget. Business Intelligence: I collaborate closely with stakeholders to understand their business needs and provide expert consultancy, translating requirements into innovative tools, techniques, metrics, and visually engaging dashboards. I foster data-driven decision making by delivering actionable insights and facilitating effective data visualization. Innovation: I utilize open source and digital technologies to extract valuable insights from complex, voluminous, and diverse data sources and platforms. I develop and implement cutting-edge data solutions, tools, and capabilities to drive self-service frameworks for data consumers. I continuously explore and adapt to new technologies, effectively leveraging them to advance various initiatives. Data Management: I champion the principles of data quality management, ensuring adherence to best practices for metadata, lineage, and business definitions. I collaborate seamlessly with cross-functional teams, particularly tech teams, to implement robust security mechanisms and data access governance. I build and execute monitoring and reporting tools to uphold data quality standards. My mission is to help clients transform their data into a strategic asset that empowers them to achieve their desired outcomes. I am passionate about solving complex data challenges and creating value for the clients and the organization. I am always eager to learn new skills and expand my domain expertise. Skills - BI Tools: Tableau, MS Excel, Power BI, Quicksight, Looker Programming: SQL, Python Data Warehousing: ETL, SSIS, SSRS Database: Oracle, MySQL, SQL Server, Postgres Data Analytics: Statistical Analysis, Data Mining AWS: Redshift, Aurora, DocumentDB NoSQL: MongoDB

Experience

1. Data Analytics Business Intelligence Consultant

   Slalom

   Jul 2018 — Present · Houston, TX, US

   Led AWS data lake Analytics and Data Architecture, converting 500+ TB legacy data seamlessly and boosting processing speed by 40%. Orchestrated end-to-end migration to modern cloud app using AWS Aurora MySQL, DocumentDB, Python, SSIS, and GitHub. Integrated 1B+ records, reducing processing time by 50%, optimizing workflows, and building efficient pipelines with AWS Redshift and PostgreSQL. Collaborated across teams, implementing impactful BI tools, fostering collaborations, and driving a 25% rise in data-driven decisions. Ingested Oracle data to Azure Data Lake, optimizing SQL Data Warehouse for 60% faster query performance. Enhanced system efficiency for advanced analytics and ML by seamlessly processing large data volumes. Designed procedures, views, and reports, implementing robust data quality checks to improve accuracy and anomaly reduction by 70%.

Education

• Vellore Institute of Technology

  Bachelor of Technology - BTech, Electrical and Electronics Engineering, 3.73

  2006 — 2010

• Texas A&M University - Mays Business School

  Master's degree, Management Information Systems, General, 3.9

  2016 — 2018