Rupa Dsouza

Tel: 224-***-****

Email: ad15xk@r.postjobfree.com

Objective:

Presently seeking to join a company that rewards effort and initiative, while at the same time providing healthy work environment for progression and self-development opportunities.

15+ years of experience in the Information Technology Field within the Auto Industry (3 years), Trading / Finance Industry (6 years), Healthcare & Wellness Industry (3 years),

Manufacturing Industry (3 years), Pharmaceutical Industry (1 year), Telecom Industry (3 years).

Familiar with Agile, Waterfall & Iterative Methodology.

Facilitating meetings relating to project status as well as work in sessions.

Experienced in Project planning, budget planning, work estimation, resource allocation, defect resolution, risk analysis, and project metrics.

Experienced Business System Analyst with a demonstrated history of working in the information technology as both Developer and Business Analyst for a variety of Business Industries.

Strong Technical professional skilled in Oracle eBusiness Suite, SQL, PL/SQL, Microsoft Office, Relational Databases, Technical Application Support, and SDLC Methodologies.

Experienced in code development of web based as well as client server applications. Script-writing experience in HTML, PL/SQL, JavaScript and VBScript.

Experience with Business Intelligence – Creating Reports, Dashboards, Data Visualizations, via Tableau/OAC/OBIEE using data from Snowflake, Dremio, Azure Cloud Data Lake using SQL scripts or via Databricks using Python scripts.

Experience in Master Data - Creating Entity, Models, Business Rules in Master Data Services.

Experience in creating SSIS packages for ETL and Data migration and warehousing.

Experience in writing SQL procedures, PL/SQL Triggers, Functions, SQL Packages & Procedures built on Developer 2000 (Oracle Forms 6.x and Oracle Reports 6.x) on Windows 2000 server.

Excellent data analysis, creating test data for integrity and security validation. Possess good verbal and written communication and interpersonal skills.

Ability to work efficiently under pressure and meet deadlines.

Technical Proficiencies

Methodologies:

Agile (SCRUM), Waterfall.

Client Server / Cloud Applications:

Azure Data Studio, Azure Data Factory, Informatica, PySpark, Azure Storage Explorer, Azure Databricks, Azure DevOps, Visual Studio, SSMS, Oracle, UC4, Document Direct 4.4, Beyond Compare 3, Attachmate Extra X-treme; MS Office, MS Project, Visio;

GitHub, PVCS Tracker 7.1.10, Visual Source Safe; VPN - Global Protect, Citrix.

Reporting Tools:

Tableau, OBIEE/Oracle Analytics Cloud, Cyber Query Report Writer, SAP Business Objects, Crystal Reports, OneStream.

Scripting Languages:

Python, SQL, PL/SQL, VBScript, JavaScript, TSL, C++, C#, HTML, XML, FIXML, Cyber Query, Direct SQL, TSL, UNIX/Korn Shell Script.

Databases:

Azure Data Lake, Dremio, MS SQL, Snowflake, Pro2SQL, Progress, Oracle, iSeries, DB2, Teradata SQL Asst, MS Access

Testing Tools:

JMeter, Postman, Tosca, Selenium, LoadRunner, Quick Test Professional QTP/UFT.

Repositories:

JIRA, Confluence, Sharepoint, Onbase, QTest, JAMA, Team Foundation Server, Microsoft Test Manager (MTM), Quality Center (ALM), File Aid for DB2

Operating System:

Windows, Unix, Linux, Mainframe

EDUCATION:

Bachelor's degree - University of Mumbai, 1993.

Diploma in Business Management – Indira Gandhi National Open University, 2001.

CERTIFICATIONS:

Tableau Certification

Oracle Cloud Infrastructure

Oracle Applications & Administration (Forms, Reports, PL/SQL, DBA)

Web Development Certification (HTML, Javascript, VBScript, XML, ASP)

Client-Server Certification (Java, CORBA, C++)

SAP MM Course.

PROFESSIONAL EXPERIENCE

