MetaSys Software Pvt. Ltd.

61/514 Unnat Nagar
Goregaon (W)
Mumbai, Maharashtra 400 062
India

P: 1 312 235 2685 (USA)
F: 1 208 379 2924
E: sunilc@metasyssoftware.com
W: http://www.metasyssoftware.com


est: 1996

Custom Web application Developement with FileMaker 11, 10, 9, 8, 7 certified developers and skills in .Net, PHP/MySQL/Ajax

MetaSys specializes in providing custom software development services to clients across the globe. A team of 13 developers (5 FileMaker certified) are equipped to handle desktop and web applications. Under the MetaSys banner, we have more than 30,000 hours of FileMaker development experience.

The broad base of projects we have undertaken are
1. Migration from earlier versions to FileMaker 9
2. Web applications using PHP API
3. Desktop development on FileMaker Pro 9 and FileMaker Advanced server

Our claim to fame is
- Wide variety of domain expertise
- Good documentation practices
- Well defined processes
- Systematic testing
- FileMaker Certified Developer as a Project Manager
- Good References
- Client base in USA, UK, Australia, Canada, Japan & Bermuda

FileMaker Pro Certification

This area lists any/all applicable FileMaker development certification(s). Certification is officially sanctioned by FileMaker Inc and all developers who qualify have completed and passed the official exam for the specified version of FileMaker Pro. Certification covers competency in the areas of general development as well as server-based aptitude..

 FileMaker  Certified Developer  - FileMaker Certified Developer
 FileMaker  Certified Developer  - FileMaker Certified Developer
 FileMaker  Certified Developer  - FileMaker Certified Developer
 FileMaker  Certified Developer  - FileMaker Certified Developer
 FileMaker  Certified Developer  - FileMaker Certified Developer

FileMaker Trainer

This company offers a wide range of services to help people expand their FileMaker knowledge. While some companies offer training through formalized class or seminar formats, other companies focus more on individual needs through remote and on-site instruction. Where “FileMaker Training Series” is checked, these trainers have successfully completed course requirements authored by FileMaker Inc. and teach seminars geared specifically toward persons obtaining certification.

 Security Practices PHP Training

FileMaker Specialty

A list of specialties, or areas of discipline within the FileMaker development arena

 Buttons Custom Functions ESS Export Data Excel Migration Import Data Layout Design Report Creation Scripting

Concentrations

This section includes a list of core competencies (as it relates to FileMaker development) where the company has a proven level of experience or offers it as a trademark skill.

 Higher Math Statistics Citrix Security Server Needs Determination Needs Analysis Data Modeling

Database/Languages

This section illustrates the computer languages used to make queries into databases and information systems. When checked, the company has working knowledge and/or advance aptitude in that particular language.

 FileMaker Access AppleScript ASP C+ Excel Java MySQL MS SQL Server Oracle ODBC SQL Visual Basic 4D

Remote Control/Access Support

This company can offer support from remote locations using the following technology.

 Apple Remote Desktop Microsoft Remote Desktop PCAnywhere Webex SupportCenter

Web Technology

The following list includes all technologies especially suited for web development -- building, creating and implementing web sites as well as sites with a Db backend.

 PHP FX.PHP FileMaker PHP API Custom Web (CWP) Instant Web (IWP) Flash .net java javascript css xhtml xml xsl html email smtp pop imap AJAX  xslt

Web Hosting

This company offers web hosting. See below for the available options.

Platform

A platform describes the type of hardware architecture or software framework (including application frameworks), that allows software to run. Typical platforms include a computer's architecture, operating system, programming languages and related runtime libraries or graphical user interface.

 Mac Windows Windows Mobile CE

Professional Accreditation & Affiliation

The following includes professional agencies, organizations and/or groups where the company is an active member.

 FMPug Network FMForums Microsoft Certified FMPug Vendor Network FileMaker Technical Network (Technet)

Clearances

A security clearance is a status granted to individuals allowing access to classified information. The term "security clearance" is also sometimes used in private organizations that have a formal process to vet employees for access to sensitive information. Anyone with access to classified data requires a clearance at or higher than the level the data is classified at. For this reason security clearances are required for a wide range of jobs, from senior management to contractors and sub-contractors.

Location Preference

This section illustrates the company’s preferences as it relates project location and travel requirements. Certain companies prefer to omit long distance travel, while others are willing to commute daily and spend their time directly on-site.

 Full Time On-Site Remote Travel As Needed

Language Support

 English English Hinudtani Hinudtani

 

Bio for Sunil Chavan

Bio for Padmaja Umrani

