Filters
Apply

Filter By:

Author

Types of Articles

Entity

Search results:

blog tag Database
1-10 of 89 results

Embracing Open Source Databases

According to Gartner, the five leading commercial relational database vendors by revenue in 2011 were Oracle(48.8%), IBM (20.2%), Microsoft (17.0%), SAP including Sybase (4.6%), and Teradata (3.7%). The high cost and vendor restrictions that come with traditional relational database vendors like Oracle are driving away end users. Open source and open-source-based relational databases have matured.

Venkatesh Sarvepalli

  • Proficiency in Java, J2EE and extensive experience in developing various web-based applications using Hibernate 3.0 and Spring 4.0 frameworks.
  • Extensive experience in developing web-based applications using Spring Boot.
  • Good working knowledge of CRUD Repository Spring Data JPA and create Entity relations.
  • Good working experience in Thymeleaf which is using in the Presentation layer.
  • Good working experience in Spring with Thymeleaf integration.
  • Good Knowledge in develops the web application with Spring MVC annotations.
  • Good working experience with IntelliJ & Eclipse IDE.
  • Experience with WEB 2.0 technologies like HTML 5, CSS 3 and Twitter Bootstrap (Responsive web design).
  • Good working experience in JAVASCRIPT, jQuery, and AJAX.
  • Good working experience with jQuery plug-ins (Drop Zone, Date Picker, Image Gallery, social share, Blog etc.) and can customize them.
  • Having good experience with Apache Solr.
  • Having Database Programming skills SQL, PL/SQL and POSTGRESQL.
  • Good Knowledge on SDLC and STLC and Manual Testing.

How to Structure Content Using HTML5 Semantic Tags

Dinanath Jayaswal

The article provides an overview of the latest meaningful HTML 5 semantic tags like header, section, footer, article, aside, nav, and accessibility WAI-ARIA. Use of these semantic tags can modernize your web pages and significantly improve search engines interactions.

Abhishek Vinjamuri

4 +Years of US IT Recruiting Experience, and worked for finding correct match for the Top-Notch US Clients.

Experience working directly with clients like HCL America, NTT DATA, Sapient, DibsysInc, Global Logic and State of New York/New Jersey,National Grid,symbotic,EF Education,Deloitte,Vitamin Shopee,Star Wood..Etc.

Experience working directly and Interacting with client managers and recruiters.

Experience in handling a team of 6 members.

Possess a good skill set of excellent Full recruitment process and communication

Expertise in resume sourcing and screening, and reference.

Adept at interacting with the Clients and consultants on various issues.

Achievement of the task as per the day schedule.

Good organizing and coordination skills coupled with good interpersonal and communication skills.

 

Worked on the following Requirements: 

 

ETL : Informatica, Ascential Data stage, Data Ware House Architect 

Database : Oracle, SQL, DB2, and Sybase

Microsoft Technologies : VB, ASP, HTML, Dot Net, Windows Mobile, Smart Phones, WCF, WPF 

Quality Assurance : Mercury, Silk, Test Director and Load Runner 

Business Intelligence : Cognos, BizTalk Server

Client/Server : Java/J2ee, Servlets, JSP, RMI, JDBC, Web logic, Web Developers

OOPS Technology : C/C++, Java 

CRM : Siebel, SAP, Oracle

Languages : Java, C++, C, PHP, and Perl

Job Boards Used : Dice, Techfetch, Monster & Carrer builder

 

SOURCING TOOLS

 

Advanced search techniques using -LinkedIn, Recruiting blogs, Technology Groups in google, Job Boards: Dice.com, Careerbuilder, Monster ,Techfetch.

Latest <em>Blogs</em>

Latest Blogs

Accion Innovation Center provides access to industry best practices that we have implemented over the years in solving real-world business-technology problems for our customers. Learn how we helped solve problems by leveraging unique techniques and strategies to achieve digital transformation.

Avinand Reddy Dandu

Current Profile:

 

  • I have around 5.9 years of experience in IT industry, currently working with Accion Labs India pvt ltd from 21sept 2016 to till date.

Experience:

 

  • Worked as Software engineer in Syntel India Pvt ltd, Chennai from June 2011 to January 2013.
  • Worked as Senior consultant in Capgemini India Pvt Ltd, Bangalore from January 2013 to 19th September 2016. 

Summary:

  • I have around 5.9 years of Professional experience in ETL Testing and I am ISTQB certified with foundation level.
  • Having Hands on experience in Hive Queries in Hadoop cluster. 

