Feb 2018 – Nov 2018 · 9 mos · Kolkata Area, India

Sep 2016 – Feb 2018 · 1 yr 5 mos · Singapore

• IRT Digital Analytics Pvt Ltd, Singapore based Consulting IT firm to providing innovative IT solutions and services to clients and enabling them to simplify their business IT needs and driving them to gain a competitive edge in their world.
• Client & Business domain:
• Manufacturing & Retail |Healthcare | Water Resource
• Government | Insurance | Logistics | Education
• Responsibilities:
• DWH Technical assessment and Information Management Strategy
• Requirements definition and Solution prototyping
• Data Integration (ETL/ELT/CDC), Data Quality, Data Modelling, Data Architecture, Data warehouse, Data Governance, and Master data management
• Providing data / data warehouse strategies
• BI Strategy, tool evaluation and selection
• Building re-usable assets for data management
• Architecture building and technology evaluation
• Requirement gathering for application features
• Implementing the data model required by the application
• Creating schema objects and implementing rules for data integrity
• Choosing a programming environment for a new development project
• Team handling and execute task from development to loading data into data warehouse
• A Project Coordinator with expertise in planning, executing & spearheading overall functions related to the projects

Jun 2015 – Sep 2016 · 1 yr 3 mos · Bengaluru Area, India

• Project Description:
• IMS Health is a leading global information and technology services company providing clients in the healthcare industry with end-to-end solutions to measure and improve their performance. 7,500 services experts connect configurable SaaS applications to 15+ petabytes of complex healthcare data in the IMS One™ cloud platform, delivering unique insights into diseases, treatments, costs and outcomes. Customers include pharmaceutical, consumer health and medical device manufacturers and distributors, providers, payers, government agencies, policymakers, researchers and the financial community. Mainly working in two product like MI (Mobile Intelligence) & OM (Organization Management).
• Objective:
• Coordinate with Managers, Architects and Analysts to perform business accordingly.
• Develop schemas, tables, triggers, indexes, sequences, constraints, functions and procedures. • Understand business requirements and accordingly develop database models.
• Provide optimal design solutions to improve system quality and efficiency.
• Develop ETL job to load data from OLTP to data mart or data warehouse.
• Developed and Involved in Extraction, Transformation and Loading (ETL) process by using Informatica Tool.
• Extracted source data from Oracle and loaded to a Seamless warehouse.
• Implemented Aggregator, Sorter, Router, Filter, Joiner, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Fixed the invalid mappings and troubleshoot the technical problems of the ETL.
• Maintain technical documentations for reference purposes.
• Responsibilities:
• Requirement gathering for application features.
• Implementing the data model required by the application
• Creating schema objects and implementing rules for data integrity
• Choosing a programming environment for a new development project
• Team handling and execute task from development to loading data into data warehouse

Feb 2015 – Jun 2015 · 4 mos · Bengaluru Area, India

• MeritTrac is India’s Largest Testing & Assessment services company in the private sector. MeritTrac provides innovative assessment services to leading educational institutions, government organizations and corporate entities.
• MeritTrac is a 100% subsidiary of Manipal Global Education (MaGE) which is one of the largest and highly rated education services providers. As a leader in the testing space, MeritTrac has been leveraging its ISO certified test processes in transforming the way tests are managed and delivered in India.
• Responsibilities:
• Requirement gathering for application features.
• Doing the weekly maintenance job.
• Creating enhancement report.
• Resolving application queries in co-ordination with client.
• Creating order, running EOD.
• Gathering functional knowledge
• Designed and coded the program which does the conversion of frozen service plans.
• Working as a key team member and meeting deadlines in many tough schedules.
• Requirement gathering for application features.
• Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing
• Feasibility study, planning, implementation, testing, deployment and close-out
• Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, synonyms.
• Used SQL*Loader, Import/Export, UTL_FILE,and other Oracle built-in packages
• Automated SQL*Loader to load the data from the flat files
• Used Materialized Views, Packages and Dynamic SQL
• Created programs to transform data from Legacy systems into Oracle database
• Tested and modified codes for quality
• Languages : SQL, PL/SQL
• Operating Systems : Windows NT/9X/2000/XP, UNIX
• Database Software : Oracle
• Tools : PL/SQL Developer,TOAD,BMC Remedy,BMC Control-M

May 2014 – Jan 2015 · 8 mos · Bengaluru Area, India

• Davinta workforce has proven industry-wide experience in catering to the current need of ‘going the extra mile’ to reach out to the unbanked.
• Objective: To enable leading financial institutions to cover the unbanked - through mobile based solutions, and to provide local and
• global customers with access to a wider range of services and greater value.
• Approach: We provide a holistic approach to addressing our clients’ biggest challenges and seizing potential growth opportunities
• in their area of business and services.
• Vision: To make AltiFin, our flagship solution emerge as the best financial product available in the market and to rollout our solution across India,
• Africa, and Latin America.

Mar 2013 – Apr 2014 · 1 yr 1 mo · Kolkata Area, India

Feb 2010 – Feb 2013 · 3 yrs · Kolkata Area, India

• Project Description :
• SIP Investment & Solutions, is a Kolkata based entrepreneur. Involved in multiple business activities in various segments like Real Estate, Health Care Service Provider, Marketing & Distribution of Products with reasonable price and quality. SIP Investment & Solutions have immense pleasure in entering into its new Venture of Multi Level Marketing System where the Products/Property/Services Provide by one consumer recommending to another consumer without any Advertisement, Stockist, Dealer, Retailer or any Middlemen.
• Objective:
• Material requirement planing & Vendor selection
• Request for quotation
• Purchase requisition & Purchase order
• Goods receipt, Goods receipt Invoice generation & Invoice verification
• Payment to vendor
• Inventory management
• Payment to master retailers & sub distributors.