Data Engineer / Systems Analyst

ABC Supply - Enterprise Analytics Jan 2020 – Present

Modernization & Rationalization – SAP Business Objects to OBIEE/OAC

Digital Products – Tableau Dashboards & Datasets

Collaborated with business users to gather business requirements, enhancements and change requests for data cleansing and transformation of master data to meet new ERP data format standards. Worked with business and development teams to gather, define, analyze and document project requirements and with QA and Development teams to develop test cases. Created Data Mapping documents and Business Requirements Documents (BRD) for the ETL projects to build out the new data-warehouse. Created Jira Stories with acceptance criteria to complete work items. Reviewed QA Test Scripts, Test Results and triaged Defects for resolution.

Created and managed full step SDLC process, including complete documentation and project planning activities for Agility Custom Reports. Wrote BRDs, Functional Specs with Use Cases for each project. Coordinated UAT testing with business clients, obtained implementation approvals.

Document and prioritize Business Requirements in Jira with acceptance criteria; assign stories / work items to resources for code development and / or validation.

Work with IT resources to collect data, cleanse, transform and load data needed for report development.

Perform Business Operations and identify issues in Application/Reports and assign to resources for resolution in JIRA. Discuss workaround solution to resolve high-risk issues.

Setup UAT as needed for sign off. Prepare User Guides / Runbook prior to deployment.

Create Entity, Models, Business Rules in Master Data Services (MDS).

Create Data Mapping Documents, developed SSIS package and other stored procedures, for daily data load from existing data warehouse to new data warehouse during new ERP implementation.

Implement coding standards for knowledge transfer.

Ensure Data Governance. Design and Develop datasets for use in report generation of Tableau reports and Dashboards by creating Views in Dremio via sql scripts, in order to get data from Azure Data Lake.

Develop Tableau Dashboards and Visualizations with Role Level Security for Branch Managers, Executives, Regional Managers at Company Level using datasets from Dremio, Data Lake, Snowflake and hyper files generated via Databricks, PySpark.

Setup environment in Azure portal to copy data from existing data warehouse tables to Azure Data lake using Azure Data Factory (ELT).

Data identification, Data Profiling, Data Cleansing, Data Transformation, Data curation via Databricks, PySpark to create datasets in Dremio.

Remediated Customer payments that did not post/upload correctly to ERP via file transfer.

Create Pipelines in Azure Portal to automate ETL process on daily basis in Dev environment.

Run pipelines to copy data from Dev environment to PROD environment during deployment.

Modernization & Rationalization Project of SAP Business Objects:

Involved in the transition of Business Objects to Oracle Analytics Cloud (OAC). Designed and developed Dashboard Reports based on existing business logic used in Business Objects Reports, with Row Level Security for Internal Users with AD Account as well External users, using datasets from Snowflake, Oracle.

Create BI Publisher reports for Branch Managers, District Managers and Regional Managers for each Company level.

Schedule reports via Agents to automate report delivery via email to end users.

Migrate Reports to Prod environment and GitHub during deployment.

Create RPD for various measures used in the OBIEE reports.

Create PL/SQL stored procedures for Date Dimension view, created views for OBIEE user role security.

Written and maintained Software Documentation in Confluence.

Lead, manage and mentor offshore team / new members.

Completed multiple projects ahead of schedule – Imagenow, OneStream (reporting), Woodstock (ERP), BankRec, Lockbox payment. Cheetah, PROS (quote), JPMorgan check printing, OBIEE, SPS Commerce, BillTrust, L&W Steel Cost, Sharepoint, GetPaid, Strategic Accounts, Inventory Management, MDS (item, customer, supplier), Territory Management (organization), Sales Goals & Lokad (Sales Cast).

L&W Supply Dec 2016 – Dec 2019

Consultant – Data Engineer / BI Analyst

•L&W Transition Project – Data Migration, Data Warehousing

•ABC Digital Platform - API and Data Integration

