Janani Chilamakurti

PROJECT 1:

• eSpear is an integrated, event-driven, exception-based platform for processing securities transactions for the Corporate and Investment Banking (CIB) businesses.
• eSpear has been developed as a number of components which work together to provide the straight-through processing functionality. The architecture solution for eSpear is designed to accommodate the demands of growing business.

Primary Focus:

• Off Shore Level 3 Support
• Ongoing support for production and application
• Restoration and Resolution of Incidents & Problems within the expected timeframe as per the criticality.
• These tickets would be raised by Level 2 support through the tracking tool dbSymphony.
• Provide responses to the service queries, while utilizing expertise of the existing Key Business Users.
• Provide responses to Ad hoc Requests and generate Ad hoc reports as per the client’s requirement.
• Debugging in Java/ PL SQL and Unix Shell Scripts.
• Troubleshooting and providing effective and efficient solution through real time customer handling.
• Handled minor and major enhancements.
• 
  

PROJECT 2:

• Performed Data/Spend Analysis for multiple clients, commodities, manufacturing sites (Internal & External) to identify cost savings
• Developed overall project plan including timeline, scope of work, work breakdown structure and associated deliverables
• Involved in complete Data mining process such as Data Classification, Data Normalization and Standardization, Data Cleansing, Data Enrichment, Attribute Value Extraction and customized product descriptions for both structured and Unstructured data
• Extracted and Validated clients spend data
• Dashboards: Created visually impactful dashboards in Excel and MicroStrategy for Data reporting by using PIVOT TABLES and VLOOKUP in Excel to identify key metrics and transform raw data into meaningful information and to identify potential saving opportunities
• Using Clients' Taxonomy rules, classified and normalized data for better spend management
• Used SQL queries and Excel for data cleaning, transformation, profiling data which is extracted from various data sources
• Resolved issues (customer/internal) with processed data effectively and efficiently
• Performed Support role for internal tools and applications.

• Purchasing imported material from international vendors is required for our manufacturing unit according to specifications and technical rating raised by our team
• Make all purchase orders through an SAP oriented database and whole processes is updated through SAP only
• Raising requests for material required to international vendors through mails and negotiations for material that need for a better price
• Verifying the HS codes (CTH) of import material as well as the customs payment to the import material and seeing that we have the product is at our specified price
• Will search for an alternate with the same rating and that matches almost all the technical specs as mentioned by our material request team if the material is not available.

• Attending Electrical panel Inspections, Testing etc., at Vendor works representing our Company
• Issue of Enquires, Technical reviews of the quotations received, release of LOI, Purchase Orders and Work Orders
• Coordinating the Consultants/ Suppliers and Site to implement the changes proposed and to have latest revised drawing for releasing for manufacture or construction
• Arraigning the meetings with Consultants/ Vendors and finalizing the issues along with GM projects and Superiors
• Checking the BOQ of the material as per drawings & documents approved
• Material reconciliation as per receipts and BOQ approved in addition to technical requirement
• Verifying the invoices from the vendors as per PO and recommending for release of payments
• Visiting the site every 3 weeks to prepare Detail Project Progress report every month for submitting to the Government of Maharashtra
• Preparation and finalizing the 132/11 KV Switchgear package for plant switchyard as per MSEDCL approvals
• Purchases of electrical items required and in the scope of the Company for total completion
• Project progress review and forecasting the site requisites
• Co-ordination with all the Vendors i.e., Boiler, Turbine, Cooling tower and ESP etc for smooth and total completion of the Project
• Preparing transit insurance coverage to the equipment under major packages purchased and to follow
• Day to Day Coordination of Site work and progress to report MD
• Fully associated in the work from proposal level to get clearances and benefits of CDM
• Followed with Airport authority of India for getting clearance and erection of Chimney height around 63mt at Akola
• Handled The Entire work for ISO i.e.,
• Document Submission
• Attending Audits
• Briefing Management Representative etc., until ISO certificate is obtained.