Capable of designing software solutions and driving the process of software development from inception to completion.
A relentless student, a quick learner. Rational self-believer. Always eager to prove myself. Looking for opportunities
       where I can make contributions in the field of technology that matters to the world.
EDUCATION:
     Master of Science in Software Engineering                                                                     Dec’2019
     Arizona State University, USA                                                                                GPA=3.63
        Bachelor of Technology in Information Technology                                                          Jun’2005
        West Bengal University of Technology, India                                                             CGPA=7.33
CERTIFICATIONS:
       PMI-ACP (Agile Certified Practitioner by Project Management Institute)                           Jul’2019 – Jul’2022
       OCA (Oracle Certified Associate)                                                                                2007
KEY SKILLS:
       Technical Leadership in database application development
       Object-Oriented Design
       System Design
       Agile methodology (Scrum, Kanban)
        Programming Languages: Python, Java, SQL, PL/SQL, JavaScript, React js
        Data platforms: Oracle DB, MySql, SQL Server, PostgreSQL, MongoDB, Apache Kafka, Hadoop, Apache Spark
        Cloud : Firebase, AWS
        Version control: Github, SVN
        Other: Familiarity with Machine Learning and Neural Network techniques
WORK EXPERIENCE:
      Tata Consultancy Services                                                                   Nov’2005 - Feb’2018
     Technical Team Lead, Solution Designer, application developer in India and the United Kingdom
           2+ years in object-orienteddesign and application development in Core Java and Java Swing for Aramark Inc
            and Phones4U Plc
           Received “Star of the Month” award in 2008 for outstanding contribution in Data Conversion and Interface
            development project for Alcoa Inc
           Received “Best Team” award from British Telecom as the Technical Team Lead in 2016
           Deputed to Phones4U, Newcastle-Under-Lyme, UK as Solution Architect in 2010, 2014
           Deputed to British Telecom, London as Technical Team Lead in 2015-2016
         W.P. Carey School of Business - Computer Information Systems, USA                           Aug’2018 – Dec’2019
        Student Worker - Teaching Assistant in Business Database Systems. Mentoring undergrad students on their Honors
        Thesis project
         Summer internship, Kaiser Permanente, USA                                                     Jun’2019-Aug’2019
        Developed a data migration solution in Python. Achieved 6-8 times better execution performance beyond the minimum
        target threshold