•ABC Agility - ERP Program

Collaborate with business users to gather business requirements, enhancements and change requests.

Document and prioritize Business Requirements in Jira with acceptance criteria; assign stories / work items to resources for code development and / or validation.

Work with IT resources to collect data, cleanse, transform and load data needed for report development.

Perform Business Operations and identify issues in Application/Reports and assign to resources for resolution in JIRA. Discuss workaround solution to resolve high-risk issues.

Setup UAT as needed for sign off. Prepare User Guides / Runbook prior to deployment.

Data Profiling, Risk Analysis, Prepared mapping documents using MS Excel for end-users.

Analyzed workflow decisions and how they translate into report requirements.

Acted as liaison between operations and development to ensure consistency and compliance.

Designed and developed real-time transaction reports for various teams in the organization using Cyber Query Report Writer for real time reporting in DMSI Agility using Progress database.

Developed stored procedures, user-defined functions using PL/SQL

Created databases and schema objects (tables, indexes, stored procedures, functions) for data migration.

Designed and implemented Data Warehouse in SQL Server using snowflake-schema.

Designed, developed, and tested ETL to populate data from various source systems using SSIS as well as SAS for data warehousing, data analysis and visualization.

Generated ad-hoc reports using Tableau and OBIEE/OAC, and enhanced report performances by tuning derived tables and join structures.

Lead, manage and mentor offshore team / new members.

Volkswagen Credit Inc – Libertyville, IL May 2014 – Dec 2016

Consultant - Analyst

Cloverleaf Project: FIS Auto Suite – Auto Finance & Default Manager (Web Applications)

Achievements:

Promoted to Product Owner in 3 months of start date.

FIS auto suite solution viz. Default Management (DM) & Auto Finance (AF) systems involves processing of online payments (via ecommerce, ETF, etc.); managing vehicle information, customer accounts, dealers accounts; procuring online data from credit bureaus, legal courts, collection agencies, skip vendors, etc. for VCI

PARMS Data Validation Phase: Co-ordinated efforts for Requirements gathering, test case development via PARMS workbook, test scripts creation & execution, identifying defects, analyzing data, defect resolution.

Co-ordinated efforts during data refresh, code migration, data setup (terminating accounts) during Component Development Phase, System Integration Test Phase, Regression Test Phase, UAT Phase, Deployment and post Go-Live.

Ensured that team follows the Defect Management Process & Guidelines during all the phases and that defects were accurately tracked in reporting tool (JAMA).

Co-ordinated with external teams on daily/bi-weekly basis for defects resolution status. Updating defect status in JAMA and assigning fixed defects to respective Testers for retest / regression testing. Regression Testing and closing defects, if resolved.

Co-ordinated with Vendor for code deployment status, defects status updates, environment and data issues.

Conducted bi-weekly meetings with Vendor for Defect Resolution and prioritization (WebEx).

Assessed impacts on Change Requests and presented to Business for approval.

Provided metrics on Project status for Executive Committee (% test cases completed, % test cases executed, % outstanding defects by severity/priority).

Provided weekly reports on project quality - defect root cause analysis, defect severity, turnaround time of defect resolution, monthly progression of in-progress & closed defects (by application - AF & DM).

Created detailed project schedule plan in MS Project.

Prior to implementation, created detailed cutover plan and assigned to designated resources. Reported findings, suggested changes, escalated issues / risks, etc.

Co-ordinated all project activities with third party vendors. Worked closely with Business, QA team, Applications team, Infrastructure Network team & Audit Team (JAMA, Jira, Sharepoint).

Blue Cross Blue Shield WNY

Consultant – Lead Analyst Feb 2014 – Apr 2014

Payment Innovations Project:

Mandated BCBS Association platform serving National Account members to allow care delivery, provider reimbursement & accountability (control costs).

Worked closely with Project Manager & other teams involved in the Project.

Reviewed Blue Web Requirements from the Association.

Reviewed latest versions of organization’s Business Requirements to prepare Design

