Isha Malhotra

Senior Data Migration Specialist and Product Developer at Valiance Partners
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
New York City Metropolitan Area
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • STAT 420: Statistical Modeling in R
    University of Illinois at Urbana-Champaign
    Aug, 2020
    - Oct, 2024
  • CS 498: Data Visualization
    University of Illinois at Urbana-Champaign
    Aug, 2019
    - Oct, 2024
  • CS 412: Introduction to Data Mining
    University of Illinois at Urbana-Champaign
    May, 2019
    - Oct, 2024

Experience

  • Valiance Partners - An NNIT Group Company
    • United States
    • Software Development
    • 1 - 100 Employee
    • Senior Data Migration Specialist and Product Developer
      • Sep 2019 - Present

      Working as Sr Data Migration Specialiast in the Pharma Industry using leading industry application suites including Veeva, Sharepoint, Documentum etc. to perform complex data and content migrations. Integral member of Research and Development team developing various software products under the Company's Migration Suite TRUSeries software. Exploring next generation databases like Graphmarts using ODATA, SPARQL to build new adapters for software compatibility. Working as Sr Data Migration Specialiast in the Pharma Industry using leading industry application suites including Veeva, Sharepoint, Documentum etc. to perform complex data and content migrations. Integral member of Research and Development team developing various software products under the Company's Migration Suite TRUSeries software. Exploring next generation databases like Graphmarts using ODATA, SPARQL to build new adapters for software compatibility.

  • NYC Department of Housing Preservation & Development
    • United States
    • Government Administration
    • 700 & Above Employee
    • Senior Data Engineer
      • Oct 2018 - Sep 2019

      Working on database design & data modelling using CA Erwin. Working on Analytical Queries, DB Scrips and Reports. Data Visualization through Tableau. Oracle PL/SQL, Procedures, Functions, Packages. Working on Integration projects using ODI (Oracle Data Integrator) Studio 12c for mapping, packages, scenarios and load plans to push data from OLTP database to Data Warehouse for publishing to Data Marts. Working on Oracle OBIEEE (Oracle Business Intelligence Enterprise Edition) for Reporting. Working on database design & data modelling using CA Erwin. Working on Analytical Queries, DB Scrips and Reports. Data Visualization through Tableau. Oracle PL/SQL, Procedures, Functions, Packages. Working on Integration projects using ODI (Oracle Data Integrator) Studio 12c for mapping, packages, scenarios and load plans to push data from OLTP database to Data Warehouse for publishing to Data Marts. Working on Oracle OBIEEE (Oracle Business Intelligence Enterprise Edition) for Reporting.

  • QPharma, Inc.
    • United States
    • Pharmaceutical Manufacturing
    • 1 - 100 Employee
    • Senior Database Analyst
      • Feb 2017 - Sep 2018

      Worked on Integration Projects using ETL methodologies in SSIS (SQL Server Integration Services) on Microsoft SQL Server 2012 & 2014. Worked on Kingswaysoft SSIS Integration toolkit for Integration with Salesforce, QuickBooks, SFTP, Amazon S3 storage. Developed Oracle Packages on 12c using advanced PLSQL concepts including XML file handling using XPath & XQuery, result caching. Created modules on Microsoft Visual Studio 2013 using C#. Worked on Powershell scripts to interact with Database and scheduled jobs using SOS Job scheduler. Show less

  • ADP
    • United States
    • Human Resources Services
    • 700 & Above Employee
    • Senior Database Developer
      • Nov 2014 - Jun 2016

      Worked on General Ledger Interface (GLI) & Business Process Management (BPM). Worked on Database Design and Data modelling. Worked on Oracle Database setup by creating Schemas, Tables, Views, Synonyms, Sequences, Indexes, Constraints, Object types, Materialized Views and DB links. • Created multiple DB modules supporting User Interface of these applications like Packages, Procedure, Functions using Advanced PL/SQL programming concepts like Bulk Collects, Pipelined table functions, Result cache functions, Dynamic sql, ref cursors. Worked on Oracle XML APIs for parsing XML documents with XPath & Xquery. Worked with Large objects data types like CLOB, BLOB, RAW to store XML documents in DB objects. Worked on SQL Performance tuning using Explain Plans, Hints, SQL Tuning Advisor, Oracle Enterprise Manager, SQL Healthcheck, AWR, ASH, ADDM analysis, SQLT reports., SQL profiles, Baselining plans. Worked on Database Character set Conversion from a lower ISO NLS_characterset to Unicode(AL32UTF8). Worked on Oracle data load utilities like exp/imp (Export/Import), expdp/imdp, SQL Loader both direct & conventional load, external table. Show less

  • New York Life Insurance Company
    • United States
    • Financial Services
    • 700 & Above Employee
    • Lead Oracle Developer
      • Aug 2014 - Oct 2014

      Worked on Oracle development for enhancement and extension of existing features of applications consuming data from the Data Warehouse. Worked on data modelling for the addition of new module of the ETL scheduler which fed data to the Data Warehouse. Worked on Oracle Performance Tuning using Explain Plans, Tkprof, sql trace, dbms_xplan, SQL healthcheck, Oracle Enterprise Manager, SQL Profile. Worked on database design and created tables, constraints, primary keys, foreign keys, indexes, views, objects. Worked on Oracle PL/SQL development including Packages, Procedures and functions. PL/SQL advanced topics like Bulk Collects, Bulk Inserts, updates and deletes, Ref Cursors, Collections and cursors. Worked on complex sql queries using joins-left outer joins, equi joins and subqueries. Show less

  • FUJIFILM Healthcare Americas Corporation
    • United States
    • Medical Device
    • 700 & Above Employee
    • Oracle Developer
      • Oct 2013 - Jul 2014

      Worked as Sr. Oracle Database Developer for FUJIFILM’s classic Medical product & PACS system ‘Synapse’ under global and research development for Synapse engineering. Involved in extensive Oracle development for enhancement and extension of existing features of Synapse compliant to DICOM standards. Also created and added new functionality to the database area for Synapse using advanced oracle features like table functions, function overloading, ref cursors, bind variables, collections, dynamic sql, result cache, session variables. Worked on Data Modelling. Extensive Oracle PL/SQL Development - Packages, Procedures and Functions. Show less

  • GE Capital
    • United States
    • Financial Services
    • 700 & Above Employee
    • Senior Oracle Developer
      • Jun 2013 - Sep 2013

      Worked as an onsite Tech Lead for the Asset Management & Capacity Reporting Project for GE Capital to support & develop CARS application. I was involved in Client/Business coordination, meetings, Offshore Team management. Did Capacity Planning of the Applications & Servers. Involved in Oracle PL/SQL development including Packages, Procedures and functions. Worked on bulk data load using SQL Loader -Conventional & Direct Path modes. Created reports for the application using Oracle APEX. Worked on Designing, Developing, Documenting, Testing of ETL jobs and mappings on Server and Parallel jobs using IBM DataStage to populate tables in Data Warehouse. Worked on IBM Infosphere (DataStage, Quality Stage) / Information Analyzer 8.1. Experience in both Parallel Extender Jobs and Server Jobs in DataStage. Experience in usage of QualityStage for maintaining and cleansing of data. Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism. Involved in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Change Capture, Complex flat file, Modify, Aggregator, XML. Show less

  • Allstate
    • United States
    • Insurance
    • 700 & Above Employee
    • Oracle Developer and Application DBA
      • Oct 2012 - May 2013

      Worked on upgrade of Agency on-boarding portal. It involved downloading Field Agents Data feed daily, massaging the data, applying some business transformations & push to Data warehouse for reporting to higher management. I did extensive Oracle PL/SQL development including Packages, Procedures and functions. Developed the load module of the Ab-Initio ETL process to load data into oracle 11g database using PL/SQL programming. Implemented PL/SQL advanced topics like Bulk Collects, Bulk Inserts, updates and deletes, Ref Cursors, Collections and Cursors. Used parameterized cursors, loops, string handling functions and date conversion functions. Used Error & Exception handling, user defined exceptions, save exceptions clause during bulk operations, raise application errors. Developed data restore packages using Oracle Flashback techniques using flashback query through timestamp and SCN. Developed statistics collection utilities using PLSQL programming like Dashboard to display daily data changes to the database. Show less

  • Infosys
    • India
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Software Engineer
      • Feb 2009 - Feb 2012

      Worked for Milwaukee, Wisconsin based Northwestern Mutual client. Designed and developed new features for the Reports option in Ulife Contract Admin application with coding in VB 6.0 in front end and developed new oracle packages for the backend functionality. Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS_SQL, DBMS_PIPE, DBMS_JOBS, UTIL_FILE and DBMS_OUTPUT. Developed Oracle packages involving cursors and composite data types for backend functionalities. Show less

Education

  • University of Illinois at Urbana-Champaign
    Master's degree, Computer Science - Data Science
    2018 - 2020
  • Rajiv Gandhi Prodyogiki Vishwavidyalaya
    Bachelor of Engineering - BE, Computer Science
    2004 - 2008

Community

You need to have a working account to view this content. Click here to join now