| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Phone No: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLESUMMARY:Over all Fifteen plus years of experience in Information Technology field with Fourteen years experience in Programming and extensive background in Oracle development, information gathering and analysis, system testing and monitoring, documentation, and technical support.Analysed, Designed, and Implemented different stages of Data Warehouse.Proficient in the use of SQL, PL/SQL, SQL*PLUS, TOAD, Stored procedures, triggers.Hands on experience in Black Box Testing, Manual and Automation testing and creating generic, reusable, efficient and effective automated Test Functions and Scripts in VB script.Programming knowledge on different data sources ranging from flat files, Oracle, SQL Server, DB2 databases and XMLExperience in performance tuning of sources, mappings, targets and sessions.Expertise in Development of applications using Java, J2EE, JDBC, JSP, JMS, Servlet, EJB, JNDI, RMI, LDAP, AJAX, HTML, Java Script.Used UNIX shell scripts to run sessions using pmcmd command.Experience in UNIX working environment, writing UNIX shell scripts.Experience working on Informatica and Sales ForceUsage of import /export wizard to transform data from various ODBC sources.Worked on Web based Applications.Strong knowledge in Oracle 10g, 9i, 8i Servers.Experience with UML to represent organizational structures.Very strong in back-end testing using SQL, PL/SQL, TSQL queries and other utilities like Quest Central, SQL Load, SAS, Export/Import, Telnet and FTP.Strong analytical, problem-solving, organizational, communication, learning and team skills.Comfortable as a great team player as well as an independent in any project assignments.EDUCATION:Masters in Electrical Engineering 2007 Batch GANNON UNIVERSITY, PATECHNICAL SKILLS:Operating SystemWin NT/95/98/2000/XP, MVS, AS/400, Unix/AIX and Linux.Internet TechnologiesASP,.NET, JDK1.2, JDBC, Servlets, RMI and EJB.LanguagesJava, VB 6.0, SQL, PL/SQL, JCL, HTML, Java script, COBRA, VBScript, C/C NET, JSP and ASP.GUI/ToolsVisual Basic 4.0/5.0/6.0, SAS EG, Visual SourceSafe, CICS, EXTRA, Quest Central, TOAD, SQA Navigator, Swing and MS Office.RDBMSDB2, Oracle 10g, 9.i, 8i, SQL server, MS-Access.Web ServerWeb Logic Server, Web sphere, Java Web Server and I planet.Web TechnologiesStruts, Spring, Hibernate, JSP, Servlets.PROFESSIONAL EXPERIENCE:Project: Enterprise Permit Land Usage, City of Jax, Jacksonville, FL Jan 2017 Till DateSr. Quality AnalystThe City of Jax is the legislative body of the City of Jacksonville's consolidated government and is responsible for making the laws that govern our way of life. The 19 Council Members, who are elected to four-year terms and serve as part-time legislators, have almost unlimited power to enact legislation in order to provide for the needs of our community. The Department of Public Works is the primary caretaker of all city-owned properties and infrastructure. Our mission is to maintain and improve our city's assets with dependable, professional and willing employees who are committed to excellence in customer service and satisfaction.EPLU : The Building Inspections Division (BID) is responsible for ensuring that existing and future developments and construction comply with the Florida building codes and the Citys building ordinances. The purpose of this document is to serve as a guide for configuration of the new system. This document specifically addresses Electrical Permits and defines the following:Current business rules, requirements, and data elements that must remain in the new systemCurrent business rules, requirements, and data elements that will not be included in the new systemNew business rules, requirements, and data elements to include in the new systemData element relationships and how they affect the permitting process as a wholeAssumptions, constraints, risks and process recommendationsAny other information pertinent to configuration of the new systemResponsibilities:Overall responsibility for multiple test phases.I am the only QA from start to end for this project.Presented testing status to internal and external audiences.Created templates for Test Plans, Test Cases and Defect Report.Internal/External Application: Extensively involved in testing internal and external services of this Application for different User access (Applicant, Gatekeeper, Reviewer and SysAdmin).Performed ADA Testing for the Users as per Rehabilitation ACT of 1973.Used HPE Service test tool to test the Load testing under severe Load.Load /Performance Testing: Involved in support to load and performance test.Provide single point of contact for all business Users.Lead daily defect meetings and capture, manage and follow-up daily action items.Under very aggressive deadlines designed, developed and executed comprehensive test plans for functional and system testing.Implemented whole life cycle of QA methodologies starting from Planning, Capturing, Creating, Executing, Reporting and tracking the defects using ALM 15.5Presented testing status to internal and external audiences.Worked on different tools such as IBMi Main Frame, iSeries BLUE, iSeries ORANGEInvolved performing system and regression testing during the Maintenance Phase of the Application.Participated in User Acceptance Test (UAT), documented procedures and guiding the users in verifying various transactions on the system.Environment : Java,J2ee,EJB,XML, Quality Centre 15.5, VB Script, DB2,, Rational Requisite Pro 7.0, Web Logic, SQL, Windows 2000,, iSeries, Windows 7, QTP 10/11, Oracle 11g, HP Screen recorder, IBM data studio, EAS, Mainframes.Project: Leads, LANDSTAR, Jacksonville, FL Mar 2016 Jan 2017Quality AnalystLandstar System, Inc. is a worldwide asset-light provider of integrated transportation management solutions delivering safe, specialized transportation services to a broad range of customers utilizing a network of agents, third-party capacity owners and employees.LEADS:Load Alerts: The Load Alerts application will provide the user with the functionality to manage subscriptions and receive alerts when available loads are posted meeting their subscription criteria. This project presents the opportunity to improve the efficiency with which BCOs can find loads that meet their business needs. By setting up automatic searches for loads that meet their business objectives and then the system sending them a message concerning that load, BCOs have more control over their business and have to spend less time searching for loads.CatchUp: When a BCO or Carrier available location or available time changes and the has an Follow Me Load Alert SSC set up, the Follow Me Load Alert SSC will be enabled and the system will also run a search for existing load opportunities that match the Follow Me Load Alert SSC and send out a single email with the information on those loads. There will be no limit on the number of loads returned in a Catch-up email.BS29: Agent need loads that require validation to be identified before they are removed from the Landstar Board, so that they have the opportunity to validate the load before it is moved to the Agent Board. The Available Loads Validation process shall be limited to available loads on the Landstar Board that are in "A" status. Available Loads Validation Notification e-Mail shall ONLY be sent if there are loads to be validated.Responsibilities:Overall responsibility for multiple test phases. Reviewed and analyzed the System Requirement Specification and Design documents.Interacted with business analysts, developers to understand the requirements, application functionality and navigation flow.Interfaced with multiple application development groups, test groups and project managers.Wrote SQA test documentation such as test plans, test cases, test scripts using RQM toolUsed Conduct Test approach and Test script review meetings every release with business lead, different business teams as well with development, Analyst team and with testing manger to take the inputs for not covered scenarios.Performed Functional, Regression, Build Acceptance, End-to-End Testing, UAT on multiple browsers (Chrome, Firefox, IE, etc).Performed QA Smoke, Acceptance, Regression, Functional, UI, Usability and Compatibility Testing.Run Compatibility Testing (cross Windows/ Mac and Android/ iOS platforms, cross browsers, cross mobile devices - phones, tablets, iPads etc).Worked in Agile (SCRUM) development environment with frequently changing requirements and features.Requirement Traceability Matrix to ensure 100% test coverage.Prepared and reviewed the test results and verified it against the expected result.Execute test cases, check and document results to ensure the system's technical and functional requirements are met.Performed both positive and negative testing.Reported and kept tracking of found Defects in RTC toolWrote and executed SQL queries to validate database content and verified correctness of business logic.Participated in User Acceptance Test (UAT), documented procedures and guiding the users in verifying various subscriptions on the system.Environment : LEADS, RQM, RTC, IBMi, TrackIt, System iNavigator, Web Logic, SQL, Windows 2000, Windows 7, Oracle 11g, Mainframes.Project: Bid Management, CSX, Jacksonville, FL July 2014 Feb 2016Sr. Quality AnalystCSX is a leading supplier of rail-based freight transportation in North America. CSX Corporation, together with its subsidiaries based in Jacksonville, FL, is one of the nation's leading transportation suppliers. The companys rail and intermodal businesses provide rail-based transportation services including traditional rail service and the transport of intermodal containers and trailers.Responsibilities:Overall responsibility for multiple test phases.Presented testing status to internal and external audiences.Created templates for Test Strategy, Test Plans, Test Cases, Defect Report, Periodic and End of Project reports. Created examples and instructions to accompany each template.Internal/External System Communication: Extensively involved in testing internal and external service communication modules (JRE, Siebel, OPD, CIP, prime and AUT).Developed Automated test cases and executed. Extensively used the record and Playback framework functionality by using QTP.Extensively use EAS to check the system logs when we encounter issue while communicating to internal or external vendors/systems.Checking the status of consuming message process in internal logging system.Web service: Validated Web service modules using Soap UI tool. Possess understanding of WSDL, schema, XML documents for Web Service Testing.Used HP Service test tool to send the required/modified request and validated response.Mainframe: Access CICS screens to validate the internal system (CIP) using IBM 3270 terminals.Control-M/Batch Jobs: Used ran the Control-M/Batch Jobs using putty in lower environments by logging in to required Unix boxes.Data patches: Worked on the SQL Statements for Data patches to resolve the data inconsistencies and to maintain Data integrity.Load /Performance/Automation Testing: Involved in support to load, performance and did automation testing.Provide single point of contact for all vendor issues to the tool vendor, liaise with the vendor on a weekly basis to review outstanding issues.Lead daily status meetings, defect meetings and capture, manage and follow-up daily action items.Trained and guided all newly hired members of the team with the new and existing technologies.Under very aggressive deadlines designed, developed and executed comprehensive test plans for functional and system testing.Apply technical expertise to organize and implement black-box test efforts and to analyze requirements for software design, development and validation.Conducted Functionality, URL link Testing, Security Testing and Regression Testing during the various testing phases of the application using QTP.Verified the rectified bugs by testing the application both manually and executing the scripts using Quick Test Pro.Implemented whole life cycle of QA methodologies starting from Planning, Capturing, Creating, Executing, Reporting and tracking the defects using ALM 11.Inserted check points where needed to compare the current behaviour of the application being tested to its earlier version using QTP.Involved performing system and regression testing during the Maintenance Phase of the Application.Participated in User Acceptance Test (UAT), documented procedures and guiding the users in verifying various transactions on the system.Environment : Java,J2ee,EJB,XML, QTP, Quality Centre 11.0, VB Script, DB2,, Rational Requisite Pro 7.0, Web Logic, SQL, Windows 2000, Windows 7, QTP 10/11, Oracle 11g, HP Screen recorder, IBM data studio, EAS, Mainframes.Project: Sapphire, BCBS, Jacksonville, FL Mar 2013 July 2014Sr. Quality AnalystSapphire is a UI Application based on Med Advantage and Medicare Supplementary information for patients who are over 65 years old. This application gives the information of what all plans the members are enrolled with disabilities and also other personal information. The data from this UI is keyed into Siebel Applications.Responsibilities:Studying the entire application management process, procedures, identifying areas for improvements and implementing the same.Participated in project planning sessions and all technical client meetings.Working on Databases and Data warehouse Design.Used the Informatica tool to load data from wide range of sources such as flat files, Oracle and Xml into the target database.Created Scripts for improving the performance of the SystemPerformed the Back-End testing to ensure data consistency on front-end by writing and executing SQL queries on the database.Developed SQL queries to validate conversion requirements and the format of legacy data.Carried out testing to check whether the application was functioning as per the Business rules and functional documents.Defined problems in test data and determined alternatives and initiated corrective action to recover/restore data and return system back to normal operationsEnvironment: Informatica, SQL Navigator, Mercury Quality Center, Rational Clear Case, DB2, Oracle 10g, Unix.Project: Medicare Advantage, Davita, Nashville, TN Mar 2012 Mar 2013Programmer AnalystDaVita Inc., a FORTUNE 500 company, is a leading provider of kidney care in the United States, delivering dialysis services to patients with chronic kidney failure and end stage renal disease. DaVita strives to improve patients quality of life by innovating clinical care, and by offering integrated treatment plans, personalized care teams and convenient health-management services. As of March 31, 2012, DaVita operated or provided administrative services at 1,841 outpatient dialysis centres located in the United States, serving approximately 145,000 patients. My project work dealt with Medicare Advantage and King Fisher Claims. DaVita supports numerous programs dedicated to creating positive, sustainable changes in communities around the world.Responsibilities:Involved in gathering Requirements, Preparing Functional Specifications, Design Reviews and Test Plan Reviews.Created the Test Plans, Test Cases, Test Scripts.Imported the test cases into Mercury Quality Center.Performed the testing for UI Application during all phases of Testing Starting from System, Integration and Prod.Tested the Full Application (King Fisher) from the scratch by validating all the fields with dropdowns and check fields.Tested the Application by giving some Negative data to see whether the application throws the error.Tested Logical Flow of Data Conversion through the UI from each field.Tickled the Claims so to make sure that the Transbots pick these claims and insert them into the Application.Inserted all the Claims (both PAPER BATCHES and 837s) with Financial data so the Application can reflect the claims information as per the design.Carried out testing to check whether the application was functioning as per the Business rules and functional Specs.Performed the System Testing, Integration, End-End and Regression testing to ensure data consistency on front-end UI by writing and executing SQL queries on the database.Logged the defects into QC and did regression testing once the defects got fixed.Developed SQL queries to validate conversion requirements and the format of legacy data.Participated in walkthroughs and technical reviews to report testing status.Worked closely with BAs, UIs and Developers to meet the requirements.Excellent Communication and Multi-tasking skills developed from previous experiences.Environment: Mercury Quality Center, PL/SQL, Transbots, Maxine, Focus, Oliver, DB2, Oracle 10g, UNIX.Project: SRMW, BCBS, Jacksonville, FL Jun 2009 Feb 2012Sr. Quality AnalystSiebel Relationship Management Warehouse (SRMW) of Blue Cross and Blue Shield serves as a major health Care for Health Information in form of Care Reporting, Group Arrangement information, Financials, Claims, Claims Paid Locations and Provider information which enables the Enterprise to better understand our customers. This foundation will provide the ability to identify correct data from multiple sources within SRMW to make intelligent business decisions.Responsibilities:Studying the entire application management process, procedures, identifying areas for improvements and implementing the same.Participated in project planning sessions and all technical client meetings.Working on Databases and Data warehouse Design.Created TSQL, PL/SQL (Functions, Procedures, Packages and Triggers) and Shell Scripts for improving the performance of the SystemPerformed the Back-End testing to ensure data consistency on front-end by writing and executing SQL queries on the database.Worked on 835s and 837s Files to extract the electronic dataCreated SQL queries using SAS to check data flow in the various Databases.Developed SQL queries to validate conversion requirements and the format of legacy data.Carried out testing to check whether the application was functioning as per the Business rules and functional documents.Developed the SQL Procedures and SQL queries to validate the reports.Involved in Developing SQL scripts for database testing using SQL and PL/SQL. Extensive experience in Database Testing on Oracle and SQL servers.Defined problems in test data and determined alternatives and initiated corrective action to recover/restore data and return system back to normal operationsProvided the Application Support for Post-Production ProcessDeveloped SQL and Shell scripts to create temporary tables and developed SQL*Loader scripts to load data into the temporary staging tables.Environment: SAS Enterprise Guide 4.1, Mercury Quality Center, Web Report Studio, Rational Test Manager, Rational Clear Quest, Rational Clear Case, DB2, Oracle 10g, SQL Server 2005, PL/SQL, TSQL, Quest Central, SQA Navigator, Unix and Windows NT.Project: EDW, BCBS, Jacksonville, FL Oct 2007 May 2009Programmer AnalystEnterprise Data Warehouse (EDW) serves as a foundation for Group, Group Arrangement information, Financials, Claims, Claims Paid, Locations and Provider information, which enables the Enterprise to better understand our customers. This foundation will provide the ability to identify correct data from multiple sources within EDW to make intelligent business decisions. The EDW is Information management's architect solution for the storage of enterprise and consumer related data.Responsibilities:Analysis and evaluation of user requirements.Oversaw requirements tracking process with Mercury Quality Center.Created SQL queries to check data flow in the various Databases.Generated SQL queries to validate various reports, loads and extract process.Developed SQL queries to validate conversion requirements and the format of legacy data.Carried out testing to check whether the application was functioning as per the Business rules and functional documents.Developed the SQL Procedures and SQL queries to validate the reports.Developed SQL queries for execution of Test cases.Developed SQL queries to validate conversion requirements and the format of legacy data.Tested the application in all the phases.Used graphs and reports to analyze the applications performance.Provided 24*7 Admin support to ensure application is up and running all the time.Provided support and proposing solutions to various functional groups who host their Business Objects in our Shared Data warehouse environment. Few of them include HR, LMS, Express, Taxes, TMS etc.Environment: Rational Test Manager, Rational Clear Quest, Rational Clear Case, DB2, Oracle 8i, Ab Initio, Quest Central, SQA Navigator, EXTRA, UNIX and Windows NT.REFERENCES:Available upon request |