Documents, Configuration Plan.

Created Data Model & Mapping documents, harvest metadata and uploaded to Sharepoint repository.

Responsible for Review & Sign off of Technical deliverables prior to Test Planning.

Created and verified accuracy of extracts, transformation and loading of data via ETL.

Executed SQL queries for data analysis & defect investigation.

Resolved defects after analyzing root cause.

Reported progress to Project Manager as well as Business Users on a weekly basis.

Environment: DB2 SQL, Mainframe, SQL, PL/SQL, UNIX script, J2EE, .NET, XML, Internet Explorer 8, Fire Fox, Chrome, Toad, Informatica 9, UltraEdit, WinSCP3, Putty, MS Share Point, Attachmate Extreme, Ultra Edit, WebEx, VMWare, Visio, Project Management, Facets, Care Radius, Erwin, BlueJeans

The Options Clearing Corp (OCC) – Chicago, IL

Consultant - Analyst May 2011 – Oct 2013

SOSA: Evaluated OCC’s in-house software application viz. ‘Streamlined Options Series Adds (SOSA). This application allows exchanges to add same day option series in Encore or next day option series in Private & Public Queues via CSV, GUI and Series Gen. ETL Informatica tool is used to extract, transform and load data from csv (vendor) files to the Java Engine that validates series before they are sent to Encore for trading. This enhancement from C++ engine to Java Engine dramatically increased performance of series processing from 40 minutes to 8 minutes. This also involves accessing procuring online prices from third party vendor and online processing of new option series adds, updating / deleting existing series in Encore. Performance testing conducted successfully via LoadRunner. Regression Testing successfully completed via QTP. As part of end of day process, verified that series data is migrated from staging tables to Encore database successfully when ‘Sweep to Encore’ job plan is completed successfully. Also verified that table data from staging tables (rawsosaseries /sosaseries) is mapped correctly to the Encore table (optionseries). Reviewed code enhancements via TortoiseSVN.

RSA: Involved in assessing the enhancements of high Risk-based Strong Authentication (RSA). This application ensures only registered users can access ecommerce website www.MyOCC.com once their Id and device has been verified by Entrust (3rd party software). Verified application meets requirements in Internet Explorer versions 7, 8, 9, Chrome & FireFox web browers.

T+1 Open Interest: Involved in implementing new screens where clearing members are allowed to update positions of products of Future Exchanges & also testing that the changes made to the positions are reflected in the reports generated for the Exchange & CFTC Agency.

Friday Expiration: Implemented Friday Expiration date for new EXPR symbols. New Standard series coming in with Saturday Expiration date for EXPR symbols only will be converted to Friday Expiration date. However, existing RXPR symbols having Saturday Expiration series in Encore will continue to be valid due to open interest. Monitoring message queues of Trades processed via Infrared360 (MQ messaging) for both EXPR & RXPR symbols for Friday & Saturday Expirations respectively are processed correctly.

Agile Methodology - Independently set up the Dev and Test environments: Build deployment, restore production data, run End of Day processing, roll the Business date, run Start of Day processing, ensure environment is configured to pick up prices from appropriate prices web server.

Review Approach, Design and Software Requirements Documents.

Reviewed Test Strategy, Test Data & Traceability Matrix to Business Requirements.

Parallel Testing – comparing data processed in new code vs. production code.

Prior to implementation, created complex test cases and message flows. Created and ran functional and load tests on web services during Performance Testing. Created MOCKS for web services testing. Analyzed recorded and modified client-server traffic using an HTTP monitor. Worked closely with business and reported findings and suggested changes.

Uploaded all Technical Specifications to Sharepoint for review.

Resolved Defect reported and updated status on a daily basis.

Involved in preliminary & final User Review Meetings with Business Users where all testing results for the project are presented and signed off.

