➢ Develop/Modify Code Base for 4 banners i.e. Saks.Com, SaksOff5th.com, LordandTaylor.com and thebay.com.

➢ Create new feeds using SQL files and Shell Scripts for third party vendor for website improvement like Salesfloor, Rich relevance, Shop-runner, Vendornet, Commerce-Hub & Onera.

➢ Create/Modify new/exsiting ETL process as part of Product/Item Setup which involved transferring data across 3 RDBMS database (Oracle, DB2) and NoSQL Database (MongoDB)

➢ Write DDL scripts to create new Database Objects like Tables, Views, Sequences, Synonyms and indexes.

➢ Extract data from multiple source using ODI (Oracle Data Integrator)

➢ Extensively used ODI (Oracle Data Integrator) ETL tool to create Dataware housing OLAP model.

➢ Worked with multiple sources such as Relational database, Flat files for Extraction, Transforming and Loading data into target tables.

➢ Work/Tune on long running batch process escalated by helpdesk/operations team as part of engineering team. Also provide performance the long running PL/SQL and SQL Blocks.

➢ Work on various tuning effort for the existing production code.

➢ Create new product attribute in Blue Martini as part of product enrichment process and push the same to website.

➢ Perform end-to-end Migration for banner to PIM (Product Information Management) Database.

➢ Created several feeds/script for OMS (Order Management System) consumption by replacing existing long running process as part of migration to OMS.

➢ Work on various project at the same time, which involved in taking part in daily standups, time keep, meeting deliverables and avoid escalation.

➢ Work closing with Business/User for creating BRD, FSD and DTD for new/ongoing projects.

➢ Scheduled various job for newly created script using Automic/UC4 scheduler.

➢ Take part in ON-CALL rotation involved in providing 24*7 support for monitoring/troubleshooting of batch job failures.

➢ Develop/Modify Axiom Objects like Datasource, Datamodel, Portfolio, Aggregation, Tabular Report, FreeFrom Report and user define function as per requirement.

➢ Work on PROD workflow failures as part of L3 Support for the various Axiom Platforms i.e. Axiom US Reg, Axiom COREP, Axiom FINRep and Axiom BOE.

➢ Provide in-depth analysis of Adhoc User queries escalated by Business as part of BAU submissions.

➢ Troubleshoot various data related user queries in US FED reports i.e. FR2900, FR2644, TIC BC, TIC BL1/BL2, TIC BQ2/BQ3, TIC S, TIC SHLA, TIC SHCA, FRY9C,FOUCS, FRY15, FRY12, FRY7N, FFIEC0002, FFIEC009.

➢ Helped in User creation and granting them permission for Axiom UI.

➢ Create/Modify Autosys batch confirgurations for new/existing reports.

➢ Help user in refilling TIC report based on changes in the Stock Records.

➢ Created Oracle Packages for generic use such as moving of data to compressed tablespace, determining the date, error logging which were called from Datasource.

➢ Wrote queries to extract data from XML columns in order to debug issues and check table space usage.

➢ Monitoring and handling of Batches through Autosys and provide end to end solutions for production issues.

➢ Manage/Led the team of 4 at client site for smoother delivery of BAU.

➢ Develop complex SQL queries for data retrieval from various database objects including tables and views for daily usage on known issues.