Sylvester John, IT Consultant - Freelance

Sylvester John

IT Consultant - Freelance

Multiple Clients

Location
India - Chennai
Education
Master's degree, Information Technology
Experience
16 years, 7 Months

Share My Profile

Block User


Work Experience

Total years of experience :16 years, 7 Months

IT Consultant - Freelance at Multiple Clients
  • India - Chennai
  • My current job since April 2021

Provided IT consultant services to individuals and small businesses.
Assessed client needs, set up security measures, ordered and installed new components, assembled computer hardware, repaired and reimaged workstations, networked print servers, and connected to workstations.
Develop and deliver high-quality business training programs that are responsive to the needs of the business served.
Create and produce instructional materials.
Analyze business projects and identified improvements required for projects.
Create and execute work plans and revisions as appropriate to meet changing needs and requirements.
Ensure all phases are documented appropriately.
Prepare and manage initiatives as determined by the client.
Responsible for both creative and production teams from concept through to completion.
Identify resources needed and assign individual responsibilities.
Investigate business systems to identify areas of improvements and using IT to bridge the needs of businesses.
Information and prepared various documentation (e.g.security and financial applications/reports).

Business Analyst at Erdster Information Services Pvt. Ltd.,
  • India - Coimbatore
  • December 2019 to March 2021

 Responsible for implementing the full life cycle of RPA solutions: Identifying automation opportunities, gathered requirements, implement, test and deploy targeted automation solutions using industry leading RPA
 Gathered our customer’s business requirements and clearly documented them in order to our RPA Consultant teams to deploy automation projects in an optimal manner
 Delivered demos, technical trainings and support for new/existing clients
 Developed the objects and workflows as per client requirement
 Performed tool evaluation and feasibility to help in selecting Automation tool for RPA implementation
 Configured UiPath processes and objects using core workflow principles that are efficient, well structured, maintained and easy to understand for further requirement
 Automated Several Processes and Business activities for various business systems and Provided knowledge transfer/support/Assistance to the Application development and Support teams
 Efficiently handled monitoring and troubleshooting the studio environment through Orchestrator
 Involved in Logging into websites, searching websites, submitting web forms, or updating records on a website
 Automated the data transfers, including importing/exporting data between applications or files using UiPath
 Worked on debugging application for fixing bugs and Production support
 Worked with test teams during the Product test and UAT phases to fix assigned bugs
 Produced, through strong report writing and analysis skills, regular and accurate management reports including metrics for each of the Problem, Availability, and Change (PAC) Management processes.

Subject Matter Expert - UK Payroll at Accentra Technologies Pvt Ltd
  • India - Chennai
  • April 2018 to February 2019

Management of multiple payrolls for third party client employees on a weekly, fortnightly and/or monthly basis.
Running a portfolio of some complex payroll clients within the firm.
Ensuring the team have no errors in manual calculations of PAYE, NI, SSP, SMP, SPP and other payments.
Providing advice to new and existing clients in relation to pension schemes and compliance to UK Legislation.
Providing contractual advice around new joiners, redundancy payments, dismissals, share schemes etc.,
Consulting with new clients regarding their payroll set-up, parallel runs, HMRC requirements, deadlines and commitments
Dealing with client enquiries, HMRC payroll queries and some PAYE investigations.
Ensuring data accuracy around third party employee records, GDPR compliance, checking payroll updates and their input through the system.
Ensuring all RTI submissions are processed accurately and on time.
Ensuring all pay slips for clients are processed and overseeing the submission of pay slip files.
Overseeing the processing for End Of Year payrolls in accordance with client contracts and HMRC guidelines (P45s, P46s, P38s etc., )
Reviewing payroll reports on a monthly basis with the Partner, ensuring reconciliation of client monies and audits are undertaken for data quality.
Experience of RTI and pension auto-enrolment. Experience in Payroll Bureau and creating set-up in Nest, NOW and TPP Pensions.
Working in high-volume, multi-payroll environments with up to date knowledge of UK payroll regulations, year-end processes, staff management and providing advice to clients on payroll & pension legislation.