Environment: DB2 SQL, Mainframe, SQL, PL/SQL, UNIX script, J2EE, .NET, Java, C++, Internet Explorer 8, FireFox, Chrome, Squirrel SQL Client, FIXML, WebSphere MQ Manager, Informatica 9, TextPad, Quality Center 11, UC4, WinSCP3, Putty, Attachmate Extreme, Document Direct 4.4, Beyond Compare 3, UC4, SnagIT, WebEx, NetMeeting, Tortoise SVN, VMWare, Selenium, LoadRunner 9, SOAP UI, QTP, MS SharePoint, MS Visio, MS Project Management

US Bank – Chicago, IL Jan 2011 - Apr 2011

CME – Chicago, IL Mar 2010 – Dec 2010

Consultant - Systems Analyst

SMART: In-house compliance application that validates electronic and pit trading activity at major exchanges (CME, CBOT, DME, NYMEX, COMMEX). Involved in both manual and automation regression testing (via Selenium), Updated Defect Status Summary and the Build Quality documents.

TCR Project: Involved in validating the trading activity data transferred via FIXML files.

Agile Methodology: Created Technical specifications, design documents and Business Requirements and uploaded to document repository.

Reviewed Test Cases and Test scripts for UAT Testing.

Reviewed test cases and analyzed data in Oracle SQL Developer.

Involved in automation regression testing via Test Partner successfully.

Resolved defects in Clear Case within deadlines.

Reported Defect Status, pushed recommended Build to production.

Environment: Oracle 11g, SQL Developer 11g, SQL, PL/SQL, UNI, Java, C++, Internet Explorer 8, Toad 9.6.1, Test Partner 6.1, Clear Case 7, Clear Quest 7, UC4, Selenium

Alere Healthcare

Data Analyst Aug 2008 – Feb 2010

Case Processing Logic Project: Involved in creating data of Active Members, New Members and Dis-enrolled Members for each Line of Business (Scenario) and the corresponding existing Programs, New Programs, Case IDs, Risks, etc.

Care Coordination Project: Involved in creating data for qualified or referred status of existing and new programs (based on the program hierarchy) of New Members, Active Members and Declined / Dis-enrolled Members.

Triage Project: Involved in migration and processing of data from HDS to CDS to CDR databases. Data Profiling, Reviewed Metadata, accurately mapped source-to-target fields. Updated staging records with correct status after migration completed.

Touch Engine Project: Involved in designing the web application that processes xml files to generate letters, emails or faxes for clients, based on language and content specified in the part and package for that specific client.

Reviewed Business Requirements

Created Unit Test Cases and scripts tor data analysis in Oracle SQL Developer.

Resolved defects reported in TFS and coordinated with QA Team within deadlines.

Environment: Oracle SQL Developer 11G, SQL, PL/SQL, Team Foundation Server (TFS), Internet Explorer 6.0, Toad

PepsiCo – Chicago, IL

Consultant - Data Analyst Aug 2006 – Jul 2008

Involved in designing and creating the data model and outputs - RICEFs (Reports, Interfaces, Conversions, Extracts, and Forms) in Enterprise Data Warehouse (EDW) as part of the PepsiCo Project One Up. The data is transformed and uploaded from Legacy/SAP-Teradata-SAP via Informatica processes.

Waterfall Methodology - Created Technical specifications, design documents and Field Mapping documents for each RICEF.

Data Profiling, created Metadata, source-to-target mappings between data sources and target data stores

Created database table structures as per logical data model and harvested metadata via Erwin.

Created ETL workflows and Ksh processes. Validated output data in Teradata.

Created tables and populated them with data sets to validate business scenarios and the dataflow in Teradata. Reviewed Ksh code during Unit Testing.

Validated negative scenarios by manipulating the source files to verify data flow, log entries and exception handling.

Executed queries and analyzed data using Toad, Teradata SQL Assistant. data model using Erwin. Resolved defects within deadlines for successful regression.

Environment: Teradata, UNIX, Oracle 10G, Teradata SQL, PL/SQL, KShell, Quality Center (Test Director 8.2), QTP, Load Runner, Erwin, Teradata, SAP Netweaver, Internet Explorer 6.0, Star team, Toad, Caliber, Secure Shell, Informatica

