Data Test Cases

Kundan V. Chaudhari

Oracle **g Data Warehousing

Certified Implementation Specialist

Oracle 9i OCP Certified

******.*********@*****.***

Cell 408-***-****

Summary

Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.

15 years of IT experience in Analysis, Design, Modeling, Development, Testing and Implementation of Data Warehousing Business Applications as well OLTP application.

7+ Years of Data warehousing experience. Design and developed medium to complex size data warehousing project for Client like Cisco, Credit Suisse and Blue Dart express LTD.

8+ years of experience in application support. Supported P1 application in Cisco systems, Credit Suisse in 24/7 model. Lead a team of 10 members in onsite-offshore support model. Sound knowledge of SeviceNow, BMC remedy tool for incident management.

Expert in Data mart designing, ETL development, Data migration.

Expert in Creating and managing logical, physical and conceptual models using data modeling tools. Handled number of medium to larger project independently End 2 End.

Analyze and profile source data to find underlying data/domain relationships and gaps. Develop and communicate standards for data structures.

Experience in requirement gathering and requirement management in cross functional projects

Expertise in business and systems documentation, use case analysis and change management

Very good knowledge of MongoDB database. Successfully converted Application from Oracle Database to MongoDb database.

MongoDB database monitoring, deployment with DBA team. Configure MongoDB as per application requirement.

Successfully handled a team of 15+ associate in Onsite/Offshore model. 10+ years of abroad experience (USA + Uruguay) worked closely with Client.

Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL_File Utilities.

Good knowledge of Data Modeling using ETL tools, OLAP tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.

Expert in developing reports using Tableau, Actuate tool.

In depth knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL using database tools like Toad, PL-SQL Developer.

Proven leadership and project management skills (PMP certified).

Excellent skills in designing and development of applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL. Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL and used TOAD, PL SQL developer in many development projects.

Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized Views and Troubleshooting Oracle database issues.

XML, JSON processing through Oracle PL-SQL.

Excellent knowledge for Oracle apps pricing module, Oracle AQ, PVCS,Kintana

Experience in Bulk Data loading using Oracle utilities namely SQL Loader and External Tables.

Leading the Credit Suisse Toastmaster club as President. Achieved the Certification as Competent Communicator and Competent Leader from Toastmaster International.

Technical skills

Programming Languages

C, C++,Java, SQL, and PL/SQL,Visual Basic 6.0

Databases

Oracle 11g/10g/9i/8i, SQL Server. Advanced Oracle queuing technique (Cisco Data Bus). Oracle Apps Pricing Module.MY SQL,MongoDB,Cassandra, Golden Gate, Oracle AQ, PVCS,Kintana

BI Tools

Tableau,Siebel Analytics, Actuate,Informatica

Operating Systems

Solaris, UNIX, Linux, Windows 95, NT, 2000, XP

Scheduling tool:

Dollar Universe,CRONTAB,BMC Control-M

Front end Tool

Toad,PL-SQL Developer

Incident management tool

Service Now, BMC remedy tool

Successfully completed Credit Suisse sponsored external instructor led MongoDB, Cassandra training.

Work Experience

Credit Suisse Jan-2016 – Present

Project: Client Data warehouse (CDW), Flash Profit Loss Application,

Role: - Senior Database Engineer.

Client Data Warehouse (CDW) – Client Data warehouse is bank wide warehouse which will be used for management reporting purpose. Credit Suisse have global presence and getting trade data from different stock exchange. Currently Credit Suisse is getting 52 Trade Feed. This data come into accumulation layer and then staging .After applying the business logic it was expose to different reporting application such as CS PLUS, Regulatory reporting.

Trade Mandate(TM) - TM is application which used to govern Trading activity for Trader. It will put mandate which product/Services can be traded by Trader. It will also generate alert for Mandate violation. Exception report is provided to management on daily basis once the overnight Data extraction is completed

Environment: Oracle 11g, PL SQL Developer,Informatica, SQL Tool, SVN for version Control, Control-M Job Scheduling tool, Tableau, Odyssey Atlassian Tool for JIRA management.

Flash PnL is Credit Suisse’s global profit loss application for Traders. This application is primarily use by Trader to input the estimate used for Today (TO estimate). This was used by management for the Planning and reporting purpose. Once today’s Actual number flow from upstream, application give insight of what is estimated and what is actual. Flash PnL Application also send the daily Automated Notification about the Region, Node wise Profit Loss Summary.

Flash PnL application used to set the daily trade limit for the traders. This will also report the Breach if Trader have violated the limit of Trading Limit. Application have capability to suspend node and Management Action Trigger (MAT) is triggered. MAT breach need to sign off by L1, L2 level supervisor.

