Data Engineer

• Apr 2022 - Present

Dbt, snowflake, airflow, sfdc, datahub, spark, census, anomalo, etc. Dbt, snowflake, airflow, sfdc, datahub, spark, census, anomalo, etc.

Senior Business Intelligence/ Data Engineer (Sales Analytics)

• Mar 2018 - Apr 2022

Endicia is the leading provider of postage online and shipping software solutions. Responsibilities • Lead a group of 3 business analysts and 2 operation specialists to drive data strategy, automation and pipelining for metric reporting, analysis, planning and quarterly/monthly sales reviews • Report into VP, Sales and work directly with Chief Sales Officer to own and drive the sales data strategy • Developed Sales data strategy to achieve operational efficiency o Built sales… Show more Endicia is the leading provider of postage online and shipping software solutions. Responsibilities • Lead a group of 3 business analysts and 2 operation specialists to drive data strategy, automation and pipelining for metric reporting, analysis, planning and quarterly/monthly sales reviews • Report into VP, Sales and work directly with Chief Sales Officer to own and drive the sales data strategy • Developed Sales data strategy to achieve operational efficiency o Built sales data mart (EIS) single handedly from scratch using Microsoft SSIS (ETL) to consolidate the data from various data sources - transactional systems, Salesforce, external sources, and internal support data which increased the overall operational productivity by 60% o Collaborated with Business Intelligence, DBAs and R&D for data and infrastructure needs o Automated monthly “book of business” process and “account portfolio” creation process to reduce the manual effort by 80% o Partially automated the quotas setting, developed SQL scripts & procedures, analyzed transaction data and dashboard to present and deliver valuable insights using SQL, Python, Salesforce, Tableau and Excel which improved the operational efficiency by 60% o Built various sales reports in Python to automate end to end needs • Developed forecasting models to predict the yearly sales using Scikit and panda libraries • Working on an AI model to detect duplicate account and perform record linkage (entity resolution) • Collaborate with Operations, ASMs, Account managers, Business services and Finance team to identify KPIs and reporting needs to evaluate sales performance • Lead the yearly budgeting and planning process to set goals for the next fiscal year which are shared with the CEO. • Perform cohort analysis, pricing analysis, product analysis, revenue share analysis, prospecting, pipeline, compensation, commissions, channel analysis, QBR and monthly sales review to evaluate the overall health of the sales organization Show less Endicia is the leading provider of postage online and shipping software solutions. Responsibilities • Lead a group of 3 business analysts and 2 operation specialists to drive data strategy, automation and pipelining for metric reporting, analysis, planning and quarterly/monthly sales reviews • Report into VP, Sales and work directly with Chief Sales Officer to own and drive the sales data strategy • Developed Sales data strategy to achieve operational efficiency o Built sales… Show more Endicia is the leading provider of postage online and shipping software solutions. Responsibilities • Lead a group of 3 business analysts and 2 operation specialists to drive data strategy, automation and pipelining for metric reporting, analysis, planning and quarterly/monthly sales reviews • Report into VP, Sales and work directly with Chief Sales Officer to own and drive the sales data strategy • Developed Sales data strategy to achieve operational efficiency o Built sales data mart (EIS) single handedly from scratch using Microsoft SSIS (ETL) to consolidate the data from various data sources - transactional systems, Salesforce, external sources, and internal support data which increased the overall operational productivity by 60% o Collaborated with Business Intelligence, DBAs and R&D for data and infrastructure needs o Automated monthly “book of business” process and “account portfolio” creation process to reduce the manual effort by 80% o Partially automated the quotas setting, developed SQL scripts & procedures, analyzed transaction data and dashboard to present and deliver valuable insights using SQL, Python, Salesforce, Tableau and Excel which improved the operational efficiency by 60% o Built various sales reports in Python to automate end to end needs • Developed forecasting models to predict the yearly sales using Scikit and panda libraries • Working on an AI model to detect duplicate account and perform record linkage (entity resolution) • Collaborate with Operations, ASMs, Account managers, Business services and Finance team to identify KPIs and reporting needs to evaluate sales performance • Lead the yearly budgeting and planning process to set goals for the next fiscal year which are shared with the CEO. • Perform cohort analysis, pricing analysis, product analysis, revenue share analysis, prospecting, pipeline, compensation, commissions, channel analysis, QBR and monthly sales review to evaluate the overall health of the sales organization Show less

Sr. Business Analyst/Data Analyst - Contract

• Jul 2017 - Mar 2018