PROJECT DETAILS:
        Project         :       Regulatory Finance – Solution Re-engineering
        Client              :     British Telecom, UK
        Role                :     Technical Delivery Manager
        Duration            :     Dec’2015-Dec’2016
        Environment         :     Financial Models on Microsoft Excel, Oracle database.
       BT is a British multinational telecommunication service company headquartered in London, United Kingdom. It is one of
       the largest telecommunications services companies in the world and has operations in over 170 countries.
    In the UK, the telecommunications industry is regulated by Ofcom (the UK’s independent communications regulator).
    BT Group Regulatory Finance team prepares the Regulatory Financial Statement (i.e. RFS through a very complex
    process) which shows the costs, revenues, assets and liabilities against regulatory Markets and Services as defined by
    Ofcom in their market reviews. TCS has been assigned to the project for the process (of preparation of the RFS)
    simplification and making it more robust by automating the areas which have the maximum dependency on individual
    users and financial excel models.
    Responsibility:
   Solution Architect at Customer Site (London)
   Analyzing the existing process and finding out the pain areas.
   Providing functional/technical solution and proposing new techniques for implementing the same
   Preparing Proof Of Concept wherever necessary
   Simplification of existing financial models and preparation of user document for the same.
    Project           :           Oracle Advanced Collection post-implementation CRs for Italy
    Client                    :      British Telecom, Italy
    Role                      :      Oracle Advanced Collection SME
    Duration                  :      Sep’2015-Dec’2015
    Environment               :     Oracle Applications 11i, Oracle Advanced Collection and Account Receivables.
    Oracle Advanced collection module is already implemented in BT Italy, but, yet to be operational. BT wants some
    enhanced features to be implemented as per its business needs before it starts using this module.
    Responsibility:
   Functional/Technical lead at offshore.
   Requirement gathering from business/IT and analysis.
   Feasibility study and proposing solution approach
   Identifying data sources to be used in the development
    Project     :     Oracle Inventory Optimizations and Value Chain Planning Implementation – Data Migration
    Client      :     British Telecom, UK
    Role              : Data Migration Expert
    Duration          : May’2015-Sep’2015
    Environment       : Oracle Applications R12, Oracle Inventory, Oracle ASCP, PL/SQL and SQL Loader.
    As part of the Inventory Optimization solution, BT requires the legacy system data to be migrated to its inventory planner
    and ASCP system in Oracle.
    Responsibility:
   Requirement analysis.
   Leading the technical team consists of 4 members.
   Involved in migration components development activity.
    Project           :           Oracle ERP R12 Upgrade
    Client                    :     GE HealthCare, USA
    Role                      :     Functional Consultant
    Duration              :        Feb’2015-May’2015
    Environment        :     Oracle Applications R12, Order Management, Oracle Account Receivables.
    General Electric - HealthCare upgrades its application from Oracle EBS version 11i to Oracle EBS version R12.
    Responsibility:
   Gathering functional requirement from business and analyzing the same.
   Solution designing.
   Functional design document preparation.
   Presenting the functional solutions to customer and get them approved through GE-HC solution approval process.
    Project     :       Intercompany PO Simplification
    Client             :   GE Oil and Gas, USA
    Role               :   Project Manager
    Duration           :   Nov’2014-Feb’2015
    Environment          :     Oracle Applications 11i, Order Management, Oracle Purchasing, Oracle Inventory,
                      PL/SQL.
    General Electric Oil and Gas business implements a simplified solution for its intercompany transactions.
    Responsibility:
   Requirement gathering from Business and analysis of requirements.
   Involved in solution designing, effort estimation and status reporting to the customer and senior management.
   Guiding the development team to reach SDLC milestones within scheduled timeline.
    Project     :          Phones4U – Application Development
    Client             :     Phones4U Limited, United Kingdom
    Role               :     Techno-Functional Consultant
    Duration           :     Mar’2014-Oct’2014
    Environment        :     Oracle Applications 11i, Order Management, Oracle Receivables, PL/SQL.
    Phones 4U is a Telecom retailer. Phones 4u is in a retail business which sells cellular phone packages through multiple
    channels like web, call centers and retail centers.
    To support the growth plans of the business Phones 4u is undertaking a large IT transformation programme to implement
    automation phase wise in their business using Oracle and Siebel Technology.
    Responsibility:
   Involved in development of small scale projects
   Worked as the onsite coordinator for Oracle e-biz team from Client site.
   Requirement gathering from users and analyzing the requirements.
   Functional design for new developments.
    Project            :     Oracle Financial – ALEKS Data Conversion
    Client             :     McGraw-Hill Education, USA
    Role               :     Finance Techno-Functional Consultant and Development Team Lead
    Duration           :     Nov’2013 –Mar’2014
    Environment        :     Oracle Applications 11i, Oracle Receivables, Oracle Order Management, PL/SQL.
    McGraw-Hill Education (MHE) is a digital learning company that provides customized educational content, software and
    services.
    ALEKS is the latest acquisition of McGraw-Hill education. Open Accounts Receivable invoices and credit memos from
    the newly-acquired ALEKS need to be imported from the ALEKS transaction processing system into the McGraw-Hill
    Education (MHE) Oracle system.
    Responsibility:
   Requirement analysis with business.
   Providing architectural solutions.
   Preparing functional design.
   Assignment and monitoring development activities in Finance module to development team.
    Project           : Implementation of Oracle Service Contract
    Client            : Scholastic Inc, USA
    Role             : Finance Techno-Functional Consultant and Development Team Lead
    Duration         : Aug’12 –Nov’13
    Environment       : Oracle Applications 11i, Oracle Receivables, Oracle Service Contracts and Oracle Order
                      Management, PL/SQL.
    Scholastic Inc. is a book publishing company headquartered in New York, USA. It is the world's largest publisher and
    distributor of children's books.
    Scholastic implements Oracle Service Contract module in Oracle application 11i to manage its subscription business. The
    modules implemented as part of the solution are OKS, OM and Oracle Receivables.
    Responsibility:
   Providing functional solutions in Finance modules (AR).
   Requirement analysis with business.
   Preparing functional design.
   Assignment and monitoring development activities in Finance module to development team.
    Project           :  GFP (Global Finance Platform) – Italy and Global CRs
    Client            :  British Telecom, UK
    Role              :  Oracle Finance Techno-Functional Consultant
    Duration          :  Aug’12 –Feb’13
    Environment      : Oracle Applications 11i, Oracle Receivables and Order Management, PL/SQL, Oracle General
                      Ledger.
    The scope of this project includes post go live support activities and deliveries of change requests.
    The modules in use for this project are SCM and Finance (includes AR, GL).
    Responsibility:
   Leading development team for technical deliveries (Order to Cash cycle).
   Requirement review with architects and teams for CRs.
   Review of functional designs and Designing technical approach for new developments.
   Developing discoverer reports.
   Developing inbound and outbound interfaces.
    Project           :   EA India Offshore Meridian
    Client                : Electronic Arts, USA
    Role             :    Finance Techno-Functional Consultant
    Duration         :    Oct’11 –Aug’12
    Environment      : Oracle Applications R12, Oracle Receivables, Oracle order Management, PL/SQL, Form
                     personalization.
    Electronic Arts (EA) is in the process of transforming organization, processes, technology, and data to implement a
    Label/Function model and enable the move to digital / direct to consumer services. The first stage in this transformation
    was the restructuring of EA to create Labels and global functions to support the Labels.
    Project Meridian is a major EA initiative which aims to drive operational efficiency through the EA business. Project
    Meridian through defining and implementing a more standardized ERP solution will also challenge our ways of working
    and ensure that we are structured in an efficient way that can be flexible to the demands of the future.
    The Project mainly was a R12 Implementation project with 2-Phased rollouts in mainly SCM and Financial Modules
    namely Order Management, GL, AP, AR and a custom cycle in SCM called DOTC (Digital Order To Cash). The project
    had reporting scope also in XML publisher, D2K and Discoverer Reports as well as in Workflows.
    Responsibility:
   Involved in the implementation of a custom module DOTC (Digital Order To Cash).
   Regular discussion with the Client’s Solution design team to understand the requirements.
   Preparing Functional Specification (MD.050) document after discussing with user.
   Assignment and monitoring of Digital Order to Cash module development tasks to team as an additional responsibility.
   Took part in development activity (concurrent programs) as well.
    Project     :     Phones4U – Production Support
    Client        :    Phones4U Limited, United Kingdom
    Role          :    Techno-Functional Consultant
    Duration      :    Dec’2008-Oct’2011
    Environment     :    Oracle Applications 11i, Oracle Payables, Order Management, Oracle Receivables, Java,
                  PL/SQL, Oracle Forms.
    Phones 4U is a Telecom retailer. Phones 4u is in a retail business which sells cellular phone packages through multiple
    channels like web, call centers and retail centers.
    Phones 4U primarily sells packages which includes purchased products from:
    •Cell Phones purchased from vendors like Nokia, Motorola, LG, Sony Ericsson etc
    •Talk Plans/ Connections from vendors (Networks) like O2, T-Mobile, Vodafone, Orange, Virgin, British Telecom etc.
    To support the growth plans of the business Phones 4u is undertaking a large IT transformation program to implement
    automation phase wise in their business using Oracle and Siebel Technology.
    Responsibility:
   Production support activity in SCM and Finance modules.
   Involved in development of small scale projects
   Object-oriented design and development
   Worked as the onsite coordinator for Oracle e-biz team from Client site.
   Requirement gathering from users and analyzing the requirements.
   Functional design for new developments.
    Project         : Europe RICE (Report, Interface, Conversion, Extension) Support
    Client          : ALCOA, Europe
    Role    :    Technical Consultant
    Duration          :    Aug’2008- Dec’2008
    Environment       :    Oracle Application 11i, PL/SQL, Interface, Oracle Reports, Conversion.
     
    Alcoa is the world's leading alumina supplier–the only global supplier with smelter and chemical grade alumina available
    from multiple sources around the world.
    Alcoa implements a common process-system-data solution (ERP) based on ORACLE 11i applications. The solution is
    being hosted at 4 regional Alcoa data centers (North American, South/Latin America, Europe, Australia and Asia) and
    deployed in over 500 manufacturing and administrative locations.
     
    Responsibility:
   Involved in production support for Reports, Interface, Conversion and Extensions.
   Requirement gathering and documentation.
   Change management activities
    Project   :     US HRMS Conversion of Hygenius
    Client    :     ALCOA, USA
    Role     :      Technical Consultant
    Duration :      Dec’2007- Jul’2008
    Environment         : Oracle Application 11i, PL/SQL, Conversions,Interface.
    HYGenius has two categories of users. One is Industrial Hygiene Group (IH Group- depending on Hygiene standards and
    classification) and other on is Human Resources Group (HR Group- Depending on Location classifications). Previously
    the Peoplesoft HR was used for maintaining employee information. The scope of this project includes Peoplesoft HR
    conversion to Oracle HR.
    Responsibility:
   Involved in Peoplesoft HR conversion to Oracle HRMS.
   Involved in developing interfaces among legacy systems and Oracle Applications HRMS.
   Requirement gathering from customer on a daily basis and analyzing the requirement.
   Testing
   Change management activities
   Maintaining status report and sharing with customer on a daily basis in the status meeting.
    Project                 : Customer Connect Initiative - Core
    Client                  : Aramark Uniform Services, USA
    Role                   :   Application Developer
    Duration                : Nov’2006 – Dec’2007
    Environment           :    Oracle Applications 11i (10g database), Core Java, PL/SQL, Order Management, AR
                          Modules.
    The scope of this project includes support and maintenance of in Oracle Application – especially in AP, OM and AR
    modules. It also includes the development activities for the enhancements of the existing application.
    Responsibilities:
   Involved in defect fixing and development of enhanced functionalities in SCM and Finance modules (Order Management
    and AR) in PL/SQL and Java.
   Documentation of technical designs.
   Change Management activities.
        Project               :   BBPNL Offshore Development
        Client                :   Balfour Beatty Power Networks, UK.
        Role                 :     Technical Developer
        Duration              :   Jan’2006-Oct’2006
        Environment           :   Oracle Applications 11i (9i database), PL/SQL, SQL* Loader, Oracle Forms 6i.
        BBPNL is a power network company based in the UK.
        The project includes the development activities of custom forms, reports and workflows in Oracle Application 11i. The
        development is done in following modules: Order Management, Project Billing.
        Responsibilities:
       Oracle Forms development in Oracle Project Billing modules
       Involved in testing activities.
       Change management activity
EXTRACURRICULAR ACTIVITIES:
      Password Security System with 2-way Authentication                                                  IEEE, 2017
     Published in Third International Conference on Research in Computational Intelligence and Communication Networks
     (ICRCICN-2017) with acceptance rate = (77/272) = 28%
         Regular participant in Hackathons
        Hack Arizona,University of Arizona                                                                       Jan’2019
        – Designed and built an intelligent chatbot prototype that runs on voice command and helps in job search
        Fox Hackathon, Arizona State University                                                                  Oct’2019
        – Developed a Convolutional Neural Network (CNN) model for image recognition that produced 89% accuracy