IT Consultant at IT Consultant
  • India - Bengaluru
  • February 2016 to March 2018

 Responsible for holistic understanding of requirements and performed vendor solution gap analysis.
 Building use cases and functional requirements documentation (FRDs), including documenting process flows, business rules and articulating overall functionality.
 Developed and executed manual test cases and test plans. Identified, prioritized, reported, and tracked defects.
 Worked on all stages of solution testing of complex products and platforms test execution, results analysis and corrective actions.
 Building subject-matter expertise on programs/applications and supporting business & operations in defining processes & best practices.
 Conducted GUI, Functionality, Integration and Regression Testing.
 Reported defects to the development team and tracked defects in TD.
 Created PR reports for evaluating the progress of bug fixing and current status of testing.
 Communicate proposed user interface designs through the use of appropriate means such as mock-ups, storyboarding, or other visual aids, and gain preliminary consensus on proposed interface designs.
 Strong knowledge of testing concepts with SDLC, STLC and Agile Process and SQL Knowledge.
 Forecast changes to scope, schedule and budget variances from the Project plan and the effects of risks.
 Wrote end-user software documentation. Developed and designed corporate brochures, business flyers for various client presentations.
 Created the strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing.
 Lead requirements discovery workshops, collaboration sessions with IT and business partners and issue resolution discussions.
 Reviewing the client requirements and business Specifications, analysing the impacts and feasibility.
 Preparing business requirements documents of Business Unit Reports, Metrics & Trend Analysis.
 Preparing traceability of security requirements in solution designs that are appropriate to address risk.
 Identifying risk impacts and effectively escalates any key risk, issues and controls which may have an adverse impact on the project and or the Business.
 Knowledge of Technology risk and Information Security processes, concepts related to industry standards and regulatory drivers.
 Understanding operational risk management and regulatory compliance, with working knowledge of information security, technology and controls.
 Documenting the Standard KPIs and key controls for the Service Level Management process and reports.
 Key point of contact to ensure Service Level Management process.
 Monitor delivery and integration of features and bug-fixes to ensure on-time delivery, testing and go-live.
 Systems technical and functional specifications / new applications release testing.

Business Analyst at MatexNet Pvt Ltd
  • India - Bengaluru
  • February 2014 to October 2015

 Managed projects from initiation stage to closing of projects. Experienced in project management audits conducted by Auditing team.
 Responsible for project management, design & development of systems for several major projects. Handled project schedule, milestone, task, estimates. Responsible for holistic understanding of requirements and performed vendor solution gap analysis.
 Building use cases and functional requirements documentation (FRDs), including documenting process flows, business rulesand articulating overall functionality.
 Modified / Updated various types of documents, including architecture, design, System requirement study(SRS) and Standard Operating Procedures(SOPs)
 Developed and executed manual test cases and test plans. Identified, prioritized, reported, and tracked defects.
 Verified defects were corrected. Supervised interns.
 Worked on all stages of solution testing of complex products and platforms test execution, results analysis and corrective actions.
 Building subject-matter expertise on programs/applications and supporting business & operations in defining processes & best practices.
 Conducted GUI, Functionality, Integration and Regression testing.
 Reported defects to the development team and tracked defects in TD.
 Manage the Testing Department. Allocate resource to projects. Review weekly Testers' status reports and take necessary actions. Estimate for testing projects. Enforce the adherence to the company's Quality processes and procedures. Decision to procure Software Testing tools for the organization. Inter group co-ordination between various departments.
 Worked on all stages of solution testing of complex
 Building subject-matter-expertise on programs/applications and supporting business & operations in defining processes & best practices.
 Forecast changes to scope, schedule and budget variances from the Project plan and the effects of risks.
 Wrote end-user software documentation. Developed and designed corporatebrochures, business flyers for various client presentations.
 Prepared reports by collecting, analyzing, and summarizing operational data and trends.
 Communicate proposed user interface designs through the use of appropriate means such as mock-ups, storyboarding, or other visual aids, and gain preliminary consensus on proposed interface designs.
 Performed IT audits of application systems, operations, and security.
 Provide technical direction and ensure compliance with best practice solutions.
 Communicated audit findings to management and implement plans with appropriate audittee management that will adequately remediate any identified control weaknesses or gaps.
 Consistently prioritized a shift workload to ensure that all situations are addressed in a timely manner.
 Manage communications from the PMO including regular reporting cycle requests.
 Build up a repository of project templates both technical and management to support the Project Managers.
 Strong knowledge of testing concepts with SDLC, STLC and Agile Process and SQL Knowledge.
 Forecast changes to scope, schedule and budget variances from the Project plan and the effects of risks.
 Wrote end-user software documentation. Developed and designed corporate brochures, business flyers for various client presentations.
 Created the strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing.

