Karan G. Email and Phone Number
I'm a dedicated Data Engineer with over 8 years of experience in transforming raw data into actionable insights. Proficient in ETL processes, SQL, and cloud technologies like AWS, I've successfully developed and maintained data pipelines that have driven process optimization and business growth.I am an opportunistic, hard working, problem solving professional with an experience of more than 8 years as Data Analyst/Engineer and related positions in data domain for different employers, working in varied industries, ready to take on any given challenge and provide the required end results. I am passionate for data and its wide array of applications in improving the overall business. To make sure that I can solve organization problems using data, I have equipped myself with the right set of skills to provide real world solutions to clients.Prior to this I have worked as a CRM Data Analyst at the USF Research and Innovation(NAI) and also held the position of a Graduate Teaching Assistant at the USF MUMA College of Business while pursuing Master's degree.My Master's degree in Business Analytics and Information Systems from the University of South Florida has equipped me with a deep understanding of data-driven strategies and business optimization.SKILLS REPERTOIREDatabase Systems: MS-SQL Server, MySQL, OracleDB, DBeaverCloud: AWSETL: Pentaho, Airflow, AWS GlueCRM: Salesforce, SAPProgramming Skills: R, Python, SQL, PostgreSQL, C#, HTML, CSSAnalytical/BI Tools: MS-Excel, MS-Office, Tableau, Power BI, R-Studio, Apache Airflow, Jupyter Notebook, SAS, SAS Enterprise Miner, AzureML Libraries/Framework: Matplotlib, Numpy, Pandas, Ggplot2, SciPyFunctional Skills: Project Management, Risk Management, Customer Analytics, Process Optimization, Requirement Gathering & Analysis, SDLC, Agile (Scrum), Quality AnalysisExperienced in Business Intelligence, Data Analysis, Project Management, Agile Methodology, Process Optimization.I don't plan on stopping anytime soon and look to continue growing my repertoire so that I can be the best at what I do.Please contact me at:1107karangupta@gmail.com
Jpmorgan Chase & Co.
View- Website:
- jpmorganchase.com
- Employees:
- 286575
-
Product Data OwnerJpmorgan Chase & Co. Jan 2024 - PresentUnited States• Accelerating product development, drive business growth, and improve the Chase customer experience through successfully ensuring that data is clearly documented, of good quality and well protected thereby driving the business innovation faster• Leveraging subject matter expertise and key partnerships to define metadata and classifiers of data critical to business area• Executing processes and procedures to identify, monitor, and mitigate data risks across the data lifecycle in the… Show more • Accelerating product development, drive business growth, and improve the Chase customer experience through successfully ensuring that data is clearly documented, of good quality and well protected thereby driving the business innovation faster• Leveraging subject matter expertise and key partnerships to define metadata and classifiers of data critical to business area• Executing processes and procedures to identify, monitor, and mitigate data risks across the data lifecycle in the business area, including the risk related to data protection, retention and destruction, storage, use, and quality• Developing operational procedures and partnering with data providers and data consumers, including partners in Business, Technology, Analytics, Operations, Risk and Control functions for delivering data in support of their business operations, strategic objectives, advance analytics, and reporting goals• Defining and documenting data requirements of key stakeholders to ensure understanding of data and its use across functions• Partnering and collaborating with technology and business resources to investigate root cause of data issues and provide recommendations for remediation in a timely manner Show less
-
Sr.Data EngineerSt. Jude Children'S Research Hospital - Alsac Jun 2022 - Dec 2023United States• Implemented data migration from SQL Server to SAAS platform named SODA to optimize workflows for further performance tuning resulting in a minimized processing time of the data flow using complex stored procedures• Independently managed sensitive payments and donor data using SQL Server Management Studio, ensuring optimal data quality by performing metrics analysis over the database and indicating KPIs over the Tableau dashboard for analysis• Tracked project progress and deliverables… Show more • Implemented data migration from SQL Server to SAAS platform named SODA to optimize workflows for further performance tuning resulting in a minimized processing time of the data flow using complex stored procedures• Independently managed sensitive payments and donor data using SQL Server Management Studio, ensuring optimal data quality by performing metrics analysis over the database and indicating KPIs over the Tableau dashboard for analysis• Tracked project progress and deliverables along with ticket issues over Jira for timely delivery of the project and future support• Assisted stakeholders in budgeting, marketing, and campaigning decisions; developed and presented consumer insights in interactive dashboards with data sourced from various online marketing platforms using Tableau• Implemented and managed Git repositories over Bitbucket for version control, collaborated with development teams to ensure proper branching strategies, facilitate efficient code integration and code review processes using Visual Studio Code• Collaborated with DevOps engineers to configure and manage Git repositories and CI/CD pipelines using Jenkins, to optimize performance, scalability, and security ensuring efficient and reliable project delivery Show less -
Data Engineer - ConsultantMtx Group Mar 2021 - Apr 2022United States• Acquired, cleaned and structured the COVID related patient data from vaccination sites using SQL scripts for further processing and migrating the data to target applications like Salesforce and AWS by developing maintaining ETL Data Pipelines using Pentaho and AWS architecture for seamless data migration across different infrastructures and to enhance data analysis• Singly scheduled appointments for the vaccination dose using bulk email marketing with the help of SendGrid• Contributed… Show more • Acquired, cleaned and structured the COVID related patient data from vaccination sites using SQL scripts for further processing and migrating the data to target applications like Salesforce and AWS by developing maintaining ETL Data Pipelines using Pentaho and AWS architecture for seamless data migration across different infrastructures and to enhance data analysis• Singly scheduled appointments for the vaccination dose using bulk email marketing with the help of SendGrid• Contributed to Data Model decisions for projects involving data integrations and migrations to different target applications like Salesforce, AWS, SQL Server, maintaining data integrity between systems by building custom integrations using APIs• Developed and maintained ETL Data Pipelines for moving large structured and unstructured data from SQL Server, Flat files, and API sources and load it to Amazon Redshift data warehouse and database clusters to enable efficient analysis of data Show less -
Graduate Teaching AssistantUniversity Of South Florida Muma College Of Business May 2020 - Dec 2020Tampa, Florida, United States• Responsible for creating assignments, exams and grading them for the courses viz. Business Application Development, Enterprise Resource Planning and Decision Process BCDR• Conducted sessions to provide feedback on assignments and projects which significantly improved class performance -
Crm Data AnalystNational Academy Of Inventors Feb 2019 - Dec 2020Tampa, Florida, United States• Solitarily monitored and customized user accounts along with reports and dashboards generation in Salesforce CRM• Analyzed and built detailed client profiles to enhance CRM marketing strategies, create insights and troubleshoot issues• Collected and migrated the entire business data from Excel worksheets to Salesforce using bulk uploads via data loader• Responsible for maintenance of company’s Salesforce.com portal website using Community Builder setup• Provided… Show more • Solitarily monitored and customized user accounts along with reports and dashboards generation in Salesforce CRM• Analyzed and built detailed client profiles to enhance CRM marketing strategies, create insights and troubleshoot issues• Collected and migrated the entire business data from Excel worksheets to Salesforce using bulk uploads via data loader• Responsible for maintenance of company’s Salesforce.com portal website using Community Builder setup• Provided recommendations to the Director by deriving insights from sales and engagement data using predictive analysis along with generating reports and dashboards using Power BI to help improve the customer engagement and revenue• Sole point of contact for all the different departments of the organization in terms of data and report requests by fetching data from custom objects and APIs in Salesforce using SOQL queries over Salesforce Inspector• Integrated Salesforce CRM with third-party applications like Mailchimp and QuickBooks Show less -
Data AnalystKeen Solution Jun 2015 - Nov 2018Indore Area, India• Acquired, cleaned and structured the business data from multiple sources to ensure data quality and presentation• Developed a solid foundation of analytical practices using Python to leverage data for an improved decision making• Built reports and dashboards using Tableau representing key insights, ensured data driven actions to improve the business• Maintained, queried and reviewed databases periodically using MS SQL Server to seek improvements in the business models• Created… Show more • Acquired, cleaned and structured the business data from multiple sources to ensure data quality and presentation• Developed a solid foundation of analytical practices using Python to leverage data for an improved decision making• Built reports and dashboards using Tableau representing key insights, ensured data driven actions to improve the business• Maintained, queried and reviewed databases periodically using MS SQL Server to seek improvements in the business models• Created detailed excel workbooks involving sales, public and demographic data using complex formulas and macros• Identified, communicated, and recommended any data-related issues through querying the databases over the MS SQL Server• Optimized and monitored performance of business to drive more accuracy, better insights and streamlined processes Show less -
Summer InternIndian Institute Of Management, Indore Jul 2016 - Aug 2016Indore -
Summer InternDiaspark Inc May 2016 - Jun 2016Indore Area, India -
InternEicher Trucks And Buses Nov 2015 - Dec 2015Pithumpur
Karan G. Education Details
-
3.64/4 -
Gpa 3.23/4
Frequently Asked Questions about Karan G.
What company does Karan G. work for?
Karan G. works for Jpmorgan Chase & Co.
What is Karan G.'s role at the current company?
Karan G.'s current role is Product and Data at JPMC | Expertise in Data Analysis, Migration and Visualization | Data Governance and Modernization | Business Intelligence Enthusiast | SQL | ETL | Tableau | Salesforce | AWS.
What schools did Karan G. attend?
Karan G. attended University Of South Florida, Shri G S Institute Of Technology & Science.
Who are Karan G.'s colleagues?
Karan G.'s colleagues are Swapna M., Luis Ho, Tsuyoshi Nakai, Natalie Boyadjian, Rishipal Singh, Christian Galante, Neiha Sinha.
Not the Karan G. you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial