Posts

Interview Questions - How To Be Prepared

Image
  When you have to compete in an economy that is tough and with more skilled people than jobs you need more than just technical skills to get through an interview. That means you need to be prepared for every curved ball that the interviewer is going to throw at you as well as create an experience unique that he/she remembers.  First think of some personal stories that help the job. Stories are vitally important they are memorable. Good stories fit many molds, which means you can use your stories even if the interviewer asks a question that you aren't prepared to answer. Good stories help because there are often many lessons hidden within one story. The pieces that stick with the interviewer will make an impact on them even if we didn't plan it that way. Take some time to think through the past and develop some solid stories that shed light on your abilities, accomplishments, and values. With that in mind, here are seven difficult interview questions and a few tips on how to...

Web Portal Governance

Image
More companies are going global and there is a need to manage global websites customized to local markets at their headquarters.The product catalogs are defined for each market/country and based on that I have created the model below. The product catalogs will be managed by the local markets but the content and layouts will be managed globally by the web master.   Web Master Responsibilities > Ability to work effectively with the client's director of web and new media to perform the required technical maintenance and administrative functions, including ensuring up-to-date content and information. Monitor, improve, and update the performance of existing websites. Assure website is easy to navigate and that it addresses the needs of the client and its customers. Competency in writing HTML. Stay current with changing Web technical standards. Strong design skills for electronic media including web and multimedia. Design and implement web strategies for product visibility and dr...

ATG Design Review Guidelines

Design Review Checklist Analyze FRD and understand the business needs Map the solution approach with the FRD Create or validate the traceability matrix between the FRD and Design document Map the requirements with the OOTB functionalities in ATG Ensure that the customizations follow the similar design patterns as ATG framework Validate the flow end to end covered in ATG Check for Sequence diagrams Verify the interfaces and classes which require to be over ridden or extended Validate the data model against the logical model and ensure it is similar to ATG data model where appropriate Validate the logical pseudo code for each method with the FRD flows Ensure LLD is developer ready

ATG Repository Exception | ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

While working with the ACC I received this error while trying to add Products. 2010-04-30 18:00:45,079 ERROR [nucleusNamespace.atg.devtools.DevSessionManager._1.atg.devtools.RepositoryAgent] CAUGHT AT:CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE at atg.adapter.gsa.GSAItemDescriptor.addItem(GSAItemDescriptor.java:6400) To resolve this error I have done the following: 1. Find out the table that is causing this error. In my case it was DCS_PRODUCT table and index that is causing this error was IDX_DCS_PRODUCT 2. Log into Oracle with the DBA user SQL>Connect ATG_DBA/ATG_DBA; 3. Get the DDL for the Index before dropping the same SQL> Select dbms_metadata.get_ddl('INDEX','IDX_DCS_PRODUCT','ATG_DBA') from dual; 4. Drop index that is causing the error SQL> drop index IDX_DCS_PRODUCT; Index dropped. 5. Create that index again using the following statement SQL> CREATE INDE...

ATG 9.1 Supported Environments

Please go to the following link to understand the environments supported by ATG9.1 http://www.atg.com/repositories/ContentCatalogRepository_en/supported_envs/atg_91.htm I am currently working on a installation guidelines for the ATG9.1 for Windows7 OS, will post instructions next week.

Software Testing Estimation eCommerce Projects

Image
There are many ways to estimate and goal should be to stay in the 10-20% range of the actual effort needed to validate the accuracy of the system being built. Software estimation is inherently non-trivial. The resulting product is virtually invisible until it is finished and we rarely end up with the same product that we initially estimated. Most of the estimates are based on the early requirements that are planned for the release or product roadmap and this can impact our estimation since effort estimated is different from actual effort when the test cycle starts. Estimation process can be challenging where we have limited knowledge about the application/product organization ecosystem which we plan to test mostly for a new client, domain or product.  With many years of experience these are some set of guidelines which have been very helpful in the estimation process and want to share in my blog. The goal that I have always set was to come in about 15-20% ball park of the actual e...

Agile Offshoring

Agile by concept is co-locating all the three legs of the IT organization the business, IT and QA. However with more and more organizations doing offshoring to optimize cost and getting the best talent across the globe it has become a challenging transition from traditional enterprise development processes into an Agile methodology along with geographically split teams with various time zones. Traditional approaches to offshore development are based on plan-driven methodologies and doing agile is definitely challenging. Because agile development works best with close communication and an open culture, agilists working offshore feel the pain much more than those using plan-driven approaches. Locations We have implemented Agile Offshoring for both development and QA teams spread across Reston(VA), Kansas(KS), Bangalore (India) and Gurgaon (India) for a major communication client. Methodology We follow SCRUM Agile process with two week sprints and a production release atleast after two sp...