Sep 2024 – Apr 2025 · 7 mos · Noida, Uttar Pradesh, India · Hybrid

• worked as a lead data modeller and architect in enterprise data platform team and helped in building a self-serve platform for business users

Jun 2018 – Aug 2024 · 6 yrs 2 mos · Gurgaon, India · Remote

• I am working with mckinsey since the start of this assignment.
• Recently shouldered successful oracle erp to sap s4 migration along with migration from oracle warehouse to snowflake warehouse.I played a crucial role owing to business understanding and good knowledge over oracle erp project subject area which helped firm to migrate legacy data objects to Sap seamlessly and provide integrated reporting through snowflake warehouse.I have modelled majority of the data objects due to change from oravle erp to sap s4 and provided low level design and defined migration strategies.I am handling the most crucial data mart and currently working in the capacity of Team Lead . I have designed ,developed lot of ETL's and Reports along with end-to-end designing of new solutions that had helped firm significantly over these years.
• Owing to my keen interest in Business Functions ,I have become a Go-to person/SME for all engagement related queries. I have worked on strategies to migrate data seamlessly from legacy systems to Firm Data Warehouse by acquiring knowledge about all legacy systems in the process.

Jun 2017 – Apr 2018 · 10 mos · Kolkata

• I was working for ericsson as a contractor and worked there in Telecom Domain for US client T-Mobile. The project involved gathering data from multiple systems like Order Management, Charging and Billing systems etc and generating business reports based on business needs. We were using ETL- Informatica 10.1 to extract data from source .The reports were getting generated through oracle tables which were replication of source tables in our schemas . I was working as a Deployment manager .Gained some exposure of GIT for deployment activities and DevOps.

Apr 2017 – Jun 2017 · 2 mos · Kolkata Area, India

• I have worked with www.pedagoge.com as Sales & Operations Head . I was working closely with co-founders to streamline the daily operations.My primary focus was on process optimization which consequently reduced the operational cost. I got involved in the product design which will help in Pan India expansion besides operating from just one place.

Jan 2015 – Dec 2015 · 11 mos · Kolkata Area, India

• My work involved data extraction from Legacy systems and then loading into SAP after applying logic/conversions through Informatica .The work involved understanding of legacy data and then designing and developing informatica modules for data cleansing and transformations.
• I have used many complex transformations and techniques while implementation of this project like Java transformation , Re-usable Mapplet ,Control Tables , Incremental Loading procedures etc

Apr 2013 – Jan 2017 · 3 yrs 9 mos · Kolkata Area, India

• In Jan 2016 I joined Grocery Bazaar full-time as CEO, the major challenge was dropping of orders and consequently monthly revenue. It was running in a big loss i.e., 70—80 k monthly.
• I analysed the whole business end-to-end and then come up with a business plan to repair the damages. The steps that I took are as follows:-
• Started working on SEO to get more of organic traffic to website through top google ranking.
• Started Social media marketing through facebook and google adwords to increase awareness about the website .
• Defined min.stock keeping unit for products across category to avoid high and unused inventory costs
• Redefine the pricing strategy and delivery charges algorithm to make profit on every single order.
• Put Route Planning in place to increase resource utilization and cut down fuel costs.
• Increase the product range with high margin products and zero inventory cost.
• Started offering Free Home Delivery to customers on their first order irrespective of any order value which helped in gaining new customers.
• Started customer referral program
• Started regular feedback from the customer who used our service and worked on their complaints and suggestions
• Started making calls to people who registered on portal but didn’t order anything.
• Started working as logistics partner for other e-commerce companies and established new revenue channel
• The above steps brought out the result in 6 months and we were able to cut down our losses to less than 10k monthly . The number of orders increased 3-4 times and consequently monthly revenue

Nov 2009 – Jan 2015 · 5 yrs 2 mos · Kolkata Area, India

• I have worked in multiple projects in my tenure with TCS.My work mainly includes below
• A data warehousing solution which was designed to provide dynamic reports to the clients,which can be utilised to analyze the business growth,challenges and sight of improvements to them.These reports can be easily modified ,as cognos provide this feature,to check the statistics of measures against any dimensions.The reports can be manipulated dynamically and easily.
• Work involves development of user stories or change requests many applications involving Informatica,Tivoli workflow scheduler,Cognos 8 and UNIX shell programming and PL/SQL codes.
• Primary responsibilities include
• 1 . Development -: Have worked with many components of Informatica like Sorter,Aggregator,Filter,Joiner.Look-ups ,Rank,Sequence Generator,Update Strategy,Router, stored procedures transformation etc .Used Flat files(i.e. fixed width,delimited),Oracle tables,Xml files as source and target definition.Created a reusable mapplet for implementation of SCD type 2 in any map.
• 2 . Writing SQL codes for lookup’s and SQ transformation and stored procedures transformations.
• 3.Generating Parameter Files and scheduling workflow using shell scripts.
• 4.Interacting with business users for understanding their requirements clearly
• 5.Applying Performance tuning measures like session partitioning and indexing