Summary ¥ Total 10 years of experience in software industry. ¥ File Maker Pro 7 Certified Developer. ¥ Created and managed a team for new technology for FileMaker and 4D 2003. ¥ Experience in handling all offshore projects, primarily from USA ¥ Complete application life cycle expertise from requirements study, data modeling, analysis, design, development, testing to implementation ¥ Software development for CMM level 3 ¥ Extremely short learning curve ¥ Seattle, WA for 8 months for implementation and release of the product, frequent visits to the offshore clients based at Bermuda and USA for requirement analysis Software Project Details (FileMaker Projects Only) Project: Web application for Biomedical Institute, based at USA Technology: FileMaker Pro 7.0, FM Pro server advanced, XML-XSLT Solution: Web application, to create and manage the Trouble Tickets for patients and monitor the status. Each Trouble Ticket consists of one or more problems. Users in various roles and with appropriate authentication, assign the problems to appropriate authority. Further, the system keeps track of each assignment and the action taken for each problem. The web application was developed using CWP and XML-XSLT. I was involved in the Management, Quality Control and Delivery of the project. Project: Client and Project Tracking system for Public Relations company, based at USA Technology: FileMaker Pro 7.0 Solution: A custom software to help manage the media contacts and correspondence. The application is developed using FM Pro 7.0. In addition to the standard features of adding and managing data, search screens, list screens, filers and portals, the software provides e-mail feature. The software helps the user to export desired data into merge file format. The user is also able to import data into the database from another database. I was involved in the Design, Development, Management, Quality Control and Delivery of the project. Project: Database development for a Electrical Equipments trading company, based at USA Technology: FileMaker Pro 7.0 Solution: An integrated inventory & equipment tracking application for a heavy duty electric equipment company. The challenge was to create a new relational database maintaining the existing relationships and adding several new entity connections. The application helps the user to create various Custom forms, Bill of lading, Vendor applications etc. for export. I was involved in the Management, Quality Control and Delivery of the project. Project: Construction Project management database development for a company, based at USA Technology: FileMaker Pro 7.0, FM Pro server advanced, XML-XSLT Solution: Database development using FM Pro 7.0 for managing and tracking the construction related projects for the user. The application keeps track of projects, sites, contractors, sub contractors and clients. The application also helps in property auction and facilitates the buyer to examine the property details before putting in a bid. The Web component was developed using FM Pro server advanced, FM Pro 7.0 and XML-XSLT. I was involved in the Management, Quality Control and Delivery of the project. Project: Database enhancement for a leading courier company, based at Bermuda Technology: FileMaker Pro 6.0, 8.5, PHP Solution: This courier company did their entire administration required for an International courier outfit using a large FileMaker Pro based system. We added several web components to the existing database earlier using XML-XSLT and then switched to PHP. I was involved in the Management, Quality Control and Delivery of the project. Project: Inventory Tracking System for a Japanese Sports Car Designer Technology: FileMaker Pro 8.5 Solution: An inventory management system for a car designer, who needs to source non-standard goods from various non-standard sources. The customer vendor was a thin line in this application, because a customer for one car can be a vendor for another part. The aim of the system is to track inventory, raise invoices, updating status of inventory and provide reports showing the true state of the business. I was involved in the Management, Quality Control and Delivery of the project. Project: Italian CRM Migration Project Technology: FileMaker Pro 8.0, XML Solution: This project involves simplifying the complicated database structure being used by the client and converting it from FileMaker Pro 5.0 to FileMaker Pro 8.0. Prior to the migration, we had to identify the entities and all the redundancy had to be eliminated in order to convert a multi file application to a single file. The data migration routines were developed simultaneously to ensure proper data migration without loss of data & integrity. I was involved in the Management, Quality Control and Delivery of the project. Project: School Management System for a school in Switzerland Technology: FileMaker Pro 8.0, XML Solution: The project involved designing the database from scratch along with providing an intuitive User Interface that could be used by Teachers/Students and Administrative users. The project automated the tasks like Student Admissions, Tracking of Student Activities and Schedules and Student Fee Management. It provides access privileges and imports data from the manual system currently in use. I was involved in the Design, Development, Management, Quality Control and Delivery of the project. Project: Online Ticket Reservation System Technology: FileMaker Pro 8.0, XML-XSLT, HTML, JavaScript. Solution: This application is like a shopping cart application, except that the goods on sale are tickets for various entertainment shows in town. Being a web based application it had stringent security requirements and features such as printing reports or sending PDFs via e-mail. I was involved in the Management, Quality Control and Delivery of the project. Project: In house Sales Tracking System Technology: FileMaker Pro 8.5, Core PHP, FM API for PHP Solution: More efficiently a company track sales (leads), higher is likely to be the conversion ratio. This application manages all sales personnel, their targets, sales leads, communication between parties etc. giving a one touch snap shot of the active sales. I was involved in the Management, Quality Control and Delivery of the project. Project: Contact Management System Technology: FileMaker Pro 8.5. Solution: This application manages the contact information of the user. It prints, exports and imports contact details. It manages access privileges for High, Low and medium level users. I was involved in the Management, Quality Control and Delivery of the project. Project: Digital Asset Library Technology: FileMaker Pro 8.5, FM API for PHP Solution: This Application is an online resource for the promotional products industry. It manages various SuppliersÕ details and its respective products details. Each product has its own digital assets like photos, PDFs, videos, podcasts, artworks and templates, case histories etc. The application manages all those digital assets such as creation, deletion, update etc. into the database. It uploads various kinds of digital assets and products data to FTP via the web, sends an email with attachment of Specimen copy of .csv, .xml file for importing data. It supports Creation of New Supplier Account, Duplication of Product, Managing price information for each product and Assign unallocated digital assets to products. The application efficiently manages all these interconnections with easy navigation and user-friendly interface. I was involved in the Management, Quality Control and Delivery of the project. Project: Museum System Cantor Technology: FileMaker Pro 8.5, Microsoft Word. Solution: This System generates, updates and processes the data for various artifacts that come in to the Museum. The complex process involves Generation of data, Generating proper incoming receipts to track various objects, Assigning Artists, vendors, and donors to the objects, Conservation related activities for the objects, Creation of data for actual physical storage of objects within the Museum system, Importing and exporting data from database system to other external supported formats and Reports generation. The highly complex system processes involve data migration I was involved in the Management, Quality Control and Delivery of the project. Project: Contact Management Pro Technology: Windows / Macintosh, FileMaker Pro 7.0 Solution: Contact Management Pro provides a user friendly GUI for managers who can efficiently track interactions between their clients and employees. Contact Management Pro is software that can be adopted by any Company. It assumes that a company may have presence in multiple locations and so may its clients. Thus a company may have multiple addresses / phones and an employee may be part of multiple businesses. Contact Management Pro streamlines the way you do business in order to increase efficiency and provide timely information. I was involved in the Management, Quality Control and Delivery of the project. Project: Comchart EMR Technology: Windows / Macintosh, FileMaker Pro 7.0 Solution: Comchart EMR, the logical evolution of the patient medical record. Comchart simplifies the management of patient information, eliminates redundant tasks, enhances patient care and controls office expenses. Designed to mimic the traditional paper medical record, ComChart is very easy to learn and enables one to build a paperless office. Whereas most EMRs force physicians to maintain their medical records in a format which conforms to the EMR software, ComChart is flexible, infinitely customizable and guarantees that it can be tailored to accurately meet the needs of a physicians practice. I was involved in the Management, Quality Control and Delivery of the project. Project: Fairhaven Technology: Windows / Macintosh, FileMaker Pro 7.0 Solution: A unique locker management system used for scheduling and maintenance of bank lockers. Lockers need to be cleaned / inspected by technicians periodically. Fairhaven was put in use in order to efficiently manage lockers of 200 banks and schedule technicians for lock changes / cleaning / other locker management activities. I was involved in the Management, Quality Control and Delivery of the project. Project: In house Mutual Funds Investment System based on banking domain Technology: FileMaker Pro 8.5, External Charting Plugins. Solution: An in house web application developed for banks involved in Mutual Funds Investments The basic processes involve risk assessment of an investor and thereafter suggesting a model portfolio and an investment plan. The application generates an investment policy document giving the user graphic and tabular view of their investments. I was involved in the Management, Quality Control and Delivery of the project. Project: A Workflow management System Technology: FileMaker Pro 9.0, Several External Plugins, FM API for PHP Solution: A full fledged work flow management system (targeted towards Advertising & Media Planning segment) starting from creation of Campaigns, identifying tasks, scheduling & subsequently managing the tasks, interaction with internal staff as well as external vendors, if any. The product has a core with all basic functionality inbuilt and is structured for easy customization. Project: An inventory management system Technology: FileMaker Pro 9.0 Solution: An extremely complex order processing, inventory management and shipment management application was created using FileMaker Pro 9.0. The starting point for the application is a work order, which creates a purchase order (on the vendor), which creates an inventory ticket and a pick slip for full or partial shipment. Another sub system takes over to handle short shipments to ensure that they are completed on a priority basis. The invoicing process begins thereafter and is taken over by Accounts Receivable. I was involved in the Management, Quality Control and Delivery of the project. Project: Project Task List Technology: FileMaker Pro 9.0 Solution: This desktop application is developed in house in order to facilitate Communication and Project status monitoring. It is a very helpful tool, which includes the Project Manager, Developer and the Client. The current status of all the tasks assigned can be viewed by all thus maintaining transparency in the whole Project Development process. Additionally the application also allows communication between all the three parties, thus avoiding any communication gaps. I was involved in the Management, Quality Control and Delivery of the project. Project: Daily Parade Technology: FileMaker Pro 9.0 Solution: Often the most neglected tasks are the daily chores. An application was created to ensure that soft reminders were given for these chores and a rating system for tasks not performed on time (or not done at all). A weekly status report of highest to lowest scores was published in order to create a better awareness of completing the tasks without follow up. I was involved in the Management, Quality Control and Delivery of the project. Project: Certification Database Technology: FileMaker Pro 9.0 Solution: A training institute conducts various courses for individuals as well as for corporate. An application was developed to register students for upcoming courses, manage the fees payable, assign tutors, schedule classes, print and e-mail certificates to successful candidates etc. I was involved in the Management, Quality Control and Delivery of the project. Project: NRC web Technology: FileMaker Pro 9.0, FM API for PHP Solution: A leading company dealing in commercial and residential real estate wanted an application for its service agents. The web application would help the service staff to check all the available properties as well as information about the buyers online. The system also provides a shopping cart option for buying property brochures and real estate properties. I was involved in the Management, Quality Control and Delivery of the project. Project: Coker Technology: FileMaker Pro 9.0, FM API for PHP Solution: A web application was developed for large second hand machinery dealing company. The company wanted the details of all the machinery up for sale available to its sales representatives. Hence the application had an Inventory Tracking facility wherein the representatives could search for machinery by category. The system also facilitated sending quotes to clients directly by e-mail. I was involved in the Management, Quality Control and Delivery of the project. Project: TestingWerks Technology: FileMaker Pro 9.0, FM API for PHP Solution: A large school in USA wanted to keep track of the student performance in the long run. A web application was developed for them wherein the teachers would input the test scores of students of all grades. The system would report the progress of students in the form of Line Graphs and Bar Graphs. The reports were available for short term as well as long term as per the duration mentioned. I was involved in the Management, Quality Control and Delivery of the project. Project: Well researched financial data about Service Providers for Emerging Markets, New York, USA Technology: FileMaker Pro 8.5, FM API for PHP Solution: The Company provides research and strategic advisory services in the emerging and diverse managers' space. A comprehensive database of emerging managers and other financial service providers was available in Microsoft SQL server. We created a FileMaker and PHP application to gather data from these service providers. The service providers were categorized among various groups and a focused questionnaire was prepared for each category. Backend database was designed in FileMaker and PHP based front end application populates the data for all users who sign up. The second phase of the project (also developed using FileMaker & PHP), makes this information available to all institutional investors and provides other advisory services to institutional investors with exposure to a fresh, largely untapped investment talent pool. I was involved in the Management, Quality Control and Delivery of the project. Project: E-Commerce & ERP of a large Retail store chain in USA Technology: FileMaker Server Advanced 8 & 9, FileMaker Pro Advanced 8.0 & 9.0, Citrix Presentation Server & EdgeSight Server load testing Solution: A fortune 200 retail shop chain with shops across the United States and Europe, has an inventory of more than 45,000 products, each further divided in categories & sub-categories. The store comes up with several promotional schemes, each with its own complex set of rules. An extremely complex FileMaker application, with little over 700 layouts and 1100 tables supports all functions of the store starting from order management, inventory control, sales promotion schemes, vendor management etc. A web based e-commerce application is supported by this FileMaker Database. We created systematic test case scenarios for testing the FileMaker application. The test plan involved understanding each process, creating a script to run the entire process automatically, enter test data wherever necessary and thereafter load the scripts multiple times in order to perform load test. We could successfully increase the load from 1 user to simultaneous 200 users and monitor the performance. The tests were performed via a Citrix environment. I was involved in the Management, Quality Control and Delivery of the project. Project: Mom Technology: FileMaker Pro 9.0 Solution: A large FileMaker Pro 6.0 application was converted to FileMaker Pro 9.0. The converted system was then enhanced to include additional features & functions. I was involved in the Management, Quality Control and Delivery of the project. Project: Highly efficient search for photographs inventory for a media company Technology: FileMaker Pro 8.5, FM API for PHP Solution: A very complex logic system, made easy to use through this development. A web-based search and updates system, which allows the photographers to search the photographs on various parameters and view the details of each photograph. The web application allows editing of the details to authenticated users whereas the photographers can edit the priority of the images. A huge database which stores the images, the description of images, photographers info, their works, assignments, job Assignments, their payments etc. The jobs are assigned on the fly and can be undefined at times. This makes it difficult to keep track of the jobs assigned. Occasionally a job may get assigned to a particular photographer but some other photographer may have already completed it. Such confusions and complications are solved using this web application. I was involved in the Management, Quality Control and Delivery of the project. Project: BID JDM Technology: FileMaker Pro 9.0, MySQL Solution: A web Auction Application was developed for a Japanese company. They were developing their new Auction website in PHP. They wished to integrate the data generated from the Auction website to the exiting FileMaker Inventory management system and automate the process as much as possible, so that the business can be run with minimum staff to handle multiple customers efficiently and accurately. I was involved in the Management, Quality Control and Delivery of the project. Project: A Media contacts management web application Technology: FileMaker Pro 9.0, FM API for PHP Solution: The application manages the media contacts for the company. The company has an elaborate process to approve the media that is allowed to cover some of the prestigious events. Media representatives can directly submit their requests using the web interface. The company administrator uses the desktop version to periodically review the request and take a decision for inclusion or exclusion of the media. I was involved in the Design, Development, Management, Quality Control and Delivery of the project. Project: Event Award Management Technology: FileMaker Pro 9.0, FM API for PHP. Solution: An organization that conducts international competition for artists from various walks of life needed an application to manage the event. The desktop & web based application manages information related to applicants, reviewers, applications and scores. The web interface allows the applicants to submit their applications over the internet. They can also view past entries and status of each application. Multiple reviewers can review applications simultaneously. Application Acceptance process has a complicated work flow. At every step, the acceptance criterion changes, depending on the answer to the previous step. The application interfaces with a payment gateway for credit card authorization. The desktop and web applications are now being maintained in the FileMaker Pro ver. 9.0 I was involved in the Design, Development, Management, Quality Control and Delivery of the project.

