Nimisha Patel C/***, Horizons Flats,
Mobile: +91-976******* Near Apostrophe Flats,
E-mail: nimi_mca@yahoo,com Wakad, Pune-411057, India
**********@*****.***
Experience Summary:
Objective
Prince2 Certified Project Manager with total 13+ years of IT experience working with both Services and Product organizations.
Worked as Practice Lead and Project Manager with very good track record of project delivery and handled the average team size of 40+ team members in domains like Banking and Finance, Health care, Consumer Goods, E-commerce, etc.
Hands on Experience on different ETL Tools like Informatica, Data stage and Reporting Tools like Business Objects, Spot fire and Micro Strategy.
Rich experience with following:
Practice Management - Responsible for the Practice Management from Hiring, end to end Operations – Quality Delivery of Testing Services projects from geographically distributed offshore centers.
Resource Management - Performance management, Employee engagement, Technical Leadership, Team building, Recruitment& Career Progression.
Technical delivery - Working with technical specialists performing builds and migrations enabling IT Operations to provide resilient and cost-effective services.
Project Management: Overseeing the entire project implementation from Initiation stage to go live support - scoping document, including the design, specification, risk management and integration of software products within various customer environments
Service Delivery –Day-to-day operations such as prioritization and task coordination, Relationship Management like Developing and sustaining effective relations with clients to ensure repeat / referral services
Key Strengths:
• Strong Experience in managing virtual and global delivery teams.
• Sound People and Project Management skills.
• Good expertise in Data warehouse, BI and migration Projects.
Professional Experience:
Working as an Associate Lead Technical Consultant and Practice Lead for Teradata India Ltd, Pune since November 2014.
Worked as a Test Lead for Wipro Technologies Ltd, Pune, since April 2010 to October 2014.
Worked as a Senior Software Engineer for Accenture Services Pvt Ltd, Bangalore, since Nov 2005 to Jan’2010.
Worked as a software developer from 2003 to 2005.
Technical Skills:
Test Management Tool : ALM, Quality Centre, Test Director, JIRA,IBM Rational Manager
Configuration Management Tool : SVN, Perforce, SharePoint, VSS, Clear Case
Operating System : Windows,Unix, Linux
Database System : MS Access, Oracle,SQL Server, Sybase, Teradata,DB2, Netezza
Tools : TOAD,PL/SQL developer Rapid SQL, Altova XML Spy, Mapforce
ETL/BI Tool : Informatica, Data stage, Business Objects, SAS, Micro Strategy
Certifications:
Prince 2 Practitioner Certificate in Project Management(Certificate No- GR634028424NP)
Certified Test Manager by Information Systems Examination Board (ISEB / ISTQ Advanced)
Certified Tester by Information Systems Examination Board (ISEB / ISTQB Foundation)
Diploma in Management (DIM) From Indira Gandhi National Open University, Delhi in 2004
Qualification Summary:
Master in Computer Applications (MCA) From L.D. College of Engineering, Ahmedabad.
Bachelor in Science (B.Sc) From M.S. University of Baroda, Baroda.
Project Summary:
Project #
Project Name
Employer
Client
Duration
Team Size
My Role
Technology
Summary
Responsibilities & Details.
:
:
:
:
:
:
:
:
:
1
Customer Data Warehouse
Teradata India Pvt. Ltd
Miles and More Group, Germany (100% subsidiary of Lufthansa), Johnson & Johnson Pharmaceutical Europe, Direct Line Group UK
January 2016 To till date
32
Lead Consultant and Practice Lead
Teradata tools and Utilities
Leading a group of project team members to ensure software quality of developed and configured BI software by planning, preparing and execute all stages of testing and Development.
Responsible for End to End Testing from Source to Target for BI Core / Symantec (System-, Integration, Operational and User Acceptance Test)
Responsible for Definition / creation of Test Strategy and getting the acceptance from various stakeholders (for e.g. User acceptance test from Business users).
Strategy for Data mock-up for the test scenarios.
Level of testing required (decision on regression required / module testing sufficient) - strategic decisions.
Responsible for co-ordination with deployment; creation of required tickets / requests for deployment.
Ensure zero defect policy before production
Reduce test effort by test automation & strategy
Mitigate risks & solving issues for the project team.
Team management and performance management for testing team.
.
Project #
Project Name
Employer
Client
Duration
Team Size
My Role
Technology
Summary
Responsibilities & Details.
:
:
:
:
:
:
:
:
:
2
Shoppers Insight
Teradata India Pvt. Ltd
IBM DemandTec, USA
June 2015 December 2015
26
Lead Technical Consultant
Netezza, Micro Strategy
SI (Shoppers insight) is an IBM Service initiative and an analytics application that helps retail clients better understand shopper purchase behavior and preferences, so they can make more data-driven and shopper-centric merchandising and marketing decisions.
It contains a library of Interactive Dashboards to help retail clients better understand product performance and analyze promotion effectiveness to make more data-driven merchandising and marketing decisions
Worked as Lead Consultant and Responsible for end-to-end delivery, ensuring timely Project deliverables through effective communication and quality.
Consulted the testing engagement for the required testing in the envision stage by interacting with business and Technical team.
Test strategy, Planning, effort estimation and scheduling of activities according to the timelines.
Involved in review of requirements, test case design and test data set up for Test execution
Coordinated and reporting the SIT and UAT testing with required sign off process.
Ensuring the appropriate resource planning based on the criticality of the project. Identifying the business challenges and formulating value adds for effort savings.
Have ramped up the team from 8-16 in offshore by hitting right opportunities.
Motivated Team members to take up challenging task to groom them to next level.
.
Project #
Project Name
Employer
Client
Duration
Team Size
My Role
Technology
Summary
Responsibilities & Details.
:
:
:
:
:
:
:
:
:
3
Glide RWD (Global Integrated Drug Development Environment)
Teradata India Pvt. Ltd
F. Hoffmann-La Roche, Switzerland
Dec 2014 To May 2015
14
Service Delivery Manager
SAS,Teradata
Purpose of this program is to transfer the existing RWD databases from the Shogun server to the new RWD environment. It involved Implementation of Teradata Enterprise Data Warehouse (EDW) and Transfer of existing RWD databases from SAS datasets to the new Teradata environment enabling delivery of analytical toolset for business users.
we do the following:
Worked as Service Delivery manager and managed Development as well as testing activities for Estimation, planning and tracking.
Manage Project Initiation through Closure.
Resource Mobilization for Projects.
Responsible for delivering a quality product by incorporating proven QA methodologies to ensure proper test coverage.
Responsible for managing testing activities like Test strategy/Test Plan creation, test estimation, test scenarios creation and defect management.
Responsible for managing development activities like Source Data analysis and development tasks planning, BTEQ scripts creation, Database objects creation, data load etc.
Offshore Team Management, Mentoring and Coaching.
Issue Management.
Participated in Daily and weekly meeting with users and stakeholders.
Project #
Project Name
Employer
Client
Duration
Team Size
My Role
Technology
Summary
Responsibilities & Details.
:
:
:
:
:
:
:
:
:
4
MMS (Market Monitoring Surveillance)
Wipro Technologies Ltd
HSBC
Jan 2014 To Oct 2014
24
Test Manager working from Client location
Sybase, Actimize, CA Data Miner
Purpose of this program is to implement minimum global consistent standards across global sites which have been highlighted as higher risk jurisdictions due to regulatory requirements, level of Market monitoring taking place and business volume levels. Global Group Compliance has identified a set of surveillance models to monitor trade, personal account dealing and electronic communication. They form part of the minimum standards of global surveillance for the prioritized hubs and sites. This solution provides provision of automated, exception driven alerts strengthening processes and controls and increases the efficiency and reduction in time and risk of human errors through automative solution using:
1. Actimize- It's a global approved vendor for Market Surveillance monitoring. It enables smart pre-matching based on historical inputs reducing false positives, users can drill down to obtain further information and post comments.
2. Computer Associates Data Miner- It provides intelligent exception driven alerts for all users who communicate internally and externally based on combination of lexicons.
This program will provide tighter global control environment resulting in a reduction of market abuse incidents and audit concerns, lower/zero regulatory fines and a reduction of risk of reputational loss.
we do the following:
Understand the testing effort by analyzing the requirements of project.
Estimate and obtain management support for the time, resources and budget required to perform the testing.
Build a testing team of professionals with appropriate skills, attitudes and motivation and identify training requirement for the team.
Develop the test plan for the tasks, dependencies and participants required to mitigate the risks to system quality and obtain stakeholder support for this plan.
Arrange the Hardware and software requirement for the Test Setup.
Assign task to all Testing Team members and ensure that all of them have sufficient work in the project.
Document, implement, monitor, and enforce all processes for testing as per standards defined by the organization.
Escalate the issues about project requirements (Software, Hardware, Resources) to higher management.
Organize the status meetings and send the Status Report (Daily, Weekly etc.) to the Client.
Act as the single point of contact between Development and Testers.
Coordinating with users, providing walkthrough/assistance to users while User Acceptance testing.
Track and prepare the report of testing activities like test testing results, test case coverage, required resources, defects discovered and their status, performance baselines etc.
Ensure the timely delivery of different testing milestones.
Prepares / updates the metrics dashboard at the end of a phase or at the completion of project.
Analyzing Manual Test Scripts and test data creation for Automation and provide suggestions for process automation and reconciliation mechanisms.
Project #
Project Name
Employer
Client
Duration
Team Size
My Role
Technology
Summary
Responsibilities & Details.
:
:
:
:
:
:
:
:
:
5
Atlas BAU
Wipro Technologies Ltd
Barclays, Morgan Stanley
June 2010 To December 2013
25
Test Lead and Onsite Coordinator working from Singapore
TCR(In house tool),Oracle 10,XML,Informatica, Sybase,DB2
Atlas is a new system that will act as books and records for Equity Derivatives trades, instruments and positions replacing Sophis legacy application. It is a cohesive collection of services and processes for trade capture and persistence, STP and commons services, messaging, database and data cache.
Two main objectives for Atlas is Expansion of flow business with E2E STP and it’s a new technology base to build new functionality quickly and Decommissioning of Sophis which is a third party application and saving huge license fees.
Future State of Atlas will have simplified trade capture architecture for full STP and One Golden trade store (Atlas Db) for consistent front to back
Atlas Testing follows Service Oriented architecture which deals with request and response model. Atlas testing is 100% automated using TCR tool. TCR is a C# application which uses certain APIs which can be used to assert the result of each test case as data persisted in Database. Using TCR, we do the following:
Request XML submission and capturing the XML response.
Response XML data validation using XPATH.
Data Assertion in Atlas and Sophis Db.
Checking data flow and validation for the business rules.
Working as an onsite coordinator and task assignment, attending daily meetings, project management and knowledge sharing sessions with offshore team.
Follow up with client and providing clarification to the offshore team members queries.
Creation and modification of Test Cases in TCR, creating and executing autosys jobs.
Test Execution, Results Analyzing and Defect Reporting.
Performing Regression, Re-testing to ensure the fixation of bugs.
Interaction with Developers for knowledge sharing, updates.
Coordinating the offshore team as per client schedules.
Review of Test Artifacts including Test Scenarios, Test Cases and Test Scripts of Team members.
Participating in Defect Triage meeting.
Preparation of weekly and monthly status reports.
Project #
Project Name
Employer
Client
Duration
Team Size
My Role
Technology
Summary
Responsibilities & Details.
:
:
:
:
:
:
:
:
:
6
BASEL and T-HUB
Accenture Services Pvt. Ltd.
Bank Of America
January 2006 To Jan 2010
16
Module Lead and Onsite coordinator working from USA
Informatica, Oracle, SQL server
The Basel Accord is an extensive proposal intended to act as a catalyst for the development of advanced methods to manage risk and the capital adequacy of financial institutions worldwide. The latest Basel framework is intended to more closely align regulatory capital requirements with underlying risk, and to provide financial institutions with expanded options in assessing capital adequacy.
This is an Automation project where the main goal is to automate this whole testing process to a very large extent with minimal manual intervention. Various PL/SQL procedures are developed and these procedures are fetching tables dynamically which are to be tested, fetching column names using Oracle system tables. Procedures will compare a large amount of data in minutes. The Automation Data team is loading the test cases and source and target query into their respective tables which will be used to test the specific test cases for each of the projects. The application then will load a test result table and a failed test case table
Excel Macros are created which creates Mock data, generates Test Cases and creates Queries.
Running Informatica workflows and autosys jobs to load data, validating mappings as per Specification, debugging jobs for the issues by looking into workflow logs and session logs by using Informatica.
Writing Macros to create Test Cases, to generate Mock data and to generate queries.
Writing PL/SQL procedure blocks for validating source and target data.
Writing SQL and PL/SQL scripts to test the data from source and Data marts.
Loading data in tables and validating source and target data for different modules.
Creating the Standards Documentation, Testing approach and KT documents so that people can understand easily.
Handle project management tasks.
Work assignment, Updating Project plan.
Review the documents prepared by other members of the team and created the corresponding review docs.
Acquiring domain knowledge of the Application.
Creating & Reviewing Test Cases.
Executing Test Cases.
Uploading Test cases into Quality Center.
Defect Tracking.
Defect Raising, Defect Verification.
Deliver daily deliverables to clients.
PERSONAL DETAILS
Marital Status :
Married
Contact Details :
C/502,Horizons, Near Apostrophe Flats,Pune
Permanent Address :
26/Sattar Taluka Apartments,Nav Jeevan Press Road, Navrang Pura, Ahmedabad, Gujarat.
Cell Number :
********@*****.***
Languages Known :
English, Hindi, Gujarati