Project lead for designing a solution to automate the HR compensation process for the monthly and quarterly payout of Portfolio Manager, Referred Manager, Wealth Adviser, and other bank officials Design the revenue model for brokerage, Investment Management, and Trust business Profile various source systems (8+) using SQL, Python and Tableau to understand and source account and revenue data to meet the reporting needs of Compensation and Accounting Mined and translated PWM data into… Show more Project lead for designing a solution to automate the HR compensation process for the monthly and quarterly payout of Portfolio Manager, Referred Manager, Wealth Adviser, and other bank officials Design the revenue model for brokerage, Investment Management, and Trust business Profile various source systems (8+) using SQL, Python and Tableau to understand and source account and revenue data to meet the reporting needs of Compensation and Accounting Mined and translated PWM data into meaningful metrics to analyze quality in Tableau for stakeholders and business owners Conduct working sessions with business owners (10+) to understand business requirements, issues, data requirements, and additional reporting needs Developed daily report for tracking new account openings and portfolio funding growth that helped HR to track anomalies in a timely manner Show less Project lead for designing a solution to automate the HR compensation process for the monthly and quarterly payout of Portfolio Manager, Referred Manager, Wealth Adviser, and other bank officials Design the revenue model for brokerage, Investment Management, and Trust business Profile various source systems (8+) using SQL, Python and Tableau to understand and source account and revenue data to meet the reporting needs of Compensation and Accounting Mined and translated PWM data into… Show more Project lead for designing a solution to automate the HR compensation process for the monthly and quarterly payout of Portfolio Manager, Referred Manager, Wealth Adviser, and other bank officials Design the revenue model for brokerage, Investment Management, and Trust business Profile various source systems (8+) using SQL, Python and Tableau to understand and source account and revenue data to meet the reporting needs of Compensation and Accounting Mined and translated PWM data into meaningful metrics to analyze quality in Tableau for stakeholders and business owners Conduct working sessions with business owners (10+) to understand business requirements, issues, data requirements, and additional reporting needs Developed daily report for tracking new account openings and portfolio funding growth that helped HR to track anomalies in a timely manner Show less

Co- Founder/ Product Manager

• Apr 2016 - Dec 2016

Setup an eCommerce based footwear business Mesha from scratch and made it profitable with-in 4 months 4 products received 1000+ ratings and made it to top 10 on Flipkart, an eCommerce marketplace Identified opportunity to sell mid-quality footwear for affordable prices in Tier 2 and Tier 3 cities Established relationship and transacted with small manufacturers for footwear manufacturing and pricing Analyzed sales data in excel to create location based promotions and participate in… Show more Setup an eCommerce based footwear business Mesha from scratch and made it profitable with-in 4 months 4 products received 1000+ ratings and made it to top 10 on Flipkart, an eCommerce marketplace Identified opportunity to sell mid-quality footwear for affordable prices in Tier 2 and Tier 3 cities Established relationship and transacted with small manufacturers for footwear manufacturing and pricing Analyzed sales data in excel to create location based promotions and participate in assured programs that helped increase the sales to 600 units per day Examined sales data to identify fraudulent activities and prevent fake orders Created various calculators in excel for fee and profit calculation, stock management, order management to streamline the daily operations Show less Setup an eCommerce based footwear business Mesha from scratch and made it profitable with-in 4 months 4 products received 1000+ ratings and made it to top 10 on Flipkart, an eCommerce marketplace Identified opportunity to sell mid-quality footwear for affordable prices in Tier 2 and Tier 3 cities Established relationship and transacted with small manufacturers for footwear manufacturing and pricing Analyzed sales data in excel to create location based promotions and participate in… Show more Setup an eCommerce based footwear business Mesha from scratch and made it profitable with-in 4 months 4 products received 1000+ ratings and made it to top 10 on Flipkart, an eCommerce marketplace Identified opportunity to sell mid-quality footwear for affordable prices in Tier 2 and Tier 3 cities Established relationship and transacted with small manufacturers for footwear manufacturing and pricing Analyzed sales data in excel to create location based promotions and participate in assured programs that helped increase the sales to 600 units per day Examined sales data to identify fraudulent activities and prevent fake orders Created various calculators in excel for fee and profit calculation, stock management, order management to streamline the daily operations Show less

Senior Consultant, Data & Analytics

• Dec 2014 - Mar 2016