Environment: Microsoft Silverlight, Oracle 11g, PL SQL Developer, Windows Job Scheduling tool. Microsoft Visual Studio. Mongo DB

Responsibilities

Converting Flash PnL application from oracle to MongoDB database.

Data modeling from RDBMS to MongoDB for Flash PnL project.

MongoDB database planning and deployment in coordination with DBA group.

Interact with the stakeholders to gather and manage requirements.

Analysis of business requirements and functional specifications documents

Creation of Technical design document to mapped the requirement

Creating and managing logical, physical and conceptual models using data modeling tools. Working closely with Data Architect for data modeling.

Writing ETL to pull the data from different data sources and work extensively on data migration. For Extraction Informatica is used and for business logic Oracle PL-SQL is used. Job Scheduling is done by BMC Control-M tool.

Provide the level 2 support for the production issue.

For Flash PnL working on moving database from Oracle Database to MongoDB database.

Work with Business Analyst to get the QA as well as BA sign off.

Work with Release team to deploy the code in production environment by following guidelines.

Do coding in PL/SQL using packages, procedure and function. Creation of relevant quality documents like Analysis, Design, Test cases.

Develop the complex View using Table function, Materialized View for downstream.

Create Tableau report for Prudential Risk Asset (PRA), Risk weight assets (RWA).

Client: Cisco Systems Inc., RTP, USA Oct-2013 – Dec-2015

Employer: - Advaitaa Technologies INC

Project: Global Infrastructure Service (GIS)

Technical Lead

Global infrastructure Services is responsible for enterprise wide monitoring of the Cisco’s mission critical application. It is an IT for IT. It is responsible for providing the different infrastructure services such as

24/7 application monitoring.

End to End costing of any services offered by Application.

Database services.

Managing Application portfolio.

Virtual machine, MS, JVM,Host management etc

Service Dependency Matrix (SDM):- SDM projects main objective is to provide End to End dependency Of any application right from Physical layer to Application layer. It will automate the cisco change request process .It depends upon number of different Upstream source such as cisco e-sotre,DBTS etc. which provide the different services to cisco IT team. Currently we are designing the ETL to fetch the data from the above mentioned source.

Responsibilities

Interact with the stakeholders in the GIS to gather and manage requirements

Analysis of business requirements and functional specifications documents

Creation of Technical design document.

Creating and managing logical, physical and conceptual models using data modeling tools. Working closely with Data Architect for data modeling.

Successfully migrated the application from Oracle Database to MongoDB database.

Provide the level 2 support for the production issue.

Act as the liaison between the business users and the technical team (onsite and offshore)

Manage traceability between requirements, use cases and test cases

Perform GAP analysis and Data modeling

End 2 End performances tuning of the Application.

Writing ETL to pull the data from different data sources and work extensively on data migration.

To do the code review, developed the reusable component.

Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.

Work closely with the testing team for preparation and execution of UAT plans.

Create Work Break Down Structures, Cost and Time estimates, Responsibility Assignment Matrix as necessary

Manage resources to ensure delivery within planned timeframes and budget

Prepare user manuals, presentations and provide end user training

Environment: Oracle 10g, Golden gate(Oracle AQ), perl, Toad, CRON TAB- Unix Job Scheduling tool, Erwin,Unix,PL-Sql MySQL,PVCS,Kintana.

Client: Cisco Systems Inc., San Jose, USA July 2012 – Oct-2013

Employer: - Tata Consultancy Services Limited.

Project: Pricing and Discounting (P&D)

Technical Lead

Pricing and discounting deals with the pricing & discounting of products and services. It consists of 2 engines:

QTC-QP (Oracle Pricing module) engine which deals with the pricing of Products.

CAPD (C3 QP) engine which deals with the pricing and discounting of Services

Oracle® Financial Services Analytical Applications (OFSAA) for risk measurement.

P & D is the single source for all pricing information of Cisco Product and Services. This pricing data flow to various downstream for pricing related information. Currently P & D support 30 different price list.Cisco’s various commerce application used this P & D engine to get the accurate price and discount for the Cisco’s product and service.

Responsibilities

Interact with the stakeholders in the Commerce Work Space group to gather and manage requirements

Analysis of business requirements and functional specifications documents

Creation of Technical design document.

Create Work Break Down Structures, Cost and Time estimates, Responsibility Assignment Matrix as necessary

Manage resources to ensure delivery within planned timeframes and budget

Act as the liaison between the business users and the technical team (onsite and offshore)

Manage traceability between requirements, use cases and test cases

Perform GAP analysis and Data modeling

Work closely with the testing team for preparation and execution of UAT plans.

Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.

