Jayamin Amin Email & Phone Number

Melville, New York, United States

Melville, Ny

Greater New York City Area

Created multiple applications utilizing Scrum to streamline and optimize business processes. Enhanced & addressed bug fixes for existing applications using Kanban. Oversaw/trained three Liberty staff Systems Analysts Overhauled previously time-intensive, ad hoc system for data entry required on new policies, which lacked a centralized resource to access key actuarial and client information with ease. Designed custom application for SQL Server to store three main sets of insurance policy data (policy holder/client information; policy quotes/pricing and actuarial rating information) as binary data with database architecture in SQL Server and front end user interface in Access/VBA. The application automatically populated standardized fields in the frequently-used documents with data stored on the SQL Server Optimized the Firm’s approximately 500 US-based Financial Advisors capacity to identify and customize their pitches in order to cross sell a variety of both commercial and retail insurance products to existing clients. Created/launched a SharePoint site, with an Access/VBA frontend that filtered products based on client criteria, limiting the recommendations to only those relevant to that client’s business Completed this project in half of the originally allotted 18-month timeline. From the first rollout/feature launch to Q1 2018, the application helped increased US sales to Retail insurance clients by ~ 43% and boosted Commercial sales by ~ 36%. Set up process whereby this application would be rolled out to Liberty’s global offices, eventually accessible to over 50,000 end users

New Hyde Park, New York

Northwell Health one of the nation’s largest health care systems with 23 hospitals, and 665 outpatient facilities Consulted for Northwell during a time when the company was rapidly expanding through acquisitions. One challenge in integrating the new facilities into the broader company was that the acquired hospital systems’ Procurement groups each had pre-existing relationships with medical supply/device vendors, all with varied terms and a wide variance in prices charged from one facility to another. Responsible for pooling this vendor/pricing data and creating tools that enabled easy contract/price comparisons. Project facilitated streamlined negotiations with vendors, resulting in optimal pricing terms for Procurement groups across all of Northwell’s facilities Wrote custom logic in VBA that allowed the Access front end to point to different servers for development and UAT, before releasing a production version to Analysts. Worked to complete Client’s data warehouse and then created a data mart for the General Procurement Office’s application. Designed, developed & deployed multiple SSIS packages for ETL processes, loading data from PeopleSoft (Oracle), and vendor Excel files into the GPO’s SQL Server database and data mart. Trained Client’s IT department on the uses of SharePoint as a web-based collaboration and BI tool. Utilized Kofax Insight for BI and reporting for data warehouse and data marts

New York, Ny

Created a SQL server database for project information, tracking of all tasks pertaining to multiple, interstate relocations of Enterprise data centers. Utilized SharePoint to create multiple custom sites, worked with Life Cycle Management/Logistics and Investment Banking departments to automate their various scorecard, dashboard, and project tracking reports The front end, used by Project Managers, Systems Analysts and various on-site technicians, was an Access database which had custom VBA automation to export data to Excel and create pivot tables, charts and graphs dynamically Managed/oversaw workflow for a team of over 50 technical staff located in Pune, India. My fluency in Hindi, and ability to conduct business in team’s native language (instead of English) added significant value, ensuring efficient communications and better comprehension of goals and instructions Pune team was responsible for utilizing SharePoint to track timing and logistics pertaining to when each of hundreds of servers and databases would be decommissioned and the servers physically transported to their new geographical location. Oversaw their work in coordinating with US Logistics/Operations staff (onsite Engineers, installation at new locations, etc.) Group was also responsible for the timely notification of all business-line end users of shut down timing to ensure uninterrupted service

Deployed CranSoft, a custom application written by BackOffice Associates, to manage data migration for a wide range of clients from a wide variety of industry sectors, including healthcare, pharmaceuticals, luxury beauty as well as state and local public-sector service departmentsCranSoft facilitated the re-integration various forms of legacy data, cleansed and business ready, for each client (for example, data from multiple product lines, or data from businesses acquired by a parent company etc.). The data was recursively cleansed (using cleansing rules created as views and stored procedures within Microsoft SQL Server 2000/2005/2008) and then loaded into the Client’s SAP, Oracle, or other ERP systemsClient projects:Merck & Company, Inc –Partnered with Firm data migration team in major project loading SAP training environment from Client legacy systems. This included thousands of records for Client’s consumer/OTC object pricing, contracts/sales orders, purchase info records and source listsEstée Lauder Companies–As Application/Server Administrator & ETL developer, installed/upgraded CranSoft and WebApp applications on all migration servers. Responsible for accelerating the execution of Client’s 36 month historical data (SellIn) process. Previously, the cleansing of millions of records took Client between 24-36 hours. By overhauling the process through the introduction of multithreading, utilizing stored procedures, SQL Server Jobs, and VB Scripts, reduced this time by 75%+ : to between 6-8 hours

As Senior Consultant, responsible for writing statement of work (SOW), full lifecycle project development, project documentations, designing unit test cases and frequent interaction with Fortune 500 clients such as UBS, Motorola and Chevron, among others. Simultaneous to Client-facing role, also managed a group of 10 BearingPoint employees, overseeing their work at client sites, coaching/training and providing year-end performance reviews. Client projects:Motorola–Lead Developer: Developed a BLAST (Bulk Loading Application and Support Tool) application written in Visual Basic 6 and Access. Required understanding Client’s business logic and applying this logic to create and modify database architecture and queries used to extract data from the Access database. The output allowed the opening of ports within a Cisco or Motorola router. Followed topology in opening a network, node, shelf, slot, and port (NNSSP), thus allowing a connection to pass throughChevron Phillips Chemical–Manager/Lead Developer: Led team in creation of a profitability model-MOS/Budget application which utilized Access, VBA, Excel, and source data in Excel extracted from SAP. Model generated Excel pivot table data values (volume, netback, feedstock margin, variable cost margins, operating gross margin, EBIT, etc.) by programmatically calculating data in VBA from Access and then inserting Excel formulas into the pivot table

Responsible for writing statement of work, full lifecycle project development, and reports that incorporated Optimal Mark Recognition (OMR) software used by the mail and document management industry. These applications allowed Pitney Bowes’ clients to use high-speed envelope and document printers with OMR sensors to better consolidate and sort statements and other direct mail projects to their customers

Maintained and enhanced the database architecture, used for project management, scheduling and event timelines of Continuing Medical Education meetings/seminars attended by physicians. Managed team of four Programmers to design a web-based graphical user interface (GUI) for the database

Wrote statement of work (SOW), full lifecycle project development, project documentations, designed unit test cases, and carried out implementation at Client sites through presentation and product installation

Masters, Computer Science, 3.9

Bachelor, Business Management, 3.2