Prateek Pamecha

Experience

• 

  Oracle India Pvt. Ltd

  Dec 2006 - Mar 2008

  Software Developer

  Languages: Oracle SQL codingDatabases: Oracle 10g databaseWeb Related: Oracle Discoverer ReportsData Warehousing Tools: Oracle BI PublisherTools and Utilities: Oracle Forms

• 

  Birla Corporation Ltd.

  Apr 2008 - Aug 2010

  Software Developer

  Software Development in Oracle D2K and Oracle PL/SQL• Developed Oracle SQL logics like grouping the data, filtering the records or joining the tables for Business SME (Subject Matter Expert) data generation requirements.• As per the requirements from sales department and the supply chain department required to develop Oracle program units like PL/SQL blocks, Oracle functions or Oracle Stored procedures.

• 

  Coforge

  Aug 2010 - Apr 2012

  Senior Software Developer

  Senior Software Developer, support Oracle 6i D2k, software development in Oracle Fusion 11g forms. Expertise in the 6i forms to 11g forms migration. Development experience in APEX.• Performed Oracle Forms, Reports and Oracle objects Migration from Oracle 9i Database to Oracle 10g Database by testing each Form or Report module after migration and fix those by writing new compatible code logic which were causing issues.• Migrated Oracle data from Oracle 9i Database to Oracle 10g Database which required creation of automated scripts to transfer data in bulk.• Developed code for Oracle Forms 6i to Oracle APEX migration by creating an understanding of functionality and recreated each module in APEX environment.• Written code from scratch in Oracle PL/SQL for new business functionalities.• Participated in post migration activities like code review, data validation and Database Tuning for the new database environment. Show less

• 

  British Airways

  May 2012 - Nov 2012

  Technical Consultant

  support Oracle 6i D2k, software development in Oracle Fusion 11g forms. Expertise in the 6i forms to 11g forms migration. Development experience in APEX. UNIX scripting development experience.

• 

  NIIT Technologies Limited

  Dec 2012 - May 2016

  Technical Analyst/Team Lead, Oracle PL/SQL Developer

  2012 to 2016 Airline Domain: Projects British Airways and Monalisa2016 to 2017 Investment Banking Domain: Project• Developed Oracle Advanced PL/SQL coding like writing collections, PL/SQL tables, arrays, pragma logic scenario, exception handling, bulk collect (for all, update all, insert all), exception handling for bulk functions, cast function, table functions etc.• Performed Database Tuning for the oracle code by creating oracle indexes, Hints, table partitions, partition swap, Index partitions, partition joins, explain plan, SQL tracing, gather statistics etc.• Worked on Oracle Data warehousing by determining design of table structures, primary keys, foreign keys, analyzing data and determining the normalization level needed, maintained data integrity, schema creation etc. Show less

• 

  SEI

  May 2016 - Jan 2018

  To understand/analyse SEI business requirements and create a technical documentation. Read and convert JASON to analyze data fetched from API’s. I was involved in development of Oracle modules (Price, Transaction, Taxlots etc.) for SWP (SEI Wealth Platform [Backend Oracle, Frontend Java]), restAPI implementation (Spring), configure Maven to download all dependencies. Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE. Translated business/functional requirements to create and alter database objects like Tables, Indexes, Constraints, Indexes, Types, Triggers, Grants, Synonyms and Stored Procedures. Generate JASON objects from Oracle database for API’s. Show less

  • Oracle Technical Specialist, Oracle PL/SQL developer

    Jun 2017 - Jan 2018

  • Technical Analyst/Development Team Lead

    May 2016 - Jun 2017
• 

  Wells Fargo Advisors

  Feb 2018 - Oct 2020

  Technology Specialist/Data Analyst, Oracle PL/SQL developer

  • Creation of business and technical requirements for the projects.• Setup Agile methodologies like creating stories and tasks along with estimations.• Apply Data Integration using INFORMATICA mapping, transformation logics, ETL JOBS between Advantage (Fee data), SEI (Oracle based), Trust3000 (DB2) and BIS(DB2) to create analytical environment.• Analyze/ modification/ creation of UNIX batch jobs using UNIX shell scripting and AutoSys.• Schedule ETL jobs in AutoSys, schedule NDM to transfer the files to Dropbox or at client folder via SFTP and reviewing ALM test case scenarios.• To create interface for Tableau reports and fetch data from Wealth data views. Worked on the requirement to developing/testing/configuring restAPI (Spring) [configure Maven to download all dependencies].• Analyzing data by preparing the complex SQL queries or preparing business reports on demand. Understanding the table data based on data history, surrogate keys, foreign keys or join conditions, relation with master tables.• Create JASON objects from Teradata for API’s. Read and convert JASON to analyze data fetched from API’s.• Importing data from XML files into oracle database using XMLTABLE.• Created requirements for development of tableau reports on top of Wealth data views at the same time participated with Tableau developers to prepare reports and review the final versions.Permanent Payroll on Synechron and contract on WellsFargo. Show less

• 

  Citi

  Oct 2020 - now

  Associate Principal Technology

  Working as a Principal Technology, Senior Oracle PLSQL Developer / Data Architect with client Citibank. Performance Tunning, Datawarehousing, Spark, Python development.Also involved in Github Copilot PROMPT Engineering, Autosys,Data Migration, IBM S3, Hive.Employee of Synechron and contract with Citi.