SUMMARY:

• Over 8+ years of IT experience in the field of Software Engineer/Systems Analyst in Financial/Banking industry.
• Experience in Financial Domain (Brokerage, Settlement System - New Zealand Stock Exchange).
• Strong experience in Business and Data Analysis, Data Migration, Data Validation and performance tuning.
• Strong experience in Agile Methodologies writing user stories in JIRA, story tracking, updating product backlog, estimation and sprint planning.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
• Experience in writing SQL Queries for Analysis, System Testing and Production Support.
• Experience in writing Use Cases for new application development and enhancements.
• Experience in understanding and writing Stored Procedures, Stored Functions, Database Triggers, Packages using PL/SQL and Microsoft SQL Server.
• Experience in Front End UI testing and Web Services testing, analyzing XML using SOAP UI and REST API testing.
• Experience in writing test plan, test cases, defect tracking, unit testing, System testing, System Integration testing, Regression testing, UAT support, UVT support, Dress Rehearsal (DR) and Production Support.
• Excellent verbal, written and interpersonal skills.

TECHNICAL SKILLS:

Tools: Visual Paradigm UML, JIRA, Confluence, New Relic, Microsoft Visio, BMC Remedy, HP Quality Centre, TOAD, SQL PLUS, HP Quality Center, Microsoft Visio, Microsoft Word, Excel, PowerPoint, SharePoint, FSCapture, Rapid Sql, Informatica, SourceTree, WIKI, Rapid SQL

Programming Languages: Java, J2EE, PL/SQL, Visual Basic, PHP, Mainframes, DB2

Testing Skills: Web service Testing (SOAP and REST), SOA Test, SOAP UI, Swagger, Web based GUI Testing, Interface Testing, and Database Testing

Web Development: J2EE, Spring, Struts, Hibernate, Servlets, JSP, JDBC, Java Bean, JUnit, Log4j, Web Services, SOAP, MVC, XML, XSLT, HTML5, PHP, JQuery, CSS3, JavaScript

Build Management: MAVEN, ANT, Jenkins, Nexus

Version Control Systems: SVN, Stash

Web Servers: Apache Tomcat

DBMS Packages: Oracle 10g/11g, MS SQL Server 2012, MySQL, Sybase, DB2

Development IDEs: Eclipse, Edit plus, Notepad++

Operating Systems: Microsoft Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Systems Analyst

Responsibilities:

• Responsible for understanding the existing product and new changes or requirement from business partners.
• Responsible for gathering system requirements (i.e. system design, UI screens, etc.) and confirm with business users that the business or system requirement meet overall business objectives.
• Involved with System Installation Group (SIG) users to validate system analysis business logic and make sure there is no impact to the existing system.
• Participated in business requirements and design sessions for a specific component or scope of the product.
• Responsible for analyzing the business requirement and translating into systems specification document to support business process, organization and technology change.
• Responsible for REST API and SOAP API web services testing
• Involved in brain storming activity with team to bring better technology and efficient solution of system design.
• Detect change requirements, gap analysis and escalate issues.
• Execute stored procedures step by step to complete flow of end to end testing from source systems to End of user application.
• Worked with QA closely to ensure the business and system requirements were covered in test scenarios.
• Conducted system analysis testing to reduce defects prior to the product move to QA.
• Involved with business team, technology team to define, coordinate and execute User Acceptance Testing (UAT)
• Involved in obtaining business & technology sign-off on Systems requirement document.
• Involved in Technical Specification document review and given inputs on system impact.
• Involved productively in an Waterfall project utilizing continuous integration and continuous deployment code delivery environment
• Involved in defect triage meeting with QA/ project team and follow up for the defects closure and retest.
• Involved in project estimation and helping team to achieve the project time line.

Environment: .Net, Java, JSP, SOA Test, SOAT UI, Para soft, Swagger, Rest and Soap Web services, XML, HTML, Oracle PL/SQL, Mainframes, DB2, Sybase, SQL Server, RAPID Sql.

Confidential

Business Systems Analyst

Responsibilities:

