3bd3de0e-919d-4a09-8cf2-1e333c9a4985

Andrew Smith


Phone:

(000) 000-0000

Email:

[email protected]

Address:

287 Custer Street, Hopewell, PA 00000

Professional Summary

Trustworthy, dependable, responsible Personal Assistant with 5 years of experience providing ongoing support to a notable CEO within the technology industry.  Dedicated, tireless professional with a keen ability to maximize both time and business efficiencies.  Well-organized with in-depth technical knowledge and keen attention to detail.

Employment history

Mar. 2020 – Present
South Valentineberg, Arizona
Analyst Programmer, Hessel-Jenkins

 Software Requirement Specification, System quality assurance, third part System integration Workflow design, Unit Testing and Integration Testing and end users training. 

Apr. 2010 – Jun. 2010
New Lenny, Maine
Computer Technician, Sanford-Koepp

  • Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
  • Route and connect cables and lines to switches, switchboard equipment, and distributing frames, using wire-wrap guns or soldering irons to connect wires to terminals.

Education

Jun. 2010
Bachelor of Science: Business Information System

  • South Reilly – Gutkowskiside, Illinois

Skills

SQL
Skillful

Software Analysis And Design
Experienced

Project Coordination
Skillful

3d31a271-2dde-4cf4-b1ee-e464e0486370

Andrew Smith

287 Custer Street, Hopewell, PA 00000
[email protected]
(000) 000-0000

Professional Summary

Analytical, motivated, adaptable and responsible gentlemen seeking a position in Information
Technology (I.T.) which will utilise the professional and technical skills developed through past work
experiences in this field. A professional Business Systems Analyst and Developer with over 2 years of experience in multifaceted roles requiring project management, business development, and solutions architecture. Skilled in the areas of data analytics, sql development systems administration and server administration in the financial industry. Motivated and eager to advance my career with a growth-oriented, technically-advanced organization as a Chief Information Officer or Senior Business systems analyst. I am an excellent team player, reliable and efficient as part of any team with good communication and interpersonal skills, with abilities in relation to building good work relationships.

Employment history

Analyst Programmer, Bashirian Group. Greenmouth, Missouri
Nov. 2019 – Present
  • Maintain and administer computer servers and related computing environments including computer hardware, systems software, applications software, and all configurations.
  • Perform data backups and disaster recovery operations.
  • Diagnose, troubleshoot, and resolve hardware, software, or other network and system problems, and replace defective components when necessary.
  • Configure, monitor, and maintain email applications or virus protection software.
  • Plan, coordinate, and implement security measures to protect data, software, and hardware.
  • Operate master consoles to monitor the performance of computer systems, and to coordinate computer network access and use.
  • Install software.
  • Design, configure, and test computer hardware, networking software and operating system software.
  • Monitor network performance to determine whether adjustments need to be made, and to determine where changes will need to be made in the future.
  • Research new technologies by attending seminars and training sessions, reading trade articles, or taking classes, and implement or recommend the implementation of new technologies.
  • Analyze equipment performance records to determine the need for repair or replacement.
  • Recommend changes to improve systems and network configurations, and determine hardware or software requirements related to such changes.
  • Perform maintenance of software system.
  • Analyze information to determine, recommend, and plan installation of a new system or modification of an existing system.
  • Monitor functioning of equipment to ensure system operates in conformance with specifications.
  • Coordinate installation of software system.
  • Train users to use new or modified equipment.
  • Recommend purchase of equipment to control dust, temperature, or humidity in area of system installation.

Graduate Trainee, Ryan Group. Donnellyside, Idaho
Nov. 2016 – Nov. 2017
  • Maintain and administer computer servers and related computing environments including computer hardware, systems software, applications software, and all configurations.
  • Perform data backups and disaster recovery operations.
  • Diagnose, troubleshoot, and resolve hardware, software, or other network and system problems, and replace defective components when necessary.
  • Configure, monitor, and maintain email applications or virus protection software.
  • Plan, coordinate, and implement security measures to protect data, software, and hardware.
  • Operate master consoles to monitor the performance of computer systems, and to coordinate computer network access and use.
  • Install software.
  • Design, configure, and test computer hardware, networking software and operating system software.
  • Monitor network performance to determine whether adjustments need to be made, and to determine where changes will need to be made in the future.
  • Research new technologies by attending seminars and training sessions, reading trade articles, or taking classes, and implement or recommend the implementation of new technologies.
  • Analyze equipment performance records to determine the need for repair or replacement.
  • Recommend changes to improve systems and network configurations, and determine hardware or software requirements related to such changes.
  • Perform maintenance of software system.
  • Analyze information to determine, recommend, and plan installation of a new system or modification of an existing system.
  • Monitor functioning of equipment to ensure system operates in conformance with specifications.
  • Coordinate installation of software system.
  • Train users to use new or modified equipment.
  • Recommend purchase of equipment to control dust, temperature, or humidity in area of system installation.