Abbott Laboratories

Consultant - Data Analyst Oct 2005 – Jul 2006

Involved in the following projects:

The Informatica Upgrade project involves migration of processes from version 5.1 to 7.1.

Call Connector: Transfer of all calls from MAX database to ODS database.

Time Off Territory: Transfer of all TOT calls from MAX database to ODS database.

Adhoc Reports and update of existing Professionals/addresses/sales force details.

Disbursements Interface: Transfer of all disbursed samples from MAX database to ODS database.

The CDW migration project involves ETL of data to a new database.

Sales Territory: Extract, Transform and Load data from ODS database to CDW database

Customer Territory: Extract, Transform and Load data from ODS database to CDW database

Time Off Territory: Extract, Transform and Load data from ODS database to CDW database

Call Activity: Extract, Transform and Load data from ODS database to CDW database.

The MAX Informatica Upgrade project involves migration of processes in Informatica 7.1 according to the FDA regulated procedure which involved the following interfaces.

SLE Interface: Transfer of all only valid Shipped Lots from OMEGA database to MAX database.

Bulk Load Interface: Transfer of all new Professionals with addresses and sales force details from NucleusPharma database to MAX database.

Reviewed all phases of the Software Development Life Cycle using Visual SourceSafe, Test Director.

Understanding the requirements and converting them to test cases, creating test data & reusable test scripts.

Responsible for writing detailed test plans & scripts for user acceptance testing, functional testing of the system & transactions in order to meet all business requirements.

Data Setup for Negative Testing, White Box Testing and User Acceptance Testing.

Completed System Test, End to End Testing, Database Testing, Regression Testing and User Acceptance Testing of Informatica processes.

Independently identified errors and interacted with developers to resolve technical issues using Test Director.

Attended Change meetings and had exceptional rapport with developers in resolving issues in least possible time.

Defect Reporting and Resolution - Tracking defects in Test Director.

Completed Test Life Cycle & Life Cycle of Bug.

Environment: MS Access, Oracle 9, PL/SQL, UNIX, Visual SourceSafe, Secure CRT 5.1, UltraEdit-32, Internet Explorer 5.x, Windows2000, Lotus Notes, Toad

Allstate Insurance Co. – Northbrook, IL

Consultant - Systems Analyst Sep 2004 – Sep 2005

Auto Policy Quote: Was involved in manually testing the online Auto Policy Quote for the State of Louisiana as well as using automation scripts for end to end testing in .Net and Java environment.

Waterfall Methodology-Understanding the requirements and converting them to test cases, creating test data & reusable test scripts.

Responsible for writing detailed test plans & scripts for user acceptance testing, functional testing of the system & transactions in order to meet all business requirements.

Completed Unit Test, Integration Test, System Test, End to End Testing, Database Testing, Load Testing, Regression Testing, User Acceptance Testing of software applications using Automated Testing tools viz. Win Runner, QTP, & Load Runner.

Independent identified GUI application errors and interacted with developers to resolve technical issues using Test Director and Clear Quest.

Used Testing Approach Methods viz. Scenario-Based Testing, Negative Testing, Boundary Value analysis, Data-Driven Testing.

Attended Change meetings and had exceptional rapport with developers in resolving issues in least possible time.

Defect Reporting and Resolution - Tracking defects in Test Director and Clear Quest.

Completed Test Life Cycle & Life Cycle of Bug.

Reviewed all phases of the Software Development Life Cycle using Clear Case, Test Director.

Maintenance and support of internet based applications.

Environment: MS SQL, MS Access, Oracle, Rational Tools (Functional Tester, Clear Case, Clear Quest, Requisite Pro), Mercury Interactive Tool Set (Win Runner 7.x, QuickTestPro 7.x, Load Runner 7.x, Test Director 7.6), Internet Explorer 5.x, .Net, Windows2000, MS Outlook, Toad