§    Having good knowledge on Extraction, Transformation, and Loading process (ETL) of the Enterprise Data warehouse.

  • Have a good experience in testing mappings with test plan strategies while following baseline test cases.
  • I have full knowledge of Defect Life Cycle/Testing Process & SDLC. I have experience in requirement gathering, test case development, test case execution, test data creation, defect management and status reporting
  • Hands on experience in testing Facts and Dimensional tables based on business logic.
  • Have Good knowledge in SAP BW and ECC Source Systems.
  • Good experience in testing data warehouse and data marts for business analysis.
  • Good Knowledge in analysing business of the customer as Business data quality member.
  • Extensive knowledge on Data Warehousing concepts.
  • Having good knowledge on database testing.
  • Having Much Experience in analysing the Business and Validating the Data related to the Business Scenarios for the application in both Functional and Non-Functional.
  • Experience on web application functional and system testing.
  • Hands on experience in writing database queries.
  • Has testing experience in Informatica.
  • Having good knowledge on UNIX Environment.
  • Having good knowledge in code deployment from dev to QA as per implementation plan.
  • Running SSIS packages to load the data from source to target tables.
  • Having hands one experience in agile model.
  • Experience in preparation of test case documents.
  • Highly motivated professionals with integrity and commitment to quality and perfection.
  • Excellent analytical skills and innovative problem solving ability.
  • Good communication skills and inter personal skills.

Education Qualification

·         B. Tech (Computer Science & Engineering) from JNTU University, Hyderabad 2008.

 

TECHNICAL SKILLS

Testing                                : Data warehouse – ETL testing, Web app testing

Operating Systems              : Windows 95/98/2000, UNIX

Languages                           : C, C++

Web Technologies               : Java, .NET

databases                            : Oracle, SQL Server2005, Teradata

ETL Tools                            : Informatica, Datastage,BODS

Management Tool               : Quality Centre

Project#1          : Allegis DMS Foundation

Client               : Allegis Group Services

Technologies   : Informatica 9.1

database          : Oracle 11i and People Soft DB

Role                 : Senior ETL Tester

 

Project Description: DMS is Data management system where I am playing a role of DWH/ETL Tester. Team will handle the CR (change request) coming from client on weekly basis and Incident resolution.

 

Responsibilities:

·         Part of a team consisting of 3 testers that were responsible for testing CR (Change request) and incident resolutions on weekly basis. Every Thursday prod migrations are performed.

·         Co-ordinate with business analyst and data modelling team to understand and analyzing the requirements from requirements document.

·         Design and review test scenarios based on functional requirements and execute test cases through HP ALM 11.0

·         Prepare test data for delta validation in target tables by insert/update queries to verify the delta logic in target tables from stage tables.

·         Prepared SQL queries and executed to validate the ETL processed data in target tables according to business rules.

·         Raised migration request from Dev to Test and Running the Informatica workflows in test Environment for data load.

·         Participate in defect triage meetings with Business Analysts and developers to resolve issues and defects.

·         Provide daily testing status report to project managers and business stakeholders.

 

Project#2          :  ESRA-AAR (Enhanced Sales and Reporting)

Client               :  Unilever (UK)

Technologies   : BODS (Business object Data services)

database          : Oracle, Teradata

Role                 : Senior ETL Tester

 

Project Description: Unilever is fast moving Consumer Goods seller across the Globe in multiple countries. Here the Project is ESRA-AAR which is Enhanced Sales& Reporting and the application is AAR where which is ASIA AFRICA& RUBEE countries data is going to be picked up for the Report presentation.

Here two type data is handling i.e.

Ø  Primary Sales Data

Ø  Secondary Sales Data

Above mentioned data is coming from Customers to Distributors and from Distributors to the Company and these data is useful to reports to analyse the sales happened at outlet level and distributor level in each city and country wise like AUSTRALIA, ARAB and GULF and many more country information will be collected to generate reports for Primary and Secondary Sales Analysis. 

 

Responsibilities:

·         Understanding the client requirements.

·         Designed High level test scenarios for given test cases.

·         Executed test cases through Quality Centre.

·         Validated data in Target database according to business rules.

·         Prepared SQL queries and executed to validate the ETL processed data in target database.

·         Prepared the Test data for Delta Validation in target tables by insert/update queries

·         Involved in functional study of the application.

