NISHANT KARIYA

• Designed solutions for various data problems in portfolio.
• Lead Engineering forum (Ambition 5) within CFO space.
• Lead Devops migration of complete portfolio to GitHub and Jenkins.
• Designed and developed many solutions for portfolio for enforcing standards. (like control-m standardization)
• Developed utility to reduce control-m costs in portfolio.
• Actively monitored and helped reduce unnecessary storage space of 22 TB from servers.
• Lead very first compute migration on snowflake, of one of the datasets (Transfer Pricing) in EMIS. with zero UAT issues.
• Oversight complete Platform as a technical architect, providing solutions to multiple datasets.
• Lead New Products Initiative in CFO data space and helped team to onboard data of many new products like CLO and Bitcoin.
• Developed complete TAL system (Tactical Assets Loader) along with leading it for small integrations.
• Handling Enterprise Sales & Assets program currently.

• Migrate legacy Informatica code to pure SQL and PLSQL code.
• Examples include converting a informatica workflow consisting 6 mappings and 6 intermediate tables to one SQL code with 1 table and make it dynamic for processing any time range of data.
• Run Data Chapters in the portfolio.
• Develop new data refresh strategy for portfolio to refresh only needed schemas instead of full database.
• Analyzed, Designed, Developed and Lead complete new dataset i.e. Distribution Analytics from scratch.
• Integrate new dataset with others.
• Represent complete Corporate Enablers Portfolio in Engineering Catalyst forum.
• Part of Data Guild community and helped solved various data problems and challenges.

• Develop and manage data of major dataset, i.e. REVENUE, of EMIS (management reporting product).
• Source data from multiple sources and analyze data to combine them in intermediate layer.
• Write transformations in Pure SQL to transform data in application layer.
• Write views and secure them, for usage in various reporting tools like - OAS, Alteryx etc.
• Lead technical team and define architecture of new integrations.
• Design and Develop new manual revenue sourcing system - RCS
• Own data from source till it reaches both Financial and Distribution revenue datasets.
• Performance tune existing solutions.
• Transformations converted from 3 hours to 10 minutes and reporting converted from 5 minutes to 5 secs.

• Develop and manage data of multiple banking projects like CitiBank, Bank of Montreal, Bank of Canada etc., using Oracle Database.
• Lead performance tuning of all projects.
• Lead and Architect solutions for data migration from legacy systems of SYBASE or other databases to Oracle.
• Understand financial requirements and convert them in to technical scope documents.
• Impart training on data management, performance tuning in organization.

Load and Transform Data for No1 Electronics Part Catalog, used by almost every major automobile OE like - John Deere, Chrysler, MOBIS, ISUZU, SUZUKI, GM, Subaru, Hyundai and many more.

• Understand RAW OE data received in multiple formats.
• Load data in database via automatic pipelined and manual loads.
• Analyze the dataset and convert it into meaningful information in Intermediate Layer.
• Transform the intermediate data in to centralized repository (normalized schema), by writing complex pure SQL code.
• Configure ODI(Oracle Data Integrator) environment for the project.
• Map various data source in to target in ODI
• Configure knowledge modules of ODI for the project.
• Use APEX to enter and maintain metadata.

• Develop & Implement ERP made on Oracle Forms & Reports.
• Coding on Oracle SQL / PLSQL, Forms & reports.
• Handle Clients (both Domestic and International).
• Test the final developed product
• Deliver and take sign off.
• Explain users about working of ERP by being at client site and implement customizations as per their business needs.