Project Developer
Resume:
SNEHAL MALU
Santa Clara CA 95054
Email: ******.****@*****.***
Contact: 408-***-****
SUMMARY
• Around 5 years of IT experience in development as Programmer Analyst and Senior Software developer.
• Well experienced in Software Development Life Cycle (SDLC) methodologies – WaterFall Model and Agile
Software Methodology.
• Good exposure to different stages of Software Life cycle – Analysis, Design, Construction (coding), Testing
and Maintenance/Support.
• 4+ years of experience in building complex, high volume Data Warehousing.
• Extensive experience of coding using ETL Tool – Ab Initio.
• Proficient with various Ab Initio Parallelism and Multi File System techniques.
• Good exposure in working with different databases – Oracle, Teradata and db2.
• Good exposure to Teradata load utilities like FastLoad, Mload and Fast Export.
• Control M Scheduling used efficiently to automate the job.
• Thorough knowledge of PL/SQL and Unix Korn Shell scripting
• Very good in working in hybrid model Onsite & offshore development model
• Worked, managed and coordinated projects bigger than 20 person years in size, starting from analysis to
completion.
• Excellent presentation, written & oral communication skills and analytical & problem solving skills.
• Exceptional ability to maintain and build client relationships, frequent meetings one on one with clients, able to
comfortably converse with all facets in the clients organization.
• Excellent analytical, problem solving, interpersonal, presentation and communication skills to keep executive
staff and team members appraised of goals, project status and resolving issues & conflicts.
SKILL SET
Field
Data Warehousing & ETL
Tools
ETL Tool – AB Initio GDE 1.15, 1.14, 1.13, Co>Operating
System 2.15 & 2.14, WebEME, SQL Server 2005, Teradata
Client, Putty, Secure Shell, Toad, ControlM, MS Project, MS
Visio, MS Office Suite (Word, Excel, PowerPoint, Outlook),
HP Service Desk (HPSD), Clear Quest.
Domain
Banking & Capital Market
Languages PL/SQL, Unix Korn Shell Scripting, C, C++
Databases Oracle, Teradata, DB2
Certifications Infosys L100 ETL – Ab Initio Certification
(Ab Initio Tool)
FDN BN101 DB Foundation Course in Banking I (Banking
Fundamentals)
Infosys SE Open Systems Foundation Certification (Unix, Oracle,
C)
IQ1: Infosys Quality Foundation Certification (Quality Processes)
EXPERIENCE – Ab Initio Developer
Period Mar 2010 – June 2010
Intersect Solutions, US
Served
Role Ab Initio Developer
Experimental Learning
Project
eBay, Campbell, US
Client
Work Coverage
Experimental Learning is a program initiated to improve eBay’s Analytic Testing capability in order to better
leverage its insight on customer behavior. The goal of ExL is to foster innovation and confirm winning ideas through a
discovery process as well as to hasten product & business decisions based on analytic data in order to improve the eBay
user experience.
Responsibility
• Responsible for the design, development and testing of Ab Initio graphs
• Develop shell scripts for multiple purposes: automation of environment setup, wrapper scripts for
process and batch execution, etc
• Analyze functional requirements and convert them to technical requirements
• Create technical detail design documents and conduct code reviews with different groups
• Develop and maintain reports
• Interface with multiple groups and document results.
• Responsible for the design of system integration test plans
• Perform other tasks that support the success of the project
Technology and Tools Used: ETL Tool Ab Initio 2.15, Oracle, Teradata.
EXPERIENCE – ETL Developer
Period Nov 2009 – Mar 2010
Infosys Technologies Limited, India
Served
Role Programmer Analyst & Sr. Developer
Mortgage
Project
Capital One, US
Client
Work Coverage
Capital One acquired many new banks for which mortgage data is handled by this application. Acquiring data
from these various banks and placing them in Capital One data warehouse in required format is base of this application.
Responsibility
• Guiding team on technical front.
• Taking care of Processes of Project Management.
• Coding using Ab Initio ETL tool of Data Warehousing, Unix shell scripting and Teradata database.
• Efficiently used Control M Enterprise Manager 6.x to Schedule jobs to run automatically without
human intervention at a regular period of time.
• Supporting QA team for QA testing.
• Supporting and providing maintenance activities to monitor post production rollout.
Technology and Tools Used: ETL Tool Ab Initio 2.15, Korn Shell Scripting, Oracle 9i, Teradata, ControlM 6.3.1, Web
EME, HP Service Desk (HPSD), Clear Quest.
EXPERIENCE – Team Lead & Programmer Analyst (Software Development)
Period May 2008 – Nov 2009
Infosys Technologies Limited, India
Served
Role Team Lead & Programmer Analyst
Defects & Enhancements (DNE)
Project
Capital One, US
Client
Work Coverage
DNE (Defects and Enhancements) application is a part of Helix Data Warehouse project which involves defect
fixing and enhancement requests for many of the Capital One applications. Work requires detailed analysis of the
failures in production and working towards fixing it in short span of time. For analysis and fixing it requires knowledge
of UNIX, Ab Initio, Teradata, Oracle and DB2 technologies.
Responsibility
Main responsibility includes leading the team of 6 developers and handling many management related activities at
project level. Also communicating with Business Personnel, Application DBA and Application Owner for the status and
requirements as well as coordinating with Offshore team was major part of the role.
Other responsibilities include detailed Analysis, preparation of design document, code changes, resolving
technical and design issues and performing independent unit testing, supporting QA testing.
Also includes project management activities like maintenance of IPM+ (Infosys Project Management Tool),
Logging defects in defect prevention tool, conducting Knowledge Sharing sessions for new joiners, conducting defect
Prevention (DP) meets for detailed analysis of defects.
Technology and Tools Used: ETL Tool Ab Initio 2.14, UNIX Shell Scripting, Oracle, Teradata, DB2, ControlM, SQL
Server 2005, Web EME, HPSD, Clear Quest
EXPERIENCE – Sr. Software Developer & Onsite Coordinator (Software
Development)
Period Aug 2007 – Apr 2008
Capital One, UK as vendor from Infosys Technologies Ltd, India
Served
Role Sr. Software Developer & Onsite Coordinator
Card Infrastructure Strategy (CIS)
Project
Capital One, UK
Client
Work Coverage
CIS had 3 parts:
A) World Class Analytics Reinventing the platform and tools
B) Complexity Reduction Reducing the non value complexity and simplifying processes for UK Card portfolio.
C) Card Platform Replacement – Re platforming many of the key pieces of infrastructure that make up the UK Card
Business
CIS Ab Initio was data warehousing project. Work coverage under this project included analyzing and designing as per
Interface Transformation Matrix (ITM) and Interface Design Questionnaire (IDQ) provided by client and to develop
them as Ab Initio graphs.
Responsibility
Main responsibility was to communicate with client and DBAs for requirement analysis and design discussion. Timely
update client on progress front, handle meetings for discussions nad overall build good client relationship for the
business growth.
Other responsibilities included detailed analysis, preparation of detail design, code changes, resolving technical
and design issues and performing independent unit testing, supporting SIT/QA testing and Production support post
rollout. This project included coding of complex graphs in Ab Initio and tuning of complex queries in Teradata, Oracle.
Technology and Tools Used: ETL Tool Ab Initio 2.14, Unix Shell Scripting, Oracle, Teradata, ControlM, SQL Server
2005, HPSD, Clear Quest
EXPERIENCE – Sr. Software Engineer
Period Jun 2006 – Jul 2007
Infosys Technologies Limited, India
Served
Role Sr. Software Engineer
Customer Acquisition Center (CAC)
Project
Capital One, US
Client
Work Coverage
CAC (Customer Acquisition Center) application was part of Helix Data Warehouse project which involves
creation of the data warehouse to store Customer contact information along with Fraud prevention data. This application
included Account booking process for new customers and maintenance of existing customer transaction data using Ab
Initio Data Warehousing tool, Oracle, Teradata and Unix.
Responsibility
Responsibilities included preparation of detail design, code changes, resolving technical and design issues and
performing independent unit testing. Communicating with Onsite Coordinator for day to day status was part of role.
Also included taking care of quality control processes like maintaining IPM (Infosys Project Management Tool),
Maintaining VSS (Visual Source Safe) being Change Controller (CC) of the team.
Technology and Tools Used: ETL Tool Ab Initio, UNIX Shell Scripting, Oracle, Teradata, SQL Server 2005, Control
M
EXPERIENCE – Sr. Software Developer
Period Nov 2005 – May 2006
Infosys Technologies Limited, India
Served
Role Sr. Software Developer
Electronic Distribution Mailing System (EDM)
Project
Capital One, US
Client
Work Coverage
EDM (Electronic Distribution Mailing) application was part of Helix Data Warehouse project which involves
creation of the data warehouse to store Customer contact information along with mailing system data. This application
included offers process for old/new customers and maintenance of existing customer transaction data using Ab Initio
Data Warehousing tool, Oracle, Teradata and Unix.
Responsibility
Responsibilities included preparation of detail design, code changes, resolving technical and design issues and
performing independent unit testing. Communicating with Onsite Coordinator for day to day status was part of role.
Also included taking care of quality control processes like maintaining IPM (Infosys Project Management Tool),
Maintaining VSS (Visual Source Safe) being Change Controller (CC) of the team.
Technology and Tools Used: ETL Tool Ab Initio 1.13 & 1.14, Unix Shell Scripting, Oracle, Toad, Control M
EXPERIENCE – Software Developer
Period Jul 2005 – Oct 2005
Infosys Technologies Limited, India
Served
Role Software Developer
Interest Reallocation System Decommission
Project
Royal Bank of Canada (RBC)
Client
Work Coverage
With this project existing interest reallocation calculation system was decommissioned and a new system was
developed.
Responsibility
Main responsibility included – Requirement analysis, study of existing application, high level design, data
modeling, development, application testing support, production release and full application support.
Technology and Tools Used: UNIX Shell Scripting, Oracle 8i, PL/SQL, Toad, Putty
EDUCATION
Masters of Science Computer Engineering from ITU, Sunnyvale CA
Majored in Information Technology with First Class Distinction, K J
Bachelor of Engineering
Somaiya College of Engineering, Mumbai, India
• :
Curriculum included Software Engineering, Data Warehousing and Data Mining, Project Management,
Computer Networks, Advanced Robotics, Multi Media Systems, Information Technology, Embedded Systems,
Database Management Systems, Computer Languages: C and C++, UNIX.
EXTRA-CURRICULAR ACTIVITIES AND LEADERSHIP ROLES
• Worked as a part of FMO (Floor Manager) Team for Capital One which is responsible for collecting
background forms and taking security sessions for the new joinee, also maintaining backup servers and External
Audit reports.
• Active Member of Infosys Foundation where worked on weekly basis for Orphan kids and rehab institute “Sun
rise Kids” and volunteered for many social events organized by Infosys.
• Organized Blind Girls’ School visit in Infosys.
• Volunteered for “Rural Reach Program” organized by Infosys to spread awareness of basic computer
functionalities in Rural area.
• Worked as a volunteer in “BBC – Children In Need” British fund raising program for Orphan kids in United
Kingdom.
• Worked as active member in Undergraduate Student Committee which included volunteering for College
Annul Events, Handling Sponsorships for Technical Events etc.
• Presented paper on “MPLS – Networking Protocol”, “Introduction to Information Technologies”, “Time
Management” and “Date Warehousing Concepts” in undergraduate school.
• Active member in “Abhivyakti” dancing group in Infosys and participated in many dance performances.
• Organized “BCM Day” annual events in Infosys three years in a row.
Contact this candidate