Nithin Kamath
SUMMARY
· Excellent understanding of Software Engineering Process (RUP) and Standards (CMM)
· Experienced in Data Warehouse and ETL Tools (Informatica PC / Datastage XE)
· Experience in UNIX and Windows Platforms, n-tier applications, web and client server technologies
· Proven technology expertise in C, Java, PERL, JSP, EJB, XML HTML, Oracle, SQL, and PL/SQL
· Strong SQL skills and experience with RDBMS
· Excellent knowledge in Oracle Database Concepts and expertise in SQL, PL/SQL
· Handled huge volume of data and experience in customization & implementation of ETL processes
· Excellent technical writing skills with hands on experience developing Functional Specifications, Business Requirements, Test Plan, Test Cases, Test Status Reports
· Excellent experience with Mercury Quality Center (WinRunner / QTP / Test Director) and strong TSL/VBScript scripting skills
· Hands on experience with LOAD/STRESS/VOLUME testing using LOADRUNNER
· Administered / managed Test Director and created custom forms and reports
· Dynamic team player who is consistently motivated toward success and completion of projects
· Ability to Work independently
· A quick learner with ability to adapt to new challenges
EDUCATION
Master of Science in Software Engineering
International Technological University, CA 2007 – 2008
University of Southern California, CA 2004 – 2006
Bachelor of Engineering in Electronics & Communication
Manipal Academy of Higher Education, INDIA 1999 – 2003
SKILLS
Languages: C/C++, JAVA, VB, SQL, PL/SQL, PERL, UML
Web Authoring Tools: MS FrontPage, Macromedia Dreamweaver, ASP Script, XML and HTML
RDBMS & Tools: ORACLE, MS SQL, DB2, MS ACCESS, TOAD, Datastage XE, Informatica PC
Server Software: WebLogic, Tuxedo, WBI (MQ Series, Broker), WebSphere, IIS, MTS
Networking Protocols: TCP/IP, OSPF, RSVP, RTP, BGP, IDRP
Platforms: MS Windows (Vista/XP/2000/ME/NT/98), DOS, UNIX, Mac OS X, Linux
Testing Tools: Mercury QTP, Wercury PerformanceCenter, Mercury LoadRunner
Test Management Tools: Mercury QualityCenter, Mercury PerformanceCenter, Rational ClearQuest, Rational ClearCase (Version Control)
PROFESSIONAL ORGANIZATION
Institute of Electrical and Electronics Engineer [IEEE], Inc.
Member 2002 – Current
PROFESSIONAL EXPERIENCE
The Ascent Services Group Walnut Creek, CA
Computer System Analyst October 2008 – Current
Intern Software Engineer October 2007 – September 2008
Software Utilized: Mercury Quality/ Performance Center (WR/TD/QTP/LR), UNIX, MS Excel, Rational ClearQuest, UNIX, Windows, PERL, XML, Datastage, MS SQL, DB2, SQL, PL/SQL, T-SQL, TOAD
Project: iProducts Global Web Services July 2008 – Current
Client: BlackRock (formerly, Barclays Global Investors)
Responsibilities & Accomplishment:
· Sr. Quality Assurance Engineer Position.
· Participate in Testing and QA for Multiple Data Applications and Data Marts for Barclays Global Investors (BGI) to BlackRock transition (October 2009 – December 2009).
· Validate Rebranding of all Internal Products and Services from BGI to BlackRock.
· Co-ordinate with External Service Provider (Infosys) for overall Transition Quality Assurance.
· Participate in Testing and QA for Multiple Data Applications.
· Work with business partners, analysts, developers and project managers to develop test plans, produce test scenarios and repeatable test cases/scripts through all parts of the development lifecycle, execute and sign-off for a high volume of data and regular release schedule for successful project delivery.
· Work with both internal and external partners.
· Take ownership of their projects and lead the overall testing effort.
· Participate in the full lifecycle of data project analysis, design, documentation and testing.
· Work closely with analysts and developers to develop test plans.
· Collaborate with Project Managers, business partners, and developers to coordinate testing schedules.
· Execute and sign off on test scripts.
· Prepare/maintain documentation on all aspects of the iProducts testing processes and support knowledge transfer to other team members.
· Analyze data using SQL, Excel, UNIX and data testing tools.
· Create/Update Test plans (including estimating and maintaining a testing schedule).
· Design test cases and test procedures; develop test scripts and create test data sets.
· Build strong relationships with the business through delivery, communication and domain knowledge.
· Identify, research, report, track and verify software defects proactively and comprehensively.
· Understand of market, static and reference data.
Project: Rebranding for iProducts Data (BGI - BlackRock Merger)
October 2009 – November 2009
Client: BlackRock (formerly, Barclays Global Investors)
Responsibilities & Accomplishment:
· Sr. Quality Assurance Engineer Position.
· Participated in Testing and QA for Multiple Data Applications and Data Marts for Barclays Global Investors’ merger with BlackRock.
· Validated Rebranding of all Internal Products and Services from Barclays branding to BlackRock branding.
· Validated Rebranding of Daily Rate Sheets for BGI Cash products.
· Validated Rebranding of Institutional iShares Performance Reports.
· Participated in Testing and QA for Multiple Data Applications.
· Co-ordinated with the Release Manager to make sure that the rebranding code is deployed on time.
Project: Credit Tickler Rewrite April 2008 – June 2008
Client: Wells Fargo Bank
Responsibilities & Accomplishment:
· Sr. Business Analyst Position.
· Participate in initial feasibility Analysis for IT Ascent for Credit Tickler Application rewrite.
· Analyze the current requirements and proposed enhancements for the application.
· Identify Risks and potential Roadblocks associated while rewriting an application from current Client - Server Model to Web Based Model.
· Perform Functional Point Analysis and classify the functionalities as Complex, Medium or Simple.
· Create Work Flow for the Covenant Creation and Default Handling functionalities.
· Perform preliminary analysis on the data sources to identify any interfacing issues.
· Interact with the Business Users to provide them with feedback. Provide them with additional functionalities that can be achieved during this rewrite.
· Evaluate Serena Business Mash up Tool for this Project. Evaluate other tools to reduce development time and costs associated with it.
Project: Commercial & Mortgage Securities Assn. (CMSA) January 2008 – March 2008
Client: Wells Fargo Bank
Responsibilities & Accomplishment:
· Sr. Business Analyst Position.
· Participate in the development of Enhancement for the current Commercial and Mortgage Securities Association (CMSA) Application.
· Participate in various meetings to analyze the requirements for the Enhancement.
· Understand various terminologies associated with Commercial Mortgage.
· Analyze the requirements and specification documents to create Functional Specification Documents. Create both High Level as well as Low Level Designs for the developers.
· Analyze the Relational Model between various associated tables. Analyze the data model that is current in place.
· Verify that the Relational Integrity is not violated during implementation.
· Analyze the Test Data used for Unit and Integration Testing.
· Verify the Code and Stored Procedure to make sure that all Business Requirements are covered.
· Provide deliverables like Work Flows and Designs to the Developers.
· Currently involved in analyzing a Post Production / Deployment issue with Watch List Enhancement.
Project: Enterprise Data Warehouse (EDW) & Centralized Distribution Hub (CDH)
October 2007 – December 2007
Client: Wells Fargo Bank
Responsibilities & Accomplishment:
· Sr. Test Engineer Position.
· Participate in implementation of Enterprise Level Data Warehouse for a Banking client.
· Participate in the project life cycle, from analysis to production implementation, with emphasis on data analysis, system testing, and auditable documentation of results.
· Create detailed test plans based on analysis of requirements and design documents.
· Write test case scripts and execute; document detailed results and summary report.
· In collaboration with other team members, analyze raw data to ensure the data will meet the business need.
· Utilize PC application software such as Microsoft Word, Excel, Access, Visio, etc.
· Analyzed the data mapping and developed test scenarios to verify the data migration from different data sources.
· Use UNIX commands and utilities to monitor server side activities and performance.
· Execute systems and data quality testing to ensure all development deliverables are production ready.
· Manage testing tasks concurrently on multiple projects.
· Work with the business owner to identify key data elements that will be monitored on an on-going basis to ensure a high level of data quality within the Warehouse.
· Coordinate the overall execution of the test plan with TIG and business representatives.
· Research various production issues.
· Also act as technical resource to other testers.
· Conduct Knowledge Transfer and Training Sessions for new Team Members.
· Perform problem analysis and problem solution in a technical environment.
· Co-ordinate Testing Tasks with Off-Shore Team located in Hydrabad, INDIA
Digital Liberty Group, Inc. Fremont, CA
Intern Software Programmer September 2006 – September 2007
Software Utilized: Sun Solaris, Windows, PERL, XML, Datastage, PowerCenter, Business Objects, MS SQL, DB2, SQL, PL/SQL, T-SQL, TOAD, Mercury Quality/ Performance Center (WR/TD/QTP/LR), UNIX, MS Excel, Rational ClearQuest
Project: Centralized Distribution Hub (CDH) November 2006 – September 2007
Client: Wells Fargo Bank
Responsibilities & Accomplishment:
· Sr. Test Engineer Position.
· Participate in Centralized Data Hub (CDH) project to create file-level data distribution center.
· Participate in the project life cycle, from analysis to production implementation, with emphasis on data analysis, system testing, and auditable documentation of results.
· Work with file formats/layouts, namely: ASCII, EBCDIC, XML, fixed-width and delimited.
· Create detailed test plans based on analysis of requirements and design documents.
· Write test case scripts and execute; document detailed results and summary report.
· In collaboration with other team members, analyze raw data to ensure the data will meet the business need.
· Coordinate UAT with business representatives. Monitor and resolve testing issues.
· Utilize PC application software such as Microsoft Word, Excel, Access, Visio, etc.
· Analyzed the data mapping and developed test scenarios to verify the data migration from different sources.
· Use UNIX commands and utilities to monitor server side activities and performance.
· Execute systems and data quality testing to ensure all development deliverables are production ready.
· Manage testing tasks concurrently on multiple projects.
· Work with the business owner to identify key data elements that will be monitored on an on-going basis to ensure a high level of data quality within the EDW.
· Coordinate the overall execution of the test plan with TIG and business representatives.
· Conduct Knowledge Transfer and Training Sessions for new Team Members.
· Perform problem analysis and problem solution in a technical environment.
· Interface with all levels and across organizational lines.
· Work on a UNIX environment and a DB2 / MS SQL Server database.
Project: Training September 2006 – October 2006
Client: None
Responsibilities & Accomplishment:
· Sr. Test Engineer Position.
· Attend Training Sessions.
· Participate in Team Discussions, Analysis and Review Sessions.
· Learn current market trends and processes.
· Enhance skills and perform Knowledge Transfers.