Bio for Shilpa Sawant

Summary 8 years of experience in Software Development. FileMaker Pro 7 Certified Developer Languages C, Visual Basic 6, JAVA, Developer 2000 Database SQL Server 2000, Oracle 8i, MS Access, FileMaker Pro 6/7/8/8.5./9.0 Experience in HTML, DHTML, VBScript, JavaScript, ASP, IIS, MS Frontpage, Visual Interdev Software Project Details (FileMaker Projects Only) Project: Inventory Tracking System for a Japanese Sports Car Designer Technology: FileMaker Pro 8.5 Solution: An inventory management system for a car designer, who needs to source non-standard goods from various non-standard sources. The customer vendor was a thin line in this application, because a customer for one car can be a vendor for another part. The aim of the system is to track inventory, raise invoices, updating status of inventory and provide reports showing the true state of the business. I was involved in the Design and Development of the project. Project: Online Ticket Reservation System Technology: FileMaker Pro 8.0, XML-XSLT, HTML, JavaScript. Solution: This application is like a shopping cart application, except that the goods on sale are tickets for various entertainment shows in town. Being a web based application it had stringent security requirements and features such as printing reports or sending PDFs via e-mail. I was involved in the Design and Development of the project. Project: Web application for Biomedical Institute, based at USA Technology: FileMaker Pro 7.0, FM Pro server advanced, XML-XSLT Solution: Web application, to create and manage the Trouble Tickets for patients and monitor the status. Each Trouble Ticket consists of one or more problems. Users in various roles and with appropriate authentication, assign the problems to appropriate authority. Further, the system keeps track of each assignment and the action taken for each problem. The web application was developed using CWP and XML-XSLT. I was involved in the Design and Development of the project. Project: Database development for a Electrical Equipments trading company, based at USA Technology: FileMaker Pro 7.0 Solution: An integrated inventory & equipment tracking application for a heavy duty electric equipment company. The challenge was to create a new relational database maintaining the existing relationships and adding several new entity connections. The application helps the user to create various Custom forms, Bill of lading, Vendor applications etc. for export. I was involved in the Design and Development of the project. Project: Database enhancement for a leading courier company, based at Bermuda Technology: FileMaker Pro 6.0, 8.5, PHP Solution: This courier company did their entire administration required for an International courier outfit using a large FileMaker Pro based system. We added several web components to the existing database earlier using XML-XSLT and then switched to PHP. I was involved in the Design and Development of the project. Project: TestingWerks Technology: FileMaker Pro 9.0, FM API for PHP Solution: A large school in USA wanted to keep track of the student performance in the long run. A web application was developed for them wherein the teachers would input the test scores of students of all grades. The system would report the progress of students in the form of Line Graphs and Bar Graphs. The reports were available for short term as well as long term as per the duration mentioned. I was involved in the Design and Development of the project. Project: Well researched financial data about Service Providers for Emerging Markets, New York, USA Technology: FileMaker Pro 8.5, FM API for PHP Solution: The Company provides research and strategic advisory services in the emerging and diverse managers' space. A comprehensive database of emerging managers and other financial service providers was available in Microsoft SQL server. We created a FileMaker and PHP application to gather data from these service providers. The service providers were categorized among various groups and a focused questionnaire was prepared for each category. Backend database was designed in FileMaker and PHP based front end application populates the data for all users who sign up. The second phase of the project (also developed using FileMaker & PHP), makes this information available to all institutional investors and provides other advisory services to institutional investors with exposure to a fresh, largely untapped investment talent pool. I was involved in the Design and Development of the project. Project: Highly efficient search for photographs inventory for a media company Technology: FileMaker Pro 8.5, FM API for PHP Solution: A very complex logic system, made easy to use through this development. A web-based search and updates system, which allows the photographers to search the photographs on various parameters and view the details of each photograph. The web application allows editing of the details to authenticated users whereas the photographers can edit the priority of the images. A huge database which stores the images, the description of images, photographers info, their works, assignments, job Assignments, their payments etc. The jobs are assigned on the fly and can be undefined at times. This makes it difficult to keep track of the jobs assigned. Occasionally a job may get assigned to a particular photographer but some other photographer may have already completed it. Such confusions and complications are solved using this web application. I was involved in the Design and Development of the project. Project: Coker Technology: FileMaker Pro 9.0, FM API for PHP Solution: A web application was developed for large second hand machinery dealing company. The company wanted the details of all the machinery up for sale available to its sales representatives. Hence the application had an Inventory Tracking facility wherein the representatives could search for machinery by category. The system also facilitated sending quotes to clients directly by e-mail. I was involved in the Design and Development of the project. Project: Construction Project management database development for a company, based at USA Technology: FileMaker Pro 7.0, FM Pro server advanced, XML-XSLT Solution: Database development using FM Pro 7.0 for managing and tracking the construction related projects for the user. The application keeps track of projects, sites, contractors, sub contractors and clients. The application also helps in property auction and facilitates the buyer to examine the property details before putting in a bid. The Web component was developed using FM Pro server advanced, FM Pro 7.0 and XML-XSLT. I was involved in the Design and Development of the project. Project: BID JDM Technology: FileMaker Pro 9.0, MySQL Solution: A web Auction Application was developed for a Japanese company. They were developing their new Auction website in PHP. They wished to integrate the data generated from the Auction website to the exiting FileMaker Inventory management system and automate the process as much as possible, so that the business can be run with minimum staff to handle multiple customers efficiently and accurately. I was involved in the Design and Development of the project. Project: A Media contacts management web application Technology: FileMaker Pro 9.0, FM API for PHP Solution: The application manages the media contacts for the company. The company has an elaborate process to approve the media that is allowed to cover some of the prestigious events. Media representatives can directly submit their requests using the web interface. The company administrator uses the desktop version to periodically review the request and take a decision for inclusion or exclusion of the media. I was involved in the Design and Development of the project. Project: Event Award Management Technology: FileMaker Pro 9.0, FM API for PHP. Solution: An organization that conducts international competition for artists from various walks of life needed an application to manage the event. The desktop & web based application manages information related to applicants, reviewers, applications and scores. The web interface allows the applicants to submit their applications over the internet. They can also view past entries and status of each application. Multiple reviewers can review applications simultaneously. Application Acceptance process has a complicated work flow. At every step, the acceptance criterion changes, depending on the answer to the previous step. The application interfaces with a payment gateway for credit card authorization. The desktop and web applications are now being maintained in the FileMaker Pro ver. 9.0 I was involved in the Design and Development of the project.