Business Analyst | Project: Unified Client Profile Assisted a large investment bank with building a client master solution to create a single and accurate view of the financial intermediaries Interfaced with clients on a daily basis to document the current state and define the future state Collaborated with internal and executive stakeholders to provide high quality PMO services including project management, business analysis, data and business requirements gathering, workflow… Show more Business Analyst | Project: Unified Client Profile Assisted a large investment bank with building a client master solution to create a single and accurate view of the financial intermediaries Interfaced with clients on a daily basis to document the current state and define the future state Collaborated with internal and executive stakeholders to provide high quality PMO services including project management, business analysis, data and business requirements gathering, workflow documentation and analysis for Unified financial intermediary profile view Conducted working sessions with SMEs to understand and profile various source systems containing 400K+ intermediary profiles, 40k+ firms and 300K+ locations using Toad, Oracle, MySQL and SQL Developed KPIs and data quality scorecard to perform health check of intermediary data - 30 data quality issues were identified across 6 data quality dimensions Created enterprise party data model and data dictionary for Unified financial intermediary profile view Identified and built remediation activities, and evaluated time effort for each activity Business Analyst | Project: Transaction Loss Provisioning Process Assisted a large online payment System Company with strategic implementation of top-down model for statutory reporting Responsible for project planning, budgeting, weekly status reports, stakeholder management, communication management and deliverable tracking Collaborated with stakeholders across various teams to define functional requirements for systematizing the model execution and its performance testing - backtesting, trend analysis and crosswalk Conducted working sessions with client SMEs to define use cases and process maps for existing loss provisioning processes in IBM Blueworks Live Created UAT script and led the entire UAT cycle Identified automation opportunities to improve efficiency and performance Created conceptual and data flow diagrams in Visio for the future loss provisioning process Show less Business Analyst | Project: Unified Client Profile Assisted a large investment bank with building a client master solution to create a single and accurate view of the financial intermediaries Interfaced with clients on a daily basis to document the current state and define the future state Collaborated with internal and executive stakeholders to provide high quality PMO services including project management, business analysis, data and business requirements gathering, workflow… Show more Business Analyst | Project: Unified Client Profile Assisted a large investment bank with building a client master solution to create a single and accurate view of the financial intermediaries Interfaced with clients on a daily basis to document the current state and define the future state Collaborated with internal and executive stakeholders to provide high quality PMO services including project management, business analysis, data and business requirements gathering, workflow documentation and analysis for Unified financial intermediary profile view Conducted working sessions with SMEs to understand and profile various source systems containing 400K+ intermediary profiles, 40k+ firms and 300K+ locations using Toad, Oracle, MySQL and SQL Developed KPIs and data quality scorecard to perform health check of intermediary data - 30 data quality issues were identified across 6 data quality dimensions Created enterprise party data model and data dictionary for Unified financial intermediary profile view Identified and built remediation activities, and evaluated time effort for each activity Business Analyst | Project: Transaction Loss Provisioning Process Assisted a large online payment System Company with strategic implementation of top-down model for statutory reporting Responsible for project planning, budgeting, weekly status reports, stakeholder management, communication management and deliverable tracking Collaborated with stakeholders across various teams to define functional requirements for systematizing the model execution and its performance testing - backtesting, trend analysis and crosswalk Conducted working sessions with client SMEs to define use cases and process maps for existing loss provisioning processes in IBM Blueworks Live Created UAT script and led the entire UAT cycle Identified automation opportunities to improve efficiency and performance Created conceptual and data flow diagrams in Visio for the future loss provisioning process Show less

Senior Data Engineer

• Aug 2012 - Sep 2014

Part of operations team Planned and managed projects aligning business goals with technology solutions to drive process improvements & competitive advantage. Managed projects in Enterprise Data Management, Master Data Management( MDM ), Data Quality and Vendor Management domains. Subject matter expertise on Markit EDM/CADIS implementation and project planning Responsible for integrating various Fixed Income Data feed like EDI, WMDATEN, ANNA, SEDOL with Markit EDM/Cadis -Enterprise… Show more Part of operations team Planned and managed projects aligning business goals with technology solutions to drive process improvements & competitive advantage. Managed projects in Enterprise Data Management, Master Data Management( MDM ), Data Quality and Vendor Management domains. Subject matter expertise on Markit EDM/CADIS implementation and project planning Responsible for integrating various Fixed Income Data feed like EDI, WMDATEN, ANNA, SEDOL with Markit EDM/Cadis -Enterprise Data Management Platform. Managed the entire vendor product life cycle from strategic planning, SLAs, mapping, testing, delivery and support. - Vendor Management Show less Part of operations team Planned and managed projects aligning business goals with technology solutions to drive process improvements & competitive advantage. Managed projects in Enterprise Data Management, Master Data Management( MDM ), Data Quality and Vendor Management domains. Subject matter expertise on Markit EDM/CADIS implementation and project planning Responsible for integrating various Fixed Income Data feed like EDI, WMDATEN, ANNA, SEDOL with Markit EDM/Cadis -Enterprise… Show more Part of operations team Planned and managed projects aligning business goals with technology solutions to drive process improvements & competitive advantage. Managed projects in Enterprise Data Management, Master Data Management( MDM ), Data Quality and Vendor Management domains. Subject matter expertise on Markit EDM/CADIS implementation and project planning Responsible for integrating various Fixed Income Data feed like EDI, WMDATEN, ANNA, SEDOL with Markit EDM/Cadis -Enterprise Data Management Platform. Managed the entire vendor product life cycle from strategic planning, SLAs, mapping, testing, delivery and support. - Vendor Management Show less

Associate Developer

• Feb 2010 - Apr 2012

Build a system in slang to automate the power bids and trades submission process Developed an interim tactical solution in SecDB/Slang to report initial remaining notional balances on all of OTC derivative inventory which involved quantitative analysis of 90 complex calculators by in-depth study of different securities & confirms Build a system in slang to automate the power bids and trades submission process Developed an interim tactical solution in SecDB/Slang to report initial remaining notional balances on all of OTC derivative inventory which involved quantitative analysis of 90 complex calculators by in-depth study of different securities & confirms

Web Developer Intern

• Aug 2009 - Dec 2009

Teaching Assistant

• Aug 2009 - Dec 2009

- Teaching Assistant for Professional Speaking. - Teaching Assistant for Professional Speaking.

Technology Consultant

• Jan 2009 - Apr 2009

Research Assistant

• Oct 2007 - Feb 2008