Sprint PCS – Overland Park, KS

Consultant - Systems Analyst Jun 2004 - Aug 2004

The project involves System testing, Integration testing and database testing of rebuild and new Business Transactions for web-based & client server applications.

Conduct Independent System testing and Integration testing using MQ Series, Transaction Browser, Stub Browser, Exceed, CRT, Toad, Oracle, eRas Applications.

Identified application errors and interacted with developers to resolve technical issues using Change Synergy.

Responsible for writing detailed test plans and procedures for black box functional testing of business transactions.

Understanding the requirements and converting them to test cases, writing reusable test scripts.

Performed Functional (Black Box) and Structural (White Box) testing using Win runner 7.0 and QTP.

Used Testing Approach Methods viz. Scenario-Based Testing, Negative Testing, Boundary Value analysis, Data-Driven Testing. Written Unix scripts for checking trace log files, running programs.

Defect Reporting and Resolution - Tracking defects and maintaining test cases in Test Director. Maintenance and support for all software applications and data-warehouse testing.

Completed test life cycle testing on modified MEID and BMP Projects. The MEID application replaces the old ESN with new modified ESN number. The BMP project provides SMS, tracking the presence and location of the MDN.

Forecasted project hours for individuals across projects within 5% variance for the month and 10% variance for the year.

Environment: UNIX 1.x, Oracle 8.x, CORBA, MS SQL, MS Access, Mercury Interactive Tool Set (Win Runner 7.x, Test Director 7.x, SQL*Plus 8.0, Toad 7.5, Brio 6.x, Windows2000, MS Outlook, PL/SQL, SQL, TSL, WAP Script, Korn Shell Script, HTML, XML, DHTML, WML, HTP, Perl, C#, C++, Java, JSP, CGI, CORBA, Oracle 11i, Internet Explorer 6.0

Motorola, Schaumburg, IL

Consultant - Systems Analyst Jun 2002 - May 2004

The project involves data-warehouse migration and rebuild web-based & client server applications.

Code reviews of HTML, Perl, VBScript, JavaScript, XML, Visual Basic, Java, JSP, C, C++, PL/SQL, Triggers, Procedures, Packages and functions created using Oracle Forms and Oracle Reports.

Tracked defects in Test Director. Attended Change meetings to rebuild web based and client server applications.

Data-warehousing and maintenance of software applications.

Completed test life cycle testing on modified Radio Bank Program on Oracle Forms 6.x that calculates the net balance on customers account for the week / month / YTD. This application sends reminders via email to Operations Department & and customers, if balance on account is low or contract needs to be renewed.

Troubleshoot and maintain test scripts, customize them so they remain generic, effective and efficient.

Reviewed all phases of the Software Development Life Cycle

Applied configuration management of software versions during change and release of software versions using Visual Source Safe.

Independently configured, installed web server; designed, build, support and maintain QA Test Lab and defect tracking tool.

Motorola, Rockford, IL

Consultant - Software Engineer Aug 2000 - May 2002

Gather test requirements, prepare test suites, carry out black-box test, regression test, defects tracking, reporting and resolutions during Code test, Unit Test, Integration Test, System Test, Database Test, Scenario based testing, negative testing, positive testing, Boundary value analysis, Load Test and Stress Test of all developed software applications. Continually ensure accurate and timely delivery. Independently tested the Online Business Reporting Application System for Motorola. The application generates adhoc business analysis reports on unit repairs, which the user may download for future reference.

Load / Stress Testing of Oracle Business Analysis Reports having PL/SQL, Triggers, Procedures, Packages and functions. The bugs responsible for poor response time were reported to the Developer. These reports were tuned.

Scheduling the reports on the Oracle Queue Server, to run daily / weekly / monthly at scheduled time for Finance, Sales, Billing and Customer Service departments at Motorola.

Tested the following business analysis reports on Radio Bank Customers, Unit

Contact this candidate