Data Analytics Software Engineering
Resume:
K.RAMESH [956-***-**** / **********@*******.***]
Passport Number: M9953280 [B1 Visa Holder, Expiry Year: 2025]
Summary:
Highly motivated, results-oriented professional with 19+ years of experience in managing windows, web applications, mobile platforms, and Data analytics products with good leadership, technical skills, strong problem-solving and critical thinking, innovation, and proactive.
32 years of experience in Software engineering on both Development and maintenance projects. Leading the team to guide and mentor technically. [Carrier got started in 2000]. From 1994 – 2000, I was running a computer training academy cum development center at Namakkal and this experience I did not include in my professional experience part.
Experienced in the development of Application Software.
Development experience with Visual FoxPro (VFP)
Experience in database SQL 2000/2005/2008/2012/2014/2018.
Work experience in creating interfaces between third-party software like SAP and Rackley [Rating Engine] to the VFP package.
Education
Bachelor of Science (B.S.) in Information Systems from Birla Institute of Technology and Science, Pilani, India (CGPA 7.8)
Diploma in Electronic and Communication Engg., from Salem Co-Operative Sugar Mills Polytechnic, Namakkal (7.9)
Certification
Undergone training on ISO Quality process.
Undergone training on Microsoft Visual Studio .NET (C#, ASP.NET, WPF, WCF, XML & ADO.NET)
Undergone training in Rating, Underwriting, Claim, and Policy management processes for Commercial Auto, Property, General Liability, Multistate Crime, and Inland Marine Insurance
Undergone training on Bluecherry EDI Processes
Undergoing Angular2 training
Completed Data Scientist Certification from Collabera TACT.
Completed Communication Skill training provided by Macrosoft and certification
Completed Inspire Designer Basic Certification from Quadient.
Completed Inspire Content Management Basic Certification from Quadient.
Completed Advanced Database and SQL Query from Udemy.
Completed Machine Learning from Udemy.
Completed AWS Certified Cloud Practitioner from Udemy.
Completed Google Studio Dashboard certification from Udemy.
Completed DevOps certification from Udemy.
Pursuing Data Engineering certification from Udemy.
Competation:
Participated in Hackathon Event 2019 and introduced legacy add-ons and DB connectors for various DBs like SQL, Postgres, Mongo and MySQL
Technical Skills:
Languages : C#.Net, VB.Net, ASP.net, COBOL, C and C++
Application Package : Visual FoxPro 9.0, Visual Basic
RDBMS : SQL Server, Postgres SQL, MySQL, MongoDB
Operating Systems : Windows, SCO UNIX.
Reporting Tools : Crystal Report, XFRX, SSRS, R&R, BI
Others : WPF, MVVM, MVC, XML
Machine Learning : Python, R
IDE Machine Learing : PyCharm, Anaconda 32/64 bit including spider and Jupiter notebook
Bug Tracking Tool : JIRA
Reporting Package : Inspire Designer 14.00
DevOps : Jenkin, Git, AWS, Maven, Ansible and Docker
BigData Tool : Hadoop
Experience Details
Company: Nexturn Software Pvt Ltd June- 2023 – Dec 2023
Project: Preview
There are Hazardous and Non-hazardous waste, this application takes care of the invoicing and other financial aspects also other reports. There are master profiles created for each customer as per the waste they provide to destroy or recycle.
There are different categories of Items created in the master like recycling services, Waste treatment, etc. When the waste is picked either the waste is processed on its own or the assignment is given to a third party and as per that the Invoice is raised to the customer, and all this is defined in the Process as per the plant code master. There are Transport masters to carry the waste as per the vehicle type required
This application is a centralized application and details will be populated from SQL Server, Salesforce, etc.
Company: CG-VAK Software and Exports Ltd Oct - 2022 – June 2023
Working as a migration lead to FRS application to convert backend from FoxPro SQL Server.
.
Company: Lakshya Software Technologies Pvt. Ltd Aug 2021 – Sep 2022
Project: Manulife
Manulife is the largest insurance company in Canada and the 28th largest fund manager in the world based on worldwide institutional assets under management. Partsplus is a Participant Accounting Recordkeeping and trust system for their primarily 401(K) Retirement plans. It provides end-to-end solutions for client enrolments to manage their funds. It will primarily take the payroll file process split the payments and transfer to the designated fund automatically through a daily cycle. It also provides various levels of reports to smooth the functioning of the operations.
Responsibilities
● Interacting with the Business team on requirements gathering/understanding
● Identifying dependencies and evaluating risks & issues
● Prepare the process flow for the change request
● Interacting with the Business team and validating the process flow
● Peer reviews the changes and suggests the change
● Carry out test scenarios and confirm the functionality
● Prepare implementation documents
● Participate in production release and assist in release process Environment Visual FoxPro, SQL Server
Working in a various role like Batch process monitoring, production support, and development for
the legacy application.
Company: Macrosoft IT Solutions India Pvt Ltd April 2014 – Jul 2021
Title: System Analyst
POC:
POC 1: FoxPro Python Integration:
For this POC, FoxPro forms and tables were used as a UI and database. Scripting is done in Python and integrated with FoxPro to show the predicated result graph in FoxPro UI. In this POC, my responsibility is coding, scripting, integrating, and testing.
Tools:
Tool 1: Data Migration:
DataMorph tool is designed to migrate the VFP database structure and data to an equivalent SQL Server, Postgress, MySql, and Mongo database. It facilitates mapping between the Visual FoxPro data types and their equivalent data types. This tool enables a user to correct potential data problems that the tool finds when validating data integrity. It provides the facility to rectify the error data and re-import the data once again into the SQL, Postgres, MySQL, and Mongo databases.
Tool 2: View Creation
This tool is used to create SQL Remote View/ Local view from the FoxPro table and SQL Database tables. This will be incorporated in the visual FoxPro project and make minimum changes to access/update data in SQL Server.
Tool 3: VFP Project Analyzer
This tool is used to find out the volume of the visual FoxPro project. This will generate an output report that contains a detailed list of programs, forms, classes, Reports, etc used in each project. The summary report contains several coded lines, comments, controls, etc. This output will be used to find out the volume of the project.
Also, this tool will generate a Cost estimation Excel sheet which will get input from the generated report. This Excel sheet will be useful to the marketing and management to find out the approximate cost estimation of the migration.
Tool 4: ATD
ATD stands for “Automatic Technical Documentation” which will generate technical documentation for the selected FoxPro project. Generated document contains the following details.
Converting FoxPro Command/Functions to meaning full English statement
Description and usage of each Form/Program/Class
Environment details
Tables used
Work flow for the form/ program/ class
External program/form/class used
Screen shot of form/class
Form/Class Properties and methods
Control Properties and methods
This tool will reduce the analyst time to make the documentation up to 10 to 20 percent of the actual time.
Migration Projects:
[The above all tools are utilized in the below mentioned Migration projects]
Project 1: DDP
Description : It is a dental company and want to enhancement the
existing application.
1.Encrypt/Decrypt of CC details.
2.Replacing existing payment gateway and implementing Authorize.net.
Responsibilities:
Analyzing the Complicity of the project
Analyzing the code and prepping the impact analysis
Coding API to integrate Foxpro to C#
Integrate API to Foxpro
Testing and deployment
Project 2: MTS
Description : It is a municipal tax company; they want to migrate their existing
application but before that they want to do the enhancement and bug fixes on the
existing application.
Responsibilities:
Analyzing the Complicity of the project
Preparing Project Plan for Analyzing tasks.
Weekly meeting with the Client to get to know the business logic.
Analyzing the code and prepping the Technical Documentation.
Preparing the Business flow documentation
Supporting the development team with any clarification
Project 3: VLink
Description : It is an insurance and hospital management company, that wants to do the enhancement and bug fixes on the existing application.
Responsibilities:
Weekly meeting with the Client to get to know the business logic.
Coding, testing and deployment
Project 4: Panther System [Panther]
Description : It is a FoxPro Product company; they want to migrate their existing application but before that, they want to do the POC using Web Api from FoxPro.
Responsibilities:
Analyzing the Complicity of the project
Preparing Project Plan for Analyzing tasks.
Weekly meeting with the Client to get to know the business logic.
Analyzing the code and prepping the Technical Documentation.
Preparing the Business flow documentation
Supporting the development team with any clarification
Modified existing application to integrate with WebAPI
Project 5: Tractor Management System [Husq]
Description : Husq is a global leading producer of outdoor power products for forest, park, and garden care. Products include chainsaws, trimmers, robotic lawnmowers, and ride-on lawnmowers.
Responsibilities:
Analyzing the Complicity of the project
Preparing Project Plan for Analyzing tasks.
Weekly meeting with the Client to get to know the business logic.
Analyzing the code and prepping the Technical Documentation.
Preparing the Business flow documentation
Supporting the development team with any clarification
Project6: WinCap
Description : WinCap is an ERP package that will be useful to main Student and Staff Records. Also, this software is used to maintain staff salary, PF, and leave records for the various schools
Responsibilities:
Analyzing the Complicity of the project
Preparing Project Plan for Analyzing tasks.
Weekly meeting with the Client to get to know the business logic.
Analyzing the code and prepping the Technical Documentation.
Preparing the Business flow documentation
Supporting the development team with any clarification
Modifying existing applications for Bug fixing and enhancement
Project7: RFL
Description : RoadRunner provides the ability for a centrally located user to monitor and manage remote installations of the EXMUX.
In general usage, the user will start RoadRunner, login, and open a network file (via “File Open”). The user will be requested to authenticate each node in the network. When done with authentication, the Network View form will display, either in tabular or in graphical format. Each node is a separate row or box, depending on the format. The display of each node will vary according to whether authentication was successful.
In alternate usage, the user can use RoadRunner to create a new network, either against a series of live nodes or by creating a network offline, for later validation. In the former case, the user will select the Network AutoCreate function, enter the identification information for each node, and then authenticate as with an existing network. RoadRunner will discover cards and settings for each node specified in the network. In the latter case, the user will select the Network New function, and manually create nodes and add cards to each node.
Responsibilities:
Analyzing the Complicity of the project
Preparing Project Plan for Analyzing tasks.
Weekly meeting with the Client to get to know the business logic.
Analyzing the code and prepping the Technical Documentation.
Preparing the Business flow documentation
Supporting the development team with any clarification
Project 8: Opticare
Description : Risk Manager, or “RM” for short, was developed to support diverse types of healthcare administration business models, under the general description of “managed healthcare” organizations. Over the years these operations have been classified under various names:
“PPOs” - Preferred Provider Organizations
“IPAs” - Independent Physical Associations
“PHOs” - Physical/Hospital Organizations
Specialty Carve-outs – Organizations serving a particular type of care, such as vision care, mental health, or physical therapy.
“HMOs” - Health Maintenance Organizations
RM can serve these diverse organizations because they share common administrative processes. Even organizations that contract with each other often need to monitor the same processes, whether they serve as the provider or purchaser of the related services.
Responsibilities:
Analyzing the Complicity of the project
Preparing Project Plan for Analyzing tasks.
Weekly meeting with the Client to get to know the business logic.
Analyzing the code and prepping the Technical Documentation.
Preparing the Business flow documentation
Supporting the development team with any clarification
Modifying existing applications for Bug fixing and enhancement
Project 9: Metro
Description : The Metro is a Windows desktop application that manages all the information associated with servicing water systems with Environmental care.
It’s a VFP application with data stored in free tables. We have migrated the free to MS SQL 2014 database and made changes in VFP applications to point it to SQL SB. The client has also used a third-party Report writer called R&R Report Writer. We have also made changes in the Metro application so that the same R&R reports can be used.
There are 4 main applications of Metro and around 6 standalone applications that we have migrated to access SQL DB.
Finally, we have created Technical documentation of all applications. So that the entire application will be migrated into a Web-based platform and will be accessible within and outside the client intranet network. In addition, clients will be able to create access and manage their accounts online. This conversion will be implemented using the most recent technologies available allowing for easy maintenance and scaling with improved performance.
Responsibilities:
Analyzing the Complicity of the project
Preparing Project Plan for Analyzing tasks.
Weekly meeting with the Client to get to know the business logic.
Analyzing the code and prepping the Technical Documentation.
Preparing the Business flow documentation
Supporting the development team with any clarification
Modifying existing applications for SQL Integration.
Project 10: Automman
Description : Automann is a premier global distributor of aftermarket truck and trailer Components Company. They have three US-based distribution centers and stock more than 15,000 products, ranging from air brake & wheel components to steering products. Automann has engaged to replace their aging FoxPro-based reporting system with a web-based .net application. This new reporting system will provide Automann personnel with the necessary software tools to request various reports that retrieve data directly from the Microsoft SQL Server database (in real-time) that is used by their Warehouse Management/ Distribution system.
Responsibilities:
Analyzing the Complicity of the project
Preparing Project Plan for Analyzing tasks.
Weekly meeting with the Client to get to know the business logic.
Analyzing the code and prepping the Technical Documentation.
Preparing the Business flow documentation
Supporting the development team with any clarification
Modifying existing applications for bug-fixing
Project 11: Trace
Description : Trace - Data Explorer: Trace Environmental provides monitoring systems, software, and services to ease the task of managing, organizing, and reporting related data. Air Quality Control: Continuous Emissions Monitoring Systems. Our DAS 2000 monitoring and reporting software is the direct result of over 14 years of applied knowledge, expertise, and experience. Knowledgeable CEM experts look upon DAS 2000 as the most reliable and easy-to-use CEM software in the industry. Plant personnel need not spend countless hours trying to “figure out” how to work with or optimize DAS 2000.
Trace - Data Monitor: DAS2000 is a real-time data acquisition product. The Data Monitor program is responsible for real-time data collection, data calculations, data display, alarm generation, reason and action code entering, and other functions. As such, it is the central means by which users are alerted to alarm conditions. It allows for the viewing of analyzer daily calibration drift test results and the updating of calibration expected values (i.e. calibration gas bottle values) and is also utilized by utilities to collect emissions data required under 40 CFR Part 75. To quickly and easily analyze this data, an hourly data screen is to be developed.
Responsibilities:
Analyzing the Complicity of the project
Preparing Project Plan for Analyzing tasks.
Weekly meeting with the Client to get to know the business logic.
Analyzing the code and prepping the Technical Documentation.
Preparing the Business flow documentation
Supporting the development team with any clarification
Project 12: Visual Collections (VCS)
Description : VCS – Visual Collections System is an application designed to assist medical institutions in processing their patient's billing systems. With a real-time, search engine, VCS can efficiently access various databases to identify guarantor and patient information. A custom-built electronic document management system allows it to easily share and transfer documents with the clients. Finally, a fully customized collection system using state-of-the-art toolsets accelerates collections and recoveries for our customers.
Responsibilities:
Analyzing the Complicity of the project
Preparing Project Plan for Analyzing tasks.
Weekly meeting with the Client to get to know the business logic.
Analyzing the code and prepping the Technical Documentation.
Preparing the Business flow documentation
Supporting the development team with any clarification
Modifying existing applications for bug fixing
Project 13: Windows Comptagest (WCP)
Duration : July 2014 – January 2015.
Description : Comptagest is a computer-integrated management system that can manage multiple companies. The software works in the network or standalone station. The fields of application are: - Accounting, - Financials, - Analysis, - Budgeting, - Management of debtors and creditors and - Management salaries. Although these features are incorporated, each can be operated separately, which allows for improvement of the configuration at any time as required. The system parameter is to be modeled on your work environment. The different modules. Comptagest share the same data, they are entered at one level and are usable throughout the chain of modules, which reduces the risk of errors arising from multiple seizures. Comptagest is user friendly, it strives to make its use easier, both from an accounting point of view and from an IT perspective, in fact, and a minimum of computer knowledge is required for its use. For example, changes in the program is done using menus, that is to say, you have no “order" to learn.
Responsibilities:
Analyzing the Complicity of the project
Preparing Project Plan for Analyzing tasks.
Weekly meeting with the Client to get to know the business logic.
Analyzing the code and prepping the Technical Documentation.
Preparing the Business flow documentation
Supporting the development team with any clarification
Modifying existing applications for bug fixing
Company: CGS India Pvt Ltd May 2010 - June 2014
Tittle: Senior Software Engineer
Projects:
Project 14: BlueCherry
Description : BlueCherry is an award-winning enterprise apparel software solution designed to meet the needs of the apparel, footwear, and accessories market, Chosen by more companies than any other system BC client’s experience. The main modules are SOE, PO, EDI, AWS, and PLD. In BC reports and Labels are user’s friendly which users can build as per their needs.
AWS: While basic warehouse functionality can be found in the BlueCherry Enterprise ERP system, our Advanced Warehouse System adds the capabilities to handle more sophisticated needs, from suggested put-away to RFID. AWS is an extension of base BlueCherry; it is inherently integrated with our core ERP system. Below you can choose between AWS for BC 6 and AWS for BC 7 Documentation, where you can find the appropriate documents for your version of AWS and BC.
EDI: EDI is the direct, application-to-application transmission of business documents such as purchase orders, invoices, and remittance advice. Businesses immersed in electronic commerce -- the electronic flow of business information between organizations have found EDI to be a vital component of their enterprise. It differs, however, from more elementary forms of electronic communication in how it provides for truly integrated information flow.
EDI makes it possible to exchange data without ever re-keying the original transaction information stored in BlueCherry. By using this method of document exchange, your company can send business documents directly from BlueCherry to your trading partner's computer system, and vice versa. EDI can thus minimize staff involvement and reduce the delays and errors that accompany the manual processing of business documents.
By simplifying and streamlining business procedures, your organization can control costs, increase efficiency, and improve customer service levels. At the same time, EDI may save your company money through decreased safety-stock inventory levels and diminished administrative requirements.
EDI extracts information from your applications and transmits the data to our trading partners. Your trading partners can then process the transaction through their internal
PLM: BlueCherry PLM enables best practice processes by providing more comprehensive, more detailed, more systematized, and real-time information to ensure accurate and informed decision-making.
Responsibilities:
Impact Analysis for the assigned Task.
Coding
Unit Testing
Preparing Service pack / Customer Service pack along with readme to deliver the SP/CSP to client
Project 15: Infinity
Description : BC Infinity is a Conversion product of Bluecherry using .Net. It is an enterprise apparel software solution designed to meet the needs of the apparel, footwear, and accessories market.
Responsibilities:
Preparation of New workflow and use case documents for the newly proposed BC Infinity.
Generated .Net UI through Visual FoxPro Tool
Coding part of UI in Package, Entity, Controls
Validation of control through Stored Procedure
Lookup of control through Stored Procedure
Company: Radiant Info Systems July 2005 – April 2010
Tittle: Senior Software Engineer [FI]
Projects:
Project 16: Parallel System
Description : Parallel System is a complete Insurance Policy Management System that will serve the Underwriters Department and Policy Issue Departments and covers different Lines of Business-like Business Automobile, Business Auto Truckers, General Liability, Garages for both Service and Dealers, Commercial Properties and Inland Marine.
Processing of all these Lines of Business includes Generation of RiskId, Issue of Quote, Issue of Policy Number, Issue of Binder, and Finally Issue of Policy, Policy Endorsement, and Policy Re-Insurance along with various reports Preview and Printing facility. This system is integrated with a third-party Rating Engine called “AMS Rackley System” for importing all coverage premiums. And also integrated with the Claim System (which is in Lotus Notes) called “Advanced Claim Technology (ACT)” for importing all claims.
Modified the Parallel system in such a way that the same source code will work under two back ends namely SQL Server 2000 & Visual FoxPro 9.0. Implementations of FTP Process through visual FoxPro program, which will take care of file Upload, and Download.
Responsibilities:
Preparation of New Workflows and use case documents for the newly proposed Policy Management Software
GAP Analysis and preparation documentation for Online Insurance Policy issuance
Interacting with clients for new enhancement.
Project Time estimation
Updating weekly Project Status, Time Sheet
Design and Development.
Manual Testing with test data and report preparation
Company: UniCorp TCS Nov 2003 – May 2005
Tittle: Software Engineer [ERP]
Projects:
Project 17: In House Project for various Branch
Description : Enterprises Resource Management System (ERM) is an integrated system for Inventory and Payroll accounting suitable for manufacturing industries. This software has already put in more than 3 years of effort and is being updated periodically based on user requirements and the payroll acts being in force from time to time. This ERM consists of the following sub-modules Purchase, Stock, Sales, PPC, Inventory, FAM, QMS, and Payroll. This system generates various reports like Statistical inquiry, Machine performance, Automatic Stock level and reorder level, most demanding Items Preprinted Invoices, etc.
Responsibilities:
Designed integration between modules like Purchase, Stock, Sales, PPC, Inventory, and QMS.
Designed Payroll module, which calculates official and workers' monthly salary.
Designed for the above module based on SDLC as well as CMMI.
Automatic Data dictionary Updating Utility software done for updating data dictionary to the customer place while upgrading or new installation.
Updated the ERM for Multi-user Environment.
Modified the Payroll system in such a way that the same source code will work Monthly, Weekly as well as Hourly payroll
Company: Premier Softek India Ltd April 2000 – Oct 2003
Tittle: System Executive
Projects:
Project 18: Human Resource Management System
Description : Human Resource Management System (HRMS) is an integrated system for human resources and payroll accounting suitable for Private / Public Limited companies, Government, and other institutions. It can interface with the Attendance Information System and Financial Accounting System. Customization can be based on user requirements. This software has already put in more than 15 years of effort and is being updated periodically based on user requirements and the payroll acts being in force from time to time.
Responsibilities:
Designed an interface to mail server, which enables s/w to send pay slips or other reports through e-mail to respective departments or persons, without any manual intervention.
Designed a Journal module that is used to interface HRMS with SAP, Tally, and other financial accounting packages for Payroll Accounting.
Designed complete HR module (Manpower, Recruitment, Personal, Appraisal, Training and IR)
Modified the system, in such a way that the same source will work under two back-ends namely SQL Server 2000 & Visual FoxPro 6.0.
Updated the HRMS System for option-level multi-user.
Designed an Import option under payroll, which is used to import data from various formats like Excel, CSV, ASCII etc., to the HRMS package.
Modified the HRMS system in such a way that the same source code will work Monthly, Weekly as well as Hourly payroll
Project 19: Management Resource System (MRS)
Description : Management Remuneration System (MRS) is being used to maintain and process Salary, Income Tax, Personnel Information, Loans, etc. for managers & officers, working in different locations all over India. It also includes integrating of data from our system to third-party tools like MS-Access, etc., as well as importing from third-party tools data and PF calculations and white Goods Calculations. This product is only designed for HLL for its internal process all over India; we were responsible for whole software maintenance including support.
Responsibilities:
·Analysis, Developing and testing.
·Modification of the fields was done according to the Client Specifications.
Understanding client request and developing strategies to resolve them.
Develop, Renovate and Review the code based on Quality
Contact this candidate