Bio for Trupti Kamble

Summary ¥ Total 3 years of experience in Software Development. ¥ File Maker Pro 8 Certified Developer. ¥ Languages Core PHP, FX PHP, PHP API, XML-XSLT, HTML, JavaScript, VB Script. ¥ Database FileMaker Pro 8, 8.5, 9.0, FileMaker Pro 8 Advanced, FileMaker Pro 8.5 Advanced ¥ Experience in ASP, XML. Software Project Details (FileMaker Projects Only) Project: iPhone Technology: FileMaker Pro 8.5, FM API for PHP Solution: iPhone is a tool used for the certification exam of iPhone. There were sets of questions with their set of answers. Based on the number of questions correct, the examinee was declared either passed or fail. The questions once answered could not be revisited again. I was involved in the Design and Development of the project. Project: Rest Assured Technology: FileMaker Pro 8.0, FX PHP Solution: This application generated a report for every work order. Bugs were fixed in the existing application and some new functionalities were added with reference to display related data in the same. I was involved in the Design and Development of the project. Project: Construction Project management database development for a company, based at USA Technology: FileMaker Pro 7.0, FM Pro server advanced, XML-XSLT Solution: Database development using FM Pro 7.0 for managing and tracking the construction related projects for the user. The application keeps track of projects, sites, contractors, sub contractors and clients. The application also helps in property auction and facilitates the buyer to examine the property details before putting in a bid. The Web component was developed using FM Pro server advanced, FM Pro 7.0 and XML-XSLT. I was involved in the Design and Development of the project. Project: E-Commerce & ERP of a large Retail store chain in USA Technology: FileMaker Server Advanced 8 & 9, FileMaker Pro Advanced 8.0 & 9.0, Citrix Presentation Server & EdgeSight Server load testing Solution: A fortune 200 retail shop chain with shops across the United States and Europe, has an inventory of more than 45,000 products, each further divided in categories & sub-categories. The store comes up with several promotional schemes, each with its own complex set of rules. An extremely complex FileMaker application, with little over 700 layouts and 1100 tables supports all functions of the store starting from order management, inventory control, sales promotion schemes, vendor management etc. A web based e-commerce application is supported by this FileMaker Database. We created systematic test case scenarios for testing the FileMaker application. The test plan involved understanding each process, creating a script to run the entire process automatically, enter test data wherever necessary and thereafter load the scripts multiple times in order to perform load test. We could successfully increase the load from 1 user to simultaneous 200 users and monitor the performance. The tests were performed via a Citrix environment. I was involved in the Design and Development of the project. Project: A Workflow management System Technology: FileMaker Pro 9.0, Several External Plugins, FM API for PHP Solution: A full fledged web enabled work flow management system (targeted towards Advertising & Media Planning segment) starting from creation of Campaigns, identifying tasks, scheduling & subsequently managing the tasks, interaction with internal staff as well as external vendors, if any. The product has a core with all basic functionality inbuilt and is structured for easy customization. I was involved in the Design and Development of the project. Project: Well researched financial data about Service Providers for Emerging Markets, New York, USA Technology: FileMaker Pro 8.5, FM API for PHP Solution: The Company provides research and strategic advisory services in the emerging and diverse managers' space. A comprehensive database of emerging managers and other financial service providers was available in Microsoft SQL server. We created a FileMaker and PHP application to gather data from these service providers. The service providers were categorized among various groups and a focused questionnaire was prepared for each category. Backend database was designed in FileMaker and PHP based front end application populates the data for all users who sign up. I was involved in the Design and Development of the project. Project: Online Ticket Reservation System Technology: FileMaker Pro 8.0, XML-XSLT, HTML, JavaScript. Solution: This application is like a shopping cart application, except that the goods on sale are tickets for various entertainment shows in town. Being a web based application it had stringent security requirements and features such as printing reports or sending PDFs via e-mail. I was involved in the Design and Development of the project. Project: In house Sales Tracking System Technology: FileMaker Pro 8.5, Core PHP, FM API for PHP Solution: More efficiently a company track sales (leads), higher is likely to be the conversion ratio. This application manages all sales personnel, their targets, sales leads, communication between parties etc. giving a one touch snap shot of the active sales. I was involved in the Design and Development of the project. Project: Contact Management System Technology: FileMaker Pro 8.5. Solution: This application manages the contact information of the user. It prints, exports and imports contact details. It manages access privileges for High, Low and medium level users. I was involved in the Design and Development of the project. Project: Digital Asset Library Technology: FileMaker Pro 8.5, FM API for PHP Solution: This Application is an online resource for the promotional products industry. It manages various SuppliersÕ details and its respective products details. Each product has its own digital assets like photos, PDFs, videos, podcasts, artworks and templates, case histories etc. The application manages all those digital assets such as creation, deletion, update etc. into the database. It uploads various kinds of digital assets and products data to FTP via the web, sends an email with attachment of Specimen copy of .csv, .xml file for importing data. It supports Creation of New Supplier Account, Duplication of Product, Managing price information for each product and Assign unallocated digital assets to products. The application efficiently manages all these interconnections with easy navigation and user-friendly interface. I was involved in the Design and Development of the project. Project: Museum System Cantor Technology: FileMaker Pro 8.5, Microsoft Word. Solution: This System generates, updates and processes the data for various artifacts that come in to the Museum. The complex process involves Generation of data, Generating proper incoming receipts to track various objects, Assigning Artists, vendors, and donors to the objects, Conservation related activities for the objects, Creation of data for actual physical storage of objects within the Museum system, Importing and exporting data from database system to other external supported formats and Reports generation. The highly complex system processes involve data migration I was involved in the Design and Development of the project.

