Experience

Avanade

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Engineering Leader - Data/Cloud Architecture

  • Oct 2021 - Present

  • Pre Sales work, solutioning and response to RFP's for US North east clients • Architecture Solutions as Data Integration, Cloud , Data and Data Modernization • Engineering manager for key accounts responsible for delivery and architecture • Client facing technologist, helping customer provide tailored made solution based on Azure • Cloud Solutioning using Data Lake, ADF, Data bricks, Synapse, Data Lake, iPaas, Cosmos, SQL DB, Azure Integration etc. • Pre Sales work, solutioning and response to RFP's for US North east clients • Architecture Solutions as Data Integration, Cloud , Data and Data Modernization • Engineering manager for key accounts responsible for delivery and architecture • Client facing technologist, helping customer provide tailored made solution based on Azure • Cloud Solutioning using Data Lake, ADF, Data bricks, Synapse, Data Lake, iPaas, Cosmos, SQL DB, Azure Integration etc.



Wipro

• India
• IT Services and IT Consulting
• 700 & Above Employee

• Data Consultant @ PNC Bank

  • Nov 2019 - Oct 2021

  Project DescriptionWorking as Data consultant for Asset management group (AMG) which provides data and analytical reports across the AMG group. This involves analysis on Wealth customers, internal employee performances assessment and sales and pipeline data for entire group.Responsibilities: • Started with seed team member with just 3 team members and worked in growing account to 23 team member presently for data team • Working with business teams to understand the business requirements for data needs • Analyze data source systems for business needs and working with data SME’s on each system to understand details required using SQL or PySpark • Analyzing code written for old systems, be in SAS, SQL etc to understand the business logic and map it into a tech document, mapping document • Building pipelines using PySpark • Worked on conceptualization, planning and delivery of Advisor 360 dashboard, which was well received by business and helped in gauging team performance at a a click • Planning quarterly deliverables and presenting it to the business and IT stakeholders • Data Model changes to the existing solution • Governing best practices around data usage and efficient programming • Quality checks both on data side and reporting side to ensure quality of data to business using Pyspark or SQL using Anaconda, Hive, Impala etc. Show less

• Data Consultant / Cloud Consultant @ Harte Hanks

  • Jan 2017 - Oct 2019

  Project DescriptionDatabase solutions group wherein we maintain and process data for Harte Hanks customers. This group provide their customers processed data for marketing and also help customers in marketing insight.Here it was two fold work, maintain exiting database and migrating important clients onto Hadoop.Responsibilities: • Managing team of onsite and offshore for delivery team of almost 45 team members, which includes 8 legacy and 1 migration client • Running WSR for client deliverables for ongoing work and also leading one project for migration, which was deemed extremely critical • Proposed data models based industry vertical like manufacturing, banking etc. helped in scalable solution which eased next migrations • Automation of the client files coming from FTP sites onto our site using EFT and UNIX. • Got CSAT rating of 6.5 out of 7 and in the remarks section customer really appreciated my work and stressed about the value adds which I helped bringing in with my experience • L3 support for production jobs on multiple solutions using Ab Initio, SQL and Alteryx and managing escalation for incidents • Data design for migration from legacy systems to Hadoop based systems: Signal Hub which was hosted on cloud AWS using tools like S3, Redshift, CLI etc. • Coding in Ab Initio, SQL and Signal Hub (Hadoop based system) • Creation of data mapping documents for migration purpose and assisting teams working on migration Show less

• Lead Data Analyst / Data Migration Analyst @ United Utilities

  • Sep 2015 - Dec 2016

  Project DescriptionWater Act 2014 allows for the full opening of retail non-household market by 1 April 2017. This means that all businesses, charities and public sector customers in England and Wales will be able to switch their water and sewerage retailer. Part of wholesale business data strategy team tasked to migrate data from legacy systems and publish this data.Responsibilities: • Understanding the busiest requirements which require migrating the whole system to a a new requirement which was quite complex in business sense • Documenting data coming from various systems and tying it together to find water and sewerage using tools like Exasol, Talend and SQL • Documenting findings and presenting it to business team and making them understand what changes are coming and how they will be impacted • Brought in business of ~1M dollars for data processing leveraging Wipro BPO division • Quality checks on data from current systems and identifying gaps • Migration strategy of data from current systems to new systems • Data mapping documents from current system to new system Show less