IT Consultant at IT Consultant
  • India - Bengaluru
  • August 2012 to January 2014

 Developed content for corporate portals &client presentations. Designed corporatebrochure and business flyer.
 Developed functional test plans, Test procedures and Test cases according to business specifications given and tested GUI functionalities according to the guidelines of the test plan.
 Performed extensive manual testing of each module. Developed and reviewed Test cases for positive and negative test scenarios, conducted baseline testing and generated reports.
 Performed GUI - Functional and Performance testing. Logging and tracking defects and producing defect reports.

Assistant Manager at Polaris Financial Technology Pvt. Ltd.,
  • Singapore
  • May 2011 to July 2012

 Provide in-depth analysis of product objectives with the goal of defining product requirements.
 Mentored and prepared the plan for domain knowledge acquisition and pre-project initiation phase.
 Responsible for data definitions, source system identification and connectivity.
 Laising with customers, Marketing team members, Product Managers, and Subject Matter Experts, to define and accomplish product goals.
 Performing research on implementing new enhancements, competitor and market analysis for senior management.
 Managed and handled multiple internal systems while communicating with customers and troubleshooting various issues.
 Responsible for Project Management and translate business/system requirements to functional requirements.
 Experience in writing SQL queries and optimizing the queries in SQL Server 2008.
 Responsible for collating data from various sources, validate to calculate metrics and key performance indicators (KPIs), and creating charts and reports for client senior management.
 Managed and documented multiple policies, procedures, minimum baseline standards and guidelines using MS SharePoint and MS Office.
 Manage weekly sprints as Product Owner in agile environment using JIRA.
 Involved in IT design effectiveness, operational effectiveness testing, development of policies, internal controls, procedures and guidelines.
 Coordinated and assisted in timely remediation of ITGC and application controls.
 Identified threats to the organization from open source and other threat intelligence sources by submitting the artefacts to QA and Senior Management.
 Assisted owners and IT staff in understanding and responding to audits reported by internal and external auditors.
 Supporting Client Management during the Internal / Country / KPMG audits.
 Played Admin role to provide access to users to participate in application yearly survey.

Business Analyst at citibank
  • Bahrain - Manama
  • November 2006 to April 2011

 Conduct gap analysis and feasibility analysis during the project inception phase.
 Prepared user requirements documents & software requirements specifications.
 Prepared BRD, Use case model during inception phases and logical views during elaboration phases.
 Perform proactive and strategic problem solving while considering cross product, cross lines of business impact of design/decisions.
 Review and provide input on design and implementation for major feature enhancements.
 Participated in design meetings with Engineering to scope out implementation of features.
 Responsible for effort estimation/analysis and feasibility to resolve bugs.
 Wrote end-user software documentation for Investment Banking - Middle Office Risk Treasury Application.
 Created new reports and dashboards and manage the existing reports and dashboards.
 Determine high-level acceptance criteria to feed into the Testing process; validate features to check for completeness and accuracy.
 Conduct in-house training to the team and share the learning’s on projects about excellence principles and approaches for implementing in action.
 Monitoring various metrics and reports and follow-up for closing the pending action items with respective teams.
 Performed Functional Audit, RCSA, defining and implementing process improvements for unit level process documents based on the Citi global processes and global standards (like COBIT, ISO27001etc).
 Conduct Internal audit of I.T. ERP security and General Controls (access control, program change, program development and computer operations)
 Recommended and reviewed user access management, program change process and procedures.
 Conduct the Risk and Control Assessment (RCSA) for unit and reporting to Client Senior Management.
 Involved in development, review, execution and maintenance of disaster recovery plans.
 Coordinated and lead the SOX compliance activities for organization to sustain SOX Compliance.
 Ensured proper escalation took place for unresolved production support issues as customer remains satisfied.
 Coordinated with Technical Support Desk for incident related issues, queries and initial escalations.

Education

Master's degree, Information Technology
  • at Alagappa University
  • October 2003
Bachelor's degree, Computer Science
  • at Madras University
  • October 1999

Specialties & Skills

Software Testing
Project Management
Business Analysis
Content Development
Project Management
Implementation support & Service Delivery
Business Analysis
Functional Testing & Defect Tracking
Content Development
Internal Audit

Languages

English
Expert
Hindi
Intermediate
Tamil
Expert