Project Data
Resume:
DEEPA IYER
Aliso Viejo, CA 92656
*****.******@*****.***
Summary
A highly dependable and results-oriented Business and Data Warehouse
Analyst with extensive information systems experience. Special expertise is
in data warehousing and applications development with proven analytical,
design, resource management, leadership and technical skills. Able to
provide innovative solutions to complex technical issues. A loyal and
thorough individual with strong communication and interpersonal skills, who
works well independently as well as in a team.
Additional skills and knowledge include:
Data Analysis Data Architecture
Business Analysis Project Management/Coordination
Software Development Life Cycle Production Support
Team Mentoring Management/Leadership
PROFESSIONAL EXPERIENCE
JPMORGAN cHASE (formerly Washington 2002-2009
Mutual), Irvine, CA
Database Management Lead/Data Warehouse Specialist Sr
2007-2009
Led the analysis and data transformation (ETL) activities to successfully
implement a reporting Datamart using Oracle, Informatica and Business
Objects for a loan system. Primary liaison with the business and downstream
systems to ensure that the data feeds and reports are provided in a timely
manner and with high accuracy. Responsibilities included requirement
analysis, data mapping, functional specifications and defect analysis as
well as estimation of resources for new tasks and projects.
. As a lead Business/Data Analyst, standardized and consolidated the data
mapping documentation within all home loans channels resulting in more
efficient and accurate information, thereby saving time for the users.
. Performed a key role in projects requiring oversight for the planning,
estimating, design and delivery to ensure zero errors and saving money by
avoiding re-work.
. Achieved a 20% positive budget variance by tight monitoring of the
resource assignments, keeping the tasks on schedule and ensuring high
quality work from the team for a downstream system decommission project.
. Retained in a key transition team until the WaMu system was
decommissioned to ensure that the loan data migration to Chase is
completed without any delays or errors. Helped the legal team save
thousands of dollars in lawsuits by providing them with accurate and
timely loan data.
. Consistently received a rating of 'exceeds expectations' or 'outstanding'
in performance reviews and was promoted twice during my tenure with WaMu.
Recognized with the Home Loans Elite award, employee of the month and
other commendations based on performance.
Technical Specialist/Data Warehouse Specialist II
2004-2007
. Addressed a series of Reporting Data mart issues as part of a SWAT team
effort of about 6 months to provide the business with reliable and
accurate reporting.
. Participated in a Quick-value session to address some downstream mapping
concerns and brought them to a quick resolution, saving the business
about $50,000 in time taken to resolve issues.
. Helped in setting up the ETL team at onshore as well as offshore by
interviewing and recommending the suitable candidates required to deliver
a high quality and cost-efficient Data Warehouse reporting solution for a
new loan system.
Programmer Analyst Sr. I 2002
-2004
. Instrumental in the evaluation of the forms vendors to support a loan
origination system, thus helping to ensure the best return on investment.
. Analyzed the impact of business rule changes to all areas of the system
and resolved the issues before they cause any impact in Production.
. Identified and resolved the cause of a purge defect that was a potential
show-stopper for the production migration of a Reporting system. This
helped the project to be completed on schedule.
KEANE INC., Jacksonville, FL 1997-2002
Project Lead 2000 -
2002
. Handled all phases of software development using Java/J2EE/Oracle as a
project lead for e-Medsoft.com's Clinical Management System. Ensured that
the team delivered products that were of high quality and ahead of
schedule increasing customer satisfaction.
. Received the Star of Excellence award for outstanding performance in
various projects including Electronic Forms System for Southern Nuclear
Company.
Programmer Analyst 1997
-2000
. Created the Y2K standards for the mainframe-based (COBOL/CICS/IDMS/DB2)
Transportation System for CSX transportation. This helped to standardize
and manage a huge number of code changes by offshore programmers. Was
deployed to offshore to help interview and setup the team.
. Received the Vice President Spotlight award for contributing to the
success of the Y2K project and was promoted to a leadership role as a
project lead.
Computer People, Blue Bell, PA 1996-1997
. As a Sr. Analyst programmer, supported a core business application
called Claims Adjudication System for Aetna U.S. Healthcare, which was
based on the mainframe platform (DB2/CICS/COBOL). Investigated and
resolved over 40 critical problems within the production HMO Claims
system with no prior background or experience with a system containing
very complex business processing rules.
. Developed a very good working relationship with the business customers
and they were confident in my abilities to resolve production issues
with a high degree of quality.
Patni Computers 1994-1996
. As a software engineer, supported the Electronic Approval Signature
subsystem of the Corporate Payroll and Relations Systems utilizing IDMS
/ADSO and COBOL for Lockheed Martin in Lakeland, FL, receiving positive
feedback from the client.
. Worked on projects from offshore for clients such as GE Supply and GE
Aircraft Engines on mainframe platforms using IDMS/R, COBOL, ADS/O, JCL,
CICS and DB2.
EDUCATION
. Master of Science, Electronics, University of Delhi, New Delhi, India
. Bachelor of Science, Electronics, University of Delhi, New Delhi, India
PROFESSIONAL DEVELOPMENT
. Completed the Data Warehousing exam towards CBIP certification (Certified
Business Intelligence Professional) at the TDWI (The Data Warehousing
Institute) conference in Las Vegas, NV.
. Dimensional Data Modeling Primer: From Requirements to Business
Analytics, TDWI.
. Ten Steps to Quality Data and Trusted Information for the Data Warehouse,
TDWI.
. Hands-On Business Analytics, TDWI.
. Enterprise Data Modeling for Business Intelligence, TDWI.
. Data Modeling, University of CA, Irvine.
. Mastering the Requirements Process.
. Fast Start in Project Management.
. Intensive Java for non-C programmers, Metamor Technologies.
. E-business boot camp, Metamor Technologies.
. Brainbench Java Certification.
IMMIGRATION STATUS: U.S. Citizen
Contact this candidate