Bio for Shweta Mhalim

Summary 4 years of experience in Software Development. Languages C, C++, Java, SQL, Visual Basic, VB.Net, HTML, DHTML, ASP Database SQL Server 2000 / 2005, MS Access, FileMaker Pro 7/8/8.5. Experience in JavaScript, VBScript Software Project Details (FileMaker Projects Only) Project: Construction Project management database development for a company, based at USA Technology: FileMaker Pro 7.0, FM Pro server advanced, XML-XSLT Solution: Database development using FM Pro 7.0 for managing and tracking the construction related projects for the user. The application keeps track of projects, sites, contractors, sub contractors and clients. The application also helps in property auction and facilitates the buyer to examine the property details before putting in a bid. The Web component was developed using FM Pro server advanced, FM Pro 7.0 and XML-XSLT. I was involved in the Design and Development of the project. Project: Coker Technology: FileMaker Pro 9.0, FM API for PHP Solution: A web application was developed for large second hand machinery dealing company. The company wanted the details of all the machinery up for sale available to its sales representatives. Hence the application had an Inventory Tracking facility wherein the representatives could search for machinery by category. The system also facilitated sending quotes to clients directly by e-mail. I was involved in the Design and Development of the project. Project: TestingWerks Technology: FileMaker Pro 9.0, FM API for PHP Solution: A large school in USA wanted to keep track of the student performance in the long run. A web application was developed for them wherein the teachers would input the test scores of students of all grades. The system would report the progress of students in the form of Line Graphs and Bar Graphs. The reports were available for short term as well as long term as per the duration mentioned. I was involved in the Design and Development of the project. Project: E-Commerce & ERP of a large Retail store chain in USA Technology: FileMaker Server Advanced 8 & 9, FileMaker Pro Advanced 8.0 & 9.0, Citrix Presentation Server & EdgeSight Server load testing Solution: A fortune 200 retail shop chain with shops across the United States and Europe, has an inventory of more than 45,000 products, each further divided in categories & sub-categories. The store comes up with several promotional schemes, each with its own complex set of rules. An extremely complex FileMaker application, with little over 700 layouts and 1100 tables supports all functions of the store starting from order management, inventory control, sales promotion schemes, vendor management etc. A web based e-commerce application is supported by this FileMaker Database. We created systematic test case scenarios for testing the FileMaker application. The test plan involved understanding each process, creating a script to run the entire process automatically, enter test data wherever necessary and thereafter load the scripts multiple times in order to perform load test. We could successfully increase the load from 1 user to simultaneous 200 users and monitor the performance. The tests were performed via a Citrix environment. I was involved in the Design and Development of the project. Project: Mom Technology: FileMaker Pro 9.0 Solution: A large FileMaker Pro 6.0 application was converted to FileMaker Pro 9.0. The converted system was then enhanced to include additional features & functions. I was involved in the Design and Development of the project. Project: Well researched financial data about Service Providers for Emerging Markets, New York, USA Technology: FileMaker Pro 8.5, FM API for PHP Solution: The Company provides research and strategic advisory services in the emerging and diverse managers' space. A comprehensive database of emerging managers and other financial service providers was available in Microsoft SQL server. We created a FileMaker and PHP application to gather data from these service providers. The service providers were categorized among various groups and a focused questionnaire was prepared for each category. Backend database was designed in FileMaker and PHP based front end application populates the data for all users who sign up. The second phase of the project (also developed using FileMaker & PHP), makes this information available to all institutional investors and provides other advisory services to institutional investors with exposure to a fresh, largely untapped investment talent pool. I was involved in the Design and Development of the project.

