Smitha Kumaraswamy

Cell: 734-***-**** acyzr9@r.postjobfree.com

Summary:

Over fifteen years of diverse experience in Information Technology with emphasis on SQL Programming, Quality assurance of Client/Server, Mainframe and Web based applications.

Experience in managing all phases of the SDLC such as gathering requirements, preparing business/technical documentation, development, testing, delivery, support and project enhancements.

Experience in creating Business and Data flow diagrams

Excellent communication skills, Documentation Skills, Team problem solving ability, quality conscious, analytical and programming skills.

As a PL/SQL Programmer

Created database objects like tables, views, sequences, synonyms and indexes.

Expertise in SQL, PL/SQL packages, functions, stored procedures, triggers and cursors.

Proficient using Analytical functions, bulk collect and Ref. Cursors

Developed materialized views for data replication in distributed environments.

Expertise in handling errors using Exceptions.

Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE

Experience in interacting with DBA’s pertaining to Roles, migrating objects from lower to higher environments.

Applied business process logic and invoked oracle packages.

Import the data into Oracle tables using SQLLOADER and Control files

Transferred data using data transfer protocols like FTP and SFTP

Experience in Unix Scripting and crontab

Worked on JAMS scheduling tool in defining the workflow schedules.

As a QA Analyst

Experience with QA Methodology and QA Validations to ensure the Quality Assurance Control.

Developed Test Plans, Test Cases and execute them.

Extensive experience in Unit, Functional, Integration, Regression, User Acceptance, System, GUI, Load, Stress and Performance Testing.

Experience in Mercury Interactive Tools like Win Runner, Load Runner and Test Director.

Expertise in testing Performance, Load and Stress for Network and Client/Server Applications

Extensive experience in Functional Testing and Component Testing.

Experience in Testing Database Applications of RDBMS in ORACLE, DB2 and MS Access

Expertise in Areas of specialization includes strong technical knowledge in MVS, COBOL, JCL, TSO, ISPF, FILE-AID, EXPEDITER, VSAM and IMS & DB2.

Expertise in Problem solving and Bug Reports using Bug Tracking Tools.

Exposure in JAVA, Mercury Interactive Tool QTP, Compuware Test partner and Change point.

Technical Skills:

Databases Oracle 12C/11g/10g/9i, DB2, MS-SQL, MS-Access.

Testing Tools Win Runner, Load Runner, IBM Rational SQA Robot, Test Director,

Compuware TestPartner, QA Director, PVCS Tracker 6.5, PR Tracker 3.1,

Issue View.

ERP SAP R/3

Web Technologies JSP, XML, HTML

Languages COBOL, C, C++, C#, JAVA, SQL, PL/SQL, HTML, DHTML, XML,

VB, VB.NET, ASP.NET, ABAP/4.

AppServers Web logic (5.1/6.0), Web sphere 3.0/3.5/4.0, MQ Series

Applications MS Word, MS Excel (MS Query), MS PowerPoint.

Operating Systems Windows 7/2000/98/NT/XP, UNIX, OS/390, MVS.

Scripting JavaScript, VBScript, Shell Script.

GUI Tools Visual Basic, Java AWT/Swing

Software Visual Studio, Visual Studio.NET

Education, Certifications & Awards

Bachelor of Engineering in Electronics and Communication.

Diploma in Software Management.

Received multiple “Associates in Excellence” awards and Bravo Zulu awards in Marketing Associates for outstanding work.

Experience:

Client: Marketing Associates, MI Jul 10- Till Date

PL/SQL Developer

Description: Marketing associates is a unique company combining marketing and technology to deliver effective and targeted campaigns across a wide array of industries.

Project: Ford Commercial Account Database (CADB): - CADB is designed to maintain a database containing information about small businesses appended with vehicle information which is updated periodically by data files from Ford, Dun & Bradstreet, and IHS. Thus it is a highly detailed relational database that is unique in as much as it merges automotive with business data into a single powerful small-business relational database. The CADB is available for batch extracts for marketing campaigns and real-time extracts by dealers via the Business Preferred Network (BPN) web-site.

Designed the data process flow and process layout

Primary contact for designing and delivering new requirements and providing BRD document

