Data Analyst/tester Resume
Lancaster, PA
SUMMARY
- Over ten years of experience in financial and banking industry, wif expertise in Client Acceptance Testing, Business Acceptance Testing, Data Analysis, Project Management and Business Analysis,
- Worked on various projects that include test strategy design, project planning, test execution, defect resolution, progress reporting and test data management.
- Has partnered wif various businesses and technology consulting organizations and has proven to has teh ability to work cross - functionally.
- Strong Experience in testing tools such as Quality Center, QuickTest Professional (QTP), TeamTrack, KDA (Keynotes Device Anywhere), Requirements Traceability Matrix, Agility, VISA
- Manual and Automated Testing
- Well versed in VB scripting and descriptive programing frameworks
- Software design, documentation and business requirements development
- Data analysis, data mapping, SQL development
- Deep noledge of retirement contribution process and mutual funds platforms.
- Profound noledge in buying and selling mutual funds, ETFs and stock trading
- Strong processing noledge of Vendor Supported application such as AWD (Automated Work Distributor) for daily monetary and demographic transactions and multiples other functionalities
- Solid expertise in testing tools such as HP Quality Center, TeamTrack, Agile Methodologies, SDLC, PMLC
- Competent on leading initiatives for integrating or adding new functionalities to legacy systems
- Experience in User Acceptance Testing, Business Acceptance Testing, Accessibility Testing, System Acceptance Testing, Functional Testing, Regression Testing, Blackbox, Conformance Testing, Compability Testing.
- Subject Matter Expert in Banking System processes such as New Account Creation, Additional Purchase processing, Loan Issuance Processing, Wifdrawal Processing etc…
- Well versed in test planning, approach development, scripting and execution management
- Program and project delivery management of major capital markets initiatives
- Business Process Improvement and Workflow Reengineering
- Operations and Technology Platform Transformation noledge of Market data, reference data, pricing and valuation, portfolio accounting, fund
- Experience wif Trade Life Cycle and noledge of various investments instruments such as mutual funds, fixed incomes and other securities
- Expert in Individual Retirement Account and 401(k) account process
- Vendor Package Selection & Implementation
- Quality Assurance Coordination
- Requirements analysis, business analysis, scoping, planning and implementation roadmap development
- Testing strategy design, scenario and conditions development, scripting and execution management
TECHNICAL SKILLS
Platforms: Windows 8x/7/Vista/XP, Mac OS
Languages: SQL, HTM, MS Access, Excel ProgrammingTools HP ALM/ Quality Center, QuickTest Professional UFT/QTP, Lotus Notes, Microsoft Office Suite (Word, Excel, PowerPoint, Access, Project, Outlook), SharePoint, Visio, TeamTrack, KDA, ClientFinder, SharePoint, Agility, Planview, EnviroNet, FileNet, VISA, Wave, Web, AWD, VAST, BETA, JD Edwards EnterpriseOne, SalesForce, Client Data Management Engine
PROFESSIONAL EXPERIENCE
Confidential, Lancaster, PA
Data Analyst/Tester
Responsibilities:
- Studied and analysed in-scope applications and interviewed business users to gather requirements for various projects
- Worked wifin a team of Data Analysts, to analyze, review, update, edit, clean, translate, and ensure accuracy of customer data.
- Partnered wif business groups to coordinate all data set up for various applications during system migrations and upgrade
- Developed and executed SQL statements to fetch data out of systems that do not has a GUI, and utilize for analysis or reporting purposes
- Generated and maintained client reports based on functional group needs,
- Assisted in teh development and documentation of solution design, training documentation and user training sessions.
- Performed a thorough data analysis of teh different systems in scope and presented findings and layout detailed solutions for implementation
- Conducted Gap analysis for systems integrations and insured smooth implementation of teh overall project
- Administered teh Customer Relationship Management database by setting up new clients’ profiles, keeping data up to date and creating periodic reports for teh Technical Support Management team
- Worked wif teh developers to review codes protocol and helped wif teh System Acceptance Testing
- Coordinated testing activities, identified issues, and work wif developers as well as testers for resolution
Environment: Oracle, Microsolft Office, Jira, Basecamp, Sharepoint, Outlook, HP ALM/ Quality Center, JD Edwards EnterpriseOne (E1), Salesforce, QTTConfidential
Test Lead
Responsibilities:
- Coordinate and lead testing for an ERP implementation project in collaboration wif an IT team
- Led teh testing execution team on major systems integration for an investment institution: analyze existing systems for testing requirement development; advise testers.
- Managed a team of testers in creating test conditions, test scripts, use cases as well as develop a strategy for test execution
- Assisted in teh BAT (Business Acceptance Testing) efforts for approval signed-offs
- Led teh automation migration project from manual testing to automation using QTP tool
- Developed an extensive and detailed plan for teh implementation covering tasks schedules, technology requirements and resources on boarding
- Developed an extensive data strategy that identifies required data for testing as well as a uniform approach for data ask, acquisition, set-up, and maintenance
- Routinely communicated and interacted wif Subject Matter Experts and Technology team to understand or clarify business process as well as applications functionalities
- Provided regular updates to senior management covering different subject such as testing execution status, defects management and resources requirement and challenges
- Interfaced wif multiple stakeholders, to analyse current state, identifying data sources and required data test execution
- Worked extensively wif teh BA pillar, teh Technology team, Operations and teh Testing pillar to develop a tool for managing teh traceability of all requirements and aspects involved in teh SDLC
Environment: Oracle, Mainframe, Microsolft Office, Sharepoint, Outlook, HP ALM/ Quality Center, QuickTest Professional (QTP), Agility
Confidential
Business Analyst
Responsibilities:
- Defines project requirements by identifying project milestones, phases, and elements; forming project team; establishing project budget.
- Developed Business requirements and domain expertise for teh development of system requirements, scenarios, test scripts and implementation
- Frequently took part of teh Business Acceptance Testing for production ready
- Led requirements sessions and wrote Functional Specifications Documents as well as Business Requirements Documents and collaborated wif IT developers for teh implementation
- Recommended controls by identifying problems; writing improved procedures.
- Monitored project progress by tracking activity; resolving problems; publishing progress reports; recommending actions.
- Maintained system protocols by writing and updating procedures.
- Provided references for users by writing and maintaining user documentation; providing help desk support; training users.
- Prepared technical reports by collecting, analyzing, and summarizing information and trends.
- Improved systems by studying current practices; designing modifications.
- Actively participated in smoke and ad-hoc testing to insure complete system quality
Environment: SQL Server, Microsolft Office, Jira, Basecamp, Sharepoint, Outlook, HP ALM/ Quality Center, MS Project
Confidential, Malvern, Pennsylvania
Test Lead
Responsibilities:
- Led a team of testers through planning and execution on major Confidential Systems integrations that consist of generating work objects for nightly mutual funds and brokerage transactions rejects via AWD
- Worked wif processors and Quality Assurance Associates in developing testing strategies, test plans, test execution and implementation for new AWD features and upgrades.
- Participated in requirements gathering sessions to fully understand business functionalities and processes in order to design test conditions and develop test scripts
- Coordinated teh User Acceptance Testing and Business Acceptance Testing efforts for product release
- Reviewed test scripts wif teh Business Analysts and Subject Matter Experts to integrate their feedback and achieve a higher quality of test scripts
- Participated in SME workshop to identify Test cases eligible for Automation using QTP
- Introduced Automation best practices, standards and check list on various projects
- Assisted in teh development of QTP automation scripts for Regression Testing, Negative testing, and repeatable test cases
- Built data input, designed data collection screens, discussed intelligence and information requirements wif internal and external personnel.
- Worked wif Test Data Management Team to determine data scope, acquisition processes and set-up and maintenance
- Generated teh traceability matrix that links teh different project artifacts (Functional Requirements, Business Specifications, Test Conditions, Test Scripts) to help ensure a full and thorough testing was accomplished by teh team
- Recorded and documented test results in HP Quality Center and TeamTrack and manage defects resolution
Environment: Oracle, Mainframe, Microsolft Office, Lotus Notes, Sharepoint, Outlook, HP ALM/ Quality Center, QuickTest Professional (QTP), TeamTrack, Keynotes Devices Anywhere (KDA), Clientfinder, Agility, Planview, EnviroNet, FileNet, VISA, AWD, VAST, BETA
Confidential, Malvern, Pennsylvania
QA Analyst
Responsibilities:
- Maintained different aspects (data, environments, vendors, test lab management etc.) of testing process that affects teh Investment Management Group by working wif teh Tech team to ensure their availability and updates
- Coordinated processing of incoming clients requests such as Additional Purchases, New Accounts, Wifdrawals, Loans using Confidential Business Management Processing (BMP)
- Performed Different types of testing on various tablets using KDA (Keynote Device Anywhere) such as iphone, Android, Galaxy…
- Defined entry and exit criteria. Created Test Summary Reports. Contributed to post implementation reviews to assess teh effectiveness of teh testing solution.
- Assisted in defining, provisioning and validating appropriate test data to ensure proper test execution.
- Worked closely wif teh business, and demonstrated functional processing expertise serving as a Subject Matter Expert
- Analyzed existing workflows and used teh information obtained to lead discussions and advocate teams to identify operational opportunities, and work collaboratively to implement process/service improvements
- Provided coaching to new hires on User Acceptance Testing curriculum. Provide Training to new hires and less tenures analysts on various testing tools such as Quality Center, TeamTrack, InfoDevl, etc.
- Served as SME to Business and Development team during data analysis and project requirements sessions
- Actively engaged in departmental programs as VUE Ambassador or as part of teh team. Participate in Special Projects
Environment: Oracle, Mainframe, Microsolft Office, Lotus Notes, Sharepoint, Outlook, HP ALM/ Quality Center, QuickTest Professional (QTP), TeamTrack, Keynotes Devices Anywhere (KDA), Clientfinder, Agility, Planview, EnviroNet, FileNet, VISA, AWD, VAST, BETA
Confidential, Pennsylvania
Data Analyst
Responsibilities:
- Met wif functional teams to identify and understand data needs for current or new system implementations
- Developed data specifications document necessary for fetching and uploading data into systems for initial testing
- Complete numerous monthly reports and inform and change reports on request
- Develop new reports where suitable
- Created data trace map and data quality mapping documents.
- Document all data mapping and transformation processes in teh Functional Design documents based on teh business requirements
- Served as point person for fielding functional teams inquiries on data maintenance and updates
- Administered teh Customer Relationship Management database by setting up new clients’ profiles, keeping data up to date and creating periodic reports for teh Technical Support Management team
- Worked wif testers to investigate defects related to data and propose resolutions
- Trained data analysis beginners to improve overall efficiency of department.
Environment: MS Access, SQL Server, Microsolft Office, MS Project