‘The IT support time has reduced by around 30% after the proposed process and system enhancements were implemented’. ‘The disciplined development process, precise requirement management and timely delivery won many accolades from Senior Management’

Environment: Oracle 10g, Oracle APPs, Golden gate, Java, Toad, Dollar Universe Scheduling tool,

Oracle AQ, PVCS, Kintana, Unix

Client: Cisco Systems Inc. USA Sept- 2011 – July-2012

Employer: - Tata Consultancy Services Limited.

Project: Enterprise Discount Management System (EDMS) Application.

Technical Lead

EDMS is single source for all approved discount information. It offers powerful search and reporting capabilities that give unprecedented visibility to discounts by customer, vertical and other attributes. It is available to Sales, Customer Service, Finance, Legal, and other organizations as the "go to" place to find all active discounts for customers. A key component of the global contractual Discount process that will include:

•Contractual discount entry and approval using SFDC and My Deal Manager

•Integration with CMS

•Integration with Customer Service processes.

Responsibilities

Interact with the stakeholders in the Commerce Work Space group to gather and manage requirements

Analysis of business requirements and functional specifications documents

Creation of Technical design document.

Create Work Break Down Structures, Cost and Time estimates, Responsibility Assignment Matrix as necessary

Manage resources to ensure delivery within planned timeframes and budget

Act as the liaison between the business users and the technical team (onsite and offshore)

Manage traceability between requirements, use cases and test cases

Perform GAP analysis and Data modeling

Work closely with the testing team for preparation and execution of UAT plans.

Prepare user manuals, presentations and provide end user training

End 2 End performances tuning of the Application.

To do the code review, developed the reusable component.

Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.

Environment: Oracle 10g, Java, Toad, DBMS profilers.

Client: Cisco Systems Inc. RTP, USA June- 2009 – Sept-2011

Employer: - Tata Consultancy Services Limited.

Project: Cisco Commerce Workspace.

Senior Database Developer

Cisco Commerce workspace Application is a web based tool which is used to create deal for the Cisco product. It is revenue generating one of the most critical applications for the Cisco.40,000 partner of Cisco are using this application to do their business. Partner can create deal for the end customer for variety of cisco’s product. They can create the standard deal, promotional deal. Once deal got created it will go for approval from various approval route. Once all approval done, Partner can place order against deal from same application. Over a period of time Cisco had acquired various small companies like Ironport, scanscafe, webex.CCW application was enhanced to support this newly acquired company for the unified quoting experience for the Partner.

Responsibilities

Interact with the stakeholders in the Commerce Work Space group to gather and manage requirements

Analysis of business requirements and functional specifications documents

Creation of Technical design document.

Create Work Break Down Structures, Cost and Time estimates, Responsibility Assignment Matrix as necessary

Manage resources to ensure delivery within planned timeframes and budget

Act as the liaison between the business users and the technical team (onsite and offshore)

Manage traceability between requirements, use cases and test cases

Perform GAP analysis and Data modeling

Work closely with the testing team for preparation and execution of UAT plans.

Prepare user manuals, presentations and provide end user training

End 2 End performances tuning of the Application.

To do the code review, developed the reusable component.

Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.

Environment: Oracle 10g, Java, Toad,DBMS profilers, Unix.

‘Performed an intense process flow analysis that resulted in pre-emptive identification of many bottlenecks in the operations and provided a reliable solution for this mission critical application to make it more robust and stable.

Client: Cisco Systems Inc. RTP,USA June- 2009 – Sept-2011

Employer :- Tata Consultancy Services Limited.

Project: Unified notification Framework (XML based).

Senior Database Developer

Currently with Cisco commerce workspace, each application is having their individual notification system. Management wanted to replace this number of application specific notification system with one generic notification framework. With the Unified notification system, notification process got simplified. In this system subscribed application need to subscribe to this system. They have to register their notification e-mails and XML with system. Once register, subscriber application simply need to push the notification event with XML data and Unified notification will take care from generating notification (XML-XSL based generation) to sending the notification successfully.

Responsibilities

Interact with the stakeholders in the Commerce Work Space group to gather and manage requirements

Analysis of business requirements and functional specifications documents

Creation of Technical design document.

Create Work Break Down Structures, Cost and Time estimates, Responsibility Assignment Matrix as necessary

Manage resources to ensure delivery within planned timeframes and budget

Act as the liaison between the business users and the technical team (onsite and offshore)

Manage traceability between requirements, use cases and test cases

Perform GAP analysis and Data modeling

Work closely with the testing team for preparation and execution of UAT plans.

Prepare user manuals, presentations and provide end user training

End 2 End performances tuning of the Application.

To do the code review, developed the reusable component.

Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.

Environment: Oracle 10g, Java,Toad,DBMS profilers, Unix.

