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 functional delivery end to end(4) Defining testing requirements together with the QA team(5) Building and maintaining strong relationship with business to ensure alignment with business requirements and project management resources(6) Establishing and operate within the governance (decision making) structure for the program/project and manage/escalate issues and risks.(7) Contribute in design and development of the project-level roadmap, ensuring sufficient business benefit is realized within each phase.(8) Ensure projects are completed according to product specifications and are properly documented.(9) Work with data sourcing to source and validate data completeness from acquisition to report delivery.(10) Work with Stakeholders during UAT to ensure reports meet requirements and ensure all deliveries are signed-off.(11) Act as an SME in various capacities and product development opportunitiesNov 2017 to Feb 2019: BMW of North Americas, New jersey(1) Work with Aftersales division of BMW to construct better dealer management program to drive revenue growth.(2) Managed & organized product development using Agile framework values and principles.(3) Responsible to ensure correct understanding of requirements, translated them into technical deliverable and then owning the functional delivery end to end(4) Defined testing requirements together with the QA team.(5) Built and maintained strong relationship with business to ensure alignment with business requirements and project management resources.

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 and Remove Duplicates stages.• 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.• Created Extract, Transform and Load (ETL) interfaces and gateways for backend database.• Involved in the migration of Datastage jobs from development to QA and then to production environment.• Collaborated with Project Managers to provision estimates, develop overall implementation solution plan. • Designed business solutions and data visualization applications with many interactive and user-friendly features using Oracle Apex 4.2 technology, Javascript, Jquery, CSS3 and HTML5 code snippets.• Architected Authorization system for Applications which includes interplay of Datastage, XML, Autosys jobs and Oracle SQL queries.• Conducted functionality demo sessions for IT and Business Users.• Managed seamless delivery by coordinating with teams located across different geographies.Application Support• Performed various application & query performance tuning to improve data fetch for reports.• Oracle Database upgrade from 10i to 11g• Created Python, Unix Shell Scripts (Kourne and Bash) for maintenance activities such as to archive the files periodically and data sanity check• Created diagnostic scripts using unix shell programming. • Provided customer support and resolved deployment as well as implementation issues.

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 access to asset management data.• 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.• Created new templates and modified existing templates for various button, region, list, etc.• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.• Liaising with end-users and 3rd party suppliers. Collaborated with Project Managers to provision estimates, develop overall implementation solution plan. Managed seamless delivery by coordinating with teams located across different geographies.• In agile methodology, learned and practiced various attributes such as scrum stories, scrum meeting, planning, review, retrospection.• 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 and Remove Duplicates stages.• Involved in the migration of Datastage jobs from development to QA and then to production environment.

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 was used to track, rename, reuse & minor amendments for database scripts. This application reduced effort to prepare for database deployment.• 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 administration) and Data Migration/ Extraction activities.• 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 Project Managers for periodic project status (efforts, SLA, resource utilization, estimations, etc.) updates.(4) Onsite counterparts for various change requests, necessary monitoring tasks and regular support activities.(5) Team members across location for design of application and service delivery for large-scale, complex environments.• 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 and user-friendly UI features of Oracle Apex(4) Designed and planned the business solution by translating business requirements into many interactive and user-friendly UI features using Oracle Apex technology.(5) Completed 6 APEX Applications through the entire cycle of development, deployment & maintenance(6) Expertise in Database Design/ Re-design, creating new reports, new charts & forms(7) Developed prototype for Apex application SLA Tracker; - It included various levels of configurability to load Master Data - It included 2 Display Modes; First mode was auto scroliing dashboard and other was regular tabbed portal

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 market sector (India) • 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. • Conceptualized, developed and implemented a parallel transaction system. The development incurred 37% rise in Annual Maintenance Contract to Idealake. • Streamlined technical system monitoring policies for the as a part of proactive maintenance, client to reduce system outages by 55% in year 2007-08. 2. Client: Banking Sector (India) • Planned and implemented database restructuring activity for the client and provided necessary support with a team of 3 database administrators. • Assessed overall business requirements and documented business specification for restructuring activities in coordination with IT division of the Client. 3. Client: Investment Management Sector (India) • Designed database system for 2-Tier web-based application for and documented the technical and functional specification. • Set technical system monitoring policies of the client as a part of New System Implementation.

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