• Data Analytics Consultant @ Tesco

  • Jan 2014 - Sep 2015

  Project DescriptionWSS was a solution developed to estimate how much manpower would be required in each physical store based on the store format and what each person should be doing at 15 minute interval. This was based on the historical data provided. This solutions has helped a lot for manpower deployment and has been a lot of assistance to store managers to deploy teams.Responsibilities: • Data model review and creation of Low-Level Design Document for ETL • Predictive model creation and support for future manpower support based on historical data • Created ETL jobs using SAS DI to extract data and loading it to the publish layer • Code reviews of team at offshore and peers • Data quality checks before providing data to the application • Technical and business demos to business and technical managers • Batch scheduling of jobs and identified scenarios to reduce batch processing time from 16 hrs to 13 hrs for a weekly load • Recommending tolerance and implementing solution for incoming source files data during batch processing • Led charter for Code efficiencies and best practices for DWH solution design and development from landing to publish layer which resulted in an efficient and manageable solution Show less

• Solution Consultant @ Ahli United Bank

  • Apr 2013 - Dec 2013

  Project Description:This project involves in implementation and maintaining of DWH solution which contains data pertaining to Credit Risk and Financial Planning, building static and analytical reports for mid and senior management.Responsibilities: • Created the Data Flow diagrams and designed the integration layer between Credit Risk product and Enterprise Data warehouse • Data model review and creation of Low-Level Design Document for ETL • Analysis of Enhancements and design of ETL jobs • Created ETL jobs using SAS DI to extract data from Enterprise Data warehouse • Created of UT Test Cases, SIT Test Cases • Coding using SAS Base, SAS Macro and SQL • Creation of Information and BI reports using Web Report Studio • Working on code efficiency and process efficiencies to bring the batch time down Show less

• Technical Lead

  • Dec 2009 - Apr 2013

  Project Description:This project involves building of a Reporting Solution which will cater to both MIS and Analytical users. This involves building reporting solution from a complex source system and data from various business areas like VAT, Treasury and Excise.Responsibilities: • Creation of Application, Data Architecture, and H/W Architecture. • Working with client to get the SRS signed and approved by multiple committee • Managing the project planning, expenses and ROI of project • Design of database using Erwin and both OLAP and ODS database • SAS Consultant for SAS BI and DI • Development of ETL Jobs and BI dashboards • Batch Automation using UNIX, Cronacale, FTP etc. tools Show less



dunnhumby

• United Kingdom
• Advertising Services
• 700 & Above Employee

• Data Engineer

  • Jun 2007 - Dec 2009

  • Development of ETL jobs using SAS DI • Working and responsible for driving efficiencies using SAS, UNIX and Excel • Data Analysis of impact of promotions • Target customer for statements and analyzing data for rise/dip in sales • Development of ETL jobs using SAS DI • Working and responsible for driving efficiencies using SAS, UNIX and Excel • Data Analysis of impact of promotions • Target customer for statements and analyzing data for rise/dip in sales



Aon

• United Kingdom
• Financial Services
• 700 & Above Employee

• Batch System Analyst

  • 2005 - 2007

  • Study of Client requirements and draft them into system specific requirements • Implementing various logics involved behind data loading, client reporting, and data manipulations using SAS 9.0 programming language • Led status calls with NA (North America) managers and counterparts for the overall project • Testing the code, which include Unit and Integration Testing • Study of Client requirements and draft them into system specific requirements • Implementing various logics involved behind data loading, client reporting, and data manipulations using SAS 9.0 programming language • Led status calls with NA (North America) managers and counterparts for the overall project • Testing the code, which include Unit and Integration Testing



CMC LTD

• India
• IT Services and IT Consulting
• 700 & Above Employee

• Engineer

  • 2004 - 2005

  • Study of RFP’s and works with team members to come up with a robust solution • Meetings with the OEM(s) for technology and Client with the solution • Co-ordinate and work with implementation team for implementing solution • Study of RFP’s and works with team members to come up with a robust solution • Meetings with the OEM(s) for technology and Client with the solution • Co-ordinate and work with implementation team for implementing solution