We provide IT Staff Augmentation Services!

Programmer Analyst Resume

SUMMARY:

  • Core experience in gathering Business - IT Requirements & clearly translated them to technical and non-technical team.
  • Proficient in System Development Life Cycle SDLC, Waterfall and on Agile, SCRUM.
  • Experience in developing Windows and Web Applications based on various architectures using Java, J2EE, Struts, HTML using databases Oracle and MySQL on Tomcat Server.
  • Hands on experience using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.), Creating & Updating tables and checking the database consistency by executing DBCC Command.
  • Experience in Query Optimization, Performance Tuning, Client/Server Connectivity, and Database Health Check, Indexing, and Updating Statistics.
  • Unit Testing experience with Mockito.
  • Experienced in designing Test Plans and Test Cases, Verifying and Validating Web based applications and Documentation based on standards for Software Development.
  • Experienced in back-end testing using SQL queries and Shell scripting to ensure Data Integrity and validate business rules.
  • Experience working on Struts for web tier development and Maven for build scripts.
  • Experience in Unit Testing, Integration testing, System Testing, Functional Testing, Regression Testing and Validation Testing.
  • Excellent Interpersonal, written & oral Communication, Presentation, writing Project Documentation and Influencing Skills.

TECHNICAL SKILLS:

Programming Languages: JAVA, J2EE, C, C++, MATLAB

Web/XML Technologies: HTML, CSS, JSP, Maven, Jav a S c rip t, X M L, Spring MVC

Databases: Oracle 10g, MySQL, MS SQL Server2012, PostgreSQL, MS Access, SSIS, SSRS

Operating Systems: UN IX, W indo w s, L INU X, Mac

Tools: Quality Center, Test Director, Mockito, Selenium, JIRA, SharePoint, MS Office, MS Visio, Tableau

Project Methodologies: Waterfall, Agile, Scrum

Frameworks: Spring MVC, Web API

Version Control Systems: Tortoise SVN, TFS, Git

IDE s: Eclipse, IntelliJ, Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential

Programmer Analyst

Responsibilities:

  • Participated in the requirement analysis and Solution meetings.
  • Involved in the creation of the Process flows, Use cases, Class diagrams and Sequence diagrams for the analysis and design of the application.
  • Integrated business analysis practices and techniques with both Agile/Scrum and Waterfall software development methodologies.
  • Ensure that the team understands business and data requirements to successfully meet the business goals.
  • Experience in maintaining huge database, involved in using complex stored procedures, views.
  • Defined and constructed layers, server-side objects and client-side interfaces based on J2EE design patterns.
  • Analyzing the data in tables and validating the work flow. Involved in writing complex SQL queries.
  • Designed and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
  • Worked in creating complex Stored Procedures, triggers, cursors, joins and statements for application.
  • Involved in designing the physical databases model on SQL Server 2008R2/2008 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
  • Performance tuning of Queries and Stored Procedures.
  • Defined and constructed layers, server-side objects and client-side interfaces based on J2EE design patterns. Enhanced the existing JAVA code classes of the Application for improving the performance.
  • Worked on Mockito tool for testing the classes.
  • Performed requirements analysis and using Rational Rose created UML specifics such as data flow diagrams (DFDs), ER diagrams, Use cases, Class, Sequence, Collaboration and Deployment Diagrams.
  • Developed Business Requirements Document (BRD), Business Process Documents, Functional Requirements Document (FRD), Use case diagrams, Test Case and other Process flow diagrams.
  • Defined detailed user stories and acceptance criteria in collaboration with the product owners and technology team
  • Used Share point, Advanced Excel, PowerPoint for content management and document management.
  • Worked on JIRA for bug tracking, issue tracking and project management functions.
  • Assisted and coordinated integration and User Acceptance Testing (UAT) prior to the release of new data feeds into production. Assisted Business in logging defects from UAT.
  • Created Test Plan, Test cases for User Acceptance Testing, coordinated in UAT testing to check any defect, also helped Product Owner to prioritize product backlog items.
  • Extensive experience lead to communicate clearly and confidently and able to influence Stakeholders, project team members and Senior Management.
  • Developed communications and presentations for high-level audiences with Visio and PowerPoint
  • Interact professionally with a diverse group of senior business managers and subject matter experts
  • Mentored new hires in the project team and conducted project related seminars for peers.

Environment: Java, J2EE, SQL Server Management Studio, IntelliJ, Struts, Mockito, Quality Center, HTML, XML, Java Script, Spring, MS Share Point, Excel, MS Visio, Windows.

Confidential

Analyst

Responsibilities:

  • Documented the project works and process.
  • Maintaining the jobs Schedules and Backup and Restoration of Databases.
  • Implementation of SQL logins, roles and authentication modes as part of security policies for various categories of users
  • Used SQL Server Profiler to monitor and record database activities of particular users and applications.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Regular data consistency checks. Monitored database system and execution time.
  • Optimized query performance by creating indexes.
  • Successfully migrated SQL Server 2000 databases to SQL Server 2005.
  • Create a daily report for all production servers.
  • Attended Weekly and daily Status Meeting.
  • Performed Manual Testing on the data and reported the errors.
  • Prepared unit test cases for system testing.

Environment: s: SQL Server 2000/2005, Windows XP, Quality Center, QTP, Excel, MS Project

Hire Now