• Responsible for requirement gathering, analyzing system impact and feasibility.
• Responsible for writing user stories using UML, updating product backlog and testing.
• Generating specification by writing use cases, business validation and business Logic.
• Responsible for reviewing Databases design and analyzing impact.
• Responsible for data analysis, data migration and data validation.
• Involved in target data mappings, business rules and data definitions.
• Responsible for functional testing, writing test plan and executing test cases.
• Responsible for communicating with third party vendor for application integration support.
• Played a key role in performance testing, reviewing SQL queries and testing to minimize the fetching response times to minimal as possible.
• Performed server performance monitoring and deployment activities.
• Responsible for Web Services (SOAP and REST protocols) testing.
• Responsible for writing user stories, maintaining product backlog, prioritization and assisting with development estimation
• Participation in daily standups, sprint planning, review meetings, retrospective meetings and sprint demonstrations and play back sessions.
• Involved in System Testing, System Integration Testing, UAT Support and Post Production Application Support.

Environment: Sql Server 2012, Visual Paradigm, JIRA, Confluence, New Relic, Java, Web Services, XML, XSLT, JQuery, CSS3, HTML5, Java Script, ANT, SVN, Jboss, MS Excel, FS Capture, Java, Linux.

Confidential

Responsibilities:

• Gathering Requirements from existing system, adding new features and impact analysis.
• Responsible for generating functional specification by writing Use Cases, Business Validation and Business Logic.
• Responsible for database analysis, written test validation scripts and performed the system testing.
• Involved in data analysis, database impact and development.
• Involved in data validation and data migration activities.
• Worked with developers during coding and reviewed queries.
• Created data quality mapping documents.
• Designed and implemented report layouts as per client requirements.
• Involved with development team to improve report performance and performed system testing.
• Responsible for project walk-through with developers and level 1 support.
• Involved in System Testing, System Integration Testing, UAT Support and Post Production Application Support.
• Responsible to handle all issues raised by UAT and liaising with them for UAT Issues sign-off.

Environment: Agilian Visual Paradigm, JIRA, Confluence, HP Quality Center, Java, New Relic HTML, ANT, SVN, SQL Server 2012, Jboss.

Confidential

Senior Product Analyst

Responsibilities:

• Involved in all requirement gathering and impact analysis activities.
• Reviewing the client requirements and business specifications, analyzing the impacts and feasibility.
• Review the application structure, database design to development and testing teams.
• Played a key role in performance tuning SQL queries, writing PLSQL procedures to minimize the fetching and saving response times to as minimal as possible.
• Worked on completely redesigning the user interface of the application and ensured the consistency in testing phase in the cross browser environment.
• Application support from bank users after product implemented in different countries.

Environment: Java, Struts 1.3, Web Services, JSP, PL/SQL, JUnit, Log4j, XML, XSLT, JQuery, CSS, HTML, ANT, SVN, Oracle 11g, Apache Tomcat, Web sphere.

Confidential

Software Engineer

Responsibilities:

• Responsible for monitoring and regular application maintenance.
• Redesigned and improved user interfaces in searching and optimized the SQL query performance.
• Worked closely with business teams to ensure the change request has been aligned with business request.
• Designed and developed a web application for managing and tracking internal users.
• Extensively worked on Java, JSP, PLSQL, HTML, JSS and JQUERY.
• Responsible for manual testing of application.
• Responsible for production support and offered knowledge transfer session for support teams.

Environment: Java, PL/SQL, JUnit, MVC Framework, Log4j, XML, Javascript, XSLT, JQuery, CSS, HTML, ANT, SVN, Oracle 11g, Apache Tomcat, Web sphere.

Confidential

Software Engineer Trainee

Responsibilities:

• Involved in Logical development of the application.
• Analyzing the existing database layer and preparing technical specs.
• Coding the struts layer, Business layer and database layer.
• Responsible for manual testing.

Environment: Java, JSP, Servlets, Struts MVC Framework, Hibernate, JUnit, Log4j, XML, Javascript, XSLT, JQuery, CSS, HTML, ANT, SVN, Oracle 11g, Apache Tomcat.