Sql Server Software
Resume:
Rachna Malik
***********@*****.***
Result oriented, highly passionate and self motivated team player with
over 4+ years of experience across the IT industry
. Good Experience in developing Test Cases, Test Plans, Test Data, Test
Case Checklists reporting, preparing test summary sheets, conducting
status meeting.
. Successfully completed development, testing, documentation and customer
training for TLD Distribution.
Good knowledge and implementation skills of complete Software Development
Life Cycle (SDLC).
Proficient in functional, regression, system integration (SIT), acceptance
(UAT), load/performance, security, and performance testing.
One year of proven track record in end to end technical recruitment
process.
EDUCATION:
. Three months technical training in JD Edwards.
. Master's Degree in Computer Applications (MCA), Shimla, HP University,
India, 1999 - 2002.
. Bachelor of Science (B.Sc.), St. Bede's College, Shimla, HP Univ., India,
1996-1999.
TECHNICAL SKILLS:
Programming Languages SQL, Visual Basic 6.0, Familiarity with C,
C++.
Operating systems MS-DOS, Windows 9X, XP, Windows 2000, NT and
Win 7.
GUI FrontPage, Adobe Photoshop.
Databases MS-Access 2000, 2007, Oracle 8, SQL Server 2005
Web technologies HTML, Java Script.
Reporting Tools Crystal Reports 7, Data Reports.
ERP Skills JD Edwards development tools, Data Conversions, Report writing.
Miscellaneous tools Familiarity with Bug filing suite Product studio,
Perseus studio test harness Adobe Robohelp 7, Visual
Studio debugger, Team foundation server, MS Office
Productivity Suite, Virtual Machines, SCRUM Works.
PROFESSIONAL EXPERIENCE:
IT Apps LLC
Dec 2009-Present
Technical Recruiter
Responsibilities
. Understanding the sourcing needs of the clients
. Posting jobs on job boards like Corp-Corp, doing vendor blast suing
madmimi, linkedin
. Technical screening of the candidate
. Identifying the right candidates
. Negotiating terms with the companies and getting the paperwork done.
. Arranging the interviews.
. Tie-ups with other companies involved in similar business for Corp to
Corp, transfer of Consultants, W2 and 1099. This also includes
building up new Vendors through agreements and forwarding the
applications to the leading companies for becoming there preferred
vendors or sub vendors for getting their regular requirements.
. Maintaining the candidate database and clients database
. Ability to work effectively in high-pressure environments
Extensive work on job boards:
Corp-Corp, Hotjobs, Jobvertise, Jobirn and Internal Database
Lexis Nexis Inc, Bellevue location, WA
Sept 2008-Sept 09
QA Analyst
LexisNexis is a leading global provider of content-enabled workflow
solutions to professionals in law firms, corporations, government, law
enforcement, tax, accounting, academic institutions and risk and compliance
assessment.
I worked on their product, LAW PreDiscovery, software combines production-
level imaging and electronic discovery processing in one robust and easy-to-
use application allowing you to produce and organize both paper and
electronic files. LAW PreDiscovery allows you to cull non-responsive data
to increase productivity, allow you to reduce costs and gain greater
control over your electronic discovery.
Responsibilities & Accomplishments:
. Writing and execution of test cases. We have had three successful
releases so far.
. Worked closely with the development team to provide feedback on new
features and perform assist in unit testing of fixed and enhanced
features.
. Developed and executed test plans ensuring that product functionality
meets customer expectations and product requirements.
. Executed functional, regression, system integration (SIT), acceptance
(UAT), load/performance, security, and performance testing
. Responsible for testing many new features getting introduced in the
product in releases.
. Tracking and reporting product bugs to verify compliance with product
requirements.
TLD Distribution, CA,
July 2007 - June2008
California.
Software Developer/Tester
Over the period of time TLD Distribution has evolved into one of the
largest independent master distributors on the West coast, supplying
distributors with a wide range of products. This project is for
customizations in JDE Vanilla applications, reports and workflows to suit
the requirements of the company.
Responsibilities & Accomplishments:
. Contributed in design of the applications and reports. Did complete
development and testing of custom applications for Sales order entry
process, including but not limited to, Picking managers application
and applications for maintaining workflows.
. Release Held order application customization
. Successfully finished the following UBEs:
Received not vouchered customized for the requirements, PO Print,
Invoice reports & bug fixes in pick slip print.
. Workflows for Credit limit change for customers, Pricing and quantity
workflows for Sales order process to verify the quantity of products
received by the company.
. Analyzed Requirements document and prepared test cases based on
business and functional specifications.
. We followed the waterfall testing methodology and as a part of that I
Performed Unit, Black Box, White Box and Functional testing.
. Performed End to End UI testing for the applications developed by me.
. Tested the application, reports and workflows in multiple environments
(Development and Prototype environment) on fat client and web client.
. Used Application debugger in JDE Edwards and performed cross
verification between log files, output files and the database.
. Data Conversions: Migrated excel data files to JD Edwards tables using
SQL Enterprise manager, Query Analyzer, Microsoft Excel 2007.
. Prepared the data in the right format and wrote scripts to convert it
to appropriate JDE Z files.
. Created Flowcharts on the basis of design to explain the process
flows.
. Documented all the technical work for training purposes.
. Contributed in customer training.
Technologies Used:
. JD Edwards, SQL Server 2005, Microsoft Excel 2007, Windows 2000, XP.
IT APPS LLC
Mar 2005-June2005
Service Website Tester
. I was involved with the design and development of the website to being
with, as we were following agile methodology, I then developed the
test scenarios and wrote a test specification documents for various
aspects of the business.
. Performed End to End UI and functional testing for the for the
website.
. Performed integration testing of the website and did validations with
Paypal to ensure that all payment methods, transactions, log details
etc are as expected.
. Performed MS Access database testing to validate the transaction
details and logs.
. Daily reporting of test scenarios and their results.
Data Dynamics Inc.
Apr 2004-Sep 2004
Technical Recruiter
Management Information System
Responsibilities
. Was involved screening and recruiting IT consultants, to satisfy
requirements for various clients for projects and staff augmentation.
. Enhanced existing company database and maintained contractor and
project data using Excel sheets. We used direct contact, cold calling,
networking.
. Talking to applicant(s) discussing the requirement, understanding
their role and responsibilities.
. Fixing appointment of candidates with clients and reconfirming /
reminding on call and paper to them.
NIC, Chandigarh, India
Nov 2003 - Dec2003
Software Developer/Tester
Management Information System
This online progress monitoring system was a web application and the step
towards converting the manual process of sending details like number of
disciplines, students enrolled in each discipline, NRI Seats etc. of all
polytechnic colleges to their head office online.
Responsibilities & Accomplishments:
. Worked as a part of development team and developed online data entry
screens for the users of this website.
Technologies Used:
. Windows 2000, JSP, HTML, Java Script, SQL Server 2000, FrontPage
NIC, Chandigarh, India
Oct 2002- Oct 2003
Software Developer/Tester
PIS Personnel Information System
A customized software package which can maintain information of all the
employees from joining till retirement like transfers, leave record,
trainings etc. and generate reports as per the requirement for different
offices.
Responsibilities & Accomplishments:
. Contributed in Analysis and design of the entire software.
. Database Designing: Creating tables, Enforcing Constraints like
Primary key, Check Not Null Referential Integrity. Involved in the
design of the database.
. Created Screen Layouts & Coded for the Masters and Transaction
Screens.
. Integrated various reports into the application. The reports were
created using Crystal Reports.
. Created the test specification document based on design and functional
requirements.
. Completed Unit, UI, Functional, and Integration testing.
. Performed white box and black testing and helped in implementation of
the software.
. Used Visual studio debugger to fix bugs reported by users.
. Did technical documentation for the project.
. Gave a demo of the applications to the Deputy
Director of NIC,
Technologies Used:
. Windows 2000, Visual Basic 6.0, ODBC, MS-Access 2000, Seagate Crystal
Reports 7
NIC, Chandigarh, India
Aug 2002- Sept 2002
Software Developer/Tester
Student Information System
This software was designed to manage the results of various technical
Education Institutes running courses like MCA, B. Pharmacy etc. User
interface was developed to enter grades and marks, calculating results,
maintaining results and mark sheets were printed.
Responsibilities & Accomplishments:
. Designed Screens & Coded for the data entry and verification screens.
. Created the test specification document based on design and functional
requirements.
. Performed white box and black testing and helped in implementation of
the software.
. Fixed bugs reported by users during User Acceptance testing using
Visual studio debugger.
Technologies Used:
. Windows 2000, Visual Basic 6.0, MS-Access 2000, Seagate, Crystal
Reports 7
NIC, Chandigarh, India
Jan 2002- July2002
Software Trainee
HARIS (Haryana Registration Information System)
HARIS is a part of Land Records System. The project involved
computerization of the process of transferring documents used in
registering the transfer of land from one person to another. Conflicts
present in manual system were removed. An application was developed using
ADO to interact with SQL Server database on Windows 2000.
Responsibilities & Accomplishments:
. Designed and developed user interface screens for a module using VB
6.0.
. Responsible for writing queries to interact with SQL Server.
. Responsible for generating various kinds of reports in English and
Hindi.
. Responsible for white box, black box, Unit and complete functional
testing of the application.
Technologies Used:
. Windows 2000, Visual Basic 6.0, SQL Server 2000,
Seagate Crystal Reports 7.
References available upon request
Contact this candidate