Harsh Jain Email & Phone Number

San Francisco, Ca, Us

San Francisco, Ca, Us

Bellevue, Washington, Us

Palo Alto, California, Us

* Built ETL flows using SQL, Python and Airflow to transform and combine datasets into a dimensional model persisted in Google Bigquery and built reports and dashboard for various stakeholders across the company* Worked with Growth/Marketing to improve customer retention by designing and setting up various cashback and reward campaigns.* Worked with the Compliance team to suggest KYC improvements - reduce cost and increase conversion* Built dashboards for Product Managers to measure adoption of various banking features like savings, ACH, cash deposit, ATM withdrawal, etc.* Deep dive in various data sets and recommend proposals to improve operational efficiency like reducing cost of card cancellations, subscriptions, etc.

San Francisco, California, Us

* Built data pipelines using Python to extract data from various sources like RDS, DynamoDB, S3 and orchestrating pipelines using Airflow.* Built reports and visualizations in Looker for various stakeholders in the company like customer success, product managers, compliance and legal analysts.* Built dimensional models in Snowflake for self service analytics

Dayton, Ohio, Us

Client: Diamond Hill Capital (Investment Management Firm) Aug 2015 - Present•Built the company’s first data warehouse that involved multiple subject areas by integrating data from multiple sources to provide an enterprise level view of security information.•Gathered requirements from the client and built data models based on data vault architecture.•Built an analytical tool using SSAS TABULAR for compliance team to monitor intermediary assets and flows for unusual account activity, minimum initial investment, validate invoice payments and other business analysis.•Created SSRS reports for compliance team to monitor security overrides.•Built fund holding dashboard reports for marketing team to display key fund holding metrics on company’s website.Centric Internal Data and Analytics Platform June 2015 – August 2015•Built a central data warehouse for analytics and reporting needs for the financial advisory committee.•Built ETL packages using SSIS to fetch data from various data sources and integrate the data•Created SSAS BISM models for data exploration and analysis•Created Power BI reports and dashboard for the end user to exhibit KPIs•Set up test framework and automation testing queries for data quality checksClient: Health Integrated Inc. (Healthcare Management Firm)May 2014 – June 2015• Built a data warehouse hosted on Amazon Web Services (AWS) to support reporting and analytics needs•Followed Agile methodology of development for continuous delivery and improvements evolving over time•Developed data quality monitoring checks (SQL queries) to ensure high quality data in the warehouse.•Handled huge volumes of data using performance optimization techniques in SSIS and SQL Server.•Supported TEST and PROD environments to ensure business continuity.•DBA activities like data backup and managing space on the DEV and TEST server.

Bangalore, Karnataka, In

• Worked with onsite team to design LLD from the Physical Data Model given by the client• Created complex Netezza Queries to fetch records from bank's IRR system• Developed many Informatica mappings to parse records from heterogeneous sources like XML, SWIFT messages, Flat Files, etc. Created several UNIX scripts and Autosys jobs• Implemented performance enhancements which meant more historical data could be stored with reduced fetch time, hence generating more revenue for the bank• Worked on coming up with final design for Reporting Layer that was based on Dimension Fact Model• Designed and implemented Disaster Recovery/Data Replication features in the project to avoid data loss in case of system outage or failures, which could potentially save the bank huge losses

Set up a Human Resource Management System that incorporated several HR related functions like Workforce Management, Compensation, Staffing and Learning, etc. It was the biggest human resource migration project in the history of the bank.• Module Lead of a four member team from Pune, India. Responsible for final delivery of the code from offshore• Developed complex Informatica mappings such as implementing SCD2 requirements and worked on PL/SQL procedures• Delivered defect free code, which was imperative since the downstream systems were dependent on ETL for data• Reviewed, unit tested and performance tested the code• Involved in estimates and other pre sales activities like conducting POCs.