Senior Software Engineer
Sears
Total years of experience :8 years, 2 months
Integrated Demand Replenishment and Planning (IDRP)
IDRP is responsible for Inventory planning, forecasting, managing promotions, and replenishment. As a developer, my key goal was to automate Inventory planning, forecasting and replenishment, which is the heart of supply chain management.
• Worked with Business to understand the requirements in Supply Chain domain, and developed applications for Inventory Forecasting, Item Replenishment/Allocation, Order Generation, and Promotional event management.
• Developed complex PL/SQL Packages, Procedures, and Functions to implement business logic.
• Used on Performance Tuning, Collections, Records, Cursors, Triggers, Ref cursors, BULK LOAD for data manipulation, validation, and loading.
• Created ETL scripts, to load files from external sources (HADOOP, DB2, and TERADATA) into Oracle External table, and transformed the data for loading into staging and final table.
• Involved in the continuous enhancements and fixing of production problems.
Technologies: Oracle 11g, Hadoop, HDFS, Unix, PL/SQL, SQL, ETL, JDA, Control-M
Midmarket Campaign Management
Midmarket application develops and maintain the customer’s database for clients in all sector of market, mostly into advertisement, postal services and campaign management. As a developer, my key goal was to write ETL scripts to Extract, Load, and Transform data from UNITED STATE POSTAL SERVICE database onto our Customers Database to give our clients the best way for campaigning and identifying new opportunity to bring in more customers.
• Worked with onshore team, to collaborate development and support tasks.
• Developed complex PL/SQL Packages, Procedures, and Functions to implement business logic.
• Created ETL scripts, to load files from external sources (Flat files mostly) using SQL*Loader.
• Worked on performance tuning, used HINTS, table partitioning, INDEXES, HASH Joins to improve performance of large volume load.
Technologies: Oracle 12c/11g/10g, Unix, PL/SQL, SQL, ETL, SQL*Loader, Agility
ACCENTURE POST TRADE PROCESSING (APTP) - SOCIETE GENERALE
APTP develops and support key post-trade processing functions such as settlement, books and records, asset servicing, operational management and control, real-time data access and administrative accounting, leveraging collective trade volumes to reduce costs per trade and provide real-time information regarding overall trading activity.
• Worked with Functional owners to understand the requirements in trade booking application.
• Created Technical Specification Documents as per the requirement gathered from functional owners.
• Developed complex PL/SQL Packages, Procedures, and Functions to implement business logic.
• Worked on Oracle Forms & Reports, which was the UI interface for trade booking.
• Created UNIX shell scripts, to call SQL scripts and scheduled them in $Universe job scheduling tool.
Technologies: Oracle 10g, Unix, PL/SQL, SQL
Geoinformatics is the science and technology which deals with Information technolgy to address the problems related to earth science. My degree is equivalent to Msc. Applied Geology. I have good hold in Geology, Geography, and Information technolgy. I have done several projects which includes working on software like Erdas Imagine, ArcGIS, Mapinfo. Done internship from ONGC, Ahmedabad. The project title was Subsurface Mapping, Well logging.
2008 All India Senior Secondary School Examination ISC William Henery Smith Memorial School, Varanasi 70 %
2006 All India Secondary School Examination ICSE William Henery Smith Memorial School, Varanasi 78.17 %