Business Analyst/QA
Resume:
Baji Shaik Correspondence Address :
PAN Details.: BHCPS1103G # 19/1 17 ‘F’ Cross, 16 Main
Email: *********.**@*****.*** BTM II Stage, Bangalore-560076.
Mobile No: 096********.
Summary:
Having 3.6 years of total professional experience in providing DW / ETL Testing in Retail, Betting & Healthcare domain for Data warehousing.
Currently working with Capgemini India Pvt Ltd., Bangalore.
Good Knowledge of Ab Initio & Cognos Data Manager.
Proficient in using Oracle PL/SQL and Teradata.
Written Various test cases for data validations such as derived level, constants, Audit columns, Data integrity check and Rejection validation.
Proficient in using Ab Initio, Executing graphs using both Ab Initio GDE and Unix.
Proficient in using Cognos Data Manager, for running workflows on QA side.
Experience in Testing of various data sources like Oracle, Mainframe and Flat Files.
Good understanding of Data warehousing concepts, Star schema, and Snow-flake schema, Data Marts, ODS, Dimension and Fact tables.
Detail understanding of Data Warehouse concepts and Data Warehousing Architecture.
A good team player and having good logical and analytical ability
Education:
Passed Bachelor of Technology in E.C.E from J.N.T.U Hyderabad, AP in 2008.
Technical Skills:
Programming Languages : PL/SQL, Unix
Database Technologies : Oracle 9i. 10g,11g, Teradata
Operating Systems used : Windows, Unix(Solaris)
Products & Tools : Ab Initio & Cognos Data Manager
Business Domains : Retail, Betting & Health Care
Defect Tracking Tool : HP QC, Rally.
Significant Projects:
1. Unilever Connect- S&SI
Client : Unilever UK
Duration : 08 Feb 2011 to till now.
Technology used in project : SAP, PL/SQL, Teradata, Ultra Edit, HP QC.
Description :
The Supplier Intelligence solution aims to build an internal repository of information on Unilever’s current (and prospective) supplier base, along with reporting functionality to enable consistent and dynamic access to this information across the various procurement teams including their directors, R&D functions in Unilever.
The Supplier Intelligence portal is logically divided into two:
Supplier Dashboard, Supplier Profiles
The Supplier Profiles section in turn contains the following:
General Supplier Information, Financial - Key Measures, Financial - Risk Management, Strategy, Operations, Projects, Regulatory, View Passport Information (sensitive & non-sensitive), Generate Passport (sensitive & non-sensitive)
Roles & Responsibilities :
• Understanding the requirements and mapping documents
• Developing test cases for ETL and BI Reports based on the functional and technical requirements
• Test case execution for system testing of the ETL
• Scripting SQL queries for testing the reconciliation
• Capturing defects and tracking them to closure using HP Quality Centre
• Validating Semantic Layers with EDW Target tables.
2. BIM (Betfair Information Management)
Client : Betfair UK
Duration : March 2010 to Jan 2011.
Technology used in project : Ab Initio, Oracle, Unix, HP QC, Rally, Ops-Console
Description :
Betfair is the world’s biggest betting community. Which deals with different modes of betting. Online betting related information and customers details will be captured and processed through ETL for business decision making. Data from landing will be processed as per business requirement and loaded into data stores.
Landing sources (Gamex & Sportex) are the replica of Base source data, which is processed and loaded in to respective data stores such as ADS,MDS, BDS,CDS,HDS and TDS using Ab Initio. MDS contains all Master tables, BDS contains Business transactional data, CDS contains current data and HDS contains Historical data, and TDS contains complete transactional data, which are archived in ICFF files.(Compressed Flat Files)
Roles & Responsibilities :
• Managing deliverables and guiding the team on technical issues.
• Actively involved in understanding functionalities, design and implementation.
• Participating in peer-review process for the quality of deliverables.
• Tested generic frame works for loading fact & dimension tables using Psets in Unix Environment.
• Test planning and status reporting.
• Review high level business requirements, technical specifications, data mapping documents and create detailed test cases.
• Execute ETL graphs created by the development team on Ab Initio GDE for testing graphs.
• Validate data both on flat files and Oracle database.
• Worked with development team to track and retest reported defects.
• Support business users with UAT activities including coordination and defect reporting.
3. Finance & Accounting Services Europe (FASE)
Client : J&J (Medical Devices and Diagnosis) EMEA Europe
Duration : July 2008 to Feb 2010.
Technology used in project : IBM Cognos Data Manager, Oracle ,HP QC
Description:
Finance & Accounting Services Europe (FASE) is a data warehouse project. It involves the loading of the data into BDS (Business Data Store) which provides sales and financial reports across MD&D (Medical Devices and Diagnosis) EMEA Europe, the Middle East and Africa).
BDS is used to supply data to a variety of systems like BROADWAY it is a cognos application, SYSTEM INTERFACES - Sales and associated dimensional hierarchies and supplies. The scope of project is loading the data from different sources like ‘GMED ‘ ERP system, BRAVO, SAPBI, Franchise Data warehouses, GHX (Third Party Sales, whereby when J&J have sold to distributors) into BDS. The process of loading data into BDS involves 6 major areas those are Staging area - Data from various source systems are loaded temporarily, so it can be ‘Cleaned’ or merged with other data sources to provide to the next stage.
Kalido Loading Area-This is an area where data that is needed for kalido is processed and where errors in loading data into Kalido (for data validation issues) is stored.
Transdata - This is where the persistent, normalized and de-normalized copies of the data is stored.
KALIDO_OUT-This is where tables and views are stored to allow other outbound franchise systems to connect and pull specific data for their system
Data marts - This is a collection of star schemas purpose built for use by BROADWAY application.
Configuration - This is a collection of tables that allow control of the ETL configuration of programs in a soft-coded manner.
Roles & Responsibilities :
Test planning and status reporting.
Review high level business requirements, technical specifications, FRS documents and create detailed test scripts in QC.
Work with development team to track and retest reported defects.
Support business users with UAT activities including coordination and defect reporting.
Personal Profile :
Name : Baji Shaik
Organisation : Capgemini India Pvt Ltd.
Designation : Consultant
Birth Date : 29-01-1986
Residence : Bangalore, India
Nationality : Indian
Marital Status : Married.
Gender : Male
Languages Known : English, Urdu, Telugu.
Passport Details
Number : G2846724
Issuing Date : 04-04-2007
Valid up to Date : 03-04-2017
Country : India
Career Aim :
To achieve excellence in working as dynamic professional offering solutions to business using the best available where my analytical ability and analyzing quest are used maximum for growth of the organization and to grow with the organization. Seeking a challenging position in well established company that offers professional growth and ample opportunity to learn and enrich my competencies in my profession.
Contact this candidate