Client: Cisco Systems Inc. Mumbai Nov- 2008 – Jun-2009

Employer :- Tata Consultancy Services Limited.

Project: Partner Data Localization (PREG, PREG Admin and PSS application in Channel Area.)

Senior Database Developer

Dynamic localization project is started with a broader aim of incorporating local languages, providing support in local language and yet to maintain a single source of reference (CR-SSOT) - so as to avoid data duplication.

PREG, PSS & PL tools modified to:

Support Chinese Partner Data.

Display localized dynamic content (currently only Chinese).

Follow the same business policies and are streamlined to current PDB.

Exploit EDSG services (PREG & PSS).

Responsibilities

Interact with the stakeholders in the Cisco channel partner to gather and manage requirements.

Analysis of business requirements and functional specifications documents

Creation of Technical design document.

Create Work Break Down Structures, Cost and Time estimates, Responsibility Assignment Matrix as necessary

Manage resources to ensure delivery within planned timeframes and budget

Act as the liaison between the business users and the technical team (onsite and offshore)

Manage traceability between requirements, use cases and test cases

Perform GAP analysis and Data modeling

Work closely with the testing team for preparation and execution of UAT plans.

Prepare user manuals, presentations and provide end user training

End 2 End performances tuning of the Application.

To do the code review, developed the reusable component.

Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.

Environment: Oracle 10g, Java, Toad, DBMS profilers,unix.

Client: Cisco Systems Inc. USA Nov- 2004 – Sept-2008

Employer :- Tata Consultancy Services Limited.

Project: My Business Report.

Database Developer

MBR application is a P1 application having visibility to Cisco’s higher management. It is consolidation of different sales applications. MBR reports will comprise of Bookings, forecast, opportunity and Commit reports by the following dimensions:

Sales Hierarchy,

Corporate Vertical Market,

Localized EMEA Vertical Market,

Core/Advanced Technology

Top 20 Customers.

The Application is a typical data mart application. Sales Data Mart implementation is done using Oracle PL/SQL. No third party ETL Tool is used.

Main Components of the Application are:

Staging-: Source data is extracted and stored in the format which can be used further for MBR reporting needs. Dimensions and Facts are populated.

Aggregation & Summarization-: The Fact data is joined with different dimensions and rolled up to different hierarchy levels depending on the type of reports to be delivered based on the different users roles and their securities.

Environment: Oracle 10g, Java, Toad,DBMS profilers, Dollar Universe, Siebel Analytics, Unix.

‘Got Outstanding performance Award for the application tuning and reusable component which help client in reducing recurring cost and automate the year end manual work.

Client: Blue Dart express LTD May- 2004 –Nov-2004

Employer :- Seeinfobiz Limited.

Project: Dataware House for Bluedart.

Database Developer

Bluedart express limited is a leading courier company in India.SEEinfobiz awarded the project to be build

Data ware house for its sales systems.

Environment: Oracle 10g, PL-SQL Developer, Actuate reporting tool.

Responsibilities

I am purely worked on technical side. I had developed the PL-SQL package for the data extraction.

I had also involved in Report development using Actuate and training blue dart staff on Actuate.

Client: DIL Ltd, Boots Primal Ltd. May- 2003 –April-2004

Employer :- Coincap Systems and Services pvt. Limited.

Project: ERP Software.

Database Developer

I had involved in developing the complex report like Item movement ledger report, Form-6, Form-5

Report required for the company, Gross to Gross reconciliation report in the manufacturing company.

Environment: Oracle 9i, Toad, Visual Basic 6.0,MSFlex Grid.

Responsibilities

I worked purely on technical side. I had developed the PL-SQL package.

I had done coding in Visual Basic 6.0 to support the ERP’s screen.

Develop Form-5, Form 6 in Visual Basic 6.0 and oracle 8.0.

Client: Pune Gymkhana, Jwel Goldie gems and jewellery Ltd August- 2002 –April-2003

Employer: - Prism cybersoft Limited.

Project: Biometric finger print access system.

Database Developer

This project is replaced the exiting swap card for employee which can be grossly misused. This project is link with the attendance systems and payroll. I had developed the Visual Basic program interface with the biometric equipment. Report for the attendance in Visual Basic 6.0 and Crystal report. I had implemented the same projects at different client side as per their need.

Environment: Oracle 9i, Toad, Visual Basic 6.0.

Responsibilities

I had done coding in Visual Basic 6.0 to support the biometric finger print attendance system.

I worked purely on technical side. I had developed the PL-SQL package.

Created the Data model for Finger print attendance system.

Education

Bachelor of Engineering in Computer Engineering, Mumbai University, India.

Contact this candidate