Primary Skills
SDLC, Requirement Gathering, System Analysis, Process mapping, Reporting and Documentation. SQA/testing.
Location
US-NJ-Old Bridge
Posted
Aug-15-09
RESUME DETAILS
Professional Profile • Accomplished IT professional with over 11 years of solid experience in all phases of the Software Development Life Cycle, business analysis, project and business relationship management, project research and analysis. • In-depth applications development and project management expertise in package goods marketing, sales, and operations, domestically and globally. • Expert at engaging Business, IT and Vendor stakeholders through transformation of business needs into realistic and cost- effective system requirements. • Proven track record of delivering business process applications that solve business problems, increase sales, reduce cost and boost productivity. • Ability to prioritize, plan and track project progress from concept to completion. • Expertise in Testing Methodologies, including Black Box Testing, White Box Testing, System Integration, Usability, Performance, Functionality, Regression, Security, User Acceptance Testing. • Focused in process-oriented Quality Assurance with experience in gathering Business Requirements, Functional Requirements and Design Documents. • Proficient in analyzing functional requirements of a system, developing test requirements and designing and executing test plans and test cases. • Ability to work with other departments, users and clients. Highly adaptable and quick to learn, adept at analyzing situations and taking initiative to solve problems.
Technical Background Software: Visual Studio 6.0/2005, Microsoft SQL Server 6.0/7.0/2000-2005, Oracle 7, 8.0/8i, 9, MS Access, MS Office Suite, MS Visio, MS SharePoint, Crystal Reports 7.0, Active reports, InterDev 7.0, TOAD, QTP/Load Runner (learning knowledge). Languages: Visual Basic 6.0, VBA, VBScript, JavaScript, HTML, ASP, VB.Net, C#, PL/SQL, ADO, ADO.Net
Professional Experience
Revlon, Inc., New York, NY 2000 - 2009
Sr. System Analyst, QA Performed as a senior tester analyst responsible for coordinating and overseeing various projects. Assumed responsibility for overall test/requirements, project management and testing support for multiple concurrent projects. Worked in accordance to QA methodology, project schedule and time lines. Worked to define, develop, formalize, and implement test systems, procedures, standards, and methodologies supporting Revlon's Software Development Life Cycle (SDLC). Solid input for ensuring proper execution of all test procedures. • Assisted in creating and analyzing technical and business requirement documents in order to establish appropriate understanding for testability and test coverage. Assisted with identifying any gaps between system functionality and business processes. • Responsible for the design, implementation, and maintenance of comprehensive test plans to ensure systems requirements are met. Participated in master test plan development and reviews. • Developed, implemented and executed detailed test cases based on business and technical requirements as well as use cases. Validated Test cases against requirement, modified the test cases based on the requirement change via Change request, and review modified test cases. Assumed the responsibility of proactively following up on any outstanding requirements or deliverables from business units across all levels of the organization. • Partnered with business and IT leads for specified application areas to review modifications, interfaces, conversions and change requests as needed. Analyzed and helped in modifying the Use Cases. Analyzed MS Visio's flow to understand Business Application. • Provided daily meetings with program and technical managers, business users to ensure understanding of current plan and phase scheduling, resource allocation, and level-of-effort expectations of the testing process. Worked closely with the programming team to identify and resolve system-related issues to meet business goals. Participated in structured code reviews/walkthroughs. • Performed functional, system, and regression testing manually. Conducted cross browser testing to check the compatibility with different Browser's (IE, Netscape, Mozilla). Performed Sanity testing for each new build of the application. • Coordinated testing schedules, communicated project status , established timelines and priorities, approved projects for production release. • Reported, documented, and logged in the Defect Tracking Tool all defects to ensure application software functionality for present and future builds. Worked with business and technical teams to manage defects until resolved. Recommended prioritization and potential corrective action. Coordinated user, technical, application, and business unit entities to ensure data integrity and effective reporting. Effectively worked in a team environment to get the job done with no defects outstanding. • Provided QA management with test case coverage reports and defect metrics to indicate status of testing efforts. • Participated in Production roll-outs and provided end-to-end support and post-implementation support to the customer community resolving production related issues. • Trained the end user group and documented the functional instruction and user guidelines for the same application. Interacted with various end user teams during user acceptance testing to gather feedback on application usability. • Worked with SQL functions to test the database integrity, wrote and executed SQL queries to retrieve and compare data, verified outputs against the Oracle database.
Sr. System Analyst, Application Development Designed, developed, implemented, and maintained Revlon Project Management System (RPMS), supporting over 500 users across the global enterprise with a single system for data inputs and outputs. Involved in the effort to expand RPMS into a matrix suite of new product development applications that supports the entire $1.4 billion Revlon enterprise from a single application supporting a limited number of users. • Led development, database operations, and desktop support in all phases of software development and support. (Visual Basic, Oracle, MS Access, and Toad environment). • Created new systems of classes and modules in the VB-6 environment for the RPMS application, reducing application set-up time from approximately one day to half an hour. • Facilitated requirement gathering sessions with the business team to collect the business standards, security and service level requirements and studied the business process resulting in the better quality of the product and saved development time. • Reviewed and analyzed application technical designs, specifications, and architecture to minimize costly rework. • Analyzed user requirements, procedures, and problems to automate existing RPMS systems and review application capabilities for enhancement to improve efficiency and marketability. • Identified and resolved problems across all new product development departments arising from conflicting user requirements reducing support call times. • Participated in new product development process task forces that play a major role in company reorganizations. • Collaborated with user community, including training and evaluating system enhancement requests. • Escalated problems to inform and make recommendations to senior management. • Developed and monitored project plans to scope work parameters and establish deliverables. • Participated in consulting with internal departments to identify business needs to ensure custom and purchased applications to meet business, time, and budget requirements. • Created and supported applications for business needs using the following: Visual Basic 6.0 Active Reports, Visual Basic .NET (including Windows Service), HTML and ASP (including VBScript and Java Script), Transact SQL (T-SQL). • Led project to convert Visual Basic 6.0 applications to VB.Net. • Extensive experience with Oracle Database: created and designed new tables, stored procedures, views; daily database updates by retrieving the data from various data sources as per the requirement of day to day business requirements, wrote complex SQL queries (Toad enviroment).
Waterhouse Securities/Marketware International Inc., Holmdel, NJ 1997 - 2000 Programer/Analyst -- Web Designer/Developer • Developed the Open Financial Exchange (OFX) Server project which is a specification designed to enable the exchange of financial data and instructions between customers and their financial institutions. The purpose of OFX is to enable a customer or small business to manage his finances electronically, to connect directly to his institutions via the computer and issue instructions to that institution as well as download his particular financial data. The OFX server was written in Visual Basic and used the SQL 6.5 Server on a Windows NT base. • Involved in the enhancement, maintenance, and implementation of COMTAPI (Common Trading Application Programming Interface) application -- Visual Basic front end that gives client service reprsentatives a single interface in which to manage clients and their accounts and control client activity through the setting of entitlement. • Designed and implemented reports for COMTAPI Adminsitrator and OFX Server, using Crystal reports software. • Project leader for the full development cycle of converting COMTAPI to Webbroker Help Desk -- Web Data Access Applications, using ASP, HTML, Interdev 6.0, VB 6.0, COM, SQL 7.0. • Project leader-designer for the Marketware Help Desks application: Internal application which builds on the Windows 2000 platform using ASP, DTML, Interdev 6.0, VBScript, Java Script, SQL 7.0.