Responsible for ACR reviews and direct client interactions

Involved in Data analysis and identified data issues

Responsible for extract data from various external sources such as IHS, Dun & Bradstreet, Melissa zip data and Monthly Navis feed from Ford.

Wrote PL/SQL packages, procedures and functions to implement the business logic.

Used analytical functions and Bulk Collects for memory intensive processes and to improve performance. Created DDL scripts, database Objects like Tables, Views, Materialized Views, Indexes, Synonyms and Sequences

Prepared Ad-hoc Reports based on Client requests

Responsible for Direct Mail Campaigns and Commercial Connection Posting & Commercial Lead Funnel Process.

Worked closely with Analytics team

Project: Superdome Migration

Led a team of 2 developers. Trained and managed offshore resources

Took the responsibility of migrating all UNIX scripts and Oracle databases from HP machines to IBM AIX

Successfully implemented cleanup process, which involves cleaning up of hundreds of unused UNIX scripts and database objects that have been there since the inception of projects dated since 2004.

Took necessary actions to improve the standards in UNIX scripting and Database designing.

Moved all UNIX Cron jobs to Jams Scheduler.

Extensively involved with DBA’s, Infrastructure team throughout the program.

Project: Transit/Transit Connect Racks and Bins Order website

Involved in Analyzing Business Requirements.

Analyzed the data and designed the data process flow

Wrote PL/SQL packages, procedures and functions to implement the business logic.

Developed Shell Scripts, SQL*Loader scripts and Oracle Packages to receive data and scheduled cron jobs in Unix environments

Generate outbound files and send to Ford Credit and Upfitters

Other miscellaneous Projects/tasks:

Well versed in handling multiple projects. Worked on multiple projects concurrently

(PSD, E&G, BPN, FCSD, DuPont, Partner Recognition, VIN decoder and direct campaign management) and delivered on time within the given budget using the available onsite and offshore resources.

Involved in Implementing Security controls to adhere clients ACR’s and SCRP’s.

Migrated Data from one schema to a different schema

Interacted with DBA’s, Infrastructure team, Front-End team & Analytics team on a regular basis.

Environment: Oracle 12C/11g, PL/SQL Developer, UNIX Shell scripting and JAMS scheduler

Client: ISGN (Dynatek Inc.), MI Jul 07- Feb 09

QA Analyst

Description: Dynatek’s MORvision™ is an advanced loan origination system that automates everything from point-of-sale and origination through processing, underwriting, closing, secondary tracking, and delivery. Lenders can do everything in one system, including access the company’s award-winning Plug-In Partner Network.

Analyzed Business Requirements.

Wrote functional test cases using Compuware QADirector

Performed Functional testing, identified application errors and interacted with the development team to resolve issues.

Bugs-tracked and reported through Visual Studio 2005.

Involved in testing various Plug-ins such as Credit, Flood and Underwriting Plug-in.

Involved in testing custom forms and reports such as 1098 Audit report, 1098 Electronic submission and Mortgage Interest form.

Involved in creating automation scripts for regression testing using Compuware TestPartner

Involved in regression testing during Patch and Service Pack release on different databases and different Operating system

Involved in testing Enterprise Loan officer application

Environment: VB, VB.NET, SQL, Oracle, MS-Access, Windows XP, Windows 2000, Compuware TestPartner, Compuware QADirector and Visual Studio 2005

Client: Marketing Associates Nov’05- Jun 07

QA Analyst

Description: Marketing associates is a unique company combining marketing and technology to deliver effective and targeted campaigns across a wide array of industries.

Responsible for the quality assurance of multiple database and web applications but not limited to BPN, Ford Truck Commercial Connection, Commercial Lead Funnel Process, CC Postings, and Consumer Trac

Analyzed Business Requirements and prepared test plans, test cases for Web and database

Involved in load testing using Open Load testing tool

Bugs-tracked and reported through MSS System.

Environment: Java Script, java, Swing, Servlets, JSP, JDBC, J2EE, VB, Oracle, SQL, Windows XP, Open Load

Client: Gyricon LLC, MI Apr’05 – Aug ‘05

QA Tester