·         Verifying the ETL data in target database.

·         Interactions with BA & Dev teams to resolve the issues.

·         Reporting daily testing status report.

·         Attending defect triage meetings

·         Defect Analysing and Reporting in QC.

 

Project#3          : Taleo-TMDW (Talent Profile Management Data warehouse)

Client               : Target India Corporation

Technologies   : Data stage, UNIX

database          : DB2, Teradata

Role                 : Business Data Quality Tester (BDQ)

 

Project Description: Taleo is the Talent Acquisition & Management System. TMDW Taleo TPM program is design to provide a robust, efficient and stable platform that meets the strategic and analytical needs of Business Partners in terms of Talent Management in Target.

 

Ø  Design an integrated Data Structure which could be combined with the existing data model like Team Member Data etc. in the new EDW Teradata environment.

Ø  Capture information required from the Source Taleo System to enable the HR Business capability- Talent Management.

Ø  Provide data attributes in the EDW Teradata Foundation to enable HR Talent Management Analytics for the Business partners.

Responsibilities:

·         Understanding the client requirements.

·         Designed High level test scenarios for given test cases.

·         Involved in Exporting the Test Cases to QC.

·         Executed test cases through Quality Centre.

·         Validated data in Target database according to business rules.

·         Prepared SQL queries and executed to validate the ETL processed data in target database.

·         Involved in functional and study of the application.

·         Validated NFR as per NFR document for Foundation tables in Teradata.

·         Verifying the ETL data in target database.

·         Prepared Mock-up Test Data for Incremental Data Load Validation in cycle-2.

·         Interactions with BA & Dev. teams to resolve the issues.

·         Reporting daily testing status report.

·         Attending defect triage meetings on weekly basis for defect status.

·         Defect Analysing and Extracting Daily Defect Reporting from QC.

 

Project#4          : EGP (Enterprise Guest Program)

Client               : Target India Corporation

Technologies   : Data stage, UNIX, Unica

database          : DB2, Teradata

Role                 : Business Data Quality Tester

 

Project Description: EGP (Enterprise Guest Program), Target is Retailer Domain.

Currently Target Corporation which has many Retail Stores in US, Canada has ADW (Analytical Data warehouse) in DB2. As ADW is going to be Sunset in coming days so target is making EGP to migrate ADW to EDW (Enterprise Data warehouse) to Teradata. With help of EGP target all the subject areas in ADW are going to be Re-Built in Teradata. The subject areas are like

Ø  Gift Registry

Ø  Emnos

Ø  Campaign

Ø  Web-Experience

Ø  Paid Search.

The above mentioned are few subject areas in ADW.

 

Responsibilities:

·         Understanding the client requirements.

·         Designed High level test scenarios for given test cases.

·         Executed test cases through Quality Center.

·         Validated data in Target database according to business rules.

·         Prepared SQL queries and executed to validate the ETL processed data in target database.

·         Involved in functional study of the application.

·         Verifying the ETL data in target database.

·         Interactions with BA & Dev teams to resolve the issues.

·         Reporting daily testing status report.

·         Attending defect triage meetings

·         Defect Analyzing and Reporting in QC.

  

Project#5          :  Omniture Aggregates

 Client               :  THD (The Home Depot)

Technologies   : Hadoop, Hive

database          : Hadoop, HQL

Role                 : Tester

 

Project Description:  Omniture aggregates are of 2 levels – Low level aggregates and High level aggregates. High level aggregates are obtained of Low level aggregates based on business rules. This data will be used for Customer online analytics and Marketing campaigns. The raw data obtained from Omniture feed is normalized, parsed out and formulated based on business rules to get the aggregates. These activities are done using HIVE query and Hadoop (MP programs) technologies.

 

Responsibilities:

 ·         Involved in functional study of the application

·         Involved in the Preparation of Test Plan Document.

·         Prepared and ran HQL queries to verify data loaded to the target tables to have correct computed values.

·         Verified the Aggregated data loaded into the Target tables.

·         Executed the Test cases in QC and prepared the Test data.

 

Project#6          :  Golden Records

Client               :  THD (The Home Depot)

Technologies   : Hadoop, Hive

database          : Hadoop, HQL

Role                 : Tester

 