Intern, Bode, Weber and Bogisich. Quigleymouth, Kentucky
Feb. 2015 – Jul. 2015
  • Maintain and administer computer servers and related computing environments including computer hardware, systems software, applications software, and all configurations.
  • Perform data backups and disaster recovery operations.
  • Diagnose, troubleshoot, and resolve hardware, software, or other network and system problems, and replace defective components when necessary.
  • Configure, monitor, and maintain email applications or virus protection software.
  • Plan, coordinate, and implement security measures to protect data, software, and hardware.
  • Operate master consoles to monitor the performance of computer systems, and to coordinate computer network access and use.
  • Install software.
  • Design, configure, and test computer hardware, networking software and operating system software.
  • Monitor network performance to determine whether adjustments need to be made, and to determine where changes will need to be made in the future.
  • Research new technologies by attending seminars and training sessions, reading trade articles, or taking classes, and implement or recommend the implementation of new technologies.
  • Analyze equipment performance records to determine the need for repair or replacement.
  • Recommend changes to improve systems and network configurations, and determine hardware or software requirements related to such changes.

Education

South Hodkiewicz University, New Marvinville, Minnesota
Master of Science, Information Systems management, Aug. 2018

The Kansas Institute, Lake Haley, Kansas
Bachelor of Science, Information Technology, Dec. 2016

East Bins, East Corene, Utah
High School Diploma, A-Level, Oct. 2011

East Iowa University, Lake Ruthannefurt, Kentucky
High School Diploma, O-Level, Jun. 2009

Skills

SQL
Skillful

Systems Administration
Beginner

Systems analysis
Beginner

Database Systems
Novice

PC Maintenance
Novice

MSSQL
Novice

C#
Beginner

Software Project Management
Novice

Data structures and algorithms
Novice

Strategic Management
Novice

analyst programmer

  • Modified existing software to correct errors, adapt to new hardware and improve performance. 
  • Performed testing to verify software quality and function before it was released. 
  • Built databases and table structures following n-tier architecture methodology for web applications. 

analyst programmer

  • Formulated quality control, auditing and maintaining databases, resolving data problems by analyzing system changes.
  • ‘Gold Award’ for successfully delivering Annual Fund Liquidation/Vendor Change project report for 150000 employees to Ernst & Young.
  • Tier 2 award for leading the complete end to end project at Analyst level.
  • Bagged Gold Award twice for Banking Re-formatter Implementation.

analyst programmer

  • Facilitated key business relation with AON/Alight USA for evaluating processes and conducting financial forecast for proposed projects
  • Managed and Trained a team of 10 offshore as well as onshore members to maximize efficiency on critical ongoing projects.
  • Estimated the feasibility of each project by crafting a development strategy through ongoing support structures and processes.
  • Performed reporting on complex data sets by gathering business requirements from clients using SAS/SQL queries saving $250k.
  • Adhered to the use of advance SQL to find anomalies in the database in order to ensure data integrity standards.
  • Configured SAS programs to fulfill ad-hoc healthcare information requests and to deliver projects for Fortune 500 listed clients.
  • Improved performance by unit, integration, regression and acceptance testing procedures to ensure 100% data accuracy.

analyst programmer

  • Requirement Analysis & Design.
  • UI changes as per requirement
  • Responsible for coding Action Classes.
  • Implemented Web Services using Soap and Rest API.

analyst programmer

  • Analyze customer requirements and prepare a model system to use in program coding.
  • Development of the system using required programming languages.
  • Test and Install the developed system at customer’s site.
  • Most of the systems are developed in Progress language on Unix/windows operating systems.
  • Train Personnel for developed systems when required.
  • Worked on to integrate MainVision (Engineering Plant Maintenance System) with the other Progress based Manufacturing Systems like MFG/PRO, Syteline.

senior analyst programmer

  • Maintain and Enhanced System21 Package, working on all areas of the business
  • Using Thenon -change management system
  • Web FOCUS – Reporting tool
  • Support Helpdesk
  • On-Call