Description: Gyricon, LLC is the only company in the world with Smart Paper™ poised to change communication forever. The SyncroSign Messenger is the latest advancement in eSignage to display dynamic messages. Corporate, educational, hospitality and government facilities can manage these eSigns throughout a large venue via a wireless (or wired) network

Analyzed Business Requirements and updated user manuals

Implemented QA methodology

Wrote and executed Smoke, functional and Network connection application test cases

Performed Functional, Black Box, Positive and Negative testing, identified application errors and interacted with the development team to resolve technical issues.

Bugs-tracked and reported through Issue view.

Tested the entire functionality of the application

Responsible for installing the revised version to various management levels within the company.

Performed regression testing due to version upgrade

Environment: Microsoft .NET, MS-SQL, Issue View and Windows XP.

Client: Eckerd Health System, FL May’03 – Mar’05

QA Tester

Description: Eckerd Health services provides an online interface that enables users to browse through web pages that included a catalog with multiple categories and products where the user can get an online medical prescription, obtain information about specific drug through Rx Advisor service, ask pharmacist a question and can get other pharmaceutical needs & health care. The user can also choose and buy other items including drugs, order for photo shop, flowers etc.

Analyzed and reviewed Business Requirements documents and Technical specifications.

Implemented QA methodology

Wrote and executed test cases and test scripts for the Functionality Testing.

Identified application errors and interacted with the development team to resolve technical issues.

Wrote SQL queries for data validation.

Involved in functional and GUI testing using Win runner.

Performed Black Box, White Box, Positive and Negative testing.

Developed detailed test plans and schedules to ensure user specifications were met and system integrity maintained and ensured all sign offs were satisfied prior to release.

Involved in business requirement gathering, user requests and bug status meetings.

Bugs-tracked and reported through Test Director and Managed the entire Testing Process.

Tested the entire functionality of the application on multiple browsers like IE and Netscape

Environment: Win Runner, Load Runner, Test Director7.2, HTML/DHTML, Java Script, java, Swing, Servlets, Oracle, JSP, JDBC, J2EE, Web Logic, Informix, SQL, Windows NT, and UNIX.

Client: Pratt & Whitney, CT May’02 – Apr'03

QA Tester

Description: Graphical Processing Utility is a multi functional tool created and maintained by UTC Hamilton-Sundstrand. The CSDT (Control System Development Tool) Compiler translates diagrams into target code for microprocessor. Used with GPU graphics editor and data dictionary, the compiler provides a development path in which pictures (dataflow and control flow diagrams) can be translated into target source.

Involved in Analyzing Business Requirements.

Categorized the Test Cases taking Manual as reference

Design of STD, SRS documents and design of STR template

Wrote and executed test cases for the Functionality Testing.

Implemented Automation tools to reduce the manual effort

Suggested for Technology Change Management.

Identified Risks and prepared a mitigation plan for the same

Designed the Directory Structure for the Configurable Items in VSS.

Bugs-tracked and reported through Test Director.

Environment: Test Director7.2, MVS, DB2, DB2 Connect, HTML/DHTML, Java Script, java, Swing, Servlets, JSP, JDBC, J2EE and Web Sphere.

Programmer/Analyst

1) Client: M/S Allied Enterprises Nov‘00-Jun’01

Project Description: This project is developed for Allied Enterprise dealers for Kemtec products, which is used in Photo Labs. This project handles all the booking details of customers for Kemtec products. The dispatched goods along with payment details also will be recorded. Provides discount features to special customers. Various order reports have been provided.

2) Client: Aptech Computer center Jan’00- Oct’00

Project Description: Examination Result Processing System is a user friendly system which stores the marks and relevant information of the students. Calculates the total marks, checks the individual subject passing marks and total passing marks. Allows modifications based on re-valuation and report generation.

Analyzed, designed, developed screens

Developed reusable components to reduce the code redundancy.

Wrote queries to retrieve, add, delete, and modify the data.

Several user-defined controls are developed to navigate between the records and query the database to find a specific Customer/order details.

Environment: Visual Basic 6.0, Oracle, Crystal Reports and Windows 98.

WORK STATUS: U.S Citizen

Contact this candidate