Project Data
Resume:
N eetha Kurup
**** ********* **, **********, ** *4010 650-***-****
******.*******@*****.***
T echnology Lead/Test Lead
P L/SQL I nformatica U N IX datastage LUW
• 7+ years of software development experience in the areas of leading and
mentoring a team, requirement gathering, requirement analysis,
configuration management, coding, testing, deployment and production
support. Excellent Skills in Analysis, Design, Planning, Implementation and
support.
• Experienced in full project life cycle from design to implementation to
i ntegration.
• Successful at managing teams, driving progress toward project milestones,
quality assurance and on-time delivery
• Establishes clear objectives for team members and enforces deadlines to keep
p rojects on t rack.
• Self-directed leader who fosters a collaborative and supportive team
environment.
• Works well under pressure and consistently meets deadlines and targets
w hile delivering high quality work.
• Quickly masters new software packages
• Works well with people at all levels of the organization, including with
s takeholders, customers and outside vendors
• 5 years of domain experience in Retail Industry
• 2.5 years of domain experience in Pharmacy industry
• 2 years of experience in testing
• Dedicated team player skilled at mediation and conflict resolution.
• Well-versed in creating test cases, as well as covering all test conditions and
eliminating redundancy and duplications
• Precisely executes development projects from concept to delivery
• Well-versed in functional, system, regression, integration, end to end and
user acceptance testing.
• Experience in quality inspection, defect t racking and test planning, reporting
and data creation.
• Hardworking and focused on meeting deadlines and exceeding expectations.
• Proficient in wri ting SQL, PL/SQL stored procedures, packages and t r iggers.
• 7 +years of experience working with Oracle 8i/9i/10g/11g including PL/SQL
p rogramming
• Fair Knowledge on Supply Chain systems like PROMPT,SCAN,
SAM,RMS,PFI,i2 Vendor profile, I tem Master, ACT
• Experience in WMS t ransactions with the retail industry.
• Data loading using PL/SQL.
• Proficient in developing mappings using various t ransformations in
i nformatica (filter, router, update strategy,sorter,joiner,expression etc)
• UN IX Shell scripting experience
• Experience in Requirements Gathering, Business Analysis, Business Process
Redesign and Mapping, Testing & User t raining, Documentation of activities,
p rocesses, test scripts and results and Client in teraction.
• Good Knowledge on HP Quality Center.
• Good Working knowledge of PL/SQL,
I nformatica,UN IX,Datastage,Teradata,Data Studio
• Good engagement feedbacks from clients.
• Involved in the development process to ensure that quality is built in to the
p roduct and verify that the system complies with the functional specification.
• Ability to learn new technologies with in a minimal time period.
• Good perception of Object Oriented Programming (OOP) concepts
• Good communication skills.
• Effectively interact with Clients
• Good team management skills
.
Technical Tools
Oracle SQL, Oracle PL/SQL, UN IX Shell Scripting, Informatica (version 7
and
8),Datastage,Teradata,HTML,Javascript,XML,DB2.,TOAD,VSS,Telnet,Windo
ws XP/7/Vista,Mainframe batch jobs, Clerity, IBM Data Studio, Winscp,
P utty, HP Quality Center, Jira, SQL Developer,DB2, Gaphost
P rofessional Experience
Infosys Limited September 2006-Present
P roject 1: Mainframe Rehosting to Clerity
Client: Gap Inc
Description: Gap, a US major textile retailer is replacing the mainframe with
Open source Clerity.
Role : T echnical T est Lead
Du ration: M ay 2013 to Till Date
R esponsibilities:
• Single point of contact for Supply Chain Domain testing process f lows.
• The work involves coordinating with different domains of retail industry for
system integration testing in new platform.
• Created and executed system and integration test scripts.
• I t involves functional testing of supply chain applications like PROMPT,
SCAN, forte applications, CICS screens
• I t also involves in tegration testing that includes applications like i2 Vendor
p rofile, GLV, I tem Master, SAM, PFI, inventory management applications,
I nvoicing, GLV,GID, GTNexus, EDI, WMS etc.
• Transactions with online DC (GID) for i tem download, Purchase order
c reation, processing of size breakdown th rough Pete application, destination
p urchase order creation and processing it back to Pete .
• Processing of i tems for different footprints for online DC.
• Validating in pacman application for i tems and i tem modifications.
• The work involves gathering requirement from client, formulate testing
s trategy, test planning, identifying test scenarios, test data set up, ensuring
quality deliverables, and giving technical solutions to the team.
• Recorded defects and coordinated issue resolution with development team
and functional leads.
• Manages testing cycles, including test plan creation, development of scripts
and co-ordination of user acceptance testing.
• Effectively in teracts with clients
• Conducts daily t riage meetings, status meetings, and defect discussions with
clients.
• Validation of LUW DB
• Validated ftp to different applications.
Software &Tools: SQLs, Clerity, LUW, Datastage,DB2, CICS screens, Forte
applications,IBM Data Studio, Oracle Databases,Winscp,Putty, HP Quality
Center,FTP
P roject 2: New DC Rollout for GAP China
Client: Gap Inc
Description: Gap, a US major textile retailer is opening a new distribution
center at Shanghai, China.
Role : T echnical Test Lead
D u ration: M ar 2013 to May 2013
Responsibilities:
• The work involved coordinating with different application owners and dc team
i dentifying test scenarios and test f lows.
• I t involved an end to end testing of inbound and outbound t ransactions from
corporate to Warehouse.
• The work involved gathering requirement from client, formulate testing
s trategy, test planning, identifying test scenarios, test data set up, ensuring
quality deliverables, and giving technical solutions to the team.
• Data validation was done in various systems like RMS, Retail
S tyle(mainframe), Datastage areas
• Effectively in teracted with clients
• Worked in Financial application (ReIM) to create invoice, match i t and to
calculate various taxes.
• Involved Mainframe batch job execution and checking the logs.
• Worked with development teams to resolve the issues on time
• Drafted comprehensive reports to document bugs and design f laws.
Software&Tools: SQLs, Mainframe batch, Datastage,RMS
P roject 3: WMS Replatform
Client: G ap I nc
Description: Platform changed from U N IX to L I N UX for Warehouse
Role : T echnical Test Lead
Du ration: Nov 2012 to Feb2013
R esponsibilities:
• The work involved testing inbound and outbound t ransactions from corporate
system to Warehouse.
• I t involved coordinating with different application owners and dc team
i dentifying test scenarios and test f lows.
• The work involved gathering requirement from client, formulate testing
s trategy, test planning, identifying test scenarios, test data set up, ensuring
quality deliverables, and giving technical solutions to the team.
• Worked with forte applications (Retail Style, Order distributor, Order
M anagement, Workflow) to create i tems, purchase orders.
• In teracted with inventory management for allocation processing, model stock
calculations.
• Validated EDI t ransactions to WMS.
• Co-ordinated with DC team for processing t ransactions.
• Effectively coordinated with mul tiple teams to successfully complete the
testing.
• Effectively in teracted with clients
• Used mainframe to execute batch jobs and to debug errors and logs & to
check table data.
• Extensively used datastage to check for logs and reports
• Used Oracle,DB2 and Teradata to query database.
Software& Tools: SQLs, Mainframe batch, Datastage, Teradata,UNIX, forte
applications, RMS, PFI, Sql developer, Putty, Winscp.
P roject 4: I tem Pu rge
C lient: G ap I nc
D escription: GAP as a retailer has many merchandise i tems being created
every day. This has resulted in near exhaustion of the style numbers (unique id to
i dentify the merchandise). This project was to identify any od styles that are no
longer active or being used for Inventory/Sales and purge them. After purging the
same style numbers can be used for future styles resulting in recycling of old style
n umbers.
Role : T echnical Test Lead
Du ration: A pr 2012 to Oct 2012
Responsibilities:
• The work involved coordinating with different application owners and
a rchitects on identifying existing purge process, identifying test scenarios
and test f lows.
• The work involved gathering requirement from client, formulate testing
s trategy, test planning, identifying test scenarios, test data set up, ensuring
quality deliverables, and giving technical solutions to the team.
• Effectively in teracted with clients.
• Used mainframe to execute batch jobs and to debug errors and logs & to
check table data.
• Extensively used datastage to check for logs and reports
• Used Oracle,DB2 and Teradata to query database.
• Maintained defect reports and conducted status meetings with clients to
communicate the progress and the schedule.
Software& Tools: SQLs, Mainframe batch, Datastage, Teradata, UN IX,Forte
applications,Item Master, SQL Developer, Toad, DB2
P roject 5: I n te ractive Management of Allocation Parameters
C lient: G ap I nc
Description: T he project involved weekly forecasting of the sales with historic
sales data and other seasonal parameters.
R ole : T echnical Lead
Du ration: M ay 2010 to Mar 2012
Responsibilities:
• The work involved gathering requirement from client, high level and detailed
design, providing architectural solutions, ensuring quality deliverables and
g iving technical solutions to the team, application support.
• Developed application to calculate model stock for inventory management.
• Created PL/SQL procedures to calculate various forecasting for inventory
a llocations.
• Worked with t r iggers, Cursors, functions, views.
• Coordinated in deployment of the application that includes migration of
codes, jar files
• Production Support has been done to resolve the ongoing issues and
t roubleshoot the problems.
• Communicated with business customers to discuss the issues and
requirements.
• Used relational SQL wherever possible to minimize the data t ransfer over the
network.
• Involved in enhancements and maintenance activities including tuning,
modifying of stored procedures for code enhancements.
• Coded Oracle SQL to create ad-hoc reports on an as-needed basis
Software& Tools: SQLs, PL/SQL, Datastage, UN IX,FTP,SQL developer,
P uty,Winscp,Toad
P roject 6: Corporate Ma inframe Support
C lient: CVS Pharmacy, Inc.
Description: T he p roject supports the corporate systems of CVS namely the
Accounts payable, Tax system and the check authorization system. The tax system
p rimarily deals with setting up and maintenance of quarterly tax rates, computing
apportionment factors etc.
Role : M odule Lead
Du ration: Feb 2010 to Apr 2010
Responsibilities:
• The work involved coming up with streamlined process f lows to provide
enhanced reporting facilities and also to come up with a potential repository
for storing data for tax purposes.
• Responsibilities included analysis, detailed design preparation, coding, unit
test plan preparation, testing, and review and module management.
• Developed ETL programs using Informatica to implement the business
requirements.
• Used various t ransformations like update strategy, fil ter, router,sorter, joiner,
expressions, lookups etc
• Created shell scripts to fine tune the ETL f low of the Informatica workflows.
• Effectively used Informatica parameter files for defining mapping variables,
workflow variables, FTP connections and relational connections.
• Used debugger in identifying bugs in existing mappings by analyzing data
f low, evaluating t ransformations
• Used Informatica reusabili ty at various levels of development.
• Worked with different types of Sources and Targets.
Software& Tools: Informatica 7 & 8 versions,
U N IX,Oracle,Toad,Putty,Winscp,FTP
P roject 7: Sales Audit Replacement
C lient: CVS Pharmacy, Inc.
Description: T he project is a development project in the area of Sales Audit
system.
R ole : M odule Lead
Du ration: J an 2010 to Feb 2010
Responsibilities:
• To support the migration of data from Mainframe based system to UN IX
based system
• Responsibilities included analysis, design document preparation, coding,
reviews, testing, preparation of unit test plans and module management
• Developed ETL programs using Informatica to implement the business
requirements.
• Created shell scripts to fine tune the ETL f low of the Informatica workflows.
• Effectively used Informatica parameter files for defining mapping variables,
workflow variables, FTP connections and relational connections.
• Effectively worked in Informatica version based environment and used
deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data
f low, evaluating t ransformations
• Pre and post session assignment variables were used to pass the variable
values from one session to other.
• Create new mapping designs using various tools in Informatica Designer like
Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping
Designer.
• Develop the mappings using needed Transformations in Informatica tool
according to technical specifications.
• Created complex mappings that involved implementation of Business Logic to
load data in to staging area.
• Used Informatica reusabili ty at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data
loading.
• Performed data manipulations using various Informatica Transformations
l ike Filter, Expression, Lookup (Connected and Un-Connected), Aggregate,
U pdate Strategy, Normalizer, Joiner, Router, Sorter and Union.
Software& Tools: I nformatica 7 & 8 versions, UN IX,Oracle,Toad, Putty,FTP
P roject 8: F I NANCE OPEN SYSTE MS BSR SUPPORT
Client: CVS Pharmacy, Inc.
Description: T he project furnishes Business Support Requests in core Finance
Open Systems Area.
R ole : M odule Lead
Du ration: Dec 2007 to Dec 2009
Responsibilities:
• The core nature of work is Data Warehousing. The project is in steady state
servicing business support requests from the Stock Ledger and Profit
Recovery departments, Accounts Payable department and tax department
• Her responsibilities included analysis, design document preparation, coding,
reviews, testing, preparation of unit test plans and module management
• Developed ETL programs using Informatica to implement the business
requirements.
• Created shell scripts to fine tune the ETL f low of the Informatica workflows.
• Effectively used Informatica parameter files for defining mapping variables,
workflow variables, FTP connections and relational connections.
• Effectively worked in Informatica version based environment and used
deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data
f low, evaluating t ransformations
• Pre and post session assignment variables were used to pass the variable
values from one session to other.
• Create new mapping designs using various tools in Informatica Designer like
Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping
Designer.
• Develop the mappings using needed Transformations in Informatica tool
according to technical specifications.
• Created complex mappings that involved implementation of Business Logic to
load data in to staging area.
• Used Informatica reusabili ty at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data
loading.Performed data manipulations using various Informatica
T ransformations like Fil ter, Expression, Lookup (Connected and Un-
Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter
and Union.
Software : Informatica 7 & 8 versions, UN IX,Oracle
P roject 9: P EOPLESOF T AND F I NANCE OPEN SYSTE MS BSR
C lient: CVS Pharmacy, Inc.
Description: T his project is a support and enhancement project in the area of
P rofit recovery system and the objective of the project is to identify the duplicate
i nvoices generated in the system.
R ole : D eveloper
Du ration: Oct 2007 to Nov 2007
Responsibilities:
• Her responsibilities included analysis of existing code, bug fixes, preparation
of detail design, developing unit test plans and performing unit testing
• Developed ETL programs using Informatica to implement the business
requirements.
• Created shell scripts to fine tune the ETL f low of the Informatica workflows.
• Effectively used Informatica parameter files for defining mapping variables,
workflow variables, FTP connections and relational connections.
• Effectively worked in Informatica version based environment and used
deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data
f low, evaluating t ransformations
• Pre and post session assignment variables were used to pass the variable
values from one session to other.
• Create new mapping designs using various tools in Informatica Designer like
Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping
Designer.
• Develop the mappings using needed Transformations in Informatica tool
according to technical specifications.
• Created complex mappings that involved implementation of Business Logic to
load data in to staging area.
• Used Informatica reusabili ty at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data
loading.Performed data manipulations using various Informatica
T ransformations like Fil ter, Expression, Lookup (Connected and Un-
Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter
and Union.
Software : Informatica 7 & 8 versions, UN IX,Oracle
P roject 10: E LEC TRON IC D ISCOVERY
Client: Walgreens
Description: T he project involves web based application to manage search data
t ypes and applications, view application details and their data types and in terfaces,
v iew the contact information of application owners
Role : D eveloper
Du ration: Sep 2006 to Sep 2007
Responsibilities:
• Responsibilities included analysis, preparation of design document, prototype
p reparation, coding, preparation of unit test plans, unit testing and bug fixes
• Worked with HTML prototypes,java scripts, SQLs, XML
Software : Java, HTML, Oracle
SOFTWARE KNOWLEDGE:
Languages: Java, HTM L, XML, SQL, PL/SQL, UN IX Shell Script, Mainframe batch
D atabase: O racle 11g/10g/9i, Teradata, SQL Developer, LUW, Clerity,FTP,DB2
ETL: I nformatica 7 & 8, Datastage
Tools: TOAD, Visio, Eclipse, Putty, Telnet, VSS, Rational Rose, IB M Data Studio, HP
Quality Center
Operating Systems: W indows XP/2007/Vista
Software / Applications: M S XP, MS 2000, MS Word, MS Excel, MS Access, Outlook,
PowerPoint
Web/Apps Servers: I BM Web Sphere,Tomcat
Education
Bachelor of Electrical & Electronics Engineering
Contact this candidate