analyst programmer

  • Worked on projects from multiple domains like Banking, Automobiles, Telecom, and FMCG industry.
  • Created survey links for online and offline surveys.
  • Programming and deployment of web-based surveys for client.
  • Quality Analysis for logical checks applied on Survey link of the Questionnaire.
  • Quality check document maintained for all projects.
  • Testing surveys to ensure all programming instructions, logic, flow have been implemented.
  • Test surveys are transferred to live surveys to the required methodology. Also additional

analyst programmer

  • Data (Progress) and Systems Analysis (Openedge, Visual Studio C#) based on User Stories (Agile, Jira)
  • Development (Progress, C#) using source maintained in SVN
  • Unit Testing and Documentation
  • Develop and analyze information to build the sales measure

analyst programmer

  •  Communicate with the software end-users to capture To-Be requirements for the project & segregate functional & non-functional Requirements. 
  • Analyse requirements to identify controls, business-rules, work flows & User Interfaces from user requirements & prepare Requirements Document. 
  •  Resolving User issues on timely basis and providing solution within SLA.
  •  Coordinating with other Modules like MM, PM, SD & FI/CO regarding Integration related issues.

analyst programmer

  • IndiaMart app for IOS and Windows platform which is hybrid app based on Ionic structure.
  • Technologies Used: Angular + Ionic
  • Team size: 4 
  •  Resolved day-to-day production issues & providing users with training & steps for its resolution and developed detailed reference training manuals

analyst programmer

  • Make report queries
  • Develop databases that support web and mobile applications.
  • Provide technical support to internal customers
  • Train users to use new or modified applications.

analyst programmer

  • Design and Develop Maintenance Request for Workflow Management System, which is used by Sun Life to process different Policies by their clients. 
  • Do unit tests to ensure quality Coordinate with Business System Analysts and Business Unit for any requirements needed in software development 
  • Tools and Language used: Java, JSP, MS SQL Server, IBM WAS, Filenet, SVN, JIRA, HP ALM, Bitbucket 
  • Communication with client

analyst programmer

  • Interrogate Advanced Customer Information System Database via SQL and present reports as web applications, utilizing the .net framework and MEAN stalk as the presentation tool.
  • Establish compatibility with third party software products (Customer Information System by Advanced Utility) by developing program for modification and integration.
  • Create custom reports as requested by the CEO and department directors.
  • Operationally report to IT Manager and functionally report to

analyst programmer

  • Involved and developed Full cycle development using Java-based platform framework when client migrated from Adobe Coldfusion using JAVA, JSP, and javascript.  Create java reporting using iReport, and deployed in Jasper Server.
  • Developed and maintained Billing System using Adobe Coldfusion, javascript and Oracle 9i. This system provides reports, invoices and billings that has been designed and developed using Crystal Report.
  • Developed and maintained Procurement Management System using Adobe Flex and actionscript. 
  • Preparing test cases for systems testing. Execute test cases.
  • Involved in manual testing for new programmes.
  • Writing technical specification and functional specification documents.
  • Developing and improving interfaces.

analyst programmer

  • To do sales presentation together with the Sales Personnel and assist them on the technical presentation of the products if required
  • To set up booth when there are sales exhibitions
  • To carry out project implementation * carried out one IT and Network standby in Corus Hotel, Ampang for ORACLE training 
  • Program software requirements according to customers needs
  • Make cold calls to carry out sales presentation for the barcode and RIFD software or hardware to new prospects
  • Other jobs as required by the management 
  • Resigned by December 2006 and back in Kuching city. Assisted the Business Development Manager, Chephren till June 2007 as a part timer @ commission earner then to find and open sales market in Kuching.

analyst programmer

  • Graduate in Information Technology with more than 6.3 years of experience in BI Tools (Cognos Express, Cognos BI, and Cognos Analytics), Reporting Tools such as Jasper Reports (3.7, 5.1,5.6), Crystal Reports (2012, 2013), Power Builder (9.0 and 11.0) and in SQL/PL-SQL.
  • Exposure to industry verticals such as Pharmaceuticals, Entertainment, Health-care and Trading.
  • Conducted in-house training for fresh recruits employed by our company as part of their induction(focus on Function knowledge about the industry and its type, Report development, Reportingfeatures and the need for documentation of policies and procedures).
  • Adaptability to new and upcoming technologies and environments.

analyst programmer

  • Planned and managed projects.
  • Automated Life Insurance Policy Quotation process
  • Created user manuals, project documentations and conducted user training.
  • Saved company cost by automation of Life Policy Quotation. 
  • Contributed my skills and experience to run the business process accurately with minimal errors

analyst programmer

  • Developed API in SRP Product as a Customer requirement
  • Designed and developed a screen for referring a Customer
  • Have studied the internal screen development tool such as Ramco Virtual Works (RVW) and Integrated Developement Extension Kit (IEDK)
  • Have knowledge in creating API spec/Documentaion in APICurio and  using  it in the Swagger
  • Debugging the program for error’s and fixing 

analyst programmer

  • Ensuring alignment of business tonnage and revenue between SAP and reporting tool for MIS – Business Objectives.
  • Ensuring that all production databases (Non SAP) are published on the Data Dictionary
  • Propose Solutions to the enforcement of referential integrity in the production databases.
  • Rewrite Data dictionary in Java.

analyst programmer

  • Develop and document style guidelines for web application content.
  • Provided technical solution design to several service requests and projects for our US client, Excellus. 
  • Mentoring Junior Resources and Currently leading 3 peoples reporting to me.
  • Client Interaction/Co-ordination over call for Understanding and Gathering of Requirements.

analyst programmer

  • Design and development of the back end and reporting modules.
  • Optimizing the code by using the performance tuning techniques.
  • Define Database functions, procedures and triggers.
  • Preparation of worksheet on daily basis and helping and sharing & gaining of knowledge amongfellow team members.
  • Coordinate between Client, Project Management and Development Team Members.
  • Providing efforts for the reports.
  • Managed Resource Allocation for Projects.

junior analyst programmer

  • Communicate with US clients in their Salesforce related difficulties
  • Create new enhancements for client’s satisfaction
  • Provide fixes and support thru Salesforce Administrative tools
  • Developed, delivered and maintained software solutions to New York State Department of Health that resulted to efficient processing of health-related transactions for its members. 

analyst programmer

  • As a SQL developer, I maintained and enhanced front end and back end of ‘Ramco Virtual Works’ application, worked in MYSQL and used SQL profiler and SQL server management studio. 
  • Developed various HCM product features according to client side requirements. 
  • Supported ASIAN region demos and issues on real time basis and was a regular member in winning client deals.
  • Delivered software solutions for different systems and portfolio under Excellus Blue Cross/Blue Shield in USA. This resulted to faster and efficient processing of claims and billing of its members. 

analyst programmer

  • Worked with CignaTTK Health Insurance from March 2013 to May 2015 during the period when the client was setting up operations in India. The projects that I received an opportunity to work on were -New Business, Workflow Management, Product Configuration, Renewals.
  • The project deals with the management of the incoming New Business i.e. buying of a new policy by a customer from Cigna Health Insurance Co., based on the available products of the Insurance Company. Calculation of premium based on the questionnaire and user information/background is implemented.
  • Technology Stack: Symbiosis framework – built on Java 6, Spring and Hibernate, JSP, Servlets and JavaScript.
  • Also worked with another client – India First Life Insurance Co. Ltd. from November 2012 – March 2013 on the Claims Management System.
  • The project dealt with the assessment of incoming Claims against policies, from various sources such as couriers, health card online etc., and its flow through various stages such as Intimation Stage, Claim Registration, Claim Assessment and Claim Approval stages.
  • Technology Stack: Symbiosis framework – built on Java 6, Spring and Hibernate, JSP, Servlets and JavaScript.
  • Team Size: 7

analyst programmer/ service support (application)

  • Worked as a full-stack developer on multiple projects across technologies.
  • Worked extensively on Struts framework, Grails framework, Backbone JS and underscore JS.
  • Create financial reports from ICMS data for the reconciliation process between ICMS and ARBOR.
  • Do data sampling comparison between the old and new system.

analyst programmer

  • Whilst at Olex Cables I was exposed to many different systems including:BPCS, modifications to a majority of applications, Invoicing, Billing, Inventory, Material Status, General Ledger, Stocktake, Marketing / Sales Analysis
  • Quotation System – as an active team member for this new project, my role was programming
  • Performed extensive function testing in anticipation of the data conversion.
  • Involved in database analysis and error investigation on WEB-CBC using SQL commands on Golden View or Embarcadero.

senior analyst programmer

  • Participate in documenting Dial Conversion Application Design.
  • Develop and tested conversion programs, designed to perform extensive data validation.
  • Investigated and analyzed files to be converted, assigning default values to new fields and cleaning-up files to be migrated.
  • Coded and unit testing every program used in the migration effort.

analyst programmer

  • Automated Module Transaction in ERP for various Customers.
  • PoC For ERP Based ChatBot Using Microsoft Bot Framework and MS-LUIS
  • Integrated Ramco ERP with SAP Financial for Hitachi.
  • Designed Web Portal for Online Allowance with Support Team.
  • Integrated Ramco ERP with 3rd Party Software via RESTful Web Services .