Project Description :Golden Record is the Enterprise Customer Record (ECR)which is consolidated and integrated profile of customer data captured from multiple points of engagement and 3rd party data. This project is going to use technologies Hadoop, Cassandra, and Restful web services. This document describes the high level design for Hadoop where customer data lands and goes through business rules, undergoes Dedup/Merge/Decouple processes and at the end forms Golden Record. The Golden Record data is then made available for Cassandra to consume, to which store application lookup/insert/update services points.

 

 

Responsibilities:

  • Involved in Studying and understanding the SDS and Functional requirement document.
  • Involved in the Estimation Preparation doc and Test plan preparation document.
  • Involved in designing the High level and Low Level Test cases based on mapping document.
  • Involved in the Exporting the Test cases into the QC.
  • Involved in writing the Hive Queries for Verifying ETL data in the Hadoop database and Test data preparation.
  • Executed the Test cases and found the defects.
  • Documented the Test reports and attended the defect issue status meetings.

 

Project#7          :  Margin Control

Client               :  DTNA (Daimler Trucks of North America)

Technologies   : Informatica Power Center

database          : DB2

Role                 : Tester

 

Project Description: Margin control is the project in which we are able to find out the estimated cost of the manufacturing trucks by the Daimler Trucks of North American company. Margin controlling project will help the business to analyse the cost for manufacturing trucks and cost can be controlled by reducing the raw materials purchasing cost. Margin controlling application is able to find out where the exact cost of the trucks manufactured has been increasing.  

 

Responsibilities:

·         Involved in functional study of the application

·         Running the jobs(work flows) for ETL process

·         Prepared and ran SQL queries to verify DIMENSIONAL and FACT tables to have correct computed values.

·         Verifying the ETL data in target database

·         Data Mapping

·         Prepared test data

·         Verifying the data which is loaded into target database

·         Interactions with BA & Dev teams to resolve the issues.

·         Reporting daily  testing status report

·         Developed, Reviewed & Executed Test Scripts and Designed test data

·         Identified Test Scripts for Regression testing

·         Defect Analysing and Reporting in QC

  

Project#8          :  Encompass R&A(Reporting and Analysis)

Client               : Allstate, USA

Technologies   : Informatica Power Center

database          : Oracle10g

Role                 : Tester

 

 

Project Description: Encompass is Insurance Company in U.S which is acquired By the Allstate Insurance Company. Allstate want his own DWH to be build. So Encompass R&A is Reporting and Analysis project by

Which the company can easily get the reporting and can do analysis’ on his Insurance .Currently the project is

 Going to be design Release 1A.

          In Release 1A the Agency Data Mart is going to be designed. The Sources for this Project are INTERLINK

TRITON and IAEDW.

 

 

Responsibilities:

·         Involved in functional study of the application

·         Running the jobs (work flows) for ETL process

·         Prepared and ran SQL queries to verify DIMENSIONAL and FACT tables to have correct computed values.

·         Verifying the ETL data in target database

·         Data Mapping

·         Prepared test data

·         Verifying the data which is loaded into target database

·         Interactions with BA & Dev teams to resolve the issues.

·         Reporting daily testing status report

·         Developed, Reviewed & Executed Test Scripts and Designed test data

·         Identified Test Scripts for Regression testing

Defect Analysing and Reporting in QC 

Siva Nomula

 

Experienced in developing web applications using Asp.Net MVC, C#, Web Api, .Net Core Javascript, jQuery, Angular5, HTML/CSS and build tools.

Expertise in SQL, MySQL and Oracle Databases. Worked on NoSQL Databases Like Mongo DB

Experience in developing product using Test Driven Development technique.

Extensively followed Agile Methodology and Scrum process for iterative planing, development and delivery techniques.

System design and development, Continues Delivery (CD) using MVC patterns with design patterns, code review.

Capabilities: 

C#, ASP.Net Web Forms, ASP.Net MVC, .Net Core

Web Api, Web Services, Windows Services, WCF,  Entity Framework, LINQ 

Javascript, jQuery, AngularJs, HTML, CSS, Grunt

Unit Test Fixtures: nUnit, Jasmine javascript tests, SoapUI web service tests

Agile and Scrum practices, used TFS & JIRA.

Certifications:

MCSD: Web Applications.

MongoDB : M101N: MongoDB for .NET Developers

 

 

TA Associates backs tech enablement sTArt-up

Accion Labs, a US-headquartered sTArt-up with Asian operations that helps companies implement emerging technologies, has received a strategic growth investment by TA Associates.

Allan Tay

By clicking “Accept all cookies,” you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Privacy policy

Contact Us