Advait Sawant Email & Phone Number

Boston, Massachusetts, US

Noida, Uttar Pradesh, IN

Bridgewater, New Jersey, US

Feb 2019 to Sep 2020: Deutsche Bank, New York(1) Creating and maintaining functional requirements in partnership and collaboration with the business and obtaining sign-off(2) Responsible for creating functional solutions, conducting FSD walk-through and obtaining sign-off(3) Responsible to ensure correct understanding of requirements and then owning the.

Teaneck, New Jersey, US

• Application Development
• Created asset data management applications for business intelligence and reporting purposes.
• Developed datastage load and extract jobs using various stages like Oracle Connector, Funnel, Transformer stage, Sequential file stage, LookUp, Join and Peek Stages. Also, used Sort, Merge, Aggregator, Peek, DataSet.
• Performed debugging on these jobs using Peek stage by outputting the data to Job Log or a stage.
• Used Datastage Designer to import/export jobs and table definitions.
• Responsible for creating detailed design and source to target mappings.

Teaneck, New Jersey, US

• Working as senior system analyst to create suite of data management applications for business intelligence and reporting purposes. These applications provide business users, privilege and approval driven controlled.
• Scoped, planned and designed the business solution with many interactive and user-friendly features using Oracle Apex 4.2 technology.
• With efficient use of Javascript, jquery and PLSQL (Collections and Control Structures) developed various value adding features in applications.
• Created custom authorization schemes, custom security roles and features for various hierarchies of end users.
• Created different types of Processes, Validations, Computations (Page level as well as Application level) for various process points such as before/ after header and on-demand.
• Created Interactive as well as Classic report with features such as drill down & page linking.

Teaneck, New Jersey, US

• Designed LDAP login based, database deployment tracking application with many interactive and user-friendly features using Oracle Apex 4.2 technology, Javascript, Jquery, CSS3 and HTML5 code snippets. This application.
• Followed Agile/Scrum methodology in project development.
• Responsible for Deployment, Production Support, Customer Support and support to other related teamsfor key activities like UAT.

Teaneck, New Jersey, US

• Expertise in:(1) Performing lead roles such as Solution Architect and Project Lead(2) Designing and implementing projects involving Oracle Application Express, Oracle SQL- PL/SQL, UNIX (Shell scripting and system.
• Involved in interaction with(1) Managers for Incident, Change, Problem & Release during various relevant phases of project execution.(2) Internal and external auditors for conducting periodic project audits.(3) Matrix.
• Oracle Apex Experience includes:(1) Oracle Apex 4.1 & 4.2 Installations (EPG) (2) Varied Applications development for Life Sciences using Oracle Apex 4.1 & 4.2(3) Planning the business solution with many interactive.

Teaneck, New Jersey, US

Client Requirement Analysis for Life Sciences domain Client for Onsite - Offshore implementation model.

Hong Kong, HK

Parel, Maharashtra, IN

• Developed forecasting and scoping plans of project quarterly and during end of year for devising Annual Maintenance Contract in co-ordination with Project Management Office.
• Structured pricing with Design, Application development & Quality Analyst Teams as required, based on project specification and budgetary constraints for 3 client accounts.
• Mentored a team of Database Administrators at Idealake to work on Oracle and Microsoft SQL Server to perform regular system health monitoring, product development/support and Client Interaction. 1. Client: Capital.
• Developed operational project plans as required to meet overall project specifications. These plans consider resource based costing as per Annual Maintenance Contract.
• Structured a Comprehensive Implementation quotation for bidding web based secure E-Voting project essential for financial depository operations at the client.
• Planned and implemented technological and functional activities in co-ordination with the client’s technology management team.

London, GB

• Generated diagnostic scripts and maintained a knowledge base in the format (issue-symptom-verification-remedy) for each issue to speed up the troubleshooting of reported issue.
• Maintained knowledgebase of technical and functional specifications of developed/ supported task orders. This avoided duplication of efforts for similar tasks.
• Analysed the client data and drew necessary insights for business development division
• Acquired technical knowledge of Pro*C programming, Oracle/ PL-SQL and Unix.
• Provided telephonic/off shore customer support in order to resolve onsite implementation issue.

Mba, Management

Bachelor Of Engineering, Instrumentation