Bio for Pushkraj Ranalkar

Summary FileMaker Pro 9 Certified Developer 3 years of experience in Software Development. Languages C, C++, VB, SQL, Embedded C, JAVA. Database FileMaker Pro 8.0, 8.5, 9.0, FileMaker Pro 8 Advanced, Oracle 8i, MS Access Software Project Details (FileMaker Projects Only) Project: Museum System Cantor Technology: FileMaker Pro 8.5, Microsoft Word. Solution: This System generates, updates and processes the data for various artifacts that come in to the Museum. The complex process involves Generation of data, Generating proper incoming receipts to track various objects, Assigning Artists, vendors, and donors to the objects, Conservation related activities for the objects, Creation of data for actual physical storage of objects within the Museum system, Importing and exporting data from database system to other external supported formats and Reports generation. The highly complex system processes involve data migration. I was involved in the Design and Development of the project. Project: In house Mutual Funds Investment System based on banking domain Technology: FileMaker Pro 8.5, External Charting Plugins. Solution: An in house web application developed for banks involved in Mutual Funds Investments The basic processes involve risk assessment of an investor and thereafter suggesting a model portfolio and an investment plan. The application generates an investment policy document giving the user graphic and tabular view of their investments. I was involved in the Design and Development of the project. Project: A Workflow management System Technology: FileMaker Pro 9.0, Several External Plugins, FM API for PHP Solution: A full fledged work flow management system (targeted towards Advertising & Media Planning segment) starting from creation of Campaigns, identifying tasks, scheduling & subsequently managing the tasks, interaction with internal staff as well as external vendors, if any. The product has a core with all basic functionality inbuilt and is structured for easy customization. Project: An inventory management system Technology: FileMaker Pro 9.0 Solution: An extremely complex order processing, inventory management and shipment management application was created using FileMaker Pro 9.0. The starting point for the application is a work order, which creates a purchase order (on the vendor), which creates an inventory ticket and a pick slip for full or partial shipment. Another sub system takes over to handle short shipments to ensure that they are completed on a priority basis. The invoicing process begins thereafter and is taken over by Accounts Receivable. I was involved in the Design and Development of the project. Project: Project Task List Technology: FileMaker Pro 9.0 Solution: This desktop application is developed in house in order to facilitate Communication and Project status monitoring. It is a very helpful tool, which includes the Project Manager, Developer and the Client. The current status of all the tasks assigned can be viewed by all thus maintaining transparency in the whole Project Development process. Additionally the application also allows communication between all the three parties, thus avoiding any communication gaps. I was involved in the Design and Development of the project. Project: Daily Parade Technology: FileMaker Pro 9.0 Solution: Often the most neglected tasks are the daily chores. An application was created to ensure that soft reminders were given for these chores and a rating system for tasks not performed on time (or not done at all). A weekly status report of highest to lowest scores was published in order to create a better awareness of completing the tasks without follow up. I was involved in the Design and Development of the project. Project: Certification Database Technology: FileMaker Pro 9.0 Solution: A training institute conducts various courses for individuals as well as for corporate. An application was developed to register students for upcoming courses, manage the fees payable, assign tutors, schedule classes, print and e-mail certificates to successful candidates etc. I was involved in the Design and Development of the project.

 

We invite you to check out some samples of our work below. Just click on any image to open the gallery

 

 View MetaSys Software Pvt. Ltd. profile on LinkedIn 

 

FindFileMakerDevelopers Footer